# NTSB investigations, CO: Air traffic event

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 CEN16LA067](https://openairdocs.org/ntsb/CEN16LA067.md): Hawker 400 · Telluride, CO · Accident · No injuries · Limited investigation · Final report · Dec 23, 2015 · XA-MEX · Substantial damage
  > The limitations of the air traffic control equipment that prevented the controller's timely recognition of NOTAM information that was effective immediately and resulted in the issuance of an approach clearance to a closed runway. Also causal was the pilots'…
- [NTSB CEN11CA166](https://openairdocs.org/ntsb/CEN11CA166.md): Mcholland C L Solitare · Wellington, CO · Accident · No injuries · Data collection · Final report · Jan 29, 2011 · N15XP · Substantial damage
  > The glider pilot’s misjudgment while approaching to land, which resulted in an off-airport landing.
- [NTSB OPS10IA002](https://openairdocs.org/ntsb/OPS10IA002.md): Airbus A320 · Cortez, CO · Incident · No injuries · Incident investigation · Final report · Nov 6, 2009 · C-FKOJ · No damage
  > The failure of the ACA795 flight crew to monitor and/or switch to the appropriate air traffic control frequency.

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '100' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/100/sequence?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.