NTSB investigations, 1965, ID

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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

19642026
NTSB investigations, 1965, ID per year, 1964–2026: 2,504 cases
196470
196549
196662
196764
196865
196947
197054
197157
197241
197348
197463
197556
197663
197748
197843
197956
198044
198140
198247
198341
198441
198546
198650
198725
198829
198922
199030
199130
199237
199326
199439
199535
199633
199731
199841
199946
200034
200124
200248
200352
200440
200538
200630
200740
200834
200937
201037
201133
201240
201332
201430
201527
201622
201731
201828
201933
202024
202139
202227
202329
202435
202522
202619

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\") = 1965
    AND c.\"eventStateOrRegion\" = 'ID' 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 SEA66D0201Accident · No injuriesClosedMooney M20B · Featherville, IDDec 28, 1965 · N74741 · Substantial damageNTSB SEA66F0175Accident · Minor injuriesClosedPiper PA-24 · Idaho Falls, IDNov 30, 1965 · N7163P · Substantial damageNTSB SEA66A0033Accident · 2 fatalClosedNavion A · Lowman, IDNov 20, 1965 · N4203K · DestroyedNTSB SEA66A0029Accident · 1 fatalClosedTaylorcraft BC12-D · Blackfoot, IDNov 2, 1965 · N36328 · DestroyedNTSB SEA66F0155Accident · Serious injuriesClosedPiper PA18A · Homedale, IDOct 31, 1965 · N7195D · Substantial damageNTSB SEA66D0170Accident · No injuriesClosedPiper J-3 · Carey, IDOct 30, 1965 · N32949 · Substantial damageNTSB SEA66F0156Accident · Minor injuriesClosedBriegleb BG-7 · Rexburg, IDOct 17, 1965 · N4565K · Substantial damageNTSB SEA66A0026Accident · 2 fatalClosedStinson V-77 · Boise, IDOct 16, 1965 · N60361 · DestroyedNTSB SEA66F0128Accident · No injuriesClosedCessna 180 · Nampa, IDOct 11, 1965 · N2223C · Substantial damageNTSB SEA66D0137Accident · No injuriesClosedMooney M20E · Twin Falls, IDSep 23, 1965 · N5733Q · Substantial damageNTSB SEA66D0127Accident · No injuriesClosedLuscombe 8A · Priest River, IDSep 18, 1965 · N45831 · Substantial damageNTSB SEA66D0119Accident · No injuriesClosedBird CK · Notus, IDSep 11, 1965 · N765N · Substantial damageNTSB SEA66D0131Accident · No injuriesClosedStinson 108-2 · Bonner Ferry, IDSep 10, 1965 · N265C · Substantial damageNTSB SEA66F0102Accident · Minor injuriesClosedPitts Psig · Idaho Falls, IDSep 4, 1965 · N86G · Substantial damageNTSB SEA66F0135Accident · No injuriesClosedBeechcraft K35 · Cottonwood, IDAug 28, 1965 · N5387E · Substantial damageNTSB SEA66F0091Accident · Serious injuriesClosedPiper PA28 · Blackfoot, IDAug 10, 1965 · N5267W · DestroyedNTSB SEA66F0072Accident · No injuriesClosedPiper PA-22 · Nampa, IDAug 8, 1965 · N6753B · Substantial damageNTSB SEA66F0069Accident · No injuriesClosedBeechcraft S-35 · Hailey, IDAug 5, 1965 · N8922U · Substantial damageNTSB SEA66F0068Accident · Minor injuriesClosedBeechcraft J-35 · Pocatello, IDAug 4, 1965 · N8332D · Substantial damageNTSB SEA66D0059Accident · No injuriesClosedPiper PA-28 · Soda Springs, IDJul 21, 1965 · N8108W · Substantial damageNTSB SEA66A0005Accident · 1 fatalClosedBeech 35 · 4w Malta, IDJul 19, 1965 · N8710A · DestroyedNTSB SEA66F0049Accident · No injuriesClosedPiper PA-24 · Boise, IDJul 16, 1965 · N5811P · Substantial damageNTSB SEA66F0022Accident · No injuriesClosedPiper PA-18A · Idaho Falls, IDJul 13, 1965 · N7172D · DestroyedNTSB SEA66F0020Accident · Minor injuriesClosedPiper PA-18A · Burley, IDJul 13, 1965 · N4874A · DestroyedNTSB SEA66D0043Accident · No injuriesClosedCessna 206 · Sellway, IDJul 11, 1965 · N5229U · Substantial damageNTSB SEA66D0027Accident · No injuriesClosedCessna 180 · Burley, IDJul 10, 1965 · N2787X · Substantial damageNTSB SEA66F0048Accident · Minor injuriesClosedBoeing A75 · Homedale, IDJul 9, 1965 · N4812V · Substantial damageNTSB SEA66F0019Accident · No injuriesClosedPiper PA-18A · Rockford, IDJul 9, 1965 · N7160D · Substantial damageNTSB SEA66A0003Accident · 2 fatalClosedBeech C-45H · Salmon, IDJul 9, 1965 · N9327Z · DestroyedNTSB SEA66F0096Accident · No injuriesClosedPiper PA-18A · Copeland, IDJun 24, 1965 · N1987P · Substantial damageNTSB SEA66D0017Accident · No injuriesClosedCessna 180 · Cascade, IDJun 20, 1965 · N1693C · DestroyedNTSB SEA66F0057Accident · No injuriesClosedFairchild M62C · Homedale, IDJun 18, 1965 · N56110 · Substantial damageNTSB SEA66F0067Accident · No injuriesClosedPiper PA-18A · Paul, IDJun 7, 1965 · N7284D · DestroyedNTSB SEA65F0072Accident · No injuriesClosedCessna 182 · Boise, IDJun 7, 1965 · N1951X · Substantial damageNTSB SEA65F0067Accident · No injuriesClosedBoeing B75N1 · Reubens, IDJun 3, 1965 · N68441 · Substantial damageNTSB SEA66F0047Accident · No injuriesClosedBeechcraft 35 · Caldwell, IDJun 2, 1965 · N3166V · Substantial damageNTSB SEA65F0061Accident · Serious injuriesClosedCessna 172 · Lewiston, IDMay 22, 1965 · N7404X · Substantial damageNTSB SEA65F0069Accident · No injuriesClosedBeechcraft 35 · Blackfoot, IDMay 13, 1965 · N476B · Substantial damageNTSB SEA65D0052Accident · No injuriesClosedCessna 182A · Weiser, IDMay 11, 1965 · N2381G · Substantial damageNTSB SEA65F0041Accident · No injuriesClosedNo American SNJ-5 · Caldwell, IDApr 22, 1965 · N9822C · DestroyedNTSB SEA65F0045Accident · Serious injuriesClosedPiper J-3 · Meadows, IDApr 7, 1965 · N69081 · Substantial damageNTSB SEA65F0023Accident · No injuriesClosedBeech K35 · Boise, IDApr 2, 1965 · N6034E · Substantial damageNTSB SEA65D0034Accident · No injuriesClosedMooney M18C · Idaho Falls, IDMar 20, 1965 · N4073 · DestroyedNTSB SEA65D0040Accident · No injuriesClosedCessna 310 · Soda Springs, IDMar 16, 1965 · N82W · Substantial damageNTSB SEA65F0018Accident · No injuriesClosedCallair A-9 · Genesee, IDMar 9, 1965 · N8268H · Substantial damageNTSB SEA65D0017Accident · 1 fatalClosedCessna 170B · Glenns Ferry, IDMar 8, 1965 · N1957C · DestroyedNTSB SEA65F0056Accident · No injuriesClosedCessna 182 · Twin Falls, IDMar 2, 1965 · N8761X · Substantial damageNTSB SEA65D0024Accident · No injuriesClosedPiper PA-18A · Bancroft, IDFeb 24, 1965 · N7676D · Substantial damageNTSB SEA65D0011Accident · No injuriesClosedPiper PA24 · Challis, IDFeb 2, 1965 · N9003T · Substantial damage