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 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 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 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 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 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.NTSB CEN24FA057Accident · 2 fatalClass 3 · FieldFinal reportBeech A23-24 · Oklahoma City, OKA total loss of engine power due to multiple connecting rod failures from oil starvation associated with an extensive before takeoff oil system leak, the source of which could not be identified due to postaccident fire damage.NTSB GAA24WA048AccidentClass 5 · ForeignEnstrom 280 · Madrid, SpainNTSB CEN24LA052Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Manitowoc, WIMaintenance personnel’s improper servicing of the magnetos, which resulted in their accelerated wear, failure, and the total loss of engine power.NTSB GAA24WA046Accident · Serious injuriesClass 5 · ForeignCessna 170 · Quebec, CanadaNTSB GAA24WA045Accident · Minor injuriesClass 5 · ForeignCessna 172 · Vera Cruz, BrazilNTSB GAA24WA041Accident · No injuriesClass 4 · ForeignPiper 32 · Mhlambanyatsi, WZNTSB WPR24LA041Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · Brawley, CAA total loss of engine power due to the failure of the No. 8 bearing and the subsequent failure of the scavenge oil pump.NTSB GAA24WA037Accident · No injuriesClass 5 · ForeignMaule M5 · Spanish Wells, Eleuthera, BahamasNTSB ERA24LA043Accident · Minor injuriesClass 3 · LimitedFinal reportLancair IV · Perry, FLA rapid throttle advancement after a period of idling, which resulted in a flooded engine and total loss of engine power.NTSB GAA24WA035AccidentClass 5 · ForeignCessna 152 · Licab Zaragosa, PhilippinesNTSB ENG24WA004IncidentClass 5 · ForeignBoeing 787 · Addis Ababa, EthiopiaNTSB GAA24WA024Accident · 4 fatalClass 3 · ForeignRobinson R44 · Cirque de Salazie, RéunionNTSB GAA24WA029Accident · Minor injuriesClass 3 · ForeignTecnam P2008 · Baramati, IndiaNTSB ERA24LA018Accident · No injuriesClass 3 · LimitedFinal reportRoth Frank Ronald Avid Aircraft · Knoxville, TNA total loss of engine power due to a seized piston in the power take-off cylinder.NTSB CEN24LA004Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Hochatown, OKA total loss of engine power during a practice autorotation due to the improper engine idle setting and rigging of the carburetor heat control which resulted in a hard landing.NTSB GAA23WA279Accident · No injuriesClass 5 · ForeignHughes 369 · Middlesmoor, United KingdomNTSB CEN23LA418Accident · Minor injuriesClass 3 · LimitedFinal reportBeech C23 · Gonzales, TXThe loss of engine power during go-around due to a failed muffler flame tube, which resulted in an exhaust blockage. Contributing to the accident was maintenance personnel's inadequate inspection of the exhaust system during the most recent maintenance.NTSB GAA23WA270Accident · Serious injuriesClass 5 · ForeignCessna 172 · Monacalieri, ItalyNTSB GAA23WA258Accident · No injuriesClass 5 · ForeignCessna 205 · La Paragua, Venezuela