NTSB investigations, TX
22 cases where the sequence of events included Fuel contamination.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 3 |
| 2012 | 1 |
| 2013 | 2 |
| 2015 | 3 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 3 |
| 2025 | 1 |
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 c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' 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 CEN26LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Taylor, TXThe pilot’s inadequate preflight inspection that resulted in a loss of engine power due to water contamination.NTSB WPR23LA263Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Marble Falls, TXA total loss of engine power due to fuel contamination from an unknown source.NTSB WPR23LA183Accident · No injuriesClass 3 · LimitedFinal reportAero Vodochody L-39ZA · Barnhart, TXA total loss of engine power due to water-contaminated fuel from an undetermined source.NTSB CEN23LA153Accident · Minor injuriesClass 3 · LimitedFinal reportRyan Navion A · New Waverly, TXA total loss of engine power as a result of fuel contamination.NTSB CEN21LA133Accident · No injuriesClass 3 · LimitedFinal reportAero Commander S2R · Alamo, TXThe partial loss of engine power due to water-contaminated fuel.NTSB CEN20LA132Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Waxahachie, TXThe partial loss of engine power due to water and contaminants in the fuel, due to the pilot’s inadequate preflight inspection, and the pilot’s decision to conduct a steep turn at low altitude to return to the runway rather than land straight ahead, which…NTSB CEN19FA325Accident · 2 fatalClass 3 · FieldFinal reportCessna A185 · Conroe, TXA partial loss of engine power due to fuel contamination with water, and the pilot’s failure to maintain control of the airplane during an attempted return to the airport shortly after takeoff, which resulted in an aerodynamic stall.NTSB CEN19LA129Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 23 · Sulphur Spring, TXThe pilot’s inadequate preflight inspection, during which he failed to detect the water contamination in the left fuel, which resulted in a partial loss of power in the left engine. Contributing to the accident was the total loss of power in the right engine…NTSB CEN18LA113Accident · Minor injuriesLimited investigationFinal reportAero Commander 100-180 · Deport, TXA total loss of engine power due to water contamination of the fuel system. Contributing to the accident was the pilot/owner's inadequate maintenance of the fuel caps.NTSB CEN17LA202Accident · Serious injuriesLimited investigationFinal reportPiper PA36 · El Campo, TXFoam contamination in the fuel injector nozzles from deteriorated foam baffles and water in the fuel flow divider, the combination of which resulted in the loss of engine power.NTSB CEN17LA153Accident · No injuriesLimited investigationFinal reportCessna 152 · La Porte, TXA total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection that did not detect water contamination.NTSB CEN15LA423Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woodville, TXThe loss of engine power due to water contamination in the fuel system. Contributing to the accident were the pilot’s inadequate preflight inspection of the fuel tanks and the operator’s inadequate inspection of the fuel supply truck that did not detect water…NTSB CEN15FA287Accident · 2 fatalField investigationFinal reportPiper PA 24-250 · Quinlan, TXThe pilot's failure to maintain control of the airplane following a loss of engine power during initial climb after takeoff, which resulted in the wing's critical angle-of-attack being exceeded and a subsequent aerodynamic stall. Also causal was the pilot's…NTSB CEN15FA269Accident · 1 fatalField investigationFinal reportGrumman American Avn. AA-5 · Fredericksburg, TXThe pilot's failure to maintain adequate airspeed following a partial loss of engine power during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Also causal was the mechanic's…NTSB CEN13FA432Accident · 1 fatalField investigationFinal reportPiper PA-30 · Amarillo, TXThe pilot’s failure to maintain airplane control after a loss of left engine power due to water-contaminated fuel. Contributing to the accident was the lack of a proper preflight that could have detected water accumulation in the fuel system before takeoff.NTSB CEN13LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · Carrizo Springs, TXThe pilot’s failure to identify the water contamination of the fuel system during his preflight inspection, which resulted in a total loss of engine power during the airplane’s initial climb.NTSB CEN12FA654Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Roanoke, TXThe loss of engine power during takeoff due to fuel contamination. Contributing to the accident was maintenance personnel's failure to adequately correct the water contamination effects. Contributing to the severity of the occupants' injuries was the lack of…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 CEN10LA256Accident · No injuriesLimited investigationFinal reportCessna P206B · Spring Branch, TXA loss of engine power due to fuel contamination.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 CEN09LA341Accident · Minor injuriesLimited investigationFinal reportHuston Charles D Pitts S-12 · Spicewood, TXA total loss of engine power due to fuel starvation as a result of the presence of an unidentified contaminant in the fuel system which clogged the fuel flow sensor. Contributing to the accident was the manufacturer’s installation of the fuel flow sensor…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.