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