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 CHI00LA031Accident · No injuriesLimited investigationFinal reportCessna 182 · Shelbyville, INthe inadequate preflight planning by the pilot and the exhaustion of usable fuel. A factor was the drainage ditch encountered on landing.NTSB DEN00LA018Accident · No injuriesLimited investigationFinal reportCessna 172N · Rawlins, WYThe pilot's inadequate preflight planning preparation which resulted in fuel exhaustion. Factors in the accident were the unsuitable terrain on which to make a forced landing and the pilot's lack of experience in aircraft type.NTSB NYC00LA030Accident · No injuriesLimited investigationFinal reportCessna 150 · New Hope, PAThe pilot's failure to identify during the preflight that both fuel vents were blocked, resulting in a total loss of engine power.NTSB FTW00LA025Accident · Minor injuriesLimited investigationFinal reportStreifthau Baby Great Lakes · Iowa Park, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel the airplane.NTSB FTW00LA023Accident · No injuriesLimited investigationFinal reportCessna 172B · Beaumont, TXFuel exhaustion as a result of the flight instructor's failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bogalusa, LAThe total loss of engine power as a result of water contamination in the fuel system.NTSB SEA00LA008Accident · No injuriesLimited investigationFinal reportCessna 150B · Sweet Home, ORCarburetor heat was not used prior to takeoff. Carburetor icing conditions and high vegetation were factors.NTSB FTW00LA019Accident · No injuriesLimited investigationFinal reportCessna TU206A · Jeanerette, LAThe total loss of power for undetermined reasons and the pilot's failure to maintain airspeed, while clearing a ditch during a forced landing, resulting in an inadvertent stall. A factor was the ditch.NTSB LAX00LA021Accident · No injuriesLimited investigationFinal reportCessna 172N · Deer Valley, AZFuel exhaustion due to the pilot's inadequate preflight verification of the fuel quantity, and, once he became aware of the critical fuel state, his decision to over-fly two alternate airports in order to continue to his destination.NTSB MIA00LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Bayou La Batre, ALThe pilot's improper preflight fuel planning and the his improper en route fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion.NTSB MIA00LA007Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lebanon, TNThe inadequate annual inspection of the airplane by the mechanic for his failure to note that the threaded portion of the bail wire had 2 1/2 failed threads which resulted in the inability to keep the gascolator bowl tightly secured. Also his failure to note…NTSB MIA00FA003Accident · 2 fatalField investigationFinal reportBell 206B · Centreville, ALThe pilot's inadequate preflight inspection of the helicopter's fuel system resulting in an in-flight loss of engine power due to fuel exhaustion as a result of overboard porting of fuel when the airframe fuel filter was left in the 'drain and locked'…NTSB MIA00LA001Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pensacola, FLThe failure of the pilot to ensure the aircraft contained adequate fuel to complete the flight resulting in engine failure due to fuel exhaustion and damage to the aircraft during the subsequent forced landing.NTSB ANC00LA001Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Anchorage, AKThe pilot's inadequate preflight inspection to remove all contaminated fuel from the fuel system. A factor associated with the accident was an unsuitable terrain condition for landing.NTSB NYC00LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wolfeboro, NHA total loss of engine power for undetermined reasons.NTSB LAX00LA002Accident · No injuriesLimited investigationFinal reportZdybel Glasair FT · Rio Linda, CAFuel starvation due to the owner/builder's improper installation of the fuel selector valve, and, his failure to placard the operating positions of the valve handle.NTSB FTW99LA273Accident · No injuriesLimited investigationFinal reportCessna 152 · Slaton, TXThe pilot's failure to refuel the airplane resulting in fuel exhaustion. Factors were the pilot's inadequate preflight planning and the lack of suitable terrain for the forced landing.NTSB CHI99LA348Accident · No injuriesLimited investigationFinal reportCessna 172N · Des Moines, IAthe pilot's improper in-flight planning and decisions which led to fuel exhaustion. A factor relating to this accident was the telephone pole.NTSB CHI99LA347Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Henrietta, MOThe engine failure due to mismanagement of the fuel system and aircraft control not maintained by the pilot.NTSB LAX99LA318Accident · No injuriesLimited investigationFinal reportCiernia Glasair III · Snelling, CAThe pilot's inadequate preflight inspection, which failed to ensure that the left fuel filler cap was secure, and his decision to continue flight with a known malfunction in the electric fuel pump. Also causal was the pilot's improper positioning of the fuel…NTSB ANC99LA151Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Galena, AKThe pilot's failure to refuel, and the resulting fuel exhaustion. A factor was the dark night which hampered location of a nearby closed, and unlit, airstrip.NTSB DEN99LA166Accident · No injuriesLimited investigationFinal reportCessna 172G · Delta, COA forced landing due to fuel exhaustion. Factors were inadequate preflight planing, inadequate in-flight planing and rough uneven, unsuitable terrain for a forced landing.NTSB ATL99FA134Accident · 2 fatalField investigationFinal reportBeech BE-35-J35 · Bartow, FLThe pilot's inadequate fuel management that resulted in the complete loss of engine power.NTSB DEN99LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Murray, UTA forced landing on unsuitable terrain. Factors were fuel exhaustion and inaccurate preflight planning by the flight instructor.NTSB FTW99LA257Accident · No injuriesLimited investigationFinal reportCessna 150J · Frisco, TXFuel exhaustion due to the pilot's inadequate preflight and his failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.NTSB NYC99LA223Accident · No injuriesLimited investigationFinal reportBeech A23 · Carlisle, PAThe pilot's improper fuel management, resulting in fuel starvation.NTSB SEA99LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Hillsboro, ORLoss of engine power due to fuel contamination.NTSB FTW99LA254Accident · No injuriesLimited investigationFinal reportMooney M20D · Edna, TXFuel exhaustion due to the pilot's inadequate preflight planning. A factor was the lack of suitable terrain for the forced landing.NTSB ATL99LA128Accident · No injuriesLimited investigationFinal reportCessna 182P · Collegedale, TNThe pilot's failure to secure the fuel cap which resulted in fuel exhaustion and the loss of engine power. A factor was the collision with a fence post.NTSB ATL99LA125Accident · No injuriesLimited investigationFinal reportCessna 172P · Buchanan, GAThe loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice during glide and cruise, and rough and uneven terrain.NTSB LAX99LA296Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Big Bear City, CAThe pilot's failure to follow the manufacturer's procedures to fully enrich the mixture, which induced an overly lean condition during full power application on the go-around and a resulting loss of power. The high density altitude weather condition was a…NTSB DEN99LA174Accident · No injuriesLimited investigationFinal reportCessna P210N · Santa Fe, NMA non-mechanical total loss of engine power for reasons undetermined. Factors were maneuvering to avoid oncoming vehicles, and the rough and uneven terrain.NTSB MIA99FA245Accident · 8 fatalField investigationFinal reportBeech B-90 · West Palm Beach, FLa total loss of engine power due to fuel exhaustion. Contributing factors in this accident were the pilot's operation of the airplane in an overweight condition, inadequate pre-flight and in-flight planning.NTSB NYC99LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Greenville, METhe pilot in command's inattentive management of the fuel supply.NTSB FTW99LA251Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Big Spring, TXFuel exhaustion as a result of the pilot's failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.NTSB LAX99LA293Accident · No injuriesLimited investigationFinal reportBell 206B · Delhi, CAThe loss of engine power due to the pilot's inadequate preflight, which failed to detect water contamination of the fuel system. The operator's inadequate maintenance of the loose fitting fuel cap and the deformed filler opening, which allowed water to leak…NTSB ATL99LA121Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cairo, GAThe loss of engine power for undetermined reasons. Factors were weather conditions favorable for the formation of carburetor ice.NTSB LAX99LA289Accident · Minor injuriesLimited investigationFinal reportCessna P210N · North Las Vegas, NVThe pilot's improper procedure in that he failed to follow the flight manual, resulting in a loss of engine power and subsequent collision with the ground.NTSB MIA99FA232Accident · 1 fatalField investigationFinal reportBeech C24R · Pickens, SCThe pilot's failure to properly preflight plan and prepare for the flight's fuel consumption resulting in engine loss of power due to fuel exhaustion and the subsequent inflight collision with trees.NTSB FTW99LA233Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Zachary, LAThe total loss of engine power due to fuel exhaustion resulting from the pilot's failure to refuel and his disorientation. Factors were the dusk light conditions and the lack of suitable terrain for the forced landing.NTSB FTW99LA229Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Houston, TXThe loss of engine power as a result of fuel starvation due to the pilot's improper fuel management.NTSB DEN99LA164Accident · No injuriesLimited investigationFinal reportCessna 180 · Columbus, NMFuel exhaustion because the pilot issued instructions that the fuel tanks not be filled to capacity. A factor was the unsuitable terrain on which to make a forced landing.NTSB LAX99LA268Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Sacramento, CAFuel exhaustion due to the pilot's failure to ensure that sufficient fuel was on board to complete the flight, and, the flight instructor's inadequate supervision of the flight.NTSB CHI99LA292Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Hudson, MIwas an inadequate preflight and misjudged flare to landing during the autorotation by the pilot. A factor in this accident was a totally blocked fuel tank vent system.NTSB LAX99LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Buckeye, AZfuel exhaustion due to the pilot's inaccurate fuel consumption calculations used in flight planning.NTSB FTW99LA220Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Humphrey, ARFuel exhaustion as a result of the pilot's failure to refuel the airplane.NTSB FTW99LA218Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Ferriday, LAThe pilot's failure to refuel the airplane which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA250Accident · No injuriesLimited investigationFinal reportCessna 177 · Austin, TXFuel exhaustion as a result of the pilot's failure to refuel the airplane.NTSB DEN99LA140Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Hasty, COThe pilot's failure to refuel his airplane, and the subsequent airborne fuel exhaustion. Factors were the lack of suitable terrain for a forced landing, and the high vegetation in the field.NTSB MIA99LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Greenville, SCThe improper position of the fuel selector by the pilot-in-command resulting in the loss of engine power due to fuel starvation. Also, the inadequate altitude flown by the pilot on final approach preventing a landing on the runway following the loss of engine…