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 MKC90LA007Accident · No injuriesLimited investigationFinal reportCessna 182 · Hasty, ARThe engine failure due to fuel starvation resulting from the collapse at the fuel cell. The fact that the forced landing was made in dark night conditions was a factor.NTSB MIA90LA007Accident · No injuriesLimited investigationFinal reportCessna 210 · Jacksonville, FLInadequate preflight by the pilot, and fuel starvation, due to his improper positioning of the fuel selector.NTSB NYC90DNA01Accident · 1 fatalFinal reportSmeesters RV-4 · North Andover, MAThe pilot's inadequate preflight inspection, and his failure to maintain aircraft control during the resultant forced landing.NTSB MIA90LA002Accident · No injuriesLimited investigationFinal reportCessna A188B · Wauchula, FLFuel starvation, improper planning/decision by the pilot, and his failure to attained the emergency procedure. Factors related to the accident were: the low fuel level, and improper planning/decision by the pilot.NTSB MIA90LA001Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Belle Glade, FLInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. A factor related to the accident was: the terrain condition in the emergency landing area.NTSB NYC89LA217Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1C · Philadelphia, PAFuel starvation, due to the pilot's failure to assure the fuel selector was positioned to a tank with adequate fuel for landing, and his failure to follow the proper emergency procedure after the tank emptied.NTSB MIA89LA258Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Kissimmee, FLInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: false fuel gage indications and trees in the emergency landing area.NTSB MKC89LA199Accident · No injuriesLimited investigationFinal reportCessna 150 · California, MOImproper use of the carburetor heat by the pilot resulting in the formation of carburetor ice and subsequent loss of power.NTSB DEN89LA223Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Carlsbad, NMThe pilot failed to refuel the airplane in a timely manner which resulted in fuel exhaustion.NTSB LAX89DUG09Accident · No injuriesFinal reportAir Tractor AT-301A · Blythe, CAThe pilot's failure to verify the fuel supply prior to takeoff.NTSB FTW89FA171Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Elgin, TXThe pilot's inadvertent closure (deactivation) of the mixture control, which resulted in a loss of engine power, and his failure to maintain sufficient airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the gusty wind, and…NTSB LAX89LA316Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Winkelman, AZImproper in-flight planning/decision by the pilot, after he became lost/disoriented, which resulted in fuel exhaustion, before he was able to complete a precautionary landing. Factors related to the accident were: darkness, the pilot's lack of visual cues at…NTSB ANC89LA170Accident · No injuriesLimited investigationFinal reportCessna 185 · Mulchatna River, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: loss of fuel that had siphoned (leaked) from the aircraft before takeoff and tree(s) overhanging the fast…NTSB SEA89LA174Accident · Serious injuriesLimited investigationFinal reportde Havilland Beaver DHC-2 MK.1 · Kapowsin, WAAn undetermined loss of engine power.NTSB BFO89LA080Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Haymarket, VAImproper use of the fuel selector, which resulted in fuel starvation & loss of engine power; and improper use of emergency procedures after loss of engine power. The presence of high obstructions (trees) in the approach path to the emergency landing area was…NTSB ATL89LA215Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Semmes, ALImproper replacement of the fuel cap gasket by the pilot, which resulted in a blocked fuel cap vent and fuel starvation. Trees in the emergency landing area contributed to aircraft damage.NTSB FTW89FA166Accident · Serious injuriesField investigationFinal reportBeech BE 100 · Houston, TXThe inadequate preflight planning preparation & the improper inflight planning/decision by the PIC when he failed to refuel the aircraft which resulted in a total loss of power in both engines.NTSB FTW89DRG10Accident · 1 fatalFinal reportZenair CH-200 · Kerrville, TXImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB MKC89LA183Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Barnesville, MNThe pilot's failure to insure that the aircraft contained an adequate fuel supply to complete the flight.NTSB LAX89FA311Accident · Serious injuriesField investigationFinal reportCessna 152 · Buena Park, CAAn inadequate performed preflight inspection by the dual student and the inadequate supervision of the dual student by the instructor pilot. Contaminated fuel was a factor in the accident.NTSB SEA89LA169Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAThe pilot's failure to obtain current in-flight wind information in order to calculate that his remaining fuel supply was adequate to reach his final destination. Contributing was his inadequate preflight planning.NTSB MIA89LA244Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Titusville, FLFailure of the private pilot (dual student) to assure the fuel selector was positioned to the proper tank, which resulted in fuel starvation; and inadequate supervision by the instructor pilot (CFI). The trees were a related factor.NTSB MKC89LA192Accident · Minor injuriesLimited investigationFinal reportPietenpol AIR Camper B4A · Horatio, ARImproper use of carburetor heat by the pilot, which resulted in carburetor ice. A factor related to the accident was: carburetor icing conditions.NTSB FTW89LA157Accident · No injuriesLimited investigationFinal reportCessna 150J · Dallas, TXPilot's failure to accurately calculate the necesary fuel for the flight and assure that the aircraft had been refueled to provide that quantity.NTSB MIA89LA238Accident · No injuriesLimited investigationFinal reportCessna 177 · Woodville, MSImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: darkness and the ditch.NTSB BFO89DID02Accident · Serious injuriesFinal reportRotorway Exec · Palmyra, VAInadequate preflight by the pilot, and fuel exhaustion due to an inadequate supply of fuel.NTSB ATL89LA206Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hickory, NCPilot's failure to adequately monitor the engine fuel consumption in flight.NTSB NYC89LA209Accident · Serious injuriesLimited investigationFinal reportCessna 210 · No. Windham, VTThe pilot's failure to assure an adequate supply of fuel was available.NTSB NYC89LA205Accident · No injuriesLimited investigationFinal reportCessna 210N · Westerly, RIThe pilot-in-command's failure to properly ensure a sufficient quantity of fuel for the intended flight.NTSB LAX89LA292Accident · No injuriesLimited investigationFinal reportCessna 172 · Bullhead City, AZFailure of the pilot to adequately perform inflight fuel consumption calculations to ensure the adequacy of the fuel supply for the flight's completion. Contributing to the accident was the failure of the pilot to consider the impact of the stronger than…NTSB FTW89FA155Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Pauls Valley, OKImproper planning/decision by the pilot, his lack of understanding of the procedures for operating the aircraft, his improper use of the fuel selector in managing his fuel supply, fuel starvation, and the pilot's failure to know and follow the emergency…NTSB ATL89LA203Accident · No injuriesLimited investigationFinal reportCessna 150G · Edgefield, SCPoor inflight planning by the pilot in command in that he allowed the fuel supply to be exhausted.NTSB MIA89LA232Accident · No injuriesLimited investigationFinal reportCessna A188B · Edwards, MSInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Rough terrain in the emergency landing area was a related factor.NTSB ATL89LA202Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gainesville, GAThe pilot's misjudgement of the airplane fuel supply during preflight inspection, and his subsequent failure to monitor in-flight fuel consumption, which led to an engine power loss due to fuel exhaustion. Contributing to the accident were the pilot's…NTSB DEN89LA198Accident · No injuriesLimited investigationFinal reportCessna 150-L · Logan, UTImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to lack of fuel. Factors related to the accident were: darkness and a fence in the emergency landing area.NTSB ANC89LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKPilot-in-command's improper fuel consumption calculations, improper inflight planning, and decisions.NTSB NYC89LA196Accident · Minor injuriesLimited investigationFinal reportRyan ST-3KR · Factoryville, PAInadequate preflight by the pilot and his misjudgement of the fuel supply, which resulted in fuel exhaustion. The ditch was a related factor.NTSB CHI89LA172Accident · No injuriesLimited investigationFinal reportCessna T-337D · Howell, MIThe pilot's poor preflight planning and inaccurate fuel consumption calculations. Contributing factor was maintenance personnel's not performing correct calibration of fuel gages.NTSB LAX89DUJ09Accident · Minor injuriesFinal reportHiller UH-12E · Tolleson, AZAn engine failure due to water contamination in the fuel supply which preceded an autorotation and collision with the ground during night time conditions.NTSB MKC89LA181Accident · Minor injuriesLimited investigationFinal reportBell 47G-B3 · Waseca, MNInadequate preflight by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. The tailwind, high obstruction (power line), and crop (beans) were contributing factors.NTSB MIA89LA223Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Fort Pierce, FLImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. The terrain (rough/uneven) in the emergency landing area was a related factor.NTSB LAX89DUQ04Accident · No injuriesFinal reportAir Tractor AT-300 · New Cuyama, CAThe pilot's mismanagement of the fuel supply which led to an engine power loss due to fuel exhaustion and subsequent collision with the ground by allowing the aircraft to stall.NTSB DEN89LA194Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Santa Fe, NMImproper use of the mixture control by the pilot during takeoff which resulted in fuel starvation. Rough/uneven terrain contributed to the aircraft damage.NTSB CHI89LA170Accident · No injuriesLimited investigationFinal reportBeech A33 · Bloomington, ILA loss of engine power due to contamination (water, debris, and rust-like particles) in the fuel and the pilot's failure to detect the contamination during the pre-flight inspection.NTSB CHI89DEI02Accident · Serious injuriesFinal reportAcroduster SA-750 · Painesville, OHThe pilot's improper use of the fuel selector for takeoff, which resulted in fuel starvation; and his improper use of emergency procedures after the engine lost power. The pilot's lack of familiarity with the aircraft and the trees were contributing factors.NTSB FTW89LA148Accident · No injuriesLimited investigationFinal reportCessna 150 · Terrell, TXThe pilot became lost during the flight and fuel exhaustion occurred which required an off airport forced landing.NTSB ATL89DMG06Accident · 1 fatalFinal reportDammann N3-2 · Hendersonville, NCEngine failure due to carburetor ice.NTSB NYC89LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Nanuet, NYInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB FTW89LA145Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Comfort, TXThe fuel exhaustion induced power loss which resulted from the fuel pilot's failure to accurately determine the amount of fuel available for the flight.NTSB ATL89LA195Accident · Minor injuriesLimited investigationFinal reportCessna 210C · Millington, TNA loss of engine power, due to contamination in the fuel flow manifold. The contamination in the fuel system was due to inadequate maintenance.