NTSB investigations, 1972, MT

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1972, 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\") = 1972
    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 SEA73DTA04Accident · No injuriesClosedPiper PA-18 · Outlook, MTDec 31, 1972 · N4050Z · Substantial damageNTSB SEA73FTI16Accident · No injuriesClosedCessna 175B · Great Falls, MTNov 30, 1972 · N8170T · Substantial damageNTSB SEA73AS014Accident · 2 fatalClosedBeech H35 · Lolo, MTNov 30, 1972 · N4695D · DestroyedNTSB SEA73FTA03Accident · No injuriesClosedPiper PA-18 · Sand Springs, MTNov 15, 1972 · N4045Z · Substantial damageNTSB SEA73FT115Accident · Minor injuriesClosedPiper PA-18 · Augusta, MTOct 30, 1972 · N4299Z · DestroyedNTSB SEA73AS011Accident · 2 fatalClosedCessna 182A · Ennis, MTOct 23, 1972 · N9918B · DestroyedNTSB SEA73AS010Accident · 3 fatalClosedCessna 182P · Corwin Spgs, MTOct 20, 1972 · N7414Q · DestroyedNTSB SEA73FTI14Accident · Minor injuriesClosedMooney M20F · Lincoln, MTOct 14, 1972 · N4005N · Substantial damageNTSB SEA73FTI13Accident · No injuriesClosedCessna 421 · Kalispell, MTOct 7, 1972 · N424WP · DestroyedNTSB SEA73FTA02Accident · No injuriesClosedCessna 150F · Miles City, MTSep 26, 1972 · N8094F · Substantial damageNTSB SEA73FT112Accident · No injuriesClosedCessna 170A · Livingston, MTSep 14, 1972 · N9028A · Substantial damageNTSB SEA73DTI11Accident · No injuriesClosedCessna 172 · Saco, MTSep 1, 1972 · N2550Y · Substantial damageNTSB SEA73FTI09Accident · No injuriesClosedMooney M20C · Harlem, MTAug 21, 1972 · N2901L · Substantial damageNTSB SEA73FTI08Accident · Minor injuriesClosedTaylorcraft BC12-D · Whitefish, MTAug 19, 1972 · N39226 · Substantial damageNTSB SEA73FTI07Accident · No injuriesClosedMooney M20E · Anaconda, MTAug 17, 1972 · N9248M · Substantial damageNTSB SEA73FTI05Accident · Minor injuriesClosedPiper PA-18 · Deer Lodge, MTAug 13, 1972 · N4714A · Substantial damageNTSB SEA73FTI04Accident · No injuriesClosedPiper PA-20 · Great Falls, MTAug 7, 1972 · N1514A · Substantial damageNTSB SEA73DTI10Accident · No injuriesClosedCessna 182 · Eureka, MTAug 6, 1972 · N9279X · Substantial damageNTSB SEA73FTI03Accident · No injuriesClosedPiper PA-28 · Twin Bridges, MTJul 16, 1972 · N7805W · Substantial damageNTSB SEA73DTI02Accident · No injuriesClosedCessna 172 · Rudyard, MTJul 14, 1972 · N78628 · Substantial damageNTSB SEA73FTA01Accident · No injuriesClosedRobertson 180H · Wyola, MTJul 9, 1972 · N3481Y · Substantial damageNTSB SEA73FTI01Accident · Minor injuriesClosedBell 206A · Paradise, MTJul 8, 1972 · N6273N · Substantial damageNTSB SEA72FTA18Accident · No injuriesClosedPiper PA-18 · Laurel, MTJun 28, 1972 · N5452H · Substantial damageNTSB SEA72DTI24Accident · No injuriesClosedPiper PA-18 · Virginia Cty, MTJun 17, 1972 · N4014Z · Substantial damageNTSB SEA72FTI23Accident · No injuriesClosedCessna 180 · Anaconda, MTJun 16, 1972 · N4679A · Substantial damageNTSB SEA72FTI22Accident · No injuriesClosedBellanca 7GCBC · Hogeland, MTMay 30, 1972 · N9183L · Substantial damageNTSB SEA72FTI20Accident · No injuriesClosedCessna 180 · Shelby, MTMay 29, 1972 · N8679X · Substantial damageNTSB SEA72FTI21Accident · No injuriesClosedTailwind Dower · Butte, MTMay 26, 1972 · N7804C · Substantial damageNTSB SEA72FTI19Accident · No injuriesClosedCessna 172H · Drummond, MTMay 20, 1972 · CF-BXE · Substantial damageNTSB SEA72FTI18Accident · No injuriesClosedPiper PA-30 · Thmpson Flls, MTMay 12, 1972 · N7788Y · Substantial damageNTSB SEA72DT117Accident · No injuriesClosedPiper PA-18 · Plains, MTApr 29, 1972 · N1447A · Substantial damageNTSB SEA72FTA17Accident · No injuriesClosedBell 47G-3B · Harlowton, MTApr 27, 1972 · N204Z · Substantial damageNTSB SEA72FTA16Accident · Minor injuriesClosedCessna 172 · Roberts, MTApr 19, 1972 · N9857T · Substantial damageNTSB SEA72AS046Accident · 2 fatalClosedAero Comdr 500 · Noxon, MTApr 8, 1972 · N2776 · DestroyedNTSB SEA72AS042Accident · 2 fatalClosedPiper PA-24 · Ronan, MTMar 23, 1972 · N7843P · DestroyedNTSB SEA72DTA14Accident · Minor injuriesClosedPiper PA-25 · Brusett, MTMar 22, 1972 · N7312Z · Substantial damageNTSB SEA72FTI16Accident · No injuriesClosedCessna 206 · Conner, MTMar 21, 1972 · N5011U · Substantial damageNTSB SEA72FTI15Accident · No injuriesClosedCessna 310G · Great Falls, MTMar 17, 1972 · N2905R · Substantial damageNTSB SEA72FTA15Accident · No injuriesClosedCessna 150J · Ashland, MTMar 16, 1972 · N5625G · Substantial damageNTSB SEA72FTA13Accident · Minor injuriesClosedStinson 108-3 · Red Lodge, MTFeb 26, 1972 · N6984M · Substantial damageNTSB SEA72DTI14Accident · No injuriesClosedPiper PA-18A · Conrad, MTFeb 20, 1972 · N3087Z · Substantial damageNTSB SEA72DTA12Accident · No injuriesClosedCessna 140 · Glendive, MTFeb 20, 1972 · N2040N · Substantial damageNTSB SEA72FTA11Accident · No injuriesClosedCessna 140 · Hardin, MTFeb 15, 1972 · N72261 · Substantial damageNTSB SEA72DTI13Accident · No injuriesClosedMooney M20E · Great Falls, MTFeb 6, 1972 · N9228V · Substantial damageNTSB SEA72DTI10Accident · No injuriesClosedAeronca 7EC · Malta, MTJan 21, 1972 · N7406B · Substantial damageNTSB SEA72FTI11Accident · No injuriesClosedCessna 172 · Kalispell, MTJan 19, 1972 · N6185E · Substantial damage