Skip to content

Fatal NTSB investigations, Outside the U.S.

26 cases where the sequence of events included Loss of engine power (partial).

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Latest cases

Query with SQL

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventCountry" <> 'USA' AND c."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"eventCountry\" <> 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventCountry" <> 'USA'
  AND c."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB GAA25WA219Accident · 2 fatalClass 5 · ForeignPiper PA31 · Deer Lake, CanadaJul 26, 2025 · C-GYYP · Substantial damage NTSB GAA24WA322Accident · 1 fatalClass 5 · ForeignWassmer WA54 · Chartres, FranceAug 13, 2024 · F-GAIB · Destroyed NTSB GAA24WA259Accident · 1 fatalClass 5 · ForeignCessna 182 · Provincia de Neuquén, ArgentinaAug 7, 2024 · LV-IHU · Substantial damage NTSB GAA24WA042Accident · 1 fatalClass 5 · ForeignBeech C23 · Bram Fischer International Airpor, South AfricaOct 21, 2023 · ZS-JKE · Substantial damage NTSB GAA23WA097Accident · 1 fatalClass 5 · ForeignCessna 310F · Puerto Vallarta, MexicoDec 27, 2022 · N541DW NTSB GAA23WA031Accident · 2 fatalClass 5 · ForeignRobinson R66 · Kesova Gora, RussiaNov 27, 2022 · RA- 07390 · Destroyed NTSB GAA22WA183Accident · 2 fatalClass 5 · ForeignCessna 208 · Boituva, BrazilMay 11, 2022 · PT-OQR · Substantial damage NTSB ERA20WA061Accident · 3 fatalForeign investigationPiper PA-32-301T · Vereda Cuzama, ColombiaThe government of Colombia has notified the NTSB of an accident involving a PIPER PA-32-301T airplane that occurred on December 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…Dec 30, 2019 · HK2629 · Substantial damage NTSB ERA19WA121Accident · 14 fatalForeign investigationDouglas DC3 · Vereda La Bendicion, ColombiaThe government of Colombia has notified the NTSB of an accident involving a DOUGLAS DC3 airplane that occurred on March 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions…Mar 9, 2019 · HK2494 · Destroyed NTSB CEN19WA079Accident · 1 fatalForeign investigationCessna 150 · Durango, MexicoJan 30, 2019 · XB-KEJ · Substantial damage NTSB CEN19WA012Accident · 2 fatalForeign investigationCessna 150M · La Paz, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 150M airplane that occurred on October 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…Oct 16, 2018 · XB-ODX NTSB ERA18WA061Accident · 1 fatalForeign investigationCessna A188 · Dom Pedrito, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on December 30, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…Dec 30, 2017 · PR-MLY · Substantial damage NTSB CEN17WA343Accident · 2 fatalForeign investigationPiper Piper PA-28RT-201 · Wolferton, United KingdomOn September 11, 2017, at 0956 universal coordinated time (UTC), a Piper PA-28RT-201 single-engine airplane, United Kingdom registration G-BHAY, serial number 28R-7918213, was substantially damaged during a forced landing following a loss of engine power and…Sep 11, 2017 · G-BHAY · Substantial damage NTSB ERA17WA080Accident · 6 fatalForeign investigationNeiva EMB-721D · Manaus, BrazilOn December 7, 2016, about 1150 UTC, an Industria Aeronautica Neiva S/A EMB 721D, Brazilian registration PT-REI, registered to and operated by a foreign individual, collided with trees then terrain shortly after takeoff. Visual meteorological conditions…Dec 7, 2016 · PT-REI · Destroyed NTSB CEN16WA340Accident · 1 fatalForeign investigationQuad City Challenger II · Amos, CanadaOn August 9, 2016, at 1530 UTC, a Quad City Challenger II (S/N CH2-0903-2368), C-IIJW, impacted terrain near the runway end at Amos/Magny Airport (CYEY), Amos, Quebec, Canada. The aircraft was destroyed and sole occupant on board was fatally injured. The…Aug 9, 2016 · C-IIJW · Destroyed NTSB DCA15RA059Accident · 43 fatalForeign investigationATR 72 · Taipei, TaiwanimportFeb 4, 2015 · B-22816 · Destroyed NTSB CEN14WA491Accident · 2 fatalForeign investigationRobinson Helicopter R44 · Roeselare, BelgiumSep 5, 2014 · N60JD · Destroyed NTSB ERA13WA203Accident · 2 fatalClass 5 · ForeignPiper PA-23-250 · Georgetown, GuyanaOn April 13, 2013, about 1854 coordinated universal time, a Piper PA-23-250, N27FT, was destroyed when it impacted a residence shortly after departing from Ogle International Airport (SYGO), Georgetown, Guyana. The certificated airline transport pilot and one…Apr 13, 2013 · N27FT · Destroyed NTSB DCA11WA008Accident · 21 fatalForeign investigationBeech 1900 · Karachi, PakistanOn November 5, 2010, a JS Air Pakistan, a Hawker Beechcraft B-1900, registration AP-BJD, crashed shortly after takeoff from Karachi-Jinnah International Airport (KHI), Karachi, Pakistan. All 17 passengers and 4 crewmembers onboard were fatally injured, and…Nov 5, 2010 · AP-BJD · Destroyed NTSB ERA11WA008Accident · 9 fatalForeign investigationCessna 402 · Nassau, BahamasOn October 5, 2010, about 1236 Atlantic standard time, a Cessna 402C, Bahamian registration C6-NLH, registered to and operated by Lebocruise Air Limited, crashed into Lake Killarney shortly after takeoff from the Lynden Pindling International Airport (MYNN),…Oct 5, 2010 · C6NLH · Substantial damage NTSB CEN10WA150Accident · 3 fatalForeign investigationCessna 421 · Tegucigalpa, HondurasThis investigation is under the jurisdiction and control of the Honduran government.Mar 10, 2010 · TG-JYM · Destroyed NTSB WPR10RA093Accident · 6 fatalClass 5 · ForeignCessna 185 · Baindoang, PNG, Papua New GuineaOn December 30, 2009, about 0618 UTC (coordinated universal time), a Papua New Guinea (PNG) registered Cessna 185E, P2-MJL, made a forced emergency landing on mountainous terrain following a loss of oil pressure, about 1 nautical mile southwest of a remote…Dec 30, 2009 · P2-MJL · Destroyed NTSB CEN09RA052Accident · 1 fatalForeign investigationBeech 200 · Punta Chivato, MexicoOn November 3, 2008 at approximately 1800 pacific standard time (PST) a twin-engine turbo prop, Beechcraft BE200, N200JL, was destroyed when it impacted terrain shortly after takeoff from Punta Chivato Airstrip, located near Punto Chivato, Baja California…Nov 4, 2008 · N200JL · Destroyed NTSB CEN09RA030Accident · 5 fatalForeign investigationCessna 310 · Ciudad Victoria, MexicoOn October 21, 2008 at approximately 1710 central daylight time a Cessna 310, Mexican Registration XB-KPF experienced a loss of power on takeoff from Pedro J. Mendez Airport, Ciudad Victoria, Tamaulipas, Mexico. The pilot attempted to return to the airport…Oct 21, 2008 · XB-KPF · Destroyed NTSB CEN09WA016Accident · 2 fatalForeign investigationCessna 421 · Oaxaca, MexicoOn October 6, 008 at approximately 1332 central daylight time (CDT) a Cessna 421C, Mexican Registration XB-KWB was destroyed while attempting to return to Xoxocotlan International Airport (OAX,) Oaxaca, Mexico to land . Both aircraft occupants sustained fatal…Oct 6, 2008 · XB-KWG · Destroyed NTSB DCA08RA078Accident · 2 fatalForeign investigationBoeing 747-200FM · Madrid, ColombiaOn July 7, 2008, at 0357 local time, a Boeing 747-200FM, N714CK, operated by Kalitta Air as Centurion Airlines flight 164, was destroyed during a forced landing in Madrid, Cundinamarca, Colombia, shortly after taking off from El Dorado International Airport…Jul 7, 2008 · N714CK · Destroyed