# NTSB investigations, 2019: 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 DCA20IA034](https://openairdocs.org/ntsb/DCA20IA034.md): Airbus AS 350 B2 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Dec 5, 2019 · N71HD · 2 aircraft · Minor damage
  > an inflight collision with a hard object of polycarbonate construction, with size and features consistent with that of a small UAS (drone).
- [NTSB ERA20LA034](https://openairdocs.org/ntsb/ERA20LA034.md): Cessna 172 · Toms River, NJ · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 13, 2019 · N3958S · 2 aircraft · Substantial damage
  > The 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…
- [NTSB CEN20FA012](https://openairdocs.org/ntsb/CEN20FA012.md): Robinson R22 Beta · Hebbronville, TX · Accident · 2 fatal · Class 3 · Field · Final report · Oct 23, 2019 · N7189D · 2 aircraft · Destroyed
  > The 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.
- [NTSB CEN19WA283](https://openairdocs.org/ntsb/CEN19WA283.md): Bell 206 · Inca, Mallorca, Spain · Accident · 7 fatal · Foreign investigation · Aug 25, 2019 · D-HOTT · 2 aircraft · Destroyed
  > On June 25, 2019, about 1335 local time, a Bell 206L-3 helicopter, D-HOTT, and an Aeroprakt A22L airplane collided in mid-air, near Inca, Mallorca, Spain. The pilot and four passengers aboard the helicopter and the two people on the airplane, received fatal…
- [NTSB CEN19IA234](https://openairdocs.org/ntsb/CEN19IA234.md): Mooney M20J · Oshkosh, WI · Incident · No injuries · Class 3 · Incident · Final report · Jul 21, 2019 · N9201A · 2 aircraft · Minor damage
  > The failure of both pilots to remain clear of the other while flying in formation.
- [NTSB ERA19FA183](https://openairdocs.org/ntsb/ERA19FA183.md): Vans Vans RV 4 · Green Cove Springs, FL · Accident · 1 fatal · Class 3 · Field · Final report · May 29, 2019 · N319RL · 2 aircraft · Destroyed
  > The failure of each pilot to maintain separation from the other airplane during intentional maneuvers within close proximity of each other.
- [NTSB WPR19FA145](https://openairdocs.org/ntsb/WPR19FA145.md): Grumman G164 · Pleasant Grove, CA · Accident · 2 fatal · Class 3 · Field · Final report · May 15, 2019 · N6787K · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid the other airplane, which resulted in a midair collision.
- [NTSB CEN19MA141](https://openairdocs.org/ntsb/CEN19MA141.md): De Havilland DHC-2 · Ketchikan, AK · Accident · 6 fatal · Class 1 · Major · Final report · May 13, 2019 · N952DB · 2 aircraft · Destroyed
  > The 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…
- [NTSB CEN19LA074](https://openairdocs.org/ntsb/CEN19LA074.md): Cessna 172 · Grand Prairie, TX · Accident · No injuries · Limited investigation · Final report · Jan 29, 2019 · N565SP · 2 aircraft · Substantial damage
  > The 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…
- [NTSB ERA19WA174](https://openairdocs.org/ntsb/ERA19WA174.md): Eurocopter AS350 · Megeve, Italy · Accident · 7 fatal · Foreign investigation · Jan 25, 2019 · I-EDIC · 2 aircraft · Destroyed
  > The government of Italy has notified the NTSB of an accident involving a midair collision between a Eurocopter AS350-B3 helicopter and a Jodel D.140E airplane that occurred on January 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist…

## 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") = 2019
  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?year=2019

---
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.