Skip to content

NTSB investigations

270 cases where the defining event was Fuel related.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '190') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '190')
  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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '190')
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 ERA13LA239Accident · No injuriesLimited investigationFinal reportCessna 182G · Clewiston, FLThe private pilot’s inadequate preflight planning and fuel management and the flight instructor’s inadequate supervision, which resulted in a total loss of engine power due to fuel starvation.May 9, 2013 · N2440R · Substantial damage NTSB WPR13LA212Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Santa Rosa, CAThe partial loss of engine power due to fuel contamination and partially blocked fuel screens.Apr 20, 2013 · N985SS · Substantial damage NTSB CEN13FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Maryland Heights, MOThe pilot’s failure to activate the carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a loss of engine power due to carburetor ice.Oct 25, 2012 · N55620 · Substantial damage NTSB WPR12LA367Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Pacoima, CAA total loss of engine power on approach for landing due to a combination of the low fuel level and fuel contamination.Aug 25, 2012 · N9409E · Substantial damage NTSB DCA12FA076Accident · 1 fatalField investigationFinal reportHawker Hawker Hunter MK.58A · Point Mugu, CAthe pilot's decision to continue the flight with a known fuel imbalance condition that resulted in a loss of lateral control when the imbalance exceeded the known capabilities of the airplane. The fuel imbalance was due to incomplete refueling and an…May 18, 2012 · N329AX · Destroyed NTSB ERA12LA279Accident · Minor injuriesLimited investigationFinal reportStanley B E Murphy Rebel · Falmouth, MAThe pilot's delayed application of carburetor heat, which resulted in a loss of engine power.Apr 13, 2012 · N24V · Substantial damage NTSB CEN11LA318Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Yancey, TXThe loss of engine power due to the unintentional closure of the fuel shutoff valve.May 3, 2011 · N927SH · Substantial damage NTSB DCA11WA021Incident · No injuriesForeign investigationMcdonnell Douglas MD · Paris, FranceOn January 12, 2011, an Air Burkina Boeing MD-83 experienced near fuel exhaustion while attempting to land at Orly International Airport, Paris, France. During the ferry flight with landing gear down the flight crew determined that it did not have enough fuel…Jan 12, 2011 · No damage NTSB WPR11CA072Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Pullman, WAThe pilot's delayed application of carburetor heat while maneuvering, which resulted in a partial loss of engine power.Dec 4, 2010 · N4100Z · Substantial damage NTSB OPS11IA054Incident · No injuriesIncident investigationFinal reportDassault FALCON900EX · Teterboro, NJThe pilot of the F900 overshooting of the final approach course, which conflicted with traffic in the pattern. Contributing to the accident was the lack of appropriate coordination between the tower controller and the approach controller.Oct 20, 2010 · PHILC · 3 aircraft · No damage NTSB CEN10CA146Accident · No injuriesData collectionFinal reportByler JDT MINI-MAX 1100R · New Paris, INA total loss of engine power in flight due to carburetor icing. Contributing to the accident was the soft field where the airplane nosed over.Mar 8, 2010 · N184PT · Substantial damage NTSB ERA10LA127Accident · No injuriesLimited investigationFinal reportCessna 150G · St. Augustine, FLA loss of engine power due to fuel exhaustion caused by the failure of the right wing fuel tank sending unit gasket, which resulted in a forced landing.Feb 1, 2010 · N3995J · Substantial damage NTSB CEN09CA532Accident · Serious injuriesData collectionFinal reportPiper PA-28-161 · Washington, IAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat in conditions that were conducive to carburetor icing.Aug 16, 2009 · N47539 · Substantial damage NTSB ERA09CA314Accident · Minor injuriesData collectionFinal reportPiper PA-22 · Aurora, WVThe pilot’s inadequate preflight planning and preparation which resulted in a low fuel condition requiring an off-airport landing.May 31, 2009 · N4824A · Substantial damage NTSB WPR09LA161Accident · No injuriesLimited investigationFinal reportBrown Barnett J4B · Sheridan, CAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.Mar 20, 2009 · N35JB · Substantial damage NTSB ERA09LA105Accident · Serious injuriesLimited investigationFinal reportBell 407 · Bow, NHAn interruption of fuel flow for undetermined reasons, which resulted in an engine flameout.Dec 22, 2008 · N407GB · Substantial damage NTSB MIA08CA192Accident · No injuriesData collectionFinal reportBeech G-36 · Erie, PAThe pilot's improper landing flare resulting in a hard landing. Contributing to the accident was the pilot's improper preflight inspection of the fuel caps and his improper inflight fuel management, which led to a loss of engine power.Sep 11, 2008 · N710ND · Substantial damage NTSB DFW08LA210Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caldwell, TXA loss of engine power in flight due to fuel exhaustion as a result of the pilot's failure to secure the right wing's fuel cap, leading to fuel being siphoned from the tank during flight.Aug 20, 2008 · N92780 · Substantial damage NTSB SEA08FA185Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Olalla, WAThe complete loss of engine power due to the accumulation of ice in the carburetor as a result of the pilot's failure to use carburetor heat.Aug 17, 2008 · N301MA · Destroyed NTSB NYC08LA213Accident · Minor injuriesLimited investigationFinal reportMarrin Pitts S-1 · St. Petersburg, FLThe pilot's failure to maintain adequate airspeed following a partial loss of engine power, which resulted in an aerodynamic stall. Contributing to the accident was improper maintenance practices during the construction of the airplane, which resulted in…Jun 12, 2008 · N347MM · Substantial damage