NTSB investigations
2,723 cases where NTSB found Aircraft power plant.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0105')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0105')) 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 CEN22LA344Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300T · Dallas, TXMaintenance personnel’s inadequate maintenance of the magneto, which resulted in a loss of engine ignition, a loss of engine power, and a subsequent forced landing.NTSB CEN22LA349Accident · No injuriesClass 3 · LimitedFinal reportSchweizer G-164B · Knox, INA partial loss of engine power for undetermined reasons.NTSB WPR22FA265Accident · 1 fatalClass 3 · FieldFinal reportNorth American T-28B · Fallbrook, CAA loss of power due to an unmaintained carburetor diaphragm and inoperative electric fuel pump that resulted in fuel starvation to the engine.NTSB ERA22LA333Accident · No injuriesClass 3 · LimitedFinal reportStinson 108 · Batesburg, SCThe fatigue failure of the crankshaft gear, resulting in a total loss of engine power.NTSB CEN22LA334Accident · Minor injuriesClass 3 · LimitedFinal reportVan's RV-10 · Beaver Dam, WIThe improperly secured spark plug boot that resulted in smoke in the cockpit and a subsequent off-airport landing.NTSB WPR22LA263Accident · Serious injuriesClass 3 · LimitedFinal reportZenith CH701 · Bothell, WAA loss of engine power due to the fatigue failure of the engine’s flywheel screws that were likely overloaded when the engine was involved in a previous accident.NTSB WPR22LA262Accident · No injuriesClass 3 · LimitedFinal reportMaule M-5-235C · Three Forks, MTA loss of engine power due to degraded and incorrectly maintained ignition system components. Contributing to the accident was the pilot’s delay in turning the airplane towards the runway when the engine began to lose power.NTSB CEN22LA330Accident · No injuriesClass 3 · LimitedFinal reportBeech N35 · Wardsville, MOEngine failure due to oil starvation resulting from an oil leak at the improperly installed aftermarket oil filter adapter.NTSB ERA22LA322Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV10 · Palatka, FLTotal loss of engine power due to the improper installation of an electronic ignition system connector plug.NTSB CEN22LA322Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 112 · Granbury, TXThe loss of engine power due to metal contamination within the cylinder following poor maintenance.NTSB WPR22LA259Accident · Minor injuriesClass 3 · LimitedFinal reportSocata TB21 · San Marcos, CAThe failure of the mechanical fuel pump due to internal friction for reasons that could not be determined based on available evidence, which resulted in a total loss of engine power.NTSB WPR22FA256Accident · 4 fatalClass 3 · FieldFinal reportCessna T337G · Gold Hill, COThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering with one engine inoperative, which resulted in an aerodynamic stall/spin and impact with terrain.NTSB CEN22FA317Accident · 4 fatalClass 3 · FieldFinal reportBell UH-1H · Chapelle, NMThe total loss of engine power due to the fatigue failure of the starter-generator input (zerol) gear which failed due to poor maintenance. Contributing to the accident was the unsuccessful autorotation complicated by the setting sun and high density altitude.NTSB ERA22LA323Accident · Serious injuriesClass 3 · LimitedFinal reportAllan G Pixley Thatcher CX4 · Baker, FLThe improper engine idle setting, which resulted in a total loss of engine power when the pilot reduced the throttle to idle to initiate a descent.NTSB ERA22LA321Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Tuscaloosa, ALThe student pilot’s inadvertent use of the fuel mixture knob instead of the carburetor heat knob, which resulted in fuel starvation and a subsequent loss of engine power.NTSB ERA22LA317Accident · No injuriesClass 3 · LimitedFinal reportCessna T210F · Monticello, NYMaintenance personnel’s improper torque of the engine through-bolts during maintenance, which resulted in a bearing shift, oil starvation, and a total loss of engine power.NTSB ERA22LA308Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150F · Pittstown, NJThe partial loss of engine power due to a stuck exhaust valve.NTSB CEN22LA315Accident · No injuriesClass 3 · LimitedFinal reportZenith Zodiac 650B · Eufaula, OKThe loss of engine power due to a push rod that was incorrectly installed by the airplane owner.NTSB CEN22LA312Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502B · Decatur, ILFracture of the compressor turbine (CT) blades due to creep.NTSB ERA22LA307Accident · No injuriesClass 3 · LimitedFinal reportMooney M20F · Cragsmoor, NYThe pilot’s decision to continue toward rising terrain despite observing the airplane’s decreased climb performance after takeoff, which resulted in flight into terrain.NTSB ERA22LA302Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502B · Center Cross, VAA loss of engine power for reasons that could not be determined.NTSB CEN22LA309Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Friend, NEA loss of engine power due to a stuck valve.NTSB WPR22LA246Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172B · Silver Springs, NVA loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN22LA308Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Aurora, COA total loss of engine power due to foreign object debris blockage of engine air intake. The source of the debris could not be determined based on the available information.NTSB ERA22LA297Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman G-164A · Hopewell Township, NJA partial loss of engine power while maneuvering at low altitude due to a failure of the airplane’s supercharger.NTSB ERA22LA366Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32RT · Wilmington, NCA partial loss of engine power during initial climb for reasons that could not be determined.NTSB ERA22LA292Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8 · New Market, VAImpact with a fence during an attempted takeoff from a short, uphill turf airstrip.NTSB ERA22FA279Accident · 6 fatalClass 1 · FieldFinal reportBell UH-1B · Amherstdale, WVthe operator’s failure to adequately inspect the former military turbine powered helicopter, which allowed an engine issue to progress and result in a loss of engine power and a subsequent loss of control after the helicopter struck powerlines during a forced…NTSB CEN22LA256Accident · No injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Madison, MSThe failure of a muffler weld due to inadequate maintenance, which resulted in a fire.NTSB CEN22LA253Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T206H · Austin, TXA total loss of engine power due to an engine fire that resulted from failure of the turbocharger exhaust clamp, which allowed hot exhaust gases to damage other vital engine components.NTSB ERA22LA270Accident · Minor injuriesClass 3 · LimitedFinal reportBurrill Steven E A Plane · Middleboro, MAA total loss of engine power for reasons that could not be determined.NTSB ERA22LA265Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-23 · Stockbridge, GAA total loss of right engine power during initial climb for reasons that could not be determined.NTSB CEN22LA247Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32R-301 · Olla, LAThe partial loss of engine power for undetermined reasons.NTSB ERA22FA261Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28RT-201 · Panama City, FLMaintenance personnel’s failure to follow the avionics installation guidance for the oil pressure sensor, which resulted in the high-cycle fatigue failure of an line, oil starvation, and the subsequent loss of engine power. Contributing to the accident was…NTSB CEN22LA234Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Henderson, TXThe partial loss of engine power in a hover due to a stuck exhaust valve.NTSB CEN22LA233Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Amarillo, TXThe loss of engine power due to a leak in the fuel control assembly. Contributing to the accident was the inadequate maintenance of the fuel control assembly.NTSB CEN22LA251Accident · No injuriesClass 3 · LimitedFinal reportTrojan TA16 · Ray, MIA lack of lubrication and inadequate cooling, which resulted in internal damage to the engine and a subsequent total loss of engine power.NTSB CEN22LA230Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Ennis, TXA partial loss of engine power for reasons that were undetermined.NTSB ERA22LA254Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Tredyffin, PAThe loosening of the throttle arm from the throttle body, which resulted in the pilot’s inability to control the engine, and a subsequent forced landing.NTSB CEN22LA228Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Allport, ARA partial loss of engine power due to fuel contamination from foreign object debris. Contributing to the accident was the operator’s failure to follow the manufacturer’s required airframe fuel filter inspection interval.NTSB WPR22LA193Accident · No injuriesClass 3 · LimitedFinal reportVans RV-8 · Galice, ORThe in-flight failure of the crankshaft gear’s alignment dowel as a result of the retaining bolt not being installed, which lead to a total loss of engine power.NTSB CEN22FA216Accident · 1 fatalClass 3 · FieldFinal reportExpress 2000RG · Cheyenne, WYThe pilot's inability to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack while managing a loss of engine power and inflight fire, which resulted in an aerodynamic stall. Contributing factors to the accident were the loss…NTSB CEN22LA227Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28RT-201T · Morgan, TXA partial loss of engine power due to a corrosion-related fatigue crack of the No. 3 cylinder barrel.NTSB WPR22FA188Accident · 2 fatalClass 3 · FieldFinal reportCessna 172F · Show Low, AZThe pilot’s improper leaning of the engine during an extended period of time, which caused an exhaust valve to become stuck and led to the partial loss of engine power during the accident flight. Contributing to the accident was the pilot’s decision to…NTSB ERA22LA235Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Caryville, FLAn in-flight loss of engine power on both engines for undetermined reasons.NTSB WPR22LA186Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P172D · Prescott, AZThe loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN22FA208Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Broomfield, COThe pilot’s failure to abort the takeoff due to degraded engine performance. Contributing to the accident was the reduced performance of the engine, the reason for which could not be determined.NTSB ERA22LA241Accident · No injuriesClass 3 · LimitedFinal reportEvektor-Aerotechnik Sportstar · Lancaster, OHThe improper installation and subsequent failure of the pushrod O-rings, which resulted in failure of the No. 4 connecting rod due to oil starvation.NTSB ANC22LA033Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft F19 · Anchorage, AKA loss of engine power for reasons that could not be determined due to a lack of available evidence.NTSB WPR22LA177Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-12 · Enterprise, ORThe inadequate maintenance and inspection of the crankshaft expansion plug, which resulted in the separation of the expansion plug from the crankshaft and the subsequent loss of oil and windshield obstruction during departure.