NTSB investigations
5,891 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353) 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 NYC95LA116Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Taunton, MAthe failure of the pilot to monitor his fuel supply, which resulted in a power loss due to fuel exhaustion, and a forced landing in rough terrain.NTSB CHI95LA154Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Kalkaska, MIFuel exhaustion due to the pilot's poor preflight and inflight planning and decisions. Factors were the powerlines and the inadvertent stall.NTSB MIA95LA130Accident · No injuriesLimited investigationFinal reportCessna 172G · Sanford, FLThe pilot's failure to maintain airspeed during a forced landing resulting in an inadvertent stall and subsequent in-flight collision with terrain. Contributing to the accident was a total loss of engine power while descending due to fuel exhaustion, and the…NTSB ATL95LA097Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Franklin, TNThe pilot's improper use of the throttle which resulted in the loss of engine power. The pilot also failed to follow emergency procedures to restart the engine.NTSB FTW95LA202Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Joes, COA total loss of power due to fuel exhaustion. Factors were: a malfunction in the fuel measuring system, the pilot's failure to perform fuel consumption calculations, and soft and unsuitable terrain for a forced landing.NTSB SEA95LA098Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Vancouver, WACarburetor heat was not used and aircraft control was not maintained. Factors to the accident were: the flight instructor's diverted attention, and carburetor icing conditions.NTSB CHI95FA149Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · North Loup, NEFailure to the student pilot to maintain control of the airplane during a forced landing, after experiencing fuel starvation due to fuel mismanagement. Factors relating to the accident were: inadequate oversight (supervision) by the flight instructor (CFI),…NTSB SEA95LA096Accident · No injuriesLimited investigationFinal reportCessna A185F · Oroville, WAWater contamination in the fuel, and the pilot's inadequate preflight of the aircraft before flight. Factors related to the accident were: deteriorated seal(s) on the fuel tank cap(s), non-compliance with an airworthiness directive to prevent water leaking…NTSB MIA95LA126Accident · Serious injuriesLimited investigationFinal reportFocke-Wulf FWP 149D · St. Augustine, FLInadequate fuel management by the pilot-in-command resulting in the total loss of engine power due to fuel starvation. Contributing to the accident was the unsuitable terrain encountered during the emergency descent for the forced landing.NTSB NYC95LA098Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Columbus, OHthe pilot's inadequate preflight of the airplane's fuel quantity, resulting in a complete loss of engine power due to fuel exhaustion, and the subsequent night forced landing and collision with the terrain.NTSB MIA95LA123Accident · Serious injuriesLimited investigationFinal reportBeech B95 · Leakesville, MSThe failure of the pilot-in-command to operate the aircraft in accordance with manufacturer's limitations resulting in fuel starvation and a total loss of power in both engines.NTSB CHI95LA136Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Springfield, MOThe student pilot's failure to refuel the airplane. The student pilot's inadequate fuel consumption calculations were a related factor.NTSB FTW95LA180Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Mcgehee, ARThe pilot intentionally shutting down the airplane's engine. A factor was the pilot's improper maintenance procedures.NTSB MIA95FA117Accident · Serious injuriesField investigationFinal reportBeech 95-B55 · Plant City, FLInadequate maintenance and inspection, and the pilot's failure to attain VMC.NTSB LAX95LA170Accident · No injuriesLimited investigationFinal reportCessna 180 · Los Banos, CAfuel exhaustion due to the pilot's inadequate preflight planning and preparation.NTSB SEA95LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Tacoma, WAFuel starvation due to an unlocked mixture control that had not been properly rigged. A factor was the ditch in the emergency landing area.NTSB CHI95LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Rock Falls, ILthe failure of the pilot to refuel prior to fuel exhaustion. A factor in the accident was the pilot's poor preflight planning/preparation.NTSB FTW95LA175Accident · No injuriesLimited investigationFinal reportBriggs Glasair III · Crescent, OKTotal non-mechanical power loss due to a fuel system vapor lock. A factor was the uneven terrain on which the forced landing was made.NTSB LAX95LA163Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Yolo, CAthe pilot's improper preflight preparation which led to fuel exhaustion.NTSB MIA95LA109Accident · No injuriesLimited investigationFinal reportCessna 172H · Hattiesburg, MSThe pilot-in-command's improper use of carburetor heat during descent, resulting in a total loss of engine power due to carburetor icing, and subsequent forced landing to unsuitable terrain.NTSB SEA95LA081Accident · No injuriesLimited investigationFinal reportCessna 180D · Nyssa, ORFuel exhaustion due to the pilot's failure to refuel en route.NTSB MIA95FA107Accident · 2 fatalField investigationFinal reportBeech 55-E55 · Daytona Beach, FLThe failure of the pilot-in-command to manage the fuel available in flight by improperly selecting the fuel selectors to fuel available in other tanks, resulting in both engines losing power. Contributing to the accident was the lack of suitable terrain for…NTSB MIA95LA106Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Lauderdale, FLThe inadequate preflight planning by the pilot-in-command to assure that adequate fuel was on-board the airplane to complete the flight, which resulted in a loss of engine power, forced landing and the collision with a tree on touchdown.NTSB MIA95FA105Accident · 1 fatalField investigationFinal reportPackard/Squire RV-4 · Davie, FLEngine fuel starvation due to the pilot's fuel mismanagement. A loss of control followed as the pilot inadvertently stalled the airplane while maneuvering for the forced landing.NTSB FTW95LA164Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marlin, TXFuel exhaustion engine power loss due to the pilot's failure to refuel. Factors were the lack of suitable terrain available for the forced landing and the dark night condition.NTSB MIA95LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Laurel, MSThe failure of the pilot-in-command to refuel the aircraft resulting in loss of engine power due to fuel exhaustion.NTSB FTW95LA160Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Orange, TXThe pilot's delayed landing flare. Factors were fuel exhaustion due to the pilot's failure to stop and refuel.NTSB NYC95LA082Accident · No injuriesLimited investigationFinal reportCessna 150G · Dayton, OHthe pilot's inadequate preflight and inflight planning, resulting in fuel exhaustion and loss of engine power, and the subsequent nose over during a forced landing.NTSB BFO95LA039Accident · Serious injuriesLimited investigationFinal reportPiper J3-C65 · Bayport, NYThe pilot's improper positioning of the fuel selector.NTSB FTW95LA146Accident · No injuriesLimited investigationFinal reportHughes 369HS · Burnet, TXFailure by the pilot-in-command to maintain rotor RPM during the autorotation and his delayed flare. A factor was: the pilot's failure to use the fuel boost pump while using aviation gasoline vice jet fuel.NTSB ATL95LA070Accident · No injuriesLimited investigationFinal reportRoggio Rotorway Executive · Toccoa, GAThe pilot's failure to use carburetor heat which resulted in the loss of engine power. A factor was weather conditions favorable for the formation of carburetor ice.NTSB ATL95LA066Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Cleveland, TNThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion during the final approach for landing.NTSB MIA95FA089Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Staley, NCThe pilot's failure to maintain airspeed (VSO) while maneuvering during a forced landing, resulting in an in-flight loss of control (inadvertent stall), and subsequent in flight collision with terrain. Contributing to the accident was the pilot's inadequate…NTSB FTW95LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Devine, TXA power loss due to the inadvertent opening of an unapproved quick oil drain installed by maintenance personnel. A factor was the lack of suitable terrain for the forced landing.NTSB LAX95LA138Accident · No injuriesLimited investigationFinal reportBell 47 · Harmon Fieldan engine failure due to oil exhaustion from a missing oil pressure relief valve as the result of an improper maintenance inspection.NTSB NYC95LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Kingston, NYThe pilot's failure to assure that the fuel selector was positioned to a tank containing ample fuel.NTSB SEA95LA066Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Boise, IDFuel exhaustion due to the pilot's failure to refuel.NTSB NYC95FA068Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Suffolk, VAThe pilot's inadequate preflight and improper in-flight planning/decision, which resulted in fuel exhaustion. Darkness was a factor related to the improper planning/decision-making for the emergency landing.NTSB LAX95LA132Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Five Points, CAfuel exhaustion due to the pilot's inattention to the fuel supply.NTSB CHI95LA100Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOThe pilot misjudged the fuel supply.NTSB MIA95LA085Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Crystal Springs, MSThe failure of the pilot in command to insure the aircraft contained adequate fuel to complete the flight.NTSB SEA95LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Albany, ORThe pilot's failure to use carburetor heat. Factors include icing conditions and the dark night light conditions.NTSB NYC95LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · North Bergen, NJThe pilot's inadequate in-flight planning which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB ATL95LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Brookwood, ALThe pilot's failure to lean the fuel mixture, stop at the first destination to refuel, and his incorrect fuel consumption calculations.NTSB CHI95LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Washington, MOthe CFI's failure to verify the fuel quantity prior to takeoff which resulted in fuel exhaustion. Factors related to the accident were the student's misjudgment of the fuel quantity and the soft terrain.NTSB NYC95LA055Accident · No injuriesLimited investigationFinal reportBeech C23 · Rochester, NHThe pilot's inadequate inflight planning/decision and inadvertently turning the ignition switch to the off position. A factor was the ignition switch stuck in the off position.NTSB LAX95LA107Accident · Serious injuriesLimited investigationFinal reportVarga 2150A · Yuma, AZfuel exhaustion due to the pilot's inadequate preflight inspection and his failure to refuel the aircraft.NTSB ATL95LA048Accident · Minor injuriesLimited investigationFinal reportCessna T210G · Covington, TNThe pilot's inadequate preflight inspection of the aircraft, in that he did not adequately drain water from the fuel system, resulting in water ingestion into the engine.NTSB MIA95LA073Accident · Serious injuriesLimited investigationFinal reportRoy Long EZ · Columbus, MSThe pilot's inadequate preflight inspection of the fuel system. This resulted in a total loss of engine power in cruise flight, due to fuel contamination, forced landing, and subsequent in- flight collision with trees and terrain.NTSB MIA95FA072Accident · Serious injuriesField investigationFinal reportCessna 152 · Mobile, ALThe pilot's improper planning/decision, which resulted in fuel exhaustion before reaching the airport, and his failure to maintain adequate airspeed while maneuvering for a forced landing, which resulted in an inadvertent stall and collision with the terrain.