# NTSB investigations: Cessna U206E, 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 WPR09CA084](https://openairdocs.org/ntsb/WPR09CA084.md): Cessna U206E · Crane Island, San Juan Is., WA · Accident · No injuries · Data collection · Final report · Jan 14, 2009 · N9428G · Substantial damage
  > The pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's improper application of brakes.
- [NTSB SEA05LA141](https://openairdocs.org/ntsb/SEA05LA141.md): Cessna 206E · Stuart Island, WA · Accident · No injuries · Limited investigation · Final report · Jul 8, 2005 · N9428G · Substantial damage
  > The pilot's excessive airspeed on final for the current runway surface conditions, and the intentional obstruction avoidance maneuver he executed when it became clear the aircraft was about to go off the end of the runway. Factors include the pilot's improper…
- [NTSB SEA98LA034](https://openairdocs.org/ntsb/SEA98LA034.md): Cessna U-206E · Friday Harbor, WA · Accident · No injuries · Limited investigation · Final report · Oct 9, 1997 · N9428G · Substantial damage
  > the pilot's failure to park with the aircraft headed into the wind in high wind conditions. A factor include the high wind condition.

## 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 ('2073350'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2073350&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.