Tragedy as police confirm missing man found dead