NTSB investigations
361 cases where the sequence of events included Fuel related.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '190' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '190' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 SEA08LA195Accident · Minor injuriesLimited investigationFinal reportLancair Propjet · Camarillo, CAThe loss of engine power due to air within the fuel system.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.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.NTSB DEN08LA131Accident · Serious injuriesLimited investigationFinal reportFlynn Van Munk · Erie, COA loss of engine power due to carburetor icing. The reason for the loss of aircraft control was not determined.NTSB NYC08LA255Accident · Serious injuriesLimited investigationFinal reportCessna 402B · Ocean Ridge, FLA partial loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s decision to add only a limited amount of fuel prior to the flight, and the fuel selector valve placards' inaccurate depiction of the airplane fuel tank…NTSB NYC08LA249Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Surfside Beach, SCA loss of engine power due to carburetor icing. Contributing to the accident was the obstruction of the carburetor heat flapper by a mud dauber's nest.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…NTSB CHI08LA134Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Palestine, ILThe loss of engine power due to carburetor icing. Contributing to the accident were the pilot's decision to conduct a low-power spiraling descent operation during conditions conducive to carburetor icing, and the weather that was conducive to carburetor icing.NTSB LAX08LA073Accident · No injuriesLimited investigationFinal reportCessna 402C · Mercury, NVA loss of power to both engines resulting from a fitting failure and leak at the right fuel selector valve that allowed fuel from the right tank to be lost overboard, and that then introduced air into the left engine's fuel lines during an attempted…NTSB SEA08LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Centerville, WAA loss of engine power due to carburetor icing conditions and the failure of the pilot to use the correct amount of carburetor heat for the existing conditions.NTSB NYC08LA078Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · North Palm Bch, FLA loss of engine power due to carburetor icing. Contributing to the accident was unsuitable terrain for a forced landing.