# NTSB investigations: Approach control procedure

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 CEN11FA302](https://openairdocs.org/ntsb/CEN11FA302.md): Beech 58 · Topeka, KS · Accident · 4 fatal · Field investigation · Final report · Apr 22, 2011 · N580EA · Destroyed
  > The pilot failed to maintain control of the airplane while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot’s minimal experience flying in actual instrument conditions.
- [NTSB CEN09FA083](https://openairdocs.org/ntsb/CEN09FA083.md): Cessna 206H · Kalkaska, MI · Accident · 1 fatal · Field investigation · Final report · Dec 6, 2008 · N6053B · Destroyed
  > The pilot's failure to maintain clearance from trees and terrain during the instrument-flight-rules flight. Contributing to the accident was the pilot's failure to comply with instrument flight procedures and his lack of recent instrument flight experience.

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03014015'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/03014015/cases

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