In Bluegrass, it's more or less the rule. There's more or less a whole category of songs, often called "Katie-and-Willies." (Watch it, you Brits! Keep it clean!)

When we do "Long Black Veil," we explain carefully that the song is NOT bluegrass, because the female protagonist is still alive at the end.

Peter