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 CHI76FEC63Accident · No injuriesClosedPiper PA-32 · Romeo, MISep 12, 1976 · N3895W · Substantial damage NTSB CHI76FEC61Accident · Minor injuriesClosedAeronca 7AC · Owosso, MISep 12, 1976 · N85749 · Substantial damage NTSB CHI76FET51Accident · Minor injuriesClosedPiper J3C-65 · Dowagiac, MISep 11, 1976 · N87943 · Substantial damage NTSB CHI76FEM59Accident · Minor injuriesClosedPiper PA-22 · Delton, MISep 11, 1976 · N5505Z · Substantial damage NTSB CHI76FEC60Accident · No injuriesClosedBeech V35B · Troy, MISep 7, 1976 · N1861W · Substantial damage NTSB CHI76DEM64Accident · No injuriesClosedOsprey I · Vicksburg, MISep 6, 1976 · N2RC · Substantial damage NTSB CHI76FEM58Accident · No injuriesClosedStinson 108-3 · Cedar Springs, MISep 5, 1976 · N6580M · Substantial damage NTSB CHI76DEM57Accident · No injuriesClosedSchemp SH1 · Lansing, MISep 5, 1976 · N12052 · Substantial damage NTSB CHI76DBM56Accident · No injuriesClosedCessna 150 · Chesaning, MISep 5, 1976 · N16109 · Substantial damage NTSB CHI76FEM62Accident · Minor injuriesClosedPiper PA-28 · Gaylord, MISep 4, 1976 · N98053 · Substantial damage NTSB CHI76FEC59Accident · No injuriesClosedCessna 172M · Pontiac, MISep 4, 1976 · N73566 · Substantial damage NTSB CHI76FEC57Accident · No injuriesClosedCessna 172 · Flint, MIAug 29, 1976 · N8285U · Substantial damage NTSB CHI76FEC58Accident · No injuriesClosedCessna 180 · Salem, MIAug 28, 1976 · N3104D · Substantial damage NTSB CHI76AC087Accident · No injuriesClosedSwearingen SA226 · Detroit, MIAug 24, 1976 · N538S · Substantial damage NTSB CHI76DEC56Accident · No injuriesClosedPiper PA-28 · Mason, MIAug 23, 1976 · N75248 · Substantial damage NTSB CHI76FEM55Accident · No injuriesClosedAero Comdr 500 · Hastings, MIAug 22, 1976 · N8457C · Destroyed NTSB CHI76FEC55Accident · No injuriesClosedGrumman G-164A · Sandusky, MIAug 18, 1976 · N6608 · Substantial damage NTSB CHI76FET49Accident · No injuriesClosedGrumman G-164A · Coldwater, MIAug 17, 1976 · N9722 · Substantial damage NTSB CHI76FEC54Accident · No injuriesClosedPiper PA-28 · Fraser, MIAug 16, 1976 · N56615 · Substantial damage NTSB CHI76FEM54Accident · No injuriesClosedCessna 177RG · Marquette, MIAug 14, 1976 · N1523H · Substantial damage NTSB CHI76FEC53Accident · No injuriesClosedCessna 172 · Ann Arbor, MIAug 8, 1976 · N91961 · Substantial damage NTSB CHI76FEM53Accident · 2 fatalClosedThorp T-18 · Menominee, MIAug 7, 1976 · N12BS · Destroyed NTSB CHI76FEC52Accident · No injuriesClosedCessna 172M · Westland, MIAug 7, 1976 · N1133U · Substantial damage NTSB CHI76FEC51Accident · No injuriesClosedCessna U206F · Owosso, MIJul 24, 1976 · N114KC · Substantial damage NTSB CHI76FEM50Accident · No injuriesClosedCessna 177RG · Muskegon, MIJul 18, 1976 · N2135Q · Substantial damage NTSB CHI76FEM52Accident · No injuriesClosedGrum Amer AA-1B · Bay City, MIJul 17, 1976 · N9904L · Substantial damage NTSB CHI76FEC49Accident · No injuriesClosedCessna 180 · Salem, MIJul 17, 1976 · N1513C · Substantial damage NTSB CHI76FEM51Accident · No injuriesClosedCessna A188B · Hamlin, MIJul 15, 1976 · N9032R · Substantial damage NTSB CHI76FEC50Accident · No injuriesClosedPiper PA-28 · Howell, MIJul 14, 1976 · N4661R · Substantial damage NTSB CHI76AC078Accident · 1 fatalClosedBeech C-45H · Detroit, MIJul 9, 1976 · N34CB · Destroyed NTSB CHI76FEM49Accident · Serious injuriesClosedTaylorcraft BC12-D · Mancelona, MIJul 6, 1976 · N43873 · Substantial damage NTSB CHI76FEC48Accident · No injuriesClosedCessna 210 · Ypsilanti, MIJun 26, 1976 · N5874F · Substantial damage NTSB CHI76DEM48Accident · No injuriesClosedPiper PA-28 · Freeland, MIJun 25, 1976 · N40715 · Substantial damage NTSB CHI76FEM47Accident · No injuriesClosedLuscombe 8A · Fruitport, MIJun 22, 1976 · N45589 · Substantial damage NTSB CHI76FET40Accident · 1 fatalClosedBellanca 8KCAB · Galien, MIJun 19, 1976 · N53803 · Destroyed NTSB CHI76AC081Accident · 2 fatalClosedPiper PA-22 · Gadwin, MIJun 18, 1976 · N2227A · Destroyed NTSB CHI76FEC47Accident · Minor injuriesClosedEL Tomcat MK-5A · Blissfield, MIJun 16, 1976 · N9043T · Destroyed NTSB CHI76AC070Accident · 1 fatalClosedGrum Amer AA-5 · Crystal Falls, MIJun 12, 1976 · N9696U · Destroyed NTSB CHI76AC069Accident · Serious injuriesClosedPiper PA-32 · Charlevoix, MIJun 12, 1976 · N55573 · Destroyed NTSB CHI76FEC46Accident · No injuriesClosedBeech 95-C55 · Marine City, MIJun 8, 1976 · N2959M · Substantial damage NTSB CHI76DEM46Accident · No injuriesClosedSchreder HP14 · Plainwell, MIJun 6, 1976 · N109R · Substantial damage NTSB CHI76FEM45Accident · No injuriesClosedPiper PA-24 · St James, MIJun 5, 1976 · N7043P · Substantial damage NTSB CHI76FEC45Accident · No injuriesClosedPiper PA-30 · S Lyon, MIJun 3, 1976 · N8173Y · Substantial damage NTSB CHI76FGP32Accident · No injuriesClosedEnstrom F-28A · Menominee, MIJun 2, 1976 · N9552 · Substantial damage NTSB CHI76FEM14Accident · No injuriesClosedCallair A-9 · Hart, MIJun 2, 1976 · N47061 · Substantial damage NTSB CHI76FEC43Accident · No injuriesClosedCessna 172H · Flushing, MIMay 27, 1976 · N2673L · Substantial damage NTSB CHI76FEM43Accident · No injuriesClosedCessna 172 · Alpena, MIMay 25, 1976 · N8553U · Substantial damage NTSB CHI76FEC41Accident · No injuriesClosedNavion G · Brighton, MIMay 22, 1976 · N2450T · Substantial damage NTSB CHI76FEC42Accident · No injuriesClosedStinson 108-1 · Pontiac, MIMay 21, 1976 · N8300K · Substantial damage NTSB CHI76FET34Accident · Minor injuriesClosedCessna 188B · Union, MIMay 20, 1976 · N9031G · Substantial damage