Skip to content

NTSB investigations, 2019, Outside the U.S.

24 cases where the sequence of events included Loss of engine power (total).

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 year(c."eventDate") = 2019 AND c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '341' 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 year(c.\"eventDate\") = 2019
    AND c.\"eventCountry\" <> 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '341' 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 year(c."eventDate") = 2019
  AND c."eventCountry" <> 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '341' 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 ERA20WA067Accident · No injuriesForeign investigationCessna 560 · Cmte Nicanor Otamendi, ArgentinaThe government of Argentina has notified the NTSB of an accident involving a CESSNA 560XLS airplane that occurred on December 28, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the…Dec 28, 2019 · LV-FQD · Substantial damage NTSB CEN20WA126Accident · No injuriesForeign investigationCessna 152 · San Salvador, El SalvadorOn December 27, 2019, about 0730 local time, a Cessna 152 airplane, YS-162PE, impacted terrain near San Salvador, El Salvador, and was destroyed. The two occupants were not injured. The accident investigation is under the jurisdiction and control of the…Dec 27, 2019 · YS-162PE · Destroyed NTSB WPR20WA020Incident · No injuriesForeign investigationCessna 172 · Vereeniging, South AfricaOn November 6, 2019, about 1740 coordinated universal time, a Cessna 172L, South African registration ZS-DAC, was enroute to the VOR beacon GAV, near Vereeniging, and reported a loss of engine power. The pilot forced landed the airplane in a field. The pilot…Nov 6, 2019 · ZS-DAC · No damage NTSB ERA20WA015Accident · Minor injuriesForeign investigationDouglas DC3C S1C3G · Nassau, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Douglas DC3C S1C3G airplane that occurred on October 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the…Oct 18, 2019 · N437GB · Substantial damage NTSB ENG19WA041Incident · No injuriesForeign investigationEmbraer ERJ190 · Buenos Aires, ArgentinaThe Junta de Investigación de Accidentes de Aviación Civil (JIAAC) República ARGENTINA has notified the NTSB of an incident involving an Embraer ERJ190, which occurred on September 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist…Sep 29, 2019 · LV-CIG · Minor damage NTSB GAA19WA589Accident · No injuriesForeign investigationCessna 172 · Baska, Krk Island, CroatiaThe government of Croatia has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on September 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Croatia's investigation under the…Sep 21, 2019 · 9A-DMG · Substantial damage NTSB ENG19WA032Incident · No injuriesForeign investigationAirbus A320 · Nassau, BahamasThe Air Accident Investigation Department (AAID) of the Bahamas has notified the NTSB of an incident involving an Airbus A320-212 that occurred on August 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB under the provisions…Aug 17, 2019 · N335NW · No damage NTSB CEN19WA341Accident · No injuriesForeign investigationCessna 150 · Ravna Gora, CroatiaThe government of Croatia has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on August 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Croatia's investigation under the provisions…Aug 17, 2019 · 9A-DMI · No damage NTSB CEN19WA272Incident · No injuriesForeign investigationReims Aviation Cessna F172N · Lesnovo, BulgariaOn August 14, 2018, about 0750 coordinated universal time, a Reims Aviation Cessna F172N airplane, Bulgarian registration number LZ-SPB, had a forced landing at the Lesnovo Airport (LBLS), Lesnovo, Bulgaria, following an inflight loss of engine power. The…Aug 14, 2019 · LZ-SPB · No damage NTSB DCA19WA197Incident · No injuriesForeign investigationBoeing 787 · Rome, ItalyThe government of Italy has notified the NTSB of an incident involving a BOEING 787 airplane that occurred on August 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…Aug 10, 2019 · LN-LND · Minor damage NTSB GAA19WA573Accident · Serious injuriesForeign investigationBeech 36 · Corse-du-Sud, FranceThe government of France has notified the NTSB of an accident involving a BEECH 36 airplane that occurred on August 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…Aug 9, 2019 · OO-JBM · Destroyed NTSB ERA19WA242Accident · No injuriesForeign investigationPiper PA34 · Bimini, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA34 airplane that occurred on August 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…Aug 8, 2019 · N40702 · Substantial damage NTSB WPR19WA203Accident · No injuriesForeign investigationRIchards Heavylift UH-1H · Limpopo Province, South AfricaOn July 23, 2019, about 1107 coordinated universal time, a Richards Heavylift Helo Inc., UH-1H, South African registration ZS-HLJ, operated for fire fighting, and equipped with a Textron Lycoming T-53 engine, reported a loss of engine power near Woodbush…Jul 23, 2019 · ZS-HLJ · Substantial damage NTSB CEN19WA201Accident · Serious injuriesForeign investigationPiper PA28R · Pointe-A-Pitre, GuadeloupeJun 19, 2019 · F-ODSM · Destroyed NTSB GAA21WA067AccidentClass 5 · ForeignCessna 172 · Keti Bandar, PakistanMay 31, 2019 · AP-BAJ · Substantial damage NTSB GAA19WA274Accident · 1 fatalForeign investigationCessna T210 · Atizapán de Zaragoza, Mexico (jjc airport), MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA T210 airplane that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…May 3, 2019 · XB-OWS · Substantial damage NTSB ENG19WA022Accident · No injuriesForeign investigationBell 222 · Addis Ababa, EthiopiaOn April 26, 2019, a Trans Nation Airways, PLC, Bell 222UT helicopter, registered in Ethiopia as ET-AVF crashed near the Addis Ababa Bole International Airport, Addis Ababa, Ethiopia after both engines, Honeywell LTS101-750 turboshafts, lost power. The…Apr 26, 2019 · ET--AVF · Substantial damage NTSB CEN19WA118Accident · Serious injuriesForeign investigationRobinson R44 · Stavnes, NorwayThe government of Norway has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on March 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…Mar 23, 2019 · LN-OGF · Substantial damage NTSB ERA19WA128Accident · 2 fatalForeign investigationCessna T182 · Jacareacanga County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna T182 airplane that occurred on February 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…Feb 23, 2019 · PR-ENM · Substantial damage NTSB ERA19WA127Accident · 1 fatalForeign investigationCessna 210 · Belém City, State of Pará, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on February 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…Feb 13, 2019 · PT-JIC · Substantial damage NTSB WPR19WA149Accident · No injuriesForeign investigationPitts S2 · Kliprivier, South AfricaThe government of South Africa has notified the NTSB of an accident involving a Pitts S2 airplane that occurred on January 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…Jan 29, 2019 · ZS-OOB · Substantial damage NTSB ERA19WA103Incident · No injuriesForeign investigationBritten Norman BN2B · Esmeraldas, EcuadorThe government of Ecuador has notified the NTSB of an incident involving a Britten Norman BN2B airplane that occurred on January 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the…Jan 25, 2019 · N203PR · No damage NTSB WPR19WA059Accident · No injuriesForeign investigationCessna 182 · Tooradin, AustraliaOn January 6, 2019, at 1045 local time, a Cessna 182G, VH-DGF, collided with trees following a loss of engine power during the initial climb near Tooradin, Australia. The pilot and four passengers were not injured. The airplane was substantially damaged. The…Jan 6, 2019 · VH-DGF · Substantial damage NTSB ERA19WA088Accident · 1 fatalForeign investigationRobinson R44 · Ubatuba, BrazilThe government of Brazil has notified the NTSB of an accident involving a Robinson R44 II that occurred on January 1, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…Jan 1, 2019 · PR-RMZ · Substantial damage