NTSB investigations, 1969, MT

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1969, 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\") = 1969
    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 SEA70D0141Accident · No injuriesClosedCessna 175 · Ryegate, MTDec 29, 1969 · N6670E · Substantial damageNTSB SEA70A0026Accident · 4 fatalClosedCessna 180 · Conrad, MTDec 19, 1969 · N4951A · DestroyedNTSB SEA70F0126Accident · No injuriesClosedBeech J35 · Billings, MTDec 16, 1969 · N8263D · Substantial damageNTSB SEA70D0124Accident · No injuriesClosedMaule M-4 · Great Falls, MTDec 9, 1969 · N9830M · Substantial damageNTSB SEA70D0153Accident · No injuriesClosedCessna 172D · Malta, MTOct 23, 1969 · N2177Y · Substantial damageNTSB SEA70D0113Accident · No injuriesClosedCessna 182 · Broadus, MTOct 17, 1969 · N70616 · Substantial damageNTSB SEA70A0014Accident · 1 fatalClosedCessna 320A · Conner, MTOct 10, 1969 · N3016R · DestroyedNTSB DEN70A0024Accident · 1 fatalClosedCessna 175 · Eureka, MTOct 7, 1969 · N9303B · DestroyedNTSB SEA70D0103Accident · No injuriesClosedCessna 150 · Broadus, MTOct 4, 1969 · N4622X · Substantial damageNTSB SEA70D0088Accident · Minor injuriesClosedCessna 182J · Neihart, MTSep 24, 1969 · N2774F · Substantial damageNTSB SEA70F0094Accident · Serious injuriesClosedCessna 185 · Helena, MTSep 23, 1969 · N9995X · Substantial damageNTSB SEA70D0092Accident · No injuriesClosedCessna 150J · Augusta, MTSep 23, 1969 · N51188 · DestroyedNTSB SEA70D0079Accident · No injuriesClosedBell 47G-3 · Circle, MTSep 12, 1969 · N6787D · Substantial damageNTSB SEA70F0066Accident · No injuriesClosedCessna 120 · Helena, MTSep 6, 1969 · N76215 · Substantial damageNTSB SEA70F0078Accident · No injuriesClosedBeech A23-24 · Belgrade, MTSep 3, 1969 · N3629Q · Substantial damageNTSB SEA70F0076Accident · No injuriesClosedCessna 195 · Three Forks, MTAug 30, 1969 · N9369A · Substantial damageNTSB DEN70A0013Accident · 1 fatalClosedCessna 182L · Bridger, MTAug 26, 1969 · N3147R · DestroyedNTSB SEA70D0059Accident · No injuriesClosedPiper PA-22 · Rapelje, MTAug 10, 1969 · N3455Z · Substantial damageNTSB SEA70F0056Accident · No injuriesClosedHiller Acft UH-12B · Billings, MTAug 5, 1969 · N3112G · Substantial damageNTSB SEA70A0008Accident · 3 fatalClosedBeech D95A · Livingston, MTAug 2, 1969 · N8920U · DestroyedNTSB SEA70D0058Accident · No injuriesClosedCessna 140A · Hingham, MTAug 1, 1969 · N9625A · Substantial damageNTSB SEA70F0027Accident · No injuriesClosedCessna 180 · Birney, MTJul 22, 1969 · N5194E · Substantial damageNTSB SEA70D0047Accident · No injuriesClosedBeech C35 · Belgrade, MTJul 20, 1969 · N1939D · Substantial damageNTSB SEA70F0042Accident · No injuriesClosedMaule M-4 · Kalispell, MTJul 18, 1969 · N4703T · Substantial damageNTSB SEA70F0018Accident · No injuriesClosedBrantly B-2 · Helena, MTJul 14, 1969 · N5987X · Substantial damageNTSB SEA70F0029Accident · No injuriesClosedWills BW-9 · Bigfork, MTJul 4, 1969 · N92883 · Substantial damageNTSB SEA70A0001Accident · 2 fatalClosedMooney M20E · Helena, MTJul 3, 1969 · N9054V · Substantial damageNTSB SEA70F0031Accident · Minor injuriesClosedTaylorcraft BC12-D · Kalispell, MTJul 1, 1969 · N95581 · Substantial damageNTSB SEA70D0021Accident · No injuriesClosedCessna 150 · Shonkin, MTJun 30, 1969 · N8164F · Substantial damageNTSB SEA70F0037Accident · No injuriesClosedPiper PA-22 · Forsyth, MTJun 28, 1969 · N3611P · Substantial damageNTSB DEN69A0053Accident · 4 fatalClosedCessna 182C · Great Falls, MTJun 25, 1969 · N8847T · DestroyedNTSB SEA70F0017Accident · Serious injuriesClosedBell 47G-3 · Deer Lodge, MTJun 4, 1969 · N8409E · DestroyedNTSB SEA70F0013Accident · Serious injuriesClosedCallair A-9 · Great Falls, MTJun 4, 1969 · N7204V · DestroyedNTSB SEA69D0263Accident · No injuriesClosedCessna 180 · Livingston, MTMay 27, 1969 · N9120C · Substantial damageNTSB SEA69F0254Accident · No injuriesClosedCessna 180A · Harrison, MTMay 9, 1969 · N180F · Substantial damageNTSB SEA69F0250Accident · No injuriesClosedCallair A-9 · St.Xavier, MTMay 5, 1969 · N7223V · Substantial damageNTSB SEA69F0253Accident · 1 fatalClosedPiper PA-24 · Plains, MTApr 29, 1969 · N7311P · DestroyedNTSB SEA69F0248Accident · No injuriesClosedCessna 150F · Malta, MTApr 26, 1969 · N8738S · Substantial damageNTSB SEA69F0237Accident · No injuriesClosedCessna 210 · Butte, MTApr 23, 1969 · N3797Y · Substantial damageNTSB SEA69F0217Accident · No injuriesClosedBrantly B-2B · Lodge Grass, MTApr 23, 1969 · N2186U · Substantial damageNTSB SEA69F0249Accident · 1 fatalClosedPiper PA-25 · Geraldine, MTApr 10, 1969 · N7291Z · DestroyedNTSB SEA69F0203Accident · No injuriesClosedHughes 269B · Missoula, MTApr 7, 1969 · N9355F · Substantial damageNTSB SEA69F0251Accident · Serious injuriesClosedMooney M20F · Melville, MTApr 6, 1969 · N2974L · DestroyedNTSB SEA69F0236Accident · No injuriesClosedErco 415-C · Kalispell, MTMar 29, 1969 · N93316 · Substantial damageNTSB SEA69F0204Incident · No injuriesClosedCessna 150 · W Yellwstone, MTMar 21, 1969 · CF-XVM · Minor damageNTSB SEA69A0049Accident · 3 fatalClosedCessna 175 · Four Buttes, MTMar 14, 1969 · N9499B · DestroyedNTSB SEA69D0209Accident · No injuriesClosedCessna 180 · Choteau, MTMar 2, 1969 · N2447F · Substantial damageNTSB SEA69D0211Accident · No injuriesClosedCessna 140A · Poplar, MTFeb 24, 1969 · N5600C · Substantial damageNTSB SEA69D0186Accident · No injuriesClosedPiper PA-28 · Chester, MTFeb 16, 1969 · N5342W · Substantial damageNTSB SEA69D0210Accident · No injuriesClosedPiper PA-23 · Great Falls, MTFeb 14, 1969 · N5121Y · Substantial damage