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 GAA22WA046Accident · No injuriesClass 5 · ForeignSchweizer 269C · Silesian, PolandNTSB GAA22WA045Accident · Minor injuriesClass 5 · ForeignCessna 172 · Trinidad, BoliviaNTSB ERA22LA082Accident · Minor injuriesClass 3 · LimitedFinal reportBeech S35 · Tallahassee, FLA total loss of engine power due to a lack of oil lubrication.NTSB CEN22LA055Accident · Minor injuriesClass 4 · LimitedFinal reportRay Earl D Flightstar Iisc · Haskell, OKA sudden loss of engine power after takeoff for undetermined reasons based on the information available.NTSB ERA22FA076Accident · 2 fatalClass 3 · FieldFinal reportCessna T210R · Grove City, PAA catastrophic engine failure due to oil starvation after the pilot’s failure to secure the oil filler cap before flight. Contributing to the accident was the pilots’ decision to continue the flight following the oil loss event and precautionary landing.NTSB ERA22LA067Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Glens Falls, NYA total loss of engine power for reasons that could not be determined.NTSB GAA22WA033Accident · No injuriesClass 5 · ForeignCessna 152 · Vilar da Luz, PortugalNTSB ERA22LA064Accident · No injuriesClass 3 · LimitedFinal reportMooney M20M · Tampa, FLThe total loss of engine power due to the failure of maintenance personnel to properly tighten the fuel supply line b-nut at the manifold valve during installation.NTSB GAA22WA030Accident · Serious injuriesClass 5 · ForeignHughes 269C · Klinga, GermanyNTSB GAA22WA027Accident · No injuriesClass 5 · ForeignRans S6-ESD · Felton, United KingdomNTSB GAA22WA035Accident · No injuriesClass 4 · ForeignRobinson R44 · Belo Horizonte, BrazilNTSB ERA22LA052Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-220C · Ridgeway, VAThe pilot’s improper fuel management which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.NTSB ERA22LA045Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Decatur, GAOil exhaustion due to an oil leak that resulted in a total loss of engine power.NTSB WPR22LA025Accident · No injuriesClass 3 · LimitedFinal reportCessna R172K · Rexburg, IDA total loss of engine power for reasons that could not be determined based on the available evidence. Contributing to the accident was the pilot’s decision to operate the airplane with a known mechanical issue.NTSB GAA22WA023Accident · No injuriesClass 5 · ForeignZenith 601 · Ciocanesti, RomaniaNTSB CEN22LA037Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Hammond, LAA complete loss of engine power due to oil starvation as a result of the oil filter safety wire fracturing and the oil filter becoming loose in flight for a reason that could not be determined given the evidence available during the investigation.NTSB GAA22WA022Accident · No injuriesClass 5 · ForeignCessna T188 · Vilhena, BrazilNTSB ERA22LA028Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Sligo, PAA total loss of engine power due to fuel exhaustion as a result of the pilots mismanagement of fuel.NTSB GAA22WA018Accident · No injuriesClass 5 · ForeignAeronca 65C · Birchwood, United KingdomNTSB DCA22WA032IncidentClass 5 · ForeignBoeing 787 · Montevideo, UruguayNTSB WPR22LA019Accident · No injuriesClass 3 · LimitedFinal reportLancair ES · Fall Creek, ORTotal loss of engine power due to fatigue failure of the camshaft gear.NTSB ERA22LA017Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Fire Island, NYA total loss of engine power for undetermined reasons.NTSB GAA22WA008Accident · Minor injuriesClass 5 · ForeignCessna 172 · Yapu, ColombiaNTSB ERA22LA011Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Greenville, SCA total loss of engine power resulting from the in-flight disconnection of oil hoses from the oil thermostat.NTSB WPR22LA005Accident · No injuriesClass 3 · LimitedFinal reportBeech B36TC · Los Banos, CAThe total loss of engine power due to the improper installation of the No. 4 connecting rod bolt nut during a recent overhaul.NTSB GAA22WA066AccidentClass 5 · ForeignPiper PA18 · Trevelin, Chubut, ArgentinaNTSB GAA22WA011AccidentClass 5 · ForeignAero Commander 100 · Carinthia, AustriaNTSB GAA22WA006AccidentClass 5 · ForeignPiper PA28 · Panama City, PanamaNTSB WPR22LA002Accident · Minor injuriesClass 3 · LimitedFinal reportZenith CH750 · Oregon City, ORThe total loss of engine power for undetermined reasons.NTSB ERA21LA391Accident · No injuriesClass 3 · LimitedFinal reportBoeing E75 · Nicholson, PAA total loss of engine power as a result of damaged internal carburetor mixture control components.NTSB ERA21LA388Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Port Orange, FLThe separation of the nut from the stud and the fracture of the bolt that secured the crankshaft idler gear to the engine crankcase, which resulted in a total loss of engine power due to the inability of the left crankshaft idler gear assembly to drive of the…NTSB CEN21LA472Accident · No injuriesClass 3 · LimitedFinal reportCessna T210N · East Sparta, OHA total loss of engine power due to a fatigue failure of the No. 2 cylinder exhaust valve.NTSB GAA21WA262Incident · No injuriesClass 4 · ForeignSchweizer G164B · Trinta y Tres, UruguayNTSB GAA21WA246Accident · Serious injuriesClass 5 · ForeignPartenavia P68 · Bush Bay Beach, Co. Wexford, IrelandNTSB GAA21WA243Accident · Minor injuriesClass 3 · ForeignKaman K1200 · Okuwa, JapanNTSB GAA21WA232AccidentClass 5 · ForeignPiper PA28 · Leon, SpainNTSB WPR21LA357Accident · Serious injuriesClass 3 · LimitedFinal reportFonville Swearingen SX300 · Buckeye, AZThe total loss of engine power due to the failure of the left magneto.NTSB GAA21WA254IncidentClass 5 · ForeignRockwell International 112A · Bad Ragaz, SwitzerlandNTSB ENG22WA001Incident · No injuriesClass 5 · ForeignAirbus A320 · Silao, Guanajuato, MexicoNTSB GAA21WA236Accident · No injuriesClass 5 · ForeignCessna 210 · Santa Izabel do Rio Negro, BrazilNTSB WPR21LA358Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-B33 · Baker, NVA total loss of engine power during the initial climb due to the failure of the No. 5 connecting rod bearing.NTSB CEN21LA402Accident · No injuriesClass 3 · LimitedFinal reportMurphy Renegade II · Sheridan, ILA total loss of engine power during initial climb due to a piston seizure.NTSB CEN21LA400Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Fort Wayne, INThe total loss of engine power after takeoff due to the formation of carburetor ice while on the ground and the pilot’s failure to apply carburetor heat immediately before takeoff.NTSB ERA21LA347Accident · Minor injuriesClass 3 · LimitedFinal reportQuad City Challenger · Geneva, ALA total loss of engine power for reasons that could not be determined.NTSB ENG21WA039Accident · No injuriesClass 4 · ForeignMD Helicopter 369 · Megiddo, IsraelNTSB ERA21LA349Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · Grant-Valkaria, FLA total loss of engine power for undetermined reasons.NTSB GAA21WA228Accident · Serious injuriesClass 3 · ForeignBritten Norman BN2A · Kuserua, EcuadorNTSB CEN21LA382Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Granbury, TXThe loss of engine power for reasons that could not be determined with the available information.NTSB GAA21WA212Accident · No injuriesClass 5 · ForeignPiper PA18 · Port Alfredsouth, South AfricaNTSB GAA21WA221Accident · Minor injuriesClass 5 · ForeignPilatus PC6 · Maturin, Venezuela