# NTSB investigations, 2010: 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 OPS11IA173](https://openairdocs.org/ntsb/OPS11IA173.md): Boeing 737-832 · Covington, KY · Incident · No injuries · Incident investigation · Final report · Dec 9, 2010 · N3731T · 2 aircraft · No damage
  > The local controller's distraction with a helicopter south of the field.
- [NTSB WPR11FA032](https://openairdocs.org/ntsb/WPR11FA032.md): Mooney M20J · Lander, WY · Accident · 4 fatal · Field investigation · Final report · Oct 25, 2010 · N201HF · Substantial damage
  > The pilot's decision to depart into known adverse weather conditions over mountainous terrain, which required operation near the limits of the airplane's performance capability and which resulted in a loss of airplane control and subsequent ground impact.…
- [NTSB OPS11IA054](https://openairdocs.org/ntsb/OPS11IA054.md): Dassault FALCON900EX · Teterboro, NJ · Incident · No injuries · Incident investigation · Final report · Oct 20, 2010 · PHILC · 3 aircraft · No damage
  > The pilot of the F900 overshooting of the final approach course, which conflicted with traffic in the pattern. Contributing to the accident was the lack of appropriate coordination between the tower controller and the approach controller.
- [NTSB OPS10IA538](https://openairdocs.org/ntsb/OPS10IA538.md): Boeing 737-7H4 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Sep 4, 2010 · N907WN · 2 aircraft · No damage
  > Failure of the air traffic controller to exercise positive control of the situation by issuing clear and timely control instructions to the helicopter pilot. Contributing to the incident was delay by the helicopter pilot in responding to instructions issued…
- [NTSB OPS10IA196](https://openairdocs.org/ntsb/OPS10IA196.md): Airbus Industrie A319-132 · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · May 21, 2010 · N810AW · 2 aircraft · No damage
  > The approach controller's delayed transfer of communications on the A319 to the tower controller and failure to account for the aircraft's speed when he directed the crew to turn north. Contributing to the incident was the 747 crew's transfer of radio…
- [NTSB OPS10IA132](https://openairdocs.org/ntsb/OPS10IA132.md): Boeing 737-7H4 · Houston, TX · Incident · No injuries · Incident investigation · Final report · Apr 28, 2010 · N242WN · 2 aircraft · No damage
  > The failure of the local controller to issue control instructions necessary to ensure positive control/standard separation of traffic operating within the Class B airspace.
- [NTSB OPS10IA090](https://openairdocs.org/ntsb/OPS10IA090.md): Boeing 737-7H4 · Burbank, CA · Incident · No injuries · Incident investigation · Final report · Apr 19, 2010 · N473WN · 2 aircraft · No damage
  > The improper separation procedures by air traffic control.

## 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 year(c."eventDate") = 2010
  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?year=2010

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