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 MKC75AK024Accident · 3 fatalClosedBell 47G-5 · Moorhead, MNOct 15, 1974 · N4064G · Destroyed NTSB MKC75FER25Accident · 1 fatalClosedRand KR-1 · Baudette, MNSep 28, 1974 · N8443 · Destroyed NTSB MKC75FER24Accident · No injuriesClosedPiper PA-23 · Hibbing, MNSep 24, 1974 · N14223 · Substantial damage NTSB MKC75DER23Accident · No injuriesClosedPiper PA-24 · Fairmont, MNSep 19, 1974 · N11CG · Substantial damage NTSB MKC75AK020Accident · 1 fatalClosedMaule M4-220 · Grand Marias, MNSep 12, 1974 · N40648 · Substantial damage NTSB MKC75AK019Accident · 6 fatalClosedPiper PA-23 · Austin, MNSep 11, 1974 · N6168Y · Destroyed NTSB MKC75DER22Accident · No injuriesClosedAeronca 7CCM · Alexandria, MNSep 3, 1974 · N4642E · Substantial damage NTSB MKC74DER20Accident · No injuriesClosedPiper PA-24 · S St Paul, MNSep 1, 1974 · N6146P · Substantial damage NTSB MKC75DER19Accident · No injuriesClosedCessna 206 · Ely, MNAug 29, 1974 · N9658G · Substantial damage NTSB MKC75DER21Accident · No injuriesClosedLuscombe 8A · Fergus Falls, MNAug 28, 1974 · N71620 · Substantial damage NTSB MKC75DER18Accident · No injuriesClosedPiper PA-12 · Olivia, MNAug 28, 1974 · N7680H · Substantial damage NTSB MKC74AK017Accident · 1 fatalClosedPiper PA-24 · La Crescent, MNAug 21, 1974 · N6371P · Destroyed NTSB MKC75FER16Accident · Serious injuriesClosedZimmerman S-1C · Waseca, MNAug 18, 1974 · N5191 · Substantial damage NTSB MKC75DER17Accident · No injuriesClosedAeronca 15AC · Forest Lake, MNAug 17, 1974 · N1203H · 2 aircraft · Substantial damage NTSB MKC75DER15Accident · No injuriesClosedPiper PA-30 · Glenwood, MNAug 14, 1974 · N7810Y · Substantial damage NTSB MKC75DER26Accident · No injuriesClosedPiper PA-24 · Faribault, MNAug 12, 1974 · N6900P · Substantial damage NTSB MKC75FER13Accident · Serious injuriesClosedPiper PA-22 · Lake Wilson, MNAug 11, 1974 · N1769A · Substantial damage NTSB MKC75AK012Accident · 8 fatalClosedPiper PA-23 · Fergus Falls, MNAug 10, 1974 · N5278Y · Destroyed NTSB MKC75FER14Accident · No injuriesClosedCessna 411 · Baudette, MNAug 9, 1974 · N173U · Substantial damage NTSB MKC75AK011Accident · 6 fatalClosedPiper PA-30 · Jackson, MNAug 9, 1974 · N8129Y · Destroyed NTSB MKC75AK018Accident · Minor injuriesClosedMooney M20C · Stewartville, MNAug 6, 1974 · N3911N · Substantial damage NTSB MKC75DER12Accident · No injuriesClosedBell 47G-2 · Meridan, MNAug 5, 1974 · N2870B · Substantial damage NTSB MKC75DER10Accident · No injuriesClosedPiper PA-28 · Farmington, MNAug 4, 1974 · N491FT · Substantial damage NTSB MKC75DER11Accident · No injuriesClosedCessna 310J · Austin, MNAug 2, 1974 · N3199L · Substantial damage NTSB MKC75FTG09Accident · No injuriesClosedCessna 210D · Wahpeton, MNJul 31, 1974 · N3858Y · Substantial damage NTSB MKC75FER07Accident · No injuriesClosedCessna 150 · Blaine, MNJul 31, 1974 · N5903G · Substantial damage NTSB MKC75DER09Accident · No injuriesClosedCessna 150L · Crystal, MNJul 31, 1974 · N568GS · Substantial damage NTSB MKC75FER08Accident · No injuriesClosedBeech 65 · Minneapolis, MNJul 30, 1974 · N1090K · Substantial damage NTSB MKC75AK009Accident · Minor injuriesClosedCessna 182N · Sartell, MNJul 30, 1974 · N9263G · Substantial damage NTSB MKC75DER06Accident · No injuriesClosedPiper PA-25 · Moorhead, MNJul 27, 1974 · N8600L · Substantial damage NTSB MKC75DER05Accident · No injuriesClosedMooney M20C · Winona, MNJul 26, 1974 · N3411X · Substantial damage NTSB MKC75DER04Accident · Minor injuriesClosedAeronca 11AC · Glenwood, MNJul 22, 1974 · N1028H · Substantial damage NTSB MKC75DER03Accident · Minor injuriesClosedCessna 140 · Albert Lea, MNJul 15, 1974 · N2314V · Substantial damage NTSB MKC75FER02Accident · No injuriesClosedLuscombe 11A · Anoka, MNJul 14, 1974 · N1634B · Substantial damage NTSB MKC75FER01Accident · No injuriesClosedPiper PA-24 · Rockford, MNJul 4, 1974 · N9137P · Substantial damage NTSB MKC74FER65Accident · No injuriesClosedAeronca 7EC · Silver Bay, MNJun 29, 1974 · N2139E · Substantial damage NTSB MKC74FER63Accident · No injuriesClosedMooney M20C · Crystal, MNJun 29, 1974 · N6898U · Substantial damage NTSB MKC74DER64Accident · No injuriesClosedBeech A36 · Warroad, MNJun 28, 1974 · N1715A · Substantial damage NTSB MKC74DER62Accident · No injuriesClosedBeech N35 · Trimont, MNJun 25, 1974 · N1289Z · Substantial damage NTSB MKC74FER59Accident · Serious injuriesClosedCallair A-9 · Stephen, MNJun 20, 1974 · N7238V · Substantial damage NTSB MKC74DER60Accident · Minor injuriesClosedCessna 188 · Crookston, MNJun 20, 1974 · N3555Q · Substantial damage NTSB MKC74DER58Accident · Minor injuriesClosedPiper PA-25 · Long Prairie, MNJun 20, 1974 · N7107Z · Substantial damage NTSB MKC74DER66Accident · No injuriesClosedPiper PA-18 · Fergus Falls, MNJun 18, 1974 · N7071B · Substantial damage NTSB MKC74FER57Accident · 1 fatalClosedSisler-Home SF2 · Faribault, MNJun 15, 1974 · N5549 · Destroyed NTSB MKC74DER56Accident · No injuriesClosedPiper PA-20 · Monticello, MNJun 13, 1974 · N7717K · Substantial damage NTSB MKC74DER54Accident · No injuriesClosedBellanca 17-31 · New Germany, MNJun 6, 1974 · N170EE · Substantial damage NTSB MKC74DER53Accident · No injuriesClosedCessna 172K · Maple Lake, MNJun 3, 1974 · N7453G · 2 aircraft · Substantial damage NTSB MKC74DER52Accident · No injuriesClosedBeech A23 · Sleepy Eye, MNJun 3, 1974 · N3560R · Substantial damage NTSB MKC74DER51Accident · No injuriesClosedCessna 150J · Esko, MNJun 1, 1974 · N50793 · Substantial damage NTSB MKC74DER55Accident · Minor injuriesClosedRyan PT-22 · Glenwood, MNMay 26, 1974 · N54428 · Substantial damage