# NTSB investigations, MN: 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 CHI03FA284](https://openairdocs.org/ntsb/CHI03FA284.md): Cessna 172S · Lake Elmo, MN · Accident · 3 fatal · Field investigation · Final report · Aug 22, 2003 · N53033 · 2 aircraft · Destroyed
  > Both pilots failed to maintain adequate visual lookout and did not maintain clearance from the other aircraft.
- [NTSB CHI93LA195](https://openairdocs.org/ntsb/CHI93LA195.md): Cessna A150L · Blaine, MN · Accident · No injuries · Limited investigation · Final report · Feb 28, 1993 · N6059J · 2 aircraft · Minor damage
  > The failure of the pilot of the Cessna 150, N6059J, and the pilot of the challenger to see and avoid each other.
- [NTSB CHI92FA201](https://openairdocs.org/ntsb/CHI92FA201.md): Cessna 172N · St Paul, MN · Accident · 4 fatal · Field investigation · Final report · Jul 7, 1992 · N6376F · 2 aircraft · Destroyed
  > Inadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see-and-avoid conflicting traffic, and failure of the relieving controllers to use the radar display to identify and sequence an airplane entering the pattern.…
- [NTSB CHI92LA036](https://openairdocs.org/ntsb/CHI92LA036.md): Piper PA28R-200 · Lakeville, MN · Accident · Minor injuries · Limited investigation · Final report · Dec 1, 1991 · N2072T · 2 aircraft · Substantial damage
  > The failure of both pilots to maintain visual separation from each other. Contributing factors to this accident were an inadequate visual lookout by both pilots and the pilot-in-command's failure to follow procedures and directives.
- [NTSB MKC90FA032](https://openairdocs.org/ntsb/MKC90FA032.md): Beech 95-B55B · Lakeville, MN · Accident · No injuries · Field investigation · Final report · Nov 18, 1989 · N5678K · 2 aircraft · Substantial damage
  > Inadequate visual lookout by the pilot in command in both aircraft.
- [NTSB CHI84FA250](https://openairdocs.org/ntsb/CHI84FA250.md): Grumman G-164B · Warren, MN · Accident · 2 fatal · Field investigation · Final report · Jun 20, 1984 · N6533K · 2 aircraft · Destroyed
  > N9367K was on departure and climbout to aerial application operations. N6533K was about to enter the traffic pattern to land and reload. Marks on respective airframes indicate N9367K was above and approaching N6533K from the latter's forward left quarter;…
- [NTSB CHI84FA225](https://openairdocs.org/ntsb/CHI84FA225.md): Schleicher AS-K13 · Stanton, MN · Accident · 1 fatal · Field investigation · Final report · Jun 9, 1984 · N3313 · 2 aircraft · Destroyed
  > The tow plane and the sailplane it had towed to pattern alt collided on final approach of the pattern. The tow plane was supposed to follow the sailplane to land after it had dropped the tow rope. There was a low sun glare facing the towplt on the heading of…

## 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" = 'MN' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 270)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=270&state=MN

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