NTSB investigations, 1968, MT

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

19632026
NTSB investigations, 1968, 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\") = 1968
    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 SEA69D0153Accident · No injuriesClosedCessna 170 · St.Xavier, MTDec 20, 1968 · N2663V · Substantial damageNTSB SEA69A0035Accident · 1 fatalClosedAero Comdr 500 · Glendive, MTDec 18, 1968 · N6281X · DestroyedNTSB SEA69F0168Accident · No injuriesClosedBell 206A · Missoula, MTDec 17, 1968 · N4735R · Substantial damageNTSB SEA69D0170Accident · No injuriesClosedCessna 170B · Belgrade, MTDec 15, 1968 · N3185B · Substantial damageNTSB SEA69A0032Accident · 3 fatalClosedAero Comdr 560-F · Wolf Creek, MTDec 8, 1968 · N6257X · DestroyedNTSB SEA69F0148Accident · No injuriesClosedCessna 150 · Belgrade, MTNov 26, 1968 · N51149 · Substantial damageNTSB SEA69D0161Accident · No injuriesClosedAeronca 11CC · Frazer, MTOct 24, 1968 · N4301E · Substantial damageNTSB SEA69F0150Accident · No injuriesClosedPiper PA-24 · Butte, MTOct 23, 1968 · N5889P · Substantial damageNTSB SEA69F0142Accident · No injuriesClosedBeech F35 · Dillon, MTOct 13, 1968 · N3899B · Substantial damageNTSB SEA69D0122Accident · Minor injuriesClosedBell 47G3B1 · Anaconda, MTSep 26, 1968 · N73931 · Substantial damageNTSB SEA69F0104Accident · Minor injuriesClosedCessna 310B · W-Yellowstne, MTSep 16, 1968 · N222V · DestroyedNTSB SEA69D0135Accident · No injuriesClosedCessna 180 · Miles City, MTSep 7, 1968 · N9907V · Substantial damageNTSB SEA69F0121Accident · No injuriesClosedPiper J3C-65 · Chinook, MTAug 30, 1968 · N41072 · Substantial damageNTSB SEA69A0014Accident · 1 fatalClosedCessna 140 · Busby, MTAug 23, 1968 · N2278V · DestroyedNTSB SEA69D0101Accident · No injuriesClosedCessna 180H · Boyes, MTAug 22, 1968 · N7999V · Substantial damageNTSB SEA69F0098Accident · 2 fatalClosedTaylorcraft BC12-D · Winnett, MTAug 19, 1968 · N95010 · DestroyedNTSB SEA69F0094Accident · No injuriesClosedCessna 175 · Hamilton, MTAug 17, 1968 · N7968T · Substantial damageNTSB SEA69D0123Accident · Minor injuriesClosedPiper PA-18 · Melville, MTAug 12, 1968 · N9443D · DestroyedNTSB SEA69F0053Accident · No injuriesClosedBeech A23-19 · Butte, MTAug 8, 1968 · N4714J · Substantial damageNTSB SEA69D0108Accident · No injuriesClosedCessna 180 · Glendive, MTAug 7, 1968 · N5224D · Substantial damageNTSB SEA68D0082Accident · No injuriesClosedCessna 182 · Kalispell, MTJul 26, 1968 · N3530U · Substantial damageNTSB SEA69A0006Accident · Serious injuriesClosedLockheed 188C · Billings, MTJul 20, 1968 · N130US · No damageNTSB SEA69A0005Accident · 5 fatalClosedBeech C35 · Tarkio, MTJul 14, 1968 · N1968D · DestroyedNTSB SEA69D0039Accident · No injuriesClosedPiaggio P-136 · Missoula, MTJul 10, 1968 · N40041 · Substantial damageNTSB SEA69F0035Accident · 1 fatalClosedBoeing A75 · Boyd, MTJul 8, 1968 · N61926 · DestroyedNTSB SEA69D0026Accident · No injuriesClosedPiper PA-28 · Chinook, MTJul 7, 1968 · N7557W · Substantial damageNTSB SEA69F0041Accident · No injuriesClosedMaule M4-210 · Kalispel, MTJul 3, 1968 · N4738T · Substantial damageNTSB SEA69D0034Accident · No injuriesClosedBoeing A75N1 · Wilsall, MTJul 1, 1968 · N5150N · Substantial damageNTSB SEA69F0059Accident · No injuriesClosedCessna 182A · Anaconda, MTJun 22, 1968 · N3589D · Substantial damageNTSB SEA69D0029Accident · No injuriesClosedPiper PA-11 · Fairview, MTJun 11, 1968 · N5537H · Substantial damageNTSB SEA69F0003Accident · No injuriesClosedPiper PA-11 · Zurich, MTJun 10, 1968 · N4966H · Substantial damageNTSB SEA69F0006Accident · No injuriesClosedPiper PA-22 · Belgrade, MTJun 8, 1968 · N2835P · Substantial damageNTSB SEA68F0315Accident · No injuriesClosedPiper PA-25 · Cut Bank, MTJun 5, 1968 · N7291Z · Substantial damageNTSB SEA68I0070Incident · No injuriesClosedCessna 402 · Libby, MTJun 3, 1968 · N4046Q · Minor damageNTSB SEA68F0319Accident · No injuriesClosedPiper PA-25 · Santa Rita, MTMay 29, 1968 · N7701Z · Substantial damageNTSB SEA68D0313Accident · Minor injuriesClosedPiper PA-11 · Wolf Point, MTMay 18, 1968 · N78741 · Substantial damageNTSB SEA68F0314Accident · No injuriesClosedPiper PA-25 · Townsend, MTMay 16, 1968 · N7306Z · Substantial damageNTSB SEA68A0067Accident · 1 fatalClosedCessna 120 · Monida, MTMay 13, 1968 · N90081 · Substantial damageNTSB SEA68D0310Accident · No injuriesClosedBell 47G3B1 · Jackson, MTMay 11, 1968 · N7920S · Substantial damageNTSB SEA68F0321Accident · No injuriesClosedBeech P35 · Great Falls, MTMay 5, 1968 · N1400G · Substantial damageNTSB SEA68F0312Accident · No injuriesClosedSnow S2A · Billings, MTMay 5, 1968 · N1626S · Substantial damageNTSB SEA68F0300Accident · Serious injuriesClosedAlon A-2 · Billings, MTApr 29, 1968 · N6504Q · Substantial damageNTSB SEA68F0298Accident · No injuriesClosedCessna 180 · Billings, MTApr 27, 1968 · N4629A · Substantial damageNTSB SEA68A0066Accident · 3 fatalClosedCessna 175 · Cascade, MTApr 26, 1968 · N9454B · DestroyedNTSB SEA68D0306Accident · No injuriesClosedCessna 206 · Livingston, MTApr 14, 1968 · N5210U · Substantial damageNTSB SEA68D0275Accident · No injuriesClosedPiper PA-22 · Miles City, MTApr 11, 1968 · N2538P · Substantial damageNTSB SEA68F0301Accident · No injuriesClosedCessna 172 · Hammond, MTApr 7, 1968 · N2049Y · Substantial damageNTSB SEA68D0291Accident · Minor injuriesClosedPiper PA-18 · Great Falls, MTApr 6, 1968 · N7699Y · Substantial damageNTSB SEA68D0265Accident · No injuriesClosedChampion 7GCBC · Maxville, MTMar 25, 1968 · N6361N · Substantial damageNTSB SEA68A0061Accident · 2 fatalClosedCessna 182 · Polson, MTMar 25, 1968 · N2684R · Destroyed