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 MKC66F0368Accident · No injuriesClosedBeech A35 · New Ulm, MNJan 9, 1966 · N8436A · Substantial damage NTSB MKC66D0468Accident · No injuriesClosedPiper J3C-65 · Pipestone, MNJan 9, 1966 · N5797N · Substantial damage NTSB MKC66D0379Accident · No injuriesClosedPiper PA-28 · So St Paul, MNJan 7, 1966 · N6274W · Substantial damage NTSB MKC66D0349Accident · No injuriesClosedMooney M20A · Altura, MNJan 2, 1966 · N6558B · Substantial damage NTSB MKC66D0306Accident · No injuriesClosedCessna 150 · Cohasset, MNJan 2, 1966 · N4489U · Substantial damage NTSB MKC66D0365Accident · No injuriesClosedCessna 172 · Trimont, MNJan 1, 1966 · N7694T · Substantial damage NTSB MKC66F0346Accident · No injuriesClosedPiper PA-22 · Park Rapids, MNDec 30, 1965 · N1657A · Substantial damage NTSB MKC66F0342Accident · No injuriesClosedCessna 140 · Monticello, MNDec 27, 1965 · N3587V · Substantial damage NTSB MKC66F0343Accident · No injuriesClosedBeechcraft 23 · So St Paul, MNDec 22, 1965 · N8799M · Substantial damage NTSB MKC66F0410Accident · No injuriesClosedPiper PA-12 · Lake Elmo, MNDec 18, 1965 · N78480 · Substantial damage NTSB MKC66D0376Accident · No injuriesClosedCessna 170A · New Ulm, MNDec 7, 1965 · N9277A · Substantial damage NTSB MKC66F0378Accident · No injuriesClosedCessna 120 · Eveleth, MNDec 5, 1965 · N72775 · Substantial damage NTSB MKC66F0315Accident · No injuriesClosedCessna 310H · Hopkins, MNNov 21, 1965 · N1108Q · Substantial damage NTSB MKC66F0332Accident · No injuriesClosedAero Cmdr 520 · Minneapolis, MNNov 8, 1965 · N5574V · Substantial damage NTSB MKC66F0331Accident · No injuriesClosedCessna 170 · So St Paul, MNNov 6, 1965 · N2632D · Substantial damage NTSB MKC66F0391Accident · Minor injuriesClosedBeech N35 · Madison, MNNov 3, 1965 · N1504Z · Substantial damage NTSB MKC66F0358Accident · Serious injuriesClosedChampion 7DC · White Bea, MNOct 30, 1965 · N6403V · Substantial damage NTSB MKC66D0308Accident · No injuriesClosedCessna 172 · Maple Plain, MNOct 29, 1965 · N6345E · Substantial damage NTSB MKC66D0361Accident · No injuriesClosedLitton Stms 213-1 · St Paul, MNOct 22, 1965 · N7534U · Destroyed NTSB MKC66A0028Accident · 1 fatalClosedPiper PA-28 · Fairfax, MNOct 19, 1965 · N7619W · Destroyed NTSB MKC66D0311Accident · No injuriesClosedCessna 150 · Rochester, MNOct 14, 1965 · N8042S · Substantial damage NTSB MKC66A0025Accident · 1 fatalClosedCessna 180 · Bemidji, MNOct 13, 1965 · N2281C · Destroyed NTSB MKC66A0024Accident · 1 fatalClosedSr.Aero SPT D-260 · Hamel, MNOct 10, 1965 · N4648T · Destroyed NTSB MKC66F0307Accident · No injuriesClosedPiper PA-28 · Duluth, MNOct 5, 1965 · N6839W · Substantial damage NTSB MKC66F0273Accident · No injuriesClosedPiper J3L-S · Excelsior, MNOct 4, 1965 · N40962 · Substantial damage NTSB MKC66F0254Accident · No injuriesClosedCessna 170A · So St Paul, MNOct 4, 1965 · N9503A · Substantial damage NTSB MKC66F0285Accident · No injuriesClosedPiper J3-S · Baudette, MNOct 2, 1965 · N87812 · Substantial damage NTSB MKC66F0269Accident · Serious injuriesClosedCessna 150 · N.Greenwald, MNOct 1, 1965 · N5948T · Destroyed NTSB MKC66F0261Accident · No injuriesClosedPiper PA-28 · Sebeka, MNSep 26, 1965 · N501UM · Substantial damage NTSB MKC66D0266Accident · No injuriesClosedCessna 140 · Melrose, MNSep 19, 1965 · N76280 · Substantial damage NTSB MKC66A0016Accident · 1 fatalClosedAir Space 18A · Anoka, MNSep 9, 1965 · N111S · Destroyed NTSB MKC66F0251Accident · No injuriesClosedCessna 150 · Mound, MNSep 5, 1965 · N5862E · Substantial damage NTSB MKC66F0293Accident · Minor injuriesClosedBeechcraft C-18S · Interntl Fls, MNAug 26, 1965 · N59550 · Substantial damage NTSB MKC66A0013Accident · No injuriesClosedBell 47G3B1 · Altura, MNAug 26, 1965 · N73247 · Substantial damage NTSB MKC66F0208Accident · 1 fatalClosedPiper PA-28 · Brainerd, MNAug 24, 1965 · N8248W · Destroyed NTSB MKC66D0233Accident · No injuriesClosedBeechcraft C-35 · So St Paul, MNAug 21, 1965 · N651X · Substantial damage NTSB MKC66F0200Accident · No injuriesClosedPiper PA-24 · Park Rapids, MNAug 19, 1965 · N7030P · Substantial damage NTSB MKC66D0242Accident · No injuriesClosedPiper PA-18A · Fairmont, MNAug 19, 1965 · N9134D · Substantial damage NTSB MKC66F0194Accident · Minor injuriesClosedPiper PA-28 · Minneapolis, MNAug 18, 1965 · N506UM · 2 aircraft · Substantial damage NTSB MKC66F0239Accident · Minor injuriesClosedChampion 7GC · Silver Bay, MNAug 15, 1965 · N8972R · Substantial damage NTSB MKC66F0238Accident · No injuriesClosedCessna 170 · Cottonwood, MNAug 15, 1965 · N4038V · Substantial damage NTSB MKC66F0217Accident · Minor injuriesClosedBeechcraft 23 · Lake City, MNAug 15, 1965 · N2374Q · Substantial damage NTSB MKC66A0009Accident · 1 fatalClosedChampion 7ECA · 3n Floodwood, MNAug 14, 1965 · N2528F · Destroyed NTSB MKC66F0294Accident · No injuriesClosedTaylorcraft BC-12D · So St Paul, MNAug 13, 1965 · N96430 · Substantial damage NTSB MKC66D0235Accident · No injuriesClosedBoeing A75N1 · Maynard, MNAug 13, 1965 · N50325 · Substantial damage NTSB MKC66F0209Accident · No injuriesClosedBeechcraft A23 · Rochester, MNAug 11, 1965 · N8771M · Substantial damage NTSB MKC66A0008Accident · 2 fatalClosedAeronca 7AC · Forest Alke, MNAug 8, 1965 · N84008 · Destroyed NTSB MKC66D0183Accident · No injuriesClosedPiper PA-12 · Pipestone, MNAug 6, 1965 · N4061M · Substantial damage NTSB MKC66F0210Accident · No injuriesClosedPiper PA-28 · Minneapolis, MNAug 4, 1965 · N503UM · Substantial damage NTSB MKC66D0182Accident · No injuriesClosedRepublic RC-3 · Onamia, MNAug 3, 1965 · N6204K · Substantial damage