Final NTSB investigations, 2019

8 cases where the sequence of events included Midair collision.

Cases per year

20082026
Final NTSB investigations, 2019 per year, 2008–2026: 149 cases
200813
200911
201010
20119
20129
20137
20147
20158
20169
20176
20189
20198
20209
20216
20227
20237
202410
20253
20261

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\") = 2019
    AND c.\"completionStatus\" = 'Completed'
    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 DCA20IA034Incident · No injuriesIncident investigationFinal reportAirbus AS 350 B2 · Los Angeles, CAan inflight collision with a hard object of polycarbonate construction, with size and features consistent with that of a small UAS (drone).Dec 5, 2019 · N71HD · 2 aircraft · Minor damageNTSB ERA20LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Toms River, NJThe failure of the Cessna 172N pilot to see and avoid a second airplane while maneuvering in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the Cessna 172N pilot to tune his radio to the correct…Nov 13, 2019 · N3958S · 2 aircraft · Substantial damageNTSB CEN20FA012Accident · 2 fatalClass 3 · FieldFinal reportRobinson R22 Beta · Hebbronville, TXThe failure of the spotter helicopter pilot to maintain clearance from the gunner helicopter while maneuvering. Contributing to the accident were the effects from the pilot’s use of impairing drugs.Oct 23, 2019 · N7189D · 2 aircraft · DestroyedNTSB CEN19IA234Incident · No injuriesClass 3 · IncidentFinal reportMooney M20J · Oshkosh, WIThe failure of both pilots to remain clear of the other while flying in formation.Jul 21, 2019 · N9201A · 2 aircraft · Minor damageNTSB ERA19FA183Accident · 1 fatalClass 3 · FieldFinal reportVans Vans RV 4 · Green Cove Springs, FLThe failure of each pilot to maintain separation from the other airplane during intentional maneuvers within close proximity of each other.May 29, 2019 · N319RL · 2 aircraft · DestroyedNTSB WPR19FA145Accident · 2 fatalClass 3 · FieldFinal reportGrumman G164 · Pleasant Grove, CAThe failure of both pilots to see and avoid the other airplane, which resulted in a midair collision.May 15, 2019 · N6787K · 2 aircraft · Substantial damageNTSB CEN19MA141Accident · 6 fatalClass 1 · MajorFinal reportDe Havilland DHC-2 · Ketchikan, AKThe inherent limitations of the see-and-avoid concept, which prevented the two pilots from seeing the other airplane before the collision, and the absence of visual and aural alerts from both airplanes’ traffic display systems, while operating in a geographic…May 13, 2019 · N952DB · 2 aircraft · DestroyedNTSB CEN19LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Grand Prairie, TXThe failure of the pilots of both airplanes to see and avoid the other airplane while entering the airport traffic pattern in visual meteorological conditions. Contributing to the accident was the tower controller's failure to recognize the proximity of the…Jan 29, 2019 · N565SP · 2 aircraft · Substantial damage