NTSB investigations, 2008
17 cases where the sequence of events included Fuel contamination.
Cases per year
| 2008 | 17 |
|---|---|
| 2009 | 14 |
| 2010 | 18 |
| 2011 | 12 |
| 2012 | 10 |
| 2013 | 13 |
| 2014 | 8 |
| 2015 | 22 |
| 2016 | 11 |
| 2017 | 15 |
| 2018 | 10 |
| 2019 | 13 |
| 2020 | 11 |
| 2021 | 10 |
| 2022 | 12 |
| 2023 | 14 |
| 2024 | 11 |
| 2025 | 4 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2008
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '193' 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 year(c."eventDate") = 2008 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '193' 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 WPR09LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Coolidge, AZA total loss of engine power due to water contamination of the fuel system. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB ERA09LA015Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Kissimmee, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during initial climb due to fuel contamination. Contributing to the accident was a fuel tank cap that did not seal properly.NTSB ERA09CA014Accident · Serious injuriesData collectionFinal reportPiper J3C-50 · Epping, NHThe pilot's improper preflight inspection and his decision to fly an unairworthy airplane.NTSB MIA08LA197Accident · Serious injuriesLimited investigationFinal reportBerrie Kolb Mark III · East Haddam, CTThe pilot's improper preflight inspection of the airplane. Contributing to the accident was water contamination of the fuel.NTSB DFW08CA235Accident · No injuriesData collectionFinal reportGulfstream-Schweizer A/C Gulfstream · Patterson, LAThe loss of engine power due to fuel contamination. Contributing to the accident was the unsuitable muddy terrain for the forced landing.NTSB MIA08CA183Accident · No injuriesData collectionFinal reportSmith Wylie Jay Kit Fox II · Deatville, ALThe pilot's inadequate fuel system maintenance.NTSB DEN08LA150Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Atkinson, NEThe total loss of engine power due to water contamination and corrosion within the fuel system at an undetermined time and from an undetermined source.NTSB MIA08CA171Accident · Minor injuriesData collectionFinal reportCessna 152 · Ormond Beach, FLBoth pilots' inadequate preflight inspection of the fuel.NTSB LAX08CA228Accident · No injuriesData collectionFinal reportSchweizer G-164B · Alturas, CAA total loss of engine power due to fuel starvation, which resulted from a fuel system contamination and a clogged fuel filter. Contributing to the accident was the rough terrain.NTSB LAX08LA212Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Kalispell, MTA partial loss of engine power during initial climb due to fuel system contamination by a foreign substance. Contributing to the accident was the uneven terrain.NTSB DEN08LA121Accident · Minor injuriesLimited investigationFinal reportCessna 337G · Point Lookout, MOA fuel flange seal leak and water in the fuel resulting in a loss of engine power during takeoff. Contributing to the accident was an inadequate preflight.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 DFW08LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Emporia, KSA total loss of engine power due to fuel starvation as a result of a blocked fuel outlet caused by the peeling off of a previously approved fuel tank sealer.NTSB CHI08CA118Accident · No injuriesData collectionFinal reportLuscombe 8A · Remus, MIThe loss of engine power during approach due to fuel contamination. Contributing to the accident were the unsuitable terrain and a tree.NTSB NYC08CA161Accident · Minor injuriesData collectionFinal reportCessna 152K · Okeechobee, FLThe loss of engine power during cruise flight due to fuel contamination, and the pilot's inadequate preflight inspection.NTSB LAX08CA094Accident · No injuriesData collectionFinal reportErcoupe 415-D · Riverside, CAWater contamination of the fuel system due to the pilot's inadequate preflight and failure to adequately drain the water from the fuel system.NTSB DFW08LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Spring, TXFailure of the pilot to ensure that the fuel system was purged of water prior to flight. Contributing to the severity of injuries was the lack of shoulder restraints.