"Mad Man Moon" by Genesis. Or, maybe "Open Door" by the same. Both talk about death from the perspective of the person dying, though the former veils its message rather well and it's a bit of a stretch to get that out of it.