Fatal NTSB investigations, 2012

5 cases where the sequence of events included Midair collision.

Cases per year

20082026
Fatal NTSB investigations, 2012 per year, 2008–2026: 111 cases
20085
20098
20106
20118
20125
20133
20146
20157
201610
20173
20186
20196
20207
20213
20225
20235
20247
20258
20263

Latest cases

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB CEN13WA092Accident · 8 fatalForeign investigationPiper PA-32-301 · Melbach, GermanyOn 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…Dec 8, 2012 · D-EUEU · 2 aircraft · Substantial damageNTSB ERA12WA530Accident · 4 fatalForeign investigationEmbraer EMB711 · Sta Barbara D'Oeste, BrazilOn 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…Aug 18, 2012 · PT-NKA · 2 aircraft · Substantial damageNTSB ERA12RA367Accident · 2 fatalForeign investigationBeech V35B · Sumerduck, VAOn 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…May 28, 2012 · N6658R · 2 aircraft · DestroyedNTSB CEN12FA312Accident · 1 fatalField investigationFinal reportAir Tractor AT-802A · Sedgwick, ARThe 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.May 23, 2012 · N4126T · 2 aircraft · Substantial damageNTSB CEN12FA199Accident · 2 fatalField investigationFinal reportCessna 172S · Longmont, COThe inadequate visual lookout by the pilots of both airplanes, which resulted in a mid-air collision.Mar 23, 2012 · N10468 · 2 aircraft · Substantial damage