I'm always making lists. No reason.
I got to thinking about songs, in the first person, that are apparently written, and sung, at the point of death. Not the many songs by doomed people written in the hours before they're killed. There are hundreds of them including the "goodnight ballads" of the 19th century.

So then -- there's:
1. "Lights on the Hill" by Joy McKean.
It ends as the truck driver is going over the edge of a cliff.
2. "Boa Constrictor" and 3. "Twenty-five Minutes to Go" both by Shel Silverstein.
They end with "ooooo!" as the singer dies.

"Lights on the Hill" is also an impossible song (I've got a list of them) because there are no witnesses to the death. No mention of a recording device either. Unless the singer is a ghost this song can't exist.

Small list. Can anyone come up with any more "extreme goodnights"?
Cheers, Joy