NTSB investigations, 2015

13 cases where the sequence of events included Midair collision.

Cases per year

20082026
NTSB investigations, 2015 per year, 2008–2026: 197 cases
200813
200912
201011
201111
201212
20137
20148
201513
201613
20178
201813
201910
202011
20217
20228
202310
202413
202511
20266

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\") = 2015
    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 WPR16LA016Accident · No injuriesLimited investigationFinal reportCessna 310C · Primm, NVThe inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision. Contributing to the accident was the pilots' failure to tune to, monitor, and communicate over the common traffic advisory frequency their relative positions…Oct 23, 2015 · N310CD · 2 aircraft · Substantial damageNTSB CEN15WA429Accident · 4 fatalForeign investigationPiper PA28 · Sandstedt, GermanyOn September 26, 2015, at 1138 universal coordinated time, a Piper PA-28, German registration D-EBVM and a Reims F172, German registration D-EGJA, collided over Sandstedt, Germany. The pilot on board the PA-28 was fatally injured. The pilot and two passengers…Sep 26, 2015 · D-EBVM · 2 aircraft · DestroyedNTSB DCA15WA188Accident · 7 fatalForeign investigationBoeing 737 · Tambacounda, SenegalSep 5, 2015 · 3C-LLY · 2 aircraft · Minor damageNTSB WPR15MA243Accident · 5 fatalMajor investigationFinal reportCessna 172M · San Diego, CAThe local controller's (LC) failure to properly identify the aircraft in the pattern and to ensure control instructions provided to the intended Cessna on downwind were being performed before turning Eagle1 into its path for landing. Contributing to the LC's…Aug 16, 2015 · N1285U · 2 aircraft · DestroyedNTSB ERA15WA303Accident · 9 fatalForeign investigationCessna U206F · Istra, RussiaOn August 8, 2015, at 1708 universal coordinated time, a Cessna U206F airplane, Russian registration RA- 67523 registered to a private owner, and a Robinson R44 II helicopter, Russian registration RA- 04383, registered to a private owner, collided while…Aug 8, 2015 · RA-67523 · 2 aircraft · DestroyedNTSB ERA15MA259Accident · 2 fatalClass 2 · MajorFinal reportCessna 150M · Moncks Corner, SCThe approach controller's failure to provide an appropriate resolution to the conflict between the F-16 and the Cessna. Contributing to the accident were the inherent limitations of the see-and-avoid concept, resulting in both pilots' inability to take…Jul 7, 2015 · N3601V · 2 aircraft · DestroyedNTSB GAA15CA157Accident · Minor injuriesData collectionFinal reportBalloon Works FIREFLY8 - 24 · Provo, UT**This report was modified on 4/21/2016. Please see the public docket for this accident for more information.** The failure of the Balony balloon pilot to see and avoid the Balloon Works balloon during an ascent, which resulted in the basket of the Balony…Jul 2, 2015 · N7148P · 2 aircraft · Substantial damageNTSB ANC15WA043Accident · 2 fatalForeign investigationCessna 172 · Fort McMurray, CanadaJun 22, 2015 · C-GJSE · 2 aircraft · Substantial damageNTSB ANC15LA033Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe other pilot’s failure to maintain an adequate visual lookout, which resulted in a midair collision. Contributing to the accident was the other pilot’s failure to follow Federal Aviation Administration-recommended traffic pattern procedures.Jun 1, 2015 · N1694M · 2 aircraft · Substantial damageNTSB ERA15WA233Accident · 1 fatalForeign investigationVans RV8 · Corropoli, ItalyOn May 31, 2015, about 1430 universal coordinated time, a Vans RV8, I-LOVI, and a Vans RV7, I-AMEL, were destroyed after colliding midair and then subsequently colliding with the Adriatic Sea, near Corropoli, Italy. The Italian certificated pilot of the RV8…May 31, 2015 · I-LOVI · 2 aircraft · DestroyedNTSB ERA15LA172Accident · No injuriesClass 3 · LimitedFinal reportMerian Richard F RV 8 · Tuscaloosa, ALThe RV-8 pilot's failure to maintain adequate clearance from the RV-6 while maneuvering during an air show, which resulted in a midair collision.Mar 29, 2015 · N8JL · 2 aircraft · Substantial damageNTSB ANC15FA009Accident · Serious injuriesField investigationFinal reportPiper PA 18 · Wasilla, AKBoth pilots’ inadequate visual lookout and failure to see and avoid each other while in level cruise flight, which resulted in a midair collision. Contributing to the accident was the obscuration of the other pilot’s visibility due to sun glare.Jan 31, 2015 · N82735 · 2 aircraft · Substantial damageNTSB ERA15LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · West Palm Beach, FLThe failure of the airplane pilots to maintain an adequate visual lookout for known traffic in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the airplane pilots to announce their intentions before…Jan 28, 2015 · N54380 · 2 aircraft · Minor damage