NTSB investigations, 1965, 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, 1965, 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\") = 1965
    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 SEA66D0188Accident · No injuriesClosedCessna 180 · Babb, MTDec 29, 1965 · N6494X · Substantial damageNTSB SEA66D0203Accident · No injuriesClosedPiper PA-18 · Billings, MTDec 26, 1965 · N3684Z · Substantial damageNTSB SEA66D0200Accident · No injuriesClosedAeronca 7AC · Billings, MTDec 19, 1965 · N1128N · Substantial damageNTSB SEA66D0195Accident · No injuriesClosedBellanca 14-13 · Billings, MTDec 9, 1965 · N86720 · Substantial damageNTSB SEA66D0189Accident · No injuriesClosedBeechcraft C33 · Chester, MTDec 7, 1965 · N6128V · Substantial damageNTSB SEA66F0192Accident · No injuriesClosedCessna 320 · Billings, MTNov 18, 1965 · N3027T · Substantial damageNTSB SEA66D0178Accident · No injuriesClosedPiper PA-11 · Lambert, MTNov 14, 1965 · N4765M · Substantial damageNTSB SEA66D0169Accident · No injuriesClosedCessna 210 · Highwood, MTNov 14, 1965 · N8383Z · Substantial damageNTSB SEA66F0180Accident · Minor injuriesClosedPiper PA-18A · Huntley, MTNov 8, 1965 · N3688A · Substantial damageNTSB SEA66F0171Accident · No injuriesClosedDehaviland DH-82A · Helena, MTNov 8, 1965 · N3301T · Substantial damageNTSB SEA66A0030Accident · No injuriesClosedBrantly B-2 · Bigfork, MTNov 3, 1965 · N5991X · DestroyedNTSB SEA66D0161Accident · No injuriesClosedPiper PA-28 · Avon, MTNov 1, 1965 · N8782W · Substantial damageNTSB SEA66A0028Accident · 1 fatalClosedStinson 108-3 · Augusta, MTOct 28, 1965 · N348 · DestroyedNTSB SEA66A0027Accident · 1 fatalClosedCessna 140 · Ryegate, MTOct 28, 1965 · N77103 · DestroyedNTSB SEA66F0190Accident · No injuriesClosedPiper PA-24 · Twin Bridges, MTOct 18, 1965 · N6380 · Substantial damageNTSB SEA66F0148Accident · No injuriesClosedCessna 182F · Broadus, MTOct 10, 1965 · N3170U · Substantial damageNTSB SEA66D0142Accident · Minor injuriesClosedPiper PA-18 · Stanford, MTOct 3, 1965 · N7699Y · Substantial damageNTSB SEA66F0122Accident · No injuriesClosedMooney M20C · Red Lodge, MTSep 19, 1965 · N5882Q · Substantial damageNTSB SEA66A0022Accident · No injuriesClosedHiller UH-12E · Choteau, MTSep 17, 1965 · N5360V · Substantial damageNTSB SEA66A0021Accident · 2 fatalClosedNavion B · Judith Gap, MTSep 11, 1965 · N4400K · DestroyedNTSB SEA66F0141Accident · Minor injuriesClosedAeronca 7AC · Ronan, MTSep 7, 1965 · N85023 · Substantial damageNTSB SEA66F0105Accident · No injuriesClosedPiper PA-17 · Deborgia, MTAug 31, 1965 · N4638H · Substantial damageNTSB SEA66F0099Accident · No injuriesClosedLuscombe 8E · W.Yellowston, MTAug 30, 1965 · N1781K · Substantial damageNTSB SEA66A0017Accident · 1 fatalClosedCallair A-9 · 14s Ryegate, MTAug 29, 1965 · N8250H · DestroyedNTSB SEA66D0104Accident · No injuriesClosedCessna 180 · Livingston, MTAug 22, 1965 · N7630A · Substantial damageNTSB SEA66A0012Accident · No injuriesClosedBell 47G3B1 · Libby, MTAug 16, 1965 · N73920 · Substantial damageNTSB SEA66D0117Accident · No injuriesClosedCessna 120 · Whitefish, MTAug 15, 1965 · N77000 · Substantial damageNTSB SEA66F0066Accident · Serious injuriesClosedLuscombe 8E · Billings, MTAug 10, 1965 · N2422K · Substantial damageNTSB SEA66D0109Accident · No injuriesClosedCessna 140A · Vida, MTAug 10, 1965 · N9414A · Substantial damageNTSB SEA66D0094Accident · No injuriesClosedCessna 182H · Butte, MTAug 10, 1965 · N3465S · Substantial damageNTSB SEA66A0009Accident · 1 fatalClosedCallair S-1A · 8sw Billings, MTAug 8, 1965 · N37261 · Substantial damageNTSB SEA66A0006Accident · 1 fatalClosedNavion G · 30nw Augusta, MTAug 1, 1965 · N2411T · DestroyedNTSB SEA66D0103Accident · No injuriesClosedCessna 185 · Billings, MTJul 29, 1965 · N4133Y · Substantial damageNTSB SEA66D0149Accident · No injuriesClosedBeech C-18S · Willard, MTJul 27, 1965 · N8056H · Substantial damageNTSB SEA66D0076Accident · No injuriesClosedCessna 185A · Livingston, MTJul 25, 1965 · N4055Y · Substantial damageNTSB SEA66F0095Accident · No injuriesClosedPiper PA-11 · Molt, MTJul 22, 1965 · N5066H · Substantial damageNTSB SEA66F0046Accident · No injuriesClosedCessna 182 · Darby, MTJul 8, 1965 · N5379B · Substantial damageNTSB SEA66D0077Accident · Minor injuriesClosedPiper PA-18A · Lewistown, MTJul 7, 1965 · N8566D · DestroyedNTSB SEA66A0002Accident · 1 fatalClosedTaylorcraft BC-12D · Biddle, MTJul 3, 1965 · N43567 · DestroyedNTSB SEA66F0058Accident · No injuriesClosedCessna 120 · Kalispell, MTJun 29, 1965 · N77423 · DestroyedNTSB SEA66D0078Accident · No injuriesClosedCessna 180 · Twin Bridges, MTJun 29, 1965 · N7630A · Substantial damageNTSB SEA66D0064Accident · No injuriesClosedCessna 182A · Schafer, MTJun 27, 1965 · N4767D · Substantial damageNTSB SEA66F0032Accident · No injuriesClosedCessna 180H · Devon, MTJun 23, 1965 · N4755U · Substantial damageNTSB SEA65A0068Accident · 1 fatalClosedCessna 210 · Opheim, MTJun 21, 1965 · N9418T · DestroyedNTSB SEA66F0036Accident · No injuriesClosedPiper J3C-65 · Missoula, MTJun 19, 1965 · N1190N · Substantial damageNTSB SEA66D0065Accident · No injuriesClosedPiper PA-18 · Galata, MTJun 19, 1965 · N2519A · Substantial damageNTSB SEA66D0055Accident · No injuriesClosedPiper PA-18 · Winifred, MTJun 10, 1965 · N4586A · Substantial damageNTSB SEA66F0038Accident · No injuriesClosedPiper J3L · Bloomfield, MTJun 8, 1965 · N30948 · Substantial damageNTSB SEA66F0035Accident · No injuriesClosedCessna 140A · Cut Bank, MTJun 8, 1965 · N9625A · Substantial damageNTSB SEA66D0040Accident · No injuriesClosedCallair A-9 · Boyd, MTJun 2, 1965 · N3556G · Substantial damage