A couple of song recommendations that are about death, that I really like:
My Dying Bride - For My Fallen Angel
Anathema - One Last Goodbye
Both very sad. Read the lyrics as well.
However, if you want some of the most sad and emotional music, but not really about death, then check out Empyrium. I'd second the Agalloch recommendation too.