NTSB investigations
3,823 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 WPR12LA394Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3 · Healdsburg, CAThe loss of engine power during cruise flight due to the failure of the engine-driven fuel pump as a result of unidentified debris within the vapor return jet.NTSB WPR12LA392Accident · No injuriesLimited investigationFinal reportCessna 210 · Kemmerer, WYThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the incorrect installation of the fuel bladder tanks.NTSB ERA12CA546Accident · No injuriesData collectionFinal reportCessna 172M · Bardstown, KYThe flight instructor's decision to turn the fuel selector to the off position and his delayed remedial actions to restart the engine, which resulted in fuel starvation and a subsequent forced landing.NTSB CEN12LA587Accident · No injuriesLimited investigationFinal reportAviat A-1 · Rolla, NDThe pilot's failure to secure the right wing's fuel cap before the flight and to properly manage the available fuel supply during the flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN12FA586Accident · 2 fatalField investigationFinal reportPiper PA-23-150 · Canton, MOThe pilot's improper decision to attempt to execute a forced landing to an open field with obstacles. Contributing to the accident was the left engine’s total loss of power due to fuel starvation as a result of the introduction of air into the fuel system…NTSB WPR12LA373Accident · No injuriesLimited investigationFinal reportCessna P210 · Alturas, CAA loss of engine power due to fuel vaporization. Contributing to the accident was the pilot’s failure to use the auxiliary fuel pump when he noticed a degradation in the airplane’s climb performance.NTSB CEN12LA582Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Jim Falls, WIThe blockage of the right fuel tank vent, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR12CA370Accident · Minor injuriesData collectionFinal reportCessna 150G · Madera, CAThe pilot's mismanagement of the fuel supply, which resulted in fuel exhaustion.NTSB ERA12LA532Accident · Serious injuriesLimited investigationFinal reportMooney M20C · East Hampton, NYA loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any failures or malfunctions that would have precluded normal operation.NTSB ERA12FA526Accident · 1 fatalField investigationFinal reportBeech B24R · Dayton, VAThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the noninstrument-rated pilot's decision to attempt a visual flight rules flight in instrument meteorological conditions…NTSB ANC12LA093Accident · No injuriesLimited investigationFinal reportCessna U206D · Nikolai, AKThe total loss of engine power for reasons that could not be determined because the engine was not made available for examination.NTSB CEN12LA583Accident · No injuriesLimited investigationFinal reportCessna 150M · Arrow Rock, MOThe pilot's inadequate fuel management and in-flight decision making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA12TA515Accident · No injuriesFinal reportBell 206B · San Juan, PRThe crew’s inadequate preflight inspection and failure to monitor the fuel state during flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA12TA542Accident · No injuriesFinal reportRidge Lowell H Jabiru J230 · Otter Lake, NYA failure of an engine cylinder exhaust valve due to the buildup of lead deposits on the valve stem and fatigue cracking of the valve stem, resulting in a total loss of engine power, and the loss of the propeller. Contributing to the accident was the lack of…NTSB CEN12TA550Accident · No injuriesFinal reportMD Helicopter 369 · Columbus, OHThe failure of a 4th-stage turbine blade due to high-cycle fatigue, which resulted in the loss of engine power.NTSB ERA12FA508Accident · 2 fatalField investigationFinal reportBeech A36TC · Clifton Park, NYA total loss of engine power for reasons that could not be determined during the postaccident investigation and testing.NTSB WPR12CA358Accident · Serious injuriesData collectionFinal reportBoughner R 80 Tiger Moth · Ramona, CAThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ERA12LA509Accident · Serious injuriesLimited investigationFinal reportDestiny XLT 2000 · Grayson, GAThe non-certificated pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA12LA500Accident · No injuriesLimited investigationFinal reportBeech V35B · Effingham, SCThe pilot's failure to avoid an encounter with known adverse weather conditions, which resulted in an in-flight upset, temporary loss of control, and loading of the airframe, engine, and propeller that led to the in-flight separation of the propeller and the…NTSB CEN12LA543Accident · Serious injuriesLimited investigationFinal reportCross David L Glasair III · Westcliffe, COThe loss of oil pressure due to the failure of an oil filter gasket, which resulted in a total loss of engine power.NTSB CEN12WA640Accident · Serious injuriesForeign investigationPiaggio P149 · Hoogeveen, NetherlandsOn August 4, 2012, at 0945 coordinated universal time, a Piaggio P149D, Dutch registration D-EGIT, owned by a private individual and operated by the pilot, received substantial damage when it impacted terrain under unknown circumstances near Hoogeveen Airport…NTSB CEN12FA561Accident · No injuriesField investigationFinal reportSavage Air Epic LT · San Saba, TXThe improper installation of flexible fuel lines, which resulted in a partial collapse of the inner wall of the fuel lines and a subsequent a loss of engine power due to fuel starvation.NTSB CEN12FA520Accident · No injuriesField investigationFinal reportPiper PA-38-112 · Fate, TXA total loss of engine power for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA513Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor G-164A · La Salle, COThe loss of engine power due to the detached distributor rotor.NTSB CEN12LA501Accident · Serious injuriesLimited investigationFinal reportBeech H35 · Holly Lake Ranch, TXThe incomplete maintenance performed by maintenance personnel, which resulted in a total loss of engine power.NTSB ANC12LA080Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Gakona, AKThe pilot's improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB ANC12CA082Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Wainwright, AKThe failure of ground personnel to ensure the helicopter was serviced with the proper fuel. Contributing to the accident was the pilot's failure to monitor the fueling process.NTSB CEN12LA497Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Big Springs, NEThe total loss of engine power as a result of the pilot inadvertently shutting the engine off. Contributing to the accident was the modification to the engine control layout.NTSB CEN12LA512Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bragg City, MOThe pilot's failure to properly tighten the b-nut from the engine-driven fuel pump to the fuel-metering unit during maintenance, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA12LA489Accident · No injuriesLimited investigationFinal reportBeech A36TC · Fayetteville, NCThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA12LA486Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Blacksburg, VAThe pilot’s inadequate preflight planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ANC12FA079Accident · Minor injuriesField investigationFinal reportBeechcraft F33A · Fairbanks, AKThe total loss of engine power reason that could not be determined because postaccident examination and test run did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA474Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Westerly, RIA total loss of engine power for reasons that could not be determined due to the postaccident salt water-damaged state of the engine.NTSB ERA12LA480Accident · No injuriesLimited investigationFinal reportCessna A185F · Mapleton, METhe pilot’s improper fuel management, which resulted in fuel starvation and a total loss of engine power, and his use of an improper engine restart procedure.NTSB ERA12LA473Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Pickens, SCA total loss of engine power due to the failure of the crankshaft, which resulted from the application of insufficient torque on the cylinder through-bolts by maintenance personnel.NTSB WPR12LA318Accident · Serious injuriesLimited investigationFinal reportRepublic RC-3 · Snohomish, WALoss of engine power during takeoff 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 WPR12FA316Accident · Serious injuriesField investigationFinal reportCessna 182P · Corona, CAA loss of engine power shortly after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s decision to take off…NTSB ERA12LA470Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Farmingdale, NJThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR12LA315Accident · No injuriesLimited investigationFinal reportPiper PA-32S-300 · Adelanto, CAThe pilot’s failure to maintain directional control during the aborted takeoff, which was aborted due to fuel starvation as a result of an inadvertent in-flight activation of the fuel drain activation lever by the passenger. Contributing to the accident was…NTSB ERA12LA469Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Statesboro, GAA total loss of engine power as a result of oil exhaustion due to the mechanic's failure to apply appropriate torque to the oil filter.NTSB ERA12FA467Accident · 1 fatalField investigationFinal reportBrenholt Larry R RV-4 · Cedartown, GAThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions and his failure to maintain airspeed while maneuvering for a forced landing, which resulted in an aerodynamic stall and collision with terrain.NTSB CEN12LA491Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Fergus Falls, MNA total loss of engine power due to a cracked No. 2 cylinder head.NTSB CEN12LA460Accident · 1 fatalLimited investigationFinal reportChamberlain Gerald Escapade · Rutland, OHThe pilot’s inadequate fuel management, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the inadvertent stall during the pilot’s emergency landing and the pilot’s decision to continue flight in deteriorating…NTSB WPR12LA313Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Wells, NVA loss of engine power during the final landing approach for reasons that could not be determined because postaccident examination did not reveal any malfunctions or failures that would have precluded normal operation.NTSB ERA12LA468Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · North Myrtle Beach, SCA total loss of engine power due to carburetor icing.NTSB CEN12LA455Accident · No injuriesLimited investigationFinal reportCessna 175A · Shelby, ILThe loss of engine power due to oil starvation for reasons that could not be determined because engine examinations revealed no malfunctions or failures that would have led to oil starvation.NTSB ERA12FA458Accident · 1 fatalField investigationFinal reportBeech A23 · Laytonsville, MDThe pilot’s failure to ensure that the fuel selector handle was correctly positioned, which resulted in an interruption of fuel to the engine and a loss of engine power during the takeoff, which necessitated a turn away from the trees at the end of the runway…NTSB CEN12WA523Accident · No injuriesForeign investigationAir Tractor AT802 · San Rafael, SpainOn July 16, 2012, about 1430 coordinated universal time, a Spanish-registered Air Tractor AT-802 airplane, EC-HMD, performed a forced landing following a loss of engine power near San Rafael, Ibiza, Spain. The pilot, the sole occupant, was not injured. The…NTSB CEN12LA446Accident · No injuriesLimited investigationFinal reportSC Iar Sa Brasov IAR 825 · Peru, ILThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA12LA452Accident · Minor injuriesLimited investigationFinal reportAeronca 7CCM · Ocklawaha, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel exhaustion.