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 MKC69F0376Accident · Serious injuriesClosedCessna 337 · Bloomington, MNFeb 25, 1969 · N2328S · Substantial damage NTSB MKC69D0346Accident · No injuriesClosedBeech J35 · Austin, MNFeb 16, 1969 · N644T · Substantial damage NTSB MKC69D0390Accident · No injuriesClosedPiper PA-16 · Mcgregor, MNFeb 9, 1969 · N5994H · Substantial damage NTSB MKC69F0366Accident · No injuriesClosedCessna 401 · Minneapolis, MNFeb 6, 1969 · N4073Q · Substantial damage NTSB MKC69D0345Accident · No injuriesClosedCessna 150 · Eden Praire, MNFeb 4, 1969 · N22182 · Substantial damage NTSB MKC69F0370Accident · No injuriesClosedPiper J3F-65 · Sargeant, MNJan 26, 1969 · N38438 · Substantial damage NTSB MKC69D0359Accident · No injuriesClosedCessna 402 · Crystal, MNJan 21, 1969 · N4032Q · Substantial damage NTSB MKC69D0337Accident · No injuriesClosedChampion 7GC · Windom, MNJan 18, 1969 · N9607S · Substantial damage NTSB MKC69D0325Accident · No injuriesClosedAeronca 7AC · Clitherall, MNJan 17, 1969 · N3340E · Substantial damage NTSB MKC69F0369Accident · Minor injuriesClosedBell 206A · Duluth, MNJan 16, 1969 · N4723R · Substantial damage NTSB MKC69F0321Accident · Minor injuriesClosedBeech S35 · Mankato, MNJan 13, 1969 · N1727W · Substantial damage NTSB MKC69D0313Accident · No injuriesClosedPiper PA-28 · Lakeville, MNJan 6, 1969 · N7450W · Substantial damage NTSB MKC69D0329Accident · No injuriesClosedPiper PA-28 · Anoka, MNJan 3, 1969 · N506UM · Substantial damage NTSB MKC69D0312Accident · No injuriesClosedLuscombe 8A · Lake Elmo, MNJan 1, 1969 · N71800 · Substantial damage NTSB MKC69D0333Accident · No injuriesClosedCessna 150 · Eden Prairie, MNDec 29, 1968 · N6825F · Substantial damage NTSB MKC69D0348Accident · No injuriesClosedTaylorcraft BC-12D · Shevlin, MNDec 21, 1968 · N43612 · Substantial damage NTSB MKC69D0310Accident · No injuriesClosedCessna 170B · Mound, MNDec 20, 1968 · N8004A · Substantial damage NTSB MKC69A0038Accident · 2 fatalClosedPiper PA-22 · Morris, MNDec 14, 1968 · N9533D · Destroyed NTSB MKC69D0291Accident · No injuriesClosedCessna 150 · Eden Prairie, MNDec 4, 1968 · N23371 · Substantial damage NTSB MKC69A0035Accident · 4 fatalClosedMooney M20E · Rochester, MNNov 24, 1968 · N5965Q · Destroyed NTSB MKC69A0032Accident · No injuriesClosedLockheed 188 · Minneapolis, MNNov 19, 1968 · N1284S · No damage NTSB MKC69D0273Accident · No injuriesClosedBeech A23-19 · Lake Elmo, MNNov 14, 1968 · N4769J · Substantial damage NTSB MKC69D0265Accident · No injuriesClosedCessna 150 · Anoka, MNNov 8, 1968 · N8523J · Substantial damage NTSB MKC69A0028Accident · No injuriesClosedBeech D18S · Alexandria, MNNov 4, 1968 · N203W · Substantial damage NTSB MKC69F0278Accident · Minor injuriesClosedCessna 206 · Albert Lea, MNNov 3, 1968 · N2617X · 2 aircraft · Substantial damage NTSB MKC69D0294Accident · No injuriesClosedCessna 180A · Waverly, MNOct 29, 1968 · N7819A · Substantial damage NTSB MKC69F0237Accident · No injuriesClosedBensen B8-M · Anoka, MNOct 21, 1968 · N1802 · Substantial damage NTSB MKC69D0246Accident · No injuriesClosedCessna 170 · Almelund, MNOct 19, 1968 · N2632V · Substantial damage NTSB MKC6.A0026Accident · 2 fatalClosedBeech T-34A · Glencoe, MNOct 16, 1968 · N10586 · Destroyed NTSB MKC69F0218Accident · Serious injuriesClosedTaylorcraft BC12-D · Starbuck, MNOct 13, 1968 · N96035 · Minor damage NTSB MKC69F0244Accident · Minor injuriesClosedCessna 177 · Whte Bear Lk, MNOct 12, 1968 · N2210Y · Substantial damage NTSB MKC69D0378Accident · No injuriesClosedCessna 150 · Avon, MNOct 10, 1968 · N3877J · Substantial damage NTSB CHI69A0039Accident · 1 fatalClosedTaylorcraft BC12-D · Ogilvie, MNOct 10, 1968 · N96557 · Destroyed NTSB MKC69F0277Accident · No injuriesClosedPiper PA-12 · Bagley, MNOct 6, 1968 · N2995M · Substantial damage NTSB MKC68F0242Accident · Minor injuriesClosedPiper PA-28 · Mabel, MNSep 24, 1968 · N1577J · Destroyed NTSB MKC69D0190Accident · No injuriesClosedPiper PA-12 · Eden Prairie, MNSep 20, 1968 · N3007M · Substantial damage NTSB MKC69A0014Accident · 1 fatalClosedPiper PA-24 · Stewartville, MNSep 20, 1968 · N8425P · Destroyed NTSB MKC69D0318Accident · No injuriesClosedCessna 170 · Bemidji, MNSep 11, 1968 · N5410C · Substantial damage NTSB MKC69D0176Accident · No injuriesClosedCessna 172 · Walker, MNSep 8, 1968 · N35519 · Substantial damage NTSB MKC68A0013Accident · 1 fatalClosedPiper PA-22 · Lake Benton, MNSep 8, 1968 · N6827B · Destroyed NTSB MKC69D0196Accident · No injuriesClosedPiper PA-28 · Ely, MNSep 7, 1968 · N9725J · Substantial damage NTSB MKC69D0192Accident · No injuriesClosedPiper PA-22 · Holdingford, MNSep 2, 1968 · N1335C · Substantial damage NTSB MKC69F0227Accident · No injuriesClosedBeech B23 · Pequot Lakes, MNAug 31, 1968 · N2388Q · Substantial damage NTSB MKC69F0134Accident · No injuriesClosedCurtiss MR-1 · Eden Prairie, MNAug 29, 1968 · N91258 · Substantial damage NTSB MKC69F0135Accident · No injuriesClosedAero Comdr 680T · Minneapolis, MNAug 27, 1968 · N7610U · Substantial damage NTSB MKC69F0078Accident · No injuriesClosedBell 47G-5 · Glencoe, MNAug 26, 1968 · N7870S · Substantial damage NTSB MKC69D0226Accident · No injuriesClosedBeech A23-19 · Stanton, MNAug 25, 1968 · N6971Q · Substantial damage NTSB MKC69F0090Accident · No injuriesClosedPiper PA-22 · Pequot Lakes, MNAug 20, 1968 · N806A · Substantial damage NTSB MKC69F0066Accident · No injuriesClosedCessna 177 · Minneapolis, MNAug 19, 1968 · N2233Y · Substantial damage NTSB MKC69D0183Accident · No injuriesClosedPiper PA-18 · New Ulm, MNAug 19, 1968 · N3695P · Substantial damage