NTSB investigations
628 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.\"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."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 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 GAA23WA214Accident · No injuriesClass 5 · ForeignBell 206B · Thetford Mines, CanadaNTSB 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 GAA23WA164AccidentClass 5 · ForeignPiper PA-24-250 · Guadalajara, MexicoNTSB 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 DCA23WA306Incident · No injuriesClass 5 · ForeignBoeing 737 · Merida, MexicoNTSB 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 GAA23WA162AccidentClass 5 · ForeignPiper PA18 · Oldenburg, GermanyNTSB 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 GAA23WA106Incident · No injuriesClass 5 · ForeignCessna 172 · Madrid, SpainNTSB ENG23WA024Incident · No injuriesClass 5 · ForeignAirbus A320 · Kota Kinabalu, MalaysiaNTSB GAA23WA115Occurrence · No injuriesClass 5 · ForeignCirrus SR22 · Salto, UruguayNTSB 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 GAA23WA075Accident · No injuriesClass 5 · ForeignPiper PA46 · Dessau, GermanyNTSB ENG23WA019IncidentClass 5 · ForeignAirbus A320 · Amritsar, IndiaNTSB GAA23WA066Incident · No injuriesClass 5 · ForeignCessna 206 · Stann Creek, BelizeNTSB ENG23WA012Incident · No injuriesClass 5 · ForeignBoeing 737 · Sydney, AustraliaNTSB ENG23WA014IncidentClass 5 · ForeignLearjet 35 · Hohn, GermanyNTSB ENG23WA009IncidentClass 5 · ForeignBoeing 767 · Incheon, South KoreaNTSB ENG23WA007Incident · No injuriesClass 4 · ForeignBoeing 737 · Mogadishu, SomaliaNTSB 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 DCA23WA076Incident · No injuriesClass 5 · ForeignBoeing 737 · Maiquetía, VenezuelaNTSB 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 ENG23WA002IncidentClass 5 · ForeignAirbus A320 · Delhi, IndiaNTSB 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 ENG23WA001IncidentClass 5 · ForeignBoeing 777 · Islamabad, PakistanNTSB 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 DCA22WA187IncidentClass 5 · ForeignMcdonnell Douglas DC-9-83 · Maiquetia, VenezuelaNTSB 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 ENG22WA042IncidentClass 5 · ForeignBoeing 737 · Gdansk, PolandNTSB GAA22WA242Accident · 1 fatalClass 5 · ForeignPiper PA28 · Sungai Pinji, MalaysiaNTSB 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 ENG22WA035Incident · No injuriesClass 4 · ForeignAirbus A320-214 · Bogota, ColombiaNTSB 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 ENG22WA033IncidentClass 4 · ForeignAirbus A320 · Shymkent, Kazakhstan