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 MKC78DER42Accident · No injuriesClosedPiper PA-22 · Westbrook, MNApr 30, 1978 · N3498A · Substantial damage NTSB MKC78FA032Accident · 1 fatalClosedPiper PA-23 · St Cloud, MNApr 17, 1978 · N799Y · Destroyed NTSB MKC78DER39Accident · No injuriesClosedHiller UH-12E · Bemidji, MNApr 13, 1978 · N61CW · Substantial damage NTSB MKC78DER38Accident · No injuriesClosedPiper PA-28 · Sauk Center, MNApr 11, 1978 · N6381R · Substantial damage NTSB MKC78DER37Accident · No injuriesClosedCessna 140 · Windom, MNMar 31, 1978 · N3587V · Substantial damage NTSB MKC78FER35Accident · Minor injuriesClosedCessna 177 · Lakeville, MNMar 30, 1978 · N3404T · Substantial damage NTSB MKC78DER36Accident · No injuriesClosedCessna 150 · Staples, MNMar 30, 1978 · N10859 · Substantial damage NTSB MKC78FER33Accident · No injuriesClosedCessna 172 · Thief Riv Fall, MNMar 8, 1978 · N3889Q · Destroyed NTSB MKC78FER32Accident · No injuriesClosedMooney M20J · Caledonia, MNMar 8, 1978 · N201BK · Substantial damage NTSB MKC78DER34Accident · No injuriesClosedCessna 172 · Montevideo, MNMar 8, 1978 · N73428 · Substantial damage NTSB MKC78FA024Accident · No injuriesClosedNo.American NA-265 · Intl Falls, MNFeb 28, 1978 · N53 · Substantial damage NTSB MKC78DER30Accident · No injuriesClosedBeech 35 · Rochester, MNFeb 26, 1978 · N40U · Substantial damage NTSB MKC78DER27Accident · No injuriesClosedCessna 150 · St.Paul, MNFeb 13, 1978 · N9284U · Substantial damage NTSB MKC78DER29Accident · Serious injuriesClosedAeronca O-58B · Hinckley, MNFeb 12, 1978 · N50435 · Destroyed NTSB MKC78FER28Accident · No injuriesClosedCessna 180 · Rice, MNFeb 11, 1978 · N9915V · Substantial damage NTSB MKC78FER26Accident · No injuriesClosedBeech F33A · Cologne, MNFeb 3, 1978 · N7209R · Substantial damage NTSB MKC78DER25Accident · No injuriesClosedCessna 172N · Crookston, MNJan 23, 1978 · N73946 · Substantial damage NTSB MKC78FER23Accident · No injuriesClosedBeech G35 · Litchfield, MNJan 22, 1978 · N4426D · Substantial damage NTSB MKC78FER24Accident · No injuriesClosedCessna 150 · Blaine, MNJan 20, 1978 · N2964S · Substantial damage NTSB MKC78FER21Accident · Minor injuriesClosedPiper PA-23 · Eden Prairie, MNJan 5, 1978 · N1142P · Destroyed NTSB MKC78FER22Accident · No injuriesClosedCessna 310C · Blaine, MNJan 4, 1978 · N1780H · Substantial damage NTSB MKC78DER16Accident · No injuriesClosedCessna 172F · Glenwood, MNJan 1, 1978 · N8205U · Substantial damage NTSB MKC78DER19Accident · No injuriesClosedCessna 310Q · Rochester, MNDec 29, 1977 · N310JP · Substantial damage NTSB MKC78FER17Accident · No injuriesClosedCessna 150M · St Paul, MNDec 19, 1977 · N8747U · Substantial damage NTSB MKC78FER15Accident · No injuriesClosedCessna 172M · St.Agusta, MNDec 11, 1977 · N1224U · Substantial damage NTSB MKC78FER14Accident · No injuriesClosedCessna 172L · Minneapolis, MNDec 11, 1977 · N9828G · Substantial damage NTSB MKC78FER13Accident · Minor injuriesClosedCessna 175 · Anoka, MNDec 5, 1977 · N7117M · Substantial damage NTSB MKC78FER12Accident · Minor injuriesClosedPiper PA-30 · Ely, MNNov 25, 1977 · N8739Y · Substantial damage NTSB MKC78FER11Accident · Minor injuriesClosedGrumman AA-5 · Caledonia, MNNov 24, 1977 · N1368R · Substantial damage NTSB MKC78DER09Accident · No injuriesClosedBellanca 17-30A · Lakeville, MNNov 16, 1977 · N117L · Destroyed NTSB MKC78DER08Accident · No injuriesClosedHiller UH-12E · Bemidji, MNNov 14, 1977 · N8286 · Substantial damage NTSB MKC78FER07Accident · No injuriesClosedPiper PA-28 · Anoka, MNNov 9, 1977 · N47350 · 2 aircraft · Substantial damage NTSB MKC78FER06Accident · No injuriesClosedBeech C-24R · Camp Ripley, MNOct 26, 1977 · N18874 · Substantial damage NTSB MKC78FER04Accident · No injuriesClosedMooney M20C · Morris, MNOct 23, 1977 · N9459V · Substantial damage NTSB MKC78FER02Accident · No injuriesClosedCessna 172 · Afton, MNOct 16, 1977 · N1390U · Substantial damage NTSB MKC78DER05Accident · No injuriesClosedStinson 108-1 · Alexandria, MNOct 16, 1977 · N97834 · Substantial damage NTSB MKC78FER03Accident · No injuriesClosedCessna 310 · Eden Prairie, MNOct 12, 1977 · N8917Z · Substantial damage NTSB MKC78DER01Accident · No injuriesClosedPiper PA-18 · Belle Plaine, MNOct 3, 1977 · N57753 · Substantial damage NTSB MKC77DER86Accident · No injuriesClosedCessna 172 · Sanborn, MNSep 28, 1977 · N13338 · Substantial damage NTSB MKC79DER01Accident · No injuriesClosedCessna 170B · Hastings, MNSep 26, 1977 · N8004A · Substantial damage NTSB MKC77DER85Accident · No injuriesClosedCessna 150G · Winona, MNSep 26, 1977 · N6231S · Substantial damage NTSB MKC77DER84Accident · No injuriesClosedPiper PA-28 · Starbuck, MNSep 20, 1977 · N8671W · Substantial damage NTSB MKC77FA040Accident · 2 fatalClosedAeronca 7AC · Grand Rapids, MNSep 18, 1977 · N3702E · Substantial damage NTSB MKC77DER83Accident · No injuriesClosedPiper PA-22 · Brandon, MNSep 18, 1977 · N5907D · Substantial damage NTSB MKC77FER82Accident · No injuriesClosedBellanca 7ECA · Belle Plaine, MNSep 10, 1977 · N53745 · Substantial damage NTSB MKC77FER81Accident · No injuriesClosedPiper PA-28 · Madison, MNSep 2, 1977 · N5117W · Substantial damage NTSB MKC77FER80Accident · No injuriesClosedPiper PA-32 · Duluth, MNAug 31, 1977 · N5541J · Substantial damage NTSB MKC77FER79Accident · No injuriesClosedCessna 195 · Bloomington, MNAug 30, 1977 · N2190C · Substantial damage NTSB MKC77FA036Accident · 1 fatalClosedCessna 172M · Henning, MNAug 30, 1977 · N64190 · Destroyed NTSB MKC77FER78Accident · No injuriesClosedCessna 172 · Ostrander, MNAug 27, 1977 · N7769T · Substantial damage