# NTSB investigations: Cessna TU206F, AZ

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 LAX08LA269](https://openairdocs.org/ntsb/LAX08LA269.md): Cessna TU206F · Glendale, AZ · Accident · No injuries · Limited investigation · Final report · Aug 19, 2008 · N62DB · Substantial damage
  > A loose fuel line fitting that resulted in a partial loss of engine power during the initial takeoff climb. Contributing to the accident was inadequate maintenance installation of the fitting.
- [NTSB LAX87LA165](https://openairdocs.org/ntsb/LAX87LA165.md): Cessna T206F · Grand Canyon, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 31, 1987 · N9026B · Substantial damage
  > The plt said that on short final the acft began to drift off the left side of the rwy and control inputs to correct the drift had no effect. The plt added pwr to initiate a go around and he said that the 'airspeed suddenly dropped to 40 and we were in a stall…
- [NTSB LAX79DUJ35](https://openairdocs.org/ntsb/LAX79DUJ35.md): Cessna U206 · Littlefield, AZ · Accident · No injuries · Closed · Nov 7, 1978 · N60838 · Substantial damage
- [NTSB LAX77DUJ53](https://openairdocs.org/ntsb/LAX77DUJ53.md): Cessna TU206F · Grand Canyon, AZ · Accident · Minor injuries · Closed · Jun 1, 1977 · N8303Q · Substantial damage
- [NTSB LAX75DUJ79](https://openairdocs.org/ntsb/LAX75DUJ79.md): Cessna TU206 · Peoria, AZ · Accident · No injuries · Closed · Apr 11, 1975 · N58476 · 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" = 'AZ' 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 ('2073353'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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