NTSB investigations, 2010
18 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\") = 2010
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") = 2010 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 ANC11CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Clear, AKThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to water/ice in the fuel system.NTSB CEN11CA098Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Gregory, ARThe pilot’s inadequate preflight inspection and failure to detect water contaminated fuel, which resulted in a loss of engine power during takeoff.NTSB CEN11LA084Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Navada, TXThe loss of engine power due to debris obstructing the fuel filter, which resulted in fuel starvation. Contributing to the accident was the pilot's inadequate airspeed during the forced landing, which resulted in an aerodynamic stall.NTSB ERA11LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Hobe Sound, FLA partial loss of engine power due to fuel contamination in the carburetor.NTSB ERA11CA020Accident · Minor injuriesData collectionFinal reportMooney M20E · New Smyrna Beach, FLThe pilot’s inadequate preflight inspection, which resulted in the loss of engine power due to water contaminated fuel.NTSB ERA10LA484Accident · No injuriesLimited investigationFinal reportBell OH-58A · Covington, TNA loss of engine power due to contamination of the helicopter's fuel supply.NTSB ERA10LA466Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Virginia Beach, VAA total loss of power due to water contamination in the fuel. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB ERA10LA457Accident · No injuriesLimited investigationFinal reportAero Commander 560E · Jacksonville, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of power in both engines during climb due to fuel contamination.NTSB ERA10LA449Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7HC · Louisville, KYA loss of engine power due to fuel system contamination resulting in damage to the carburetor float.NTSB ERA10LA438Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Douglas, GAA loss of engine power during takeoff due to fuel contamination. Contributing to the accident was the pilot's inadequate preflight inspection and inadequate maintenance of the fuel system.NTSB ERA10LA374Accident · Serious injuriesLimited investigationFinal reportMulloy Charles Zodiac 601XL · Enochville, NCLoss of engine power due to fuel contamination, and the pilot’s inadequate preflight of the fuel system.NTSB WPR10LA313Accident · Minor injuriesLimited investigationFinal reportDe Havilland DHC-1 · Port Orchard, WAA loss of engine power during initial climb due to water contamination in the fuel.NTSB CEN10LA282Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Las Cruces, NMA loss of engine power due to fuel starvation as a result of water contamination in the fuel, and the pilot's inadequate preflight inspection. Contributing the accident was an inoperative number 5 cylinder exhaust valve.NTSB CEN10LA256Accident · No injuriesLimited investigationFinal reportCessna P206B · Spring Branch, TXA loss of engine power due to fuel contamination.NTSB CEN10CA211Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · White Bear Lake, MNA total loss of engine power during takeoff due to fuel contamination as a result of the pilot's inadequate preflight inspection.NTSB CEN10FA122Accident · 2 fatalField investigationFinal reportPiper PA-30 · Amarillo, TXThe pilot’s failure to detect water contaminated fuel, which resulted in a loss of engine power shortly after takeoff. Contributing to the accident were the worn and loose fuel caps, which allowed water to enter the fuel tanks.NTSB WPR10LA119Accident · Minor injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · La Quinta, CAA loss of engine power during cruise flight due to water contamination in the fuel.NTSB ERA10LA111Accident · No injuriesLimited investigationFinal reportStinson 108 · Bayport, NYA total loss of engine power during cruise flight due to fuel contamination.