Skip to content

NTSB investigations, MN

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 CHI80FER61Accident · No injuriesClosedCessna P206 · Blaine, MNAug 2, 1980 · N4741F · Destroyed NTSB CHI80FER63Accident · Minor injuriesClosedCessna 188 · Long Prairie, MNAug 1, 1980 · N8024V · Substantial damage NTSB CHI80DER62Accident · No injuriesClosedGrumman G-164B · E.Grand Forks, MNAug 1, 1980 · N6515K · Destroyed NTSB CHI80FER60Accident · 1 fatalClosedCassutt · Winona, MNJul 26, 1980 · N89MC · Destroyed NTSB CHI80FER56Accident · Serious injuriesClosedBellanca 7GCBC · Duluth, MNJul 11, 1980 · N2612Z · Substantial damage NTSB CHI80FER57Accident · No injuriesClosedPiper PA-34 · Albert Lea, MNJul 10, 1980 · N7021C · Substantial damage NTSB CHI80FER54Accident · No injuriesClosedMooney M20 · Blaine, MNJul 9, 1980 · N5228B · Substantial damage NTSB CHI80DER52Accident · Minor injuriesClosedBell OH-13 · Bixby, MNJul 5, 1980 · N67083 · Substantial damage NTSB CHI80FER55Accident · 1 fatalClosedCassutt 111M · Warren, MNJul 4, 1980 · N10TD · Destroyed NTSB CHI80DER53Accident · No injuriesClosedCessna 172 · Fosston, MNJul 2, 1980 · N12565 · Substantial damage NTSB CHI80FER50Accident · Minor injuriesClosedBell OH-13H · Olivia, MNJun 23, 1980 · N51862 · Destroyed NTSB CHI80FA048Accident · 4 fatalClosedBeech A35 · Angle Inlet, MNJun 20, 1980 · N188Q · Destroyed NTSB CHI80FER51Accident · No injuriesClosedCessna A185F · Ely, MNJun 18, 1980 · N7611Q · Destroyed NTSB CHI80FER49Accident · 1 fatalClosedPiper PA-25 · Grove City, MNJun 16, 1980 · N6444Z · Destroyed NTSB CHI80DER48Accident · Serious injuriesClosedPiper PA-28 · Tower, MNJun 14, 1980 · N4774L · Substantial damage NTSB CHI80FER47Accident · Minor injuriesClosedPiper PA-25 · Hector, MNJun 9, 1980 · N4826Y · Substantial damage NTSB CHI80DER46Accident · No injuriesClosedCessna 188A · Grygla, MNJun 5, 1980 · N2279U · Substantial damage NTSB CHI80FER44Accident · Minor injuriesClosedHughes 269C · Dexter, MNJun 3, 1980 · N7482F · Destroyed NTSB CHI80DER43Accident · No injuriesClosedHughes 269C · Willmar, MNJun 1, 1980 · N7448F · Substantial damage NTSB CHI80FER41Accident · Minor injuriesClosedBeech B19 · Mankato, MNMay 23, 1980 · N24669 · Substantial damage NTSB CHI80FA041Accident · 4 fatalClosedCessna 172K · Big Fork, MNMay 23, 1980 · N64368 · Destroyed NTSB CHI80DA044Accident · 1 fatalClosedCessna 150 · St Paul, MNMay 23, 1980 · N11960 · No damage NTSB CHI80FER40Accident · No injuriesClosedCessna 210 · Minneapolis, MNMay 18, 1980 · N732XM · Substantial damage NTSB CHI80DER39Accident · No injuriesClosedCessna 152 · Minneapolis, MNMay 10, 1980 · N67993 · Substantial damage NTSB CHI80FER42Accident · No injuriesClosedAeronca 7AC · Mora, MNMay 7, 1980 · N3737E · Substantial damage NTSB CHI80FER38Accident · No injuriesClosedPiper PA-22 · Hoffman, MNMay 2, 1980 · N1495A · Substantial damage NTSB MKC80FER37Accident · Serious injuriesClosedFly Baby BWM-10 · Waubun, MNApr 26, 1980 · N1081Z · Substantial damage NTSB MKC80DER33Accident · No injuriesClosedBeech C23 · Eveleth, MNApr 20, 1980 · N6996R · Substantial damage NTSB MKC80DER34Accident · No injuriesClosedCessna 185 · Eveleth, MNApr 19, 1980 · N4220Q · Substantial damage NTSB MKC80DER35Accident · No injuriesClosedCessna 150 · Rushford, MNApr 18, 1980 · N19588 · Substantial damage NTSB MKC80DER36Accident · No injuriesClosedCessna 180 · Battle Lake, MNApr 12, 1980 · N3397D · Substantial damage NTSB MKC80FA030Accident · 2 fatalClosedCessna 340A · Minneapolis, MNApr 8, 1980 · N98547 · Destroyed NTSB MKC80DER32Accident · No injuriesClosedBeech C24R · Blaine, MNMar 28, 1980 · N2008Z · Substantial damage NTSB MKC80FER30Accident · 1 fatalClosedScorpion II · Lakeville, MNMar 25, 1980 · NONE · Destroyed NTSB MKC80FER29Accident · No injuriesClosedPiper PA-22 · Floodwater, MNMar 18, 1980 · N3757A · Substantial damage NTSB MKC80FER26Accident · No injuriesClosedPiper PA-32 · Sauk Centre, MNMar 7, 1980 · N333JD · Substantial damage NTSB MKC80DER31Accident · No injuriesClosedCessna 305A · Bemidji, MNMar 7, 1980 · N5250G · Substantial damage NTSB MKC80FER27Accident · No injuriesClosedCessna 152 · Euclid, MNMar 4, 1980 · N68811 · Substantial damage NTSB MKC80FER25Accident · No injuriesClosedCessna 120 · Square Lake, MNFeb 2, 1980 · N76542 · Substantial damage NTSB MKC80DER28Accident · No injuriesClosedCessna 150L · Northome, MNFeb 2, 1980 · N19528 · Substantial damage NTSB MKC80DER24Accident · No injuriesClosedSoloy 12EJ3 · Baudette, MNJan 29, 1980 · N156HA · Substantial damage NTSB MKC80FER23Accident · No injuriesClosedCessna 152 · Shakopee, MNJan 26, 1980 · N714SZ · Substantial damage NTSB MKC80DER21Accident · Minor injuriesClosedPiper PA-28 · Battle Lake, MNJan 25, 1980 · N15968 · Substantial damage NTSB MKC80DER18Accident · No injuriesClosedCessna 190 · Intl Falls, MNJan 21, 1980 · N3019B · Substantial damage NTSB MKC80DER20Accident · No injuriesClosedPiper PA-38 · Anoka, MNJan 20, 1980 · N2536A · Substantial damage NTSB MKC80DER19Accident · No injuriesClosedPiper PA-28 · Rochester, MNJan 20, 1980 · N5918V · Substantial damage NTSB MKC80DER22Accident · No injuriesClosedPiper PA-38 · Fergus Falls, MNJan 13, 1980 · N107WC · Substantial damage NTSB MKC80DER17Accident · No injuriesClosedCessna 152 · Anoka, MNJan 13, 1980 · N24537 · Substantial damage NTSB MKC80DER16Accident · Minor injuriesClosedBellanca 7ECA · Paynesville, MNDec 27, 1979 · N3086H · Destroyed NTSB MKC80DER15Accident · No injuriesClosedAeronca 11AC · Sacred Heart, MNDec 6, 1979 · N86113 · Substantial damage