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 ERA13LA127Accident · Minor injuriesLimited investigationFinal reportHiller UH-12B · Merritt Island, FLA total loss of engine power due to fuel starvation, which resulted from an overstress failure of a fitting on the fuel supply line and led to an autorotation and hard landing.NTSB ERA13LA126Accident · No injuriesLimited investigationFinal reportMccowan Steve A Shttd · Montrose, GAA total loss of engine power during cruise flight due to the separation of the No. 2 piston connecting rod.NTSB WPR13LA113Accident · No injuriesLimited investigationFinal reportCessna 172 · Wilcox, AZThe loss of engine power for reasons that could not be determined because postaccident examination did not reveal any abnormalities that would have precluded normal operation.NTSB WPR13LA109Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Bountiful, UTA total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA152Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Victoria, TXThe mechanical failure of the engine power section, which resulted in a loss of engine power.NTSB CEN13CA145Accident · No injuriesData collectionFinal reportHughes 369HS · London, OHThe pilot's failure to comply with established cold weather operating procedures, which resulted in a total loss of engine power. Contributing to the accident was the pilot's excessive aft cyclic input during the landing flare, which resulted in main rotor…NTSB WPR13LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Atwater, CAThe student pilot's inadequate flight planning, which resulted in his getting lost and not being able to return to the airport before the fuel was exhausted and the engine lost power.NTSB ERA13LA119Accident · Serious injuriesLimited investigationFinal reportShoemaker James B KR-2 · Palmetto, FLThe total loss of engine power for undetermined reasons, which resulted in a forced landing.NTSB WPR13LA098Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Marysville, CAA total loss of engine power during initial climb due to fuel starvation, which resulted from maintenance personnel’s improper installation of the fuel selector handle. Contributing to the accident was an incorrectly modified fuel selector handle assembly.NTSB ERA13LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Winder, GAA total loss of engine power due to a cracked fuel pump line fitting O-ring seal at the inlet to the engine driven fuel pump. Contributing to the accident was the failure of the aircraft operator to comply with the engine manufacturer’s recommended time…NTSB ERA13LA112Accident · No injuriesLimited investigationFinal reportCessna T182 · Brandon, FLFailure of the No. 2 cylinder’s rod bearing, which resulted in a total loss of engine power.NTSB WPR13LA085Accident · Minor injuriesLimited investigationFinal reportJeremiah Jackson Vans RV-10 · Julian, CAA loss of engine power due to oil starvation as a result of a disconnected oil line. Contributing to the accident was an insufficiently tightened oil line fitting.NTSB ERA13FA105Accident · 3 fatalField investigationFinal reportBeech H35 · Palm Coast, FLA total loss of engine power after the failure of the No. 4 connecting rod due to oil starvation, which resulted in a subsequent forced landing. Contributing to the accident was the pilot’s failure to clearly state that the aircraft had lost all power and the…NTSB CEN13FA121Accident · Serious injuriesField investigationFinal reportEurocopter EC130 B4 · Seminole, OKThe loss of engine power due to ice ingestion. Contributing to the accident was maintenance personnel’s delayed decision to install the helicopter's engine inlet cover until after the engine had been exposed to moisture and freezing temperatures and their…NTSB WPR13LA078Accident · No injuriesLimited investigationFinal reportCessna 210A · Chandler, AZA loss of engine power during takeoff climb for reasons that could not be determined because postaccident examination and testing of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN13LA118Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mc Allen, TXA loss of engine power due to carburetor icing.NTSB ERA13FA096Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Leesburg, FLThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and a subsequent total loss of power in both engines during cruise flight. Contributing to the accident was the pilot’s use of prescription and illicit drugs, which likely impaired…NTSB ERA13LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Boca Raton, FLThe pilot's improper landing flare after a loss of engine power shortly after takeoff, which resulted in a hard landing. The reason for the loss of engine power could not be determined based on the available information.NTSB ERA13LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Lock Haven, PAThe reinstallation of improper connecting rods at engine overhaul, which resulted in abnormal wear of the connecting rod bearings; while the bearings did not meet the manufacturer’s specifications, the use of the unapproved connecting rods more likely caused…NTSB CEN13LA110Accident · Minor injuriesLimited investigationFinal reportBeech 95-B55 (T42A) · Las Cruces, NMThe pilot's failure to properly manage the airplane's fuel, which resulted in engine failure due to fuel starvation.NTSB CEN13LA111Accident · No injuriesLimited investigationFinal reportPiper L-18C · Graham, TXThe failure of an engine connecting rod and the subsequent loss of oil pressure, which resulted in a total loss of engine power.NTSB ERA13LA084Accident · Minor injuriesLimited investigationFinal reportMerritt Leslie R Kelly D · Brandon, MSA total loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA097Accident · Minor injuriesLimited investigationFinal reportNorth American T-28C · Moody, TXThe total loss of engine power for reasons that could not be determined because the examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA104Accident · No injuriesLimited investigationFinal reportCessna 172M · Arcola, TXThe loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA099Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Abilene, TXThe flight instructor's failure to conduct an autorotation following the loss of engine power due to fuel exhaustion. Contributing to the accident was the failure of the flight instructor and the student pilot to visually check fuel levels to ensure adequate…NTSB CEN13LA091Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Halfway, MOThe pilot's failure to properly maintain the airplane and engine, which resulted in a total loss of engine power due to improperly installed magnetos and a broken camshaft.NTSB CEN13FA080Accident · Minor injuriesField investigationFinal reportCessna 208B · Bryans Corner, OKThe total loss of engine power as a result of a fractured compressor turbine blade due to fatigue cracking.NTSB CEN13LA076Accident · No injuriesLimited investigationFinal reportCessna 177RG · Lansing, MIA loss of engine power due to the loss of fuel flow through the airplane's fuel tank selector valve.NTSB WPR13LA052Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Van Nuys, CAA partial loss of engine power during cruise flight due to fatigue fractures of two crankshaft gear teeth from corrosion pitting, which resulted in an off-airport forced landing and collision with obstacles on the ground.NTSB CEN13LA072Accident · Serious injuriesLimited investigationFinal reportBeech S35 · DeRidder, LAA total loss of engine power due to oil starvation after the oil filler cap separated from the oil filler tube during flight due to corrosion. Contributing to the accident was the pilot's failure to maintain airspeed during low altitude operations, which…NTSB WPR13LA047Accident · No injuriesLimited investigationFinal reportCessna 210 · San Rafael, CAThe loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA063Accident · 1 fatalLimited investigationFinal reportRedd Tom Quicksilver GT 400 · Oak Grove, LAThe total loss of engine power, the specific cause of which could not be identified during the postaccident examination, and the airplane’s subsequent impact with trees.NTSB ERA13LA053Accident · No injuriesLimited investigationFinal reportCessna 210 · Jasper, GAA loss of engine power due to fuel starvation as a result of the pilot’s prolonged sideslip maneuvers during the descent to landing. Contributing to the accident was the airplane’s lack of a required placard advising pilots to avoid lengthy sideslip maneuvers…NTSB CEN13LA056Accident · Minor injuriesLimited investigationFinal reportCessna 210L · La Grange, TXThe total loss of engine power due to the loss of oil to the engine. Contributing to the accident was maintenance personnel’s improper installation of the engine oil filter adaptor, which resulted in the loss of oil to the engine.NTSB CEN13LA055Accident · Serious injuriesLimited investigationFinal reportCentral Ohio Dragonfly Club DRAGONFLY-C · Darbyville, OHThe total loss of engine power due to a cold-seizure event that occurred at a low altitude, which precluded the pilot's recovery from an inadvertent aerodynamic stall/spin.NTSB ANC13LA008Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Kenai, AKThe loss of engine power due to carburetor icing and the pilot's failure to apply carburetor heat when he reduced engine power.NTSB ERA13WA050Accident · Serious injuriesForeign investigationCessna 206 · Kiim, EcuadorOn October 31, 2012, about 1545 coordinated universal time (1045 local time), a Cessna 206, Ecuadorian registration HC-CBG, was substantially damaged during a forced landing in Kiim, Ecuador. The Ecuadorian commercial pilot was seriously injured. The airplane…NTSB ERA13LA029Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Edison, GAThe total loss of engine power due to the fatigue failure of the k-pin associated with the No. 1 cylinder.NTSB WPR13LA015Accident · No injuriesLimited investigationFinal reportBeech N35 · Phoenix, AZA loss of engine power due to oil starvation due to loose oil cooler attachment bolts. Contributing to the accident was inadequate maintenance during the annual inspection.NTSB CEN13LA015Accident · Serious injuriesLimited investigationFinal reportYoung Robert Herman Woody Pusher · Cloverdale, INThe total loss of engine power due to carburetor icing.NTSB WPR13LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Corona, CATotal loss of engine power during the landing approach due to insect debris in the carburetor metering valve, which resulted in fuel starvation.NTSB ERA13TA021Accident · Minor injuriesFinal reportBell OH-58A · Jackson, TNA loss of engine power for undetermined reasons because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA011Accident · No injuriesLimited investigationFinal reportMeyers Little Toot · Roanoke, TXThe total loss of engine power due to partially obstructed fuel lines.NTSB WPR13LA005Accident · Minor injuriesLimited investigationFinal reportCessna 180H · St Maries, IDThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.NTSB CEN13IA008Incident · No injuriesIncident investigationFinal reportMueller Michael Walter Challenger II CW SPC · Sandwich, ILA total loss of engine power due to significant engine corrosion. Contributing to the accident was inadequate engine maintenance.NTSB ERA13WA085Accident · No injuriesForeign investigationThrush S2R-T34 · Naranjal, EcuadorOn October 2, 2012, a Thrush S2R-T34, Ecuadorian registration HC-CFU, operated by a private owner, was substantially damaged following an engine failure and collision with terrain near Naranjal Province, Guayas, Ecuador. The flight's last departure point and…NTSB ERA12LA584Accident · 1 fatalLimited investigationFinal reportKeuthan Buccaneer II · Granite Quarry, NCThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN12LA667Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Heli 369FF · Decorah, IAThe pilot's failure to properly manage the helicopter's available fuel supply, which led to a total loss of engine power due to fuel exhaustion. Contributing to the accident was the improper calibration of the fuel gauge and the fuel-low warning light.NTSB WPR12LA439Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eugene, ORA total loss of engine power due to fuel exhaustion during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have resulted in the loss of engine power.NTSB CEN12LA675Accident · No injuriesLimited investigationFinal reportBeech E33 · Greeley, COThe loss of engine power for reasons that could not be determined during postaccident examinations and testing.