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 CHI77FET30Accident · Minor injuriesClosedBellanca 7FC · Baroda, MIJul 28, 1977 · N4853E · Substantial damage NTSB CHI77FEC40Accident · No injuriesClosedPiper PA28 · Mason, MIJul 26, 1977 · N7963F · Substantial damage NTSB CHI77DEM30Accident · No injuriesClosedBeech 56TC · Traverse City, MIJul 25, 1977 · N570S · Substantial damage NTSB CHI77FEM34Accident · Serious injuriesClosedBell 47D · Byron Center, MIJul 21, 1977 · N64580 · Substantial damage NTSB CHI77FET26Accident · Minor injuriesClosedCessna 188B · Coloma, MIJul 18, 1977 · N4462Q · Destroyed NTSB CHI77FET25Accident · No injuriesClosedErco 415-C · Edwardsburg, MIJul 18, 1977 · N94074 · Substantial damage NTSB CHI77DEM36Accident · No injuriesClosedBellanca 7ECA · Manistique, MIJul 16, 1977 · N6352N · Substantial damage NTSB CHI77FET23Accident · No injuriesClosedPiper PA-25 · Niles, MIJul 13, 1977 · N7278Z · Substantial damage NTSB CHI77DEC38Accident · No injuriesClosedCessna 150 · Pontiac, MIJul 13, 1977 · N1642Q · Substantial damage NTSB CHI77FEM33Accident · Serious injuriesClosedCessna 172 · Stambaugh, MIJul 10, 1977 · N303EE · Substantial damage NTSB CHI77FEM32Accident · Minor injuriesClosedPiper PA-28 · St. Helen, MIJul 10, 1977 · N9008J · Destroyed NTSB CHI77FA056Accident · 4 fatalClosedPiper PA-23 · Freesoil, MIJul 4, 1977 · N4338P · Destroyed NTSB CHI77DEM31Accident · No injuriesClosedSchweizer SGS2-3 · Cedar, MIJul 3, 1977 · N65879 · Substantial damage NTSB CHI77FEM35Accident · No injuriesClosedCessna 172K · Beaverton, MIJul 2, 1977 · N78157 · Substantial damage NTSB CHI77FEC34Accident · No injuriesClosedLuscombe 8F · Clio, MIJun 27, 1977 · N2225B · Substantial damage NTSB CHI77FEC39Accident · No injuriesClosedMcculloch J-2 · Flint, MIJun 26, 1977 · N4328G · Substantial damage NTSB CHI77FEC37Accident · Serious injuriesClosedPiper PA-28 · Marlette, MIJun 25, 1977 · N7588W · Substantial damage NTSB CHI77FA054Accident · 4 fatalClosedMooney M20F · Port Huron, MIJun 25, 1977 · N9349V · Substantial damage NTSB CHI77FA053Accident · 5 fatalClosedCessna 182C · Grattan, MIJun 25, 1977 · N8723T · Destroyed NTSB CHI77DEM29Accident · No injuriesClosedSchemp Cirrus · Ionia, MIJun 25, 1977 · N111JT · Substantial damage NTSB CHI77FEM27Accident · No injuriesClosedCessna 188B · Grand Rapids, MIJun 24, 1977 · N9073R · Destroyed NTSB CHI77FEC33Accident · No injuriesClosedCessna 150 · Ann Arbor, MIJun 23, 1977 · N66590 · Substantial damage NTSB CHI77FEM28Accident · No injuriesClosedPiper PA-31 · Grayling, MIJun 19, 1977 · N62948 · Substantial damage NTSB CHI77FEC32Accident · No injuriesClosedCessna 180B · Napoleon, MIJun 18, 1977 · N9126T · Substantial damage NTSB CHI77FEC35Accident · No injuriesClosedFly Baby 1-A · Flint, MIJun 17, 1977 · N7105 · Substantial damage NTSB CHI77FEC31Accident · No injuriesClosedCessna 172 · Jackson, MIJun 10, 1977 · N1191U · Substantial damage NTSB CHI77FEC30Accident · Serious injuriesClosedPiper PA-22 · Carleton, MIJun 4, 1977 · N4788A · Destroyed NTSB CHI77FEC29Accident · No injuriesClosedCessna 150 · Troy, MIJun 3, 1977 · N704HP · Substantial damage NTSB CHI77FEC28Accident · Minor injuriesClosedLuscombe 8A · Carleton, MIJun 1, 1977 · N45976 · Substantial damage NTSB CHI77FEM26Accident · No injuriesClosedHughes 269B · Evart, MIMay 30, 1977 · N9423F · Substantial damage NTSB CHI77FA045Accident · Serious injuriesClosedLear Jet 25B · Detroit, MIMay 26, 1977 · N501PS · Destroyed NTSB CHI77FEM25Accident · No injuriesClosedPiper PA36 · Grant, MIMay 17, 1977 · N57588 · Substantial damage NTSB CHI77FEC27Accident · Minor injuriesClosedTaylorcraft L-2 · Monroe, MIMay 14, 1977 · N50414 · Substantial damage NTSB CHI77FA042Accident · 1 fatalClosedBeagle 206S2 · Mendon, MIMay 2, 1977 · N500KR · Destroyed NTSB CHI77FEM24Accident · No injuriesClosedPiper PA-31 · Grand Rapids, MIApr 28, 1977 · N7404L · Substantial damage NTSB CHI77FEC26Accident · Minor injuriesClosedBeech K-35 · Petersburg, MIApr 27, 1977 · N6068E · Destroyed NTSB CHI77FEM23Accident · No injuriesClosedStinson 108-3 · Birch Run, MIApr 26, 1977 · N6876M · Substantial damage NTSB CHI77DEC25Accident · No injuriesClosedPiper PA-28 · Lapeer, MIApr 13, 1977 · N4565X · Substantial damage NTSB CHI77FEM22Accident · 1 fatalClosedAmer Avco AA1 · East Tawas, MIApr 11, 1977 · N5706L · Destroyed NTSB CHI77FEM21Accident · 1 fatalClosedCessna 150J · Albion, MIApr 9, 1977 · N50883 · Destroyed NTSB CHI77FEC25Accident · Serious injuriesClosedMitsubishi MU-2B · Ypsilanti, MIApr 4, 1977 · N321MA · Destroyed NTSB CHI77FEC24Accident · No injuriesClosedPiper PA-24 · Owosso, MIApr 3, 1977 · N7057P · Substantial damage NTSB CHI77DEM20Accident · Minor injuriesClosedPiper PA-18 · Faithorne, MIApr 1, 1977 · N7088B · Substantial damage NTSB CHI77FA037Accident · 2 fatalClosedCessna 172M · Iron River, MIMar 27, 1977 · N1136U · Destroyed NTSB CHI77FEC22Accident · No injuriesClosedBeech E18S · Detroit, MIMar 25, 1977 · N152JB · Substantial damage NTSB CHI77DET10Accident · No injuriesClosedCessna 150 · Sturgis, MIMar 23, 1977 · N6087K · Substantial damage NTSB CHI77FEC21Accident · Serious injuriesClosedEnstrom F-28A · Howell, MIMar 17, 1977 · N9598 · Destroyed NTSB CHI77FEC19Accident · No injuriesClosedCessna 172 · Monroe, MIMar 16, 1977 · N70256 · Minor damage NTSB CHI77FEC20Accident · Serious injuriesClosedRockwell 500-S · Mt. Clemens, MIMar 12, 1977 · N303E · Destroyed NTSB CHI77FEM19Accident · No injuriesClosedCessna 310R · Baldwin, MIMar 9, 1977 · N98839 · Substantial damage