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 MIA98LA005Accident · Minor injuriesLimited investigationFinal reportCessna P172D · Umatilla, FLThe improper fuel tank selector position by the pilot-in-command resulting in the total loss of engine power due to fuel starvation.NTSB CHI98LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Nebraska City, NEthe pilot's improper positioning of the fuel slector to a tank which contained only unusable fuel.NTSB FTW97LA371Accident · Minor injuriesLimited investigationFinal reportSiai-Marchetti F.260 · Santa Rosa, NMimproper planning/decision by the pilot, which led to fuel exhaustion, loss of engine power, and a forced landing. A related factor was the lack of suitable terrain for the forced landing.NTSB ATL97LA142Accident · No injuriesLimited investigationFinal reportBeech 33 · Winston-Salem, NCthe pilot's improper planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing.NTSB ATL97LA141Accident · No injuriesLimited investigationFinal reportTomlinson Pober Super ACE · Lebanon, TNThe pilot's failure to follow normal checklist procedures that resulted in fuel starvation.NTSB SEA97LA216Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Creswell, ORThe pilot's improper fuel management in which the fuel selector was positioned on tank with inadequate fuel resulting in fuel starvation. Also causal was the pilot's failure to perform the pilot operating handbook 'engine failure in flight' procedure. A…NTSB LAX97FA330Accident · 2 fatalField investigationFinal reportRyan Navion B · Pacoima, CAthe dual student's improper positioning of the fuel selector and the CFI's inadequate supervision, which led to a takeoff with the auxiliary fuel tank selected and resulted in fuel starvation. A contributing factor was the position of the nomenclature on the…NTSB NYC97LA192Accident · No injuriesLimited investigationFinal reportCessna 150G · Forest, VAthe pilot's movement of the mixture control to the idle cut-off position, during an approach to land, which resulted in a loss of engine power and a forced landing before reaching the runway.NTSB FTW97LA355Accident · Serious injuriesLimited investigationFinal reportAmerican General AG5B · Texarkana, ARthe pilot's improper planning/decision, by failing to ensure timely refueling of the airplane, which resulted in fuel exhaustion, loss of engine power, and a forced landing.NTSB ATL97FA135Accident · 1 fatalField investigationFinal reportCessna 182G · Lexington, TNImproper planning/decision by the pilot, which led to the fuel exhaustion, loss of engine power, and a forced landing. Trees in the emergency landing area were a related factor.NTSB IAD97LA121Accident · Minor injuriesLimited investigationFinal reportPohlman/Pohlman Rotorway Exec 90 · Westminster, MDThe loss of power due to carburetor icing. A factor to this accident was the carburetor heat was not accessible from within the cockpit.NTSB ANC97LA153Accident · No injuriesLimited investigationFinal reportCessna 185E · Wasilla, AKThe loss of engine power due to water contaminated fuel, and the pilot's inadequate preflight inspection of the airplane. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB ATL97LA139Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Mcgee, MSfuel starvation, while in maneuvering flight, due to the pilot's improper planning/decision.NTSB CHI97LA297Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Indianapolis, INthe pilot's improper planning/decision and failure to refuel the airplane in a timely manner, which resulted in fuel exhaustion. A related factor was: trees in the emergency landing area.NTSB SEA97LA210Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · The Dalles, ORthe pilot-in-command(CFI)'s failure to refuel which subsequently led to fuel exhaustion.NTSB NYC97LA182Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Crimora, VAThe pilot's mismangement of fuel which resulted in fuel exhaustion. Contributing was his inadequate preflight planning that resulted in an inadequate fuel supply..NTSB LAX97LA322Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Hilo, HIfailure of the pilot to verify the quantity of fuel before departure, and to monitor fuel consumption during the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Tall grass in the emergency landing was a related factor.NTSB LAX97LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Murrieta, CAfailure of the flight instructor (CFI) to ensure an adequate preflight of the airplane, and his failure to properly quantify or verify the fuel onboard before departing on a dual instruction flight, which resulted in fuel exhaustion and a forced landing.NTSB FTW97LA343Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hillsboro, TXFuel contamination from an undetermined source. A factor was the lack of suitable terrain for the forced landing.NTSB LAX97LA316Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Madera, CAfuel exhaustion due to the pilot's failure to compute the fuel required and the fuel available. The pilot's decision to extend his downwind beyond gliding distance of the runway after entering the traffic pattern was a factor in this accident.NTSB LAX97LA314Accident · Serious injuriesLimited investigationFinal reportHallam RV-6 · Woodlake, CAfailure of the pilot to accurately determine the quantity of fuel onboard the airplane before flight, and subsequent loss of engine power due to fuel starvation, which resulted in a forced landing.NTSB ATL97FA134Accident · 2 fatalField investigationFinal reportNorth American T-6-SNJ5 · Camden, SCThe pilot's failure to take remedial action after a loss of engine power for undetermined reasons, leading to a spin. Factors were the pilot's use of unapproved medication, and the FAA's inadequate certification and standards for airman.NTSB NYC97LA175Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Fredericksburg, VAA loss of engine power for undetermined reasons.NTSB IAD97LA116Accident · Minor injuriesLimited investigationFinal reportBeech Musketeer 23 · Wauseon, OHThe pilot's fuel mismanagement by his failure to switch fuel tank positions, which resulted in the fuel starvation and the loss of engine power.NTSB CHI97LA276Accident · No injuriesLimited investigationFinal reportCessna 150J · Romeo, MIthe pilot's improper use of carburetor heat, which resulted in carburetor ice and loss of engine power. Factors relating to the accident were: carburetor icing conditions, and the crop (corn) in the emergency landing area.NTSB NYC97GA177Accident · No injuriesFinal reportNavion G · Brooklyn, NYthe pilot's inadequate preflight by failing to ensure the fuel selector was properly positioned for takeoff, which resulted in fuel starvation, loss of engine power, and a forced landing after takeoff.NTSB CHI97LA281Accident · No injuriesLimited investigationFinal reportCessna 150M · Benton, KSthe flight instructor's (CFI') improper in-flight planning/decision, which led to fuel exhaustion and loss of engine power before the airplane was safely landed.NTSB FTW97LA332Accident · No injuriesLimited investigationFinal reportPitts S-2B · Mountain View, ARFuel exhaustion due to the pilot's inadequate preflight planning. A factor was the lack of suitable terrain for the forced landing.NTSB ATL97LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLthe flight instructor's (CFI's) inaccurate assessment of fuel available for the flight, and his improper in-flight planning/decision by continuing the training flight with minimal fuel, which resulted in fuel exhaustion and loss of engine power.NTSB LAX97LA305Accident · No injuriesLimited investigationFinal reportCessna 152 · Mecca, CAfuel exhaustion as a result of the student pilot's inadequate preflight and failure to refuel.NTSB LAX97LA302Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Kenwood, CAthe pilot's improper planning/decision, which resulted in fuel exhaustion and a forced landing, due to an inadequate supply of fuel.NTSB ANC97LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Bethel, AKthe pilot's improper selection of a fuel tank that did not contain fuel, which resulted in subsequent fuel starvation and loss of engine power. A factor relating to the accident was: the inability to reach suitable terrain for a forced landing.NTSB MIA97FA239Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Brownsville, TNthe pilot's inadequate preflight, and his improper in-flight planning/decision, which led to fuel exhaustion and a forced landing at night on unprepared terrain. Factors relating to the accident were: darkness, and the lack of a suitable area for an emergency…NTSB FTW97LA324Accident · No injuriesLimited investigationFinal reportCessna 182A · Delta, COFailure by the pilot to properly plan for the flight in that the fuel aboard was insufficient for the planned flight. Factors were: inaccurate fuel gauges and terrain condition for the forced landing.NTSB CHI97LA267Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Coopersville, MIthe pilot inadequate fuel system management which led to a fuel starvation.NTSB LAX97LA299Accident · Serious injuriesLimited investigationFinal reportCessna 210E · Oxnard, CAThe failure of maintenance personnel to properly secure a fuel supply line during a 100-hour inspection and the failure of inspection personnel to detect the loose fitting.NTSB LAX97LA298Accident · No injuriesLimited investigationFinal reportBeech H35 · Vacaville, CAThe pilot's mismanagement of the fuel supply which resulted in fuel starvation. A contributing factor was inoperative fuel gauges.NTSB NYC97LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Blairsville, PAthe pilot's inaccurate fuel consumption calculations and improper in-flight planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing.NTSB NYC97LA167Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Brickerville, PAFuel starvation as a result of the pilot performing a takeoff with the fuel selector in the 'OFF' position.NTSB FTW97LA316Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Caldwell, TXThe loss of engine power due to fuel exhaustion which resulted from a leaking fuel cap. Factors were the dark night conditions, and the lack of suitable terrain for the forced landing.NTSB SEA97LA192Accident · No injuriesLimited investigationFinal reportCessna 175 · Lynnwood, WAThe pilot's inadequate preflight planning and preparation, which led to fuel exhaustion and subsequent loss of engine power.NTSB NYC97LA166Accident · Minor injuriesLimited investigationFinal reportCessna 425 · Perkasie, PAthe pilot's inadequate preflight, by failing to verify the fuel supply, which led to subsequent fuel exhaustion and loss of engine power. A related factor was: the inaccurate fuel quantity gauge.NTSB LAX97LA283Accident · Serious injuriesLimited investigationFinal reportCessna 195 · Santa Ana, CAWater contamination in the fuel system due to the failure of the mechanic who performed the last annual inspection to adequately comply with the AD which required inspection of the fuel tank filler area for proper sealing, and the pilot's inadequate preflight…NTSB NYC97LA162Accident · Minor injuriesLimited investigationFinal reportSimpson Avid Flyer · Westerly, RIThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.NTSB FTW97LA303Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Los Alamos, NMThe fuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB LAX97LA278Accident · No injuriesLimited investigationFinal reportCessna 150G · Palos Verdes, CALoss of engine power due to fuel starvation and the pilot's mismanagement of the aircraft's fuel supply.NTSB FTW97LA307Accident · Serious injuriesLimited investigationFinal reportCessna T210 · Eagle, COwater contamination of the fuel, which led to a total loss of engine power and a forced landing. Factors relating to the accident were: the delay in refueling the aircraft by the FBO, which allowed condensation to form in the fuel tanks, and inadequate…NTSB LAX97LA282Accident · No injuriesLimited investigationFinal reportMooney M20K · Lakeport, CAthe pilot's inadequate preflight by failing to ensure that the fuel selector was positioned to a tank containing fuel, which resulted in fuel starvation, and a forced landing shortly after takeoff.NTSB ATL97LA117Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Rockhill, SCThe pilot's failure to plan and have adequate fuel for the flight.NTSB NYC97LA161Accident · No injuriesLimited investigationFinal reportCessna A150L · Waynesburg, PAthe pilot's inadequate preflight by failing to ensure there was adequate fuel on board, which resulted in fuel exhaustion during takeoff.