I'm surprised I haven't seen "Cats In the Cradle" by Harry Chapin. The lyrics are too often so true...it made me sad when I was young - still does.
The Wreck of the Edmund Fitzgerald was another oldie that always brought a lump to my throat.
"Major Tom" was a real sad one.
Of the more modern ones, "Holes in the Floor of Heaven."