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 CHI77FEC18Accident · No injuriesClosedMeyers 200A · Monroe, MIFeb 23, 1977 · N494C · Substantial damage NTSB CHI77FEC17Accident · Serious injuriesClosedPiper PA-28 · Fraser, MIFeb 22, 1977 · N9461W · Destroyed NTSB CHI77FEC15Accident · Serious injuriesClosedCessna 150L · Detroit, MIFeb 21, 1977 · N10900 · Destroyed NTSB CHI77FEM18Accident · No injuriesClosedPiper PA-22 · Alma, MIFeb 20, 1977 · N7449D · Substantial damage NTSB CHI77FEC16Accident · No injuriesClosedCessna 150 · Pontiac, MIFeb 20, 1977 · N5796G · Substantial damage NTSB CHI77FA030Accident · 1 fatalClosedCessna 150J · Carleton, MIFeb 20, 1977 · N51226 · Destroyed NTSB CHI77FEM17Accident · No injuriesClosedCessna 150M · Kalamazoo, MIFeb 17, 1977 · N6068K · Substantial damage NTSB CHI77FEC14Accident · Minor injuriesClosedPiper PA-28 · Owosso, MIFeb 11, 1977 · N6590W · Destroyed NTSB CHI77FEM16Accident · Serious injuriesClosedTaylorcraft DC-65 · N Muskegon, MIFeb 10, 1977 · N36356 · Substantial damage NTSB CHI77DEC12Accident · No injuriesClosedCessna 150 · Romeo, MIFeb 8, 1977 · N9230U · Substantial damage NTSB CHI77FEM15Accident · No injuriesClosedCessna 150 · Kalamazoo, MIFeb 5, 1977 · N6188F · Substantial damage NTSB CHI77DET08Accident · No injuriesClosedPiper PA-24 · Three Rivers, MIFeb 4, 1977 · N9207P · Substantial damage NTSB CHI77FEM14Accident · Minor injuriesClosedPiper J-3 · Steuben, MIJan 30, 1977 · N98761 · Substantial damage NTSB CHI77FEC11Accident · No injuriesClosedCessna 310J · Flint, MIJan 23, 1977 · N3061L · Destroyed NTSB CHI77FEC10Accident · No injuriesClosedBeech A55 · Detroit, MIJan 23, 1977 · N1572S · Substantial damage NTSB CHI77FA022Accident · 2 fatalClosedLear Jet 23 · Flint, MIJan 6, 1977 · N332PC · Destroyed NTSB CHI77FEC08Accident · No injuriesClosedCessna 150 · Pontiac, MIDec 30, 1976 · N10090 · Substantial damage NTSB CHI77FEC07Accident · No injuriesClosedCessna 172 · Detroit, MIDec 29, 1976 · N2791L · Substantial damage NTSB CHI77FA020Accident · 2 fatalClosedCessna 411 · Mccomb Twp, MIDec 29, 1976 · N411EF · Destroyed NTSB CHI77FA016Accident · 1 fatalClosedErco 415-C · Palo, MIDec 19, 1976 · N99258 · Destroyed NTSB CHI77FEM13Accident · No injuriesClosedCessna 421B · Bellaire, MIDec 12, 1976 · N421TC · Substantial damage NTSB CHI77FEM12Accident · Serious injuriesClosedCessna 310 · Saginaw, MINov 28, 1976 · N6931L · Destroyed NTSB CHI77FEC05Accident · Minor injuriesClosedLuscombe 8F · Manchester, MINov 27, 1976 · N1339B · Substantial damage NTSB CHI77FA008Accident · 2 fatalClosedCessna 310P · Muskegon, MINov 26, 1976 · N246BS · Destroyed NTSB CHI77DEC06Accident · No injuriesClosedPiper PA-28 · Hadley, MINov 25, 1976 · N5120W · Substantial damage NTSB CHI77DEC04Accident · No injuriesClosedPiper PA-28 · Utica, MINov 19, 1976 · N2676T · Substantial damage NTSB CHI77FEM10Accident · 1 fatalClosedScorpion 2 · Alston, MINov 16, 1976 · N63301 · Substantial damage NTSB CHI77FA006Accident · 2 fatalClosedPiper PA-31 · Spring Lake, MINov 11, 1976 · N74941 · Destroyed NTSB CHI77FEM09Accident · No injuriesClosedPiper PA-28R · Harbor Springs, MINov 5, 1976 · N3759T · Substantial damage NTSB CHI77FEC03Accident · No injuriesClosedCessna 205 · Utica, MIOct 28, 1976 · N8326Z · Substantial damage NTSB CHI77FEM08Accident · No injuriesClosedCessna 150L · Sparta, MIOct 25, 1976 · N17236 · Destroyed NTSB CHI77FEC02Accident · No injuriesClosedBellanca 17-30 · Flint, MIOct 24, 1976 · N7341V · Substantial damage NTSB CHI77FEC01Accident · No injuriesClosedHughes 369HS · Pickney, MIOct 21, 1976 · N9213F · Substantial damage NTSB CHI77FEM11Accident · No injuriesClosedSwearingen SA26T · Clare, MIOct 20, 1976 · N30W · Substantial damage NTSB CHI77DEC09Incident · No injuriesClosedCessna 172 · Detroit, MIOct 11, 1976 · N1895Y · Minor damage NTSB CHI77FEM06Accident · No injuriesClosedCessna 150 · Lansing, MIOct 3, 1976 · N10747 · Substantial damage NTSB CHI77FEM04Accident · Serious injuriesClosedNavion A · St. James, MIOct 3, 1976 · N4491K · Destroyed NTSB CHI77FEM01Accident · No injuriesClosedJeanies Teenie · Frankfort, MIOct 2, 1976 · N519S · Destroyed NTSB UNK77X0100Accident · Minor injuriesClosedPiper PA-22 · Coral, MIOct 1, 1976 · N3438A · Substantial damage NTSB CHI77FEM05Accident · No injuriesClosedBeech B23 · Ironwood, MIOct 1, 1976 · N721RT · Substantial damage NTSB CHI77FEM03Accident · No injuriesClosedCessna 172 · Watersmeet, MIOct 1, 1976 · N35672 · Substantial damage NTSB CHI77AC095Accident · 2 fatalClosedBeech 95 · L'Anse, MISep 20, 1976 · N2080C · Destroyed NTSB CHI76FEC66Accident · No injuriesClosedPiper PA-28 · New Hudson, MISep 20, 1976 · N3601R · Substantial damage NTSB CHI76FEM61Accident · No injuriesClosedCessna 172M · Gobles, MISep 19, 1976 · N1279U · Substantial damage NTSB CHI76FEC65Accident · Minor injuriesClosedCessna 150H · Willis, MISep 19, 1976 · N50203 · Substantial damage NTSB CHI76DEM60Accident · No injuriesClosedWeilbuilt WB-4 · Thomas City, MISep 19, 1976 · N788 · Destroyed NTSB CHI76FEC64Accident · No injuriesClosedStinson 108-3 · Deckerville, MISep 18, 1976 · N6108M · Substantial damage NTSB CHI76AC091Accident · 6 fatalClosedBeech D55 · Coldwater, MISep 16, 1976 · N8330N · Destroyed NTSB CHI76FEC62Accident · No injuriesClosedPiper PA-28 · Ann Arbor, MISep 13, 1976 · N56619 · Substantial damage NTSB CHI76FEM63Accident · No injuriesClosedBeech D-17S · Mt Pleasant, MISep 12, 1976 · N5400N · Substantial damage