Skip to content

NTSB investigations, MI

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with 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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'
  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'
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 CHI75FEM46Accident · No injuriesClosedIntercept 400 · Grand Rapids, MIJun 14, 1975 · N71LB · Substantial damage NTSB CHI75FECS5Accident · No injuriesClosedPiper PA-24 · Mason, MIJun 13, 1975 · N5574P · Substantial damage NTSB CHI75FEM45Accident · No injuriesClosedCessna 150 · Hudsonville, MIJun 10, 1975 · N66075 · Substantial damage NTSB CHI75FEC54Accident · No injuriesClosedPiper J3 · Ann Arbor, MIJun 8, 1975 · N21647 · Substantial damage NTSB CHI75AEM44Accident · No injuriesClosedLuscombe 8A · Alma, MIJun 6, 1975 · N1951B · Substantial damage NTSB CHI75AC094Accident · 3 fatalClosedCessna 177 · Detroit, MIJun 4, 1975 · N2242Y · Destroyed NTSB CHI75DEC53Accident · Minor injuriesClosedPitts S-1C · Chelsea, MIJun 3, 1975 · N24144 · Substantial damage NTSB CHI75DEC52Accident · No injuriesClosedPiper PA-22 · Linden, MIJun 2, 1975 · N5587Z · Substantial damage NTSB CHI75FEC51Accident · No injuriesClosedCessna 414 · Lapeer, MIMay 30, 1975 · N414GW · Substantial damage NTSB CHI75AEC50Accident · No injuriesClosedCessna 172 · Flint, MIMay 28, 1975 · N2418L · Substantial damage NTSB CHI75FEC49Accident · Serious injuriesClosedCessna 140 · Tecumseh, MIMay 25, 1975 · N2459V · Destroyed NTSB CHI75FEM42Accident · No injuriesClosedHughes 269C · Traverse City, MIMay 24, 1975 · N9662F · Substantial damage NTSB CHI75DEM43Accident · No injuriesClosedLuscombe 8A · Oshtemo, MIMay 23, 1975 · N71101 · Substantial damage NTSB CHI75FEC48Accident · No injuriesClosedPiper PA-28 · Ypsilanti, MIMay 22, 1975 · N2189T · Substantial damage NTSB CHI75AC088Accident · 1 fatalClosedStinson 108-2 · Jackson, MIMay 18, 1975 · N9508K · Destroyed NTSB CHI75FEC45Accident · No injuriesClosedCessna 172M · Troy, MIMay 17, 1975 · N20439 · Substantial damage NTSB CHI75FEC46Accident · No injuriesClosedPiper PA-18 · Detroit, MIMay 16, 1975 · N1237A · Substantial damage NTSB CHI75DEM41Accident · No injuriesClosedPiper PA-24 · Houghton Lake, MIMay 16, 1975 · N6753P · Substantial damage NTSB CHI75FEC47Accident · No injuriesClosedCessna 150L · Clarkston, MIMay 15, 1975 · N7505G · Destroyed NTSB CHI75FEM40Accident · No injuriesClosedCessna 150K · Battle Creek, MIMay 11, 1975 · N8452M · Substantial damage NTSB CHI75FEM38Accident · Serious injuriesClosedRaven S-40 · Fremont, MIMay 11, 1975 · N11976 · Destroyed NTSB CHI75DEM39Accident · No injuriesClosedLuscombe 8A · Marquette, MIMay 11, 1975 · N1117B · Substantial damage NTSB CHI75AC083Accident · 1 fatalClosedCessna 150G · Prudenville, MIMay 6, 1975 · N2910S · Substantial damage NTSB CHI75AC082Accident · 2 fatalClosedCessna 172L · Linden, MIMay 5, 1975 · N7590G · Destroyed NTSB CHI75AC081Accident · 2 fatalClosedPiper PA-28 · Vicksburg, MIMay 4, 1975 · N7065R · Destroyed NTSB CHI75AC080Accident · 3 fatalClosedCessna 172M · Grosse Pointe, MIApr 30, 1975 · N4612Q · Substantial damage NTSB CHI75DEM37Accident · No injuriesClosedGrumman G-164A · Schoolcraft, MIApr 18, 1975 · N9823 · Substantial damage NTSB CHI75DEC44Accident · No injuriesClosedCessna 150 · Owosso, MIApr 12, 1975 · N1250Q · Substantial damage NTSB CHI75FEM36Accident · No injuriesClosedBellanca 17-30A · Mackinac Is, MIApr 11, 1975 · N8259R · Substantial damage NTSB CHI75FEM35Accident · No injuriesClosedCessna 172 · Byron Center, MIApr 7, 1975 · N4432L · Substantial damage NTSB CHI75DEM34Accident · No injuriesClosedPiper PA-28 · Bay City, MIApr 6, 1975 · N8304R · Substantial damage NTSB CHI75FEC43Accident · No injuriesClosedPiper PA-28 · Ann Arbor, MIApr 5, 1975 · N55656 · Substantial damage NTSB CHI75DEC42Accident · No injuriesClosedCessna 150 · Port Huron, MIMar 23, 1975 · N19564 · Substantial damage NTSB CHI75AC070Accident · 3 fatalClosedCessna 337D · Stambaugh, MIMar 21, 1975 · N86134 · Destroyed NTSB CHI75FEM33Accident · No injuriesClosedCessna 150F · Kalamazoo, MIMar 20, 1975 · N10097 · Substantial damage NTSB CHI75FEC41Accident · Serious injuriesClosedCessna 140 · Mason, MIMar 19, 1975 · N76264 · Substantial damage NTSB CHI75DEM32Accident · No injuriesClosedAeronca 11AC · Ontonagon, MIMar 19, 1975 · N85931 · Substantial damage NTSB CHI75FEM31Accident · No injuriesClosedBell 47G · Portage, MIMar 17, 1975 · N7763 · Substantial damage NTSB CHI75DEM30Accident · No injuriesClosedCessna 185 · Iron Mountain, MIMar 15, 1975 · N9812X · Substantial damage NTSB NYC75DEC40Accident · No injuriesClosedPiper PA-20 · Flint, MIMar 14, 1975 · N2571A · Substantial damage NTSB CHI75AC065Incident · No injuriesClosedBeech H18 · Grayling, MIMar 12, 1975 · N6000M · Minor damage NTSB CHI75AC064Accident · No injuriesClosedBeech 95-C55 · Gaylord, MIMar 12, 1975 · N5740V · Substantial damage NTSB CHI75AC062Accident · No injuriesClosedTed Smith 600 · Detroit, MIMar 7, 1975 · N7MW · Substantial damage NTSB CHI75FEC39Accident · No injuriesClosedPiper PA-23 · Pontiac, MIMar 5, 1975 · N5212Y · Substantial damage NTSB CHI75DEM29Accident · No injuriesClosedBeech 35 · Gladwin, MIMar 1, 1975 · N4416D · Substantial damage NTSB CHI75FEM28Accident · Serious injuriesClosedThorp T-18 · Lansing, MIFeb 23, 1975 · N5564 · Destroyed NTSB CHI75AC058Accident · 1 fatalClosedNa Rockwell NA-265 · Pontiac, MIFeb 23, 1975 · N5107 · Destroyed NTSB CHI75FEC38Accident · No injuriesClosedCessna T337B · Pontiac, MIFeb 22, 1975 · N2414S · Substantial damage NTSB CHI75DEC37Accident · No injuriesClosedPiper PA-32 · Ann Arbor, MIFeb 20, 1975 · N3939W · Substantial damage NTSB CHI75FEC36Accident · No injuriesClosedCessna 210F · Howell, MIFeb 13, 1975 · N1864F · Substantial damage