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 CHI81DEC19Accident · No injuriesClosedPiper PA-34 · Detroit, MIMar 28, 1981 · N8GC · Substantial damage NTSB CHI81DET05Accident · No injuriesClosedBeech V35B · Sturgis, MIMar 22, 1981 · N1030W · Substantial damage NTSB CHI81FA035Accident · 1 fatalClosedPiper PA-23 · Lowell, MIMar 18, 1981 · N2023P · Destroyed NTSB CHI81DEC18Accident · No injuriesClosedCessna 152 · Pontiac, MIMar 15, 1981 · N4737L · Substantial damage NTSB CHI81DEC17Accident · No injuriesClosedLuscombe 8A · New Hudson, MIMar 7, 1981 · N1244B · Substantial damage NTSB CHI81FEM11Accident · Serious injuriesClosedPiper J3C · Grand Haven, MIMar 4, 1981 · N2083M · Substantial damage NTSB CHI81FEM10Accident · Minor injuriesClosedPiper PA-34 · Manistee, MIMar 3, 1981 · N479T · Destroyed NTSB CHI81FEC16Accident · No injuriesClosedLuscombe 8A · Owosso, MIFeb 26, 1981 · N77876 · Substantial damage NTSB CHI81FA029Accident · 3 fatalClosedPiper PA-31T · Waterford Twp, MIFeb 19, 1981 · N321SS · Destroyed NTSB CHI81DEC13Accident · No injuriesClosedCessna 172N · New Hudson, MIFeb 7, 1981 · N6341D · Substantial damage NTSB CHI81FEM08Accident · No injuriesClosedCessna 152 · Lowell, MIFeb 5, 1981 · N5528M · Substantial damage NTSB CHI81FEC14Accident · No injuriesClosedPiper PA-28 · Howell, MIFeb 5, 1981 · N6899F · No damage NTSB CHI81FEM09Accident · Serious injuriesClosedPiper PA-28R · Houghton, MIFeb 2, 1981 · N4542Q · Destroyed NTSB CHI81FEC11Accident · No injuriesClosedLuscombe 8E · Belleville, MIJan 31, 1981 · N1430B · Substantial damage NTSB CHI81FEC12Accident · Minor injuriesClosedPiper PA-31P · Pontiac, MIJan 28, 1981 · N222EB · Substantial damage NTSB CHI81FEM06Accident · No injuriesClosedPiper PA-20 · Newaygo, MIJan 22, 1981 · N4859A · Substantial damage NTSB CHI81FEM07Accident · Minor injuriesClosedPiper J3C-65 · Atlanta, MIJan 20, 1981 · N6658H · Substantial damage NTSB CHI81DA020Incident · No injuriesClosedNorth Amer 265-80 · Battle Creek, MIJan 16, 1981 · N62 · Minor damage NTSB CHI81FEM05Accident · No injuriesClosedCessna 150 · Midland, MIJan 14, 1981 · N9297U · Substantial damage NTSB CHI81FEC10Accident · No injuriesClosedCessna 310N · Owosso, MIJan 14, 1981 · N174K · Substantial damage NTSB CHI81DA019Accident · No injuriesClosedCessna 402 · Lansing, MIJan 12, 1981 · N18WW · Substantial damage NTSB CHI81DEC09Accident · No injuriesClosedCessna 152 · Howell, MIJan 8, 1981 · N714VW · Substantial damage NTSB CHI81DEC08Accident · No injuriesClosedCessna 152A · Salem, MIJan 3, 1981 · N24764 · Substantial damage NTSB CHI81DAMS2Accident · 5 fatalClosedCessna 421B · Muskegon, MIDec 29, 1980 · N9394A · Destroyed NTSB CHI81FEM04Accident · No injuriesClosedCessna 172N · Pellston, MIDec 24, 1980 · N4800J · Substantial damage NTSB CHI81FEC07Accident · No injuriesClosedPiper PA-32R · Belleville, MIDec 20, 1980 · N5421F · Substantial damage NTSB CHI81FA012Accident · 2 fatalClosedPiper PA-28R · Kalkaska, MIDec 12, 1980 · N559PA · Destroyed NTSB CHI81FEC06Accident · Minor injuriesClosedCessna 421B · Detroit, MINov 26, 1980 · N200SM · Destroyed NTSB CHI81FEC05Accident · Serious injuriesClosedStinson L-5 · New Hudson, MINov 22, 1980 · N57576 · Substantial damage NTSB CHI81FA006Accident · 2 fatalClosedPiper PA-28 · Fremont, MINov 13, 1980 · N7956N · Destroyed NTSB CHI81FEC04Accident · No injuriesClosedCessna 182Q · Britton, MINov 10, 1980 · N96437 · Substantial damage NTSB CHI81FEC03Accident · No injuriesClosedCessna 152 · Hillsdale, MINov 6, 1980 · N7352W · Destroyed NTSB CHI81FA004Accident · 3 fatalClosedCessna 152 · Linden, MINov 2, 1980 · N24552 · 2 aircraft · Destroyed NTSB CHI81FEM03Accident · No injuriesClosedCessna 172M · Lansing, MIOct 31, 1980 · N9019H · Substantial damage NTSB CHI81FEM02Accident · No injuriesClosedCessna 402B · Traverse City, MIOct 30, 1980 · N3AP · Substantial damage NTSB CHI81DEC02Accident · Serious injuriesClosedPiccard AX-6 · Metamora, MIOct 23, 1980 · N2454Z · Substantial damage NTSB CHI81DEC01Accident · No injuriesClosedCessna 152 · Flushing, MIOct 16, 1980 · N24251 · Substantial damage NTSB CHI81FA001Accident · 3 fatalClosedCessna 337H · Waterford, MIOct 14, 1980 · N1333L · 2 aircraft · Destroyed NTSB CHI81FEM01Accident · No injuriesClosedCessna 170A · Lowell, MIOct 1, 1980 · N1724D · Substantial damage NTSB CHI80FEM47Accident · Minor injuriesClosedSkybolt Steen · Rose City, MISep 13, 1980 · N25541 · Destroyed NTSB CHI80FEM46Accident · No injuriesClosedBeech A35 · Lincoln, MISep 13, 1980 · N2744V · Destroyed NTSB CHI80FEC36Accident · No injuriesClosedCessna 150 · Detroit, MISep 12, 1980 · N19332 · Substantial damage NTSB CHI80FEC35Accident · Minor injuriesClosedCessna 182A · Richmond, MISep 7, 1980 · N4949Q · Substantial damage NTSB CHI80FEM45Accident · No injuriesClosedCessna 172L · Chesaning, MISep 6, 1980 · N300AW · Substantial damage NTSB CHI80FEC34Accident · No injuriesClosedCessna 152 · North Adams, MISep 6, 1980 · N25266 · Substantial damage NTSB CHI80DEM43Accident · No injuriesClosedCessna 172 · Lansing, MIAug 31, 1980 · N12136 · Substantial damage NTSB CHI80DEM44Accident · No injuriesClosedHughes 500D · Manistee, MIAug 29, 1980 · N500NC · Substantial damage NTSB CHI80FET28Accident · Serious injuriesClosedPiper J3C-65 · Jones, MIAug 28, 1980 · N6334H · Substantial damage NTSB CHI80FEM48Accident · No injuriesClosedPiper PA-28 · Shelby, MIAug 28, 1980 · N6378C · Substantial damage NTSB CHI80FEC32Accident · Minor injuriesClosedPiper PA-28 · Plymouth, MIAug 27, 1980 · N43406 · Destroyed