He is a major character in A Ranger Lost, in which the Hunter Guardian is sent on a mission to Venus to search for him after he goes missing. His body was discovered in the Black Garden after he was separated from his Ghost on the other side of a Vex Gate on Venus and was overrun. Afterward, the Guardian received the Nightstalker subclass from Cayde's old friend.
"Doesn't matter how good you are—you stay out there too long, you're not coming back. Not the same way you left, anyway."