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 CHI80FA065Accident · 4 fatalClosedPiper PA-23 · East Tawas, MIAug 27, 1980 · N44EM · Destroyed NTSB CHI80DEC33Accident · No injuriesClosedPiper PA-24 · Detroit, MIAug 27, 1980 · N6741P · Substantial damage NTSB CHI80DAMS3Accident · 1 fatalClosedCessna 182G · Ludington, MIAug 24, 1980 · N2323R · Destroyed NTSB CHI81DEC31Accident · No injuriesClosedCessna 172 · Pontiac, MIAug 20, 1980 · N4967G · Substantial damage NTSB CHI80FEM42Accident · Serious injuriesClosedPiper PA-28 · Harrison, MIAug 19, 1980 · N6839W · Destroyed NTSB CHI80FEM41Accident · No injuriesClosedCessna 152 · Negaunee, MIAug 16, 1980 · N4898H · Substantial damage NTSB CHI80FEC30Accident · No injuriesClosedBeech C23 · Pontiac, MIAug 15, 1980 · N1947L · Substantial damage NTSB CHI80FEM40Accident · No injuriesClosedCessna 172 · Fennville, MIAug 14, 1980 · N7660T · Substantial damage NTSB CHI80FEM39Accident · Serious injuriesClosedCorbin E · Hessel, MIAug 10, 1980 · N74702 · Substantial damage NTSB CHI80FA063Accident · 2 fatalClosedCessna 172 · Bois Blanc Is, MIAug 10, 1980 · N739PP · Destroyed NTSB CHI80DEC29Accident · Serious injuriesClosedPiccard AX-6 · Pontiac, MIAug 9, 1980 · N2482Z · No damage NTSB CHI80DEC28Accident · Minor injuriesClosedCessna 172N · Ubly, MIAug 3, 1980 · N2418E · Substantial damage NTSB CHI80FEM38Accident · No injuriesClosedPiper PA-28 · Kalamazoo, MIAug 1, 1980 · N6838W · Substantial damage NTSB CHI80FEC26Accident · 1 fatalClosedBell 47D1 · Munith, MIJul 30, 1980 · N3656F · Substantial damage NTSB CHI80DEM37Accident · No injuriesClosedBell 47G2 · Greenville, MIJul 28, 1980 · N2866B · Substantial damage NTSB CHI80FA060Accident · 1 fatalClosedPiper PA-28 · Lake City, MIJul 26, 1980 · N15336 · Destroyed NTSB CHI80FEC25Accident · Serious injuriesClosedBell 47D1 · Milan, MIJul 22, 1980 · N74006 · Substantial damage NTSB CHI80FEM35Accident · No injuriesClosedCessna U206B · Charlotte, MIJul 20, 1980 · N3830G · Substantial damage NTSB CHI80FA058Accident · 2 fatalClosedPiper J-3 · Flushing, MIJul 20, 1980 · N42726 · Destroyed NTSB CHI80FEM36Accident · Serious injuriesClosedGrum-Amer AA-1 · Midland, MIJul 17, 1980 · N5621L · Destroyed NTSB CHI80DA057Accident · 2 fatalClosedStinson 108-3 · Grattan, MIJul 17, 1980 · N4110C · Destroyed NTSB CHI80FEC23Accident · Serious injuriesClosedGreat Lakes 2T-1 · Mason, MIJul 13, 1980 · N88SK · Destroyed NTSB CHI80FEC24Accident · No injuriesClosedPiper PA-22 · Troy, MIJul 12, 1980 · N5821D · Substantial damage NTSB CHI80FEC22Accident · Serious injuriesClosedPiper PA-32R · Troy, MIJul 10, 1980 · N7113F · Destroyed NTSB CHI80FA052Accident · 1 fatalClosedCessna P210 · Marcellus, MIJul 10, 1980 · N616LP · Destroyed NTSB CHI80FA051Accident · 1 fatalClosedGrum Amer AA-1A · Troy, MIJul 8, 1980 · N7278L · Destroyed NTSB CHI80FEM33Accident · Minor injuriesClosedLake 4-200 · Byron Center, MIJul 6, 1980 · N1214L · Substantial damage NTSB CHI80DEM34Accident · No injuriesClosedSchweizer 2-33A · Frankfort, MIJul 5, 1980 · N17969 · Substantial damage NTSB CHI80FA050Accident · 2 fatalClosedPiper PA-11S · Orleans, MIJul 4, 1980 · N5065H · Substantial damage NTSB CHI80FET19Accident · No injuriesClosedBellanca 7ECA · Berrien Sprgs, MIJul 2, 1980 · N2737Z · Substantial damage NTSB CHI80DEM32Accident · No injuriesClosedPiper PA-28 · Lake Leelanau, MIJul 2, 1980 · N41973 · Destroyed NTSB CHI80FEC21Accident · Minor injuriesClosedCessna 172M · Fowlerville, MIJun 29, 1980 · N9413H · Substantial damage NTSB CHI80DEC20Accident · No injuriesClosedCessna 172N · Troy, MIJun 29, 1980 · N5136D · Substantial damage NTSB CHI80FEC27Accident · No injuriesClosedCessna 177 · South Lyon, MIJun 25, 1980 · N3396T · Substantial damage NTSB CHI80FEM31Accident · Minor injuriesClosedPitts S2A · Salt St Marie, MIJun 24, 1980 · C-GVHI · Substantial damage NTSB CHI80FEM29Accident · 1 fatalClosedScorpion II · Hastings, MIJun 23, 1980 · N88922 · Substantial damage NTSB CHI80DEM30Accident · No injuriesClosedPiper PA-25 · South Haven, MIJun 21, 1980 · N7278Z · Substantial damage NTSB CHI80DA047Accident · 1 fatalClosedCessna 180 · Otisville, MIJun 20, 1980 · N91473 · Destroyed NTSB CHI80FEM28Accident · Minor injuriesClosedMooney M20F · South Haven, MIJun 18, 1980 · N6765V · Destroyed NTSB CHI80DEM27Accident · No injuriesClosedBeech A23 · Paw Paw, MIJun 14, 1980 · N6134N · Substantial damage NTSB CHI80FEM26Accident · No injuriesClosedBeech B-23 · Onaway, MIMay 26, 1980 · N7617R · Substantial damage NTSB CHI80DEC19Accident · No injuriesClosedPiper PA-28R · Pigeon, MIMay 26, 1980 · N4581J · Substantial damage NTSB CHI80FA040Accident · 1 fatalClosedCessna 152 · Jerome, MIMay 21, 1980 · N5104B · Destroyed NTSB CHI80FEM25Accident · 1 fatalClosedChampion 7KCAB · Grant, MIMay 19, 1980 · N1635G · Destroyed NTSB CHI80FEM24Accident · No injuriesClosedLightizer Lakes · Grand Haven, MIMay 4, 1980 · N6RL · Substantial damage NTSB CHI80FEC17Accident · No injuriesClosedCessna 150K · Imlay City, MIMay 4, 1980 · N5783G · Substantial damage NTSB CHI80FEC16Accident · Minor injuriesClosedPiper PA-22 · Hadley, MIMay 4, 1980 · N8138D · Substantial damage NTSB CHI80FEC15Accident · No injuriesClosedCessna 150L · Troy, MIApr 26, 1980 · N11586 · Substantial damage NTSB CHI80FEM23Accident · Minor injuriesClosedCessna 177RG · Dorr, MIApr 25, 1980 · N34027 · Substantial damage NTSB CHI80DEC18Accident · Serious injuriesClosedBLN Works FRFY6B · Orchard Lake, MIApr 19, 1980 · N4067L · No damage