# Fatal NTSB investigations, 2012: 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 CEN13WA092](https://openairdocs.org/ntsb/CEN13WA092.md): Piper PA-32-301 · Melbach, Germany · Accident · 8 fatal · Foreign investigation · Dec 8, 2012 · D-EUEU · 2 aircraft · Substantial damage
  > On December 8, 2012, about 1513 coordinated universal time, a Piper PA-32, German registration, D-EUEU, and a Robin Regent DR400, German registration D-EHJP, collided while on cross country flights near Melbach, Germany. Visual meteorological conditions…
- [NTSB ERA12WA530](https://openairdocs.org/ntsb/ERA12WA530.md): Embraer EMB711 · Sta Barbara D'Oeste, Brazil · Accident · 4 fatal · Foreign investigation · Aug 18, 2012 · PT-NKA · 2 aircraft · Substantial damage
  > On August 18, 2012, at 1140 UTC an Embraer EMB-711C (Piper PA-28R-200), Brazilian registration PT-NKA, registered to a private owner, and a Embraer EMB-711C (Piper PA-28R-200), Brazilian registration PT-NIR, registered to a private owner, collided in cruise…
- [NTSB ERA12RA367](https://openairdocs.org/ntsb/ERA12RA367.md): Beech V35B · Sumerduck, VA · Accident · 2 fatal · Foreign investigation · May 28, 2012 · N6658R · 2 aircraft · Destroyed
  > On May 28, 2012, about 1604 eastern daylight time, a Beech V35B, N6658R, and a Piper PA-28-140, N23SC, collided in flight in the vicinity of Sumerduck, Virginia. The Beech was destroyed, and the pilot and flight instructor were fatally injured; the Piper was…
- [NTSB CEN12FA312](https://openairdocs.org/ntsb/CEN12FA312.md): Air Tractor AT-802A · Sedgwick, AR · Accident · 1 fatal · Field investigation · Final report · May 23, 2012 · N4126T · 2 aircraft · Substantial damage
  > The inability of both pilots to see and avoid the other airplane, which resulted in a midair collision. Contributing to the accident was the distraction of the Air Tractor pilot by a cellular telephone conversation during the flight.
- [NTSB CEN12FA199](https://openairdocs.org/ntsb/CEN12FA199.md): Cessna 172S · Longmont, CO · Accident · 2 fatal · Field investigation · Final report · Mar 23, 2012 · N10468 · 2 aircraft · Substantial damage
  > The inadequate visual lookout by the pilots of both airplanes, which resulted in a mid-air collision.

## 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") = 2012
  AND c."highestInjuryLevel" = 'Fatal'
  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?fatal=1&year=2012

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
