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 MKC71FDM11Accident · No injuriesClosedCessna 320 · Sprg Lake Pk, MNJul 9, 1970 · N5783X · Substantial damage NTSB MKC71DDM05Accident · No injuriesClosedCessna 150F · Lincoln, MNJul 8, 1970 · N6485F · Substantial damage NTSB MKC71DDM08Accident · No injuriesClosedPiper PA-28 · Marshall, MNJul 7, 1970 · N6302R · Substantial damage NTSB MKC71FDM06Accident · Minor injuriesClosedPiper PA-22 · Two Harbors, MNJul 5, 1970 · N1305C · Substantial damage NTSB MKC71DDM03Accident · No injuriesClosedCessna C-34 · Pennock, MNJul 5, 1970 · N12599 · 2 aircraft · Substantial damage NTSB MKC71DDM02Accident · No injuriesClosedCessna U206 · Jordan, MNJul 5, 1970 · N3430L · Substantial damage NTSB MKC71FDM07Accident · No injuriesClosedBeech D18S · St.Paul, MNJul 3, 1970 · N8615A · Substantial damage NTSB MKC71DDM09Accident · No injuriesClosedCessna 172H · Pequot Lakes, MNJul 2, 1970 · N3246L · Substantial damage NTSB MKC70FDM37Accident · No injuriesClosedChampion S7EC · Cambridge, MNJun 20, 1970 · N7434B · Substantial damage NTSB MKC70FDM36Accident · No injuriesClosedCessna 150F · Crystal, MNJun 20, 1970 · N7936F · Substantial damage NTSB MKC70DDM35Accident · No injuriesClosedCessna 172G · Lakeville, MNJun 17, 1970 · N4312L · Substantial damage NTSB MKC70FDM34Accident · No injuriesClosedHughes 269A · Vesta, MNJun 16, 1970 · N8867F · Destroyed NTSB MKC70FDM32Accident · No injuriesClosedBeech 35-33 · Rochester, MNJun 9, 1970 · N615V · Substantial damage NTSB MKC70FDD20Accident · No injuriesClosedPiper PA-18 · Rothsay, MNJun 6, 1970 · N4878A · Substantial damage NTSB MKC70DDM33Accident · No injuriesClosedCessna 180B · Grand Rapids, MNJun 5, 1970 · N5168E · Substantial damage NTSB MKC70AK068Accident · No injuriesClosedBeech E18S · Detroit Lake, MNJun 1, 1970 · N221H · Substantial damage NTSB MKC70FDM28Accident · Minor injuriesClosedCessna 150H · Crystal, MNMay 30, 1970 · N23399 · Substantial damage NTSB MKC70DDM29Accident · No injuriesClosedBeech A23 · Lake Elmo, MNMay 28, 1970 · N2354W · Substantial damage NTSB MKC70DDM31Accident · No injuriesClosedAeronca 7AC · Lydia, MNMay 25, 1970 · N82117 · Substantial damage NTSB MKC70DDM21Accident · No injuriesClosedCessna 206 · Intl Falls, MNMay 22, 1970 · N8015Z · Substantial damage NTSB MKC70FDD13Accident · No injuriesClosedPiper PA-18 · Laporte, MNMay 16, 1970 · N5760D · Substantial damage NTSB MKC70FDM26Accident · No injuriesClosedPiaggio P136L1 · White Br Lke, MNMay 13, 1970 · N40026 · Substantial damage NTSB MKC70FDM25Accident · No injuriesClosedCessna 337C · Eden Prairie, MNMay 7, 1970 · N7675F · Substantial damage NTSB MKC70FDM24Accident · No injuriesClosedCessna 140 · Eden Prairie, MNMay 4, 1970 · N72393 · Substantial damage NTSB MKC71DDM18Accident · Minor injuriesClosedHughes 269B · Crosby, MNMay 2, 1970 · N9487F · Substantial damage NTSB MKC70FDM22Accident · No injuriesClosedRhein RW3B · Minneapolis, MNApr 27, 1970 · N111ZZ · Substantial damage NTSB MKC70DDM23Accident · No injuriesClosedPiper J3C · Jackson, MNApr 24, 1970 · N33237 · Substantial damage NTSB MKC70FDM20Accident · No injuriesClosedBell 206A · Saginaw, MNApr 22, 1970 · N4719R · Substantial damage NTSB MKC70AK055Accident · Minor injuriesClosedAeronca 7AC · So.St.Paul, MNApr 11, 1970 · N1883E · 2 aircraft · Substantial damage NTSB MKC70DDM19Accident · Minor injuriesClosedCessna 150 · Lake Elmo, MNApr 10, 1970 · N50693 · Substantial damage NTSB MKC70DDM16Accident · No injuriesClosedLuscombe 8A · Winsted, MNApr 5, 1970 · N1456B · Substantial damage NTSB MKC70DDM18Accident · No injuriesClosedCessna 150J · Willmar, MNApr 4, 1970 · N51179 · Substantial damage NTSB MKC70DDM17Accident · No injuriesClosedBeech 56TC · Rochester, MNApr 4, 1970 · N7890R · Substantial damage NTSB MKC70DDM15Accident · No injuriesClosedCessna 150 · Cambridge, MNMar 30, 1970 · N7881Z · Destroyed NTSB MKC70FDM14Accident · No injuriesClosedCessna 150 · Lakeville, MNMar 27, 1970 · N23114 · Substantial damage NTSB MKC70FDM13Accident · No injuriesClosedBeech 65-A80 · Eden Prairie, MNMar 19, 1970 · N887T · Substantial damage NTSB MKC70DDM12Accident · No injuriesClosedMooney M20E · Anoka, MNMar 19, 1970 · N6980U · Substantial damage NTSB MKC70DDM11Accident · No injuriesClosedCessna 150J · Winona, MNFeb 23, 1970 · N61182 · Substantial damage NTSB MKC70DDM10Accident · No injuriesClosedPiper PA-22 · Rosemount, MNFeb 21, 1970 · N3619Z · Substantial damage NTSB MKC70DDM04Accident · No injuriesClosedCessna 150 · St.Paul, MNFeb 8, 1970 · N3085S · Substantial damage NTSB MKC70FDM08Accident · No injuriesClosedCessna 150G · Crystal, MNFeb 6, 1970 · N8680J · Substantial damage NTSB MKC70FDM09Accident · No injuriesClosedBensen B-8M · Lake Elmo, MNJan 31, 1970 · N1802 · Substantial damage NTSB MKC70FDM07Accident · No injuriesClosedCessna 140 · Onamia, MNJan 31, 1970 · N4243N · Substantial damage NTSB MKC70DDM06Accident · No injuriesClosedCessna 150 · W Bear Lake, MNJan 31, 1970 · N6231S · Substantial damage NTSB MKC70DDM05Accident · No injuriesClosedCessna 180 · Minneapolis, MNJan 31, 1970 · N9310C · Substantial damage NTSB MKC70AK040Accident · 2 fatalClosedAeronca 7AC · Motley, MNJan 31, 1970 · N84969 · Destroyed NTSB MKC70FDM03Accident · No injuriesClosedDehavilland DHC-2 · Ely, MNJan 21, 1970 · N11255 · Substantial damage NTSB MKC70DDM01Accident · No injuriesClosedBeech 60 · Duluth, MNJan 12, 1970 · N7334D · Substantial damage NTSB MKC70IK038Incident · No injuriesClosedBoeing 720B · Minneapolis, MNJan 8, 1970 · N93144 · Minor damage NTSB MKC70DDM02Accident · No injuriesClosedPiper PA-28 · St.Cloud, MNJan 7, 1970 · N5610U · Substantial damage