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 CHI79FEC03Accident · Serious injuriesClosedPiccard AX6 · Rochester, MIOct 29, 1978 · N24402 · No damage NTSB CHI79FEC01Accident · 2 fatalClosedNord Stampe SV4C · Wixom, MIOct 21, 1978 · N671SV · Destroyed NTSB CHI78FEM03Accident · No injuriesClosedHiller UH12A · Muskegon, MIOct 8, 1978 · N330M · Substantial damage NTSB CHI79FEM05Accident · No injuriesClosedPiper PA-22 · Grand Rapids, MIOct 2, 1978 · N4859A · Substantial damage NTSB CHI79DEM02Accident · No injuriesClosedBell 47G · Saginaw, MIOct 1, 1978 · N7762 · Substantial damage NTSB CHI78FEC56Accident · Minor injuriesClosedCessna 150L · Pontiac, MISep 25, 1978 · N5237Q · Substantial damage NTSB CHI78FEM42Accident · Minor injuriesClosedPiper PA-22 · Kalamazoo, MISep 20, 1978 · N2852Z · Substantial damage NTSB CHI78FEC55Accident · No injuriesClosedCessna 152 · Plymouth, MISep 16, 1978 · N69037 · Substantial damage NTSB CHI78FEC54Accident · No injuriesClosedPiper PA-24 · Flint, MISep 16, 1978 · N2SV · Substantial damage NTSB CHI78DEM43Accident · No injuriesClosedCessna 152 · Beal City, MISep 15, 1978 · N24552 · Substantial damage NTSB CHI78FA065Accident · 3 fatalClosedCessna 172K · Mackinaw City, MISep 10, 1978 · N84380 · Destroyed NTSB CHI78FEC52Accident · No injuriesClosedBeech BE35 · Pontiac, MISep 8, 1978 · N2834V · Substantial damage NTSB CHI78FEM41Accident · No injuriesClosedCessna 182 · Charlotte, MISep 7, 1978 · N8659T · Substantial damage NTSB CHI78DET37Accident · No injuriesClosedBeech A55 · Benton Harbor, MISep 4, 1978 · N511JL · Destroyed NTSB CHI78DEC53Accident · No injuriesClosedBalloon WKS 7 · Northville, MISep 4, 1978 · N2027F · Substantial damage NTSB CHI78FEC51Accident · No injuriesClosedCessna 152 · Clawson, MISep 3, 1978 · N757RP · Substantial damage NTSB CHI78FEM38Accident · No injuriesClosedCessna 182 · Hubbard Lake, MISep 2, 1978 · N21477 · Substantial damage NTSB CHI78FEC50Accident · No injuriesClosedSikorsky S55B · Pontiac, MISep 2, 1978 · N90885 · Destroyed NTSB CHI78FEM36Accident · No injuriesClosedCessna 180 · Nunica, MIAug 30, 1978 · N5133E · Substantial damage NTSB CHI78DEM37Accident · Serious injuriesClosedLake LA4200 · Foster City, MIAug 30, 1978 · N2738P · Destroyed NTSB CHI78FEC49Accident · No injuriesClosedCessna 172M · South Rockwood, MIAug 26, 1978 · N73606 · Substantial damage NTSB CHI78FEM39Accident · No injuriesClosedCessna 177 · Moorestown, MIAug 25, 1978 · N30242 · Substantial damage NTSB CHI78FA063Accident · No injuriesClosedCessna 337 · Escanaba, MIAug 23, 1978 · N75BB · Substantial damage NTSB CHI78FEC48Accident · Minor injuriesClosedAeronca 7AC · Imlay City, MIAug 20, 1978 · N85108 · Destroyed NTSB CHI78FEM34Accident · No injuriesClosedBell 47G · Chippewa, MIAug 19, 1978 · N5237A · Substantial damage NTSB CHI78FEM35Accident · Minor injuriesClosedTaylorcraft BL-65 · Grand Haven, MIAug 17, 1978 · N27427 · Substantial damage NTSB CHI78FEM32Accident · Minor injuriesClosedCessna 150L · Lansing, MIAug 17, 1978 · N18686 · Substantial damage NTSB CHI78FEC47Accident · Serious injuriesClosedPiper PA-38 · Romeo, MIAug 17, 1978 · N9304T · Destroyed NTSB CHI78DA062Accident · No injuriesClosedPitts Spcl 1 · Flat Rock, MIAug 13, 1978 · N28K · Substantial damage NTSB CHI78FEM33Accident · Minor injuriesClosedPiper PA-28 · Holland, MIAug 9, 1978 · N187SP · Substantial damage NTSB CHI78FEC46Accident · Minor injuriesClosedCessna 150M · Westland, MIAug 9, 1978 · N704HH · Substantial damage NTSB CHI78FEC45Accident · Serious injuriesClosedGrum Amer AA1-B · Milford, MIAug 4, 1978 · N1SU · Destroyed NTSB DCA78AA019Accident · Serious injuriesClosedConvair 580 · Kalamazoo, MIJul 25, 1978 · N4825C · Substantial damage NTSB CHI78FEM31Accident · No injuriesClosedPiper PA-22 · Evart, MIJul 25, 1978 · N9807D · Substantial damage NTSB CHI78FEM30Accident · No injuriesClosedPiper PA-28 · Ludington, MIJul 24, 1978 · N7936W · Substantial damage NTSB CHI78DEC42Accident · No injuriesClosedCessna 152 · Adrian, MIJul 24, 1978 · N24896 · Substantial damage NTSB CHI78FEC44Accident · No injuriesClosedPiper PA-25 · Cass City, MIJul 21, 1978 · N54902 · Destroyed NTSB CHI78FEC43Accident · No injuriesClosedCessna 402 · Salem, MIJul 20, 1978 · N4014Q · Substantial damage NTSB CHI78FEM29Accident · No injuriesClosedCessna 180 · Otsego Lake, MIJul 15, 1978 · N1608C · Substantial damage NTSB CHI78FEM28Accident · Serious injuriesClosedCessna 150L · Escanaba, MIJul 14, 1978 · N9918G · Destroyed NTSB CHI78FEM27Accident · No injuriesClosedStinson 108-1 · Lake Ann, MIJul 14, 1978 · N8568K · Substantial damage NTSB CHI78FEC41Accident · No injuriesClosedSchweizer SGS233 · Pontiac, MIJul 14, 1978 · N65810 · Substantial damage NTSB CHI78FEC40Accident · 1 fatalClosedRyan ST3KR · Petersburg, MIJul 14, 1978 · N48700 · Destroyed NTSB CHI78DEC39Accident · No injuriesClosedCessna 172N · Salem, MIJul 11, 1978 · N739FS · Substantial damage NTSB CHI78FEM26Accident · No injuriesClosedCessna 172N · Battle Creek, MIJul 10, 1978 · N733HW · Substantial damage NTSB CHI78DEM24Accident · No injuriesClosedCessna 150 · Sharon, MIJul 7, 1978 · N152HB · Substantial damage NTSB CHI78FEM25Accident · No injuriesClosedCessna 172 · Chesaning, MIJul 6, 1978 · N8189U · Substantial damage NTSB CHI78FA046Accident · 1 fatalClosedCessna 170B · Ann Arbor, MIJul 6, 1978 · N2763C · Destroyed NTSB CHI78FEM23Accident · Minor injuriesClosedCessna 172 · Lowell, MIJul 5, 1978 · N1108F · Substantial damage NTSB CHI78FEC38Accident · Serious injuriesClosedPiper PA-28 · Salem, MIJun 30, 1978 · N7505W · Substantial damage