# NTSB investigations, 2009: Midair collision

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 WPR10FA068](https://openairdocs.org/ntsb/WPR10FA068.md): Schleicher ASW-27 · Middletown, CA · Accident · 2 fatal · Field investigation · Final report · Nov 28, 2009 · N127AL · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid the other airplane. Contributing to the accident was the pilot's failure to yield right of way to the glider.
- [NTSB CEN10FA011](https://openairdocs.org/ntsb/CEN10FA011.md): Cessna 150F · Alexandria, LA · Accident · 2 fatal · Field investigation · Final report · Oct 10, 2009 · N8642S · 2 aircraft · Substantial damage
  > Failure of the wingman to maintain proper separation from the lead airplane during formation maneuvers. Contributing to the accident was lead's abrupt right bank and both pilots' lack of formation training.
- [NTSB WPR09FA437](https://openairdocs.org/ntsb/WPR09FA437.md): Cessna 152 · Coolidge, AZ · Accident · 1 fatal · Field investigation · Final report · Sep 9, 2009 · N94741 · 2 aircraft · Substantial damage
  > The failure of both safety/spotter pilots to see and avoid the other airplane.
- [NTSB CEN09WA582](https://openairdocs.org/ntsb/CEN09WA582.md): Reims F172 · Commune de Brethencourt, France · Accident · 2 fatal · Foreign investigation · Sep 8, 2009 · F-BXIU · 2 aircraft · Destroyed
  > Under the jurisdiction and control of the French government.
- [NTSB CEN09LA555](https://openairdocs.org/ntsb/CEN09LA555.md): Destiny Powered Parachutes Destiny 2000 · Arcanum, OH · Accident · 1 fatal · Limited investigation · Final report · Aug 25, 2009 · N5604B · 2 aircraft · Substantial damage
  > The failure of pilot to maintain an adequate visual lookout in order to avoid the collision with an aircraft on final approach to land.
- [NTSB ERA09MA447](https://openairdocs.org/ntsb/ERA09MA447.md): Piper PA-32R-300 · Hoboken, NJ · Accident · 9 fatal · Class 1 · Major · Final report · Aug 8, 2009 · N71MC · 2 aircraft · Substantial damage
  > (1) the inherent limitations of the see-and-avoid concept, which made it difficult for the airplane pilot to see the helicopter until the final seconds before the collision, and (2) the Teterboro Airport local controller’s nonpertinent telephone conversation,…
- [NTSB CEN09LA491](https://openairdocs.org/ntsb/CEN09LA491.md): Cessna 182J · Iowa Falls, IA · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 2009 · N989TP · 2 aircraft · Substantial damage
  > Both pilots' failure to execute adequate visual lookout, resulting in the two airplanes colliding over the runway.
- [NTSB ERA09LA302](https://openairdocs.org/ntsb/ERA09LA302.md): Hazelwood Michael S RV-8 · Decatur, AL · Accident · 1 fatal · Limited investigation · Final report · May 23, 2009 · N875MH · 2 aircraft · Substantial damage
  > The RV-8 pilot's failure to maintain adequate clearance from the CJ-6A while maneuvering. This report was modified on September 10, 2010.
- [NTSB WPR09FA248](https://openairdocs.org/ntsb/WPR09FA248.md): Cessna 172N · Long Beach, CA · Accident · 3 fatal · Field investigation · Final report · May 19, 2009 · N738NN · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid each other's aircraft.
- [NTSB WPR09LA228](https://openairdocs.org/ntsb/WPR09LA228.md): Ayres S2R-T34 · Marysville, CA · Accident · Serious injuries · Limited investigation · Final report · May 6, 2009 · N40208 · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid the other airplane while making their final approach for landing.
- [NTSB CEN09IA161](https://openairdocs.org/ntsb/CEN09IA161.md): Piper PA28 · Fairmont, NE · Incident · No injuries · Incident investigation · Final report · Feb 7, 2009 · N55502 · 2 aircraft · Minor damage
  > Both pilots' failure to see and avoid the other aircraft.
- [NTSB CEN09LA149](https://openairdocs.org/ntsb/CEN09LA149.md): North American T-6G · Cypress, TX · Accident · No injuries · Limited investigation · Final report · Jan 31, 2009 · N51KT · 2 aircraft · Minor damage
  > Both pilot's failure to see and avoid the other aircraft.

## 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") = 2009
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '250' 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/250/sequence?year=2009

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