# NTSB investigations: Cessna TU206A, CO

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 DEN99LA138](https://openairdocs.org/ntsb/DEN99LA138.md): Cessna TU206A · Durango, CO · Accident · No injuries · Limited investigation · Final report · Aug 8, 1999 · N4835F · Substantial damage
  > A worn landing nose gear steering system that diminished the ability to steer the airplane. Factors were improper maintenance by unknown persons, and loose gravel.
- [NTSB DEN84FA016](https://openairdocs.org/ntsb/DEN84FA016.md): Cessna TU-206A · Loveland, CO · Accident · No injuries · Field investigation · Final report · Oct 23, 1983 · N4831F · Substantial damage
  > The acft lost part of one blade of the propeller during the climb to cruise phase of operation. The passengers were skydivers so they used their parachutes in an exit of the acft as the airframe started to vibrate. The plt made a successful landing on the…
- [NTSB DCA81AA015](https://openairdocs.org/ntsb/DCA81AA015.md): Handly Page HP-137 · Loveland, CO · Accident · 15 fatal · Closed · Apr 17, 1981 · N11360 · 2 aircraft · Destroyed
- [NTSB DEN79FA053](https://openairdocs.org/ntsb/DEN79FA053.md): Cessna TU206 · Ft Collins, CO · Accident · No injuries · Closed · Aug 4, 1979 · N4862F · Substantial damage
- [NTSB DEN78FTE69](https://openairdocs.org/ntsb/DEN78FTE69.md): Cessna TU206A · Crested Butte, CO · Accident · No injuries · Closed · Jun 21, 1978 · N4895F · 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" = 'CO' 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 ('2073318'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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