It's probably not gonna happen. Miyamoto's policy is to treat storylines as just one of many equal (or even less than equal) elements of a game. Not to mention, Link is supposed to be representative of the player, so I doubt Miyamoto will let him die.
Maybe Zelda...or Tingle
