Skip to content

NTSB investigations, MN

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 MKC68D0566Accident · No injuriesClosedCessna 170 · Watertown, MNFeb 12, 1968 · N9125A · Substantial damage NTSB MKC68F0470Accident · No injuriesClosedCessna 150 · Belle Plaine, MNFeb 10, 1968 · N6242T · Substantial damage NTSB MKC68D0436Accident · No injuriesClosedCessna 140 · Thief Rvr Fl, MNFeb 10, 1968 · CF-PJP · Substantial damage NTSB MKC68F0447Accident · No injuriesClosedPiper J3C-65 · Fergus Falls, MNFeb 4, 1968 · N7025B · Substantial damage NTSB MKC68D0489Accident · No injuriesClosedAeronca 7AC · Babbitt, MNJan 28, 1968 · N3446E · Substantial damage NTSB MKC68A0047Accident · 1 fatalClosedMooney M20E · Gary, MNJan 23, 1968 · N5707Q · Destroyed NTSB MKC68F0468Accident · No injuriesClosedMooney M-22 · Minneapolis, MNJan 16, 1968 · N7708M · Substantial damage NTSB MKC68D0429Accident · No injuriesClosedBeech A23 · Houston, MNJan 14, 1968 · N5986S · Substantial damage NTSB MKC68F0467Accident · No injuriesClosedPiper PA-28 · Anoka, MNJan 11, 1968 · N508UM · Substantial damage NTSB MKC68D0433Accident · No injuriesClosedCessna 150 · Duluth, MNDec 31, 1967 · N6230T · Substantial damage NTSB MKC68F0408Accident · No injuriesClosedBeech 95-B55 · Hibbing, MNDec 30, 1967 · N9574Y · Substantial damage NTSB MKC68F0469Accident · No injuriesClosedPiper PA-24 · Tamarack, MNDec 24, 1967 · N9118P · Substantial damage NTSB MKC68F0391Accident · Minor injuriesClosedCessna 150 · Rosemount, MNDec 16, 1967 · N2484J · Substantial damage NTSB MKC68F0428Accident · No injuriesClosedCessna 310B · St.Paul, MNDec 15, 1967 · N5347A · Substantial damage NTSB MKC68F0371Accident · No injuriesClosedNavion A · Willmar, MNDec 3, 1967 · N4861K · Substantial damage NTSB MKC68D0376Accident · No injuriesClosedCessna 150 · Wykoff, MNDec 3, 1967 · N8671J · Substantial damage NTSB MKC68F0393Accident · Serious injuriesClosedBeech A23 · Askov, MNNov 26, 1967 · N4726J · Substantial damage NTSB MKC68D0359Accident · No injuriesClosedPiper PA-28 · Grand Rapids, MNNov 24, 1967 · N507UM · Substantial damage NTSB MKC68F0363Accident · No injuriesClosedMooney 20E · Winsted, MNNov 19, 1967 · N5534Q · Substantial damage NTSB MKC68F0355Accident · Minor injuriesClosedAeronca 15AC · Markville, MNNov 19, 1967 · N1451H · Substantial damage NTSB MKC68D0357Accident · No injuriesClosedCessna 182 · Prior Lake, MNNov 18, 1967 · N3453F · Substantial damage NTSB MKC68F0335Accident · No injuriesClosedPiper PA-12 · Eden Prairie, MNNov 14, 1967 · N3017M · Substantial damage NTSB MKC68F0358Accident · No injuriesClosedCessna 172 · Hill City, MNNov 13, 1967 · N5686A · Substantial damage NTSB MKC68F0360Accident · No injuriesClosedPiper J-3 · St.Charles, MNNov 9, 1967 · N88173 · Substantial damage NTSB MKC68F0314Accident · No injuriesClosedPiper PA-28 · St.Peter, MNNov 9, 1967 · N6341R · Substantial damage NTSB MKC68D0356Accident · No injuriesClosedLuscombe 8A · Circle Pines, MNNov 9, 1967 · N71922 · Substantial damage NTSB MKC68F0333Accident · No injuriesClosedBeech 35 · Minneapolis, MNOct 30, 1967 · N3943N · Substantial damage NTSB MKC68F0311Accident · No injuriesClosedCessna 310 · Crystal, MNOct 28, 1967 · N659R · Substantial damage NTSB MKC68D0336Accident · No injuriesClosedAeronca 7AC · Buffalo, MNOct 23, 1967 · N82455 · Substantial damage NTSB MKC68F0273Accident · Minor injuriesClosedThorp T-18 · Anoka, MNOct 22, 1967 · N18117 · Substantial damage NTSB MKC68D0361Accident · No injuriesClosedLuscombe 8F · Brainerd, MNOct 21, 1967 · N1962B · Substantial damage NTSB MKC68D0276Accident · No injuriesClosedPiper PA-12 · Pipestone, MNOct 19, 1967 · N4061M · Substantial damage NTSB MKC68D0310Accident · No injuriesClosedChampion 7ECA · Caribou, MNOct 15, 1967 · N11040 · Substantial damage NTSB MKC68F0249Accident · No injuriesClosedMooney M20F · Callaway, MNOct 5, 1967 · N2918L · Substantial damage NTSB MKC68F0286Accident · No injuriesClosedBellanca 14-19 · Lake Elmo, MNOct 1, 1967 · N8511R · Substantial damage NTSB MKC68D0272Accident · No injuriesClosedCessna 150G · Worthington, MNSep 28, 1967 · N3365J · Substantial damage NTSB MKC68F0242Accident · Minor injuriesClosedCessna 172 · Green Isle, MNSep 24, 1967 · N6389E · Destroyed NTSB MKC68D0289Accident · No injuriesClosedPiper PA-28 · Crystal, MNSep 24, 1967 · N9282J · Substantial damage NTSB MKC68F0241Accident · Serious injuriesClosedCessna 170B · Howard Lake, MNSep 17, 1967 · N2806C · Substantial damage NTSB MKC68D0334Accident · No injuriesClosedCessna 140 · Fairmont, MNSep 17, 1967 · N73081 · Substantial damage NTSB MKC68F0262Accident · No injuriesClosedBeech A23 · Mankato, MNSep 16, 1967 · N8891M · Substantial damage NTSB MKC67F0453Accident · No injuriesClosedPiper PA-28 · Barnesville, MNSep 15, 1967 · N4131J · Substantial damage NTSB MKC68F0260Accident · No injuriesClosedPiper PA-18 · Minneapolis, MNSep 14, 1967 · N211T · Substantial damage NTSB MKC68F0261Accident · No injuriesClosedCessna 182 · Hopkins, MNSep 13, 1967 · N8873X · Substantial damage NTSB MKC68F0236Accident · Serious injuriesClosedErnst Eaa Biplan · Cambridge, MNSep 4, 1967 · N530C · Substantial damage NTSB MKC68F0228Accident · Minor injuriesClosedPiper PA-25 · Fairfax, MNSep 2, 1967 · N6985Z · Destroyed NTSB MKC68F0207Accident · No injuriesClosedTaylorcraft BC12-D · Crane Lake, MNSep 2, 1967 · N5290M · Substantial damage NTSB MKC68F0188Accident · No injuriesClosedStits SA3B · Owatonna, MNSep 2, 1967 · N1079Z · Substantial damage NTSB MKC68D0225Accident · No injuriesClosedPiper PA-22 · Bemidji, MNSep 2, 1967 · N8963D · Substantial damage NTSB MKC68F0204Accident · Minor injuriesClosedPiper PA-12 · Cloquet, MNAug 27, 1967 · N2453M · Destroyed