# NTSB investigations: Cessna 208B: In flight collision with terrain/water

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 CHI08FA045](https://openairdocs.org/ntsb/CHI08FA045.md): Cessna 208B · Columbus, OH · Accident · 2 fatal · Field investigation · Final report · Dec 5, 2007 · N28MG · Destroyed
  > The pilot's failure to maintain aircraft control and collision avoidance with terrain due to spatial disorientation. Contributing to the accident were the low cloud ceiling and night conditions.
- [NTSB CHI04LA278](https://openairdocs.org/ntsb/CHI04LA278.md): Cessna 208B · Gwinner, ND · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 2004 · N7392B · Substantial damage
  > The pilot's failure to maintain altitude during the circling maneuver. Contributing factors were the pilot's improper decision to execute the approach when weather conditions were below minimums and the low light (dark night) conditions.
- [NTSB MIA03FA034](https://openairdocs.org/ntsb/MIA03FA034.md): Cessna 208B · Manteo, NC · Accident · 1 fatal · Field investigation · Final report · Dec 25, 2002 · N1122Y · Substantial damage
  > The pilot's continued descent below the minimum descent altitude, for undetermined reasons, while performing a NDB approach, resulting in the airplane crashing into water 1.5 miles from the airport. A factor in the accident was a cloud ceiling below the…
- [NTSB NYC00LA265](https://openairdocs.org/ntsb/NYC00LA265.md): Cessna 208B · Greenville, ME · Accident · Minor injuries · Limited investigation · Final report · Sep 23, 2000 · N590TA · Substantial damage
  > The pilot's improper in-flight decision to continue his descent without visual contact with the runway, and his inattention to his altitude, in relation to the airport elevation.
- [NTSB ANC97MA161](https://openairdocs.org/ntsb/ANC97MA161.md): Cessna 208B · Wainwright, AK · Accident · 5 fatal · Major investigation · Final report · Apr 11, 1997 · N408GV · Destroyed
  > The pilot's intentional VFR flight into instrument meteorological conditions and his failure to maintain altitude/clearance from terrain. Factors contributing to the accident were the weather conditions.
- [NTSB LAX95FA141](https://openairdocs.org/ntsb/LAX95FA141.md): Cessna 208B · Reno, NV · Accident · 1 fatal · Field investigation · Final report · Mar 22, 1995 · N9417B · Destroyed
  > the pilot's failure to comply with published instrument approach procedures by a premature descent below the minimum altitude specified for the approach.
- [NTSB ATL95FA057](https://openairdocs.org/ntsb/ATL95FA057.md): Cessna 208B · Gainesville, GA · Accident · 2 fatal · Field investigation · Final report · Mar 4, 1995 · N227DM · Destroyed
  > The pilots failure to maintain the minimum descent altitude during the approach. The weather and dark night light condition were factors.
- [NTSB ATL92FA024](https://openairdocs.org/ntsb/ATL92FA024.md): Cessna 208B · Destin, FL · Accident · 1 fatal · Field investigation · Final report · Nov 16, 1991 · N951FE · Substantial damage
  > The pilots failure to follow instrument flight rules procedures by disregarding the minimum descent altitude for the approach and failing to maintain clearance from the terrain. A factor in the accident was the pilot's over confidence in his personal ability.

## 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."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')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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