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 ANC91LA122Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Iliamna, AKFuel contamination and the pilot's failure to perform an adequate preflight of the airplane. Contributing to the accident was the rough, uneven terrain of the tundra landing area.NTSB CHI91LA256Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Valparaiso, INThe pilot in command's failure to maintain airspeed. A factor contributing was improper maintenance (design change) performed by an unqualified person (pilot in command).NTSB SEA91LA205Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Boring, ORFuel exhaustion and improper inflight decision by the pilot in command followed by rough terrain during the forced landing. Factors contributing to the accident were a fuel system leak and the pilot's failure to refuel en route.NTSB CHI91LA258Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Delavan, WIMisjudged fuel consumption calculations by the pilot which resulted in fuel exhaustion. A factor related to the accident was refueling not performed.NTSB ATL91LA153Accident · No injuriesLimited investigationFinal reportCessna T188C · Quitman, GAA total loss of engine power due to fuel starvation. The reason for the fuel starvation was not determined.NTSB LAX91LA343Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Byron, CAThe pilot's failure to refuel the airplane and his misjudging the distance to the runway.NTSB DEN91LA107Accident · Minor injuriesLimited investigationFinal reportBeech J35 · Tulsa, OKThe engine ailure for undetermined reasons. Factors were the light condition and the lack of suitable terrain.NTSB CHI91LA250Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Loman, MNFuel exhaustion due to fuel consumption calculations misjudged by the pilot.NTSB CHI91LA245Accident · Serious injuriesLimited investigationFinal reportHiller 1345 · Michigan City, INFuel exhaustion due the pilot's delay in refueling. Factors related to the accident were pressure induced by others (passenger), and the absence of suitable terrain.NTSB CHI91DCJ04Accident · No injuriesFinal reportCessna T188C · Grand Island, NEThe pilot's failure to maintain adequate clearance from crops during aerial application maneuvers. Related factors are the failure of a propeller pitch change mechanism and the pilot's diverted attention.NTSB BFO91LA071Accident · No injuriesLimited investigationFinal reportCessna 172G · Fredericksburg, VAThe pilot's selection of the improper fuel tank. Contributing to the accident was the pilot did not use the check list.NTSB ATL91FA148Accident · 1 fatalField investigationFinal reportCessna 401 · Monroe, NCInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. The pilot's lack of familiarity with the aircraft fuel system was a related factor.NTSB SEA91LA197Accident · No injuriesLimited investigationFinal reportCessna 150M · Hillsboro, ORFailure of the pilot to refuel resulting in fuel exhaustion.NTSB LAX91LA335Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Scottsdale, AZFailure of the pilot-in-command accurately performing inflight fuel consumption calculations resulting in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot-in-command's poorly planned approached which terminated in a…NTSB CHI91LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Manning, IAThe pilot's improper selection of fuel tanks and improper in-flight emergency procedure by the pilot.NTSB CHI91LA232Accident · Serious injuriesLimited investigationFinal reportCessna 305 · Hutchinson, KSFuel consumption calculations misjudged by the pilot resulting in fuel exhaustion. Factors related to the accident were compensation for wind conditions were inadequate and presence of trees during the emergency landing attempt.NTSB ANC91LA112Accident · No injuriesLimited investigationFinal reportPilatus Porter PC-6/350 · Yakutat, AKThe fuel contamination and the pilot's inadequate preflight. Contributing to the accident was the soft sand bar.NTSB ANC91LA110Accident · No injuriesLimited investigationFinal reportCessna 182C · Cordova, AKA total loss of engine power while operating over water.NTSB LAX91FA334Accident · 1 fatalField investigationFinal reportErcoupe 415C · Rubidoux, CAThe mechanic's improper installation of the magnetos and the pilot's failure to maintain flying speed. Factors related to this accident are the pilot's inadvertent stall and the residential area.NTSB SEA91LA193Accident · No injuriesLimited investigationFinal reportBeech N35 · Hillsboro, ORFuel starvation due to the improper use of the fuel selector switch by the pilot and his failure to extend the landing gear for the forced landing.NTSB NYC91LA189Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Westfield, MAThe pilot's failure to refuel resulting in a power failure due to fuel exhaustion, and subsequent forced landing in unsuitable terrain.NTSB BFO91LA075Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Warrenton, VAThe pilot's inadequate preflight operations, which failed to detect the presence of water contamination in the fuel system, and resulted in the loss of power and subsequent forced landing. Other related factor: standing water on the grassy area.NTSB LAX91LA339Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B · Kahului, HIA non-mechanical loss of engine power due to fuel exhaustion and subsequent hard landing by the pilot. Contributing to the accident was a malfunctioning fuel low level indication system.NTSB FTW91LA126Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Provencal, LAFuel leakage from the fuel drain valve. A factor was the inaccessibility of suitable terrain for fored landing.NTSB CHI91LA226Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INEngine failure due to fuel exhaustion and refueling not performed by the cfi/pic.NTSB ATL91LA141Accident · Serious injuriesLimited investigationFinal reportMaridon Starduster TOO · Locust Grove, GAFuel exhaustion which resulted from the failure of the pilots to refuel the airplane. A factor was the local pilot's having become lost.NTSB CHI91LA221Accident · No injuriesLimited investigationFinal reportCessna 150M · Merrillville, INImproper pre-flight planning and preparation by the pilot-in-command. Factors related to this accident were the pilot-in-commands's inattentiveness concerning the refueling of his airplane, and inadequate fuel supply, inattentive ground personnel, and…NTSB ANC91LA105Accident · No injuriesLimited investigationFinal reportCessna 182 · Girdwood, AKImproper in flight planning, fuel starvation and fuel supply not understood by the pilot. Contributing to the accident was rough and uneven terrain.NTSB CHI91DTK03Accident · 1 fatalFinal reportWag-Aero Super Cuby · Roscoe, SDThe pilot's inadvertent stall and inadequate remedial action. Associated factors are the pilot's lack of recent total experience and inadequate preflight planning/preparation.NTSB SEA91FA175Accident · 1 fatalField investigationFinal reportCessna TU206G · Mccall, IDProcedures/directives were not followed. Factors to the accident were: improper fuel boost pump selector position, leaded spark plugs and sunglare.NTSB LAX91LA317Accident · No injuriesLimited investigationFinal reportBeech 55B · Cupertino, CAFuel exhaustion which resulted from the pilot inaccurately calculating fuel consumption and fuel requirements.NTSB SEA91LA174Accident · No injuriesLimited investigationFinal reportSchrader, Edward A · Nampa, IDA loss of engine power for undetermined reasons.NTSB LAX91LA313Accident · No injuriesLimited investigationFinal reportRockwell 500S · Kahului, HIThe pilot's inadequate preflight inspection of the aircraft after refueling. The failure of the aircraft manufacturer to publish the refueling instructions in the operator's manual, the inadequate fuel servicing of the aircraft by other maintenance personnel…NTSB ATL91LA133Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Hawkinsville, GAThe pilot's inadequate preflight planning, his failure to refuel the airplane when he observed his fuel supply getting low, and the resultant exhaustion of his fuel supply.NTSB LAX91FA310Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Hesperia, CAThe pilot's improper refueling and inadequate preflight which resulted in fuel contamination and the inadvertent stall.NTSB FTW91LA121Accident · No injuriesLimited investigationFinal reportBell 206B · Freeport, TXThe pilot's failure to maintain sufficient rotor RPM during the autorotation. Factors were the fuel exhaustion induced power loss due to the pilot's improper pre-flight inspection.NTSB ATL91LA131Accident · No injuriesLimited investigationFinal reportCessna 152 · Benton, TNA loss of engine power for undetermined reasons.NTSB ANC91LA098Accident · No injuriesLimited investigationFinal reportCessna 185A · Wood River, AKThe pilot's improper in-flight planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. Soft sand in the emergency landing area was a related factor.NTSB ATL91LA128Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Hawkinsville, GAA complete loss of engine power for undetermined reasons. A factor in this accident was: the rough, uneven terrain at the forced landing site.NTSB NYC91LA176Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Stebensville, PAThe pilot's failure to refuel the airplane, his improper fuel consumption calculations, and his failure to flare the airplane during the forced landing.NTSB LAX91LA298Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Indian Springs, NVFuel exhaustion due to improper preflight planning, and failure to refuel the aircraft. Factors in the accident were: 1) the pilot becoming lost/disoriented ; 2) the dark night conditions; 3) the failure of the pilot to seek help in a timely fashion; and 4)…NTSB BFO91LA067Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Norton, WVThe pilot's inadequate inflight decision which resulted in fuel exhaustion and the lost of engine power.NTSB SEA91LA162Accident · Minor injuriesLimited investigationFinal reportAeronca 65-CA · West Jordan, UTThe pilot's delayed switching of the fuel tank selector, the engine failure from fuel starvation and the unsuitable terrain for a forced landing.NTSB NYC91LA175Accident · No injuriesLimited investigationFinal reportCessna 182 · Xenia, OHTotal loss of engine power due to fuel exhaustion resulting in a forced landing and subsequent nose over during the landing roll. Factors related to the accident was the pilot's failure to ensure sufficient fuel was available for the flight.NTSB LAX91LA291Accident · No injuriesLimited investigationFinal reportBeech F33A · Wickenberg, AZThe loss of engine power for undetermined reasons. A factor was the unsuitable terrain.NTSB LAX91FA292Accident · 2 fatalField investigationFinal reportBeech G35 · Pacoima, CAImproper positioning of the fuel selector by the pilot, which resulted in fuel starvation.NTSB ANC91LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Woodchopper Crk, AKEngine failure due to fuel exhaustion, the pilot's inadequate preflight planning and the unsuitable terrain. Contributing to the accident was the pilot's lack of total experience.NTSB NYC91LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · Millville, OHThe pilot's improper in-flight planning/decision after becoming lost, resulting in engine fuel exhaustion. Factors related to the accident were: the pilot's lack of familiarity with the geographic area, and his lack of experience in this type of operation.NTSB MIA91LA179Accident · No injuriesLimited investigationFinal reportCessna 182C · Keystone Hghts, FLTotal loss of engine power due to fuel exhaustion due to fuel siphoning overboard, and failure of the pilot to perform an adequate preflight inspection to insure the fuel caps were secured. Contributing to the accident was incorrect fuel tank quantity gauges…NTSB CHI91LA214Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Sparta, MIInadequate preflight by the pilot and the pilot's failure to reach a proper touchdown point.