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 LAX92LA272Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Santa Clarita, CAFuel starvation caused by the inflight separation of the fuel gascolator bowl due to improper component installation.NTSB FTW92LA174Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Paris, TXFuel exhaustion power loss. Factors were a loose fuel cap, inadequate preflight by the pilot and the lack of suitable terrain.NTSB SEA92LA141Accident · No injuriesLimited investigationFinal reportBell-World 47D1 · Wenatchee, WACarburetor ice and the pilot in command's not being able to maintain clearance. Factors contributing to the accident were: carburetor icing conditions and tree(s).NTSB NYC92LA134Accident · No injuriesLimited investigationFinal reportCessna 150L · Bethel Park, PAThe failure of the pilot to determine the fuel quantity prior to departure, which resulted in a power loss due to fuel exhaustion, over unsuitable terrain. Factors related to the accident were an improperly reading right fuel gauge, and an improperly adjusted…NTSB BFO92LA089Accident · Minor injuriesLimited investigationFinal reportMadsen Rans S-12 · Saluda, VAWater contamination of the fuel, and an inadequate preflight by the pilot.NTSB CHI92DER01Accident · Serious injuriesFinal reportGoehring Quickie · So. St. Paul, MNA loss of engine power due to carburetor ice. The lack of suitable terrain for the forced landing was a factor.NTSB SEA92LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Mckinnon, WYWater in the aircraft fuel system which was not purged as a result of the pilot in command's inadequate preflight. Factors contributing to the accident were: trees, a fence and the uneven terrain condition during the landing and rollout.NTSB MIA92FA142Accident · 1 fatalField investigationFinal reportHughes 369HS · Labelle, FLThe pilot-in-command's improper application of collective pitch during an autorotative landing resulting in insufficient rotor RPM and in-flight collision with trees and the terrain. Contributing to the accident was the total loss of engine power due to fuel…NTSB LAX92FA257Accident · 2 fatalField investigationFinal reportWaco UPF-7 · Sedona, AZFuel exhaustion due to the pilots inadequate preflight planning and his failure to refuel the airplane prior to departure. Factors in the accident were: 1) the unreliable fuel sight gauges which were contaminated with a tar like residue which may have…NTSB ATL92LA129Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Donalsonville, GAThe pilot's inadequate preflight inspection of the aircraft, and his failure to detect water in the aircraft fuel system.NTSB NYC92LA120Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Huron, OHThe student pilot's alcoholic impairment of efficiency and judgement which led to his geographical disorientation and eventual fuel exhaustion and total loss of engine power, and his failure to maintain airspeed during the forced landing resulting in a…NTSB ANC92LA091Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Memory Lake, AKFuel exhaustion. Factors include inadequate preflight planning, lack of familiarity with the aircraft, and unsuitable terrain.NTSB DEN92LA059Accident · No injuriesLimited investigationFinal reportCessna 177RG · Gunnison, COThe pilot's failure to maintain directional control. Factor(s) included: fuel exhaustion and the misjudging of fuel consumption calculations.NTSB MIA92LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Bradenton, FLThe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB CHI92DTG02Accident · Minor injuriesFinal reportCallair A9B · Bisbee, NDThe loss of engine power due to fuel starvation resulting from the pilot's inadequate preflight inspection.NTSB LAX92LA243Accident · No injuriesLimited investigationFinal reportCessna 150 · Tucson, AZThe pilot's failure to follow v.f.r. procedures; inadequate preflight planning/preperation; and improper fuel consumption calculations which resulted in fuel exhaustion.NTSB CHI92LA184Accident · No injuriesLimited investigationFinal reportCessna 150L · Evansville, INThe pilot's misjudgement of fuel supply.NTSB NYC92FA103Accident · 1 fatalField investigationFinal reportCessna 180G · Reynoldsville, PAThe pilot's failure to refuel resulting in fuel exhaustion and subsequent forced landing in trees.NTSB MIA92LA135Accident · Minor injuriesLimited investigationFinal reportHiller UH12C · Punta Gorda, FLThe pilot in command's failure to monitor fuel consumption and flight time resulting in exhaustion of fuel and engine failure. Contributing to the accident was the pilot in command's improper autorotation following engine failure which resulted in a hard…NTSB MIA92LA133Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Panama City, FLThe pilot in command's failure to enrich the mixture control during descent, resulting in loss of engine power, and his improper engine restart procedure which resulted in his being unable to get the engine started prior to an off airport landing.NTSB MIA92GA134Accident · 1 fatalFinal reportCessna U206-F · Live Oak, FLImproper maintenance of the fuel system by the pilot/mechanic resulting in an engine failure on takeoff over terrain unsuitable for a forced landing. Contributing to the accident was the pilot's improper in-flight decision to turn back to the runway, and…NTSB MIA92LA130Accident · No injuriesLimited investigationFinal reportCessna 310-R · Summerfield, FLThe failure of the pilot-in-command to switch the fuel selectors in flight which caused both engines to fail due to fuel starvation. Contributing to the accident was the complacency of the pilot-in-command.NTSB CHI92LA163Accident · No injuriesLimited investigationFinal reportCessna 120 · Elk River, MNThe pilot's improper preflight inspection.NTSB BFO92LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Saxonburg, PAThe pilot mismanaged the fuel supply, which resulted in fuel starvation and the lost of engine power.NTSB ANC92LA077Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2-T · Alexander Creek, AKThe pilot's inadvertent deactivation of the engine's fuel supply by switching off the fuel shut off. Factor related to the accident was the soft mud in the forced landing area.NTSB LAX92LA214Accident · No injuriesLimited investigationFinal reportCobb Intl Exec 90 · Glendale, AZThe improper carburetor idle adjustment by company maintenance personnel. Contributing to this accident was the cfi's inability to attain adequate RPM and the soft dirt.NTSB FTW92LA139Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-CD · Van, TXFuel exhaustion engine power loss due to the pilot's failure to refuel. A factor was the lack of suitable terrain available for the forced landing.NTSB LAX92FA212Accident · 2 fatalField investigationFinal reportCessna 150 · Cottonwood, AZA failure of the student pilot to conduct an adequate pre-flight inspection to remove contaminated fuel; a failure to maintain adequate airspeed to prevent an inadvertent stall. Contributing to the accident was an inadequate annual inspection of the fuel…NTSB ATL92LA103Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Manchester, GAThe inadequate in-flight planning by the pilot.NTSB ATL92LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Soccastee, SCThe pilot's mismanagement of his fuel in that he exhausted fuel in one tank, then failed to select the tank with fuel.NTSB FTW92LA129Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Terrell, TXThe pilot's alcoholic impairment of efficiency and judgement which led to his inattention to the amount of fuel remaining in the left fuel tank, resulting in fuel starvation and a total loss of engine power. A factor in the accident was the existence of the…NTSB BFO92LA057Accident · Serious injuriesLimited investigationFinal reportCessna 210M · West Mifflin, PAThe pilot's inadequate preflight preparation. Contributing to the accident was the unreliable fuel quantity gauges.NTSB LAX92LA235Accident · No injuriesLimited investigationFinal reportMcquen Glassair III · Casa Grande, AZFuel starvation due to the pilot's misreading of a newly installed fuel selector panel with placards and a position pointer which were confusing. Factors in the accident were the confusing nature of the fuel panel and placard design and the school bus which…NTSB CHI92DCG01Accident · Serious injuriesFinal reportCedric Lewellen Soneria II · Bolivar, MOThe pilot's improper preflight planning/preparation.NTSB ANC92LA068Accident · No injuriesLimited investigationFinal reportCessna 180 · Kenai, AKThe pilot's improper use of carburetor heat which resulted in loss of engine power due to carburetor ice.NTSB LAX92FA206Accident · 1 fatalField investigationFinal reportRobinson R-22B · Anaheim, CAThe total loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate rotor RPM during the autorotation.NTSB CHI92DCD04Accident · No injuriesFinal reportHiller UH-12E · Milford, IAA total loss of engine power for an undetermined reason as the helicopter was performing aerial application maneuvers.NTSB NYC92FA090Accident · 1 fatalField investigationFinal reportBeech A36 · Southbury, CTThe failure of the pilot to monitor his fuel supply which resulted in a power loss due to fuel exhaustion and an inadvertent stall/spin as the pilot was maneuvering for a forced landing. Factors related to the accident was improper maintenance on the fuel…NTSB ATL92LA095Accident · No injuriesLimited investigationFinal reportCessna 180B · Jacksonville, NCThe pilot's failure to ensure an adequate supply of fuel for the planned flight; which resulted in fuel exhaustion. A factor was the high vegetation in the forced landing field.NTSB LAX92LA199Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Sun Valley, CA1) Fuel exhaustion due to improper preflight planning by the CFI and his failure to refuel the aircraft prior to departure on the accident flight, and 2) the cfi's misjudgement of the landing flare timing during the auto rotation.NTSB MIA92FA121Accident · 3 fatalField investigationFinal reportCessna 310Q · Odessa, FLLoss of engine power on initial takeoff climb on all engines for undetermined reasons. This resulted in a forced landing, in flight collision with trees, terrain, and postcrash fire.NTSB SEA92LA087Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Prineville, ORThe pilot in command delaying his decision to divert for fuel, overloading of the nose gear strut and the pilot in command's inability to maintain aircraft control subsequent to the nose wheel separation. Factors contributing to the accident were: the pilot…NTSB LAX92LA194Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-325 · Independence, CAFuel starvation due to 1) the pilots inadequate preflight planning preparation, 2) the pilot's fuel system management, and 3) his operation of the aircraft with known deficiencies in the aircraft electrical system. Factors in the accident were: 1) the…NTSB CHI92LA133Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Washington, MOThe pilot in command's improper use of the carburetor heat control.NTSB LAX92FA185Accident · 2 fatalField investigationFinal reportBeech S35 · Long Beach, CAThe pilot's failure to maintain an airspeed above the airplane's stall speed (vs) and inadvertent entry into a spin. The engine failure resulting from contaminated fuel and inadequate preflights were factors in the accident.NTSB ATL92LA088Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Alto, GAThe pilot's mismangement of the fuel in that he delayed selection of a fuel tank with usable fuel, and the excessive final landing speed. Factors were the pilot's failure to extend the flaps and the rough/uneven terrain because of the railroad spur.NTSB LAX92MA183Accident · 16 fatalMajor investigationFinal reportde Havilland DHC-6-200 · Perris, CAThe pilot-in-command's inadvertent feathering of the wrong propeller following an engine power loss, and the failure of the operator to assure that the pilot was provided with adequate training in the airplane. Factors related to the accident were: water…NTSB SEA92LA080Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Sunriver, ORThe pilot did not accurately calculate fuel consumption. A factor to the accident was: fuel exhaustion.NTSB LAX92LA181Accident · No injuriesLimited investigationFinal reportNavion G · Santa Paula, CAThe pilot's improper aircraft preflight by failing to assure the fuel selector handle was in the proper position. Factors relating to this accident was the engine fuel starvation.NTSB LAX92LA180Accident · No injuriesLimited investigationFinal reportCessna 150 · Mesquite, NVThe pilot's poor preflight planning and improper fuel consumption calculations. Factors relating to this accident were fuel exhaustion, and the unsuitable terrain, and lack of understanding of the airplane's fuel system.