Skip to content

NTSB investigations, 2020

30 cases where the sequence of events included Powerplant sys/comp malf/fail.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

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") = 2020 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '340' 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\") = 2020
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '340' 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") = 2020
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '340' 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 ENG21LA011Incident · No injuriesClass 3 · LimitedFinal reportCessna 501 · Opa Locka, FLAn uncontained left engine failure caused by a low cycle fatigue crack that originated from a manufacturing machining groove on the high pressure compressor impeller aft face. Contributing to the incident was service bulletin borescope inspection criteria…Dec 31, 2020 · N75TL · Minor damage NTSB ENG21WA010IncidentClass 5 · ForeignAirbus A330 · Keflavik, IcelandDec 28, 2020 · N810NW · No damage NTSB ENG21WA009IncidentClass 5 · ForeignBoeing 737 · Johannesburg, South AfricaDec 25, 2020 · ZS-SJR · No damage NTSB CEN21LA088Accident · 2 fatalClass 3 · LimitedFinal reportRans S12XL · Port Isabel, TXAn exceedance of the airplane’s critical angle of attack and aerodynamic stall following a loss of engine power during an unknown phase of flight, which resulted in an impact with terrain.Dec 16, 2020 · N449JP · Substantial damage NTSB WPR21LA068Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Ogden, UTThe partial loss of engine power for reasons that cannot be determined due to lack of available evidence.Dec 10, 2020 · N577CP · Substantial damage NTSB ENG21WA008Incident · No injuriesClass 5 · ForeignBoeing 737 · Katowice, PolandDec 5, 2020 · LZ-CGU · Minor damage NTSB ENG21WA007IncidentClass 4 · ForeignBoeing 777 · Naha, JapanDec 4, 2020 · JA8978 · Minor damage NTSB WPR21FA048Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Los Angeles, CAMaintenance personnel’s failure to properly secure the throttle control hardware during recent maintenance, which resulted in its disconnection and a subsequent loss of engine power on approach for landing.Nov 12, 2020 · N939CP · Destroyed NTSB CEN21WA093Accident · No injuriesClass 4 · ForeignCessna 401B · Toussus-le-Noble, FranceOct 30, 2020 · N517HC · Substantial damage NTSB ENG21WA050Incident · No injuriesClass 5 · ForeignSikorsky S92 · Sola, NorwayOct 20, 2020 · LN-OMI · No damage NTSB ERA21LA024Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Winder, GAMaintenance personnel’s failure to properly secure the engine cooling fan attachment bolts, leading to vibration of the cooling fan, the overextension of the tension belt actuator, the failure of the drive system vee-belts, and the loss of power to the rotor…Oct 18, 2020 · N566BC · Substantial damage NTSB ERA21LA006Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Fulton, NYThe mechanic’s improper maintenance, which resulted in the crankshaft expansion plug dislodging in flight and a subsequent forced landing.Oct 4, 2020 · N6179U · Substantial damage NTSB ERA20LA309Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA28 · McMinnville, TNA total loss of engine power due to a fatigue failure in a cylinder, and the pilot’s subsequent failure to maintain airspeed and her exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude.Sep 8, 2020 · N4166Z · Substantial damage NTSB CEN20LA377Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-3 · Coleman, MIThe pilot’s improper installation of the generator drive gear, which resulted in a total loss of engine power.Sep 1, 2020 · N909C · Substantial damage NTSB WPR20WA281Accident · No injuriesForeign investigationRobinson R22 · McArthur River Mine, AustraliaAug 16, 2020 · VH-YMU · Substantial damage NTSB GAA20WA125Accident · 1 fatalForeign investigationCessna R172 · Tarapaca-Amazonas, ColombiaJul 30, 2020 · HK2129 · Destroyed NTSB CEN20LA279Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Dalhart, TXThe total loss of engine power due to a failed fuel control unit bearing.Jul 10, 2020 · N61315 · Substantial damage NTSB CEN20LA260Accident · No injuriesClass 3 · LimitedFinal reportChampion 7EC · Port O'Conner, TXThe loss of engine power due to a stuck intake valve.Jul 3, 2020 · N9891B · Substantial damage NTSB CEN20LA286Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Welsh, LAA partial loss of engine power while in flight due to corrosion of engine components, which resulted in a loss of control and a subsequent impact with terrain.Jul 2, 2020 · N7511D · Substantial damage NTSB CEN20LA256Accident · 1 fatalClass 3 · LimitedFinal reportCessna 320 · Round Rock, TXImproper maintenance that led to a loss of engine power due to a failed left engine magneto, the pilot’s improper application of single engine emergency procedures, and his failure to maintain control of the airplane which resulted in a collision with trees.Jul 1, 2020 · N19AS · Destroyed NTSB WPR20LA193Accident · Serious injuriesClass 3 · LimitedFinal reportThatcher CX4 · Upland, CAThe inflight separation of the propeller assembly due to a fatigue fracture of the crankshaft. Contributing to the accident was the pilot’s restricted visibility during landing, which resulted in an excessive approach speed, a long landing, and subsequent…Jun 24, 2020 · N274DR · Substantial damage NTSB WPR20LA144Accident · No injuriesClass 3 · LimitedFinal reportMooney M20J · Phoenix, AZA total loss of engine power due to oil starvation for reasons that could not be determined due to a lack of available evidence, which resulted in impact with terrain during a subsequent forced landing.May 13, 2020 · N201HH · Substantial damage NTSB ENG20WA029Incident · No injuriesForeign investigationAirbus A300 · Brussles, BelgiumOn March 27, 2020, the Danish Aviation Accident Investigation Board (AAIB) informed the NTSB of an Airbus A300-622RF cargo airplane, powered by two Pratt & Whitney PW4158 turbofan engines, that experienced a right (No. 2) engine failure during approach to…Mar 27, 2020 · D-AZMK · Minor damage NTSB DCA20WA096Incident · No injuriesForeign investigationEmbraer ERJ170-200LR · Apodaca, MexicoMar 5, 2020 · N250NN · No damage NTSB CEN20LA107Accident · No injuriesClass 3 · LimitedFinal reportZenith CH601 · Cabool, MOThe loss of engine power due to failure of the No. 1 cylinder piston for reasons that could not be determined based on available evidence.Feb 29, 2020 · N601ND · Substantial damage NTSB ENG20WA018Incident · No injuriesForeign investigationAirbus A321 · London, United KingdomOn February 26, 2020, an Airbus A321-211, powered by two CFM International CFM56-5B3/3 turbofan engines experienced a left (No. 1) engine surge on departure from London Gatwick Airport (LGW) and an ECAM alert for the right engine (No. 2) stall condition. The…Feb 26, 2020 · G-POWN · No damage NTSB CEN20LA109Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Dumas, ARThe pilot’s failure to maintain clearance from a power line pole during a low-level aerial application flight, which resulted in impact with the bracket and a subsequent forced landing.Feb 25, 2020 · N5197Y · Substantial damage NTSB ENG20LA015Incident · No injuriesClass 4 · LimitedFinal reportAirbus A220 · Bordeaux, FranceA No. 1 (left) engine low pressure compressor (LPC) stage 1 integrally bladed rotor (IBR) separation due to a high cycle fatigue crack (HCF) that originated at the runout of an airfoil leading edge root radius. The HCF crack developed because of a…Feb 12, 2020 · YL-AAU · No damage NTSB ENG20WA017Incident · No injuriesForeign investigationAirbus A320 · Mexico City, MexicoOn January 24, 2020, an Airbus A320-271N neo, powered by two Pratt & Whitney PW1127G-JM geared turbofan engines, experienced a right (No. 2) engine failure while climbing through 11,500 feet after takeoff from the Mexico City Intentional Airport (MMMX). The…Jan 24, 2020 · N528VL · No damage NTSB ENG20WA012Incident · No injuriesForeign investigationAirbus A320 · New Delhi, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on January 7, 2020. A GoAir Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced an engine failure…Jan 7, 2020 · VT-WGC · No damage