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 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 CEN24LA140Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · San Saba, TXA total loss of engine power due to multiple connecting rod failures from oil starvation.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.NTSB GAA24WA127Accident · Minor injuriesClass 5 · ForeignRobinson Helicopter 22 · Candoi, BrazilNTSB ERA24LA141Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Winokur, GAA total loss of engine power due to the unseating and subsequent failure of the No. 4 piston connection rod bushing.NTSB ERA24LA144Accident · No injuriesClass 3 · LimitedFinal reportGlasair Sportsman 2+2 · Fort Meade, FLThe pilot’s inadequate inspection of the airplane following an inflight smoke event, which result in separation of the exhaust pipe and hot exhaust igniting the engine cowling, and a subsequent loss of engine power.NTSB GAA24WA109Accident · Serious injuriesClass 5 · ForeignCessna 206 · Macas, EcuadorNTSB WPR24FA103Incident · No injuriesClass 3 · FieldFinal reportCirrus Design SR22T · Bellevue, WAA total loss of engine power due to a fatigue fracture of the crankshaft.NTSB GAA24WA113Accident · 2 fatalClass 5 · ForeignCessna 208B · Belo Horizonte, BrazilNTSB GAA24WA142AccidentClass 5 · ForeignRockwell Commander · Dortmond, GermanyNTSB ERA24LA151Accident · No injuriesClass 3 · LimitedFinal reportPalmetto Electronics X-AIR H · Ellenboro, NCA total loss of engine power due to an inoperative ignition system.NTSB GAA24WA106Accident · No injuriesClass 5 · ForeignBell 206 · Narsaq, GreenlandNTSB WPR24LA093Accident · Minor injuriesClass 3 · LimitedFinal reportBell 47G-3B-1 · Garey, CAMaintenance personnel’s failure to properly check the torque paint on a fuel control unit B-nut, which resulted in the loosening of the B-nut, a loss of engine power at a low altitude, and a subsequent impact with terrain.NTSB GAA24WA096Accident · No injuriesClass 5 · ForeignCessna 402 · Nassau, BahamasNTSB GAA24WA100AccidentClass 5 · ForeignBell 407 · Midrand, South AfricaNTSB GAA24WA089Accident · 1 fatalClass 5 · ForeignCessna 208 · Puerto Escondido, MexicoNTSB WPR24LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Goodyear, AZBearing degradation that increased clearances between the bearing and crankshaft journal surfaces, resulting in fatigue cracks and the subsequent failure of the No. 3 connecting rod and a total loss of engine power. Contributing to the accident was the…NTSB ERA24LA105Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Parkland, FLA catastrophic engine failure due to oil starvation to the main bearings for undetermined reasons.NTSB WPR24LA081Accident · Serious injuriesClass 3 · LimitedFinal reportChristopher Randall Raptor Junior 540 · Camarillo, CAA total loss of engine power due to the loss of power to the electronic fuel injection and ignition system, which was the result of a loose connection between a common ground feed-through stud and the ground bus.NTSB WPR24FA080Accident · 1 fatalClass 3 · FieldFinal reportSwanson R/Swanson S RV-6 · Concord, CAA total loss of engine power during takeoff due to a separated fuel line and the pilot’s subsequent failure to maintain control of the airplane. Contributing to the accident were the pilot's medical condition and the effects of multiple impairing substances.NTSB GAA24WA081Accident · Minor injuriesClass 5 · ForeignHughes 369 · Erharting, GermanyNTSB GAA24WA098AccidentClass 5 · ForeignPiper 31 · Tepic Nayarit, MexicoNTSB ERA24LA095Accident · No injuriesClass 3 · LimitedFinal reportCessna 210D · Paris, TNThe disruption of torque to the No 4 connecting rod journals, which resulted in a spun bearing and the subsequent total loss of engine power.NTSB GAA24WA073Accident · No injuriesClass 5 · ForeignBeech 35 · Murcott, United KingdomNTSB GAA24WA071AccidentClass 5 · ForeignCessna 182 · Quepos, Costa RicaNTSB WPR24LA074Accident · No injuriesClass 3 · LimitedFinal reportBeck Michael J Sonex · Auburn, WAWater contamination within the fuel regulator air-reference system, which resulted in improper fuel metering and a loss of engine power during initial climb.NTSB CEN24LA088Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter AS 350 B2 · Spofford, TXThe fatigue failure of the fuel control unit control lever arm, which resulted in fuel starvation, and a loss of engine power.NTSB CEN24LA092Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Dalhart, TXThe total loss of engine power due to carburetor icing and the pilot’s failure to utilize carburetor heat in meteorological conditions conducive to the formation of carburetor icing.NTSB WPR24LA070Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502A · Stratford, CAA partial loss of engine power due to the malfunction of the engine compressor bleed-off valve.NTSB GAA24WA066Accident · 4 fatalClass 3 · ForeignBellanca 17-30A · Bequia, St. Vincent & GrenadinesNTSB GAA24WA120Occurrence · No injuriesClass 5 · ForeignBeechcraft 400A · Tauá, BrazilNTSB CEN24LA079Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Davenport, IAThe fatigue failure of the No. 5 cylinder head, which resulted in a total loss of engine power. Contributing to the accident was the maintenance which did not fully blend to the depth necessary to preclude the failure.NTSB GAA24WA063AccidentClass 5 · ForeignCessna 172 · Buenos Aires, ArgentinaNTSB ERA24LA076Accident · No injuriesClass 3 · LimitedFinal reportBell Helicopter Textron 206L-1 · Walland, TNThe improper installation of the No. 8 bearing spanner nut, which resulted in the No. 8 bearing’s failure, and the subsequent total loss of engine power.NTSB GAA24WA077Accident · No injuriesClass 5 · ForeignVans RV6 · Smaalandsfarvandet, DenmarkNTSB GAA24WA059Accident · No injuriesClass 5 · ForeignPiper PA28 · Carmo da Cachoeira, BrazilNTSB WPR24LA060Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20J · Carlin, NVImproper spacing of the magneto’s breaker point contact assemblies, which led to a loss of engine ignition during cruise flight and resulted in a total loss of engine power.NTSB CEN24LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-23-250 · Forney, TXThe pilot's inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN24LA065Accident · Serious injuriesClass 3 · LimitedFinal reportBeech B36TC · Burnet, TXThe loss of engine power due an overly rich mixture from an improper adjustment of the fuel pump, which resulted in a forced landing and impact with a car and terrain.