NTSB investigations, 2014
8 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\") = 2014
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") = 2014 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 WPR14LA371Accident · No injuriesLimited investigationFinal reportAyres S2R T34 · Buckeye, AZA partial loss of engine power due to water contamination of the fuel.NTSB CEN14LA390Accident · No injuriesLimited investigationFinal reportBell 206B · Bennet, NEA total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection. Contributing to the accident was the operator’s failure to properly maintain the fuel storage tank.NTSB CEN14CA391Accident · No injuriesData collectionFinal reportContinental Copters Tomcat MK5A · Osage, MNThe total loss of engine power due to water contamination of the fuel, which resulted in the pilot's forced landing and impact with terrain. Contributing to the accident was the pilot's decision to operate the helicopter without resolving the fuel…NTSB CEN14FA337Accident · Serious injuriesField investigationFinal reportPiper PA30 · Harrison, ARThe pilot's loss of control of the airplane during initial climb because he failed to correctly compensate for the loss of power in the left engine. Contributing to the accident was water contamination in the fuel and the lack of an adequate preflight…NTSB WPR14FA158Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Green River, UTA loss of engine power due to fuel contamination while maneuvering at a low altitude and the pilot's inadequate preflight inspection, which failed to detect the contamination.NTSB CEN14LA120Accident · No injuriesLimited investigationFinal reportCessna 414A · Ashland, MOThe in-flight failure of both engines due to water contamination.NTSB WPR14LA099Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · San Jose, CAThe pilot’s failure to sump the fuel tanks, which resulted in water contamination, a partial loss of engine power during takeoff, and collision with a taxiing airplane during the subsequent forced landing.NTSB ANC14CA014Accident · Minor injuriesData collectionFinal reportCessna 170 - B · Nome, AKThe pilot's failure to adequately remove water-contaminated fuel during the preflight inspection, which resulted in a total loss of engine power.