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 GAA24WA224AccidentClass 5 · ForeignCessna 182 · La Paragua, VenezuelaNTSB GAA24WA230Accident · No injuriesClass 5 · ForeignCessna 182 · Vichy, FranceNTSB GAA24WA218AccidentClass 5 · ForeignCessna 188 · Payo, EcuadorNTSB WPR24LA248Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Ritzville, WAMaintenance personnel’s improper installation of the No. 2 cylinder exhaust valve, which allowed the valve to drop into the cylinder and resulted in a total loss of engine power.NTSB WPR24LA241Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Herriman, UTA hard landing following a total loss of engine power due to fuel starvation as a result of the improper idle setting of the helicopter’s engine. Contributing to the loss of engine power was the instructor’s reduction of engine power past that recommended by…NTSB WPR24LA240Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182B · Soldier, IDA total loss of engine power resulting from the failure of the No. 1 piston and the No. 2 piston connecting rod due to detonation.NTSB GAA24WA223Accident · Minor injuriesClass 5 · ForeignCessna 150 · Muriae, BrazilNTSB GAA24WA222Accident · No injuriesClass 5 · ForeignCessna P206 · Cozumel, MexicoNTSB GAA24WA212Accident · No injuriesClass 5 · ForeignPiper PA23 · Norman's Cay, BahamasNTSB WPR24LA224Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Harmony, WYA total loss of engine power as a result of the pilot's inadvertent placement of the fuel selector to the "off" position.NTSB GAA24WA207Accident · No injuriesClass 5 · ForeignSchweizer 269C · BeléM - Pará - Brasil, BrazilNTSB GAA24WA197Accident · Serious injuriesClass 5 · ForeignPiper PA34 · Whitby, Turks & Caicos IslandsNTSB GAA24WA199Accident · Minor injuriesClass 5 · ForeignCessna 182 · Torres, BrazilNTSB ENG24WA023Accident · 1 fatalClass 5 · ForeignCessna 208B · Spa, Belgium, BelgiumNTSB CEN24LA239Accident · No injuriesClass 3 · LimitedFinal reportThrush S2R · Hebron, NDForeign object debris in the Negative Torque Sensing (NTS) system check valve, which impeded the flow of oil to the NTS system and the propeller governor (PG) reset piston, resulting in a total loss of engine power and an off-airport forced landing.…NTSB GAA24WA191Accident · Serious injuriesClass 5 · ForeignBeech 35 · Gelnhausen, GermanyNTSB GAA24WA235AccidentClass 4 · ForeignAir Tractor AT502 · Apartado, ColombiaNTSB WPR24LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Roll, AZThe failure of the No. 2 intake valve due to inadequate seating, which resulted from valve guide-to-seat misalignment and associated wear.NTSB ERA24LA258Accident · Serious injuriesClass 3 · LimitedFinal reportClapp Saberwing · Valdosta, GAThe total loss of engine power due to the shearing of the woodruff key that indexed the crankshaft gear and hub assembly to the crankshaft, which resulted in the gear and hub rotating from their indexed position and caused the crankshaft-to-camshaft timing to…NTSB GAA24WA183Accident · No injuriesClass 5 · ForeignRobinson R44 · Aioi City, JapanNTSB GAA24WA190Accident · Minor injuriesClass 5 · ForeignCessna 152 · Juquitiba, BrazilNTSB GAA24WA186Accident · 2 fatalClass 5 · ForeignPiper PA46 · Sorriso, BrazilNTSB CEN24FA212Accident · 1 fatalClass 3 · FieldFinal reportBeech V35A · Arvada, COA total loss of engine power due to oil starvation as a result of loose turbocharger oil line fittings.NTSB GAA24WA208Accident · No injuriesClass 5 · ForeignCessna F152 · Maribor, SloveniaNTSB WPR24LA161Accident · Minor injuriesClass 3 · LimitedFinal reportAerospatiale SA315B · Hildale, UTMaintenance personnel’s failure to properly secure the EGT thermocouples, which resulted in catastrophic overtemperature of the engine and a total loss of engine power.NTSB ENG24WA018IncidentClass 5 · ForeignBoeing 737 · Ciudad Juarez, MexicoNTSB GAA24WA176Accident · 1 fatalClass 5 · ForeignZenair Unknown · Caceres, SpainNTSB ERA24LA222Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177 · Selma, ALInsufficient lubrication of the engine’s internal components, which resulted in a total loss of engine power.NTSB GAA24WA174Accident · Minor injuriesClass 5 · ForeignPiper PA25 · Lorenzo de Garaicoa, EcuadorNTSB GAA24WA161Accident · No injuriesClass 5 · ForeignPiper PA31 · Västerås, SwedenNTSB ERA24LA203Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Louisburg, NCThe pilot under instruction’s inadvertent use of the mixture control, which resulted in a total loss of engine power.NTSB WPR24LA135Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 17-31ATC · El Cajon, CAMaintenance personnel’s improper installation of an engine-driven vacuum pump, which resulted in oil starvation to the engine and a subsequent total loss of engine power. Contributing to the accident was the A&P IA’s lack of supervision.NTSB ERA24LA195Accident · No injuriesClass 4 · LimitedFinal reportReddick Jonathan L Zodiac 601XLB · Dunbar, PAA total loss of engine power as a result of an improperly fabricated fuel-air mixture cable bracket. Contributing was the pilot’s decision to fly the airplane with a known mechanical engine issue, and the presence of another airplane that was back taxiing on…NTSB WPR24FA132Accident · 1 fatalClass 3 · FieldFinal reportBell 206-L4 · Anaconda, MTA total loss of engine power due to a loss of cooling oil to the turbine-to-compressor coupling shaft and subsequent fracture of the shaft at an altitude too low for the pilot to complete a successful autorotation. Contributing to the accident was carbon…NTSB GAA24WA150Accident · Minor injuriesClass 5 · ForeignCessna 208 · Gap-tallard, FranceNTSB ERA24LA201Accident · No injuriesClass 4 · LimitedFinal reportStinson 108 · Beach City, OHA total loss of engine power due to the due to the pilot’s delayed application of carburetor heat.NTSB ANC24LA027Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Marana, AZA total loss of engine power due to a failure of the No. 4 cylinder piston boss.NTSB CEN24LA155Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-301 · Sullivan, MOA bearing failure that resulted in fatigue failure of the crankshaft and a subsequent total loss of engine power.NTSB GAA24WA140Accident · No injuriesClass 3 · ForeignBell 407 · Chicureo, ChileNTSB GAA24WA139AccidentClass 5 · ForeignAir Tractor AT401 · Zona rural, Washington, Córdoba, ArgentinaNTSB GAA24WA137Accident · Minor injuriesClass 5 · ForeignPiper PA28 · Guatemala City, GuatemalaNTSB CEN24LA152Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Galveston, TXMaintenance personnel’s failure to properly secure the oil filter adapter when replacing the oil filter adapter gasket which resulted in the filter becoming loose, resulting in the loss of engine oil, and the subsequent total loss of engine power.NTSB GAA24WA135Accident · No injuriesClass 5 · ForeignCessna 152 · Balneario Laguna de Gómez, ArgentinaNTSB ERA24FA160Accident · 1 fatalClass 3 · FieldFinal reportArthur B Canning Merlin Lite · Mulberry, FLThe pilot/builder’s modifications of the motorglider’s engine, which resulted in an excessively lean fuel air mixture, preignition, piston failure, and a subsequent total loss of engine power during the initial climb. Contributing to the outcome was the…NTSB ERA24LA159Accident · Serious injuriesClass 3 · LimitedFinal reportDta Voyager II 912S · Clermont, FLLack of lubrication of the No. 4 connecting rod bearing, which resulted in a total loss of engine power.NTSB CEN24LA141Accident · No injuriesClass 3 · LimitedFinal reportCozy Mark IV · Gonzales, TXMaintenance personnel’s failure to properly torque the crankshaft idler gear hardware according to the engine manufacturer’s service instructions, which resulted in separation of the crankshaft idler gear’s fasteners and disengagement of the camshaft,…NTSB GAA24WA146AccidentClass 5 · ForeignCessna 182 · Manuel Urbano, BrazilNTSB GAA24WA121Accident · 1 fatalClass 5 · ForeignRans S12 · Tabacundo, EcuadorNTSB GAA24WA116Accident · No injuriesClass 5 · ForeignCessna U206 · Waramasen Indigenous Community, VenezuelaNTSB ERA24LA143Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Blackshear, GAA catastrophic engine failure due to oil starvation, which resulted in a total loss of engine power.