NTSB investigations, 1964, MT

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

19632026
NTSB investigations, 1964, MT per year, 1963–2026: 2,223 cases
19632
196478
196573
196687
196782
196861
196956
197067
197155
197246
197349
197459
197561
197660
197761
197857
197950
198046
198152
198257
198337
198438
198542
198634
198727
198831
198926
199032
199128
199229
199325
199429
199526
199623
199729
199838
199924
200028
200118
200225
200323
200429
200521
200633
200728
200820
200916
201014
201121
201217
201329
201421
201520
201618
201712
201814
201915
202019
202118
202214
202316
202418
202524
202615

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\" = 'MT' 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 UNK65X1176Accident · 2 fatalClosedPiper PA-28 · Terry, MTDec 28, 1964 · N5124W · DestroyedNTSB UNK65X1143Accident · No injuriesClosedPiper PA28 · Great Falls, MTDec 26, 1964 · N6304W · Substantial damageNTSB UNK65X1107Accident · No injuriesClosedPiper PA18 · Alzada, MTDec 23, 1964 · N7598K · Substantial damageNTSB UNK65X0758Accident · No injuriesClosedPiper PA-30 · Miles City, MTNov 20, 1964 · N7318Y · Substantial damageNTSB UNK65X0738Accident · No injuriesClosedPiper PA28 · Great Falls, MTNov 16, 1964 · N6304W · Substantial damageNTSB UNK65X0737Accident · No injuriesClosedCessna 172 · Ashland, MTNov 16, 1964 · N7132A · Substantial damageNTSB UNK65X0718Accident · No injuriesClosedPiper J3C · Billings, MTNov 15, 1964 · N6988H · Substantial damageNTSB UNK65X0716Accident · No injuriesClosedCessna 172 · Saco, MTNov 15, 1964 · N9857T · Substantial damageNTSB UNK65X0713Accident · No injuriesClosedMooney M21 · Plentywood, MTNov 15, 1964 · N6881U · Substantial damageNTSB UNK65X0708Accident · Minor injuriesClosedCessna 182 · Belt, MTNov 14, 1964 · N3034Y · Substantial damageNTSB UNK65X0691Accident · 1 fatalClosedCessna 170B · Roberts, MTNov 13, 1964 · N2561D · DestroyedNTSB UNK65X0467Accident · 1 fatalClosedMaule M-4 · Townsend, MTOct 28, 1964 · N4725T · DestroyedNTSB UNK65X0464Accident · No injuriesClosedStinson 108-3 · Glacier, MTOct 28, 1964 · N4161C · Substantial damageNTSB UNK65X0431Accident · No injuriesClosedCessna 172D · Broadus, MTOct 25, 1964 · N2379U · Substantial damageNTSB UNK65X0344Accident · No injuriesClosedBell 47G3 · Stevensville, MTOct 20, 1964 · N8418E · DestroyedNTSB UNK65X0309Accident · 4 fatalClosedCessna 185B · Augusta, MTOct 17, 1964 · N2566Z · DestroyedNTSB UNK65X0109Accident · No injuriesClosedCessna 175 · Great Falls, MTOct 1, 1964 · CF-KPG · Substantial damageNTSB UNK64X4215Accident · No injuriesClosedCessna 172D · Helena, MTSep 30, 1964 · N8536X · Substantial damageNTSB UNK64X4198Accident · No injuriesClosedPiper PA28 · Winfred, MTSep 28, 1964 · N8534W · DestroyedNTSB UNK64X4016Accident · No injuriesClosedCessna 190 · Ennis, MTSep 17, 1964 · N1058D · Substantial damageNTSB UNK64X3938Accident · No injuriesClosedPiper PA22 · Kremlin, MTSep 12, 1964 · N303F · Substantial damageNTSB UNK64X3712Accident · No injuriesClosedPiper PA12 · Belgrade, MTAug 31, 1964 · N3403M · Substantial damageNTSB UNK64X3611Accident · 4 fatalClosedPiper PA-30 · Choteau, MTAug 26, 1964 · CF-PHN · DestroyedNTSB UNK64X3483Accident · No injuriesClosedCessna 180 · Baker, MTAug 20, 1964 · N4657U · Substantial damageNTSB UNK64X3464Accident · No injuriesClosedMaule M4 · Hysham, MTAug 18, 1964 · N4705T · Substantial damageNTSB UNK64X3426Accident · No injuriesClosedBeechcraft 35 · Kalispell, MTAug 16, 1964 · N4685D · Substantial damageNTSB UNK64X3380Accident · No injuriesClosedAeronca 7DC · Sand Springs, MTAug 14, 1964 · N2836E · Substantial damageNTSB UNK64X3196Accident · No injuriesClosedCessna 140 · Medicine Lke, MTAug 3, 1964 · N2362V · Substantial damageNTSB UNK64X3131Accident · No injuriesClosedErcoupe 415C · Fishtail, MTJul 31, 1964 · N93472 · Substantial damageNTSB UNK64X3053Accident · No injuriesClosedCessna 170B · Billings, MTJul 26, 1964 · N8102A · Substantial damageNTSB UNK64X2962AccidentClosedPiper PA12 · Yellowstone, MTJul 21, 1964 · N3403M · Substantial damageNTSB UNK64X2905Accident · No injuriesClosedCessna 180 · Choteau, MTJul 18, 1964 · N4951A · Substantial damageNTSB UNK64X2847Accident · Minor injuriesClosedLuscombe 8A · Lookout Pass, MTJul 15, 1964 · N71491 · DestroyedNTSB UNK64X2834Accident · 1 fatalClosedChampion 7CCM · Flaxville, MTJul 14, 1964 · N4616E · DestroyedNTSB UNK64X2781Accident · 1 fatalClosedPiper PA-24 · W Yellowstone, MTJul 12, 1964 · N6002P · DestroyedNTSB UNK64X2740Accident · Serious injuriesClosedCessna 182 · Roscoe, MTJul 9, 1964 · N9355X · DestroyedNTSB UNK64X2716Accident · No injuriesClosedPiper PA18 · Ryegate, MTJul 8, 1964 · N5447H · Substantial damageNTSB UNK64X2598Accident · No injuriesClosedPiper PA22 · Baker, MTJul 1, 1964 · N4702Z · Substantial damageNTSB UNK64X2500Accident · No injuriesClosedBeechcraft D18S · Hardin, MTJun 26, 1964 · N9886H · Substantial damageNTSB UNK64X2260Accident · No injuriesClosedCessna 170 · Red Lodge, MTJun 13, 1964 · N3557C · Substantial damageNTSB UNK64X2246Accident · Minor injuriesClosedTaylorcraft BC12D · Poplar, MTJun 12, 1964 · N39161 · DestroyedNTSB UNK64X2210Accident · No injuriesClosedBell 47G3 · Yack Flats, MTJun 9, 1964 · N8400E · Substantial damageNTSB UNK64X2200Accident · No injuriesClosedCessna 182D · Schafer, MTJun 9, 1964 · N8974X · Substantial damageNTSB UNK64X2144Accident · No injuriesClosedBeechcraft D35 · Terry, MTJun 6, 1964 · N2153D · Substantial damageNTSB UNK64X2105Accident · Minor injuriesClosedPiper PA18A · Geraldine, MTJun 4, 1964 · N2693P · DestroyedNTSB UNK64X2053Accident · No injuriesClosedStinson 108 · Anaconda, MTMay 31, 1964 · N8599K · Substantial damageNTSB UNK64X2049Accident · No injuriesClosedCessna 170B · Poplar, MTMay 31, 1964 · N4585C · Substantial damageNTSB UNK64X2036Accident · No injuriesClosedMaule M-4 · Culbertson, MTMay 30, 1964 · N12032 · Substantial damageNTSB UNK64X2032Accident · No injuriesClosedPiper PA18 · Malta, MTMay 30, 1964 · N2534A · Substantial damageNTSB UNK64X2004Accident · No injuriesClosedPiper J3 · Winifred, MTMay 29, 1964 · N3666K · Substantial damage