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 CHI75FEC12Accident · Serious injuriesClosedPitts S-1S · Pontiac, MISep 1, 1974 · N161Y · Substantial damage NTSB CHI75DEM07Accident · No injuriesClosedChampion 7ECA · Linwood, MIAug 24, 1974 · N5164T · Substantial damage NTSB CHI75AC020Accident · 2 fatalClosedMooney M20F · Manistique, MIAug 22, 1974 · N6438Q · Destroyed NTSB CHI75FEC10Accident · No injuriesClosedPiper J3C · Fair Haven, MIAug 20, 1974 · N35670 · Substantial damage NTSB CHI75FEC09Accident · No injuriesClosedCessna 172 · Detroit, MIAug 19, 1974 · N1744F · Substantial damage NTSB CHI75DEM08Accident · Minor injuriesClosedCessna 177A · South Branch, MIAug 19, 1974 · N30563 · Substantial damage NTSB CHI75FEC11Accident · No injuriesClosedTaylorcraft BC12-D · Durand, MIAug 18, 1974 · N96279 · Substantial damage NTSB CHI75FEC08Accident · Minor injuriesClosedBellanca 7GCAA · Clio, MIAug 14, 1974 · N8362V · Destroyed NTSB CHI75DEM05Accident · No injuriesClosedCessna 177 · Dewitt, MIAug 14, 1974 · N3262T · Substantial damage NTSB CHI75FEM04Accident · No injuriesClosedCessna 150 · Muskegon, MIAug 13, 1974 · N4501U · Substantial damage NTSB CHI75DEM06Accident · No injuriesClosedCessna 172M · Harrison, MIAug 10, 1974 · N13387 · Substantial damage NTSB CHI75AC014Accident · No injuriesClosedBeech D18S · Detroit, MIAug 7, 1974 · N35CB · Destroyed NTSB CHI75FEC07Accident · No injuriesClosedStinson 108 · Dansville, MIJul 29, 1974 · N9805K · Substantial damage NTSB CHI75FEM02Accident · No injuriesClosedEnstrom F-28A · Walker, MIJul 26, 1974 · N9229 · Substantial damage NTSB CHI75DEC06Accident · No injuriesClosedPiper PA-24 · Flushing, MIJul 26, 1974 · N7605P · Substantial damage NTSB CHI75FEC05Accident · No injuriesClosedTaylorcraft BL-65 · Mason, MIJul 21, 1974 · N24459 · Substantial damage NTSB CHI75AC009Accident · Minor injuriesClosedBell 47J-2A · Detroit, MIJul 18, 1974 · N8525F · Destroyed NTSB CHI75DEM03Accident · No injuriesClosedAeronca S65-CA · Cheboygan, MIJul 14, 1974 · N31901 · Substantial damage NTSB CHI75DEC03Accident · No injuriesClosedCessna 150L · Onsted, MIJul 11, 1974 · N18022 · Substantial damage NTSB CHI75DEM01Accident · No injuriesClosedSchemp SHI · Frankfort, MIJul 7, 1974 · N415M · Substantial damage NTSB CHI75AC002Accident · 1 fatalClosedPiper PA-23 · Willis, MIJul 5, 1974 · N1402P · Destroyed NTSB CHI75FET01Accident · Minor injuriesClosedTeenie Two TT1 · Watervliet, MIJul 4, 1974 · N4027 · Substantial damage NTSB CHI75FEC04Accident · No injuriesClosedBeech D18 · Utica, MIJul 4, 1974 · N1111D · Substantial damage NTSB CHI75DEC01Accident · No injuriesClosedVolmer Sprtmn · W Bloomfield, MIJul 3, 1974 · N7742G · Destroyed NTSB CHI75AC001Accident · 1 fatalClosedBeech H18 · Iron Mtn, MIJul 3, 1974 · N73FA · Destroyed NTSB CHI75FEC02Accident · No injuriesClosedPiper PA-31 · Marine City, MIJul 1, 1974 · N2WM · Substantial damage NTSB CHI74DEM69Accident · No injuriesClosedChampion 7GCAA · Frankfort, MIJun 30, 1974 · N8371V · Substantial damage NTSB CHI74DEM68Accident · 2 fatalClosedCougar 1 · Manistee, MIJun 30, 1974 · N11717 · Destroyed NTSB CHI74FEC52Accident · Minor injuriesClosedCessna 150 · Port Huron, MIJun 27, 1974 · N6608G · Destroyed NTSB CHI74AC099Accident · 2 fatalClosedBeech D18S · Detroit, MIJun 27, 1974 · N3616B · 2 aircraft · Substantial damage NTSB CHI74FEM67Accident · No injuriesClosedPiper PA-30 · Freeland, MIJun 26, 1974 · N7745Y · Substantial damage NTSB CHI74FEC51Accident · 1 fatalClosedCessna U206 · Otisville, MIJun 22, 1974 · N3855G · Substantial damage NTSB CHI74FEC50Accident · Serious injuriesClosedPiper PA-28 · Troy, MIJun 21, 1974 · N8744W · Substantial damage NTSB CHI74FEM66Accident · No injuriesClosedCessna 310G · Cadillac, MIJun 20, 1974 · N2906R · Substantial damage NTSB CHI74DEC35Accident · No injuriesClosedPiper PA-28 · Marlette, MIJun 13, 1974 · N4693R · Substantial damage NTSB CHI74FET21Accident · Minor injuriesClosedGrumman G-164 · Sodus, MIJun 4, 1974 · N646Y · Destroyed NTSB CHI74FEC48Accident · Minor injuriesClosedPiper PA-28 · Belleville, MIJun 3, 1974 · N5404W · Destroyed NTSB CHI74FEM65Accident · Serious injuriesClosedBellanca 7GCBC · Otsego, MIJun 2, 1974 · N86624 · Destroyed NTSB CHI74FEC47Accident · Serious injuriesClosedAero Comdr 100 · Erie, MIJun 1, 1974 · N3787X · Substantial damage NTSB CHI74DEM64Accident · No injuriesClosedCessna 180A · Steuben, MIJun 1, 1974 · N5212D · Substantial damage NTSB CHI74FEM63Accident · No injuriesClosedPiper PA-25 · Hart, MIMay 30, 1974 · N4864Y · Destroyed NTSB CHI74FEM62Accident · No injuriesClosedEL Tomcat I · Belding, MIMay 29, 1974 · N73872 · Substantial damage NTSB CHI74AC094Accident · 3 fatalClosedPiper PA-28 · L'Anse, MIMay 29, 1974 · N6584J · Destroyed NTSB CHI74FEM61Accident · No injuriesClosedCessna 177 · Gaylord, MIMay 26, 1974 · N2242Y · Substantial damage NTSB CHI74FEC46Accident · 1 fatalClosedSchreder HP-11A · Adrian, MIMay 25, 1974 · N17612 · Destroyed NTSB CHI74FEC44Accident · No injuriesClosedPiper PA-28R · Mt Morris, MIMay 15, 1974 · N2337T · Substantial damage NTSB CHI74DEC45Accident · No injuriesClosedCessna 150E · Lincoln, MIMay 12, 1974 · N3049J · Substantial damage NTSB CHI74DEC43Accident · No injuriesClosedCessna 172 · Goodells, MIMay 5, 1974 · N8584V · Substantial damage NTSB CHI74AC086Accident · 4 fatalClosedPiper PA-28R · Freeland, MIMay 5, 1974 · N56611 · Destroyed NTSB CHI74FEM60Accident · No injuriesClosedN.American Navion · Central Lake, MIMay 2, 1974 · N8542H · Substantial damage