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 UNK64X4067Accident · No injuriesClosedBeechcraft 23 · St Paul, MNSep 20, 1964 · N2349L · Substantial damage NTSB UNK64X4031Accident · No injuriesClosedPiper PA22 · Marshall, MNSep 18, 1964 · N5436Z · Substantial damage NTSB UNK64X3993Accident · No injuriesClosedPiper PA22 · Gaylord, MNSep 15, 1964 · N3265Z · Substantial damage NTSB UNK64X3973Accident · No injuriesClosedCessna 140 · Rosemount, MNSep 13, 1964 · N72393 · Substantial damage NTSB UNK64X3878Accident · 1 fatalClosedBeechcraft D-18S · Deer River, MNSep 8, 1964 · N800UA · Destroyed NTSB UNK64X3863Accident · Serious injuriesClosedBoeing B-720 · Minneapolis, MNSep 7, 1964 · N736US · Minor damage NTSB UNK64X3840Accident · No injuriesClosedPiper PA20 · Grove City, MNSep 7, 1964 · N7717K · Substantial damage NTSB UNK64X3751Accident · No injuriesClosedCessna 180 · Circle Pines, MNSep 3, 1964 · N5318D · Substantial damage NTSB UNK64X3705Accident · Serious injuriesClosedPiper PA25 · Prior Lake, MNAug 31, 1964 · N6276Z · Substantial damage NTSB UNK64X3652Accident · No injuriesClosedCessna 310H · Hopkins, MNAug 28, 1964 · N1042Q · Substantial damage NTSB UNK64X3566Accident · Serious injuriesClosedCessna 140 · Virginia, MNAug 23, 1964 · CF-KWH · Substantial damage NTSB UNK64X3523Accident · Serious injuriesClosedBarnes 65A · Minneapolis, MNAug 21, 1964 · N4633T · Minor damage NTSB UNK64X3422Accident · No injuriesClosedCessna 170 · East Bethel, MNAug 16, 1964 · N1242D · Destroyed NTSB UNK64X3389Accident · No injuriesClosedCessna 150 · Bowlus, MNAug 15, 1964 · N7379X · Substantial damage NTSB UNK64X3353Accident · No injuriesClosedBoeing A75N1 · Waseca, MNAug 13, 1964 · N64514 · Substantial damage NTSB UNK64X3194Accident · No injuriesClosedCessna 140 · Minneapolis, MNAug 3, 1964 · N76346 · Destroyed NTSB UNK64X3181Accident · No injuriesClosedLake LA4 · Lake Elmo, MNAug 2, 1964 · N1128L · Substantial damage NTSB UNK64X2970Accident · No injuriesClosedBeechcraft P35 · Faribault, MNJul 22, 1964 · N8675M · Substantial damage NTSB UNK64X2927Accident · No injuriesClosedCessna 310B · Grand Rapids, MNJul 19, 1964 · N4379U · Substantial damage NTSB UNK64X2907Accident · No injuriesClosedCessna 150 · Oslo, MNJul 18, 1964 · N7336X · Substantial damage NTSB UNK64X2888Accident · Serious injuriesClosedBeechcraft 35A33 · Int L Falls, MNJul 17, 1964 · N494T · Substantial damage NTSB UNK64X2859Accident · No injuriesClosedTaylorcraft BC12D · Lax Lake, MNJul 16, 1964 · N96646 · Substantial damage NTSB UNK64X2793Accident · Minor injuriesClosedBellanca 14133 · Maynard, MNJul 12, 1964 · N6523N · Substantial damage NTSB UNK64X2760Accident · No injuriesClosedChampion 7EC · New Ulm, MNJul 11, 1964 · N9878B · Substantial damage NTSB UNK64X2729Accident · Minor injuriesClosedChampion 7FC · Blaine, MNJul 9, 1964 · N7501B · Substantial damage NTSB UNK64X2670Accident · Minor injuriesClosedCessna 180 · Crystal, MNJul 5, 1964 · N9171T · Destroyed NTSB UNK64X2641Accident · No injuriesClosedPiper PA22 · Faribault, MNJul 4, 1964 · N7053B · Substantial damage NTSB UNK64X2623Accident · Serious injuriesClosedBell 47G2 · Lake Lillian, MNJul 3, 1964 · N262MV · Destroyed NTSB UNK64X2546Accident · No injuriesClosedPiper PA12 · Mound, MNJun 28, 1964 · N3977M · Substantial damage NTSB UNK64X2526Accident · No injuriesClosedPiper PA-18A · Angus, MNJun 27, 1964 · N2585A · Substantial damage NTSB UNK64X2501Accident · No injuriesClosedPiper PA24 · Winona, MNJun 26, 1964 · N8429P · Substantial damage NTSB UNK64X2494Accident · No injuriesClosedPiper PA11 · Sherack, MNJun 26, 1964 · N78678 · Substantial damage NTSB UNK64X2450Accident · Minor injuriesClosedMooney MK20 · Parker Prarie, MNJun 23, 1964 · N6467U · Substantial damage NTSB UNK64X2401Accident · 3 fatalClosedHughes 269B · Coon Rapids, MNJun 20, 1964 · N9324F · Destroyed NTSB UNK64X2398Accident · No injuriesClosedPiper PA18 · Sleepy Eye, MNJun 20, 1964 · N2421A · Substantial damage NTSB UNK64X2372Accident · Minor injuriesClosedAeronca 15AC · Minneapolis, MNJun 19, 1964 · N1203H · Substantial damage NTSB UNK64X2328Accident · No injuriesClosedTaylorcraft BC12D · Lake George, MNJun 17, 1964 · N96276 · Substantial damage NTSB UNK64X2229Accident · No injuriesClosedPiper PA23 · Marshall, MNJun 11, 1964 · N5455Y · Substantial damage NTSB UNK64X2192Accident · Minor injuriesClosedCessna 150 · Hopkins, MNJun 8, 1964 · N7827Z · Destroyed NTSB UNK64X2167Accident · Minor injuriesClosedCessna 170A · Roseau, MNJun 7, 1964 · N9570A · Substantial damage NTSB UNK64X2140Accident · No injuriesClosedCessna 170 · Montevideo, MNJun 6, 1964 · N2601V · Substantial damage NTSB UNK64X2047Accident · No injuriesClosedCessna 175 · Wells, MNMay 31, 1964 · N9385B · Substantial damage NTSB UNK64X1954Accident · No injuriesClosedCessna 172D · St James, MNMay 25, 1964 · N2447U · Substantial damage NTSB UNK64X1875Accident · Minor injuriesClosedStinson 108-3 · Isabelle, MNMay 22, 1964 · N6937M · Substantial damage NTSB UNK64X1751Accident · No injuriesClosedBeechcraft D18S · Minneapolis, MNMay 13, 1964 · N1555V · Substantial damage NTSB UNK64X1694Accident · No injuriesClosedPiper J3 · Minneapolis, MNMay 10, 1964 · N33023 · Substantial damage NTSB UNK64X1651Accident · No injuriesClosedBeechcraft G35 · St Paul, MNMay 7, 1964 · N151B · Substantial damage NTSB UNK64X1600Accident · No injuriesClosedPiper PA22 · Windom, MNMay 3, 1964 · N1395C · Substantial damage NTSB UNK64X1578Accident · No injuriesClosedPiper PA12 · Anoka, MNMay 2, 1964 · N78546 · Substantial damage NTSB UNK64X1574Accident · No injuriesClosedBeechcraft T34 · Brainerd, MNMay 2, 1964 · N7718B · Substantial damage