Skip to content

NTSB investigations, MN

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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" = 'MN' 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\" = 'MN' 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" = 'MN' 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 MKC74DER50Accident · No injuriesClosedPiper PA-28 · Benson, MNMay 19, 1974 · N8889N · Substantial damage NTSB MKC74DER49Accident · No injuriesClosedPiper PA-24 · Fairmont, MNMay 17, 1974 · N11CG · Substantial damage NTSB MKC74DER48Accident · Minor injuriesClosedCessna 175 · Tintah, MNMay 15, 1974 · N7581M · Substantial damage NTSB MKC74DER47Accident · Minor injuriesClosedPiper PA-28 · Pipestone, MNMay 3, 1974 · N502UM · Substantial damage NTSB MKC74DER46Accident · No injuriesClosedGlobe GC-1B · Buffalo, MNApr 5, 1974 · N97098 · Substantial damage NTSB MKC74AK060Accident · No injuriesClosedCessna 185F · Warroad, MNApr 5, 1974 · N2678S · Substantial damage NTSB MKC74FER44Accident · No injuriesClosedCessna 172 · Willmar, MNMar 23, 1974 · N6126E · Substantial damage NTSB MKC74FER42Accident · No injuriesClosedRobertson T337E · St Paul, MNFeb 26, 1974 · N1711M · Substantial damage NTSB MKC74DER41Accident · No injuriesClosedCessna 172 · Ely, MNFeb 23, 1974 · N19752 · Substantial damage NTSB MKC74FER45Accident · No injuriesClosedBellanca 7GCBC · Roseau, MNFeb 12, 1974 · N62984 · Substantial damage NTSB MKC74FER39Accident · Serious injuriesClosedCessna 402 · Eden Prairie, MNFeb 12, 1974 · N4032Q · Substantial damage NTSB MKC74DER40Accident · No injuriesClosedCessna 150 · Motley, MNFeb 9, 1974 · N60030 · Substantial damage NTSB MKC74AK047Accident · 1 fatalClosedChampion 7GCAA · Warroad, MNFeb 9, 1974 · N2577F · Destroyed NTSB MKC74AK046Accident · 1 fatalClosedPiper PA-18 · Wabasha, MNFeb 3, 1974 · N1864P · Destroyed NTSB MKC74DER38Accident · No injuriesClosedChampion 7ECA · Austin, MNJan 30, 1974 · N11065 · Substantial damage NTSB MKC74AK043Accident · 3 fatalClosedBeech A23-24 · Montevideo, MNJan 30, 1974 · N3645Q · Destroyed NTSB MKC74AK042Accident · 4 fatalClosedPiper PA-28 · Winger, MNJan 28, 1974 · N5290S · Destroyed NTSB MKC74DER37Accident · Minor injuriesClosedPiper PA-28 · Detroit Lake, MNJan 27, 1974 · N6604W · Substantial damage NTSB MKC74FER36Accident · Serious injuriesClosedCessna 175 · Fairmont, MNJan 26, 1974 · N8016T · Substantial damage NTSB MKC74AK038Accident · 1 fatalClosedPiper PA-28 · Willmar, MNJan 17, 1974 · N8900J · Destroyed NTSB MKC74DER35Accident · No injuriesClosedCessna 150E · Springfield, MNJan 13, 1974 · N4019U · Substantial damage NTSB MKC74DER33Accident · No injuriesClosedCessna 172M · Forrest Lake, MNJan 6, 1974 · N20183 · Substantial damage NTSB MKC74DER34Accident · No injuriesClosedPiper PA-28 · Silver Bay, MNJan 4, 1974 · N8414W · Substantial damage NTSB MKC74DER32Accident · No injuriesClosedCessna U206C · Austin, MNDec 29, 1973 · N29136 · Substantial damage NTSB MKC74DER31Accident · No injuriesClosedCessna 182 · Austin, MNDec 25, 1973 · N9043X · Substantial damage NTSB MKC74FER30Accident · No injuriesClosedBell 47G4A · St Paul, MNDec 21, 1973 · N2247W · Substantial damage NTSB MKC74FER29Accident · No injuriesClosedBrantly B2 · Rosemount, MNDec 21, 1973 · N5920X · Substantial damage NTSB MKC74DER27Accident · No injuriesClosedPiper J-3 · Aitkin, MNDec 20, 1973 · N3322N · Substantial damage NTSB MKC74DER28Accident · No injuriesClosedBeech E58 · T River Fall, MNDec 19, 1973 · N6AC · Substantial damage NTSB MKC74FER26Accident · Serious injuriesClosedPiper PA-28 · Rochester, MNDec 16, 1973 · N1549J · Destroyed NTSB MKC74FER25Accident · Minor injuriesClosedCessna 180J · Crystal, MNDec 6, 1973 · N42936 · Substantial damage NTSB MKC74DER24Accident · No injuriesClosedPiper PA-31 · Grand Marais, MNNov 21, 1973 · N7486L · Substantial damage NTSB MKC74FER22Accident · 1 fatalClosedVolmer VJ-22 · Prior Lake, MNNov 12, 1973 · N1007N · Destroyed NTSB MKC74FER19Accident · No injuriesClosedStinson 108-3 · Blaine, MNNov 8, 1973 · N4028C · Substantial damage NTSB MKC74DER21Accident · No injuriesClosedMooney M20A · Willmar, MNNov 8, 1973 · N1075B · Substantial damage NTSB MKC74DER20Accident · Minor injuriesClosedCessna 175-58 · Lake Elmo, MNOct 24, 1973 · N7099M · Substantial damage NTSB MKC74DER18Accident · No injuriesClosedCessna 170 · Anoka, MNOct 15, 1973 · N2632V · Substantial damage NTSB MKC74DTG09Accident · No injuriesClosedCessna 150H · Angus, MNOct 5, 1973 · N50989 · Substantial damage NTSB MKC74AK014Accident · 1 fatalClosedTaylorcraft BC12-D · Slayton, MNOct 2, 1973 · N96184 · Substantial damage NTSB MKC74DER17Accident · No injuriesClosedPiper J-3 · Blackduck, MNSep 30, 1973 · N88553 · Substantial damage NTSB MKC74DER16Accident · No injuriesClosedCessna 140 · Osage, MNSep 20, 1973 · N3071N · Substantial damage NTSB MKC74DER15Accident · No injuriesClosedBellanca 17-30A · Lake Elmo, MNSep 18, 1973 · N8286R · 2 aircraft · Substantial damage NTSB MKC74FER14Accident · Serious injuriesClosedCessna 120 · Ulen, MNSep 16, 1973 · N72606 · Substantial damage NTSB MKC74FER13Accident · Minor injuriesClosedBeech B23 · Clear Lake, MNSep 12, 1973 · N9123T · Substantial damage NTSB MKC74DER12Accident · No injuriesClosedPiper PA-28 · Elk River, MNSep 8, 1973 · N7254F · Substantial damage NTSB MKC74FER11Accident · No injuriesClosedCessna 150H · St Paul, MNSep 7, 1973 · N562G · Substantial damage NTSB MKC74DER09Accident · Serious injuriesClosedCessna 182A · Lake Elmo, MNSep 5, 1973 · N6332B · Substantial damage NTSB MKC74DER06Accident · Minor injuriesClosedCallair A-9 · Stephen, MNAug 20, 1973 · N8414V · Substantial damage NTSB MKC74DER43Accident · Minor injuriesClosedPiper PA-18 · Intl Falls, MNAug 18, 1973 · N5415H · Substantial damage NTSB MKC74DER05Accident · No injuriesClosedAero Comdr A-9B · Winnebago, MNAug 9, 1973 · N7757V · Substantial damage