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.

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.Dec 8, 2023 · N146TJ · Substantial damageNTSB 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…Nov 27, 2023 · N4187Q · DestroyedNTSB 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.Nov 16, 2023 · N90AB · Substantial damageNTSB 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.Nov 9, 2023 · N1817E · Substantial damageNTSB 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…Oct 26, 2023 · N141CD · Substantial damageNTSB 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.Oct 21, 2023 · N7716G · Substantial damageNTSB 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.Oct 15, 2023 · N42VZ · Substantial damageNTSB 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.Oct 15, 2023 · N6JA · Substantial damageNTSB 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.Sep 25, 2023 · N135WT · Substantial damageNTSB 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.Aug 21, 2023 · N3589X · Substantial damageNTSB 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.Jul 21, 2023 · N730WL · Substantial damageNTSB 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…Jul 9, 2023 · N5027P · Substantial damageNTSB 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.Jul 4, 2023 · N26387 · Substantial damageNTSB 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.Jun 21, 2023 · N80461 · Substantial damageNTSB 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.Jun 18, 2023 · N463HP · Substantial damageNTSB 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…Jun 17, 2023 · N926TT · Minor damageNTSB 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.Jun 7, 2023 · N731UF · DestroyedNTSB 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.Jun 6, 2023 · N91157 · Substantial damageNTSB 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.Jun 4, 2023 · N77583 · Substantial damageNTSB 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.May 24, 2023 · N60372 · Substantial damageNTSB 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.May 21, 2023 · N272S · DestroyedNTSB 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.May 20, 2023 · N9433T · Substantial damageNTSB 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.May 17, 2023 · N5550J · Substantial damageNTSB 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.May 15, 2023 · N8262 · Substantial damageNTSB 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.Apr 13, 2023 · N413EK · Substantial damageNTSB 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.Mar 2, 2023 · N9420N · Substantial damageNTSB 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.Nov 27, 2022 · N8006A · Substantial damageNTSB 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.Nov 20, 2022 · N10612 · Substantial damageNTSB 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.Nov 5, 2022 · N6051U · Substantial damageNTSB 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.Oct 18, 2022 · N600JG · DestroyedNTSB 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.Sep 30, 2022 · N297SU · Substantial damageNTSB CEN22LA438Accident · No injuriesClass 4 · LimitedFinal reportShirey David A Fisher Celebrity · Haskell, OKThe inflight fire for reasons that could not be determined.Sep 30, 2022 · N812TD · DestroyedNTSB WPR22LA316Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150H · Vacaville, CAThe partial loss of engine power due to a stuck exhaust valve.Aug 24, 2022 · N22507 · Substantial damageNTSB ERA22LA380Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Berry, ALA partial loss of engine power due to the No. 3 cylinder’s stuck exhaust valve.Aug 20, 2022 · N8797G · Substantial damageNTSB 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.Jul 28, 2022 · N3027J · Substantial damageNTSB 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.Jul 22, 2022 · N4400K · Substantial damageNTSB 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.Jul 20, 2022 · N1228Z · Substantial damageNTSB 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.Jul 17, 2022 · N911SZ · DestroyedNTSB ERA22LA308Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150F · Pittstown, NJThe partial loss of engine power due to a stuck exhaust valve.Jul 13, 2022 · N8761G · Substantial damageNTSB CEN22LA309Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Friend, NEA loss of engine power due to a stuck valve.Jul 8, 2022 · N5177H · Substantial damageNTSB 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.Jul 2, 2022 · N8923H · Substantial damageNTSB 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.Jun 20, 2022 · N337AX · Substantial damageNTSB 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.Jun 20, 2022 · N7048K · Substantial damageNTSB CEN22LA256Accident · No injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Madison, MSThe failure of a muffler weld due to inadequate maintenance, which resulted in a fire.Jun 16, 2022 · N39880 · Substantial damageNTSB 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.Jun 16, 2022 · N52854 · Substantial damageNTSB CEN22LA234Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Henderson, TXThe partial loss of engine power in a hover due to a stuck exhaust valve.Jun 6, 2022 · N94WC · Substantial damageNTSB 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.Jun 4, 2022 · N9087S · Substantial damageNTSB 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.May 29, 2022 · N2148J · Substantial damageNTSB 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.May 14, 2022 · N3960M · Substantial damageNTSB 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.May 9, 2022 · N86RD · Substantial damage