# NTSB investigations: Cessna U206G, WA

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 WPR13CA246](https://openairdocs.org/ntsb/WPR13CA246.md): Cessna U206G · Friday Harbor, WA · Accident · No injuries · Data collection · Final report · May 14, 2013 · N707WJ · Substantial damage
  > A collision with a bird while on the downwind leg of the traffic pattern.
- [NTSB SEA89LA035](https://openairdocs.org/ntsb/SEA89LA035.md): Cessna 206 · Sekiu, WA · Accident · Minor injuries · Limited investigation · Final report · Jan 16, 1989 · N732FN · Substantial damage
  > Pilot attempted a landing in adverse weather conditions, rather than postpone the business trip and return to origin or other safe area. Contributing to the accident were turbulence and gusty winds along with the self induced pressure to make the business flt.
- [NTSB SEA82DA024](https://openairdocs.org/ntsb/SEA82DA024.md): Cessna U206G · Moses Lake, WA · Accident · No injuries · Final report · Feb 3, 1982 · N756GF · Substantial damage
  > The pilot stated that he encountered a freak gust of wind during the landing. The plane touched down on the right side of the runway in an area of soft terrain. The aircraft veered farther to the right and continued into an earthen drainage ditch. The ditch…

## 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" = 'WA' 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=WA

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