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 MKC74FER03Accident · No injuriesClosedCessna 310J · Owatonna, MNAug 1, 1973 · N3165L · Substantial damage NTSB MKC74DER04Accident · Serious injuriesClosedCallair A-9A · Grygla, MNJul 31, 1973 · N8261H · Destroyed NTSB MKC74AK002Accident · 2 fatalClosedCessna 172E · Lake Park, MNJul 30, 1973 · N3552S · Destroyed NTSB MKC74DER02Accident · No injuriesClosedPiper PA-28 · Eden Prairie, MNJul 20, 1973 · N8378W · Substantial damage NTSB MKC74DER01Accident · No injuriesClosedBell 47G-5 · Bloomington, MNJul 20, 1973 · N4064G · Substantial damage NTSB MKC73DER69Accident · Serious injuriesClosedBellanca 7GCBC · Grand Rapids, MNJun 20, 1973 · N8552 · Substantial damage NTSB MKC73FER68Accident · 1 fatalClosedPiper PA-18A · Beardsley, MNJun 12, 1973 · N8073D · Destroyed NTSB MKC73DER67Accident · Minor injuriesClosedWaco YKS-6 · Deer River, MNJun 9, 1973 · N16241 · Substantial damage NTSB MKC73DER70Accident · No injuriesClosedCessna 172K · Ranier, MNJun 8, 1973 · N79277 · Substantial damage NTSB MKC73DER66Accident · No injuriesClosedBell 47G-2 · Brainerd, MNJun 1, 1973 · N65520 · Substantial damage NTSB MKC73IK072Incident · No injuriesClosedConvair 580 · Minneapolis, MNMay 31, 1973 · N968N · Minor damage NTSB MKC73FER65Accident · Minor injuriesClosedPiper PA-22 · Wadena, MNMay 26, 1973 · N9999D · Substantial damage NTSB MKC73FER64Accident · Minor injuriesClosedGrumman G-164 · Elbow Lake, MNMay 26, 1973 · N985X · Substantial damage NTSB MKC73AK070Accident · 2 fatalClosedPiper PA-23 · Cloquet, MNMay 26, 1973 · N4330Y · Destroyed NTSB MKC73AK068Accident · 5 fatalClosedCessna 411 · Minneapolis, MNMay 25, 1973 · N4932T · Destroyed NTSB MKC73DER63Accident · No injuriesClosedPiper PA-28 · Lake Benton, MNMay 22, 1973 · N6302R · Substantial damage NTSB MKC73DER62Accident · No injuriesClosedCessna 150 · Hallock, MNMay 20, 1973 · N88026 · Substantial damage NTSB MKC73DER60Accident · No injuriesClosedCessna 180 · Circle Pines, MNMay 16, 1973 · N9917V · Substantial damage NTSB MKC73FER58Accident · Minor injuriesClosedCessna 140 · Grand Rapids, MNMay 14, 1973 · N2917N · Substantial damage NTSB MKC73DER59Accident · Minor injuriesClosedPiper PA-18 · Stanton, MNMay 13, 1973 · N1015A · Substantial damage NTSB MKC73DER56Accident · No injuriesClosedAero Comdr 100 · Maple Plain, MNMay 12, 1973 · N4125X · Substantial damage NTSB MKC73FER57Accident · No injuriesClosedCessna 140 · Anoka, MNMay 9, 1973 · N77095 · Substantial damage NTSB MKC73AK065Accident · 2 fatalClosedPiper PA-24 · Granger, MNMay 6, 1973 · N8114P · Destroyed NTSB MKC73FER51Accident · Serious injuriesClosedCessna 170B · Burnsville, MNApr 29, 1973 · N2568C · Substantial damage NTSB MKC73DER52Accident · Serious injuriesClosedPiper PA-18 · Fosston, MNApr 29, 1973 · N2461A · Substantial damage NTSB MKC73DER55Accident · Minor injuriesClosedBellanca 7ECA · Redwood Fall, MNApr 28, 1973 · N90992 · Substantial damage NTSB MKC73DER54Accident · No injuriesClosedCessna 180 · Bemidji, MNApr 28, 1973 · N3393D · Substantial damage NTSB MKC73DER53Accident · No injuriesClosedCessna 182 · Spring Valey, MNApr 28, 1973 · N8954T · Substantial damage NTSB MKC73FER23Accident · Serious injuriesClosedBeech A23 · Eden Prairie, MNApr 8, 1973 · N7212T · Substantial damage NTSB MKC73AK060Accident · 2 fatalClosedPiper PA-12 · Bock, MNApr 8, 1973 · N7705H · Destroyed NTSB MKC73DER49Accident · No injuriesClosedPiper PA-32 · Starbuck, MNApr 7, 1973 · N3364W · Substantial damage NTSB MKC73FER48Accident · Serious injuriesClosedGrumman G-164A · Elbow Lake, MNApr 6, 1973 · N6595 · Destroyed NTSB MKC73AK059Accident · No injuriesClosedBell 47G-2 · Owatonna, MNApr 6, 1973 · N38926 · Substantial damage NTSB MKC73DER47Accident · No injuriesClosedMooney M10 · Willmar, MNApr 3, 1973 · N9530V · Substantial damage NTSB MKC73FER46Accident · No injuriesClosedLuscombe 8A · Hibbing, MNMar 30, 1973 · N2128K · Substantial damage NTSB MKC73AK058Accident · No injuriesClosedBell 47J-2 · Minneapolis, MNMar 26, 1973 · N8482E · Destroyed NTSB MKC73FER45Accident · No injuriesClosedPiper PA-24 · Grand Rapids, MNMar 25, 1973 · N5671P · Substantial damage NTSB MKC73FER43Accident · Minor injuriesClosedBeech G18S · Willmar, MNMar 11, 1973 · N788G · Substantial damage NTSB MKC73FER44Accident · No injuriesClosedMooney M20A · Duluth, MNMar 10, 1973 · N8142E · Substantial damage NTSB MKC73AK057Accident · 2 fatalClosedN. American NA-265 · Blaine, MNMar 7, 1973 · N9503Z · Destroyed NTSB MKC73DER42Accident · No injuriesClosedCessna 180C · Eveleth, MNMar 4, 1973 · N3653C · Substantial damage NTSB MKC73AK054Accident · No injuriesClosedLear Jet 24 · Brainerd, MNMar 2, 1973 · N661CP · Substantial damage NTSB MKC73DER41Accident · No injuriesClosedCessna 206 · Glencoe, MNFeb 24, 1973 · N8706Z · Substantial damage NTSB MKC73DER40Accident · No injuriesClosedBeech B23 · Thief R Fall, MNFeb 23, 1973 · N6084N · Substantial damage NTSB MKC73FER39Accident · No injuriesClosedCessna 180 · St Paul, MNFeb 7, 1973 · N4790B · Substantial damage NTSB MKC73DER38Accident · No injuriesClosedBeech A23 · Madison, MNFeb 3, 1973 · N2369W · Substantial damage NTSB MKC73DER37Accident · No injuriesClosedCessna 150L · Fertile, MNJan 28, 1973 · N18513 · Substantial damage NTSB MKC73FER36Accident · Serious injuriesClosedCessna A185E · Warroad, MNJan 17, 1973 · N5841J · Destroyed NTSB MKC73FER35Accident · Minor injuriesClosedTaylorcraft BC12-D · Blue Earth, MNJan 13, 1973 · N43478 · Substantial damage NTSB MKC73DER34Accident · No injuriesClosedCessna 150G · Lake Elmo, MNJan 13, 1973 · N2270J · Substantial damage