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 CHI81FEC38Accident · No injuriesClosedPiper PA-28 · Oxford, MIJul 31, 1981 · N2139N · Substantial damage NTSB CHI81FEC26Accident · No injuriesClosedCessna 150 · Monroe, MIJul 29, 1981 · N17134 · Substantial damage NTSB CHI81FEM31Accident · No injuriesClosedPiper PA-32R · Harbor Springs, MIJul 26, 1981 · N39659 · Substantial damage NTSB CHI81DEC35Accident · No injuriesClosedCessna 172 · Deford, MIJul 25, 1981 · N13203 · Substantial damage NTSB CHI81DEM34Accident · No injuriesClosedCessna 172K · Mackinac Is, MIJul 24, 1981 · N78424 · Substantial damage NTSB CHI81FEM30Accident · No injuriesClosedGrumman G-164A · Howard City, MIJul 23, 1981 · N5083 · Substantial damage NTSB CHI81DEC37Accident · No injuriesClosedVliegtuigbo SA-013 · Adrian, MIJul 22, 1981 · N9121 · Substantial damage NTSB CHI81FEM32Accident · No injuriesClosedPiper PA-31 · Mt Pleasant, MIJul 20, 1981 · N500KH · Substantial damage NTSB CHI81FEC34Accident · Minor injuriesClosedCessna A185F · Clio, MIJul 17, 1981 · N6440E · Destroyed NTSB CHI81DEM28Accident · No injuriesClosedAeronca 11AC · Elwell, MIJul 17, 1981 · N39578 · Substantial damage NTSB CHI81IA075Incident · No injuriesClosedBeech 18 · Detroit, MIJul 11, 1981 · N355C · Minor damage NTSB CHI81FEC33Accident · Minor injuriesClosedCessna 152 · Wixom, MIJul 11, 1981 · N64978 · Substantial damage NTSB CHI81FEM29Accident · No injuriesClosedCessna 172 · Mackinac Is, MIJul 9, 1981 · N7920B · Substantial damage NTSB CHI822A073Incident · No injuriesClosedSwearingen SA-226 · Detroit, MIJul 7, 1981 · N781S · Minor damage NTSB CHI81DEM26Accident · No injuriesClosedCessna 152 · S.Manitou Is, MIJul 6, 1981 · N47559 · Substantial damage NTSB CHI81FEM25Accident · No injuriesClosedPiper PA-28 · Mecosta, MIJul 4, 1981 · N9515K · Substantial damage NTSB CHI81FEC31Accident · Serious injuriesClosedBellanca 8KCAB · Hillsdale, MIJul 4, 1981 · N2692Z · Destroyed NTSB CHI81FEM27Accident · Minor injuriesClosedPiper PA-22 · Alma, MIJul 3, 1981 · N5009Z · Substantial damage NTSB CHI81FEC32Accident · No injuriesClosedCessna 172N · Lambertville, MIJul 3, 1981 · N739EJ · Substantial damage NTSB CHI81DEM24Accident · No injuriesClosedPiper PA-25 · Langston, MIJul 3, 1981 · N82539 · Substantial damage NTSB CHI81FA070Accident · 5 fatalClosedCessna 401 · Muskegon, MIJun 30, 1981 · N7957F · Destroyed NTSB CHI81FEC29Accident · Minor injuriesClosedCessna 152 · Linden, MIJun 28, 1981 · N757ET · Substantial damage NTSB CHI81FEM23Accident · Serious injuriesClosedSonerai II · Escanaba, MIJun 27, 1981 · N88877 · Destroyed NTSB CHI81FEC30Accident · Minor injuriesClosedPiper PA-38 · Utica, MIJun 27, 1981 · N24088 · Destroyed NTSB CHI81FEC28Accident · Serious injuriesClosedCessna U206F · Plymouth, MIJun 19, 1981 · N8532Q · Destroyed NTSB CHI81DEM22Accident · No injuriesClosedMaule M-5 · Gaylord, MIJun 14, 1981 · N5639Y · Substantial damage NTSB CHI81DEM21Accident · No injuriesClosedMaule M-5 · Gaylord, MIJun 13, 1981 · N5631N · Substantial damage NTSB CHI81DEM20Accident · Serious injuriesClosedCessna 180 · Detour Village, MIJun 12, 1981 · N4593B · Substantial damage NTSB CHI81DEM19Accident · Minor injuriesClosedStinson 108-3 · Midland, MIJun 11, 1981 · N676C · Substantial damage NTSB CHI81FA062Accident · 2 fatalClosedBellanca 17-31 · Hessel, MIJun 5, 1981 · N9699E · Destroyed NTSB CHI81FEC27Accident · No injuriesClosedCessna 152 · Almont, MIJun 3, 1981 · N69011 · Substantial damage NTSB CHI81FEM18Accident · No injuriesClosedCessna 170B · Lowell, MIMay 31, 1981 · N2836C · Substantial damage NTSB CHI81FEM17Accident · No injuriesClosedCessna 152 · Shepard, MIMay 31, 1981 · N5108L · Substantial damage NTSB CHI81FEC26Accident · Serious injuriesClosedPiper PA-28 · Bad Axe, MIMay 30, 1981 · N4996F · Destroyed NTSB CHI81FA059Accident · 2 fatalClosedCessna 310R · Grand Rapids, MIMay 27, 1981 · N2636L · Destroyed NTSB CHI81FEC24Accident · No injuriesClosedCessna 182 · Tecumseh, MIMay 17, 1981 · N5552B · Substantial damage NTSB CHI81FEC25Accident · No injuriesClosedPiper PA-28 · Fraser, MIMay 16, 1981 · N47624 · Substantial damage NTSB CHI81FEM16Accident · No injuriesClosedCessna 152 · Portland, MIMay 13, 1981 · N48731 · Substantial damage NTSB CHI81FEM15Accident · No injuriesClosedCessna 170 · Charlotte, MIMay 1, 1981 · N9194A · Substantial damage NTSB CHI81FA053Accident · 2 fatalClosedCessna 172M · Saginaw, MIApr 28, 1981 · N5224R · Destroyed NTSB CHI81IA052Incident · No injuriesClosedRockwell 265-80 · Kalamazoo, MIApr 24, 1981 · N59 · Minor damage NTSB CHI81FA051Accident · 3 fatalClosedMitsubishi MU-2B · Alpena, MIApr 23, 1981 · N9JS · Destroyed NTSB CHI81FEC23Accident · Minor injuriesClosedCessna 152 · Hadley, MIApr 22, 1981 · N89475 · Substantial damage NTSB CHI81DEC22Accident · No injuriesClosedCessna 172H · Mason, MIApr 21, 1981 · N2673L · Substantial damage NTSB CHIB1FEM14Accident · Minor injuriesClosedPiper J5A · Covert, MIApr 18, 1981 · N35697 · Substantial damage NTSB CHI81FEC21Accident · Minor injuriesClosedPiper PA-30 · Ann Arbor, MIApr 14, 1981 · N7755Y · Destroyed NTSB CHI81FA044Accident · 2 fatalClosedAeronca 65-TAL · West Olive, MIApr 9, 1981 · N36878 · Destroyed NTSB CHI81FEC20Accident · No injuriesClosedCessna 182RG · Howell, MIApr 4, 1981 · N4608T · Substantial damage NTSB CHI81FA040Accident · 1 fatalClosedPiper PA-32 · Corunna, MIMar 31, 1981 · N2158D · Destroyed NTSB CHI81FEM12Accident · No injuriesClosedVeebee 4 · Safinaw, MIMar 28, 1981 · N4VB · Substantial damage