NTSB investigations
1,226 cases where NTSB found Engine (reciprocating).
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\", '010585')) 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", '010585')) 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 CEN22LA423Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8 · Kingsbury, TXA total loss of engine power due to a failure of the ignition switch from carbon tracking, which resulted in a forced landing and a subsequent impact with trees.NTSB ERA22LA412Accident · No injuriesClass 3 · LimitedFinal reportEngineering & Research 415-C · Galion, OHA partial loss of engine power due to an exhaust valve that was stuck in the open position.NTSB ERA22LA410Accident · No injuriesClass 3 · LimitedFinal reportCessna U206 · Buckland, AKThe installation of incompatible rocker arms and rocker arm bushings during an engine overhaul, which resulted in a complete loss of engine power.NTSB CEN22LA413Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32RT · Bulverde, TXThe partial loss of engine power due to excessive carbon deposits that resulted in one or more stuck exhaust valves.NTSB WPR22LA334Accident · Serious injuriesClass 3 · LimitedFinal reportBuxbaum Mark Edward Long EZ · Medicine Bow, WYA partial loss of engine power due to the fatigue fracture of the No. 4 exhaust valve head.NTSB ERA22LA411Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Clearfield, PAA sudden partial loss of engine power for undetermined reasons, which resulted in an off-airport landing.NTSB WPR22FA331Accident · 1 fatalClass 3 · FieldFinal reportYakovlev YAK-11 · Shafter, CAThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the loss of engine oil pressure shortly after takeoff.NTSB CEN22LA403Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Houghton Lake, MIA loss of engine power during cruise flight for undetermined reasons.NTSB WPR22LA317Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design General Avn Ctsw SuperSport · Boulder City, NVA total loss of engine power for undetermined reasons.NTSB WPR22LA316Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150H · Vacaville, CAThe partial loss of engine power due to a stuck exhaust valve.NTSB WPR22LA314Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F33A · Wilder, IDCatastrophic engine failure during the initial climb due to an incorrectly installed crankshaft counterweight retaining ring.NTSB ERA22LA380Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Berry, ALA partial loss of engine power due to the No. 3 cylinder’s stuck exhaust valve.NTSB ERA22LA378Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Marathon, FLA total loss of power for undetermined reasons.NTSB WPR22FA303Accident · 2 fatalClass 3 · FieldFinal reportCessna T207A · Page, AZThe total loss of engine power for undetermined reasons during low altitude cruise flight, which resulted in a water ditching. Contributing to the severity of the accident was the pilot’s failure to extend the flaps during the ditching, which increased the…NTSB WPR22LA301Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Laurel, MTThe loss of climb performance due to undetermined reasons.NTSB CEN22LA377Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Vernon Hills, ILThe pilot’s improper in-flight fuel management, which led to a loss of engine power due to fuel starvation. Contributing to the accident was the collapsed carburetor heat induction tube that restricted airflow to the engine preventing engine restart.NTSB CEN22LA367Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Benton, KSThe loss of engine power for undetermined reasons.NTSB ERA22LA346Accident · Serious injuriesClass 3 · LimitedFinal reportTextron G36 · Ridgeland, SCA loss of engine power for reasons that could not be determined.NTSB ERA22LA345Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Ephratah, NYA loss of engine power for undetermined reasons.NTSB CEN22LA353Accident · Serious injuriesClass 3 · LimitedFinal reportSonex Sonex · River Falls, WIThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.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 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 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 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 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 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 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 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 CEN22LA230Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Ennis, TXA partial loss of engine power for reasons that were undetermined.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 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 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 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 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.NTSB ERA22FA223Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-250 · Athens, GAA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA22LA268Accident · No injuriesClass 3 · LimitedFinal reportWingren Norman Escapade · Brasstown, NCThe failure of the engine gearbox drive flange, which resulted in a nose gear collapse during the subsequent precautionary landing in tall grass.NTSB CEN22LA187Accident · No injuriesClass 3 · LimitedFinal reportNorth American AT-6D · Fredericksburg, TXA total loss of engine power due to a failure of the No. 1 cylinder.NTSB ERA22LA172Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28 · Melbourne, FLA loss of engine power due to oil starvation as a result of the failure of the No. 3 crankshaft journal bearing.NTSB ERA22LA169Accident · Serious injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Smithfield, NCMaintenance personnel’s failure to set the correct engine timing after the replacement of a cylinder head and exhaust camshaft before the accident flight, which resulted in a total loss of engine power.NTSB CEN22LA152Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Ash Flat, ARThe partial loss of engine power during a go-around resulting in an inadvertent entry into an aerodynamic stall. Contributing to the accident was the inexperience of the low-time pilot.NTSB WPR22LA127Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32R-300 · St. George, UTThe total loss of engine power for undetermined reasons.