# NTSB investigations, WI: 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 CEN23FA333](https://openairdocs.org/ntsb/CEN23FA333.md): Rotorway 162F · Oshkosh, WI · Accident · 2 fatal · Class 3 · Field · Final report · Jul 29, 2023 · N193AZ · 2 aircraft · Destroyed
  > The failure of the gyroplane pilot to see and avoid the helicopter while maneuvering in the traffic pattern. Contributing to the accident was the gyroplane pilot’s performance of a prohibited maneuver in the traffic pattern.
- [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 CEN14LA036](https://openairdocs.org/ntsb/CEN14LA036.md): Cessna 182L · Superior, WI · Accident · Minor injuries · Limited investigation · Final report · Nov 2, 2013 · N70520 · 2 aircraft · Destroyed
  > The failure of the pilot who was flying the trail airplane to maintain separation from the lead airplane. Contributing to the accident was the inadequate pilot training for formation skydiving operations.
- [NTSB CEN10IA447](https://openairdocs.org/ntsb/CEN10IA447.md): Piper PA-32R-301 · Ripon, WI · Incident · No injuries · Incident investigation · Final report · Jul 27, 2010 · N8159B · 2 aircraft · Minor damage
  > The inability of either pilot to see the other airplane due to the blind spot created by their respective airplane's wings.

## 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" = 'WI' 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=WI

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