# NTSB investigations: Cessna 425, 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 DEN05FA126](https://openairdocs.org/ntsb/DEN05FA126.md): Cessna 425 · Lone Tree, CO · Accident · 4 fatal · Field investigation · Final report · Aug 14, 2005 · N425SG · Destroyed
  > The pilot's failure to properly execute the published instrument approach procedure, which resulted in controlled flight into terrain.
- [NTSB DEN03LA095](https://openairdocs.org/ntsb/DEN03LA095.md): Cessna 425 · Pueblo, CO · Accident · No injuries · Limited investigation · Final report · May 31, 2003 · N425SG · Substantial damage
  > the pilot's inadvertent flight into adverse weather conditions. Contributing factors include the encounter with severe turbulence and hail.
- [NTSB DEN86MA061](https://openairdocs.org/ntsb/DEN86MA061.md): Cessna 425 · Granby, CO · Accident · 5 fatal · Major investigation · Final report · Jan 11, 1986 · N425SC · Destroyed
  > Drg arrival, the plt advised ARTCC that the destination arpt appeared to be covered with fog. She then canceled her IFR flt plan. According to ground witnesses, the acft made several passes over the arpt. Witnesses also rprtd that the horizontal visibility…
- [NTSB DEN85LA244](https://openairdocs.org/ntsb/DEN85LA244.md): Cessna 425 · Boulder, CO · Accident · No injuries · Limited investigation · Final report · Sep 19, 1985 · N1222B · Substantial damage
  > The plt said he made a normal ldg. During ldg roll the left brake would not respond to pedal application. The plt errored by incorrectly feathering both props. The a/c went off the eng of r/w and struck a fence. Examination of the brake system revealed a…

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

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