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 MKC67D0601Accident · No injuriesClosedAeronca 7EC · Ranier, MNMay 7, 1967 · N4370C · Substantial damage NTSB MKC67F0581Accident · No injuriesClosedSchweizer SGU-2 · Red Wing, MNMay 6, 1967 · N5823V · Substantial damage NTSB MKC67D0569Accident · No injuriesClosedCessna 172H · Harmony, MNMay 6, 1967 · N2412L · Substantial damage NTSB MKC67F0513Accident · Minor injuriesClosedCessna 150 · Fosston, MNApr 29, 1967 · N6283R · Substantial damage NTSB MKC67A0063Accident · 1 fatalClosedMooney M20C · Austin, MNApr 29, 1967 · N2703W · Destroyed NTSB MKC67F0625Accident · Minor injuriesClosedBeech 23 · Spring Valle, MNApr 16, 1967 · N2397Z · Substantial damage NTSB MKC67F0515Accident · No injuriesClosedBeech 35 · Minneapolis, MNApr 16, 1967 · N40U · Substantial damage NTSB MKC67D0578Accident · No injuriesClosedCessna 140 · Thief R Flls, MNMar 27, 1967 · N3612V · Substantial damage NTSB MKC67D0466Accident · No injuriesClosedCessna 150 · Park Rapids, MNMar 27, 1967 · N3063J · Substantial damage NTSB MKC67D0548Accident · No injuriesClosedCessna 150 · Sprg.Lake Pk., MNMar 25, 1967 · N8892G · Substantial damage NTSB MKC67D0542Accident · No injuriesClosedPiper PA-32 · Albert Lea, MNMar 22, 1967 · N3805W · Substantial damage NTSB MKC67D0508Accident · No injuriesClosedCessna 210E · Sandstone, MNMar 11, 1967 · N2322T · Substantial damage NTSB MKC67F0493Accident · Minor injuriesClosedCessna 120 · St.Cloud, MNMar 10, 1967 · N1787V · Substantial damage NTSB MKC67F0529Accident · No injuriesClosedPiper PA-22 · St.Paul, MNMar 9, 1967 · N4599Z · Destroyed NTSB MKC67A0052Accident · No injuriesClosedAir-Space 18A · Clarissa, MNMar 4, 1967 · N6167S · Substantial damage NTSB MKC67D0481Accident · No injuriesClosedChampion 7FC · Anoka, MNFeb 27, 1967 · N9989Y · Substantial damage NTSB MKC67F0482Accident · No injuriesClosedPiper PA-22 · Austin, MNFeb 26, 1967 · N6723B · Substantial damage NTSB MKC67D0494Accident · No injuriesClosedBeech C-18S · Rosemount, MNFeb 25, 1967 · N58911 · Substantial damage NTSB MKC67D0483Accident · No injuriesClosedCessna 140 · Cohasset, MNFeb 25, 1967 · N3709V · Substantial damage NTSB MKC67D0467Accident · No injuriesClosedCessna 172 · Stanton, MNFeb 24, 1967 · N5403R · Substantial damage NTSB MKC67D0536Accident · No injuriesClosedChampion 7DC · Roosevelt, MNFeb 21, 1967 · N4516E · Substantial damage NTSB MKC67F0608Accident · Serious injuriesClosedPiper J-3C · Virginia, MNFeb 19, 1967 · N70955 · Destroyed NTSB MKC67F0502Accident · No injuriesClosedBeech A23 · Lake Elmo, MNFeb 14, 1967 · N8700M · Substantial damage NTSB MKC67F0454Accident · No injuriesClosedCessna 150 · Anoka, MNFeb 14, 1967 · N8614G · Substantial damage NTSB MKC67D0501Accident · No injuriesClosedPiper PA-22 · Whte Bear Lk, MNFeb 14, 1967 · N5193Z · Substantial damage NTSB MKC67D0455Accident · No injuriesClosedCessna 172 · Dodge Cntr, MNFeb 14, 1967 · N159AE · Substantial damage NTSB MKC67F0417Accident · No injuriesClosedCessna 210D · Hopkins, MNFeb 6, 1967 · N3796Y · Substantial damage NTSB MKC67D0549Accident · No injuriesClosedBeech D35 · Austin, MNJan 31, 1967 · N2130D · Substantial damage NTSB MKC67F0438Accident · No injuriesClosedCessna 172 · Blaine, MNJan 28, 1967 · N3024U · Substantial damage NTSB MKC67D0439Accident · No injuriesClosedPiper PA-22 · Buffalo, MNJan 28, 1967 · N8053D · Substantial damage NTSB MKC67F0414Accident · No injuriesClosedCessna 310G · Minneapolis, MNJan 25, 1967 · N8907Z · Substantial damage NTSB MKC67D0396Accident · Serious injuriesClosedPiper PA-28 · Grand Marais, MNJan 22, 1967 · N4559R · Destroyed NTSB MKC67F0392Accident · No injuriesClosedNavion G · Hopkins, MNJan 21, 1967 · N2351T · Substantial damage NTSB MKC67D0413Accident · No injuriesClosedCessna 150 · Bigg Falls, MNJan 19, 1967 · N3180J · Substantial damage NTSB MKC67D0379Accident · No injuriesClosedCessna 150 · Hopkins, MNJan 12, 1967 · N6960F · Substantial damage NTSB MKC67F0410Accident · No injuriesClosedBeech E18S · Minneapolis, MNJan 7, 1967 · N352WB · Substantial damage NTSB MKC67F0366Accident · Serious injuriesClosedAeronca 7DC · St.Martin, MNJan 2, 1967 · N4314E · Destroyed NTSB MKC67D0423Accident · No injuriesClosedBeech J35 · Benson, MNJan 2, 1967 · N7263B · Substantial damage NTSB MKC67A0041Accident · 1 fatalClosedCessna 172 · Spring Grove, MNJan 1, 1967 · N7378A · Destroyed NTSB MKC67F0383Accident · Minor injuriesClosedAeronca 7CCM · Phelphs, MNDec 31, 1966 · N4642E · Substantial damage NTSB MKC67D0368Accident · No injuriesClosedCessna 182 · Maple Plain, MNDec 28, 1966 · N6384A · Substantial damage NTSB MKC67F0376Accident · Serious injuriesClosedChampion 7AC · Moose Lake, MNDec 26, 1966 · N82838 · Substantial damage NTSB MKC67D0384Accident · No injuriesClosedCessna 120 · Buyek, MNDec 26, 1966 · N72775 · Substantial damage NTSB MKC67D0360Accident · No injuriesClosedPiper PA-28 · Duluth, MNDec 23, 1966 · N7147R · Substantial damage NTSB MKC67F0356Accident · No injuriesClosedNavion F · Hopkins, MNDec 19, 1966 · N5387K · Substantial damage NTSB MKC67D0354Accident · No injuriesClosedCessna 150F · Warren, MNDec 11, 1966 · N7199F · Substantial damage NTSB MKC67A0038Accident · 1 fatalClosedAero Comdr 680E · Minneapolis, MNDec 9, 1966 · N8496C · Destroyed NTSB MKC67D0412Accident · No injuriesClosedBeech P35 · Glenwood, MNDec 5, 1966 · N977Q · Substantial damage NTSB MKC67F0330Accident · 1 fatalClosedChampion 7FC · Forest Lake, MNDec 3, 1966 · N9034B · Destroyed NTSB MKC67F0320Accident · No injuriesClosedPiper PA-20 · Paynesville, MNDec 3, 1966 · N7428K · Substantial damage