# NTSB investigations: Cessna 208B, CO

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 DEN01FA094](https://openairdocs.org/ntsb/DEN01FA094.md): Cessna 208B · Steamboat Spngs, CO · Accident · 1 fatal · Field investigation · Final report · May 5, 2001 · N948FE · Destroyed
  > an inadvertent stall during an instrument approach, which resulted in a loss of control. Contributing factors were the pilot's attention being diverted by an abnormal indication, conditions conducive to airframe icing, and the pilot's lack of total experience…
- [NTSB DCA98MA002](https://openairdocs.org/ntsb/DCA98MA002.md): Cessna 208B · Montrose, CO · Accident · 9 fatal · Major investigation · Final report · Oct 8, 1997 · N12022 · Destroyed
  > the pilot's failure to maintain sufficient airspeed for undetermined reasons while maneuvering the airplane near the maximum gross weight and aft cg in or near instrument meteorological conditions, resulting in the loss of control and entry into a stall/spin.…
- [NTSB DEN89FA056](https://openairdocs.org/ntsb/DEN89FA056.md): Cessna 208B · Aspen, CO · Accident · Serious injuries · Field investigation · Final report · Jan 5, 1989 · N945FE · Destroyed
  > Pilot's improper IFR procedure. Contributing factors included moderate turbulence, low ceilings, obscuration and snow.

## 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" = 'CO' 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 ('2073701', '2073700', '2073705'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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