# NTSB investigations: Cessna U206G, MO

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 CHI99FA079](https://openairdocs.org/ntsb/CHI99FA079.md): Cessna U-206G · Salem, MO · Accident · 1 fatal · Field investigation · Final report · Jan 31, 1999 · N7586N · Destroyed
  > the spatial disorientation and loss of control by the pilot after a reported vacuum failure. Factors were instrument flight conditions and icing conditions.
- [NTSB CHI98FA106](https://openairdocs.org/ntsb/CHI98FA106.md): Cessna U206G · Grain Valley, MO · Accident · 6 fatal · Field investigation · Final report · Mar 21, 1998 · N506SD · Destroyed
  > Pilot's inadequate preflight, the partial loss of oil and the resulting rod failure. A factor was the pilot's failure to maintain flying speed.
- [NTSB CHI95LA056](https://openairdocs.org/ntsb/CHI95LA056.md): Cessna 206G · Butler, MO · Accident · No injuries · Limited investigation · Final report · Nov 2, 1994 · N9924R · Substantial damage
  > the pilot's inadequate visual lookout. A factor associated with the accident was the dark night lighting conditions.
- [NTSB MKC84LA162](https://openairdocs.org/ntsb/MKC84LA162.md): Cessna U206G · Kansas City, MO · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1984 · N9967M · Substantial damage
  > As a large jet was departing from the threshold of rwy 19, the plt of a Cessna 206, N9967M, was cleared onto the rwy to hold. Reportedly, the Cessna plt held short of the rwy until the jet had rolled about 1000 ft. as the Cessna was taxied onto the rwy, it…

## 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" = 'MO' 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 ('2073356', '2073315', '2073314'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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