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 CHI80DEC14Accident · No injuriesClosedCessna 172 · Pontiac, MIApr 19, 1980 · N737UT · Substantial damage NTSB CHI80IA035Incident · No injuriesClosedAvions Mrcl 20 · Battle Creek, MIApr 16, 1980 · N1047T · Minor damage NTSB CHI80FEM22Accident · No injuriesClosedPiper PA-38 · Saginaw, MIApr 16, 1980 · N2413F · Substantial damage NTSB CHI80FEM21Accident · No injuriesClosedCessna 150M · Allegan, MIApr 1, 1980 · N714CB · Substantial damage NTSB CHI80FEC13Accident · Minor injuriesClosedPiper PA-28 · Brighton, MIMar 22, 1980 · N1462T · Substantial damage NTSB CHI80FA031Accident · 3 fatalClosedCessna 172K · Manistee, MIMar 19, 1980 · N4692K · Destroyed NTSB CHI80DEM19Accident · No injuriesClosedStinson 108-2 · Marquette, MIMar 16, 1980 · N8563K · Substantial damage NTSB CHI80DEM20Accident · No injuriesClosedPiper PA-28 · Harrison, MIMar 15, 1980 · N6839W · Substantial damage NTSB CHI80FEM17Accident · No injuriesClosedCessna 150M · Traverse City, MIMar 7, 1980 · N45181 · Substantial damage NTSB CHI80DEC12Accident · No injuriesClosedCessna 182M · Bay Port, MIMar 3, 1980 · N71162 · Substantial damage NTSB CHI80FEM16Accident · No injuriesClosedCessna 172N · Midland, MIMar 2, 1980 · N737GG · Substantial damage NTSB CHI80FET10Accident · No injuriesClosedCessna 402B · Dowagiac, MIFeb 28, 1980 · N4619N · Substantial damage NTSB CHI80FET08Accident · No injuriesClosedCessna 152 · Three Oaks, MIFeb 13, 1980 · N4903H · Substantial damage NTSB CHI80FEM14Accident · Serious injuriesClosedPiper PA32RT · Ironwood, MIFeb 10, 1980 · N9636C · Destroyed NTSB CHI80DEC11Accident · Minor injuriesClosedTaylorcraft DCO-65 · Brighton, MIFeb 7, 1980 · N47867 · Substantial damage NTSB CHI80FET07Accident · Minor injuriesClosedCessna 152 · Dowagiac, MIFeb 4, 1980 · N4746B · Substantial damage NTSB CHI80DEM15Accident · Minor injuriesClosedCessna 180 · Lake Leelanau, MIFeb 2, 1980 · N2406C · Substantial damage NTSB CHI80FEC10Accident · No injuriesClosedCessna 172N · Salem, MIJan 25, 1980 · N738ZZ · Substantial damage NTSB CHI80FEM13Accident · No injuriesClosedCessna 185 · Allegan, MIJan 23, 1980 · N80520 · Substantial damage NTSB CHI80FEC09Accident · No injuriesClosedBeech V35 · Detroit, MIJan 14, 1980 · N2060W · Substantial damage NTSB CHI80FEM12Accident · No injuriesClosedPiper PA-30 · Lansing, MIJan 9, 1980 · N7166Y · Substantial damage NTSB CHI80FA020Accident · 3 fatalClosedPiper PA-28 · Royal Oak, MIDec 30, 1979 · N4512P · Destroyed NTSB CHI80FEC08Accident · No injuriesClosedCessna 152 · Frasher, MIDec 27, 1979 · N89969 · Substantial damage NTSB CHI80FEM09Accident · No injuriesClosedCessna 150H · Hesperia, MIDec 26, 1979 · N6746S · Substantial damage NTSB CHI80DEM10Accident · Minor injuriesClosedPiper PA-20 · Ithaca, MIDec 24, 1979 · N2807Z · Substantial damage NTSB CHI80FEC07Accident · No injuriesClosedPiper PA-28 · Owosso, MIDec 21, 1979 · N36700 · Substantial damage NTSB CHI80FEM08Accident · Minor injuriesClosedRyan ST-3KR · Holland, MIDec 19, 1979 · N47433 · Substantial damage NTSB CHI80DEM11Accident · No injuriesClosedGrumman AA-1C · Marion, MIDec 15, 1979 · N39008 · Destroyed NTSB CHI80FEC04Accident · No injuriesClosedCessna 172F · Detroit, MIDec 5, 1979 · N8633U · Substantial damage NTSB CHI80DEC05Accident · No injuriesClosedCessna 140 · Romeo, MIDec 3, 1979 · N1788N · Substantial damage NTSB CHI80FEE09Accident · No injuriesClosedCessna 182J · Lansing, MINov 30, 1979 · N3059F · Substantial damage NTSB CHI80FEM07Accident · No injuriesClosedSpezio CB-2 · Marne, MINov 25, 1979 · N18822 · Substantial damage NTSB CHI80DEM05Accident · No injuriesClosedCessna 150D · Niron Mountain, MINov 7, 1979 · CG-CDR · Substantial damage NTSB CHI80FEC02Accident · No injuriesClosedCessna 152 · Jackson, MINov 6, 1979 · N68246 · Substantial damage NTSB CHI80DEC03Accident · No injuriesClosedCessna 150M · Napoleon, MINov 2, 1979 · N6100K · Substantial damage NTSB CHI80DA008Accident · 1 fatalClosedPiper PA-28 · Plainwell, MIOct 29, 1979 · N4437J · 2 aircraft · Destroyed NTSB CHI80FEM04Accident · Serious injuriesClosedPiper PA-12 · Long Rapids, MIOct 21, 1979 · N98967 · Substantial damage NTSB CHI80FEM03Accident · No injuriesClosedPiper PA-32R · Manistee, MIOct 20, 1979 · N39591 · Substantial damage NTSB CHI79FEC59Accident · 1 fatalClosedCessna 120 · Vassar, MIOct 20, 1979 · N2854N · Destroyed NTSB CHI80FEM06Accident · No injuriesClosedCessna 402A · Lansing, MIOct 17, 1979 · N7809Q · Substantial damage NTSB CHI80FAMS1Accident · 1 fatalClosedPiper PA-24 · Ganges, MIOct 10, 1979 · N8437P · Destroyed NTSB CHI80FEM02Accident · No injuriesClosedErco 415-C · Cheboygan, MIOct 9, 1979 · N2150H · Substantial damage NTSB CHI79FEM01Accident · 1 fatalClosedCessna 177 · Baraga, MIOct 9, 1979 · N3331T · Destroyed NTSB CHI80FET01Accident · No injuriesClosedCessna 310G · Benton Harbor, MIOct 2, 1979 · N20PC · Substantial damage NTSB CHI80FEM01Accident · Minor injuriesClosedCessna 172K · Byron Center, MIOct 1, 1979 · N84660 · Substantial damage NTSB CHI79FEM40Accident · Minor injuriesClosedCessna 182F · Gladwin, MISep 28, 1979 · N3564Y · Substantial damage NTSB CHI79FEC58Accident · No injuriesClosedCessna 182K · Sandusky, MISep 28, 1979 · N2615R · Substantial damage NTSB CHI79FEC57Accident · 2 fatalClosedBreezy RLU-1 · Frazer, MISep 22, 1979 · N9369 · Destroyed NTSB CHI80FEC56|CHI79FEC56Accident · No injuriesClosedCessna 182 · Pontiac, MISep 15, 1979 · N1930X · 2 aircraft · Substantial damage NTSB CHI79FA076Accident · 4 fatalClosedBeech C-45H · Hastings, MISep 15, 1979 · N600NA · Destroyed