Mystery over World War II ship torpedoed by Nazi Germany finally solved