# NTSB investigations, MI: 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 CHI90FA190](https://openairdocs.org/ntsb/CHI90FA190.md): Piper PA-28 · Plymouth, MI · Accident · 3 fatal · Field investigation · Final report · Jul 23, 1990 · N55354 · 2 aircraft · Destroyed
  > Inadequate visual lookout by the pilot of the PA-60. A factor related to the accident was that neither of the flight crews had obatained atc/radar assistance.
- [NTSB CHI87LA167](https://openairdocs.org/ntsb/CHI87LA167.md): Balloon Works Firefly 7 · Springfield, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 1987 · N1505F · 2 aircraft · Substantial damage
  > Two hot air balloons were involved in a midair collision during a sanctioned Balloon competition. N40363 was able to retain control and landed uneventfully. N1505F partially deflated and descended out of control to the ground. Witnesses stated that N40363 was…
- [NTSB CHI86FA094](https://openairdocs.org/ntsb/CHI86FA094.md): Cessna 152 · Drayton Plaines, MI · Accident · 1 fatal · Field investigation · Final report · Mar 1, 1986 · N93604 · 2 aircraft · Destroyed
  > After a home built dragon fly gnd looped, other acft in the VFR traffic pattern were sent around, including a Cessna 152(C-152), N93604, flown by a student plt. Shortly after the dragon fly was clrd fm the rwy, Cessna 172 (C-172), N48003, entered the pattern,…
- [NTSB CHI85LA291](https://openairdocs.org/ntsb/CHI85LA291.md): Balloon Works Firefly 6B · Battle Creek, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 16, 1985 · N1533S · 2 aircraft · Substantial damage
  > The envelope of Balloon N1533S was penetrated and torn by the basket of Balloon i-frog. The envelope was damaged to the degree that altitude could not be sustained. The aeronqut of N1533S was seriously injured upon ground impact. I-frog was landed without…
- [NTSB CHI82IA364](https://openairdocs.org/ntsb/CHI82IA364.md): Cessna 152 · Pontiac, MI · Incident · No injuries · Incident investigation · Final report · Sep 23, 1982 · N24236 · 2 aircraft · Minor damage
  > The pilot was on a local flight in Cessna 152, N4745B, practicing landings during a period of peak traffic. While the pilot was in the traffic to land on runway 27R, another Cessna 152, N24236, was cleared onto the left runway (27L). At 1722:05, N24236 was…

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

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