NTSB investigations
13 cases where NTSB found Water.
Cases per year
| 2010 | 2 |
|---|---|
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 3 |
| 2018 | 1 |
| 2019 | 1 |
| 2022 | 2 |
| 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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01071030')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01071030')) 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 DCA22LA179Incident · No injuriesClass 4 · LimitedFinal reportBoeing 767-332 · New York, NYThe failure of maintenance personnel to close the drain mast heater circuit breakers which resulted in the formation of ice in the forward drain mast, an improper flow of wastewater into the main landing gear wheel well, and the formation of ice on one or…NTSB WPR22LA076Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172H · Los Angeles, CAThe pilot’s inadequate preflight inspection during which he failed to remove all water contamination in the fuel system, which resulted in a total loss of engine power on takeoff. Contributing to the accident was the condition of the fuel caps, which allowed…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 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 ERA14LA051Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Montrose, PAThe pilot’s failure to check the fuel tanks for contaminants after fueling, which resulted in a total loss of engine power due to water contamination.NTSB WPR13FA281Accident · 2 fatalField investigationFinal reportPiper PA-30 · Idaho Falls, IDA loss of power to the right engine during the initial climb due to fuel contamination and the pilot's failure to maintain adequate airspeed and airplane control. Contributing to the accident was the pilot's inadequate preflight check of the airplane.NTSB WPR13FA141Accident · 1 fatalField investigationFinal reportMaule M5 · Woodinville, WAThe pilot's failure to maintain adequate airspeed following a total loss of engine power due to fuel contamination, which resulted in a stall/spin and subsequent impact with terrain.NTSB CEN12CA469Accident · Serious injuriesData collectionFinal reportPurtee Kevin M Pietenpol Aircamper · Broadhead, WIThe pilot's failure to adequately remove water-contaminated fuel during the preflight inspection, which resulted in a total loss of engine power during takeoff, and his decision to initiate a turn back to the runway with insufficient airspeed, which resulted…NTSB WPR11FA331Accident · 2 fatalField investigationFinal reportMooney M20F · Winslow, AZA loss of engine power due to fuel system contamination, and the pilot’s subsequent failure to maintain an adequate airspeed, which resulted in a loss of control.NTSB WPR11FA166Accident · 5 fatalField investigationFinal reportBeech 200 · Long Beach, CAThe pilot's failure to maintain directional control of the airplane during a momentary interruption of power from the left engine during the initial takeoff climb. Contributing to the accident was the power interruption due to water contamination of 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 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.