A major rescue operation was launched but police have confirmed a 50-year-old man has tragically died