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 CHI79FEC26Accident · Minor injuriesClosedBeech 55 · Fraser, MIMay 25, 1979 · N45235 · Substantial damage NTSB CHI79FEM21Accident · No injuriesClosedBell 47D-1 · Middleville, MIMay 19, 1979 · N64580 · Substantial damage NTSB CHI79DEC23Accident · Serious injuriesClosedCessna 206 · Bad Axe, MIMay 11, 1979 · N5031U · Substantial damage NTSB CHI79FEC25Accident · No injuriesClosedRower Aero Bipe · Sandusky, MIMay 9, 1979 · N3987A · Substantial damage NTSB CHI79FEM20Accident · No injuriesClosedCessna 310 · Traverse City, MIMay 6, 1979 · N639R · Substantial damage NTSB CHI79FEC24Accident · No injuriesClosedCessna 152 · Fraser, MIMay 6, 1979 · N69191 · Substantial damage NTSB CHI79FEC22Accident · Minor injuriesClosedBeech A23A · Fraser, MIMay 6, 1979 · N5955S · Substantial damage NTSB CHI79FEM19Accident · No injuriesClosedCessna 152 · Negaunee, MIApr 18, 1979 · N24993 · Substantial damage NTSB DCA79AA016Accident · Minor injuriesClosedBoeing 727-31 · Saginaw, MIApr 4, 1979 · N840TW · Substantial damage NTSB CHI79FEM18Accident · No injuriesClosedCessna T210L · Grand Rapids, MIApr 3, 1979 · N59132 · Substantial damage NTSB CHI79FA037Accident · 1 fatalClosedPiper PA-30 · Ludington, MIMar 28, 1979 · N77334 · Destroyed NTSB CHI79DEM17Accident · No injuriesClosedCessna 172M · Point Aux Pin, MIMar 28, 1979 · N9929Q · Substantial damage NTSB CHI79FEC21Accident · Minor injuriesClosedCessna T210L · Detroit, MIMar 18, 1979 · N148VM · Substantial damage NTSB CHI79DEC20Accident · Minor injuriesClosedPiper PA-28 · Pontiac, MIMar 17, 1979 · N8879W · Substantial damage NTSB CHI79DA033Accident · 1 fatalClosedCessna 150M · Adrian, MIMar 15, 1979 · N9280U · Destroyed NTSB CHI79FEM15Accident · No injuriesClosedCessna 172G · Grand Rapids, MIMar 14, 1979 · N4432L · Substantial damage NTSB CHI79FEM14Accident · Minor injuriesClosedCessna 150L · Traverse City, MIMar 12, 1979 · N155KA · Substantial damage NTSB CHI79DET20Accident · No injuriesClosedCessna 152 · Berrien Sprgs, MIMar 6, 1979 · N25389 · Substantial damage NTSB CHI79FEM16Accident · No injuriesClosedCessna 421B · Cadillac, MIFeb 28, 1979 · N699DT · Substantial damage NTSB CHI79DEC19Accident · No injuriesClosedPiper PA-38 · Lapeer, MIFeb 27, 1979 · N4342E · Substantial damage NTSB CHI79FEM12Accident · Minor injuriesClosedBell 47-G2 · Newberry, MIFeb 17, 1979 · N2866B · Substantial damage NTSB CHI79DEC16Accident · No injuriesClosedCessna 172H · Linden, MIFeb 17, 1979 · N3894R · Substantial damage NTSB CHI79FEM13Accident · No injuriesClosedCessna 150M · Allegan, MIFeb 9, 1979 · N45491 · Substantial damage NTSB CHI79FEM11Accident · No injuriesClosedCessna 310R · Kalamazoo, MIFeb 7, 1979 · N3413G · Substantial damage NTSB CHI79FEC18Accident · No injuriesClosedForney F-1 · Mason, MIFeb 6, 1979 · N7542C · Substantial damage NTSB CHI79DEC15Accident · No injuriesClosedCessna 150 · Flint, MIFeb 6, 1979 · N21971 · Substantial damage NTSB CHI79DEC13Accident · No injuriesClosedCessna 152 · Owosso, MIFeb 6, 1979 · N48852 · Substantial damage NTSB CHI79FEM10Accident · Minor injuriesClosedPiper PA-24 · Escanaba, MIFeb 3, 1979 · N276P · Substantial damage NTSB CHI79FEC14Accident · No injuriesClosedPiper PA-32 · Sylvan Lake, MIFeb 3, 1979 · N9709C · Substantial damage NTSB CHI79DEC12Accident · No injuriesClosedPiper PA-28 · Mason, MIFeb 3, 1979 · N75078 · Substantial damage NTSB CHI79DEC17Accident · No injuriesClosedVarieze Herzog · Salem, MIJan 29, 1979 · N4WH · Substantial damage NTSB CHI79FEC11Accident · No injuriesClosedGrum Amer AA-5B · Port Huron, MIJan 28, 1979 · N74560 · Substantial damage NTSB DCA79AA007Accident · 6 fatalClosedLear Jet 25D · Detroit, MIJan 19, 1979 · N137GL · Destroyed NTSB CHI79FA025Accident · 4 fatalClosedAerostar 601 · Grand Rapids, MIJan 19, 1979 · N7437S · Destroyed NTSB CHI79FEC10Accident · No injuriesClosedCessna 210 · Ypsilanti, MIJan 18, 1979 · N5883F · Substantial damage NTSB CHI79FEC09Accident · No injuriesClosedCessna 150 · Ann Arbor, MIJan 16, 1979 · N51104 · Substantial damage NTSB CHI79DET13Accident · No injuriesClosedCessna 150M · Three Rivers, MIJan 13, 1979 · N704CG · Substantial damage NTSB CHI79FEM09Accident · No injuriesClosedCessna 172M · Ludington, MIJan 10, 1979 · N19803 · Substantial damage NTSB CHI79FEM08Accident · No injuriesClosedPiper PA-23 · Muskegon Hgts, MIJan 5, 1979 · N5120Y · Substantial damage NTSB CHI79DEC08Accident · No injuriesClosedPiper PA-28R · Napoleon, MIDec 25, 1978 · N33867 · Substantial damage NTSB CHI79FET09Accident · Minor injuriesClosedCessna 150 · Three Oaks, MIDec 15, 1978 · N45597 · Substantial damage NTSB CHI79FEM07Accident · No injuriesClosedCessna 152 · Mt Pleasant, MIDec 12, 1978 · N65472 · Substantial damage NTSB CHI79FEC07Accident · No injuriesClosedBeech B23 · Brighton, MIDec 12, 1978 · N7615R · Substantial damage NTSB CHI79FEM06Accident · No injuriesClosedCessna 150M · Big Rapids, MIDec 10, 1978 · N63276 · Substantial damage NTSB CHI79FEC06Accident · Minor injuriesClosedScorpion II · Romulus, MINov 26, 1978 · N92086 · Substantial damage NTSB CHI79DEC04Accident · Serious injuriesClosedBede BD-4 · Romeo, MINov 18, 1978 · N37RH · Substantial damage NTSB CHI79FEM04Accident · No injuriesClosedMooney M20J · Marshall, MINov 11, 1978 · N201RP · Substantial damage NTSB CHI79FA017Accident · 2 fatalClosedGrumman AA-5 · Norway, MINov 10, 1978 · N7170L · Destroyed NTSB CHI79FEC05Accident · No injuriesClosedBeechcraft D-18S · Flint, MINov 3, 1978 · N80369 · Destroyed NTSB CHI79FEC02Accident · No injuriesClosedMitsubishi MU2B20 · Ypsilanti, MIOct 31, 1978 · N13EW · Substantial damage