# NTSB investigations: Beech E-55, 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 DEN05FA047](https://openairdocs.org/ntsb/DEN05FA047.md): Beech E55 · Fort Collins, CO · Accident · 1 fatal · Field investigation · Final report · Apr 3, 2005 · N3FJ · Destroyed
  > the pilot's failure to maintain aircraft control. Contributing factors were the left engine loss of power for reasons undetermined, and the pilot allowing the airspeed to drop below Vmc during an attempted single-engine go-around.
- [NTSB DEN92FA091](https://openairdocs.org/ntsb/DEN92FA091.md): Beech E-55 · Steamboat Sprin, CO · Accident · 2 fatal · Field investigation · Final report · Sep 5, 1992 · N12GG · Destroyed
  > The pilot becoming spatially disoriented and losing control of the airplane. Factors were: the pilot's disregard of the preflight weather briefing, his intentional VFR flight into instrument meteorological conditions, his lack of recent instrument time, and…
- [NTSB DEN82FA012](https://openairdocs.org/ntsb/DEN82FA012.md): Beech E55 · Hayden, CO · Accident · 3 fatal · Closed · Dec 26, 1981 · N1766C · Destroyed
- [NTSB DEN78FA064](https://openairdocs.org/ntsb/DEN78FA064.md): Beech E-55 · Pueblo, CO · Incident · No injuries · Closed · Aug 23, 1978 · N9327Q · Minor damage

## 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 ('1152732'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1152732&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.
