NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 SEA67A0044Accident · 2 fatalClosedMooney M20E · Wolf Creek, MTDec 26, 1966 · N2747W · DestroyedNTSB SEA67D0272Accident · No injuriesClosedChampion 7GCB · Great Falls, MTDec 25, 1966 · N9601S · Substantial damageNTSB SEA67D0266Accident · No injuriesClosedAeronca 7AC · Circle, MTDec 20, 1966 · N2849E · Substantial damageNTSB SEA67A0043Accident · No injuriesClosedBrantly B-2B · Wyola, MTDec 18, 1966 · N2183U · Substantial damageNTSB SEA67D0219Accident · No injuriesClosedBeech A23-19 · Billings, MTNov 26, 1966 · N5775V · Substantial damageNTSB SEA67A0039Accident · 5 fatalClosedCessna 172G · Chinook, MTNov 25, 1966 · N6068R · DestroyedNTSB SEA67D0191Accident · No injuriesClosedPiper PA-18 · Rudyard, MTNov 20, 1966 · N9136D · Substantial damageNTSB SEA67D0221Accident · Serious injuriesClosedAeronca 7AC · Capitol, MTNov 13, 1966 · N82708 · DestroyedNTSB SEA67F0193Accident · No injuriesClosedPiper PA-30 · Billings, MTNov 12, 1966 · N7730Y · Substantial damageNTSB CHI67A0064Accident · Serious injuriesClosedBoeing B-720 · Billings, MTNov 12, 1966 · N7203U · No damageNTSB SEA67D0194Accident · No injuriesClosedCessna 180 · Swan Lake, MTNov 11, 1966 · N2493F · Substantial damageNTSB SEA67D0192Accident · No injuriesClosedBeech 35 · Thom Falls, MTOct 29, 1966 · N80415 · Substantial damageNTSB SEA67D0195Accident · No injuriesClosedStinson 108-3 · Malta, MTOct 19, 1966 · N659C · Substantial damageNTSB SEA67D0186Accident · No injuriesClosedPiper PA-28 · Billings, MTOct 17, 1966 · N6991W · Substantial damageNTSB SEA67D0165Accident · No injuriesClosedCessna 172 · Chinook, MTOct 16, 1966 · N7327T · Substantial damageNTSB SEA67D0169Accident · No injuriesClosedPiper PA-22 · Square Butte, MTOct 15, 1966 · N1337C · Substantial damageNTSB SEA67D0168Accident · No injuriesClosedMooney M20B · W S Springs, MTOct 9, 1966 · N74785 · Substantial damageNTSB SEA67A0027Accident · 2 fatalClosedBell 47G3B1 · W.Yellowston, MTSep 21, 1966 · N1169W · DestroyedNTSB SEA67A0026Accident · 4 fatalClosedPiper PA-28 · Alberton, MTSep 20, 1966 · N5182W · DestroyedNTSB SEA67A0025Accident · No injuriesClosedBell 47G-3 · Noxon, MTSep 19, 1966 · N6782D · DestroyedNTSB SEA67D0144Accident · No injuriesClosedPiper PA-18 · Dillon, MTSep 16, 1966 · N3952Z · Substantial damageNTSB SEA67D0167Accident · No injuriesClosedCessna 185 · Great Falls, MTSep 15, 1966 · N4145Y · Substantial damageNTSB SEA67D0120Accident · No injuriesClosedCessna 140 · Great Falls, MTSep 15, 1966 · N72308 · Substantial damageNTSB SEA67D0185Accident · No injuriesClosedStinson 108-2 · Laurel, MTSep 11, 1966 · N967D · Substantial damageNTSB SEA67F0129Accident · Minor injuriesClosedPiper PA-12 · Thomp. Falls, MTSep 10, 1966 · N78576 · Substantial damageNTSB SEA67F0111Accident · No injuriesClosedCessna 182 · Dupuyer, MTSep 9, 1966 · N3175S · Substantial damageNTSB SEA67D0120Accident · No injuriesClosedBeech 35 · Libby, MTSep 9, 1966 · N3172V · Substantial damageNTSB SEA67D0138Accident · No injuriesClosedPiper PA-18 · Stevensville, MTSep 4, 1966 · N3973P · Substantial damageNTSB SEA67D0132Accident · Minor injuriesClosedCessna 172 · Dutton, MTSep 4, 1966 · N2328U · DestroyedNTSB SEA67F0133Accident · No injuriesClosedStinson 108-3 · Hamilton, MTAug 22, 1966 · N6669M · Substantial damageNTSB SEA67D0110Accident · No injuriesClosedCessna 150F · Belgrade, MTAug 16, 1966 · N8024S · Substantial damageNTSB SEA67D0108Accident · No injuriesClosedCessna 180 · Conrad, MTAug 16, 1966 · N4603U · Substantial damageNTSB SEA67F0107Accident · No injuriesClosedPiper PA-18 · Zortman, MTAug 14, 1966 · N1197C · Substantial damageNTSB SEA67D0139Accident · No injuriesClosedStearman PT-17 · Big Horn, MTAug 12, 1966 · N51132 · Substantial damageNTSB SEA67F0077Accident · No injuriesClosedPiper PA-24 · Laurel, MTAug 7, 1966 · N6593P · Substantial damageNTSB SEA67D0102Accident · No injuriesClosedCessna 180 · W.Yellowstone, MTAug 3, 1966 · N5156E · Substantial damageNTSB SEA67F0086Accident · Minor injuriesClosedPiper PA-22 · Eurek, MTJul 30, 1966 · N6063D · Substantial damageNTSB SEA67D0100Accident · No injuriesClosedCessna 210 · Polson, MTJul 30, 1966 · N9454X · Substantial damageNTSB SEA67F0078Accident · 1 fatalClosedLuscombe 8A · Chinook, MTJul 27, 1966 · N2978K · DestroyedNTSB SEA67F0054Accident · No injuriesClosedPiper PA-25 · Winifred, MTJul 25, 1966 · N6880Z · Substantial damageNTSB SEA67D0092Accident · No injuriesClosedGrumman TBM-3E · Potomac, MTJul 25, 1966 · N3969A · Substantial damageNTSB SEA67D0081Accident · No injuriesClosedPiper PA-18 · Neihart, MTJul 25, 1966 · N7699Y · Substantial damageNTSB SEA67F0148Accident · No injuriesClosedPiper PA-18 · Molt, MTJul 15, 1966 · N3839Z · Substantial damageNTSB SEA67D0035Accident · No injuriesClosedPiper PA-28 · Butte, MTJul 15, 1966 · N7392W · Substantial damageNTSB SEA67D0075Accident · No injuriesClosedMorrisey 2150 · Babb, MTJul 14, 1966 · N5107V · Substantial damageNTSB SEA67A0002Accident · Serious injuriesClosedBell 47-G3B · Clinton, MTJul 14, 1966 · N8509F · DestroyedNTSB SEA67A0004Accident · 1 fatalClosedCessna 172B · Roy, MTJul 8, 1966 · N7834X · DestroyedNTSB SEA67D0055Accident · No injuriesClosedCessna 172 · Kalispell, MTJul 1, 1966 · N3733L · Substantial damageNTSB SEA66A0072Accident · Minor injuriesClosedBell 47G3B1 · Livingston, MTJun 30, 1966 · N73916 · DestroyedNTSB SEA67D0142Accident · No injuriesClosedChampion 7ECA · Lewistown, MTJun 28, 1966 · N8306V · Substantial damage