# NTSB investigations, VA: Fuel contamination

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ERA19TA235](https://openairdocs.org/ntsb/ERA19TA235.md): Cessna 152 · Wakefield, VA · Accident · No injuries · Class 3 · Final report · Jul 25, 2019 · N47028 · Substantial damage
  > The pilot's inadequate preflight inspection, which failed to detect and remove all water from fuel, and maintenance personnel’s unapproved repair of the right wing fuel cap, which resulted in fuel contamination and a subsequent partial loss of engine power…
- [NTSB ERA18CA035](https://openairdocs.org/ntsb/ERA18CA035.md): Driggers Quillan E Titan Tornado · Mechanicsville, VA · Accident · No injuries · Data collection · Final report · Nov 29, 2017 · N50F · Substantial damage
  > The pilot’s inadequate preflight inspection and failure to detect water contamination in the fuel system, which resulted in a partial loss of engine power on takeoff.
- [NTSB ERA17LA280](https://openairdocs.org/ntsb/ERA17LA280.md): Costruzioni Aeronautiche Tecna P2004 Bravo · Quinton, VA · Accident · 1 fatal · Limited investigation · Final report · Aug 18, 2017 · N319TA · Substantial damage
  > The flight instructor and commercial pilot's inadequate preflight inspection, which resulted in water contamination of the fuel supply, and a total loss of engine power.
- [NTSB ERA10LA466](https://openairdocs.org/ntsb/ERA10LA466.md): Cessna 182Q · Virginia Beach, VA · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 2010 · N812KT · Substantial damage
  > A total loss of power due to water contamination in the fuel. Contributing to the accident was the pilot's inadequate preflight inspection.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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" = 'VA' 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
```

This list as a web page: https://openairdocs.org/ntsb-events/193/sequence?state=VA

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.