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 ATL92LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Thomasville, GAA total loss of engine power for undetermined reasons, and the pilot's failure to maintain a proper descent rate during the forced landing attempt.NTSB DEN92LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Berryville, ARA power loss for undetermined reasons. Factors were: incorrect fuel, improper maintenance, and inadequate maintenance inspection interval.NTSB ATL92FA013Accident · Serious injuriesField investigationFinal reportBeech 58 · Pelham, ALThe pilot's failure to correct the position of the fuel selector before takeoff, and her inattentiveness to fuel consumption during the flight, which resulted in fuel starvation. Factors were the non-performance of engine out emergency procedures and the…NTSB NYC92LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Montgomery, NYFailure of the pilot-in-command to correctly position the fuel selector when the right main fuel tank was exhausted, resulting in fuel starvation to the engine.NTSB MIA92LA015Accident · No injuriesLimited investigationFinal reportRockwell 685 · Tupelo, MSThe pilot in commands failure to insure that adequate fuel was placed on the aircraft for the flight resulting in loss of power in both engines due to fuel exhaustion.NTSB BFO92LA002Accident · No injuriesLimited investigationFinal reportCessna 177B · London, KYThe loss of engine power from fuel starvation due to inadequate inflight planning/decision by the pilot.NTSB LAX92LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA 24-250 · Linden, CAThe pilot in command inaccurately calculating the aircraft's fuel consumption, and not re-fueling the aircraft prior to takeoff from his last departure point. This resulted in a power loss due to fuel exhaustion. A factor in this accident was the unsuitable…NTSB SEA92LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA28-161 · Duchesne, UTFuel exhaustion due to the pilot's inattention and becoming lost. A factor to the accident was the night conditions.NTSB LAX92LA014Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350D · Hilo, HI1) A loss of engine power due to the ingestion of gasses from the active volcano vent, and 2) the pilots inflight decision to hover downwind in close proximity to the vent.NTSB CHI92LA005Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Cassville, MOThe pilot-in-command's improper preflight planning and preparation. Factors contributing to this accident were fuel exhaustion, a hidden obstruction within the terrain the pilot landed on and a collapsed nosegear.NTSB SEA92LA003Accident · No injuriesLimited investigationFinal reportCessna 337A-RG · Snohomish, WAFuel system starvation, due to the pilot's improper fuel tank selection. Factors include procedures not being followed, and inattentiveness.NTSB ATL92LA003Accident · Minor injuriesLimited investigationFinal reportCessna 320 · Gadsden, ALFuel starvation due to incorrect fuel line installations, an inoperative fuel boost pump, and incorrect pilot procedure. A factor in this accident was the pilot's intentional operation with a known fuel system deficiency.NTSB MIA92GA002Accident · 2 fatalFinal reportCessna 172K · Everglades City, FLThe pilot-in-command's improper management of fuel. This resulted in the airplane experiencing fuel exhaustion, forced landing, and in flight collision with terrain.NTSB LAX92LA001Accident · Serious injuriesLimited investigationFinal reportBeech A36TC · Dunsmuir, CA1) Improper preflight planning by the aircraft owner, 2) failure of the owner to refuel the aircraft, 3) operation of the aircraft by the owner and a mechanic at a known fuel state below the minimum required for takeoff, and 4) failure of the mechanic to…NTSB BFO91FA087Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Laurel, MDA loss of engine power for undetermined reasons.NTSB ATL91LA184Accident · 1 fatalLimited investigationFinal reportFischer Wagabond · Rossville, TNThe loss of engine power as a result of carburetor icing.NTSB MIA91FA227Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · West Palm Beach, FLThe pilot's improper use of the mixture control in that he failed to place it in full rich condition prior to takeoff. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB FTW91LA167Accident · No injuriesLimited investigationFinal reportCessna 177B · Lake Charles, LAThe pilot's failure to perform a complete preflight inspection which resulted in a total loss of engine power due to fuel exhaustion as a result of inadequate fuel supply.NTSB CHI91LA273Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Columbus, NEImproper refueling by ground personnel and the pilot's inadequate preflight.NTSB NYC91LA242Accident · No injuriesLimited investigationFinal reportCessna 180L · Vestal, NYImproper use of carburetor heat by the pilot which resulted in a power loss due to carburetor ice over unsuitable terrain.NTSB ATL91LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Greenville, SCThe dual student's improper positioning of the fuel tank selector handle, and the cfi's inadequate supervision of her student. A factor in this accident was: the cfi's lack of experience as a flight instructor.NTSB ATL91LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pleasant Grove, ALThe pilot's failure to refuel the airplane prior to the last takeoff resulting in an inadequate fuel supply for the flight.NTSB NYC91LA241Accident · No injuriesLimited investigationFinal reportRobinson R22B · Wexford, PAThe pilot's improper procedures during a practice autorotation, and selection of unsuitable terrain. Contributing to the accident was a loss of engine power for undetermined reasons, at a low altitude.NTSB LAX91LA400Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · French Gulch, CAThe pilot's failure to refuel before departing on the accident flight. Contributing to this accident was the high vegetation and fuel exhaustion.NTSB SEA91LA247Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Arco, IDWater in the fuel tank and the inability of the pilot to flare for landing after maneuvering to avoid transmission lines in his flight path during the forced landing.NTSB MIA91LA220Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Bay Springs, MSTotal loss of engine power due to undetermined reasons. Contributing to the accident was unsuitable terrain encountered during the forced landing.NTSB ANC91LA157Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Cantwell, AKThe engine power loss for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB SEA91LA239Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Hillsboro, ORInadequate preflight planning, which resulted in an inadequate fuel supply and fuel exhaustion.NTSB LAX91LA395Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Tehachapi, CAFuel exhaustion due to improper inflight planning.NTSB DEN91LA129Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKPower loss due to fuel exhaustion and the pilot's failure to refuel. A factor was: the rough uneven terrain.NTSB ATL91LA172Accident · Serious injuriesLimited investigationFinal reportCessna 401 · Jackson, TNThe pilot's failure to select the main fuel tanks prior to the approach, resulting in fuel starvation and engine stoppage.NTSB DEN91FA126Accident · 1 fatalField investigationFinal reportPiper PA-30 · Ft. Carson, COThe loss of power to both engines due first to fuel starvation followed by fuel exhaustion, the pilot's failure to refuel, and the inadvertent stall. A factor was: the pilot's improper use of powerplant controls.NTSB ANC91LA146Accident · No injuriesLimited investigationFinal reportHughes 369D · Iliamna, AKWas fuel exhaustion due to the pilot-in-command's improper preflight planning. Contributing to the accident was the rough and uneven tundra landing site.NTSB DEN91LA125Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Broomfield, COThe pilot's failure to refuel and his misjudged fuel consumption calculations which resulted in fuel exhaustion power loss.NTSB MIA91LA216Accident · No injuriesLimited investigationFinal reportCessna 182 · Titusville, FLThe pilot in command's improper preflight planning and his failure to ensure that the aircraft contained sufficient fuel for the flight.NTSB BFO91LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Fallston, MDThe pilot's failure to accurately determine the fuel quantity before his flight and monitor the quantity during the flight, which resulted in fuel exhaustion due to an inadequate fuel supply.NTSB LAX91LA381Accident · No injuriesLimited investigationFinal reportCessna C-210 · Calexico, CAA non-mechanical loss of engine power due to fuel starvation from the pilot's improper use of the fuel supply.NTSB ATL91LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tullahoma, TNAn engine power loss for undetermined reasons.NTSB CHI91DEV04Accident · Minor injuriesFinal reportPitts Special S-1 · Lincoln, ILLoss of engine power for undetermined reasons.NTSB BFO91LA077Accident · No injuriesLimited investigationFinal reportCessna 150 · Atlantic Ocean (Atlantic Ocean)The pilot became lost over the Atlantic Ocean and flew until the fuel supply was exhausted.NTSB BFO91LA076Accident · No injuriesLimited investigationFinal reportCessna A188B · New Market, MDInadequate preflight by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the inoperative fuel quantity gages.NTSB NYC91LA220Accident · Minor injuriesLimited investigationFinal reportDouglas DC-3 · Apple Creek, OHImproper planning/decision by the pilot(s), and improper use of the fuel system/fuel selector. The location of trees was a related factor.NTSB MIA91IA201Incident · No injuriesIncident investigationFinal reportPiper PA-28-140 · Clearwater, FLTotal loss of engine power due to fuel starvation caused by improper fuel tank selector position by the pilot-in-command. Contributing to the incident was the pilot's total lack of experience.NTSB FTW91LA151Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Tomball, TXThe total loss of engine power for undetermined reasons. A factor in the accident was the unsuitable terrain at the pilot's disposal.NTSB LAX91LA363Accident · Minor injuriesLimited investigationFinal reportBell 47G · Kettleman City, CAA non-mechanical loss of engine power due to fuel exhaustion by the pilot's improper calculation of the fuel supply and subsequent hard landing.NTSB CHI91DEM08Accident · Serious injuriesFinal reportFisher FT101 · Sparta, MIAn improper preflight inspection by the pilot. Factors contributing to this accident were inadequate altitude for the turn back towards the runway and the stall/spin encountered by the pilot.NTSB CHI91DTG08Accident · No injuriesFinal reportGrumman G164B · Minto, NDInadequate aircraft servicing, inadequate aircraft preflight, fuel contamination, and unsuitable soft terrain in which to effect an emergency landing.NTSB LAX91FA355Accident · Minor injuriesField investigationFinal reportPiper PA-23-250 · Hawthorne, CAOverconfidence in the airplane's ability and his personal ability by the instructor pilot (CFI), by intentionally shutting off fuel to an engine during a critical part of flight. The aircraft's lack of single engine performance was a related factor.NTSB ANC91LA126Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Seldovia, AKThe pilot misjudged fuel consumption for the airplane during flight and experienced complete fuel exhaustion.NTSB NYC91LA207Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bear Mountain, NYThe pilot's improper preflight and planning, which resulted in fuel exhaustion and a forced landing in water.