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 MKC73DER30Accident · No injuriesClosedChampion 7KCAB · Red Wing, MNDec 28, 1972 · N5167X · Substantial damage NTSB MKC73DER31Accident · No injuriesClosedPiper PA-30 · Morris, MNDec 27, 1972 · N8387Y · Substantial damage NTSB MKC73DER33Accident · No injuriesClosedCessna 182 · Minneapolis, MNDec 26, 1972 · N3120R · Substantial damage NTSB MKC73DER32Accident · No injuriesClosedPiper PA-28 · New Ulm, MNDec 26, 1972 · N1718T · Substantial damage NTSB MKC73DER29Accident · No injuriesClosedCessna 180B · St. Cloud, MNDec 21, 1972 · N5095E · Substantial damage NTSB MKC73AKO43Accident · 5 fatalClosedCessna T210K · Eden Prarie, MNDec 20, 1972 · N8202M · Substantial damage NTSB MKC73FER28Accident · No injuriesClosedPiper PA-24 · T.R.Falls, MNDec 7, 1972 · N6900P · Substantial damage NTSB MKC73AK040Accident · 2 fatalClosedBeech C-45H · St.Paul, MNNov 29, 1972 · N717B · Destroyed NTSB MKC73AK037Accident · 2 fatalClosedCessna 182 · Duluth, MNNov 8, 1972 · N70586 · Destroyed NTSB MKC73DER27Accident · No injuriesClosedPiper PA-22 · Anoka, MNOct 27, 1972 · N8427D · Substantial damage NTSB MKC73FER26Accident · No injuriesClosedCessna 150G · Anoka, MNOct 25, 1972 · N3085S · Substantial damage NTSB MKC73AKO27Accident · Minor injuriesClosedCessna 182B · Cloquet, MNOct 19, 1972 · N2470G · Substantial damage NTSB MKC73FER24Accident · No injuriesClosedAmer Avco AA1A · Eden Prairie, MNOct 11, 1972 · N9217L · Substantial damage NTSB MKC73FER25Accident · No injuriesClosedPiper PA-28 · Duluth, MNOct 7, 1972 · N4486J · Substantial damage NTSB MKC73DER23Accident · No injuriesClosedCessna 195B · Park Rapids, MNOct 6, 1972 · N3082B · Substantial damage NTSB MKC73DER22Accident · Minor injuriesClosedCessna 175 · Duluth, MNOct 4, 1972 · N76MA · Substantial damage NTSB MKC73AK022Accident · 1 fatalClosedForney F-1A · Clearbrook, MNSep 19, 1972 · N3034G · Destroyed NTSB MKC73FER21Accident · No injuriesClosedBeech 95-B55 · Detroit Lks, MNSep 7, 1972 · N7958K · Substantial damage NTSB MKC73FER18Accident · No injuriesClosedCessna 210B · Leonard, MNSep 4, 1972 · N3828Y · Substantial damage NTSB MKC73AK021Accident · 4 fatalClosedPiper PA-22 · Princeton, MNSep 4, 1972 · N3365Z · Destroyed NTSB MKC73FER16Accident · No injuriesClosedCessna 170B · Hibbing, MNAug 27, 1972 · N2555C · Substantial damage NTSB MKC73DER15Accident · No injuriesClosedCessna 180H · Walker, MNAug 25, 1972 · N9059M · Substantial damage NTSB MKC73FER14Accident · No injuriesClosedPiaggio P-136 · Minneapolis, MNAug 24, 1972 · N201NA · Substantial damage NTSB MKC73AK017Accident · 2 fatalClosedCessna 180B · Anoka, MNAug 24, 1972 · N5271E · Destroyed NTSB MKC73DER13Accident · No injuriesClosedPiper PA-25 · Mapleton, MNAug 19, 1972 · N7217Z · Substantial damage NTSB MKC73FER12Accident · No injuriesClosedGrumman G-164A · Hollandale, MNAug 17, 1972 · N7843 · Substantial damage NTSB MKC73DER19Accident · No injuriesClosedPiper PA-28 · Montevideo, MNAug 17, 1972 · N6302R · Substantial damage NTSB MKC73FER11Accident · No injuriesClosedCessna 170 · Rosemount, MNAug 16, 1972 · N3824V · Substantial damage NTSB MKC73AK016Accident · 2 fatalClosedCessna 182 · Eden Prairie, MNAug 10, 1972 · N182TC · 2 aircraft · Destroyed NTSB MKC73FER09Accident · Minor injuriesClosedPiper PA-28 · Perham, MNJul 29, 1972 · N7406W · Substantial damage NTSB MKC73DER20Accident · No injuriesClosedBeech D55 · Thef Riv.Fls, MNJul 24, 1972 · N8470N · Substantial damage NTSB MKC73FER10Accident · No injuriesClosedLuscombe 8A · Marshall, MNJul 22, 1972 · N1459K · Substantial damage NTSB MKC73DER08Accident · No injuriesClosedCessna 310 · Duluth, MNJul 21, 1972 · N169G · Substantial damage NTSB MKC73FER07Accident · No injuriesClosedPiper PA-22 · Eden Prairie, MNJul 19, 1972 · N2331P · Substantial damage NTSB MKC73FER06Accident · No injuriesClosedAeronca 11AC · Two Harbors, MNJul 18, 1972 · N3289E · Substantial damage NTSB MKC73FER03Accident · No injuriesClosedBeech A60 · Coon Rapids, MNJul 15, 1972 · N176D · Substantial damage NTSB MKC73AK005Accident · No injuriesClosedLockheed PV-1 · Lakeville, MNJul 10, 1972 · N5033F · Substantial damage NTSB MKC73FER02Accident · Serious injuriesClosedBeech 19A · Forest Lake, MNJul 7, 1972 · N7649R · Substantial damage NTSB MKC73AK003Accident · 2 fatalClosedN.American SNJ-4 · Thief Rvr Fl, MNJul 6, 1972 · N7056C · Destroyed NTSB MKC73FER04Accident · Minor injuriesClosedEL Tomcat MK6B · Miesville, MNJul 5, 1972 · N7840S · Destroyed NTSB MKC72DER70Accident · No injuriesClosedGrumman G164A · Roland, MNJun 28, 1972 · N5275 · Substantial damage NTSB MKC72DER69Accident · Minor injuriesClosedBensen-Ayer B8MJ · Huntington, MNJun 27, 1972 · N8251 · Substantial damage NTSB MKC72FER68Accident · No injuriesClosedPiper PA-30 · Fergus Fls, MNJun 15, 1972 · N7573Y · Substantial damage NTSB MKC72FER66Accident · No injuriesClosedBeech H35 · Eden Prairie, MNJun 15, 1972 · N5436D · Substantial damage NTSB MKC72FER67Accident · No injuriesClosedCessna 172I · White Bar Lk, MNJun 14, 1972 · N46015 · Substantial damage NTSB MKC72FER64Accident · Serious injuriesClosedLuscombe 8A · Circle Pines, MNJun 10, 1972 · N71782 · Substantial damage NTSB MKC72DER65Accident · No injuriesClosedAmer Avco AA1A · Barnsville, MNJun 10, 1972 · N9250L · Substantial damage NTSB MKC73DER05Accident · No injuriesClosedCessna 140 · Princeton, MNJun 8, 1972 · N3577V · Substantial damage NTSB MKC72FER62Accident · Serious injuriesClosedAero Comdr A-9B · Mt.Lake, MNMay 26, 1972 · N7756V · Destroyed NTSB MKC72FER63Accident · No injuriesClosedN.American NA-265 · Minneapolis, MNMay 25, 1972 · N1903W · Substantial damage