Saddest Death(s) - spoilers inside

[Trumpet Thief]

quite possibly the saddest moment in any game ever....the flute playing boy from Link to the past. that was the first time I ever really getting watery in my eyes from a game

I'd like to hear the story behind that, if you wouldn't mind.