NTSB investigations, 1977, 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, 1977, 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\") = 1977
    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 SEA78FA015Accident · 2 fatalClosedGrum Amer AA-5A · Anaconda, MTDec 28, 1977 · N9968U · DestroyedNTSB SEA78DTI04Accident · No injuriesClosedPiper PA-18 · Livingston, MTDec 23, 1977 · N4996P · Substantial damageNTSB SEA78FTA08Accident · Minor injuriesClosedBell 47G3B1 · Billings, MTDec 20, 1977 · N7860S · DestroyedNTSB SEA78DTI03Accident · No injuriesClosedCessna 170 · Browning, MTDec 18, 1977 · N5414C · Substantial damageNTSB SEA78FTA09Accident · No injuriesClosedCessna 150 · Peerless, MTDec 17, 1977 · N61067 · Substantial damageNTSB SEA78FTA07Accident · No injuriesClosedCessna TU206 · Zortman, MTDec 12, 1977 · N357DP · Substantial damageNTSB SEA78DTA06Accident · No injuriesClosedCessna 182 · Baker, MTNov 30, 1977 · N71638 · Substantial damageNTSB SEA78DTI01Accident · No injuriesClosedLuscombe 8AC · Boulder, MTNov 13, 1977 · N1041K · Substantial damageNTSB SEA78FTA05Accident · No injuriesClosedGrum Amer AA5A · Billings, MTNov 12, 1977 · N26106 · Substantial damageNTSB SEA77FTA04Accident · No injuriesClosedPiper PA-22 · Glendive, MTNov 7, 1977 · N8152D · Substantial damageNTSB SEA78FTA03Accident · No injuriesClosedCessna 185 · Bay Horse, MTNov 4, 1977 · N21709 · Substantial damageNTSB SEA78DTI02Accident · No injuriesClosedCessna 310G · Belgrade, MTOct 20, 1977 · N8984Z · Substantial damageNTSB SEA78FTA02Accident · Minor injuriesClosedCessna 210-5 · Lewistown, MTOct 2, 1977 · N8162Z · Substantial damageNTSB SEA77FTA01Accident · No injuriesClosedBellanca 8KCAB · Forsyth, MTOct 2, 1977 · N2535Z · Substantial damageNTSB SEA77DTI24Accident · No injuriesClosedCessna 120 · Chester, MTSep 23, 1977 · N2687N · Substantial damageNTSB SEA77DTI23Accident · No injuriesClosedCessna 182G · Ledger, MTSep 23, 1977 · N34105 · Substantial damageNTSB SEA77FTI22Accident · No injuriesClosedCessna 210D · W.Sulphur Spgs, MTSep 15, 1977 · N3964Y · Minor damageNTSB SEA77DTI20Accident · Minor injuriesClosedCessna 170 · Ft.Benton, MTSep 3, 1977 · N4212V · Substantial damageNTSB SEA77FTI19Accident · No injuriesClosedBell 47G3B2 · Missoula, MTSep 1, 1977 · N7937J · Substantial damageNTSB SEA77FTA29Accident · Serious injuriesClosedPiper PA-18 · Wyola, MTAug 29, 1977 · N3989P · DestroyedNTSB SEA77FTA30Accident · No injuriesClosedPiper PA-28 · Miles City, MTAug 26, 1977 · N5358L · Substantial damageNTSB SEA77DTI18Accident · No injuriesClosedCessna 180 · Cut Bank, MTAug 25, 1977 · N52102 · Substantial damageNTSB SEA77FTA28Accident · No injuriesClosedMaule M4 · Hardin, MTAug 12, 1977 · N12011 · Substantial damageNTSB SEA77FTI21Accident · No injuriesClosedCessna 150G · Helena, MTAug 8, 1977 · N3752J · Substantial damageNTSB SEA77FTI17Accident · Serious injuriesClosedPiper PA-28 · St.Regis, MTAug 6, 1977 · N9115W · DestroyedNTSB SEA77FTA23Accident · No injuriesClosedBellanca 7CE · Baker, MTAug 5, 1977 · N7525E · Substantial damageNTSB SEA77FTA27Accident · No injuriesClosedCessna 180 · Biddle, MTJul 28, 1977 · N968K · Substantial damageNTSB SEA77FTI16Accident · 2 fatalClosedCessna 150M · Helena, MTJul 27, 1977 · N45126 · Substantial damageNTSB SEA77FTI15Accident · No injuriesClosedEnstrom 280C · Dillon, MTJul 7, 1977 · N594H · Substantial damageNTSB SEA77FTA26Accident · No injuriesClosedPiper PA-28 · Billings, MTJul 4, 1977 · N9875W · Substantial damageNTSB SEA77FTA24Accident · No injuriesClosedCessna 140 · Jordan, MTJun 23, 1977 · N2040N · Substantial damageNTSB SEA77FA041Accident · 1 fatalClosedPiper PA-18 · Glasgow, MTJun 22, 1977 · N4094Z · DestroyedNTSB SEA77FTA25Accident · No injuriesClosedCessna T210M · Malta, MTJun 21, 1977 · N45SP · Substantial damageNTSB SEA77FTA21Accident · No injuriesClosedPiper J3C-65 · Scobey, MTJun 6, 1977 · N35214 · Substantial damageNTSB SEA77FA038Accident · 3 fatalClosedPiper PA-28 · Lavina, MTJun 4, 1977 · N1176H · DestroyedNTSB SEA77FTI14Accident · Minor injuriesClosedCessna 140 · Stevensville, MTJun 1, 1977 · N76330 · DestroyedNTSB SEA77FTA20Accident · No injuriesClosedCessna 206 · Billings, MTMay 31, 1977 · N1803Q · Substantial damageNTSB SEA77FTA19Accident · Minor injuriesClosedCessna 188 · Billings, MTMay 24, 1977 · N70146 · Substantial damageNTSB SEA77FTA18Accident · No injuriesClosedPiper PA-25 · Brockway, MTMay 21, 1977 · N7312Z · Substantial damageNTSB SEA77FTA17Accident · No injuriesClosedBellanca 7GCBC · Opheim, MTMay 9, 1977 · N88465 · Substantial damageNTSB SEA77DTI13Accident · Minor injuriesClosedPiper PA-18 · Chester, MTMay 3, 1977 · N4614Y · DestroyedNTSB SEA77FTA22Accident · No injuriesClosedPiper PA-20 · Ismay, MTMay 1, 1977 · N7635K · Substantial damageNTSB SEA77DTI12Accident · No injuriesClosedCessna 182A · Browning, MTApr 29, 1977 · N5913B · Substantial damageNTSB SEA77FTA16Accident · No injuriesClosedPiper J3 · Otter, MTApr 23, 1977 · N70209 · Substantial damageNTSB SEA78DA046Accident · 2 fatalClosedBeech 23 · Lewiston, MTApr 20, 1977 · C-GMUK · DestroyedNTSB SEA77FTI11Accident · Serious injuriesClosedBell 47G3B1 · Polson, MTApr 17, 1977 · N12437 · Substantial damageNTSB SEA77FTA15Accident · No injuriesClosedBeech C-45H · Plentywood, MTApr 3, 1977 · N5043K · Substantial damageNTSB SEA77FTI10Accident · No injuriesClosedPiper PA-28 · Gardiner, MTMar 26, 1977 · C-GDNW · Substantial damageNTSB SEA77FTA14Accident · No injuriesClosedPiper PA-18 · Boyes, MTFeb 25, 1977 · N1313A · Substantial damageNTSB SEA77FTA13Accident · No injuriesClosedPiper PA-28 · Plentywood, MTFeb 20, 1977 · N32532 · Substantial damage