# NTSB investigations, ID: 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 WPR24FA201](https://openairdocs.org/ntsb/WPR24FA201.md): Air Tractor AT-802 · Arco, ID · Accident · 1 fatal · Class 3 · Field · Final report · Jun 20, 2024 · N802TP · 2 aircraft · Destroyed
  > A midair collision between two airplanes during aerial application operations due to both pilots’ insufficient awareness of their proximity to each other and their failure to see and avoid each other. Contributing to the accident was the operator and both…
- [NTSB WPR20FA206](https://openairdocs.org/ntsb/WPR20FA206.md): Cessna TU206 · Coeur d'Alene, ID · Accident · 8 fatal · Class 3 · Field · Final report · Jul 5, 2020 · N6373U · 2 aircraft · Destroyed
  > The failure of the pilots of both airplanes to see and avoid the other airplane.
- [NTSB DCA18IA264](https://openairdocs.org/ntsb/DCA18IA264.md): Lindstrand 105A · Driggs, ID · Incident · No injuries · Incident investigation · Final report · Aug 10, 2018 · N1410C · 2 aircraft · No damage
  > the drone pilot's decision to fly without pre-coordination, and without the requisite skills and knowledge, to maneuver the drone in close proximity to another aircraft.
- [NTSB WPR16LA146](https://openairdocs.org/ntsb/WPR16LA146.md): Cessna 172 · Emmett, ID · Accident · No injuries · Limited investigation · Final report · Jul 17, 2016 · N8184B · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid each other during cruise flight, which resulted in a midair collision.
- [NTSB WPR14FA283](https://openairdocs.org/ntsb/WPR14FA283.md): American Champion 7GCBC · Landmark, ID · Accident · 1 fatal · Field investigation · Final report · Jul 7, 2014 · N162CG · 2 aircraft · Substantial damage
  > The failure of the overtaking airplane’s pilot to maintain visual contact and separation from the airplane being overtaken.
- [NTSB WPR13FA296](https://openairdocs.org/ntsb/WPR13FA296.md): Piper PA-22-135 · Yellow Pine, ID · Accident · 1 fatal · Field investigation · Final report · Jun 28, 2013 · N1540P · 2 aircraft · Substantial damage
  > The pilot's failure to see and avoid the airplane ahead of his position in the airport traffic pattern, which resulted in a midair collision while both airplanes were on approach to land. Contributing to the accident was both pilots’ failure to adequately…
- [NTSB SEA08FA116](https://openairdocs.org/ntsb/SEA08FA116.md): Cessna 172N · McCall, ID · Accident · 3 fatal · Field investigation · Final report · May 3, 2008 · N75856 · 2 aircraft · Destroyed
  > The failure of the pilot to maintain adequate visual lookout and clearance from another airplane while attempting to land on the same runway. Contributing to the accident was the non-standard pattern entry of the pilot.

## 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 c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA'
  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?state=ID

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