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 MKC75DER72Accident · No injuriesClosedCessna 172M · Northome, MNJun 4, 1975 · N4383R · Substantial damage NTSB MKC75DER73Accident · No injuriesClosedBell 47G2 · Rosemount, MNJun 3, 1975 · N108DA · Substantial damage NTSB MKC75AK059Accident · 1 fatalClosedPiper PA-18 · Elizabeth, MNJun 2, 1975 · N5463H · Destroyed NTSB MKC75FER71Accident · Serious injuriesClosedAeronca 7AC · Mora, MNMay 28, 1975 · N81407 · Substantial damage NTSB MKC75DER70Accident · Minor injuriesClosedCessna 170B · Sauk Center, MNMay 23, 1975 · N3048A · Substantial damage NTSB MKC75DER69Accident · Minor injuriesClosedCessna 182N · Argyle, MNMay 22, 1975 · N92514 · Substantial damage NTSB MKC75DER68Accident · No injuriesClosedHughes 269A · Lafayette, MNMay 21, 1975 · N8929F · Substantial damage NTSB MKC75FER67Accident · Minor injuriesClosedCessna 150H · Blaine, MNMay 5, 1975 · N22720 · Substantial damage NTSB MKC75DER66Accident · No injuriesClosedCessna 150M · Cambridge, MNApr 29, 1975 · N66396 · Substantial damage NTSB MKC75AK052Accident · 1 fatalClosedBeech C90 · Grand Rapids, MNApr 18, 1975 · N4146S · Destroyed NTSB MKC75FER65Accident · 1 fatalClosedPiper PA-25 · Benson, MNApr 16, 1975 · N6027Z · Destroyed NTSB MKC75FER64Accident · No injuriesClosedCessna 150L · Duluth, MNApr 16, 1975 · N18063 · Substantial damage NTSB MKC75DER63Accident · No injuriesClosedMooney M20C · Winona, MNApr 3, 1975 · N7109U · Substantial damage NTSB MKC75DER62Accident · No injuriesClosedPiper PA-28 · Alexandria, MNApr 2, 1975 · N5760F · Substantial damage NTSB MKC75DER61Accident · No injuriesClosedBeech 19 · Eden Prairie, MNMar 31, 1975 · N6579R · Substantial damage NTSB MKC75DER58Accident · No injuriesClosedCessna 172G · Austin, MNMar 20, 1975 · N7522X · Substantial damage NTSB MKC75FER59Accident · No injuriesClosedCessna 140 · Eden Prairie, MNMar 19, 1975 · N76865 · Substantial damage NTSB MKC75DER60Accident · No injuriesClosedCessna 310 · Minneapolis, MNMar 18, 1975 · N650R · Substantial damage NTSB MKC75AK048Accident · No injuriesClosedBell 47G-2A · Eden Prairie, MNMar 12, 1975 · N116SP · Substantial damage NTSB MKC75DER56Accident · No injuriesClosedCessna 150J · Anoka, MNMar 10, 1975 · N60030 · Substantial damage NTSB MKC75FER55Accident · No injuriesClosedBeech 58 · Rochester, MNMar 7, 1975 · N9021V · Substantial damage NTSB MKC75DER54Accident · No injuriesClosedChampion 7EC · Northfield, MNMar 4, 1975 · N4837E · Substantial damage NTSB MKC75DER53Accident · No injuriesClosedCessna 180 · Lake Elmo, MNMar 1, 1975 · N5095E · Substantial damage NTSB MKC75DER57Accident · No injuriesClosedCessna 172 · Pine River, MNFeb 28, 1975 · N7830G · Substantial damage NTSB MKC75DER52Accident · Minor injuriesClosedCessna 140 · Maple Lake, MNFeb 17, 1975 · N76111 · Substantial damage NTSB MKC75FER51Accident · Serious injuriesClosedCessna 182 · Annandale, MNFeb 15, 1975 · N52370 · Destroyed NTSB MKC75DER49Accident · No injuriesClosedCessna 172 · Fergus Falls, MNFeb 13, 1975 · N46015 · Substantial damage NTSB MKC75FER50Accident · No injuriesClosedCessna 175A · Eden Prairie, MNFeb 11, 1975 · N6766E · Substantial damage NTSB MKC75DER47Accident · No injuriesClosedCessna T210G · Eden Prairie, MNFeb 1, 1975 · N6906R · Substantial damage NTSB MKC75DER46Accident · No injuriesClosedMooney M20C · Hector, MNFeb 1, 1975 · N6558U · Substantial damage NTSB MKC75DER45Accident · No injuriesClosedCessna 172 · Eden Prairie, MNJan 30, 1975 · N4380Q · Substantial damage NTSB MKC75FER42Accident · No injuriesClosedPiper PA-30 · Rochester, MNJan 26, 1975 · N8367Y · Substantial damage NTSB MKC75DER43Accident · No injuriesClosedCessna 150 · Crystal, MNJan 26, 1975 · N3343V · Substantial damage NTSB MKC75FER40Accident · No injuriesClosedCessna 172M · Eden Prairie, MNJan 19, 1975 · N13249 · Substantial damage NTSB MKC75DER44Accident · No injuriesClosedCessna 150L · Garrison, MNJan 19, 1975 · N6909G · Substantial damage NTSB MKC75DER38Accident · No injuriesClosedCessna 172M · Mankato, MNJan 18, 1975 · N103MS · Substantial damage NTSB MKC75FER41Accident · No injuriesClosedPiper PA-24 · Rochester, MNJan 15, 1975 · N7179P · Substantial damage NTSB MKC75DER39Accident · No injuriesClosedPiper PA-28 · Waseca, MNJan 15, 1975 · N7951W · Substantial damage NTSB MKC75DER37Accident · No injuriesClosedStinson 108 · Vermillion, MNJan 5, 1975 · N97369 · Substantial damage NTSB MKC75FER36Accident · Serious injuriesClosedCessna 180A · Detroit Lakes, MNJan 3, 1975 · N9733B · Destroyed NTSB MKC75FER34Accident · No injuriesClosedBeech V35 · St Paul, MNDec 20, 1974 · N2798T · Substantial damage NTSB MKC75IK032Incident · No injuriesClosedDouglas DC-9 · Minneapolis, MNDec 19, 1974 · N8910E · Minor damage NTSB MKC75FER35Accident · No injuriesClosedBeech 35 · Mankato, MNDec 16, 1974 · N2790V · Substantial damage NTSB MKC75FER33Accident · No injuriesClosedPiper PA-28R · Eden Prairie, MNDec 5, 1974 · N55610 · Substantial damage NTSB MKC75DER32Accident · No injuriesClosedPiper PA-22 · Marshall, MNDec 2, 1974 · N7222D · Substantial damage NTSB MKC75FER31Accident · No injuriesClosedPiper PA-20 · Cloquet, MNDec 1, 1974 · N690K · Substantial damage NTSB MKC75FER30Accident · No injuriesClosedCessna 150L · Green Isle, MNNov 17, 1974 · N569GS · Substantial damage NTSB MKC75FER28Accident · No injuriesClosedBeech 95-55 · Minneapolis, MNNov 7, 1974 · N1233Z · Substantial damage NTSB MKC75DER29Accident · No injuriesClosedAero Comdr 100 · Milan, MNOct 27, 1974 · N5553M · Substantial damage NTSB MKC75DER27Accident · No injuriesClosedAmer Avco AA1-B · Northome, MNOct 27, 1974 · N9606L · Substantial damage