NTSB investigations, 1971, 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, 1971, 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\") = 1971
    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 SEA72DTI12Accident · No injuriesClosedCessna 172G · Loma, MTDec 27, 1971 · N3636L · Substantial damageNTSB SEA72AS021Accident · 2 fatalClosedMooney M20C · Broadus, MTNov 27, 1971 · N6436U · DestroyedNTSB SEA72AS019Accident · 1 fatalClosedCessna 150L · Ulm, MTNov 9, 1971 · N6691G · DestroyedNTSB SEA72DTA10Accident · No injuriesClosedLuscombe 8E · Volborg, MTOct 25, 1971 · N2472K · Substantial damageNTSB SEA72FTI09Accident · Serious injuriesClosedCessna 150 · Chinook, MTOct 24, 1971 · N6180T · DestroyedNTSB SEA72FTA09Accident · No injuriesClosedCessna 170B · Billings, MTOct 23, 1971 · N8234A · Substantial damageNTSB SEA72DTI08Accident · Serious injuriesClosedMooney M20C · Great Falls, MTOct 3, 1971 · N78939 · Substantial damageNTSB SEA72DTI07Accident · No injuriesClosedCessna 320 · Philipsburg, MTOct 2, 1971 · N5719X · Substantial damageNTSB SEA72FTA07Accident · No injuriesClosedPiper PA-23 · Harlowton, MTAug 31, 1971 · N4081P · Substantial damageNTSB SEA72DTI05Accident · No injuriesClosedDehavilland DH 104 · Chester, MTAug 21, 1971 · N1565V · Substantial damageNTSB SEA72DTI06Accident · No injuriesClosedCessna 337E · Livingston, MTAug 19, 1971 · N86545 · Substantial damageNTSB SEA72DTA08Accident · No injuriesClosedHughes 369HS · Mosby, MTAug 18, 1971 · N9059F · Substantial damageNTSB SEA72DTI04Accident · No injuriesClosedCessna 177 · Drummond, MTAug 6, 1971 · N29666 · Substantial damageNTSB SEA72FTA05Accident · No injuriesClosedCessna 150 · Sand Springs, MTAug 1, 1971 · N7971E · Substantial damageNTSB SEA72FTI03Accident · No injuriesClosedCessna 180 · Helena, MTJul 31, 1971 · N4577B · Substantial damageNTSB SEA72FTA02Accident · No injuriesClosedCallair A-9 · Laurel, MTJul 19, 1971 · N8264H · Substantial damageNTSB SEA72FTA04Accident · No injuriesClosedMaule M-4 · Wolf Point, MTJul 18, 1971 · N4700T · Substantial damageNTSB SEA72FTA03Accident · No injuriesClosedCessna 172 · Miles City, MTJul 14, 1971 · N8469U · Substantial damageNTSB SEA72DTI02Accident · No injuriesClosedAeronca 7AC · Conrad, MTJul 10, 1971 · N84458 · Substantial damageNTSB SEA72FTA01Accident · No injuriesClosedCessna 180D · Lodge Grass, MTJul 6, 1971 · N8609X · Substantial damageNTSB SEA72FTI01Accident · No injuriesClosedCessna 421B · Ennis, MTJul 5, 1971 · N803HK · Substantial damageNTSB SEA71FTA23Accident · No injuriesClosedCallair A-9 · Opheim, MTJun 20, 1971 · N9650Z · Substantial damageNTSB SEA71DTA24Accident · No injuriesClosedPiper PA-11 · Alzada, MTJun 16, 1971 · N4986H · Substantial damageNTSB SEA71FTI38Accident · 1 fatalClosedPiper PA-18 · Turner, MTJun 13, 1971 · N5765D · DestroyedNTSB SEA71DTI39Accident · No injuriesClosedLuscombe T-8F · Chinook, MTJun 13, 1971 · N2216B · Substantial damageNTSB SEA71FTI37Accident · No injuriesClosedCessna A188A · Havre, MTJun 8, 1971 · N9955G · Substantial damageNTSB SEA71FTI36Accident · Minor injuriesClosedCallair A-5 · Havre, MTJun 7, 1971 · N2957G · Substantial damageNTSB SEA71FTI35Accident · No injuriesClosedChampion 7AC · Belgrade, MTJun 5, 1971 · N84885 · Substantial damageNTSB SEA71DTI34Accident · No injuriesClosedCessna 182F · Shelby, MTJun 4, 1971 · N3463U · Substantial damageNTSB SEA71FTA22Accident · No injuriesClosedBeech A23-19 · Terry, MTJun 2, 1971 · N4722J · Substantial damageNTSB SEA71FTI33Accident · Minor injuriesClosedCessna 140 · Butte, MTMay 29, 1971 · N3079N · Substantial damageNTSB SEA71DTI32Accident · No injuriesClosedPiper PA-28 · Belgrade, MTMay 27, 1971 · N6357R · Substantial damageNTSB SEA71DTI31Accident · No injuriesClosedPiper PA-18 · Gallatin Gwy, MTMay 23, 1971 · N3695A · Substantial damageNTSB SEA71FTA21Accident · No injuriesClosedCessna 150J · Sidney, MTMay 17, 1971 · N60792 · Substantial damageNTSB SEA71FTA19Accident · 1 fatalClosedPitts Spec SC-1 · Lewiston, MTMay 9, 1971 · N21F · DestroyedNTSB SEA71DTI30Accident · No injuriesClosedCessna 175 · Havre, MTMay 2, 1971 · N7169M · Substantial damageNTSB SEA71FTI29Accident · No injuriesClosedCessna 150F · Libby, MTApr 29, 1971 · N6618F · Substantial damageNTSB SEA71FTA20Accident · No injuriesClosedCessna 170B · Brusett, MTApr 27, 1971 · N3479C · Substantial damageNTSB SEA71FDG28Accident · No injuriesClosedPiper PA-18 · Hamilton, MTApr 19, 1971 · N4299Z · Substantial damageNTSB SEA71FDA18Accident · No injuriesClosedCessna A188 · Joliet, MTApr 17, 1971 · N9821V · Substantial damageNTSB SEA71AS040Accident · 4 fatalClosedLear Jet 24D · Butte, MTApr 17, 1971 · N123CB · DestroyedNTSB SEA71FDG27Accident · No injuriesClosedMooney M20C · Santa Rita, MTApr 16, 1971 · N5996Q · Substantial damageNTSB SEA71FDG26Accident · No injuriesClosedCessna 150 · Plains, MTApr 16, 1971 · N61087 · Substantial damageNTSB SEA71FTA06Accident · No injuriesClosedTaylorcraft BC12-D · Baker, MTApr 10, 1971 · N94966 · Substantial damageNTSB SEA71FDG25Accident · No injuriesClosedBellanca 14-19 · Butte, MTApr 8, 1971 · N9832B · Substantial damageNTSB SEA71FDA16Accident · No injuriesClosedCessna 182N · Hysham, MTMar 31, 1971 · N8949G · Substantial damageNTSB SEA71FDA15Accident · No injuriesClosedStinson 108-2 · Alzada, MTMar 19, 1971 · N171C · Substantial damageNTSB SEA71FDA17Accident · No injuriesClosedPiper PA-11 · Alzada, MTMar 11, 1971 · N4532M · Substantial damageNTSB SEA71FDA14Accident · No injuriesClosedCessna 310C · Miles City, MTMar 10, 1971 · N1814H · Substantial damageNTSB SEA71DDG24Accident · No injuriesClosedCessna 177 · Great Falls, MTMar 9, 1971 · N2237Y · Substantial damage