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 MKC72DER61Accident · No injuriesClosedAeronca 7AC · Buffalo, MNMay 20, 1972 · N2786E · Substantial damage NTSB MKC72FER60Accident · Minor injuriesClosedCessna 140 · Albert Lea, MNMay 19, 1972 · N2085N · Substantial damage NTSB MKC72AK062Accident · Minor injuriesClosedPiper PA-28 · Anoka, MNMay 18, 1972 · N502UM · Substantial damage NTSB MKC72FER59Accident · No injuriesClosedChampion 7FC · Mankato, MNMay 16, 1972 · N9988Y · Substantial damage NTSB MKC72DER58Accident · No injuriesClosedCessna 170A · Anoka, MNMay 6, 1972 · N1403D · Substantial damage NTSB MKC72FER57Accident · No injuriesClosedBeech V35 · So.St.Paul, MNMay 3, 1972 · N2798T · Substantial damage NTSB MKC72DER56Accident · No injuriesClosedPiper PA-22 · Morris, MNApr 19, 1972 · N4639Z · Substantial damage NTSB CHI72IC084Incident · No injuriesClosedBoeing 727 · Minneapolis, MNApr 19, 1972 · N7061U · No damage NTSB MKC72DER54Accident · No injuriesClosedCessna 180 · Circle Pines, MNApr 16, 1972 · N9359C · Substantial damage NTSB MKC72FER55Accident · No injuriesClosedCessna 150K · Osseo, MNApr 15, 1972 · N5918J · Substantial damage NTSB MKC72FER53Accident · No injuriesClosedPiper PA-24 · Lake Elmo, MNApr 7, 1972 · N5183P · Substantial damage NTSB MKC72FER51Accident · No injuriesClosedMooney M-20A · Mankato, MNApr 3, 1972 · N1095C · Substantial damage NTSB MKC72DER49Accident · No injuriesClosedPiper PA-12 · Duluth, MNApr 1, 1972 · N3752M · Substantial damage NTSB MKC72DER48Accident · No injuriesClosedCessna 170A · Anoka, MNApr 1, 1972 · N9707A · Substantial damage NTSB MKC72FER45Accident · No injuriesClosedBeech 65-80 · Mankato, MNMar 26, 1972 · N270D · Substantial damage NTSB MKC72DER50Accident · No injuriesClosedCessna 170B · Lake Elmo, MNMar 25, 1972 · N8214A · Substantial damage NTSB MKC72DER46Accident · No injuriesClosedAmer Avco AA1 · Stanton, MNMar 25, 1972 · N5980L · Substantial damage NTSB MKC72AK056Accident · 1 fatalClosedBeech V35 · Worthington, MNMar 21, 1972 · N9407S · Destroyed NTSB NYC72DKM24Accident · No injuriesClosedCessna 150K · Bruno, MNMar 20, 1972 · N561GS · Substantial damage NTSB MKC72FER47Accident · No injuriesClosedStinson 108-2 · Rosemont, MNMar 18, 1972 · N9256K · Substantial damage NTSB MKC72FER43Accident · No injuriesClosedCessna 150 · Crystal, MNFeb 27, 1972 · N6472S · Substantial damage NTSB MKC72DER44Accident · No injuriesClosedCessna U206 · Maple Plain, MNFeb 26, 1972 · N9472G · Substantial damage NTSB MKC72DER42Accident · No injuriesClosedCessna 195 · Stewartville, MNFeb 20, 1972 · N1533D · Substantial damage NTSB MKC72FER40Accident · No injuriesClosedPiper PA-28 · Faribault, MNFeb 12, 1972 · N9071J · Substantial damage NTSB MKC72DER41Accident · No injuriesClosedCessna 150F · Princeton, MNFeb 12, 1972 · N8918S · Substantial damage NTSB MKC72DER36Accident · No injuriesClosedPiper PA-12 · Silver Bay, MNFeb 5, 1972 · N7644H · Substantial damage NTSB MKC72FER37Accident · Serious injuriesClosedCessna 210K · Duluth, MNFeb 4, 1972 · N9468M · Substantial damage NTSB MKC72FER38Accident · No injuriesClosedPiper PA-28R · Hopkins, MNFeb 3, 1972 · N7576J · Substantial damage NTSB MKC72DER39Accident · No injuriesClosedCessna 180H · Baudette, MNJan 31, 1972 · N3437Y · Substantial damage NTSB MKC72AK045Accident · No injuriesClosedBell 206A · Walker, MNJan 26, 1972 · N2502M · Minor damage NTSB MKC72DER35Accident · No injuriesClosedCessna 172H · Dodge Center, MNJan 12, 1972 · N8801Z · Substantial damage NTSB MKC72AK044Accident · No injuriesClosedPiper PA-28 · Fergus Falls, MNJan 11, 1972 · N2952R · Substantial damage NTSB MKC72DER33Accident · No injuriesClosedCessna 150L · Wht Br Lake, MNDec 22, 1971 · N1601Q · Substantial damage NTSB MKC72FER34Accident · No injuriesClosedCessna 172E · Walker, MNDec 18, 1971 · N3599S · Substantial damage NTSB MKC72FER31Accident · No injuriesClosedCessna 421 · Crystal, MNDec 7, 1971 · N4018L · Substantial damage NTSB MKC72DER32Accident · No injuriesClosedCessna 150G · Lesueur, MNDec 5, 1971 · N2434J · Substantial damage NTSB MKC72AK033Accident · 1 fatalClosedAero Comdr 100 · Albert Lea, MNDec 2, 1971 · N4176X · Destroyed NTSB MKC72FER29Accident · Minor injuriesClosedCessna 182M · Belview, MNDec 1, 1971 · N91834 · Substantial damage NTSB MKC72FER30Accident · Serious injuriesClosedPiper PA-18 · Gilman, MNNov 21, 1971 · N4316Z · Substantial damage NTSB MKC72FER26Accident · 1 fatalClosedKnutson B8M · St.Paul, MNNov 13, 1971 · N34DK · Destroyed NTSB MKC72DER27Accident · No injuriesClosedAeronca L-16 · Lakeville, MNNov 13, 1971 · N6040V · Substantial damage NTSB MKC72DER28Accident · No injuriesClosedCessna 150H · Preston, MNNov 10, 1971 · N22182 · Substantial damage NTSB CHI83FA225Accident · 3 fatalClosedCessna 185 · Hovland, MNOct 26, 1971 · N9881X · Destroyed NTSB MKC72DER24Accident · No injuriesClosedBeech 19A · Blue Earth, MNOct 9, 1971 · N7682R · Substantial damage NTSB MKC72DER25Accident · No injuriesClosedMooney M20C · Walnut Grove, MNOct 8, 1971 · N6558U · Substantial damage NTSB MKC72FER21Accident · Serious injuriesClosedPiper PA-22 · Isle, MNSep 19, 1971 · N5798Z · Substantial damage NTSB MKC72DER23Accident · No injuriesClosedCessna 140 · Delavan, MNSep 17, 1971 · N2748N · Substantial damage NTSB MKC72DER22Accident · Minor injuriesClosedCessna 150J · Bemidji, MNSep 17, 1971 · N51228 · Substantial damage NTSB MKC72FER20Accident · No injuriesClosedPiper PA-28 · Duluth, MNSep 12, 1971 · N95112 · Destroyed NTSB MKC72DER19Accident · No injuriesClosedCessna 172I · Crosby, MNAug 28, 1971 · N35375 · Substantial damage