# NTSB investigations: Cessna TU206G: In flight collision with terrain/water

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 SEA97LA046](https://openairdocs.org/ntsb/SEA97LA046.md): Cessna TU-206 · Cascade, ID · Accident · Serious injuries · Limited investigation · Final report · Jan 7, 1997 · N717CM · Substantial damage
  > The pilot's failure to maintain adequate altitude/clearance from the terrain while reversing course in mountainous terrain. Factors include the mountainous terrain and tall trees in the area where he was maneuvering.
- [NTSB SEA94FA111](https://openairdocs.org/ntsb/SEA94FA111.md): Cessna TU206G · Gold Bar, WA · Accident · Serious injuries · Field investigation · Final report · Apr 30, 1994 · N732JK · Substantial damage
  > Electrical system short. Factors to the accident were: mountainous terrain and procedures/directives not followed.
- [NTSB MIA91LA139](https://openairdocs.org/ntsb/MIA91LA139.md): Cessna TU-206G · Gulf Of Mexico · Accident · 1 fatal · Limited investigation · Final report · May 9, 1991 · N6567Z · Destroyed
  > An in flight collision with the water for undetermined reasons.
- [NTSB LAX87LA334](https://openairdocs.org/ntsb/LAX87LA334.md): Cessna 206 · Williams, AZ · Accident · 1 fatal · Limited investigation · Final report · Jul 26, 1987 · N4651Z · Destroyed
  > The aircraft was reported stolen on July 26, 1987. It is believed that the aircraft departed the grand canyon airport in grand canyon, Arizona on July 26, 1987, at 0300 MST. A search of records or airports in the area revealed that the aircraft was refueled…
- [NTSB DEN83LA003](https://openairdocs.org/ntsb/DEN83LA003.md): Cessna TU206G · Rock Springs, WY · Accident · No injuries · Limited investigation · Final report · Oct 7, 1982 · N6169Z · Substantial damage
  > The aircraft was being used for transportation to an oil drilling sight. A 1300 ft portion of a road near the sight was being used as a landing strip. The pilot reported that after the plane touched down and was rolling, it came to a dog leg in the road. He…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073357')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2073357&occurrence=230

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