He is known for mysteriously disappearing while leading an expedition in search of the Northwest Passage, a waterway that connects the Atlantic and Pacific oceans in northern Canada