# NTSB investigations: Cessna 208B: Controlled flight into terr/obj (CFIT)

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 ANC25FA010](https://openairdocs.org/ntsb/ANC25FA010.md): Cessna 208B · Honolulu, HI · Accident · 2 fatal · Class 3 · Field · Preliminary report · Dec 18, 2024 · N689KA · Destroyed
  > On December 17, 2024, about 1515 Hawaii-Aleutian Standard time, a turbine-powered Cessna 208B airplane, N689KA, was destroyed when it was involved in an accident near Honolulu, Hawaii. The two pilots onboard were fatally injured. The airplane was operated as…
- [NTSB ANC23LA012](https://openairdocs.org/ntsb/ANC23LA012.md): Cessna 208B · Kualapuu, HI · Accident · Serious injuries · Class 4 · Limited · Final report · Jan 16, 2023 · N236KA · Substantial damage
  > The pilot’s failure to maintain adequate altitude during a circling approach procedure in dark night visual meteorological conditions, which resulted in a collision with terrain.
- [NTSB ANC16LA012](https://openairdocs.org/ntsb/ANC16LA012.md): Cessna 208B · Anaktuvuk Pass, AK · Accident · Serious injuries · Limited investigation · Final report · Jan 2, 2016 · N540ME · Substantial damage
  > The pilot’s continued flight into deteriorating, flat light weather conditions, which resulted in impact with mountainous, snow-covered terrain.
- [NTSB ANC14MA008](https://openairdocs.org/ntsb/ANC14MA008.md): Cessna 208B · Saint Marys, AK · Accident · 5 fatal · Major investigation · Final report · Nov 30, 2013 · N12373 · Substantial damage
  > The pilot's decision to initiate a visual flight rules approach into an area of instrument meteorological conditions at night and the flight coordinators' release of the flight without discussing the risks with the pilot, which resulted in the pilot…

## 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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '120'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/120/cases?model=2073701

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