# NTSB investigations, 2007: 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 NYC08FA054](https://openairdocs.org/ntsb/NYC08FA054.md): Piper PA-30 · Parkland, FL · Accident · 2 fatal · Field investigation · Final report · Dec 8, 2007 · N766CC · 2 aircraft · Destroyed
  > Both pilots' failure to see and avoid the other airplane. Contributing to the accident were the erroneous readouts from the Cessna's altitude encoder.
- [NTSB SEA08LA031](https://openairdocs.org/ntsb/SEA08LA031.md): Cessna 182A · Tacoma, WA · Accident · Minor injuries · Limited investigation · Final report · Nov 20, 2007 · N6147B · 2 aircraft · Substantial damage
  > The failure of both pilots to maintain an adequate visual lookout during cruise flight.
- [NTSB MIA08LA005](https://openairdocs.org/ntsb/MIA08LA005.md): Piper PA-32R-301 · Farmingdale, NY · Accident · No injuries · Limited investigation · Final report · Oct 21, 2007 · N43450 · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid while maneuvering resulting in a midair collision. Contributing to the accident was the local controller's failure to properly identify conflicting traffic.
- [NTSB SEA07FA264](https://openairdocs.org/ntsb/SEA07FA264.md): Deluca-Owl OR-71 · Reno, NV · Accident · 1 fatal · Field investigation · Final report · Sep 14, 2007 · N1VD · 2 aircraft · Substantial damage
  > The failure of the pilots of both aircraft to maintain an adequate visual lookout and clearance from one another during a low altitude aerial race.
- [NTSB NYC07LA208](https://openairdocs.org/ntsb/NYC07LA208.md): Piper PA-28-181 · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Sep 2, 2007 · N465MA · 2 aircraft · Substantial damage
  > The inadequate visual lookout of the pilot of the unknown airplane.
- [NTSB LAX07MA231](https://openairdocs.org/ntsb/LAX07MA231.md): Eurocopter AS350-B2 · Phoenix, AZ · Accident · 4 fatal · Class 1 · Major · Final report · Jul 27, 2007 · N613TV · 2 aircraft · Destroyed
  > Both pilots' failure to see and avoid the other helicopter. Contributing to this failure was the pilots' responsibility to perform reporting and visual tracking duties to support their station's ENG operation. Contributing to the accident was the lack of…
- [NTSB CHI07FA140](https://openairdocs.org/ntsb/CHI07FA140.md): Cessna 172N · Sharonville, OH · Accident · 3 fatal · Field investigation · Final report · May 11, 2007 · N6614D · 2 aircraft · Destroyed
  > The inadequate visual lookout of the pilots in both airplanes and their not maintaining clearance from each others airplane during climb.
- [NTSB DFW07LA082](https://openairdocs.org/ntsb/DFW07LA082.md): Cessna T210R · Boerne, TX · Accident · No injuries · Limited investigation · Final report · Mar 8, 2007 · N766DP · 2 aircraft · Minor damage
  > The pilot of the other airplane's failure to maintain proper spacing during approach to landing and subsequent go-around, which resulted in a midair collision.
- [NTSB LAX07LA079](https://openairdocs.org/ntsb/LAX07LA079.md): Waco UPF-7 · Palos Verdes, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 2007 · N30140 · 2 aircraft · Substantial damage
  > the failure of both pilots to maintain adequate visual lookout and clearance from each other while maneuvering in close proximity.

## 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") = 2007
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 270)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=270&year=2007

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