NTSB investigations, 1965, 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, 1965, 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\") = 1965
    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 MKC66F0346Accident · No injuriesClosedPiper PA-22 · Park Rapids, MNDec 30, 1965 · N1657A · Substantial damageNTSB MKC66F0342Accident · No injuriesClosedCessna 140 · Monticello, MNDec 27, 1965 · N3587V · Substantial damageNTSB MKC66F0343Accident · No injuriesClosedBeechcraft 23 · So St Paul, MNDec 22, 1965 · N8799M · Substantial damageNTSB MKC66F0410Accident · No injuriesClosedPiper PA-12 · Lake Elmo, MNDec 18, 1965 · N78480 · Substantial damageNTSB MKC66D0376Accident · No injuriesClosedCessna 170A · New Ulm, MNDec 7, 1965 · N9277A · Substantial damageNTSB MKC66F0378Accident · No injuriesClosedCessna 120 · Eveleth, MNDec 5, 1965 · N72775 · Substantial damageNTSB MKC66F0315Accident · No injuriesClosedCessna 310H · Hopkins, MNNov 21, 1965 · N1108Q · Substantial damageNTSB MKC66F0332Accident · No injuriesClosedAero Cmdr 520 · Minneapolis, MNNov 8, 1965 · N5574V · Substantial damageNTSB MKC66F0331Accident · No injuriesClosedCessna 170 · So St Paul, MNNov 6, 1965 · N2632D · Substantial damageNTSB MKC66F0391Accident · Minor injuriesClosedBeech N35 · Madison, MNNov 3, 1965 · N1504Z · Substantial damageNTSB MKC66F0358Accident · Serious injuriesClosedChampion 7DC · White Bea, MNOct 30, 1965 · N6403V · Substantial damageNTSB MKC66D0308Accident · No injuriesClosedCessna 172 · Maple Plain, MNOct 29, 1965 · N6345E · Substantial damageNTSB MKC66D0361Accident · No injuriesClosedLitton Stms 213-1 · St Paul, MNOct 22, 1965 · N7534U · DestroyedNTSB MKC66A0028Accident · 1 fatalClosedPiper PA-28 · Fairfax, MNOct 19, 1965 · N7619W · DestroyedNTSB MKC66D0311Accident · No injuriesClosedCessna 150 · Rochester, MNOct 14, 1965 · N8042S · Substantial damageNTSB MKC66A0025Accident · 1 fatalClosedCessna 180 · Bemidji, MNOct 13, 1965 · N2281C · DestroyedNTSB MKC66A0024Accident · 1 fatalClosedSr.Aero SPT D-260 · Hamel, MNOct 10, 1965 · N4648T · DestroyedNTSB MKC66F0307Accident · No injuriesClosedPiper PA-28 · Duluth, MNOct 5, 1965 · N6839W · Substantial damageNTSB MKC66F0273Accident · No injuriesClosedPiper J3L-S · Excelsior, MNOct 4, 1965 · N40962 · Substantial damageNTSB MKC66F0254Accident · No injuriesClosedCessna 170A · So St Paul, MNOct 4, 1965 · N9503A · Substantial damageNTSB MKC66F0285Accident · No injuriesClosedPiper J3-S · Baudette, MNOct 2, 1965 · N87812 · Substantial damageNTSB MKC66F0269Accident · Serious injuriesClosedCessna 150 · N.Greenwald, MNOct 1, 1965 · N5948T · DestroyedNTSB MKC66F0261Accident · No injuriesClosedPiper PA-28 · Sebeka, MNSep 26, 1965 · N501UM · Substantial damageNTSB MKC66D0266Accident · No injuriesClosedCessna 140 · Melrose, MNSep 19, 1965 · N76280 · Substantial damageNTSB MKC66A0016Accident · 1 fatalClosedAir Space 18A · Anoka, MNSep 9, 1965 · N111S · DestroyedNTSB MKC66F0251Accident · No injuriesClosedCessna 150 · Mound, MNSep 5, 1965 · N5862E · Substantial damageNTSB MKC66F0293Accident · Minor injuriesClosedBeechcraft C-18S · Interntl Fls, MNAug 26, 1965 · N59550 · Substantial damageNTSB MKC66A0013Accident · No injuriesClosedBell 47G3B1 · Altura, MNAug 26, 1965 · N73247 · Substantial damageNTSB MKC66F0208Accident · 1 fatalClosedPiper PA-28 · Brainerd, MNAug 24, 1965 · N8248W · DestroyedNTSB MKC66D0233Accident · No injuriesClosedBeechcraft C-35 · So St Paul, MNAug 21, 1965 · N651X · Substantial damageNTSB MKC66F0200Accident · No injuriesClosedPiper PA-24 · Park Rapids, MNAug 19, 1965 · N7030P · Substantial damageNTSB MKC66D0242Accident · No injuriesClosedPiper PA-18A · Fairmont, MNAug 19, 1965 · N9134D · Substantial damageNTSB MKC66F0194Accident · Minor injuriesClosedPiper PA-28 · Minneapolis, MNAug 18, 1965 · N506UM · 2 aircraft · Substantial damageNTSB MKC66F0239Accident · Minor injuriesClosedChampion 7GC · Silver Bay, MNAug 15, 1965 · N8972R · Substantial damageNTSB MKC66F0238Accident · No injuriesClosedCessna 170 · Cottonwood, MNAug 15, 1965 · N4038V · Substantial damageNTSB MKC66F0217Accident · Minor injuriesClosedBeechcraft 23 · Lake City, MNAug 15, 1965 · N2374Q · Substantial damageNTSB MKC66A0009Accident · 1 fatalClosedChampion 7ECA · 3n Floodwood, MNAug 14, 1965 · N2528F · DestroyedNTSB MKC66F0294Accident · No injuriesClosedTaylorcraft BC-12D · So St Paul, MNAug 13, 1965 · N96430 · Substantial damageNTSB MKC66D0235Accident · No injuriesClosedBoeing A75N1 · Maynard, MNAug 13, 1965 · N50325 · Substantial damageNTSB MKC66F0209Accident · No injuriesClosedBeechcraft A23 · Rochester, MNAug 11, 1965 · N8771M · Substantial damageNTSB MKC66A0008Accident · 2 fatalClosedAeronca 7AC · Forest Alke, MNAug 8, 1965 · N84008 · DestroyedNTSB MKC66D0183Accident · No injuriesClosedPiper PA-12 · Pipestone, MNAug 6, 1965 · N4061M · Substantial damageNTSB MKC66F0210Accident · No injuriesClosedPiper PA-28 · Minneapolis, MNAug 4, 1965 · N503UM · Substantial damageNTSB MKC66D0182Accident · No injuriesClosedRepublic RC-3 · Onamia, MNAug 3, 1965 · N6204K · Substantial damageNTSB MKC66F0201Accident · No injuriesClosedCessna 140 · Robbinsdale, MNJul 29, 1965 · N77095 · Substantial damageNTSB MKC66F0226Accident · No injuriesClosedAeronca 7AC · Detroit Laks, MNJul 27, 1965 · N7146E · Substantial damageNTSB MKC66F0180Accident · No injuriesClosedCessna 172 · So St Paul, MNJul 26, 1965 · N7737U · Substantial damageNTSB MKC66F0263Accident · No injuriesClosedPiper PA-22 · Gaylord, MNJul 17, 1965 · N3265Z · Substantial damageNTSB MKC66D0203Accident · No injuriesClosedCessna 310 · Backus, MNJul 17, 1965 · N4845R · Substantial damageNTSB MKC66F0159Accident · No injuriesClosedCessna 180 · Bigfork, MNJul 16, 1965 · N3156C · Substantial damage