Fatal NTSB investigations, 2011

8 cases where the sequence of events included Midair collision.

Cases per year

20082026
Fatal NTSB investigations, 2011 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\") = 2011
    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 ERA12WA089Accident · 2 fatalForeign investigationPiper PA-28-236 · Mercedes, ArgentinaOn November 21, 2011, about 1320 coordinated universal time, a Piper PA-28-236, Argentine Air Force designation PF-449, and a Cessna 152, Argentine registration LV-OOF, collided while on approach to Mercedes Airfield (MRD), Mercedes, Buenos Aires Province,…Nov 21, 2011 · PG-449 · 2 aircraft · Minor damageNTSB WPR12FA020Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · St. Paul, ORThe pilot was unable to see the other aircraft to avoid a collision.Oct 25, 2011 · N3062H · 2 aircraft · Substantial damageNTSB ANC11FA091Accident · 1 fatalField investigationFinal reportCessna 208B · Nightmute, AKThe failure of the pilot of the other airplane to maintain adequate clearance while performing an unexpected and unannounced abrupt maneuver, resulting in a midair collision between the two airplanes.Sep 2, 2011 · N207DR · 2 aircraft · DestroyedNTSB ERA11FA468Accident · 1 fatalField investigationFinal reportMitchell David N Lancair IV P · Hammonton, NJThe Lancair pilot's failure to see and avoid the aerobatic airplane. Contributing to the accident was the Lancair pilot's inadequate use of collision avoidance strategies while inbound to an area of known potential aerobatic activity.Aug 20, 2011 · N71DM · 2 aircraft · Substantial damageNTSB CEN11LA573Accident · 1 fatalLimited investigationFinal reportStevens R P/Mccright D W Vans RV-6 · Conroe, TXThe failure of the pilot of the RV-6 airplane to maintain clearance from the RV-8 airplane while practicing formation flight.Aug 13, 2011 · N16DD · 2 aircraft · Substantial damageNTSB ANC11FA071Accident · 4 fatalField investigationFinal reportCessna U206G · Talkeetna, AKThe inadequate visual lookout and failure to see and avoid by the pilots of both airplanes while maneuvering to land, which resulted in a midair collision. Contributing to the accident was the lack of standardized, unequivocal procedures concerning common…Jul 30, 2011 · N756MP · 2 aircraft · Minor damageNTSB CEN11WA458Accident · 1 fatalForeign investigationVans RV6 · Shoreham, United KingdomOn July 4, 2011, at 1528 Universal Coordinated Time (UTC), a Vans RV-6A single-engine airplane, G-RVCG, and a Diamond DA-40 single-engine airplane, G-CEZR, collided in midair while maneuvering near Shoreham, West Sussex, United Kingdom. G-RVGC was destroyed…Jul 4, 2011 · G-RVGC · 2 aircraft · DestroyedNTSB ERA11FA291Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · New Hampton, NYThe PA24 pilot’s failure to maintain adequate clearance from the PA28, resulting in an in-flight collision. Contributing to the accident was the PA24 pilot's decision to overtake the PA28.May 9, 2011 · N5275L · 2 aircraft · Substantial damage