NTSB investigations
3,825 cases where the sequence of events included Loss of engine power (total).
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA23WA110Accident · No injuriesClass 4 · ForeignEmbraer EMB201 · Nova Ubirata, BrazilNTSB DCA23WA223Incident · Minor injuriesClass 5 · ForeignEmbraer 145 · Kumasi, GhanaNTSB GAA23WA105Accident · No injuriesClass 4 · ForeignPiper PA25 · Corupa, BrazilNTSB WPR23LA131Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-4-220C · Santa Ynez, CAThe pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel starvation.NTSB GAA23WA103Accident · Serious injuriesClass 5 · ForeignCessna 150 · Porto Nacional, TO, BrazilNTSB GAA23WA101Accident · Minor injuriesClass 5 · ForeignEmbraer EMB202 · Porto dos Gauchos, MT, BrazilNTSB WPR23LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Lewiston, IDThe flight instructor’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA23WA098Incident · No injuriesClass 4 · ForeignCirrus SR22 · Sabara, BrazilNTSB WPR23LA125Accident · Minor injuriesClass 4 · LimitedFinal reportRockwell International AC 690A · Bullhead City, AZThe pilot’s improper fuel planning for a cross-country flight, which resulted in fuel exhaustion, a total loss of engine power and subsequent impact with terrain.NTSB ERA23LA141Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Miami, FLA total loss of engine power due to a lack of oil lubrication.NTSB ERA23LA173Accident · No injuriesClass 3 · LimitedFinal reportBeech P35 · Perry, FLMaintenance personnel’s incorrect torquing of the oil filter adapter jam nut, resulting in the failure of the adapter threads, a complete loss of oil, and subsequent total loss of engine power.NTSB GAA23WA092Accident · Minor injuriesClass 5 · ForeignCessna 172 · Loreto, PeruNTSB WPR23LA118Accident · No injuriesClass 4 · LimitedFinal reportBell UH-1B · Orland, CAThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a loss of engine power.NTSB GAA23WA085Accident · Serious injuriesClass 5 · ForeignMcdonnell Douglas 500 · Dansey Pass, Livingston, New ZealandNTSB GAA23WA077AccidentClass 5 · ForeignHughes 269A · Budaors, HungaryNTSB GAA23WA078Accident · No injuriesClass 5 · ForeignEmbraer EMB201 · Santa Vitoria do Palmar, BrazilNTSB CEN23LA107Accident · No injuriesClass 3 · LimitedFinal reportMooney M20 · Lakeway, TXA total loss of engine power due to detonation and preignition in the No. 6 cylinder.NTSB ANC23LA020Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-16 · Soldotna, AKA total loss of engine power for undetermined reasons.NTSB CEN23LA133Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Hilbert, WIThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA23WA059Accident · No injuriesClass 5 · ForeignBell 206 · Itacare, BrazilNTSB WPR23LA094Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Carlsbad, CAA failure of the No. 2 piston connecting rod bearing due to oil starvation for reasons that could not be determined, which resulted in a complete loss of engine power.NTSB ERA23FA113Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · North Castle, NYThe pre-ignition/detonation damage to the No. 4 piston for reasons that could not be determined, which allowed the crankcase to become pressurized and resulted in oil exhaustion and subsequent catastrophic internal engine failure.NTSB DCA23WA174AccidentClass 5 · ForeignATR ATR72 · Pokhara, NepalNTSB CEN23LA083Accident · No injuriesClass 3 · LimitedFinal reportCheek Carroll Hatz/Cheek · Brashear, TXA partial loss of engine power due to the formation of carburetor ice, which resulted in the inability to maintain altitude and the subsequent hard forced landing.NTSB GAA23WA058Accident · Serious injuriesClass 4 · ForeignRobinson R22 · Boa Vista, BrazilNTSB CEN23LA080Accident · No injuriesClass 4 · LimitedFinal reportBeech G33 · Bolingbrook, ILThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA23WA049Accident · No injuriesClass 5 · ForeignCessna F152 · Shoreham on the Sea, United KingdomNTSB CEN23LA067Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172F · Auburn Hills, MIThe catastrophic engine failure due to lack of oil lubrication, which resulted from the pilot’s failure to follow the airplane and engine manufacturers’ guidance for cold weather operation.NTSB ENG23WA011IncidentClass 5 · ForeignCessna 525C · Geneva, SwitzerlandNTSB CEN23LA062Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20K · Addison, TXThe fatigue failure of the engine’s camshaft gear teeth which resulted in a loss of all engine power. Contributing to the accident was the non-compliance with the engine manufacturer’s recommended service bulletin.NTSB ERA23LA083Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-44 · Hawkinsville, GAThe pilot’s inadequate in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA23WA044AccidentClass 4 · ForeignCessna 188 · InaciolâNdia, BrazilNTSB ERA23LA086Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Covington, GAA total loss of engine power due to oil starvation as a result of engine operation with low oil pressure. Contributing to the accident was the failure of two separate maintenance facilities to comply with guidance from the engine manufacturer to disassemble…NTSB GAA23WA043Accident · Minor injuriesClass 4 · ForeignPiper PA25 · Ponta Grossa, BrazilNTSB CEN23LA049Accident · No injuriesClass 3 · LimitedFinal reportCessna 182A · Durango, COA complete loss of engine power for reasons that could not be determined from the available evidence.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 CEN23FA038Accident · 1 fatalClass 3 · FieldFinal reportCessna 421C · Decatur, TXA loss of power on the left engine due to fuel starvation and the subsequent loss of power on the right engine for undetermined reasons.NTSB ERA23LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Lancaster, OHA loss of engine power during initial climb for undetermined reasons.NTSB ERA23LA058Accident · No injuriesClass 3 · LimitedFinal reportAntonov AN2 · Opa-Locka, FLThe pilot's failure to properly configure the cowl flaps and oil cooler shutters, which resulted in a total loss of engine power due to overheating of the engine. Contributing to the accident was the pilot's decision to operate the airplane in with an…NTSB ERA23LA051Accident · No injuriesClass 4 · LimitedFinal reportPipistrel D O O Virus SW · Cross City, FLThe pilots’ inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent deployment of the ballistic parachute recovery system.NTSB GAA23WA024Accident · 2 fatalClass 5 · ForeignPiper PA32 · Jersey, United KingdomNTSB ERA23LA054Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Tanner, ALThe pilot’s inadequate inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA23LA049Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Greenville, SCThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing was the pilot’s failure to use the checklist aboard the airplane during her attempts to restore engine power.NTSB CEN23LA022Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32R-300 · Evansville, INThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA23WA023Accident · No injuriesClass 5 · ForeignCessna 182 · Igarassu, BrazilNTSB ANC23LA005Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-160 · Kenai, AKImproper installation of the crankshaft drive gear by maintenance personnel, who failed to install all required hardware, resulting in an in-flight engine failure.NTSB ERA23LA037Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Spartanburg, SCA partial separation of the crankshaft gear/bolt, which resulted in a total loss of engine power.NTSB GAA23WA013AccidentClass 5 · ForeignPiper PA30 · Quebec, CanadaNTSB ERA23LA034Accident · No injuriesClass 3 · LimitedFinal reportCessna A185E · York, PAOil starvation of the number 1 connecting rod bearings, which resulted in a total loss of engine power.NTSB GAA23WA018Accident · Serious injuriesClass 5 · ForeignBell 407 · São Paulo, Brazil