# NTSB investigations: Cessna 208B, 2017

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 WPR17LA207](https://openairdocs.org/ntsb/WPR17LA207.md): Cessna 208B · Sedona, AZ · Accident · No injuries · Limited investigation · Final report · Sep 16, 2017 · N786WW · Substantial damage
  > The pilot's failure to maintain clearance from a light pole while taxiing.
- [NTSB GAA17CA490](https://openairdocs.org/ntsb/GAA17CA490.md): Cessna 208 · Mulino, OR · Accident · No injuries · Data collection · Final report · Aug 4, 2017 · N9829B · Substantial damage
  > The pilot's improper landing flare, which resulted in a bounced landing.
- [NTSB GAA17CA311](https://openairdocs.org/ntsb/GAA17CA311.md): Cessna 208 · Skagway, AK · Accident · No injuries · Data collection · Final report · May 22, 2017 · N754KP · Substantial damage
  > An in-flight collision with a goose.
- [NTSB ANC17FA021](https://openairdocs.org/ntsb/ANC17FA021.md): Cessna 208B · Chignik Lake, AK · Accident · 1 fatal · Field investigation · Final report · May 1, 2017 · N803TH · Substantial damage
  > The pilot's continued visual flight rules flight into an area of mountainous terrain and instrument meteorological conditions, which resulted in controlled flight into terrain (CFIT). Contributing to the accident was the company's failure to provide the pilot…
- [NTSB GAA17CA191](https://openairdocs.org/ntsb/GAA17CA191.md): Cessna 208 · Kalaupapa, HI · Accident · Minor injuries · Class 4 · Data collection · Final report · Mar 11, 2017 · N865MA · Substantial damage
  > The pilot's attempted aborted landing late in the landing sequence because she saw another airplane on the runway facing her with its propeller turning, which resulted in a hard landing, a subsequent loss of directional control, and ground loop.

## 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") = 2017
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073701', '2073700', '2073705'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2073701&year=2017

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