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 MKC65F0098Accident · No injuriesClosedPiper J-3 · Ellsworth, MNMar 7, 1965 · N3663K · Destroyed NTSB CHI65D0094Accident · No injuriesClosedPiper PA-28 · Crystal, MNMar 7, 1965 · N7971W · Substantial damage NTSB MKC65F0090Accident · No injuriesClosedCessna 140 · Aitkin, MNFeb 28, 1965 · N89164 · Destroyed NTSB MKC65F0037Accident · No injuriesClosedCessna 170B · New Ulm, MNFeb 20, 1965 · N1692D · Substantial damage NTSB MKC65F0035Accident · No injuriesClosedCessna 170B · Barnesville, MNFeb 18, 1965 · N3120A · Substantial damage NTSB MKC65D0086Accident · No injuriesClosedMooney 21 · Hopkins, MNFeb 18, 1965 · N7143U · Substantial damage NTSB MKC65D0055Accident · No injuriesClosedCessna 172 · Olivia, MNFeb 16, 1965 · N3282A · Substantial damage NTSB MKC65F0112Accident · No injuriesClosedCessna 172 · Rosemount, MNFeb 14, 1965 · N8722B · Substantial damage NTSB MKC65F0104Accident · No injuriesClosedChampion 7EC · Coon Rapids, MNFeb 7, 1965 · N9813Y · Substantial damage NTSB MKC65F0042Accident · No injuriesClosedPiper PA-22 · Bagley, MNFeb 6, 1965 · N2317P · Destroyed NTSB MKC65F0078Accident · No injuriesClosedCessna 172 · Hopkins, MNFeb 5, 1965 · N7748U · Substantial damage NTSB MKC65F0002Accident · No injuriesClosedPiper PA-24 · Lake Elmo, MNJan 28, 1965 · N5981P · Substantial damage NTSB MKC65D0014Accident · No injuriesClosedMooney 20D · Brookston, MNJan 27, 1965 · N6793U · Substantial damage NTSB MKC65F0101Accident · No injuriesClosedBeechcraft B-35 · Big Fork, MNJan 21, 1965 · N5079C · Substantial damage NTSB MKC65D0099Accident · No injuriesClosedMaule M-4 · Mcgregor, MNJan 20, 1965 · N4728T · Substantial damage NTSB MKC65D0022Accident · No injuriesClosedPiper PA-11 · Redwood Falls, MNJan 18, 1965 · N4643M · Substantial damage NTSB MKC65F0091Accident · No injuriesClosedCessna 170 · Minneapolis, MNJan 16, 1965 · N3852V · Substantial damage NTSB MKC65F0009Accident · No injuriesClosedCessna 170 · Isle, MNJan 16, 1965 · N3803V · Substantial damage NTSB UNK65X1289Accident · No injuriesClosedChampion 7EC · Cambridge, MNJan 14, 1965 · N4837E · Substantial damage NTSB MKC65F0031Accident · No injuriesClosedPiper PA-20 · Bemidji, MNJan 4, 1965 · N7020K · Substantial damage NTSB MKC65F0019Accident · No injuriesClosedCessna 172 · Crystal, MNJan 2, 1965 · N8264B · Substantial damage NTSB UNK65X1141Accident · No injuriesClosedPiper PA22 · Silver Lake, MNDec 26, 1964 · N5931D · Substantial damage NTSB UNK65X1140Accident · No injuriesClosedCessna 180 · So St Paul, MNDec 26, 1964 · N3138S · Substantial damage NTSB UNK65X1105Accident · 1 fatalClosedPiper PA-22 · Winona, MNDec 23, 1964 · N3142Z · Destroyed NTSB UNK65X1093Accident · 3 fatalClosedBeechcraft 95-B55 · Good Thunder, MNDec 22, 1964 · N8849M · Destroyed NTSB UNK65X1072Accident · No injuriesClosedPiper PA22 · St Cloud, MNDec 20, 1964 · N8814C · Substantial damage NTSB UNK65X1070Accident · No injuriesClosedAeronca 11AC · Gerogetown, MNDec 20, 1964 · N85906 · Substantial damage NTSB UNK65X1054Accident · No injuriesClosedAeronca 7GCM · Cloquet, MNDec 19, 1964 · N82067 · Substantial damage NTSB UNK65X1012Accident · No injuriesClosedPiper PA12 · Littlefork, MNDec 14, 1964 · N2624M · Substantial damage NTSB UNK65X0995Accident · No injuriesClosedCessna 170A · Rosemount, MNDec 13, 1964 · N9965A · Substantial damage NTSB UNK65X0969Accident · Serious injuriesClosedAeronca 7AC · Le Sueur, MNDec 10, 1964 · N7946A · Substantial damage NTSB UNK65X0955Accident · No injuriesClosedCessna 310B · Hopkins, MNDec 8, 1964 · N547M · Substantial damage NTSB UNK65X0781Accident · No injuriesClosedPiper PA22 · Sleepy Eye, MNNov 21, 1964 · N1645P · Substantial damage NTSB UNK65X0689Accident · No injuriesClosedCessna 180 · St Paul, MNNov 13, 1964 · N4751U · Substantial damage NTSB UNK65X0667Accident · No injuriesClosedBeechcraft 35B33 · Minneapolis, MNNov 12, 1964 · N1700G · Substantial damage NTSB UNK65X0658Accident · No injuriesClosedCessna 150 · Minneapolis, MNNov 11, 1964 · N6173T · Minor damage NTSB UNK65X0611Accident · No injuriesClosedCessna 180 · Leech Lake, MNNov 8, 1964 · N4648A · Substantial damage NTSB UNK65X0585Accident · 1 fatalClosedCessna 170B · Wabasso, MNNov 6, 1964 · N8355A · Destroyed NTSB UNK65X0567Accident · Minor injuriesClosedErcoupe 415C · Isle, MNNov 5, 1964 · N99080 · Substantial damage NTSB UNK65X0547Accident · Serious injuriesClosedHughes 269B · Owatonna, MNNov 3, 1964 · N9326F · Destroyed NTSB UNK65X0528Accident · No injuriesClosedCessna 182 · Anoka, MNNov 2, 1964 · N3193S · Substantial damage NTSB UNK65X0441Accident · 1 fatalClosedBeechcraft N-35 · Brainerd, MNOct 25, 1964 · N9977R · Substantial damage NTSB UNK65X0417Accident · Minor injuriesClosedGrumman F6F5 · Minneapolis, MNOct 25, 1964 · N1078Z · Substantial damage NTSB UNK65X0247Accident · 5 fatalClosedMooney M-20A · Cambridge, MNOct 11, 1964 · N6063X · Destroyed NTSB UNK65X0237Accident · Minor injuriesClosedPiper PA18A · Fergus Falls, MNOct 11, 1964 · N1306A · Substantial damage NTSB UNK65X0208Accident · No injuriesClosedPiper PA28 · Duluth, MNOct 9, 1964 · N8769W · Substantial damage NTSB UNK65X0168Accident · No injuriesClosedPiper J5A · Stanton, MNOct 6, 1964 · N30849 · Substantial damage NTSB UNK64X4187Accident · No injuriesClosedStinson 108 · Grand Portage, MNSep 27, 1964 · N6630M · Substantial damage NTSB UNK64X4152Accident · No injuriesClosedCessna 182 · Murdock, MNSep 26, 1964 · N4966E · Substantial damage NTSB UNK64X4140Accident · No injuriesClosedLuscombe 8F · Isabella, MNSep 25, 1964 · N1475B · Substantial damage