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 CHI79DEC54Accident · No injuriesClosedCessna 180 · Dexter, MISep 8, 1979 · N4750U · Substantial damage NTSB CHI79FEC49Accident · No injuriesClosedAeronca 7AC · Deford, MISep 4, 1979 · N85188 · Substantial damage NTSB CHI79FEC51Accident · Minor injuriesClosedHughes 269B · Flint, MISep 3, 1979 · N9310F · Substantial damage NTSB CHI79FEC48Accident · No injuriesClosedBeech 35 · Detroit, MISep 3, 1979 · N3712N · Substantial damage NTSB CHI79FEC50Accident · No injuriesClosedPiper PA-28R · Hudson, MISep 2, 1979 · N54425 · Substantial damage NTSB CHI79FA071Accident · 3 fatalClosedPiper PA-28R · Grayling, MISep 2, 1979 · N4392T · Destroyed NTSB CHI79FEC52Accident · Serious injuriesClosedPiper PA-28 · Marine City, MISep 1, 1979 · N5944V · Destroyed NTSB CHI79DEM39Accident · No injuriesClosedPiper PA-22 · Selkirk, MISep 1, 1979 · N8824D · Substantial damage NTSB CHI79DEC53Accident · No injuriesClosedCessna 152 · Detroit, MISep 1, 1979 · N25800 · Substantial damage NTSB CHI79FEM37Accident · Minor injuriesClosedSikorsky S-55B · Stanton, MIAug 30, 1979 · N6737 · Substantial damage NTSB CHI79CEM38Accident · No injuriesClosedCessna 150 · Muskegon, MIAug 30, 1979 · N68339 · Substantial damage NTSB CHI79DEM36Accident · No injuriesClosedGrumman AA1B · Harrisville, MIAug 26, 1979 · N9942L · Substantial damage NTSB CHI79FA067Accident · 2 fatalClosedBeech 95-B55 · Kinross, MIAug 24, 1979 · N4422W · Destroyed NTSB CHI79FEC47Accident · No injuriesClosedHughes 369H5 · Grosse Ile, MIAug 20, 1979 · N9034F · Substantial damage NTSB CHI79FEC45Accident · No injuriesClosedLark 28B2 · Manchester, MIAug 19, 1979 · N74NS · 2 aircraft · Substantial damage NTSB CHI79FEM35Accident · No injuriesClosedPiper PA-32R · Harbor Springs, MIAug 16, 1979 · N6145J · Substantial damage NTSB CHI79FEM34Accident · No injuriesClosedBell 47G-2 · Hart, MIAug 16, 1979 · N4734S · Substantial damage NTSB CHI79FEC44Accident · 1 fatalClosedStitts SA-3A · Manchester, MIAug 16, 1979 · N19BC · Destroyed NTSB CHI79FEC42Accident · No injuriesClosedCessna 182 · Tecumseh, MIAug 12, 1979 · N3939D · Substantial damage NTSB CHI79FEC41Accident · Serious injuriesClosedMaule M-5 · Owosso, MIAug 12, 1979 · N9177E · Destroyed NTSB CHI79FEC43Accident · No injuriesClosedCessna 150M · New Hudson, MIAug 7, 1979 · N9287U · Substantial damage NTSB CHI79FEC40Accident · 1 fatalClosedLockheed 12A · Pontiac, MIAug 7, 1979 · N36P · Destroyed NTSB CHI79FEM33Accident · 2 fatalClosedBreezy FGC100 · Grand Haven, MIAug 5, 1979 · N219TC · 2 aircraft · Minor damage NTSB CHI79FEM32Accident · No injuriesClosedCessna 150E · Dafter, MIAug 1, 1979 · C-FXCC · Substantial damage NTSB CHI79DEC39Accident · Serious injuriesClosedVariviggin · Flint, MIJul 26, 1979 · N29X · Substantial damage NTSB CHI79FEM30Accident · No injuriesClosedErco 415-C · Woodland, MIJul 24, 1979 · N2748H · Destroyed NTSB CHI79DA060Incident · No injuriesClosedCessna 310L · Detroit, MIJul 24, 1979 · N3074T · Minor damage NTSB CHI79FEM31Accident · No injuriesClosedPiper PA-30 · Kalamazoo, MIJul 23, 1979 · N8173Y · Substantial damage NTSB CHI79FEC37Accident · Serious injuriesClosedSchleicher AS-K13 · Adrian, MIJul 22, 1979 · N9180 · Substantial damage NTSB CHI79FEC36Accident · Minor injuriesClosedPiper PA-28 · Petersburg, MIJul 22, 1979 · N40923 · Destroyed NTSB CHI79FA059Accident · 2 fatalClosedPiper PA-22 · Pellston, MIJul 21, 1979 · N5809D · Destroyed NTSB CHI79DEC38Accident · No injuriesClosedBeech D-55 · Troy, MIJul 18, 1979 · N6288V · Substantial damage NTSB UNK79X0113Accident · Minor injuriesClosedGrum-Amer AA-5 · Au Gres, MIJul 15, 1979 · N7104L · Destroyed NTSB CHI79FEM29Accident · 2 fatalClosedSmith Sport Aire · Elk Rapids, MIJul 15, 1979 · N6171U · Destroyed NTSB CHI79FEM28Accident · No injuriesClosedCessna 172 · Hudsonville, MIJul 11, 1979 · N500TC · Substantial damage NTSB CHI79DEC35Accident · No injuriesClosedCessna 182 · Flushing, MIJul 11, 1979 · N9108G · Substantial damage NTSB CHI79FEM27Accident · Serious injuriesClosedAeronca 7AC · Spring Lake, MIJul 8, 1979 · N85092 · Substantial damage NTSB CHI79FEM25Accident · Minor injuriesClosedBellanca 7GCAA · West Branch, MIJul 7, 1979 · N31252 · Substantial damage NTSB CHI79DEM24Accident · No injuriesClosedCessna 150M · St. Charles, MIJun 28, 1979 · N66688 · Substantial damage NTSB CHI79FEM23Accident · No injuriesClosedEnstrom F-28A · Albion, MIJun 24, 1979 · N4883 · Substantial damage NTSB CHI79FEC32Accident · No injuriesClosedHughes 269A · Pontiac, MIJun 24, 1979 · N8863F · Substantial damage NTSB CHI79FEC31Accident · No injuriesClosedPiper PA-22 · Pontiac, MIJun 24, 1979 · N6817B · Substantial damage NTSB CHI79FEC34Accident · No injuriesClosedBellanca 7ECA · Owossow, MIJun 23, 1979 · N5529K · Substantial damage NTSB CHI79DEC33Accident · Serious injuriesClosedCessna 150M · Utica, MIJun 15, 1979 · N66427 · Substantial damage NTSB CHI79FEM22Accident · No injuriesClosedPiper PA-22 · Lowell, MIJun 13, 1979 · N7429D · Substantial damage NTSB CHI79DEC30Accident · No injuriesClosedEiriavion PIK-20 · Manchester, MIJun 9, 1979 · N3019M · Substantial damage NTSB CHI79FA051Accident · 1 fatalClosedBeech 24R · Traverse City, MIJun 4, 1979 · N6561R · Destroyed NTSB CHI79FEC29Accident · Minor injuriesClosedCessna 150 · Napoleon, MIJun 3, 1979 · N9101U · Substantial damage NTSB CHI79FEC28Accident · Serious injuriesClosedPiper J3L · Napoleon, MIJun 3, 1979 · N26769 · Destroyed NTSB CHI79FEC27Accident · No injuriesClosedCessna TR182 · Monroe, MIMay 28, 1979 · N4731R · Substantial damage