Skip to content

NTSB investigations, 2019, Outside the U.S.

20 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 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" = '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 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\" = '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 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" = '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 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 ENG20WA011Incident · No injuriesForeign investigationAirbus A320 · Guwahati, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on December 23, 2019. A GoAir Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced an inflight shutdown…Dec 23, 2019 · VT-WGL · No damage NTSB ENG20WA009Incident · No injuriesForeign investigationAirbus A320 · Mumbai, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on December 22, 2019. A GoAir Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced high engine…Dec 22, 2019 · VT-WJE · No damage NTSB GAA20WA108Incident · No injuriesForeign investigationDe Havilland DHC6 · Pau Pyrenesse, FranceThe government of France has notified the NTSB of an accident involving a DE HAVILLAND DHC6 airplane that occurred on December 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the…Dec 6, 2019 · F-GHRK · Minor damage NTSB ENG20WA049Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Owerri, NigeriaNov 5, 2019 · 5N-BUJ · No damage NTSB CEN19WA274Accident · No injuriesForeign investigationBell 206 · Vuoggatjålme, SwedenOn August 10, 2019, about 0855 hours universal coordinated time, a Bell 206-L1, Swedish registration SE-JOA, was damaged when the rotor blades struck the tail boom during an emergency landing following a loss of engine power after takeoff near Vuoggatjålme,…Aug 10, 2019 · SE-JOA · Substantial damage NTSB GAA19WA458Incident · No injuriesForeign investigationSikorsky S92 · Sable Island, CanadaThe government of Canada has notified the NTSB of an accident involving a SIKORSKY S92 helicopter that occurred on July 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…Jul 24, 2019 · C-GICB · No damage NTSB GAA19WA592Accident · No injuriesForeign investigationBeech B36 · Mexico, MexicoThe government of Mexico has notified the NTSB of an accident involving a BEECH B36 airplane that occurred on July 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Jul 5, 2019 · XB-HYS NTSB GAA19WA414Incident · No injuriesForeign investigationCessna 207 · Birtingarholt, IcelandJun 6, 2019 · TF-MAJ · No damage NTSB CEN19WA254Accident · Minor injuriesForeign investigationCirrus SR22 · Abergavenny, United KingdomOn May 12, 2019, about 0930 coordinated universal time (UTC), a Cirrus Aircraft SR22T airplane, Guernsey registration 2-RORO, serial number 701, was destroyed during a forced landing and postimpact fire following a loss of engine power shortly after takeoff…May 12, 2019 · 2-RORO · Destroyed NTSB ENG19WA017Incident · No injuriesForeign investigationAirbus A320 · Pune, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 2, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure…Apr 2, 2019 · VT-ITG · No damage NTSB ENG19WA018Incident · No injuriesForeign investigationAirbus A320 · Jaipur, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 1, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure…Apr 1, 2019 · VT-IVB · No 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 ENG19WA020Incident · No injuriesForeign investigationAirbus A320 · Lucknow, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on March 7, 2019. A GoAir Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure while…Mar 7, 2019 · VT-WGT · No damage NTSB CEN19WA089Incident · No injuriesForeign investigationPiper PA19 · Brustem Airfield, Belgium, BelgiumThe government of Belgium has notified the NTSB of an accident involving a PIPER PA19 airplane that occurred on February 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions…Feb 16, 2019 · OO-SPQ · Minor damage NTSB ENG19WA012Incident · No injuriesForeign investigationAirbus A321 · Lahore, PakistanOn February 2, 2019, a Vietnam Airlines A321-272N Neo, powered by two P&W PW1130G-JM geared fan engines experienced an No. 2 (right ) engine failure while in cruise. It was reported that a stall warning was detected followed by high vibration and an exhaust…Feb 6, 2019 · VNA-621 · No damage NTSB CEN19WA079Accident · 1 fatalForeign investigationCessna 150 · Durango, MexicoJan 30, 2019 · XB-KEJ · Substantial damage NTSB ENG19WA009Incident · No injuriesForeign investigationAirbus A320 · Lucknow, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on January 21, 2019. An Indigo Airbus A320 experienced a No. 2 (right) engine failure while climbing through FL120 after departure from Lucknow Airport…Jan 21, 2019 · VT-ITQ · No damage NTSB ENG21WA016Incident · No injuriesClass 5 · ForeignBoeing 737 · Lagos, NigeriaJan 3, 2019 · 5N-AIS · Minor damage NTSB ENG19WA010Incident · No injuriesForeign investigationAirbus A320 · Chennai, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on January 3, 2019. An Indigo Airbus A320 experienced a No. 2 (right) engine failure while climbing while climbing after departure from Chennai Airport…Jan 3, 2019 · VT-ITW · No damage