The search for a missing Royal Navy crew member has ended tragically after extensive efforts failed to locate him.