Final NTSB investigations
422 cases where the defining event was 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '340')
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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '340') 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 CEN24LA061Accident · No injuriesClass 3 · LimitedFinal reportCessna 421C · McGregor, TXThe failure of the spring pin in the right propeller governor, which precluded the pilot from controlling the propeller pitch to maintain engine rpm, resulting in a loss of engine thrust, excessive drag, and the subsequent forced landing to a field.NTSB ERA24FA050Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Attalla, ALThe undetected wear of both pawl retaining rivets of the left magneto impulse coupling and fatigue failure of one pawl retaining rivet, which led to cascading fractures of the second pawl retaining rivet, left gear retainer assembly, and gear teeth of…NTSB ERA24LA040Accident · Minor injuriesClass 3 · LimitedFinal reportBell Andy Skyraider II · Limington, METhe failure of the fuel pump to adequately supply fuel to the engine due to significant corrosion.NTSB CEN24LA036Accident · No injuriesClass 3 · LimitedFinal reportTextron 172S · Erie, COA partial loss of engine power while maneuvering at a low altitude due to a stuck exhaust valve.NTSB CEN24LA027Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Rowlett, TXA malfunction of the helicopter’s Engine Monitoring Unit (EMU)/Governor Controller for undetermined reasons. Contributing to the accident was the flight instructor’s failure to turn off the EMU/Governor Controller per the emergency checklist when the…NTSB ERA24LA016Accident · No injuriesClass 3 · LimitedFinal reportCessna 172L · Richmond, VAThe loss of engine power due to a restriction of fuel flow as a result of a fractured float bracket in the carburetor.NTSB CEN24LA012Accident · No injuriesClass 3 · LimitedFinal reportTvap 4 · Franksville, WIThe improper installation of the supplemental ignition system, which resulted in a total loss of engine power.NTSB CEN24LA011Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Red Oak, IAThe fatigue failure of the exhaust valve due to excessive combustion deposits, which resulted in a partial loss of engine power. Contributing to the accident was the pilot’s failure to ensure that the required scheduled maintenance was completed.NTSB WPR23LA352Accident · Serious injuriesClass 3 · LimitedFinal reportWayne Toddun Sling 4 TSI · San Pedro, CAA total loss of engine power due to a failure of the No. 4 cylinder exhaust valve from overheating and excessive wear.NTSB CEN23LA370Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Durant, OKThe loosening of a connecting rod cap nut for reasons that could not be determined, which resulted in a mechanical failure of the engine and an in-flight fire.NTSB CEN23LA327Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV10 · Chouteau, OKThe total loss of engine power as a result of a failed positive crankcase ventilation (PCV) valve and a subsequent impact with terrain.NTSB ERA23LA293Accident · Minor injuriesClass 3 · LimitedFinal reportHughes 369D · Waldorf, MDFatigue failure of the overrunning clutch outer race and a subsequent inflight loss of power due to abnormal bending loads as a result of improper reassembly of the clutch subassembly following maintenance and the presence of microcracks on the clutch’s outer…NTSB ERA23LA286Accident · No injuriesClass 3 · LimitedFinal reportGrumman American Avn. AA5A · Redstone Arsenal, ALThe separation of the clamp assembly securing the throttle control cable outer housing, which resulted in the pilot’s inability to control the throttle.NTSB CEN23LA250Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 7EC · Waunakee, WIA total loss of engine power during the initial takeoff climb due to a worn manual fuel primer pump locking mechanism, which resulted in an unlocked primer and an overly rich fuel mixture.NTSB CEN23LA246Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · College Station, TXThe mechanic’s failure to properly secure the oil suction screen plug during recent maintenance, which resulted in an oil leak and subsequent loss of engine power due to oil starvation.NTSB ENG23LA030Incident · No injuriesClass 3 · LimitedFinal reportGulfstream Aerospace G-IV · Sioux City, IAA No. 2 (right) engine failure due to a spinner fairing separation and subsequent impact with the fan blades that resulted in a midspan fracture of one fan blade. The spinner fairing separated as a result of a fatigue crack that originated from the heat…NTSB WPR23LA218Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A188B · Chillicothe, MOA partial loss of engine power due to a tear in the fuel manifold diaphragm, which prevented sufficient fuel flow to the engine.NTSB CEN23LA231Accident · No injuriesClass 3 · LimitedFinal reportCessna 207 · Harlingen, TXThe improper installation of the throttle control arm to the throttle control cable attachment end, which resulted in a failure of the control arm and a loss of engine power in flight.NTSB WPR23LA215Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Belfair, WAThe total loss of engine power due to the fatigue failure of the crankshaft accessory drive gear.NTSB WPR23LA199Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Casa Grande, AZAn in-flight separation of the throttle linkage, which resulted in a loss of throttle control. Contributing to the accident was maintenance personnel’s failure to follow the maintenance manual inspection procedure for the throttle cable assembly.NTSB ERA23FA238Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · Rougemont, NCA total loss of engine power due to oil starvation. The source of the oil starvation could not be determined.NTSB WPR23LA197Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Redding, CAA fuel leak caused by an age-degraded fuel pressure sender hose, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was inadequate maintenance.NTSB CEN23LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Flower Mound, TXThe fatigue failure of the rocker arm which resulted in a partial loss of engine power. Contributing was the airplane operator’s failure to inspect the rocker arm in accordance with the engine manufacturer’s service bulletin.NTSB ERA23LA231Accident · No injuriesClass 3 · LimitedFinal reportCharles D Walker Walker Curtiss JN4D · Greenville, KYThe separation of an electrical wire that powered the ignition module, rendering the ignition system inoperative, and resulting in the total loss of engine power.NTSB CEN23LA165Accident · No injuriesClass 3 · LimitedFinal reportPipistrel Lsa Sinus · Kingsford, MIThe failure of maintenance personnel to properly secure the left carburetor bowl cover, which resulted in an engine fire before takeoff.NTSB ERA23LA144Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Slaughters, KYMaintenance personnel’s failure to secure the fuel strainer bowl with safety wire, which resulted in the fuel strainer bowl leaking and starving the engine of fuel. Also causal was the obstruction of two fuel injector nozzles.NTSB ERA23LA073Accident · No injuriesClass 3 · LimitedFinal reportChilds Michael A Rotorway Exec 162-F · Titusville, FLA failure of the No. 4 exhaust valve spring retainer, which resulted in a partial loss of engine power.NTSB CEN23LA040Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150L · Cypress, TXFailure of the engine exhaust valve during cruise flight, which resulted in a loss of engine power and a forced landing.NTSB CEN23LA027Accident · No injuriesClass 3 · LimitedFinal reportCessna R172E · Aguilar, COFailure of the engine cylinder assembly, which resulted in a loss of engine power during cruise flight and an impact with a fence during the forced landing.NTSB ERA23FA025Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Brentwood, TNA total loss of engine power due to the catastrophic failure of the crankshaft resulting from the improper installation of the crankshaft for this application.NTSB WPR22LA363Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Cedar City, UTA partial loss of engine power due to a damaged cylinder intake valve and subsequent collision with terrain during an autorotation.NTSB CEN22LA438Accident · No injuriesClass 4 · LimitedFinal reportShirey David A Fisher Celebrity · Haskell, OKThe inflight fire for reasons that could not be determined.NTSB WPR22LA316Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150H · Vacaville, CAThe partial loss of engine power due to a stuck exhaust valve.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 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 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 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 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 ERA22LA308Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150F · Pittstown, NJThe partial loss of engine power due to a stuck exhaust valve.NTSB CEN22LA309Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Friend, NEA loss of engine power due to a stuck valve.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 ERA22LA277Accident · Serious injuriesClass 3 · LimitedFinal reportHawker Hunter · Wilmington, NCA bearing failure in the high-pressure fuel pump, which resulted in a partial loss of engine power.NTSB ANC22LA049Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Palmer, AKThe loss of engine power due to carburetor icing and the pilot’s failure to utilize carburetor heat.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 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 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 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 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.