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 CHI74DEM59Accident · Minor injuriesClosedCessna 120 · Grand Rapids, MIMay 1, 1974 · N2386N · Substantial damage NTSB CHI74DEM57Accident · Minor injuriesClosedBell 47G · Hart, MIMay 1, 1974 · N4734S · Substantial damage NTSB CHI74FEM55Accident · Minor injuriesClosedAeronca 11AC · Grand Rapids, MIApr 27, 1974 · N9572E · Substantial damage NTSB CHI74FEC42Accident · Minor injuriesClosedPiper PA-22 · Cambridge Jt, MIApr 27, 1974 · N2240A · Substantial damage NTSB CHI74FEC40Accident · No injuriesClosedHughes 269A-1 · Imlay City, MIApr 27, 1974 · N8902F · Substantial damage NTSB CHI74FEC41Accident · No injuriesClosedNord Stampe SV4C · Grosse Ile, MIApr 26, 1974 · N14428 · Substantial damage NTSB CHI74DEM58Accident · No injuriesClosedChampion 7FC · Lansing, MIApr 26, 1974 · N7539E · Substantial damage NTSB CHI74FEC39Accident · Minor injuriesClosedSmith EOS-1 · Pontiac, MIApr 25, 1974 · N10AE · Substantial damage NTSB CHI74DEM56Accident · No injuriesClosedErco 415-D · South Haven, MIApr 20, 1974 · N2650H · Substantial damage NTSB CHI74DEC38Accident · No injuriesClosedCessna 150 · Mason, MIApr 20, 1974 · N6561G · Substantial damage NTSB CHI74FEC37Accident · Serious injuriesClosedCessna 120 · Flushing, MIApr 19, 1974 · N76554 · Substantial damage NTSB CHI74DEM54Accident · No injuriesClosedCessna 150 · Lansing, MIApr 17, 1974 · N156KA · Substantial damage NTSB CHI74FET18Accident · Minor injuriesClosedTeenie TWO · Watervliet, MIApr 16, 1974 · N4306 · Substantial damage NTSB CHI74DEM53Accident · No injuriesClosedPiper PA-24 · Lawrence, MIApr 13, 1974 · N6883P · Destroyed NTSB CHI74FEC36Accident · Minor injuriesClosedBell 47G5 · Flint, MIApr 12, 1974 · N8142J · Substantial damage NTSB CHI74DEC34Accident · No injuriesClosedLuscombe 8A · Romeo, MIApr 6, 1974 · N71910 · Substantial damage NTSB CHI74FEM51Accident · No injuriesClosedCessna 500 · Menominee, MIApr 3, 1974 · N11A · Substantial damage NTSB CHI74FET20Accident · No injuriesClosedCessna 182A · Berrien Spgs, MIApr 2, 1974 · N6325B · Substantial damage NTSB CHI74DEM50Accident · No injuriesClosedLuscombe 8A · White Cloud, MIMar 31, 1974 · N45475 · Substantial damage NTSB CHI74DEM49Accident · No injuriesClosedCessna 310I · Battle Creek, MIMar 28, 1974 · N8155M · Substantial damage NTSB CHI74DEM52Accident · No injuriesClosedBeech A35 · Cheboygan, MIMar 27, 1974 · N8758A · Substantial damage NTSB CHI74DEM48Accident · No injuriesClosedCessna 170B · Allegan, MIMar 25, 1974 · N8185A · Substantial damage NTSB CHI74DEM47Accident · No injuriesClosedCessna 150 · Mt Pleasant, MIMar 25, 1974 · N5506G · Substantial damage NTSB CHI74FET17Accident · No injuriesClosedCessna 172A · Vandalia, MIMar 23, 1974 · N7478T · Substantial damage NTSB CHI74DEM42Accident · Minor injuriesClosedStinson 108 · Grant, MIMar 19, 1974 · N97226 · Substantial damage NTSB CHI74FEC33Accident · Serious injuriesClosedPiper PA-28 · Marine City, MIMar 16, 1974 · N6037W · Substantial damage NTSB CHI74AC077Accident · 1 fatalClosedPiper PA-22 · Port Huron, MIMar 14, 1974 · N901A · Minor damage NTSB CHI74AC075Accident · No injuriesClosedCessna 172K · Clinton, MIMar 10, 1974 · N74496 · No damage NTSB CHI74AC074Accident · No injuriesClosedBeech 56TC · Grand Rapids, MIMar 6, 1974 · N5465U · Substantial damage NTSB CHI74AC073Accident · 4 fatalClosedCessna P206C · Coral, MIMar 3, 1974 · N8693Z · Destroyed NTSB CHI74FEM45Accident · No injuriesClosedPiper PA-28 · Holland, MIFeb 24, 1974 · N4625R · Substantial damage NTSB CHI74DEM46Accident · No injuriesClosedAmer Avco AA1-1A · Laingsburg, MIFeb 18, 1974 · N6383L · Substantial damage NTSB CHI74AC071Accident · No injuriesClosedCessna 402 · St.Ignace, MIFeb 18, 1974 · N3295Q · Substantial damage NTSB CHI74FEM41Accident · No injuriesClosedPiper PA-24 · Bay City, MIFeb 17, 1974 · N7805P · Substantial damage NTSB CHI74FEC31Accident · No injuriesClosedBeech V35 · Romeo, MIFeb 13, 1974 · N855DS · Substantial damage NTSB CHI74AC069Accident · 2 fatalClosedBeech 95-B55 · Grand Rapids, MIFeb 13, 1974 · N5945S · Destroyed NTSB CHI74FEC30Accident · No injuriesClosedCessna 421B · Flint, MIFeb 12, 1974 · N5998M · Substantial damage NTSB CHI74DEC32Accident · No injuriesClosedPiper PA-28 · Almont, MIFeb 12, 1974 · N6820W · Substantial damage NTSB CHI74DEM43Accident · No injuriesClosedPiper PA-28 · Linwood, MIFeb 9, 1974 · N7028W · Substantial damage NTSB CHI74AC068Accident · No injuriesClosedBeech C-45H · South Haven, MIFeb 9, 1974 · N9929Z · Substantial damage NTSB CHI74FEM38Accident · No injuriesClosedPiper PA-32 · Pellston, MIFeb 5, 1974 · N3911W · Substantial damage NTSB CHI74DEM39Accident · No injuriesClosedPiper PA-28 · Charlotte, MIFeb 4, 1974 · N3648K · Substantial damage NTSB CHI74DEM40Accident · No injuriesClosedPiper PA-22 · Trout Lake, MIFeb 3, 1974 · N2473P · Substantial damage NTSB CHI74DEC29Accident · No injuriesClosedCessna 172 · Romeo, MIJan 30, 1974 · N46369 · Substantial damage NTSB CHI74AC065Accident · 3 fatalClosedBeech A35 · Traverse Cty, MIJan 27, 1974 · N9329Y · Destroyed NTSB CHI74DEM37Accident · No injuriesClosedBellanca 7ECA · Holland, MIJan 26, 1974 · N36381 · Substantial damage NTSB CHI74AC064Accident · 2 fatalClosedBeech B55 · Romulus, MIJan 26, 1974 · N1164A · Destroyed NTSB CHI74FEC28Accident · No injuriesClosedCessna 150L · Mason, MIJan 19, 1974 · N16080 · Substantial damage NTSB CHI74FEM36Accident · No injuriesClosedAeronca 11AC · Charlotte, MIJan 12, 1974 · N86078 · Substantial damage NTSB CHI74FEC27Accident · No injuriesClosedPiper PA-31 · Pontiac, MIJan 9, 1974 · N366BC · Substantial damage