# NTSB investigations: Cessna U206D, TX

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 FTW93LA031](https://openairdocs.org/ntsb/FTW93LA031.md): Cessna U206D · Fort Stockton, TX · Accident · No injuries · Limited investigation · Final report · Nov 4, 1992 · N925RR · Substantial damage
  > The pilot's failure to follow published fuel system sumping procedures before flight and total loss of power due to water contaminated fuel. Factors were the drizzle and icing conditions and the lack of suitable terrain.
- [NTSB FTW89LA101](https://openairdocs.org/ntsb/FTW89LA101.md): Cessna 206D · Saint Jo, TX · Accident · No injuries · Limited investigation · Final report · May 27, 1989 · N72279 · Destroyed
  > The pilot's decision to attempt to takeoff from a field that was not suitable for such purpose.
- [NTSB FTW80DA009](https://openairdocs.org/ntsb/FTW80DA009.md): Cessna U206D · Lubbock, TX · Accident · No injuries · Closed · Nov 1, 1979 · N71967 · Substantial damage
- [NTSB FTW72DPD30](https://openairdocs.org/ntsb/FTW72DPD30.md): Cessna U206 · Abilene, TX · Accident · No injuries · Closed · Feb 16, 1972 · N71996 · Substantial damage

## 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" = 'TX' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073342'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2073342&state=TX

---
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.