Skip to content

NTSB investigations, MN

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" = '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 MKC68F0156Accident · Minor injuriesClosedClark 1000 · Owatonna, MNAug 27, 1967 · N78855 · Substantial damage NTSB MKC68F0208Accident · No injuriesClosedPiper PA-14 · Bemidji, MNAug 24, 1967 · N5158H · Substantial damage NTSB MKC68F0191Accident · No injuriesClosedPiper PA-24 · Alexandria, MNAug 22, 1967 · N6847P · Substantial damage NTSB MKC68F0175Accident · Serious injuriesClosedCessna 140 · Two Harbors, MNAug 20, 1967 · N1824V · Substantial damage NTSB MKC68D0471Accident · No injuriesClosedLuscombe 8E · Brainerd, MNAug 20, 1967 · N2882K · Substantial damage NTSB MKC68F0253Accident · No injuriesClosedBellanca 14-19 · Rothsay, MNAug 5, 1967 · N1282R · Substantial damage NTSB MKC68D0205Accident · Minor injuriesClosedCessna 180 · Princeton, MNJul 30, 1967 · N9171T · Substantial damage NTSB MKC68F0112Accident · No injuriesClosedRepublic RC-3 · Nisswa, MNJul 26, 1967 · N6342K · Substantial damage NTSB MKC68F0122Accident · No injuriesClosedMooney M20C · Goodland, MNJul 22, 1967 · N6040Q · Substantial damage NTSB CHI68A0008Accident · 4 fatalClosedNavion G · Hopkins, MNJul 17, 1967 · N2351T · Destroyed NTSB MKC68F0094Accident · No injuriesClosedBeech A23 · Duluth, MNJul 15, 1967 · N4726J · Substantial damage NTSB MKC67D0093Accident · No injuriesClosedChampion 7EC · Grand Rapids, MNJul 15, 1967 · N7401B · Substantial damage NTSB MKC68F0150Accident · No injuriesClosedPiper PA-18 · Barnesville, MNJul 13, 1967 · N4250Z · Substantial damage NTSB MKC68F0091Accident · No injuriesClosedBeech 95 · Hopkins, MNJul 13, 1967 · N2734Y · Substantial damage NTSB MKC68A0003Accident · 2 fatalClosedGrumman G-159 · Le Center, MNJul 11, 1967 · N861H · Destroyed NTSB MKC68F0110Accident · No injuriesClosedCessna 150 · St.Cloud, MNJul 9, 1967 · N4462U · Substantial damage NTSB MKC68D0076Accident · No injuriesClosedAlon A-2 · Finlayson, MNJul 4, 1967 · N6525Q · Substantial damage NTSB MKC68F0067Accident · Serious injuriesClosedPiper PA-28 · So.St.Paul, MNJul 3, 1967 · N508UM · Substantial damage NTSB MKC68F0058Accident · Serious injuriesClosedAeronca 7AC · Twin Valley, MNJun 30, 1967 · N2706E · Substantial damage NTSB MKC68F0074Accident · No injuriesClosedPiper PA-18 · Ashby, MNJun 28, 1967 · N8976D · Substantial damage NTSB MKC67A0092Accident · 1 fatalClosedBeech D35 · So.St-Paul, MNJun 28, 1967 · N2930B · 2 aircraft · Substantial damage NTSB MKC68F0073Accident · No injuriesClosedAeronca 15AC · Alexandria, MNJun 25, 1967 · N1028H · Substantial damage NTSB MKC68F0035Accident · No injuriesClosedChampion 7GC · Montevideo, MNJun 22, 1967 · N4867E · Substantial damage NTSB MKC67A0085Accident · Serious injuriesClosedCessna 180 · Baudette, MNJun 22, 1967 · N8212V · Substantial damage NTSB MKC68F0059Accident · No injuriesClosedCessna T-210 · St Paul, MNJun 21, 1967 · N6722R · Substantial damage NTSB MKC68D0107Accident · No injuriesClosedPiper PA-18 · Evansville, MNJun 21, 1967 · N8976D · Substantial damage NTSB MKC68D0040Accident · No injuriesClosedCessna 120 · Blaine, MNJun 20, 1967 · N1739N · Substantial damage NTSB MKC68D0088Accident · No injuriesClosedCessna 172 · Foreston, MNJun 19, 1967 · N2535L · Substantial damage NTSB MKC68D0106Accident · No injuriesClosedBellanca 14-193 · Eveleth, MNJun 18, 1967 · N8518R · Substantial damage NTSB MKC68F0028Accident · Serious injuriesClosedCessna 150 · Canyon, MNJun 17, 1967 · N8693J · Substantial damage NTSB MKC68D0246Accident · No injuriesClosedSmith PSA-1 · Pennock, MNJun 17, 1967 · N14H · Substantial damage NTSB MKC67A0080Accident · Minor injuriesClosedHughes 269B · Fairmont, MNJun 15, 1967 · N9419F · Substantial damage NTSB MKC68F0018Accident · No injuriesClosedCessna 150G · Pine City, MNJun 14, 1967 · N3322J · Substantial damage NTSB MKC68F0022Accident · No injuriesClosedPiper PA-18 · Breckenridge, MNJun 13, 1967 · N1076A · Substantial damage NTSB MKC68D0113Accident · No injuriesClosedCessna 150 · Savage, MNJun 12, 1967 · N3464J · Substantial damage NTSB MKC68F0029Accident · Minor injuriesClosedCessna 175 · Owatonna, MNJun 11, 1967 · N7533M · Substantial damage NTSB MKC68F0017Accident · No injuriesClosedCessna 150G · St.Paul, MNJun 11, 1967 · N4669X · Substantial damage NTSB MKC68F0062Accident · Minor injuriesClosedCallair A-9 · Roosevelt, MNJun 4, 1967 · N3584G · Substantial damage NTSB MKC68D0016Accident · No injuriesClosedCallair A-4 · Mountain Lke, MNJun 2, 1967 · N7581C · Substantial damage NTSB MKC67A0075Accident · 1 fatalClosedMooney M-18C · Anoka, MNJun 1, 1967 · N4100 · Destroyed NTSB MKC68F0269Accident · No injuriesClosedPiper PA-25 · Stephen, MNMay 31, 1967 · N7421Z · Substantial damage NTSB MKC67D0593Accident · No injuriesClosedCessna 206 · Montevideo, MNMay 30, 1967 · N2137F · Substantial damage NTSB MKC68F0003Accident · Minor injuriesClosedMooney 20C · Willmar, MNMay 28, 1967 · N5602Q · Substantial damage NTSB MKC67A0071Accident · Serious injuriesClosedHughes 269A · Hancock, MNMay 27, 1967 · N8924F · Substantial damage NTSB MKC67F0612Accident · No injuriesClosedPiper PA-23 · Hopkins, MNMay 24, 1967 · N3471P · Substantial damage NTSB MKC67D0624Accident · No injuriesClosedCessna 182 · Hopkins, MNMay 19, 1967 · N2686G · Substantial damage NTSB MKC67F0585Accident · Serious injuriesClosedAeronca 7AC · Lesueur, MNMay 14, 1967 · N83428 · Substantial damage NTSB MKC67A0067Accident · 2 fatalClosedHughes 269B · Federal Dam, MNMay 12, 1967 · N700 · Destroyed NTSB MKC67D0607Accident · No injuriesClosedPiper PA-22 · St.Paul, MNMay 11, 1967 · N5193Z · Substantial damage NTSB MKC67F0592Accident · No injuriesClosedPiper PA-22 · Gaylord, MNMay 9, 1967 · N3265Z · Substantial damage