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 BFO93LA125Accident · Serious injuriesLimited investigationFinal reportHancock- Harris Pitts Special · Independent Hil, VAThe pilot's inadequate preflight planning/preparation which resulted in fuel exhaustion and subsequent loss of engine power.NTSB DEN93LA078Accident · No injuriesLimited investigationFinal reportCessna 172XP · Allen, TXFuel exhaustion induced power loss. A factor was the lack of suitable terrain for the forced landing.NTSB ATL93LA128Accident · Minor injuriesLimited investigationFinal reportBrown Glassair SH-2 · Timmonsville, SCThe pilot's inadequate fuel planning which resulted in the exhaustion of the fuel supply and the loss of engine power. A factor was the pilot's failure to comply with a manufacturer's service bulletin.NTSB SEA93LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Arlington, WYFuel contamination, directives not followed by the pilot in command, and his premature flare.NTSB CHI93LA250Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Harvel, ILThe pilot-in-command's inadequate preflight planning.NTSB CHI93LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Senter, MIThe pilot-in-command's inadequate pre-flight planning. Factors relating to this accident are fuel exhaustion, unsuitable terrain on which to make an emergency landing, as well as an inadvertent stall.NTSB CHI93LA253Accident · Minor injuriesLimited investigationFinal reportCessna 210 · West Bend, WIThe inadequate preflight by pilot-in-command. A factor was the rough terrain.NTSB ANC93LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot-in-command's improper positioning of the fuel selector. Factor was the soft condition of the forced landing area.NTSB MIA93LA151Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Magee, MSInstallation of an incorrect oil filter adapter plate stud which secures the plate to the accessory case.NTSB CHI93LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Bloom, KSimproper refueling by a person or persons unknown. A factor was deteriorated fuel.NTSB BFO93LA112Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Normalville, PAThe presence of carburetor icing conditions, which caused a total loss of engine power. A factor related to the accident was the pilot's delayed use of carburetor heat and rough terrain.NTSB LAX93LA273Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Moccasin, CAFuel exhaustion due to the pilot's failure to perform fuel consumption calculations. Factors related to this accident were: the pilot's inadequate preflight or inflight planning and preparation.NTSB BFO93LA105Accident · 1 fatalLimited investigationFinal reportAdolfson Starduster SA300 · Windsor, NYLoss of engine power during initial climbout due to undetermined reasons. A factor related to the accident was the pilot's failure to maintain adequate airspeed following the loss of engine power, leading to an aerodynamic stall.NTSB LAX93LA271Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Malibu, CAthe inadequate annual inspection by other maintenance personnel and the worn fuel selector valve shaft. Contributing to this accident was the loss of power due to fuel starvation.NTSB FTW93LA202Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Lampasas, TXFuel exhaustion engine power loss due to an inadequate preflight preparation. A factor was the lack of suitable terrain for the forced landingNTSB ATL93LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Seneca, SCThe pilot's improper preflight planning which resulted in fuel exhaustion.NTSB SEA93LA145Accident · Minor injuriesLimited investigationFinal reportBellanca 17-31ATC · Jackson Hole, WYThe pilot's selection of an empty fuel tank, and fuel starvation. Factors include rough/uneven terrain.NTSB NYC93FA133Accident · 2 fatalField investigationFinal reportAmerican General AA-1 · Vestal, NYThe loss of engine power due to fuel starvation from a fuel leak caused by inadequate maintenance by unqualified personnel, the pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with the ground.NTSB LAX93LA268Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Danville, CAThe pilot's poor fuel consumption calculations. Contributing to this accident was the downsloping terrain.NTSB CHI93LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172C · West Chicago, ILthe pilot's improper use of carburetor heat. Conditions conducive to the formation of carburetor ice was a factor.NTSB CHI93FA225Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Elwell, MIImproper use of the fuel selector by the pilot, which resulted in fuel starvation.NTSB ANC93LA102Accident · No injuriesLimited investigationFinal reportCessna 150 · Nondalton, AKThe inadequate preflight preparation by the pilot-in-command. A factor in the accident was the encounter with unsuitable terrain during the emergency descent.NTSB LAX93LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Camarillo, CAFuel exhaustion due to the inadequate preflight fuel consumption planning, the inadequate en route fuel consumption calculations, and the failure of the pilot to stop en route for fuel.NTSB SEA93LA135Accident · Minor injuriesLimited investigationFinal reportBell 206B · Harlem, MTThe improper refueling system procedures which allowed water to contaminate the aircraft fuel and the pilot's inadequate preflight.NTSB DEN93LA071Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Watkins, COTotal loss of power resulting from a blocked carburetor fuel filter. A factor was: soft terrain encountered during the forced landing.NTSB CHI93LA217Accident · No injuriesLimited investigationFinal reportCessna P210 · Pulaski, ILthe pilot's improper fuel tank selection resulting in fuel starvation. A factor in the accident is the soft emergency landing surface.NTSB NYC93LA122Accident · 1 fatalLimited investigationFinal reportSmitrvich Starduster SA-300A · Millville, NJThe pilot's inflight planning which resulted in fuel exhaustion. A factor was inadequate preflight planning.NTSB FTW93LA193Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Holly Grove, ARTotal loss of power due to fuel exhaustion due to the pilot not refueling. A factor was the lack of suitable terrain for the forced landing.NTSB ANC93LA100Accident · No injuriesLimited investigationFinal reportCessna 180 · Merrill Pass, AKThe pilot-in-command's inadequate fuel calculations.NTSB SEA93LA134Accident · Minor injuriesLimited investigationFinal reportRomig FR-1 · Independence, ORFuel starvation and the pilot-in-command's not maintaining directional control. Factors contributing to the accident were the pilot-in-command's not selecting the fuel boost pump and high vegetation.NTSB SEA93LA130Accident · No injuriesLimited investigationFinal reportBeech H35 · Douglas, WYThe improper maintenance/replacement of a fuel hose and the blocked fuel vapor return system. A factor relating to the accident was the cattle guard fence posts beside the road.NTSB SEA93LA129Accident · Minor injuriesLimited investigationFinal reportCessna T210K · Forest Grove, ORLoss of engine power due to fuel exhaustion, resulting from inadequate preflight planning/preparation by the PIC.NTSB MIA93LA142Accident · No injuriesLimited investigationFinal reportSayer, Trevor A. Rans S-12 · New Smyrna Bch, FLFailure of the pilot to maintain adequate airspeed and inadvertent stall/spin. Contributing to the accident was total loss of engine power due to fuel starvation. This was due to improper placement of a component of the fuel system by the builder/pilot.NTSB MIA93FA141Accident · 1 fatalField investigationFinal reportCessna 150J · Niceville, FLThe inadequate annual inspection of the airplane by other maintenance personnel and the failure of the pilot to maintain airspeed above a stall.NTSB ATL93LA109Accident · No injuriesLimited investigationFinal reportCessna 170 · Mooresville, NCPoor maintenance practices during the rebuilding of the aircraft which allowed the fuel system to become contaminated and resulted in the subsequent fuel starvation of the engine.NTSB NYC93LA104Accident · No injuriesLimited investigationFinal reportCessna 150J · West Caldwell, NJThe complete loss of engine power as a result of carburetor icing, the subsequent forced landing and impact with the terrain.NTSB NYC93LA100Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Cincinnati, OHThe pilot's improper inflight planning and decision resulting in fuel exhaustion, and the subsequent forced landing and collision with power lines.NTSB CHI93LA191Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Kewanee, ILThe pilot's failure to refuel the airplane prior to fuel exhaustion. A factor in the accident is the pilot's inadvertent stall/mush during the forced landing.NTSB MIA93LA138Accident · No injuriesLimited investigationFinal reportCessna 152 · Sarasota, FLPilot in command's failure to ensure the aircraft contained enough fuel to complete the flight resulting in the engine failing due to fuel exhaustion.NTSB ATL93LA104Accident · Minor injuriesLimited investigationFinal reportHatz CB-1 · Stedman, NCThe improper positioning of the main fuel tank drain, which resulted in fuel starvation and engine stoppage. A factor were trees in the forced landing area.NTSB LAX93LA237Accident · Minor injuriesLimited investigationFinal reportSchmidt JURCA-MJ55 · Bakersfield, CALoss of engine power for undetermined reasons.NTSB NYC93LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Gordonsville, VAWas a power loss due to fuel contamination, after the pilot refueled from cans and did not filter the fuel according to recommendations.NTSB MIA93LA133Accident · No injuriesLimited investigationFinal reportCessna 150L · Fort Myers, FLFailure of the pilot-in-command to perform in-flight fuel consumption calculations. The lack of suitable terrain for a forced landing was a factor.NTSB CHI93LA184Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Ely, MNthe pilot's decision to continue flight with a known deficiency in the airplane's hydraulic system. Factors associated with the accident are the loss of power in the left engine due to fuel contamination, and a leak in the hydraulic system.NTSB LAX93LA221Accident · No injuriesLimited investigationFinal reportCessna 150E · Hollister, CAfuel exhaustion due to the pilot's inadequate preflight inspection of the aircraft and his failure to refuel the aircraft prior to departure.NTSB ATL93LA095Accident · No injuriesLimited investigationFinal reportCessna 172 · Athens, TNFailure of the aircraft engine to produce power for unknown reasons.NTSB BFO93LA096Accident · No injuriesLimited investigationFinal reportRyan Navion · Cumberland, RILoss of engine power due to undetermined reasons. A factor related to the accident was rough and uneven terrain.NTSB LAX93LA218Accident · No injuriesLimited investigationFinal reportBeech 36 · Hayward, CAfuel starvation due to the pilot's inadequate preflight inspection of the aircraft and his failure to ensure that adequate fuel existed in the fuel tanks to be used.NTSB FTW93FA158Accident · Serious injuriesField investigationFinal reportPiper PA-22-108 · Weatherford, TXTotal loss of engine power with cause undetermined. A factor was the lack of suitable terrain.NTSB BFO93LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Canton, KYThe pilot's inadequate preflight planning when determining his fuel load, which led to an exhaustion of the airplane's fuel supply.