NTSB investigations
821 cases where the sequence of events included Powerplant sys/comp malf/fail.
Cases, newest first
Query with SQL
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.\"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 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 CEN22LA085Accident · No injuriesClass 3 · LimitedFinal reportBeech A100 · West Helena, ARThe malfunction of the propeller autofeather system after takeoff for undetermined reasons, which resulted in both propellers going into feather and a hard landing.NTSB ERA22LA071Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Brent, ALThe inadequate maintenance of the oil filter adapter, which resulted in in an engine oil leak and subsequent loss engine oil pressure, and the subsequent off-airport landing.NTSB ERA22LA011Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Greenville, SCA total loss of engine power resulting from the in-flight disconnection of oil hoses from the oil thermostat.NTSB ENG22LA002Incident · Minor injuriesClass 3 · LimitedFinal reportAirbus A320-271N · Atlantic City, NJThe ingestion of a bird into the right engine during the takeoff roll caused a fan blade to fracture near the blade platform resulting in high fan blade off loads and engine vibrations sufficient to result in an eventual failure of a fuel tube in the right…NTSB CEN21LA472Accident · No injuriesClass 3 · LimitedFinal reportCessna T210N · East Sparta, OHA total loss of engine power due to a fatigue failure of the No. 2 cylinder exhaust valve.NTSB ERA21LA356Accident · No injuriesClass 3 · LimitedFinal reportWaco GXE · Burt, NYThe improper magneto timing, which resulted in the engine’s inability to produce full power during the takeoff.NTSB ERA21LA359Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Venice, FLMaintenance personnel’s failure to use the correct throttle linkage hardware when reinstalling the engine, resulting in a disconnection of the throttle during flight.NTSB GAA21WA253Accident · No injuriesClass 5 · ForeignCessna 441 · Tindal, AustraliaNTSB CEN21LA402Accident · No injuriesClass 3 · LimitedFinal reportMurphy Renegade II · Sheridan, ILA total loss of engine power during initial climb due to a piston seizure.NTSB GAA21WA218Accident · No injuriesClass 5 · ForeignBoeing A75N1(PT17) · Sandbanks, United KingdomNTSB GAA21WA223AccidentClass 5 · ForeignRobinson R44 · Kamajab, NamibiaNTSB ANC21LA094Accident · No injuriesClass 3 · LimitedFinal reportDehavilland DHC-3 · Bettles, AKThe seizure of the engine during flight for undetermined reasons, which led to a total loss of engine power.NTSB WPR21LA325Accident · No injuriesClass 3 · LimitedFinal reportStout Garry V Europa - Trigear · Hanksville, UTThe pilot’s installation of a non-original equipment manufactured radiator cap, which resulted in the loss of coolant and the engine’s exceedance of the maximum admissible cylinder head temperature. Contributing to the accident was the lack of suitable…NTSB WPR21LA316Accident · No injuriesClass 3 · LimitedFinal reportBeech 77 · Stanley, NMA loss of engine performance due to lead fouling of the lower spark plugs, which resulted in an off airport forced landing.NTSB CEN21LA359Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Gosport, INA total loss of engine power during cruise flight due to the failure of a cylinder exhaust valve stem, which led to a forced landing during which the airplane impacted terrain.NTSB WPR21LA301Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Amado, AZThe inflight separation of a section of a propeller blade due to a fatigue crack, which resulted in a forced landing.NTSB DCA21WA188Incident · No injuriesClass 5 · ForeignBoeing 747 · Zhengzhou City, ChinaNTSB CEN21LA358Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Patterson, LAThe mechanic’s failure to properly secure the throttle arm rendering it loose and inoperable after takeoff, which resulted in a total loss of engine power.NTSB ERA21FA253Accident · 1 fatalClass 3 · FieldFinal reportVans RV6 · Buckingham, PAAn exhaust system leak that resulted in failure of the oil quick drain, a loss of oil lubrication, an in-flight fire, and the pilot’s subsequent loss of airplane control.NTSB CEN21LA264Accident · No injuriesClass 3 · LimitedFinal reportBoeing B75N1 · Elwood, NEThe failure of the engine master rod, resulting in a total loss of engine power and a forced landing.NTSB WPR21LA219Accident · Serious injuriesClass 3 · LimitedFinal reportStoddard Hamilton Glasair II · Darby, MTThe pilot’s impact with terrain during a go-around following an attempted precautionary landing due to a low oil pressure indication. The reason for the low oil pressure indication could not be determined based on the available information.NTSB ENG21WA027IncidentClass 5 · ForeignBoeing 737 · Beograd, SerbiaNTSB CEN21LA222Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Racine, WIThe fatigue failure of the carburetor throttle control cable, which resulted in a partial loss of engine control.NTSB DCA21WA136Incident · No injuriesClass 5 · ForeignBoeing 777 · Cayo Coco, CubaNTSB ANC21LA038Accident · No injuriesClass 3 · LimitedFinal reportEnstrom F-28F · Palmer, AKA loss of drive to the rotor system due to the disengagement of the main belt drive tensioning system, which resulted in a forced landing. The disengagement was due to inadequate clearance between the clutch handle and the roll pin in the handle bellcrank…NTSB DCA21WA129IncidentClass 5 · ForeignAirbus A330 · Karachi, PakistanNTSB GAA21WA085Accident · No injuriesClass 5 · ForeignCessna 550 · Eelde, NetherlandsNTSB ENG21WA020Incident · No injuriesClass 5 · ForeignBoeing 737 · Jakarta, IndonesiaNTSB CEN21LA138Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182F · Millville, IAThe inadequate maintenance/inspection of the airplane, which resulted in a total loss of engine power due to oil starvation.NTSB DCA21FA085Incident · No injuriesClass 3 · FieldFinal reportBoeing 777-222 · Broomfield, COThe fatigue failure of the right engine fan blade. Contributing to the fan blade failure was the inadequate inspection of the blades, which failed to identify low-level indications of cracking, and the insufficient frequency of the manufacturer’s inspection…NTSB GAA21WA023Accident · No injuriesClass 4 · ForeignBell 206 · Wonderboom, South AfricaNTSB CEN21FA130Accident · 2 fatalClass 3 · FieldFinal reportVelocity Vtwin · Janesville, WIThe exceedance of the maximum airspeed for flight with the landing gear extended, which resulted in a separation of the right main landing gear door that subsequently impacted the right propeller and resulted in a total loss of right engine power.…NTSB ENG21WA017IncidentClass 5 · ForeignBoeing 737 · Kinshasa, Congo - KinshasaNTSB ERA21LA109Accident · Serious injuriesClass 3 · LimitedFinal reportPlante Challenger II · Minneola, FLFailure of the engine/propeller drive belt.NTSB WPR21LA079Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20-135 · Riverside, UTA failure of the throttle control during a landing roll, which resulted in a loss of control and collision with a fence.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…NTSB ENG21WA010IncidentClass 5 · ForeignAirbus A330 · Keflavik, IcelandNTSB ENG21WA009IncidentClass 5 · ForeignBoeing 737 · Johannesburg, South AfricaNTSB 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.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.NTSB ENG21WA008Incident · No injuriesClass 5 · ForeignBoeing 737 · Katowice, PolandNTSB ENG21WA007IncidentClass 4 · ForeignBoeing 777 · Naha, JapanNTSB 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.NTSB CEN21WA093Accident · No injuriesClass 4 · ForeignCessna 401B · Toussus-le-Noble, FranceNTSB ENG21WA050Incident · No injuriesClass 5 · ForeignSikorsky S92 · Sola, NorwayNTSB 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…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.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.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.NTSB WPR20WA281Accident · No injuriesForeign investigationRobinson R22 · McArthur River Mine, Australia