NTSB investigations, MI
5 cases where the first occurrence was “Midair collision”.
Cases per year
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CHI90FA190Accident · 3 fatalField investigationFinal reportPiper PA-28 · Plymouth, MIInadequate 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 CHI87LA167Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Springfield, MITwo 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 CHI86FA094Accident · 1 fatalField investigationFinal reportCessna 152 · Drayton Plaines, MIAfter 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 CHI85LA291Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 6B · Battle Creek, MIThe 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 CHI82IA364Incident · No injuriesIncident investigationFinal reportCessna 152 · Pontiac, MIThe 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…