NTSB investigations, 1970, 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, 1970, 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\") = 1970
    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 SEA71FDG18Accident · No injuriesClosedCessna 205 · Winston, MTDec 17, 1970 · N8383Z · Substantial damageNTSB SEA71DDG20Accident · No injuriesClosedCessna 182 · Dutton, MTDec 17, 1970 · N71654 · Substantial damageNTSB SEA71DDA11Accident · No injuriesClosedPiper PA-18 · Garryowen, MTDec 4, 1970 · N8109Y · Substantial damageNTSB SEA71FDG19Accident · No injuriesClosedCessna 120 · Whitewater, MTDec 1, 1970 · N77416 · Substantial damageNTSB SEA71FDA08Accident · No injuriesClosedCessna 180H · Billings, MTNov 15, 1970 · N4772U · Substantial damageNTSB SEA71DDA10Accident · No injuriesClosedCessna 150F · Glendive, MTNov 15, 1970 · N3557L · Substantial damageNTSB SEA71DDA09Accident · No injuriesClosedAeronca 7AC · Opheim, MTNov 15, 1970 · N81782 · Substantial damageNTSB DEN71AD020Accident · 5 fatalClosedCessna 180 · Missoula, MTNov 1, 1970 · N1757C · 2 aircraft · DestroyedNTSB SEA71DDG17Accident · No injuriesClosedPiper PA-28 · Livingston, MTOct 31, 1970 · N7164R · Substantial damageNTSB SEA71FDG16Accident · Serious injuriesClosedMooney M20F · Cameron, MTOct 30, 1970 · N9646M · Substantial damageNTSB SEA71AS023Accident · 2 fatalClosedPiper PA-14 · Carlyle, MTOct 30, 1970 · N4266H · DestroyedNTSB SEA71DDG14Accident · Minor injuriesClosedMooney M20C · Melrose, MTSep 17, 1970 · N5637Q · Substantial damageNTSB SEA71FDG13Accident · No injuriesClosedCessna 170A · Fort Benton, MTSep 14, 1970 · N9543A · Substantial damageNTSB SEA71DDG11Accident · No injuriesClosedCessna 210 · Missoula, MTAug 30, 1970 · N6921R · Substantial damageNTSB SEA71AS010Accident · 1 fatalClosedMooney M20E · Big Fork, MTAug 23, 1970 · N6013Q · DestroyedNTSB SEA71DDA07Accident · No injuriesClosedTaylorcraft BC12-D · Melstone, MTAug 21, 1970 · N43333 · Substantial damageNTSB SEA71DDG10Accident · No injuriesClosedCessna 172A · Loring, MTAug 19, 1970 · N7308T · Substantial damageNTSB SEA71FDA05Accident · Serious injuriesClosedStinson 108-2 · Red Lodge, MTAug 17, 1970 · N454C · DestroyedNTSB SEA71DDA06Accident · No injuriesClosedCessna 180 · Kirby, MTAug 16, 1970 · N2951C · Substantial damageNTSB SEA71FDG09Accident · No injuriesClosedMooney M20A · Libby, MTAug 13, 1970 · CF-WKP · Substantial damageNTSB SEA71FDA04Accident · No injuriesClosedPiper PA-18A · Garryowen, MTAug 13, 1970 · N1190C · Substantial damageNTSB SEA71FDG15Accident · No injuriesClosedMooney M20E · Kalispell, MTAug 11, 1970 · N9228V · Substantial damageNTSB SEA71FDA02Accident · No injuriesClosedCessna 170B · Billings, MTAug 7, 1970 · N2304D · Substantial damageNTSB SEA71DDG08Accident · Minor injuriesClosedCessna 172 · Butte, MTAug 5, 1970 · N84748 · Substantial damageNTSB SEA71DDA03Accident · No injuriesClosedPiper PA-18 · Lavina, MTAug 4, 1970 · N5480H · Substantial damageNTSB SEA71FDG07Accident · No injuriesClosedLuscombe 8F · Butte, MTAug 2, 1970 · N1995B · Substantial damageNTSB SEA71FDG06Accident · No injuriesClosedBeech J35 · Helena, MTJul 21, 1970 · N3036C · Substantial damageNTSB SEA71FDG05Accident · No injuriesClosedPiper PA-23 · Helena, MTJul 16, 1970 · N1279P · Substantial damageNTSB SEA71DDG04Accident · No injuriesClosedPiper PA-18A · Brady, MTJul 15, 1970 · N2696P · Substantial damageNTSB SEA71FDG03Accident · No injuriesClosedPiper J3 · Cut Bank, MTJul 9, 1970 · N31162 · Substantial damageNTSB SEA71FDA01Accident · No injuriesClosedBeech A-23 · Roundup, MTJul 7, 1970 · N8886M · Substantial damageNTSB SEA71DDG02Accident · No injuriesClosedStinson 108-2 · Floweree, MTJul 7, 1970 · N9850K · Substantial damageNTSB SEA71FDG01Accident · No injuriesClosedPiper PA-25 · Gallatin Gwy, MTJul 3, 1970 · N6441Z · Substantial damageNTSB SEA70DDG15Accident · No injuriesClosedPiper PA-32 · Three Forks, MTJun 30, 1970 · N4193W · Substantial damageNTSB SEA70DDG13Accident · No injuriesClosedPiper PA-28 · Fairfield, MTJun 28, 1970 · N7338J · Substantial damageNTSB SEA70FDA16Accident · Serious injuriesClosedPiper PA-18 · Wolf Point, MTJun 27, 1970 · N7078B · DestroyedNTSB SEA70DDG14Accident · No injuriesClosedCessna 172 · Kremlin, MTJun 27, 1970 · N8251X · Substantial damageNTSB SEA70FDA15Accident · No injuriesClosedCessna 182 · Joliet, MTJun 24, 1970 · N5417B · Substantial damageNTSB SEA70DDA17Accident · No injuriesClosedPiper PA-18 · Poplar, MTJun 21, 1970 · N3595Z · Substantial damageNTSB SEA70DDG12Accident · No injuriesClosedCessna 172G · Belgrade, MTJun 16, 1970 · N6029R · Substantial damageNTSB SEA70DDA14Accident · No injuriesClosedCessna 150 · Billings, MTJun 15, 1970 · N5656G · Substantial damageNTSB SEA70FDG11Accident · 1 fatalClosedPiper PA-18 · Turner, MTJun 12, 1970 · N1917A · DestroyedNTSB SEA70FDA12Accident · No injuriesClosedCallair A-9 · Moore, MTJun 7, 1970 · N7230V · Substantial damageNTSB SEA70FDA11Accident · No injuriesClosedPiper PA-25 · Lindsay, MTJun 6, 1970 · N6483Z · Substantial damageNTSB SEA70FDG09Accident · No injuriesClosedHiller Acft UH-12B · Sandcoulee, MTJun 3, 1970 · N3112G · Substantial damageNTSB SEA70FDG08Accident · No injuriesClosedPiper PA-18 · Cascade, MTJun 3, 1970 · N4884A · Substantial damageNTSB SEA70DDA10Accident · No injuriesClosedPiper PA-18 · Sidney, MTJun 3, 1970 · N3190Z · Substantial damageNTSB SEA70FDA09Accident · No injuriesClosedPiper PA-28 · Baker, MTJun 1, 1970 · N8641W · Substantial damageNTSB SEA70DDA08Accident · No injuriesClosedPiper PA-25 · Billings, MTMay 31, 1970 · N4337Y · Substantial damageNTSB SEA70FDG06Accident · 1 fatalClosedPiper PA-25 · Big Sandy, MTMay 25, 1970 · N7003Z · Destroyed