NTSB investigations, 1964, MN

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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.

Cases per year

19642026
NTSB investigations, 1964, MN per year, 1964–2026: 3,233 cases
1964113
1965115
1966117
1967130
196895
1969113
197088
197180
197282
197377
197483
197598
197678
197792
197898
197976
198066
198189
198261
198368
198451
198557
198643
198740
198852
198950
199042
199159
199225
199340
199439
199537
199640
199737
199836
199933
200039
200140
200246
200340
200432
200531
200629
200725
200831
200929
201032
201128
201228
201333
201424
201515
201626
201720
201814
201916
202026
202112
202224
202334
202424
202522
202613

Latest cases

Query with SQL
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 year(c.\"eventDate\") = 1964
    AND 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.

NTSB UNK65X1141Accident · No injuriesClosedPiper PA22 · Silver Lake, MNDec 26, 1964 · N5931D · Substantial damageNTSB UNK65X1140Accident · No injuriesClosedCessna 180 · So St Paul, MNDec 26, 1964 · N3138S · Substantial damageNTSB UNK65X1105Accident · 1 fatalClosedPiper PA-22 · Winona, MNDec 23, 1964 · N3142Z · DestroyedNTSB UNK65X1093Accident · 3 fatalClosedBeechcraft 95-B55 · Good Thunder, MNDec 22, 1964 · N8849M · DestroyedNTSB UNK65X1072Accident · No injuriesClosedPiper PA22 · St Cloud, MNDec 20, 1964 · N8814C · Substantial damageNTSB UNK65X1070Accident · No injuriesClosedAeronca 11AC · Gerogetown, MNDec 20, 1964 · N85906 · Substantial damageNTSB UNK65X1054Accident · No injuriesClosedAeronca 7GCM · Cloquet, MNDec 19, 1964 · N82067 · Substantial damageNTSB UNK65X1012Accident · No injuriesClosedPiper PA12 · Littlefork, MNDec 14, 1964 · N2624M · Substantial damageNTSB UNK65X0995Accident · No injuriesClosedCessna 170A · Rosemount, MNDec 13, 1964 · N9965A · Substantial damageNTSB UNK65X0969Accident · Serious injuriesClosedAeronca 7AC · Le Sueur, MNDec 10, 1964 · N7946A · Substantial damageNTSB UNK65X0955Accident · No injuriesClosedCessna 310B · Hopkins, MNDec 8, 1964 · N547M · Substantial damageNTSB UNK65X0781Accident · No injuriesClosedPiper PA22 · Sleepy Eye, MNNov 21, 1964 · N1645P · Substantial damageNTSB UNK65X0689Accident · No injuriesClosedCessna 180 · St Paul, MNNov 13, 1964 · N4751U · Substantial damageNTSB UNK65X0667Accident · No injuriesClosedBeechcraft 35B33 · Minneapolis, MNNov 12, 1964 · N1700G · Substantial damageNTSB UNK65X0658Accident · No injuriesClosedCessna 150 · Minneapolis, MNNov 11, 1964 · N6173T · Minor damageNTSB UNK65X0611Accident · No injuriesClosedCessna 180 · Leech Lake, MNNov 8, 1964 · N4648A · Substantial damageNTSB UNK65X0585Accident · 1 fatalClosedCessna 170B · Wabasso, MNNov 6, 1964 · N8355A · DestroyedNTSB UNK65X0567Accident · Minor injuriesClosedErcoupe 415C · Isle, MNNov 5, 1964 · N99080 · Substantial damageNTSB UNK65X0547Accident · Serious injuriesClosedHughes 269B · Owatonna, MNNov 3, 1964 · N9326F · DestroyedNTSB UNK65X0528Accident · No injuriesClosedCessna 182 · Anoka, MNNov 2, 1964 · N3193S · Substantial damageNTSB UNK65X0441Accident · 1 fatalClosedBeechcraft N-35 · Brainerd, MNOct 25, 1964 · N9977R · Substantial damageNTSB UNK65X0417Accident · Minor injuriesClosedGrumman F6F5 · Minneapolis, MNOct 25, 1964 · N1078Z · Substantial damageNTSB UNK65X0247Accident · 5 fatalClosedMooney M-20A · Cambridge, MNOct 11, 1964 · N6063X · DestroyedNTSB UNK65X0237Accident · Minor injuriesClosedPiper PA18A · Fergus Falls, MNOct 11, 1964 · N1306A · Substantial damageNTSB UNK65X0208Accident · No injuriesClosedPiper PA28 · Duluth, MNOct 9, 1964 · N8769W · Substantial damageNTSB UNK65X0168Accident · No injuriesClosedPiper J5A · Stanton, MNOct 6, 1964 · N30849 · Substantial damageNTSB UNK64X4187Accident · No injuriesClosedStinson 108 · Grand Portage, MNSep 27, 1964 · N6630M · Substantial damageNTSB UNK64X4152Accident · No injuriesClosedCessna 182 · Murdock, MNSep 26, 1964 · N4966E · Substantial damageNTSB UNK64X4140Accident · No injuriesClosedLuscombe 8F · Isabella, MNSep 25, 1964 · N1475B · Substantial damageNTSB UNK64X4067Accident · No injuriesClosedBeechcraft 23 · St Paul, MNSep 20, 1964 · N2349L · Substantial damageNTSB UNK64X4031Accident · No injuriesClosedPiper PA22 · Marshall, MNSep 18, 1964 · N5436Z · Substantial damageNTSB UNK64X3993Accident · No injuriesClosedPiper PA22 · Gaylord, MNSep 15, 1964 · N3265Z · Substantial damageNTSB UNK64X3973Accident · No injuriesClosedCessna 140 · Rosemount, MNSep 13, 1964 · N72393 · Substantial damageNTSB UNK64X3878Accident · 1 fatalClosedBeechcraft D-18S · Deer River, MNSep 8, 1964 · N800UA · DestroyedNTSB UNK64X3863Accident · Serious injuriesClosedBoeing B-720 · Minneapolis, MNSep 7, 1964 · N736US · Minor damageNTSB UNK64X3840Accident · No injuriesClosedPiper PA20 · Grove City, MNSep 7, 1964 · N7717K · Substantial damageNTSB UNK64X3751Accident · No injuriesClosedCessna 180 · Circle Pines, MNSep 3, 1964 · N5318D · Substantial damageNTSB UNK64X3705Accident · Serious injuriesClosedPiper PA25 · Prior Lake, MNAug 31, 1964 · N6276Z · Substantial damageNTSB UNK64X3652Accident · No injuriesClosedCessna 310H · Hopkins, MNAug 28, 1964 · N1042Q · Substantial damageNTSB UNK64X3566Accident · Serious injuriesClosedCessna 140 · Virginia, MNAug 23, 1964 · CF-KWH · Substantial damageNTSB UNK64X3523Accident · Serious injuriesClosedBarnes 65A · Minneapolis, MNAug 21, 1964 · N4633T · Minor damageNTSB UNK64X3422Accident · No injuriesClosedCessna 170 · East Bethel, MNAug 16, 1964 · N1242D · DestroyedNTSB UNK64X3389Accident · No injuriesClosedCessna 150 · Bowlus, MNAug 15, 1964 · N7379X · Substantial damageNTSB UNK64X3353Accident · No injuriesClosedBoeing A75N1 · Waseca, MNAug 13, 1964 · N64514 · Substantial damageNTSB UNK64X3194Accident · No injuriesClosedCessna 140 · Minneapolis, MNAug 3, 1964 · N76346 · DestroyedNTSB UNK64X3181Accident · No injuriesClosedLake LA4 · Lake Elmo, MNAug 2, 1964 · N1128L · Substantial damageNTSB UNK64X2970Accident · No injuriesClosedBeechcraft P35 · Faribault, MNJul 22, 1964 · N8675M · Substantial damageNTSB UNK64X2927Accident · No injuriesClosedCessna 310B · Grand Rapids, MNJul 19, 1964 · N4379U · Substantial damageNTSB UNK64X2907Accident · No injuriesClosedCessna 150 · Oslo, MNJul 18, 1964 · N7336X · Substantial damageNTSB UNK64X2888Accident · Serious injuriesClosedBeechcraft 35A33 · Int L Falls, MNJul 17, 1964 · N494T · Substantial damage