NTSB investigations
2,826 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '341') 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" = '341') 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 GAA23WA132Accident · No injuriesClass 5 · ForeignEmbraer EMB711 · Manoel Urbano, BrazilNTSB ERA23LA197Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177RG · Crestview, FLThe total loss of engine power due to the loosening and separation of the No. 1 connecting rod cap nuts in flight, resulting in catastrophic internal engine damage. Contributing to the accident was the pilot/owner’s failure to comply with the engine…NTSB GAA23WA121AccidentClass 5 · ForeignCessna 210 · Mazatlan, MexicoNTSB GAA23WA197AccidentClass 5 · ForeignPiper PA-31-350 · Archerfield, AustraliaNTSB CEN23LA149Accident · No injuriesClass 3 · LimitedFinal reportCessna 182Q · Gardner, KSA total loss of engine power due to failure of the No. 6 connecting rod as a result of detonation.NTSB ERA23LA183Accident · No injuriesClass 4 · LimitedFinal reportPeterson Mark G Peterson A600 · Foley, ALThe loss of engine power during the initial climb due to the disconnection of the turbocharger air intake hose and clamp, and the pilot’s inadequate servicing and preflight inspection of the turbocharger air intake clamp.NTSB GAA23WA122Accident · Minor injuriesClass 4 · ForeignCessna 172 · Chapecó, BrazilNTSB GAA23WA123Accident · Minor injuriesClass 4 · ForeignCessna T188 · Recinto Estero Claro, EcuadorNTSB DCA23WA222IncidentClass 5 · ForeignBoeing 737-823 · Belize City, BelizeNTSB GAA23WA116Accident · No injuriesClass 5 · ForeignCirrus SR-22 · Massaranduba, BrazilNTSB GAA23WA114Accident · Serious injuriesClass 5 · ForeignPiper PA-28-140 · Scottsdene, South AfricaNTSB ERA23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Travelers Rest, SCMaintenance personnel’s improper servicing of the magneto, which resulted in its accelerated wear, failure, and the total loss of engine power.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 GAA23WA103Accident · Serious injuriesClass 5 · ForeignCessna 150 · Porto Nacional, TO, BrazilNTSB GAA23WA101Accident · Minor injuriesClass 5 · ForeignEmbraer EMB202 · Porto dos Gauchos, MT, BrazilNTSB GAA23WA098Incident · No injuriesClass 4 · ForeignCirrus SR22 · Sabara, BrazilNTSB 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 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 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 GAA23WA058Accident · Serious injuriesClass 4 · ForeignRobinson R22 · Boa Vista, BrazilNTSB 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 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 ERA23LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Lancaster, OHA loss of engine power during initial climb for undetermined reasons.NTSB GAA23WA024Accident · 2 fatalClass 5 · ForeignPiper PA32 · Jersey, United KingdomNTSB 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, BrazilNTSB ERA23FA023Accident · 2 fatalClass 3 · FieldFinal reportPeryera Adventura II · Miramar, FLThe pilot’s failure to remove the ECU select switch per the manufacturer’s service bulletin, which resulted in a loss of engine power.NTSB GAA23WA011Incident · No injuriesClass 5 · ForeignCessna 402 · Bahia Solano, ColombiaNTSB WPR23LA003Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182C · Boulder City, NVA total loss of engine power due to oil starvation resulting from the failure of an engine oil filter adapter fiber gasket.NTSB GAA23WA004Accident · Minor injuriesClass 5 · ForeignPilatus BN2A-21 · Kubin, Australia