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 CHI76FEM42Accident · Serious injuriesClosedPiper J-3 · Sparta, MIMay 20, 1976 · N98045 · Substantial damage NTSB CHI76DEM41Accident · No injuriesClosedCessna 150 · Lansing, MIMay 18, 1976 · N7679U · Substantial damage NTSB CHI76AC062Accident · 1 fatalClosedPiper PA-28 · Milan, MIMay 14, 1976 · N5729W · Destroyed NTSB CHI76FEM40Accident · No injuriesClosedCessna 150 · Lamont, MIMay 10, 1976 · N4545U · Substantial damage NTSB CHI76FEC44Accident · Serious injuriesClosedBeech B35 · Troy, MIMay 5, 1976 · N3917N · Substantial damage NTSB CHI76FEM39Accident · No injuriesClosedBell 47G · Portage, MIMay 3, 1976 · N7763 · Substantial damage NTSB CHI76AC058Accident · No injuriesClosedBeech E18 · Kalamazoo, MIApr 30, 1976 · N2510C · Substantial damage NTSB CHI76FEM38Accident · No injuriesClosedCessna 182H · Acme, MIApr 28, 1976 · N2402X · Substantial damage NTSB CHI76FEM37Accident · Minor injuriesClosedEvangel 4500 · Grand Haven, MIApr 19, 1976 · N4508L · Substantial damage NTSB CHI76DEC39Accident · No injuriesClosedCessna 172 · Troy, MIApr 16, 1976 · N64119 · Substantial damage NTSB MIA76FLD39Accident · No injuriesClosedDehavilland DHC-2 · Cedar Lake, MIApr 15, 1976 · N63315 · Substantial damage NTSB CHI76FEM35Accident · No injuriesClosedLuscombe 8E · Glen, MIApr 11, 1976 · N1449B · Substantial damage NTSB CHI76FEC40Accident · Minor injuriesClosedCessna 120 · Mason, MIApr 10, 1976 · N1775V · Substantial damage NTSB CHI76FEC37Accident · Minor injuriesClosedCessna 188 · Ypsilanti, MIApr 8, 1976 · N21829 · Substantial damage NTSB CHI76FEC38Accident · Serious injuriesClosedCessna 175 · Lansing, MIApr 7, 1976 · N1515S · Destroyed NTSB CHI76AEM34Accident · Minor injuriesClosedPiper PA-25 · Edmore, MIApr 7, 1976 · N4921Y · Destroyed NTSB CHI76FEC36Accident · Minor injuriesClosedHughes 269A · Richmond, MIMar 28, 1976 · N8880F · Destroyed NTSB CHI76FEC35Accident · No injuriesClosedBell 47G-2 · Whitmore Lake, MIMar 26, 1976 · N2873B · Destroyed NTSB CHI76FEC34Accident · No injuriesClosedPiper PA-24 · Owosso, MIMar 22, 1976 · N99LB · Substantial damage NTSB CHI76FEC33Accident · No injuriesClosedChampion 7FC · Jackson, MIMar 14, 1976 · N9805Y · Substantial damage NTSB CHI76FEC32Accident · Minor injuriesClosedCessna 177RG · Owosso, MIMar 10, 1976 · N8060G · Destroyed NTSB CHI76FEC31Accident · No injuriesClosedBell 47G-5 · Adrian, MIMar 9, 1976 · N8563F · Substantial damage NTSB CHI76DEC30Accident · No injuriesClosedCessna 150B · Caro, MIMar 7, 1976 · N1258Y · Substantial damage NTSB CHI76FEM33Accident · Serious injuriesClosedPiper PA-32 · Lansing, MIMar 4, 1976 · N3969W · Substantial damage NTSB CHI76FEC29Accident · No injuriesClosedBellanca 17-30 · Port Huron, MIFeb 27, 1976 · N7341V · Substantial damage NTSB CHI76FEM32Accident · No injuriesClosedPiper PA-12 · Whitehall, MIFeb 20, 1976 · N4275M · Substantial damage NTSB CHI76FEC28Accident · No injuriesClosedCessna 150G · Petersburg, MIFeb 20, 1976 · N3412J · Substantial damage NTSB CHI76FEM29Accident · Minor injuriesClosedCessna 120 · Big Rapids, MIFeb 15, 1976 · N2099V · Substantial damage NTSB CHI76FEC27Accident · Minor injuriesClosedPiper PA-28 · Ann Arbor, MIFeb 12, 1976 · N55656 · Substantial damage NTSB CHI76FEC26Accident · No injuriesClosedCessna 150L · Westland, MIFeb 12, 1976 · N1528Q · Substantial damage NTSB CHI76FEM30Accident · Minor injuriesClosedCessna 210 · Grand Rapids, MIFeb 10, 1976 · N93303 · Substantial damage NTSB CHI76FEM27Accident · No injuriesClosedCessna 172 · Marshall, MIFeb 9, 1976 · N91596 · Substantial damage NTSB CHI76DEM31Accident · No injuriesClosedCessna 177 · Newberry, MIFeb 9, 1976 · N3393T · Substantial damage NTSB CHI76DEM28Accident · No injuriesClosedCessna 182J · Newberry, MIFeb 9, 1976 · N3091F · Substantial damage NTSB CHI76DEC25Accident · No injuriesClosedCessna 172 · Mason, MIFeb 7, 1976 · N2890Q · Substantial damage NTSB CHI76AC047Accident · 1 fatalClosedCessna 172L · Bay City, MIJan 31, 1976 · N3971Q · Destroyed NTSB CHI76FEC24Accident · Minor injuriesClosedPiper PA-28 · Ann Arbor, MIJan 29, 1976 · N15372 · Substantial damage NTSB CHI76DEM26Accident · No injuriesClosedCessna 120 · Kalamazoo, MIJan 27, 1976 · N2404N · Substantial damage NTSB CHI76IC045Incident · No injuriesClosedLockheed 1011 · Detroit, MIJan 25, 1976 · N715DA · Minor damage NTSB CHI76FEC23Accident · No injuriesClosedPiper PA-22 · Tecumseh, MIJan 25, 1976 · N3002Z · Substantial damage NTSB CHI76FEC22Accident · Serious injuriesClosedBeech 95-B55 · Pontiac, MIJan 25, 1976 · N8408N · Destroyed NTSB CHI76FEC21Accident · No injuriesClosedCessna 172 · Pinckney, MIJan 18, 1976 · N4154F · Substantial damage NTSB CHI76DEC20Accident · No injuriesClosedCessna 150M · Grosse Ile, MIJan 18, 1976 · N3546V · Substantial damage NTSB CHI76FEM25Accident · No injuriesClosedCessna 172 · South Haven, MIJan 15, 1976 · N46579 · Substantial damage NTSB CHI76FEC19Accident · No injuriesClosedChampion 7ECA · Plymouth, MIJan 8, 1976 · N2595F · Substantial damage NTSB CHI76FEM23Accident · Minor injuriesClosedPiper PA-28 · Eaton Rapids, MIJan 5, 1976 · N5549F · Substantial damage NTSB CHI76DEM24Accident · No injuriesClosedHughes 269C · Saginaw, MIJan 5, 1976 · N9685F · Substantial damage NTSB CHI76FEC16Accident · 1 fatalClosedCessna 182 · Detroit, MIDec 28, 1975 · N6054B · No damage NTSB CHI76FEC18Accident · Serious injuriesClosedRyan Navion · Jackson, MIDec 27, 1975 · N4216K · Destroyed NTSB CHI76FEC17Accident · No injuriesClosedPiper PA-28 · Detroit, MIDec 26, 1975 · N56889 · Substantial damage