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 MIA97LA227Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Tullahoma, TNthe pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation, a forced landing, and impact with a tree.NTSB NYC97LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Ashland, OHThe pilot's improper fuel management which resulted in fuel exhaustion and loss of engine power.NTSB FTW97LA294Accident · No injuriesLimited investigationFinal reportBeech C24R · Pollock, LAThe loss of engine power due to fuel starvation and the pilot's improper use of the fuel selector. Factors were the pilot's failure to use the checklist and the lack of suitable terrain for the forced landing.NTSB FTW97LA293Accident · Minor injuriesLimited investigationFinal reportBauer Vans RV-4 · Seminole, TXloss of engine power due to fuel starvation as a result of the pilot's improper use of the fuel tank selector.NTSB FTW97LA290Accident · No injuriesLimited investigationFinal reportCessna A150K · Elgin, OKfuel contamination, and the pilot's inadequate preflight of the airplane. Trees in the emergency landing area were considered a related factor.NTSB NYC97LA151Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Sussex, NJthe pilot's improper management of the fuel supply. A related factor was the inoperative low fuel quantity light for the rear tank.NTSB LAX97LA254Accident · No injuriesLimited investigationFinal reportBeech 77 · Lakeport, CAcarburetor ice, and the failure of both pilot's to use (or properly use) carburetor heat. Factors relating to the accident were: the weather (carburetor icing) conditions, and obstructions in the forced landing area (grape vineyard).NTSB CHI97LA215Accident · No injuriesLimited investigationFinal reportCessna 182 · Chippewa Falls, WIthe pilot's misjudgment of the fuel supply, and subsequent fuel exhaustion.NTSB FTW97LA272Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Chickasha, OKthe pilot's improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power. Factors relating to the accident were: the pilot's failure to follow the checklist, and the lack of suitable terrain for the forced landing.NTSB LAX97FA253Accident · 2 fatalField investigationFinal reportMooney M20J · Placerville, CAA loss of engine power for undetermined reasons.NTSB FTW97FA269Accident · 1 fatalField investigationFinal reportMooney M20C · Sarepta, LAThe pilot's impairment (drugs) resulting in his becoming disoriented and the ensuing loss of engine power due to fuel exhaustion. Factors were the lack of suitable terrain for the forced landing and the inaccurate navigation chart.NTSB SEA97LA168Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Idaho Falls, IDThe pilot mismanaged his fuel supply which led to fuel exhaustion and subsequent loss of engine power. Factors contributing to the accident were the lack of adequate altitude and airspeed to successfully execute an autorotation.NTSB FTW97LA268Accident · No injuriesLimited investigationFinal reportCessna 152 · Lufkin, TXThe loss of engine power due to fuel exhaustion, which resulted from the student pilot becoming disoriented. A factor was the lack of suitable terrain for the forced landing.NTSB NYC97LA142Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Jersey City, NJThe pilot's mismangement of the fuel supply, by which he failed to switched fuel tanks, which resulted in fuel starvation and the loss of engine power.NTSB LAX97LA240Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gila Bend, AZthe pilot's failure to verify the fuel quantity prior to departure, and his failure to perform sufficient en route fuel consumption calculations during the cross-country flight.NTSB SEA97LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Naches, WAinadequate preflight by the pilot, and subsequent fuel exhaustion, which led to a forced landing and subsequent nose over of the aircraft. Related factors were: the FBO did not refuel the aircraft as requested, and soft terrain was encountered during the…NTSB LAX97LA232Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Santa Paula, CAFuel exhaustion due to the pilot's inadequate preflight planning/inspection and his failure to ensure that adequate fuel was onboard prior to departure.NTSB CHI97LA199Accident · No injuriesLimited investigationFinal reportSnow S2C · Viola, ILthe pilot's inadequate preflight planning/preparation by failing to ensure there was an inadequate supply of fuel for the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Uneven terrain in the emergency landing area was a…NTSB FTW97LA244Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXfuel exhaustion, due to the pilot's failure to refuel before taking off on the remainder of the flight after making a precautionary landing. Factors related to the accident were: the pilot becoming lost and disoriented, and the lack of suitable terrain for a…NTSB LAX97LA226Accident · Serious injuriesLimited investigationFinal reportCessna 182C · Rimrock, AZFuel starvation due to the pilot's failure to monitor the fuel level in the right tank, and to select a tank containing fuel during the approach and landing in accordance with the checklist.NTSB ATL97FA090Accident · 1 fatalField investigationFinal reportBeech 35-C33A · Lugoff, SCimproper fuel management by the pilot by not positioning the fuel selector to the fullest tank for landing, which resulted in fuel starvation, loss of engine power, and a forced landing. Trees in the emergency landing area were a factor.NTSB MIA97LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sanford, FLFailure of the oil cooler radiator hose which resulted in oil exhaustion and subsequent engine failure. Contributing to the accident was the failure of the FAA to require a recurrent detailed examination and or require those hoses be life limited to prevent…NTSB ANC97LA091Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Chugiak, AKwater contamination in the fuel, the second pilot's inadequate preflight/preparation to ensure all water was drained from the airplane fuel tanks, and inadequate supervision by the first pilot (CFI). A factor relating to the accident was: the lack of suitable…NTSB CHI97FA187Accident · Serious injuriesField investigationFinal reportPiper PA-22-108 · Lenox Township, MIThe pilot's failure to follow the procedures and directives as listed on the placard in the aircraft resulting in fuel starvation and subsequent engine failure.NTSB MIA97LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Walls, MSThe poor in-flight planning by the pilot for her failure to divert to an alternate airport after recognizing that a low fuel quantity state existed when preflight and in-flight planning revealed sufficient fuel for the flight. Contributing to the accident was…NTSB FTW97LA232Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · El Indio, TXthe pilot's inadequate preflight, subsequent fuel starvation, and failure of the pilot to reposition the fuel selector to another tank (perform emergency procedure) after the loss of engine power, which resulted in a forced landing and subseqent nose-over.…NTSB SEA97FA148Accident · 2 fatalField investigationFinal reportBeech 77 · Cottage Grove, ORFuel exhaustion resulting from the pilot's inadequate preflight planning/preparation and his failure to maintain adequate airspeed during a forced landing approach, resulting in a stall. A related factor was the pilot's failure to refuel.NTSB CHI97LA175Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Wamego, KSinaccurate preflight planning which resulted in an inadequate fuel supply for the flight and ultimately fuel exhaustion. Factors associated with the accident were the powerlines and the parachutists over the runway.NTSB SEA97LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Sweet Home, ORThe pilot's inadequate preflight preparation and his inadequate inflight planning which resulted in fuel exhaustion. A factor was lack of suitable terrain for a forced landing.NTSB CHI97LA173Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Kaiser, MOwas fuel starvation for undetermined reasons. A factor was the failure of the pilot to refuel the aircraft.NTSB CHI97LA171Accident · Serious injuriesLimited investigationFinal reportRoe-Wayne Mustang II · Portage, MIinadequate fuel system design by the owner/builder, which led to fuel starvation as the airplane was on a 'flat' approach to land. The pilot's inadequate flight planning was a factor, in that he did not fly the traffic pattern of this first test flight, in a…NTSB LAX97TA213Accident · No injuriesFinal reportBell 47G-3B-1 · Fallon, NVexhaustion of the aircraft's fuel supply, due to improper planning and/or decision. A factor related to the accident was the high density altitude which made a successful autorotative landing unlikely.NTSB MIA97LA184Accident · No injuriesLimited investigationFinal reportCessna 150G · Greer, SCthe student pilot's improper management of fuel, which resulted in fuel exhaustion, loss of engine power, and subsequent collision with trees and terrain.NTSB IAD97LA090Accident · No injuriesLimited investigationFinal reportCessna 150 · Punxsutawney, PAPilot in command became disoriented and continued flight until fuel exhaustion. A factor to this accident is the pilot's inadequate in-flight planning/decision by over flying several airports during his disorientation.NTSB FTW97LA224Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Little Rock, ARa loss of engine power due to fuel starvation from a partially blocked fuel line which was the result of improper maintenance by unknown person(s). A factor was the lack of suitable terrain for landing.NTSB FTW97LA219Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Biggers, ARThe total blockage of a fuel line by a silicone rubber contaminant which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB NYC97LA111Accident · No injuriesLimited investigationFinal reportCessna 150K · Jay, MEthe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.NTSB SEA97LA132Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Big Creek, IDthe pilot's improper positioning of the fuel selector to the 'OFF' position, which resulted in fuel starvation and loss of engine power during takeoff. Factors relating to the accident were: down-sloping terrain (airstrip) and trees that were encountered…NTSB SEA97FA130Accident · 1 fatalField investigationFinal reportLockheed P-38L · Tillamook, ORfailure of the pilot to maintain minimum control speed (VMC), after loss of power in one engine, which resulted in a loss of aircraft control and collision with terrain. Related factors were: the pilot's improper fuel management and failure to change the fuel…NTSB ATL97LA082Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Daytona Beach, FLThe pilot's mismanagement of fuel, resulting in fuel exhaustion.NTSB ATL97LA081Accident · No injuriesLimited investigationFinal reportCessna 172I · N. Myrtle Beach, SCThe pilot's inadequate pre-flight inspection which resulted in fuel exhaustion and total loss of engine power. A factor was the soft terrain at the emergency landing site.NTSB IAD97GA081Accident · Minor injuriesFinal reportPiper PA-18-150 · Harrisonburg, VAThe pilot's preoccupation which led to fuel starvation of the selected tank and the subsequent forced landing.NTSB CHI97LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Alanson, MIinadequate preflight by the pilot, which resulted in fuel starvation, due to an improper fuel tank selector position. A factor relating to the accident was: the pilot's improper inflight planning/decision, which resulted in his delay or inability to flare the…NTSB FTW97LA212Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Woodsboro, TXThe loss of engine power as result of fuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the unsuitable terrain available for the pilot to execute the forced landing.NTSB NYC97LA100Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Baltimore, MDthe pilot's inadequate preflight of the airplane which failed to detect water in the fuel, and resulted in a power loss after departure due to fuel contamination.NTSB FTW97LA198Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Ward, ARThe loss of engine power resulting from fuel starvation due to the pilot's mismanagement of available fuel. A factor was the lack of suitable terrain for a forced landing.NTSB LAX97LA193Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Rota, Sarkthe unauthorized use of automobile gasoline which led to the loss of engine power due to fuel vapor generation.NTSB SEA97LA119Accident · No injuriesLimited investigationFinal reportGarlick UH-1H · Lolo, MTFuel exhaustion due to the pilot's failure to refuel.NTSB LAX97LA190Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lamont, CAthe pilot's failure to maintain adequate fuel for the flight.