NTSB investigations, 1967, MT

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 1967, MT per year, 1963–2026: 2,224 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
202616

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\") = 1967
    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 SEA68D0210Accident · No injuriesClosedPiper PA-18 · Ovando, MTNov 24, 1967 · N4268Z · Substantial damageNTSB SEA68D0218Accident · No injuriesClosedAero Comdr 520 · Bozeman, MTNov 22, 1967 · N2625B · Substantial damageNTSB SEA68D0209Accident · No injuriesClosedCessna 172 · Wolf Point, MTNov 11, 1967 · N3910F · Substantial damageNTSB SEA68A0039Accident · Minor injuriesClosedConvair 340T · Great Falls, MTNov 1, 1967 · N73120 · Substantial damageNTSB SEA68F0208Accident · No injuriesClosedPiper PA-24 · Pryor, MTOct 27, 1967 · N8551P · Substantial damageNTSB SEA68D0194Accident · No injuriesClosedPiper PA-30 · Laurel, MTOct 26, 1967 · N7840Y · Substantial damageNTSB SEA68F0159Accident · No injuriesClosedPiper PA-18 · Billings, MTOct 13, 1967 · N1734A · Substantial damageNTSB SEA68D0165Accident · No injuriesClosedPiper J3C-65 · Richland, MTOct 11, 1967 · N70234 · Substantial damageNTSB SEA68A0032Accident · 2 fatalClosedChampion 7GCBC · Lothair, MTOct 8, 1967 · N9601S · DestroyedNTSB SEA68D0178Accident · No injuriesClosedTaylorcraft BC12 · Malta, MTOct 7, 1967 · N34032 · DestroyedNTSB SEA68D0213Accident · No injuriesClosedPiper PA-22 · Great Falls, MTOct 3, 1967 · N3455A · Substantial damageNTSB SEA68A0042Accident · No injuriesClosedCessna 320A · Missoula, MTSep 30, 1967 · N3016R · Substantial damageNTSB SEA68F0185Accident · No injuriesClosedBoeing B75N1 · Brady, MTSep 29, 1967 · N4685N · Substantial damageNTSB SEA68F0138Accident · No injuriesClosedPiper PA-22 · Helena, MTSep 27, 1967 · N3763P · Substantial damageNTSB SEA68F0199Accident · Serious injuriesClosedCessna 140 · Hardin, MTSep 25, 1967 · N76931 · DestroyedNTSB SEA68D0144Accident · Minor injuriesClosedTaylorcraft BC12-D · Harrison, MTSep 20, 1967 · N95731 · Substantial damageNTSB SEA68F0139Accident · No injuriesClosedLuscombe 8A · Missoula, MTSep 16, 1967 · N45564 · Substantial damageNTSB SEA68D0127Accident · No injuriesClosedCessna 180 · Babb, MTSep 5, 1967 · N6494X · Substantial damageNTSB SEA68A0020Accident · Serious injuriesClosedBoeing B-17 · Kalispell, MTAug 29, 1967 · N7228C · DestroyedNTSB SEA68F0116Accident · No injuriesClosedChampion 7FC · Billings, MTAug 28, 1967 · N9886B · Substantial damageNTSB SEA68D0156Accident · No injuriesClosedMaule M-4 · Moore, MTAug 24, 1967 · N12010 · Substantial damageNTSB SEA68F0069Accident · No injuriesClosedBeech 23 · Broadview Mont, MTAug 17, 1967 · CF-OYJ · Substantial damageNTSB SEA68D0132Accident · No injuriesClosedPiper PA-24 · Libby, MTAug 16, 1967 · N5864P · Substantial damageNTSB SEA68F0142Accident · No injuriesClosedPiper PA-24 · Columbus, MTAug 14, 1967 · N5384P · DestroyedNTSB SEA68D0155Accident · Minor injuriesClosedPiper PA-18 · Mildred, MTAug 14, 1967 · N5756D · Substantial damageNTSB SEA68D0143Accident · No injuriesClosedForney F-1 · Jordan, MTAug 14, 1967 · N7551C · Substantial damageNTSB SEA68D0093Accident · No injuriesClosedChampion 7EC · Wolf Point, MTAug 14, 1967 · N4301C · Substantial damageNTSB SEA68D0111Accident · Minor injuriesClosedPiper PA-25 · Carter, MTAug 11, 1967 · N7668Z · Substantial damageNTSB SEA68D0180Accident · No injuriesClosedCessna 140A · Worden, MTAug 10, 1967 · N3785V · Substantial damageNTSB SEA68A0015Accident · No injuriesClosedBell 47G-3 · Livingston, MTAug 10, 1967 · N8416F · Substantial damageNTSB SEA68A0012Accident · No injuriesClosedBell 47G-3B · Augusta, MTAug 7, 1967 · N1357X · Substantial damageNTSB SEA68D0121Accident · Minor injuriesClosedPiper PA-28 · Swan Lake, MTJul 29, 1967 · N9456J · DestroyedNTSB SEA68A0021Accident · No injuriesClosedBell 47G3B1 · West Glacier, MTJul 29, 1967 · N73916 · Substantial damageNTSB SEA68D0051Accident · No injuriesClosedCessna 182G · Helena, MTJul 22, 1967 · N2082R · Substantial damageNTSB SEA68D0054Accident · No injuriesClosedCessna 150 · Missoula, MTJul 21, 1967 · N3130J · Substantial damageNTSB SEA68F0089Accident · No injuriesClosedCessna 185 · Billings, MTJul 14, 1967 · N4001Y · Substantial damageNTSB SEA68F0059Accident · No injuriesClosedBellanca 14-19 · Fort Shaw, MTJul 13, 1967 · N9832B · Substantial damageNTSB SEA68A0006Accident · No injuriesClosedBell 47G-3 · Fairfield, MTJul 10, 1967 · N8414E · Substantial damageNTSB SEA68D0140Accident · No injuriesClosedMooney M20E · Huntley, MTJul 9, 1967 · N5753Q · Substantial damageNTSB SEA68A0004Accident · 4 fatalClosedBeech K35 · Fort Peck, MTJul 4, 1967 · N6024E · DestroyedNTSB SEA68D0109Accident · No injuriesClosedAeronca 7AC · Wh.Sulph.Spg, MTJul 3, 1967 · N82901 · Substantial damageNTSB SEA68A0001Accident · 1 fatalClosedCallair A-9 · Power, MTJul 1, 1967 · N7225V · DestroyedNTSB SEA68D0061Accident · No injuriesClosedPiper PA-18 · Tampico, MTJun 30, 1967 · N2883Z · Substantial damageNTSB SEA68F0078Accident · No injuriesClosedPiper PA-23 · Billings, MTJun 26, 1967 · N4986P · Substantial damageNTSB MKC68D0108Accident · No injuriesClosedCessna 210 · Glasgow, MTJun 25, 1967 · N2311F · Substantial damageNTSB SEA68D0062Accident · No injuriesClosedPiper PA-18 · St.Xavier, MTJun 16, 1967 · N3831Z · Substantial damageNTSB SEA68D0048Accident · No injuriesClosedPiper PA-25 · Dutton, MTJun 14, 1967 · N7006Z · Substantial damageNTSB SEA68D0002Accident · No injuriesClosedPiper PA-18 · Lincoln, MTJun 11, 1967 · N3981Z · Substantial damageNTSB SEA68D0064Accident · No injuriesClosedBeech 35-B33 · Westby, MTJun 3, 1967 · N8946M · Substantial damageNTSB SEA68F0058Accident · No injuriesClosedMaule M-4 · Polson, MTJun 2, 1967 · N4602T · Substantial damage