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 NYC89LA153Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Newport, METhe aircraft fuel supply was contaminated by water and the pilot's inadequate preflight.NTSB BFO89LA050Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Weirton, WVLoss of engine power due to water in the fuel and inadequate preflight inspection of the airplane by the pilot.NTSB NYC89DHA01Accident · No injuriesFinal reportVehafric Jungster ONE · Reading, PAThe failure of the pilot to properly use carburetor heat.NTSB SEA89LA185Accident · No injuriesLimited investigationFinal reportAeronca 65-C · New Meadows, IDImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB LAX89LA235Accident · No injuriesLimited investigationFinal reportCessna 172E · Mariposa, CAStudent pilot's miscalculation of the fuel supply which led to a loss of engine power due to fuel exhaustion.NTSB FTW89LA116Accident · No injuriesLimited investigationFinal reportCessna 152 · Addison, TXImproper planning/decision by the solo student pilot and inadequate supervision by the student's instructor pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the instructor pilot's lack of…NTSB CHI89LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Middletown, OHFuel starvation from improper movement of the fuel selector by the pilot and his improper use of emergency procedures during the attempted engine restart. Contributing factors were the pilot's lack of experience in this type of aircraft and the terrain…NTSB FTW89LA115Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Waco, TXA deteriorated fuel cap, water contamination of the fuel, and the pilot's inadequate preflight of the aircraft. A factor related to the accident was: the dirt bank (berm).NTSB ATL89LA168Accident · No injuriesLimited investigationFinal reportCessna 172 · Centreville, ALThe student pilot's failure to remove all remaining water from the airplane fuel system during pre-flight inspection which led to a total loss of power.NTSB CHI89LA118Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Indianapolis, INFuel contamination from a deteriorating part in the carburetor. The trees and improper maintenance/servicing of the aircraft were probable contributing factors.NTSB ATL89FA167Accident · Serious injuriesField investigationFinal reportCessna 140 · Conyers, GACarburetor ice and the pilot's improper use of carburetor heat. Carburetor icing condition was a related factor.NTSB CHI89FA117Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Delphi, INImproper planning/decision of the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel, and his failure to maintain flying speed during a forced landing, which resulted in a stall and subsequent impact with the ground.NTSB LAX89LA224Accident · No injuriesLimited investigationFinal reportCessna 340 · Paso Robles, CAImproper use (mismanagement) of the fuel system by the pilot, which resulted in fuel starvation. Related factors were: the lack of fuel quantity indicators (not installed) in the aircraft, flight by the pilot with this known deficiency, and trees in the…NTSB DEN89LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA28-180 · Broomfield, COThe failure of the student to properly plan the flt resulting in fuel exhaustion.NTSB LAX89LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · El Cajon, CAThe inadequate maintenance of the airplane & inadequate preflight inspection which resulted in the undetection of contaminated fuel.NTSB MIA89FA177Accident · 1 fatalField investigationFinal reportUhley-Mason R.A.F. VARI-EZE · Lantana, FLPilots inadvertent turning off of the engine ignition switches resulting in engine failure.NTSB LAX89LA220Accident · No injuriesLimited investigationFinal reportCommonwealth 185 · Sacramento, CAFuel exhaustion due to the pilot's failure to accurately determine the fuel load prior to departure.NTSB MIA89LA175Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Miramar, FLInadequate planning/decision by the pilot, which resulted in loss of engine power due to fuel exhaustion. A contributing factor was the faulty reading from the fuel quantity indicator.NTSB LAX89LA214Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Diego, CAFuel starvation due to the pilot's inadvertent selection of the off position on the fuel selector.NTSB ANC89FA094Accident · 4 fatalField investigationFinal reportPiper PA-22 · Kenai, AKInadequate preflight by the pilot and fuel exhaustion.NTSB MKC89LA134Accident · No injuriesLimited investigationFinal reportGrumman G164 · Brinkley, ARThe failure of the aircraft engine due to water contamination. The pilot executed a landing in a flooded rice field which did not permit a successful landing.NTSB DEN89LA136Accident · No injuriesLimited investigationFinal reportCessna 150M · Gooding, IDImproper inflight decision of the pilot to continue the flight without refueling which resulted in fuel exhaustion.NTSB SEA89FA104Accident · 1 fatalField investigationFinal reportAnderson BD-5 · Everett, WAInadequate maintenance by the pilot/owner/builder, his operation of the aircraft with a known deficiency, and his failure to maintain adequate airspeed during an emergency descent, which resulted in an inadvertent stall.NTSB FTW89LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Kaufman, TXStudent pilot inadvertently becoming lost/disoriented and exhausting the fuel in the fuel system.NTSB DEN89LA137Accident · No injuriesLimited investigationFinal reportCessna 182 · Moab, UTFailure of the pilot to refuel the aircraft before the flight and company induced pressure by the company/operator management, which resulted in fuel exhaustion from a lack of fuel. The terrain conditions and the tree were considered to be contributing…NTSB MKC89LA128Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Creve Coeur, MOImproper use of the carburetor heat by the pilot and carburetor ice. Contributing factors were: carburetor icing conditions, high obstructions and terrain conditions (corn crop).NTSB FTW89LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Bristow, OKThe pilot's improper fuel management and failure of the inflight restart attempt.NTSB DEN89LA134Accident · Serious injuriesLimited investigationFinal reportRyan ST-3KR · La Salle, COForeign material (insect nest) blocking the fuel system vent, which resulted in a restriction of fuel flow and fuel starvation. A related factor was the alfalfa crop in the emergency landing area.NTSB CHI89DEM02Accident · Minor injuriesFinal reportAeronca 15AC · Plainwell, MIThe pilot's decision to fly the airplane which had not been properly maintained which resulted in the fuel system blockage.NTSB MIA89LA171Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Picayune, MSInadequate preflight by the pilot and his miscalculation of fuel, which resulted in fuel starvation from lack of fuel; and the pilot's failure to see-and-avoid the power lines during the forced landing. The power lines were a contributing factor.NTSB MKC89LA132Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Scandia, KSImproper planning/decision by the pilot and fuel exhaustion. Contributing factors were the pilot becoming lost/disoriented and small trees.NTSB DEN89FA127Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Wilmington, OHThe failure of the pilot to assure an adequate fuel supply and his failure to refuel en route.NTSB FTW89LA102Accident · No injuriesLimited investigationFinal reportCessna 150L · Onalaska, TXFuel system exhaustion due to the improper planning/decision by the flight instructor, on the ground, prior to the flight and the improper inflight planning/decision by the student pilot.NTSB CHI89LA100Accident · No injuriesLimited investigationFinal reportCessna P206B · New Hudson, MIPilot's inadequate preflight which resulted in an engine failure due to water contamination of the fuel system. The wires, trees, and utility pole were related factors.NTSB CHI89LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Necedah, WIPilot-in-command's improper use of the fuel selector.NTSB ANC89FA076Accident · Minor injuriesField investigationFinal reportCessna 170B · Birchwood, AKFailure of the pilot to assure that the fuel selector was in the proper detent for takeoff. A factor related to the accident was: the soft/muddy terrain conditions in the emergency landing area.NTSB CHI89DEP05Accident · Minor injuriesFinal reportPiper PA-25-235 · Suring, WIImproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of fuel. Factors related to th accident were: the lack of suitable terrain and trees in the emergency landing area.NTSB ATL89DKJ03Accident · No injuriesFinal reportGrumman G-164A · Loxley, ALThe loss of engine power due to carburetor ice, and the pilot's improper use of carburetor heat.NTSB LAX89LA200Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Bakersfield, CAThe loss of engine power due to fuel exhaustion. The pilot did not adequately plan for the flight in that he did not calculate the fuel consumption accurately, failed to provide for adequate fuel reserves, and also failed to land at airports short of his…NTSB CHI89DCA01Accident · Minor injuriesFinal reportZengel RV-4 · Columbia, ILThe improper routing of engine fuel lines resulting in over temperature of the lines which resulted in the fuel flow to carburetor to fluctuate and cause over rich condition and loss of engine power.NTSB NYC89LA133Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N · Canaan, CTA loss of power due to contamination of the fuel system.NTSB LAX89LA199Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Arcata, CAThe pilots inaccurate fuel consumption calculations and improper fuel tank selector position. These resulted in fuel starvation to both engines when the aux tanks ran dry and the mains had fuel remaining in them. A factor in this accident was the rough…NTSB FTW89DRA05Accident · Minor injuriesFinal reportBoeing A75 · East Bernard, TXWater in fuel from improper servicing of the aircraft and improper preflight by the pilot. The tailwind & soft/wet terrain were contributing factors.NTSB ATL89LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Hinckley, OHThe pilots failure to calculate proper fuel consumption for the flight which resulted in fuel exhaustion.NTSB LAX89LA193Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Upland, CAInadequate in-flight planning/decision by the pilot in command, the instructor pilot. Factors were the private pilot did not switch the fuel tanks and the instructor did not catch it.NTSB LAX89LA190Accident · No injuriesLimited investigationFinal reportCessna 150D · Vacaville, CAThe pilots failure to accurately calculate fuel consumption during preflight planning and preparation and during the flight which resulted in fuel exhaustion.NTSB SEA89LA082Accident · No injuriesLimited investigationFinal reportCessna 172 · Woodland, WAThe pilot's poor planning and inadequate calculation of fuel consumption which resulted in fuel exhaustion.NTSB LAX89LA185Accident · Minor injuriesLimited investigationFinal reportCessna 210T · Imperial, CAThe pilots inaccurate fuel consumption calculations along with the decision to depart with inadequate fuel to insure landing at his proposed destination which resulted in fuel exhaustion. The rough/uneven terrain on which the landing was made contributed to…NTSB MKC89LA106Accident · No injuriesLimited investigationFinal reportCessna 150 · Minneapolis, MNThe pilots failure to properly calculate fuel consumption which resulted in an inadequate fuel reserve and fuel exhaustion prior to reaching his destination. During the ensuing forced landing the pilot failed to maintain airspeed which resulted in an…NTSB ATL89LA140Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Charlotte, NCComplete loss of engine power due to fuel exhaustion. The fuel exhaustion was due to the pilot not assuring an adequate fuel supply for the flight by visual inspection during his preflight inspection. Contributing was the pilot's decision to continue flight…