# NTSB investigations: Cessna U206E, 2005

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 ANC05LA125](https://openairdocs.org/ntsb/ANC05LA125.md): Cessna U206E · Skwentna, AK · Accident · Minor injuries · Limited investigation · Final report · Aug 21, 2005 · N9138M · Substantial damage
  > The pilot's misjudged distance/altitude on final approach, which resulted in a noseover following an undershoot and in-flight collision with rough/uneven terrain. A factor associated with the accident was the rough/uneven terrain.
- [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 ANC05CA059](https://openairdocs.org/ntsb/ANC05CA059.md): Cessna U206E · Yakutat, AK · Accident · No injuries · Data collection · Final report · Apr 15, 2005 · N9417G · Substantial damage
  > The pilot's selection of unsuitable terrain for landing, which resulted in a nose down, and structural damage to the wing. A factor contributing to the accident was the soft sand.

## 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 year(c."eventDate") = 2005
  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&year=2005

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