The search for a missing Royal Navy crew member has come to an end following extensive efforts by multiple agencies.