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 MIA94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tupelo, MSThe pilot-in-commands failure to monitor fuel consumption.NTSB ATL94LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffin, GAFuel starvation caused by foreign matter blockage of the fuel tank vent system.NTSB BFO94LA022Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Waynesburg, PAThe pilot's inadequate preflight and inflight preparations, planning and decisions. The lack of suitable terrain for the forced landing was a factor.NTSB CHI94DEP01Accident · No injuriesFinal reportKrotje Kolb Mark III · Oshkosh, WIThe lack of carburetor heat for the engine. A factor related to the accident was: the weather condition, which was favorable for formation of carburetor ice.NTSB LAX94LA057Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Buckeye, AZA loss of engine power due to fuel system contamination. A factor in the accident was the soft terrain in the landing area.NTSB MIA94LA028Accident · No injuriesLimited investigationFinal reportCessna 172P · Jacksonville, FLThe improper positioning of the fuel selector by the pilot-in- command resulting in fuel starvation.NTSB FTW94LA039Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Mancos, COFuel exhaustion induced power loss and the pilot's inadequate preflight inspection, during which he failed to insure that the airplane had been refueled to capacity. A factor was the lack of suitable terrain for a forced landing.NTSB SEA94LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Brookings, ORThe pilot's inadequate preflight planning/preparation, and icing of the induction air filter/screen. Factors include weather conditions conducive to icing, and rough/uneven terrain in the area of attempted landing.NTSB ATL94LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Maryville, TNThe pilot's inadequate inflight planning, which resulted in fuel exhaustion prior to reaching the planned destination.NTSB FTW94FA034Accident · Serious injuriesField investigationFinal reportCessna 172N · Fort Collins, COPower loss due to throttle linkage disconnect. Factors were missing cotter key, improper maintenance, and the lack of suitable terrain for the forced landing.NTSB CHI94LA037Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Arcadia, WIthe loss of engine power for an undetermined reason(s).NTSB BFO94LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Riverhead, NYThe pilot's preflight planning/preparation was inadequate which resulted in a loss of engine power due to fuel exhaustion.NTSB ATL94LA018Accident · No injuriesLimited investigationFinal reportCessna 150 · Cumming, GAThe pilot's failure to use the carburetor heat system while maneuvering the airplane. A factor was conditions that were favorable for the formation of carburetor ice.NTSB ATL94LA014Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 Soloy · Atmore, ALThe pilot's inadequate pre-flight inspection. Factors were the lack of a filter on the refueling pump which would preclude water passage, and the high trees.NTSB ATL94LA013Accident · Serious injuriesLimited investigationFinal reportBowermaster B-8M · Cowpens, SCFuel starvation which resulted from unported fuel in the fuel tank due to inadequate design of the tanks.NTSB LAX94LA040Accident · No injuriesLimited investigationFinal reportBeech D95A · Hollister, CAThe improper position of the fuel selector switch by the dual student during the before landing checklist and inadequate supervision by the CFI. Fuel starvation to both engines was a factor in this accident.NTSB FTW94LA026Accident · Minor injuriesLimited investigationFinal reportRockwell 114 · Magnolia, TXWas the owner's failure to perform corrective maintenance on the airplane's fuel system and the pilot's decision to operate it with known maintenance deficiencies. A factor was the lack of suitable terrain onto which a forced landing could be executed.NTSB MIA94LA016Accident · Minor injuriesLimited investigationFinal reportLovern Pitts S1C · Miami, FLInadequate preflight by the pilot-in-command resulting in the total loss of engine power due to fuel exhaustion.NTSB LAX94LA036Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Palm Springs, CAfuel exhaustion due to the pilot's failure to adequately monitor the fuel consumption during the flight.NTSB CHI94LA025Accident · No injuriesLimited investigationFinal reportCessna 150M · Franklin, WIFailure of the instructor pilot (CFI) to use carburetor heat during the simulated engine failure, which resulted in carburetor ice and loss of engine power. Factors related to the accident were: carburetor icing conditions and the crop in the emergency…NTSB LAX94LA022Accident · Minor injuriesLimited investigationFinal reportBeech B35 · Indian Springs, NVFailure of the pilot to properly operate the airplane's fuel selector, which resulted in fuel starvation, and his improper emergency procedure for restarting the engine. A factor related to the accident was: the pilot's lack of experience in this make and…NTSB CHI94LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Byron, WIthe pilot's inaccurate fuel consumption calculations which resulted in his not refueling during the flight. A factor related to the accident was the pilot's failure to maintain proper airspeed during the forced landing.NTSB LAX94LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Daggett, CAthe pilot's poor fuel consumption calculations which culminated in engine losing power due to fuel exhaustion. The soft desert terrain was a factor in this accident.NTSB LAX94LA013Accident · No injuriesLimited investigationFinal reportCessna 150L · Van Nuys, CAthe pilot's poor preflight planning/preparation and fuel consumption calculations. Fuel exhaustion is a factor in this accident.NTSB ATL94LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Blountville, TNImproper planning/decision by the pilot, which resulted in inadequate fuel and fuel exhaustion.NTSB ANC94LA007Accident · No injuriesLimited investigationFinal reportHelio H-391-B · Beaver Creek, AKThe pilot's failure to maintain the required airspeed during the emergency descent as published in the pilot's manual. A factor is the loss of engine power for undetermined reasons.NTSB NYC94FA004Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · East Hampton, NYInadvertent feathering of both propellers by the student pilot, which resulted in a loss of power, and failure (or inability) of the instructor pilot (CFI) to attain remedial action. A factor related to the accident was: the student pilot's habit…NTSB CHI94LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Allendale, MIImproper in-flight planning/decision by the pilot, after encountering unfavorable winds and a low fuel level, which resulted in fuel exhaustion. The unfavorable wind was a related factor.NTSB CHI94LA006Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Frankfort, MIthe pilot's failure to perform refueling.NTSB ATL94LA003Accident · No injuriesLimited investigationFinal reportCessna T188C · Rogersville, ALWas the pilot's inadequate pre-flight preparation which resulted in fuel exhaustion during take off.NTSB SEA94LA007Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Shoshoni, WYFuel exhaustion and the pilot in command's failure to refuel the aircraft.NTSB CHI94LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Monroe, MIThe pilot's inadequate preflight planning/preparation, when he misjudged the (inadequate) supply of fuel before takeoff, which resulted in fuel exhaustion. Soft terrain in the emergency landing area was a related factor.NTSB CHI94LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Cheboygan, MIInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to and inadequate supply of fuel. Factors related to the accident were: the lack of suitable terrain for a forced landing, and trees in the emergency landing area.NTSB LAX93LA373Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lompoc, CAwas fuel starvation. A factor in the accident was the mechanic's inadequate inspection of the airplane.NTSB ATL93LA165Accident · No injuriesLimited investigationFinal reportCessna 150 · Sylvania, GAWas the pilot's failure to properly plan sufficient fuel for the flight which resulted in fuel exhaustion short of the destination airport.NTSB CHI93LA380Accident · No injuriesLimited investigationFinal reportCessna 177B · Fayette, IAthe pilot-in-command's failure to refuel the airplane. A factor was a road sign and fuel exhaustion.NTSB CHI93LA379Accident · No injuriesLimited investigationFinal reportCessna 150M · Burlington, WIthe improper fuel calculations by the pilot-in-command. Factors were the pilot-in-command's not refueling and uphill terrain.NTSB ANC93IA188Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · Anchorage, AKForeign object damage to the compressor forward fan assembly as a result of the ingestion of a bird.NTSB FTW93LA264Accident · Minor injuriesLimited investigationFinal reportFairchild M-62A · San Antonio, TXFuel starvation induced power loss due to the pilot's improper fuel tank selection and his failure to switch tanks after the power loss. A factor was the lack of suitable terrain onto which a forced landing could be executed.NTSB CHI93LA375Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Spencer, IAthe pilot's to switch fuel tanks which resulted in fuel starvation. A factor related to the accident was the rough terrain on which the airplane was landed.NTSB CHI93LA367Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Crivitz, WIfuel starvation caused by foreign matter in the fuel tank strainer.NTSB ANC93LA181Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Iliamna, AKTotal loss of engine power due to fuel exhaustion and the pilot's improper fuel consumption calculations. Factor was the unsuitable terrain.NTSB CHI93LA368Accident · Minor injuriesLimited investigationFinal reportKewley KR2 · Carbondale, ILImproper planning/decision by the pilot, which resulted in fuel exhaustion due to lack of fuel.NTSB CHI93LA366Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Madison, WIthe loose fuel selector handle/valve which resulted in an inability to properly switch fuel tanks.NTSB MIA93LA196Accident · Minor injuriesLimited investigationFinal reportSukhoi SU-26M · Natchez, MSThe pilot-in-command's failure to accurately calculate fuel consumption resulting in total loss of engine power due to fuel exhaustion while approaching the destination airport.NTSB CHI93LA360Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Marshfield, MOfuel exhaustion due to the failure of the fuel tank selector valve handle which prohibited the pilot from switching to a tank containing fuel.NTSB CHI93LA356Accident · No injuriesLimited investigationFinal reportCessna 150H · Crescent, IAImproper in-flight planning/decision by the pilot, after encountering unfavorable winds and a low fuel level, which resulted in fuel exhaustion. The unfavorable wind was a related factor.NTSB SEA93LA197Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Merrill, ORFuel exhaustion and inadequate inflight planning/decision.NTSB CHI93LA355Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Davison, MIImproper planning/decision by the pilot, which resulted in inadequate fuel and fuel exhaustion.NTSB SEA93LA192Accident · No injuriesLimited investigationFinal reportWestholm Vans RV-6 · Salmon, IDThe inadequate preflight planning/preparation by the PIC in his failure to close the fuel drain valve. A factor relating to the accident was the fence post located in the landing area.