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 CHI75FEC35Accident · Serious injuriesClosedEmeraude 1 · Onondaga, MIFeb 11, 1975 · N1470 · Substantial damage NTSB CHI75DEM26Accident · Serious injuriesClosedPiper J-3 · Midland, MIFeb 2, 1975 · N7202H · Substantial damage NTSB CHI75FEM27Accident · No injuriesClosedVolpar H18 · Saginaw, MIJan 31, 1975 · N958B · Substantial damage NTSB CHI75DEM25Accident · Minor injuriesClosedCessna 150L · Traverse City, MIJan 28, 1975 · N1420Q · Substantial damage NTSB CHI75FEM24Accident · Minor injuriesClosedPiper PA-22 · Marquette, MIJan 27, 1975 · N5143Z · Substantial damage NTSB CHI75AC052Accident · No injuriesClosedBeech C-45H · Detroit, MIJan 15, 1975 · N45437 · Substantial damage NTSB CHI75DEM23Accident · No injuriesClosedBeech A23-19 · Traverse City, MIJan 10, 1975 · N20TD · Substantial damage NTSB CHI75AC050Accident · 4 fatalClosedPiper PA-28 · Watervliet, MIJan 8, 1975 · N9762J · Destroyed NTSB CHI75AC049Accident · 1 fatalClosedBeech E35 · Westland, MIJan 7, 1975 · N7308B · Destroyed NTSB CHI75FEC34Accident · No injuriesClosedCessna 337A · Howell, MIJan 6, 1975 · N5403S · Substantial damage NTSB CHI75DEM22Accident · Minor injuriesClosedAero Comdr 680 · Big Rapids, MIJan 6, 1975 · N6891S · Substantial damage NTSB CHI75FEC32Accident · No injuriesClosedPiper PA-28 · Troy, MIJan 2, 1975 · N55580 · Substantial damage NTSB CHI75FEC31Accident · No injuriesClosedCessna 150 · S Rockwood, MIDec 30, 1974 · N50794 · Substantial damage NTSB CHI75DEM13Accident · No injuriesClosedCessna 150H · Cadillac, MIDec 28, 1974 · N6934S · Substantial damage NTSB CHI75FEC30Accident · No injuriesClosedMaule M4220C · Ann Arbor, MIDec 26, 1974 · N51161 · Substantial damage NTSB CHI75DEC29Accident · No injuriesClosedMcculloch J2 · Otisville, MIDec 25, 1974 · N4384 · Substantial damage NTSB CHI75FEC28Accident · No injuriesClosedPiper PA-28 · Lake Orion, MIDec 18, 1974 · N56497 · Substantial damage NTSB CHI75FEC27Accident · No injuriesClosedPiper PA-28 · Grosse Ile, MIDec 17, 1974 · N5063T · Substantial damage NTSB CHI75DEM09Accident · No injuriesClosedCessna 120 · East Tawas, MIDec 12, 1974 · N89982 · Substantial damage NTSB CHI75AC044Accident · 1 fatalClosedCessna 150J · Utica, MIDec 9, 1974 · N51370 · Destroyed NTSB CHI75FEC26Accident · Minor injuriesClosedLuscombe 8E · Ann Arbor, MIDec 3, 1974 · N2075K · Substantial damage NTSB CHI75FET12Accident · No injuriesClosedCessna 120 · Sodus, MIDec 2, 1974 · N2571N · Substantial damage NTSB CHI75FEM20Accident · No injuriesClosedJupiter J1 · Plainwell, MINov 29, 1974 · N2981C · Substantial damage NTSB CHI75DEM21Accident · Minor injuriesClosedBeech K35 · Gaylord, MINov 28, 1974 · N6068E · Substantial damage NTSB CHI75FEC25Accident · No injuriesClosedBensen B-8M · Grosse Ile, MINov 23, 1974 · N104RJ · Substantial damage NTSB CHI75FEC24Accident · Serious injuriesClosedPiper J3C-65 · Ypsilanti, MINov 22, 1974 · N2472C · Substantial damage NTSB CHI75DEC33Accident · No injuriesClosedCessna 421 · Detroit, MINov 17, 1974 · N99NE · Substantial damage NTSB CHI75FEC23Accident · No injuriesClosedBeech B19 · Pontiac, MINov 16, 1974 · N1924W · Substantial damage NTSB CHI75FEC22Accident · No injuriesClosedPiper PA-28 · Deerfield, MINov 10, 1974 · N44567 · Substantial damage NTSB MIA75AM026Accident · Serious injuriesClosedDouglas DC-8 · Detroit, MINov 6, 1974 · N815E · No damage NTSB CHI75DEM18Accident · No injuriesClosedCessna 120 · Burlington, MIOct 31, 1974 · N2339N · Substantial damage NTSB CHI75DEM19Accident · No injuriesClosedCessna 150 · Boyne City, MIOct 28, 1974 · N22919 · Substantial damage NTSB CHI75DEC21Accident · No injuriesClosedPiper PA-30 · Port Huron, MIOct 28, 1974 · CF-VLE · Substantial damage NTSB CHI75FEC20Accident · Minor injuriesClosedAmer Avco AA1-B · Clio, MIOct 26, 1974 · N8987L · Substantial damage NTSB CHI75FEC19Accident · Serious injuriesClosedSchleicher AS-K13 · Adrian, MIOct 26, 1974 · N14AA · Substantial damage NTSB CHI75AC034Accident · Serious injuriesClosedBeech 99 · Jackson, MIOct 23, 1974 · N140J · Substantial damage NTSB CHI75FEC18Accident · No injuriesClosedCessna 414 · Jackson, MIOct 20, 1974 · N414HC · Destroyed NTSB CHI75DEM17Accident · No injuriesClosedCessna 210T · Rockford, MIOct 20, 1974 · N381DS · Substantial damage NTSB CHI75AC033Accident · 1 fatalClosedBeech H18 · Iron Mtn, MIOct 17, 1974 · N72FA · Destroyed NTSB CHI75DEM16Accident · No injuriesClosedErco 415-C · Plainwell, MIOct 11, 1974 · N2372H · Substantial damage NTSB CHI75FEM15Accident · No injuriesClosedCessna 150 · Slt St Marie, MIOct 9, 1974 · N6621Y · Substantial damage NTSB CHI75FEC17Accident · No injuriesClosedLuscombe 8A · Napoleon, MIOct 9, 1974 · N72011 · Substantial damage NTSB CHI75FEM14Accident · 1 fatalClosedPiper PA-25 · Wayland, MIOct 1, 1974 · N8922L · Destroyed NTSB CHI75FEC16Accident · No injuriesClosedGates Lear 24 · Detroit, MISep 23, 1974 · N111LJ · Substantial damage NTSB CHI75FEM12Accident · Minor injuriesClosedBell 47G-2 · Paw Paw, MISep 21, 1974 · N7893B · Substantial damage NTSB CHI75FEC15Accident · No injuriesClosedCessna 180 · Springville, MISep 21, 1974 · N7713A · Destroyed NTSB CHI75FEC14Accident · 1 fatalClosedWard-Rand KR-1 · Adrian, MISep 20, 1974 · N6364 · Destroyed NTSB CHI75FEM11Accident · Serious injuriesClosedCessna 172 · Harrison, MISep 19, 1974 · N4155F · Destroyed NTSB CHI75FEC13Accident · No injuriesClosedBellanca 14-19 · Jackson, MISep 15, 1974 · N7624E · Substantial damage NTSB CHI75DEM10Accident · No injuriesClosedCessna 120 · Paw Paw, MISep 14, 1974 · N2948N · Substantial damage