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 WPR10LA180Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Terry, MTThe pilot's failure to maintain directional control during the landing roll in gusting winds. Contributing to the accident was a loss of engine power on final approach due to fuel exhaustion as a result of the pilot having to divert due to deteriorating…NTSB ERA10LA189Accident · No injuriesLimited investigationFinal reportCessna 120 · Annapolis, MDA loss of engine power for undetermined reasons.NTSB ERA10LA184Accident · No injuriesLimited investigationFinal reportCessna 150L · Lake Alfred, FLA loss of engine power during the landing approach for undetermined reasons.NTSB CEN10LA171Accident · No injuriesLimited investigationFinal reportLoehr Thomas H Zenith Stol CH701 · Eldon, MOA loss of engine thrust during takeoff due to the failure of the engine-to-propeller drive belts as a result of improper belt tension. Contributing to the accident was the non-certificated pilot's improper preflight inspection.NTSB WPR10FA163Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Morton, WAThe failure of maintenance personnel to properly secure a fitting cap on the throttle and metering assembly inlet after conducting a fuel system pressure check, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was…NTSB ERA10LA179Accident · No injuriesLimited investigationFinal reportFerguson William C FX4-2 · Cartersville, GAThe failure of the engine-driven oil pump drive coupling resulting in a loss lubrication and subsequent loss of engine power.NTSB CEN10LA168Accident · No injuriesLimited investigationFinal reportCessna 182G · Mount Vernon, MOA loss of engine power due to the failure of the number four connecting rod for undetermined reasons.NTSB WPR10LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Eliza Island, WAThe total loss of engine power during cruise flight due to the failure of maintenance personnel to tighten a fitting on the propeller governor oil line, which resulted in a loss of engine oil and catastrophic engine failure.NTSB ANC10LA024Accident · No injuriesLimited investigationFinal reportCessna A185E · Ophir, AKThe total loss of engine power for an undetermined reason.NTSB WPR10LA154Accident · No injuriesLimited investigationFinal reportSutton Avid Hauler · Rigby, IDA loss of engine power during takeoff for undetermined reasons.NTSB ANC10LA020Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Delta Junction, AKA total loss of engine power in flight for undetermined reasons.NTSB CEN10LA140Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Slaton, TXThe loss of engine power due to the insufficient clamping force between the two crankcase halves and each cylinder to the crankcase.NTSB WPR10LA150Accident · Serious injuriesLimited investigationFinal reportMuffett Quickslvr Sprnt II · Buena, WAA loss of engine power due to fuel exhaustion as a result of the student pilot’s inadequate fuel planning.NTSB ERA10LA159Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Arcadia, FLThe total loss of engine power due to a fatigue fracture of the crankshaft resulting from worn bearings.NTSB CEN10LA131Accident · No injuriesLimited investigationFinal reportLacour Long-EZE SR7-1 · Falfurrias, TXA total loss of engine power due to a failure of the crankshaft behind the No. 3 connecting rod journal for undetermined reasons.NTSB WPR10LA149Accident · Minor injuriesLimited investigationFinal reportSchafer Starduster SA-300 · North Bend, ORThe complete loss of engine power during cruise for undetermined reasons.NTSB ERA10FA150Accident · 2 fatalField investigationFinal reportBeech C23 · Winter Haven, FLThe pilot’s improper placement of the fuel selector valve during takeoff, and his failure to maintain adequate airspeed following a total loss of engine power resulting in an inadvertent stall. Contributing to the accident was the failure of maintenance…NTSB ERA10FA148Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Springfield, KYThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion, and the pilot's impairment due to alcohol. Contributing to the accident was the Federal Aviation Administration's failure to adequately oversee…NTSB ERA10LA146Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Carthage, NCA total loss of engine power during the initial climb after takeoff for undetermined reasons.NTSB CEN10LA136Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · La Porte, TXA loss of engine power for undetermined reasons.NTSB ANC10TA017Accident · No injuriesFinal reportPiper PA-18-150 · King Cove, AKA total loss of engine power due to the pilot's failure to use carburetor heat in conditions conducive to carburetor ice.NTSB ERA10FA138Accident · 1 fatalField investigationFinal reportBeech 65 · Lawrenceville, GAThe failure of both engines for undetermined reasons.NTSB WPR10LA130Accident · Minor injuriesLimited investigationFinal reportNanchang China CJ-6A · Mesa, AZSeparation of the cylinder from the engine during cruise flight due to fatigue in the studs attaching it to the engine casing.NTSB ERA11WA269Incident · No injuriesForeign investigationEmbraer EMB-202 · Guarau, BrazilOn January 28, 2010, about 1030 coordinated universal time, an Embraer EMB-202, Brazilian registration PT-UPW, had a reported loss of power during cruise and landed in a soybean field near Guarau, Santa Catarina, Brazil. The pilot was not injured And the…NTSB WPR10LA118Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Reno, NVA total loss of engine power during cruise due to oil starvation as a result of foreign material blockage of the oil pickup tube.NTSB ERA10WA340Accident · Minor injuriesForeign investigationRobinson R44 · San Felipe, ChileOn January 21, 2010, at 2210 universal coordinated time, a Robinson R44 helicopter, Chilean registration CC-PSZ, experienced a loss of engine power while in cruise flight, and was substantially damaged during a subsequent forced landing, in San Felipe, Chile.…NTSB ERA10FA115Accident · 2 fatalField investigationFinal reportBeech B-60 · Madison, ALThe pilot's failure to divert to the nearest suitable airport following a total loss of power in the right engine during cruise flight. Contributing to the accident was the total loss of power in the right engine due to separation of its No. 2 cylinder as a…NTSB WPR10LA111Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Napa, CAA loss of engine power due to fuel starvation as a result of the unintentional movement of the fuel selector valve beyond its stops during takeoff initial climb resulting in restricted fuel flow.NTSB WPR10GA102Accident · Serious injuriesFinal reportHughes 369D · Kooskia, IDA complete loss of engine power due to the failure of the No. 2 bearing, which was precipitated by electrical arcing that occurred at an unknown time prior to the accident flight.NTSB CEN10LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Alexandria, LAA loss of engine power for undetermined reasons.NTSB ERA10LA102Accident · 1 fatalLimited investigationFinal reportDavis Michael J Longez · Dexter, KYThe loss of engine power due to the chaffing and grounding of the single magneto's ignition lead.NTSB CEN10LA078Accident · Serious injuriesLimited investigationFinal reportBell Helicopter Textron Canada 407 · Decatur, TXThe pilot's inadequate preflight inspection and the momentary loss of engine power due to snow or ice ingestion.NTSB ERA10LA100Accident · No injuriesLimited investigationFinal reportFpna A-22 Valor · Hunting Island, SCMaintenance personnel's inadequate inspection of the oil system's fittings during a routine oil servicing, which resulted in oil starvation due to a loose and/or detached oil line B-nut fitting that led to the engine seizing while in flight.NTSB WPR10LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Corona, CAA loss of engine power for undetermined reasons.NTSB WPR10FA085Accident · Serious injuriesField investigationFinal reportEurocopter AS350BA (FX2) · Hana, Maui, HIAn uncommanded engine shutdown due to an improperly calibrated fuel control unit (FCU) and power turbine governor (PTG). Also causal was the operator’s inadequate maintenance practices and procedures that failed to properly assess and correct the FCU and PTG…NTSB WPR10LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAA total loss of engine power for undetermined reasons.NTSB ERA10IA094Incident · No injuriesIncident investigationFinal reportCessna 208B · Rome, NYThe operator's inadequate engine wash intervals, which resulted in compressor turbine blade sulphidation and subsequent turbine blade failure.NTSB ERA10LA084Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Hillsboro Beach, FLA total loss of engine power for undetermined reasons.NTSB ERA10WA081Accident · Serious injuriesForeign investigationCessna A-188B · Quevedo, EcuadorOn November 25, 2009, a Cessna A-188B, Ecuadorian registration HC-CEU, registered to and operated by Russagrif, impacted terrain in the Los Rios Provenance following a loss of engine power, immediately after takeoff. The pilot sustained serious injuries and…NTSB ERA10WA416Accident · No injuriesForeign investigationEmbraer EMB-720 · Fazenida Liberdade, Brazil, BrazilOn November 23 18, 2009, about 1440 Universal Coordinated Time (UTC), an Embraer EMB-720D, Brazilian registration PT-VIF, operated by W.P.Comercio De Cereais LTDA, collided with a fence as a result of a force landing from a loss of engine power during cruise…NTSB ERA10FA074Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Wappinger, NYA total loss of engine power due to a delamination of the No. 3 connecting rod bearing. Contributing to the accident was the inadequate maintenance inspection of the engine oil system.NTSB CEN10CA060Accident · No injuriesData collectionFinal reportBoeing B75N1 · St. Louis, MOA loss of engine power for undetermined reasons.NTSB WPR10LA063Accident · 1 fatalLimited investigationFinal reportBudd Lancair Legacy · Watsonville, CAA loss of engine power due to oil starvation and the pilot's failure to maintain airspeed while approaching the landing area resulting in an aerodynamic stall, rapid descent, and collision with terrain.NTSB ERA10LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hammonton, NJA total loss of engine power due to a blocked fuel vent.NTSB CEN10IA059Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Elk Mound, WIThe loss of engine power due to component failure from excessive heating of the engine connecting rod journals.NTSB WPR10LA053Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Chico, CAA loss of engine power during final approach for undetermined reasons.NTSB ERA10LA053Accident · No injuriesLimited investigationFinal reportHughes 369 · Baxley, GAA loss of engine power due to fuel starvation resulting from the pilot’s inadequate preflight inspection of the main fuel valve position.NTSB CEN10LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Coldwater, MIA loss of engine power due to the separation of the No. 4 piston connecting rod as a result of inadequate torque of the connecting rod bolt.NTSB CEN10LA036Accident · Serious injuriesLimited investigationFinal reportBell 206 · High Island A-442AA total loss of engine power due to maintenance personnel's failure to correctly torque the Pc line following removal and reinstallation of the turbine module.NTSB CEN10FA029Accident · 1 fatalField investigationFinal reportBeech A36TC · Kalamazoo, MIThe loss of engine power for an undetermined reason.