NTSB investigations, 1979, 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, 1979, 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\") = 1979
    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 SEA80FTA07Accident · 1 fatalClosedScorpion 133 · Nashua, MTDec 29, 1979 · NONE · DestroyedNTSB SEA80FTA06Accident · No injuriesClosedCessna 210M · Glendive, MTDec 21, 1979 · N8197M · Substantial damageNTSB SEA80FTA05Accident · No injuriesClosedPiper PA-22 · Laurel, MTDec 20, 1979 · N7403D · Substantial damageNTSB SEA80FTI02Accident · Serious injuriesClosedPiper PA-32R · Chester, MTDec 19, 1979 · N2168D · DestroyedNTSB SEA80FTA03Accident · No injuriesClosedCessna 182E · Red Lodge, MTDec 2, 1979 · N3136Y · Substantial damageNTSB SEA80FTA04Accident · No injuriesClosedCessna 140 · Malta, MTDec 1, 1979 · N2197N · Substantial damageNTSB SEA80FTA02Accident · No injuriesClosedCessna 210 · Billings, MTOct 20, 1979 · N3976Y · Substantial damageNTSB SEA80FTA01Accident · No injuriesClosedCessna 150 · Billings, MTOct 19, 1979 · N45361 · Substantial damageNTSB SEA80FTI01Accident · 2 fatalClosedCessna A185F · Dillon, MTOct 16, 1979 · N4961Q · DestroyedNTSB SEA79FTI27Accident · Serious injuriesClosedCessna 182C · Whitefish, MTSep 30, 1979 · N9054T · DestroyedNTSB SEA79FTI26Accident · No injuriesClosedCessna 172K · Three Forks, MTSep 27, 1979 · N84445 · Substantial damageNTSB SEA79FTA21Accident · No injuriesClosedPiper PA-18 · Winnett, MTSep 25, 1979 · N83613 · Substantial damageNTSB SEA79FA060Accident · 2 fatalClosedCessna 150 · Sula, MTSep 20, 1979 · CG-CMZ · DestroyedNTSB SEA79FTA20Accident · Minor injuriesClosedCessna 182G · Billings, MTSep 19, 1979 · N3410S · Substantial damageNTSB SEA79DTI25Accident · No injuriesClosedCessna 172 · Conrad, MTSep 13, 1979 · N2015S · Substantial damageNTSB SEA79FT124Accident · Serious injuriesClosedPiper PA-24 · Big Sandy, MTAug 29, 1979 · N5791P · DestroyedNTSB SEA79FTA19Accident · No injuriesClosedBell 206B · Absarokee, MTAug 28, 1979 · N5013C · Substantial damageNTSB SEA79FT123Accident · Minor injuriesClosedKaman HH-43F · Hamilton, MTAug 24, 1979 · N4524 · DestroyedNTSB SEA79FA050Accident · 4 fatalClosedBeech B23 · Neihart, MTAug 24, 1979 · N7635R · DestroyedNTSB SEA79FTA18Accident · No injuriesClosedGrum Amer AA-5 · Laurel, MTAug 23, 1979 · N5880L · Substantial damageNTSB SEA79FTA17Accident · No injuriesClosedErco 415-C · Billings, MTJul 31, 1979 · N2467H · Substantial damageNTSB SEA79FA048Accident · 2 fatalClosedGrum Amer AA-5A · Augusta, MTJul 24, 1979 · N9966U · DestroyedNTSB SEA79DTI22Accident · Minor injuriesClosedCessna 182 · Schafer, MTJul 21, 1979 · N6166B · Substantial damageNTSB SEA79DTI20Accident · No injuriesClosedCessna 170B · Cut Bank, MTJul 18, 1979 · N8051A · Substantial damageNTSB SEA79FTA16Accident · No injuriesClosedCessna 180 · Landusky, MTJul 8, 1979 · N1674C · Substantial damageNTSB SEA79FA041Accident · 2 fatalClosedBellanca 7GCBC · Big Sky, MTJul 1, 1979 · N6397V · DestroyedNTSB SEA79FTI19Accident · No injuriesClosedBell 47G3B1 · Emigrant, MTJun 25, 1979 · N3078G · Substantial damageNTSB SEA79FA040Accident · 1 fatalClosedBellanca 7KCAB · Laurel, MTJun 22, 1979 · N1833G · DestroyedNTSB SEA79FTI16Accident · Serious injuriesClosedCessna TU206F · Sula, MTJun 10, 1979 · N8733Q · Substantial damageNTSB SEA79FTI18Accident · No injuriesClosedCessna 188 · Toston, MTJun 9, 1979 · N4810Q · Substantial damageNTSB SEA79FTI17Accident · No injuriesClosedCessna 140 · Brady, MTJun 8, 1979 · N77318 · Substantial damageNTSB SEA79FTA15Accident · No injuriesClosedPiper PA-18 · Circle, MTJun 5, 1979 · N5493H · Substantial damageNTSB SEA79FTI15Accident · No injuriesClosedScorpion II · Belgrade, MTMay 21, 1979 · N133RW · Substantial damageNTSB SEA79FTA14Accident · No injuriesClosedCessna 150 · Billings, MTMay 5, 1979 · N704JL · Substantial damageNTSB SEA79FTA13Accident · No injuriesClosedGrumman G-164B · Billings, MTMay 3, 1979 · N6753Q · Substantial damageNTSB SEA79DTI13Accident · Serious injuriesClosedPiper PA-24 · Sula, MTApr 20, 1979 · N8372P · DestroyedNTSB SEA79FA031Accident · 2 fatalClosedBell 214B-1 · Darby, MTApr 19, 1979 · N226RM · DestroyedNTSB SEA79FTA12Accident · No injuriesClosedStinson 108-2 · Sidney, MTApr 14, 1979 · N9379K · Substantial damageNTSB SEA79DTI12Accident · No injuriesClosedCessna 172 · Valier, MTApr 5, 1979 · N4343L · Substantial damageNTSB SEA79DTI10Accident · No injuriesClosedCessna 188 · Carter, MTMar 21, 1979 · N21759 · Substantial damageNTSB SEA79DTI09Accident · No injuriesClosedPiper PA-22 · Turner, MTMar 11, 1979 · N8690C · Substantial damageNTSB SEA79FTA10Accident · No injuriesClosedPiper PA-18 · Terry, MTFeb 28, 1979 · N3803Z · Substantial damageNTSB SEA79FA021Accident · 1 fatalClosedCessna T210P · Lavina, MTFeb 28, 1979 · N6995N · DestroyedNTSB SEA79FTI08Accident · No injuriesClosedCessna 180K · Missoula, MTFeb 26, 1979 · N64211 · Substantial damageNTSB SEA79FTA09Accident · Serious injuriesClosedCessna 180 · Miles City, MTFeb 25, 1979 · N9434C · DestroyedNTSB SEA79DTI07Accident · No injuriesClosedCessna 185E · Cut Bank, MTFeb 2, 1979 · N70263 · Substantial damageNTSB SEA79FTI06Accident · No injuriesClosedCessna 150L · Stevensville, MTJan 31, 1979 · N10903 · Substantial damageNTSB SEA79DTA07Accident · No injuriesClosedCessna 150 · Scobey, MTJan 29, 1979 · N50281 · Substantial damageNTSB SEA79FTA08Accident · No injuriesClosedBellanca 7GCBC · Sand Springs, MTJan 25, 1979 · N62972 · Substantial damageNTSB SEA79FA018Accident · No injuriesClosedHandly-Page HP-137 · Missoula, MTJan 15, 1979 · N14RJ · Substantial damage