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 CHI78FEC14Accident · No injuriesClosedCessna 152 · Fraser, MIFeb 6, 1978 · N24204 · Substantial damage NTSB CHI78FEC13Accident · No injuriesClosedPiper PA-23 · Troy, MIFeb 6, 1978 · N6704Y · Destroyed NTSB CHI79FA019Accident · 1 fatalClosedCessna 150M · Big Bay Denoc, MIFeb 4, 1978 · C-GYEF · Destroyed NTSB CHI78FEC12Accident · Minor injuriesClosedLuscombe 8A · Salem, MIFeb 4, 1978 · N71531 · Substantial damage NTSB CHI78FEC11Accident · No injuriesClosedCessna 310 · Detroit, MIFeb 2, 1978 · N310JJ · Substantial damage NTSB CHI78FA018Accident · 1 fatalClosedCessna 152 · Ypsilanti, MIJan 31, 1978 · N757PQ · Destroyed NTSB CHI78FEM09Accident · No injuriesClosedBeech 58 · Freeland, MIJan 28, 1978 · N232LK · Substantial damage NTSB CHI78FET13Accident · No injuriesClosedCessna A185F · Berrien Spring, MIJan 24, 1978 · N1344Q · Substantial damage NTSB CHI78FEM08Accident · 1 fatalClosedCessna 150 · Millersburg, MIJan 21, 1978 · N8284U · Destroyed NTSB CHI78FET07Accident · Minor injuriesClosedMooney M20C · Coloma, MIJan 2, 1978 · N5776Q · Substantial damage NTSB CHI78DEM07Accident · No injuriesClosedCessna 150 · Crystal Falls, MIDec 26, 1977 · N7966G · Substantial damage NTSB CHI78FEM06Accident · No injuriesClosedCessna 177 · Birch Run, MIDec 16, 1977 · N30275 · Substantial damage NTSB CHI78DEC09Accident · No injuriesClosedPiper PA-28 · Marine City, MIDec 11, 1977 · N4458T · Substantial damage NTSB CHI78FEC08Accident · Serious injuriesClosedBell 47J2A · Plymouth, MIDec 3, 1977 · N1190W · Destroyed NTSB CHI78FEC07Accident · No injuriesClosedCessna 150G · Fowlerville, MIDec 3, 1977 · N3166X · Substantial damage NTSB CHI78FEM05Accident · No injuriesClosedCessna 310P · Saginaw, MIDec 1, 1977 · N310AW · Substantial damage NTSB CHI78FET02Accident · No injuriesClosedPiper PA-24 · Niles, MINov 24, 1977 · N5047P · Substantial damage NTSB CHI78FEM03Accident · Serious injuriesClosedCessna 172M · Mt Pleasant, MINov 6, 1977 · N4435Q · Substantial damage NTSB CHI78FEM02Accident · No injuriesClosedErco 415-C · Beaverton, MINov 3, 1977 · N87046 · Substantial damage NTSB CHI78FEC05Accident · No injuriesClosedCessna 140 · W.Bloomfield, MINov 3, 1977 · N2229N · Substantial damage NTSB CHI78FEC04Accident · No injuriesClosedAero Comdr 100 · Fraser, MINov 3, 1977 · N3697X · Substantial damage NTSB CHI78FEM04Accident · No injuriesClosedPiper PA-28 · Grand Ledge, MIOct 30, 1977 · N44006 · Substantial damage NTSB CHI78FEM01Accident · Minor injuriesClosedCessna 170B · Bath, MIOct 28, 1977 · N2524C · Substantial damage NTSB CHI78DEC06Accident · No injuriesClosedCessna 182 · Grosse Ile, MIOct 28, 1977 · N2675R · Substantial damage NTSB CHI78DEC03Accident · No injuriesClosedGrum Amer AA-5A · Ann Arbor, MIOct 28, 1977 · N766MF · Substantial damage NTSB CHI78FEC02Accident · Minor injuriesClosedCessna 172H · Romulus, MIOct 27, 1977 · N2791L · Destroyed NTSB CHI78FA002Accident · No injuriesClosedSikorsky S-58E · Flat Rock, MIOct 16, 1977 · N99275 · Destroyed NTSB CHI78DEC01Accident · Minor injuriesClosedPiper PA-28 · Grosse Ile, MIOct 15, 1977 · N7505W · Substantial damage NTSB CHI77FA075Accident · No injuriesClosedN.American 265 · Detroit, MISep 30, 1977 · N8NR · Substantial damage NTSB CHI77FEM43Accident · No injuriesClosedHiller UH-12B · Carrollton, MISep 26, 1977 · N94735 · Destroyed NTSB CHI77FEC48Accident · 1 fatalClosedPiper PA-28 · Romeo, MISep 24, 1977 · N5194S · Destroyed NTSB CHI78FET35Accident · 1 fatalClosedPiper PA-18 · Benton Harbor, MISep 18, 1977 · N82328 · Substantial damage NTSB CHI77FEC47Accident · Minor injuriesClosedBell 47B3 · Lake Orion, MISep 18, 1977 · N1575 · Substantial damage NTSB CHI77FEM42Accident · Serious injuriesClosedBenson Gyro · Montague, MISep 11, 1977 · NONE · Substantial damage NTSB CHI77FEC44Accident · No injuriesClosedWallis 3 · Plymouth, MISep 11, 1977 · N65022 · Substantial damage NTSB CHI77FET36Accident · No injuriesClosedPiper PA-28 · Coldwater, MISep 10, 1977 · N4379X · Substantial damage NTSB CHI77FEC43Accident · Serious injuriesClosedCessna 182 · Gregory, MISep 10, 1977 · N6054B · Substantial damage NTSB CHI77DEC46Accident · No injuriesClosedPiper PA-28 · Fraser, MISep 10, 1977 · N7080F · Substantial damage NTSB CHI77FEM39Accident · 1 fatalClosedCessna 182Q · East Tawas, MISep 4, 1977 · N444SP · No damage NTSB CHI77FEM40Accident · Serious injuriesClosedPiper PA-28 · Kalamazoo, MISep 3, 1977 · N15060 · Substantial damage NTSB CHI77DEM41Accident · No injuriesClosedCessna 172M · Pleasant, MISep 1, 1977 · N30278 · Substantial damage NTSB CHI77FA070Accident · Minor injuriesClosedBeech C-45H · Ypsilanti, MIAug 31, 1977 · N125TF · Destroyed NTSB CHI77FEM38Accident · No injuriesClosedCessna 170A · Cedar Springs, MIAug 29, 1977 · N5137B · Substantial damage NTSB CHI77FEC42Accident · No injuriesClosedErco 415-C · Unionville, MIAug 28, 1977 · N99014 · Substantial damage NTSB CHI77FA068Accident · 1 fatalClosedCessna 172N · Salem, MIAug 22, 1977 · N75810 · Destroyed NTSB CHI78FEC41Accident · Minor injuriesClosedPitts S1C · Clinton, MIAug 20, 1977 · N24144 · Substantial damage NTSB CHI77FA067Accident · 4 fatalClosedFairchild F24 · Cedar, MIAug 18, 1977 · N81225 · Destroyed NTSB CHI77FET32Accident · No injuriesClosedGrumman G-44A · Cassopolis, MIAug 10, 1977 · N1629H · Substantial damage NTSB CHI77FEC36Accident · No injuriesClosedBede BD-4 · Detroit, MIAug 4, 1977 · N375JK · Substantial damage NTSB CHI77FA061Accident · 1 fatalClosedCessna 172F · Grand Rapids, MIJul 30, 1977 · N5606R · Destroyed