NTSB investigations, 1976, ID

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

19642026
NTSB investigations, 1976, 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\") = 1976
    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 SEA77DYP15Accident · No injuriesClosedCessna 170B · Lewiston, IDDec 20, 1976 · N2392D · Substantial damageNTSB SEA77FYA08Accident · No injuriesClosedPiper PA-28R · Glenns Ferry, IDNov 27, 1976 · N4513F · Substantial damageNTSB SEA77FA008Accident · 1 fatalClosedPiper PA-28R · Sandpoint, IDNov 22, 1976 · N15987 · DestroyedNTSB SEA77FYA06Accident · Minor injuriesClosedCessna 150L · Mountain Home, IDNov 14, 1976 · N6788G · Substantial damageNTSB SEA77DYA05Accident · Minor injuriesClosedCessna 150 · Blackfoot, IDNov 6, 1976 · N4047J · Substantial damageNTSB SEA77DYA07Accident · No injuriesClosedCessna T210K · Challis, IDOct 27, 1976 · N8231M · Substantial damageNTSB SEA77FYA04Accident · Serious injuriesClosedSchweizer SGU222 · Boise, IDOct 24, 1976 · N2787Z · Substantial damageNTSB SEA77DYA03Accident · Minor injuriesClosedLake LA-4 · Boise, IDOct 20, 1976 · N6023V · Substantial damageNTSB SEA77DYG01Accident · No injuriesClosedCessna 182D · Cottonwood, IDOct 17, 1976 · N8713X · DestroyedNTSB SEA77DYA02Accident · Minor injuriesClosedPiper PA-22 · Malta, IDOct 9, 1976 · N8439D · Substantial damageNTSB SEA77DYA01Accident · No injuriesClosedStinson 108 · Soda Springs, IDOct 8, 1976 · N97182 · Substantial damageNTSB SEA77FYG04Accident · Serious injuriesClosedCessna 172 · Grangeville, IDOct 2, 1976 · N1641F · No damageNTSB SEA76DYG67Accident · No injuriesClosedHiller Acft UH-12E · Clark Fork, IDSep 27, 1976 · N62409 · Substantial damageNTSB SEA76DYA48Accident · No injuriesClosedHiller Acft UH-12E · Jerome, IDSep 8, 1976 · N62346 · Substantial damageNTSB SEA76AS075Accident · 1 fatalClosedPiper PA-28 · Mountain Home, IDSep 6, 1976 · N5916W · Substantial damageNTSB SEA76FYA46Accident · 4 fatalClosedPiper PA-22 · American Falls, IDAug 27, 1976 · N1401C · DestroyedNTSB SEA76AS072Accident · 1 fatalClosedPiper PA-23 · Blackfoot, IDAug 27, 1976 · N4306P · DestroyedNTSB SEA76AS073Accident · 1 fatalClosedCessna TU206E · Salmon, IDAug 25, 1976 · N1383M · DestroyedNTSB SEA76DYA44Accident · No injuriesClosedAero Comdr 600S2R · Rexburg, IDAug 2, 1976 · N4990X · Substantial damageNTSB SEA76FYG70Accident · 1 fatalClosedCessna 188 · Lewiston, IDJul 30, 1976 · N53151 · DestroyedNTSB SEA76DYA45Accident · No injuriesClosedCallair B1A · Newdale, IDJul 29, 1976 · N7260V · Substantial damageNTSB SEA76AS063Accident · 4 fatalClosedBeech H35 · Mccall, IDJul 24, 1976 · N5423D · DestroyedNTSB SEA76FYA42Accident · Minor injuriesClosedPiper PA-25 · Parma, IDJul 21, 1976 · N6748Z · DestroyedNTSB SEA76DYA41Accident · No injuriesClosedPiper PA-25 · Fruitland, IDJul 20, 1976 · N6751Z · DestroyedNTSB SEA76DYA40Accident · Minor injuriesClosedPiper PA-25 · Hamer, IDJul 16, 1976 · N4618Y · Substantial damageNTSB SEA76FYG71Accident · No injuriesClosedCessna 310Q · Coolin, IDJul 15, 1976 · N7709Q · Substantial damageNTSB SEA76DYA39Accident · No injuriesClosedHughes 269A · Gooding, IDJul 10, 1976 · N7432F · Substantial damageNTSB SEA76DYA36Accident · No injuriesClosedBell 47G3B2 · Gooding, IDJul 8, 1976 · N1424W · Substantial damageNTSB SEA76FYA35Accident · 1 fatalClosedAero Comdr A-9 · Nampa, IDJul 7, 1976 · N8400V · DestroyedNTSB SEA76DYA34Accident · No injuriesClosedCessna A188B · Grays Lake, IDJul 7, 1976 · N53216 · Substantial damageNTSB SEA76DYA33Accident · Minor injuriesClosedCallair A-9 · Grandview, IDJul 6, 1976 · N7214V · Substantial damageNTSB SEA76AS059Accident · 5 fatalClosedGrum Amer AA-5A · Boise, IDJul 5, 1976 · N9724U · DestroyedNTSB SEA76DYG59Accident · Minor injuriesClosedPiper PA-12 · Worley, IDJun 30, 1976 · N3131M · Substantial damageNTSB SEA76DYA31Accident · No injuriesClosedPiper PA-24 · Burley, IDJun 30, 1976 · N9327P · Substantial damageNTSB SEA76FYG62Accident · No injuriesClosedCessna 188B · Lewiston, IDJun 29, 1976 · N9919G · Substantial damageNTSB SEA76DYA32Accident · Minor injuriesClosedPiper PA-25 · Georgetown, IDJun 28, 1976 · N6342Z · DestroyedNTSB SEA76FYA29Accident · Serious injuriesClosedLaister LK-10B · Howe, IDJun 27, 1976 · N24189 · Substantial damageNTSB SEA76FYA28Accident · Serious injuriesClosedTaylorcraft BC12-D · Mountain Home, IDJun 23, 1976 · N36430 · Substantial damageNTSB SEA76DYG69Accident · No injuriesClosedHiller Acft UH-12E · Nezperce, IDJun 17, 1976 · N5944V · Substantial damageNTSB SEA76DYA27Accident · No injuriesClosedPiper PA-20 · Council, IDJun 15, 1976 · N1018Z · Substantial damageNTSB SEA76DYA26Accident · No injuriesClosedHiller Acft UH-12E · Rupert, IDJun 10, 1976 · N68021 · DestroyedNTSB SEA76DYA30Accident · No injuriesClosedBeech D95A · Rexburg, IDJun 7, 1976 · N499G · Substantial damageNTSB SEA76DYA25Accident · No injuriesClosedGrumman G-164A · Hamer, IDJun 5, 1976 · N7863 · Substantial damageNTSB SEA76DYG35Accident · No injuriesClosedBoeing B75N1 · Nezperce, IDJun 4, 1976 · N65573 · Substantial damageNTSB SEA76AS051Accident · 4 fatalClosedStinson 108-1 · Burley, IDMay 23, 1976 · N8480K · DestroyedNTSB SEA76AS049Accident · 2 fatalClosedCessna 172K · Weiser, IDMay 21, 1976 · N7148G · DestroyedNTSB SEA76FYA24Accident · No injuriesClosedBell 47G3B1 · Burley, IDMay 17, 1976 · N47042 · Substantial damageNTSB SEA76FYG48Accident · Serious injuriesClosedEnstrom F-28A · White Bird, IDApr 23, 1976 · N715BP · DestroyedNTSB SEA76DYG47Accident · Minor injuriesClosedHiller Acft UH-12E · Worley, IDApr 22, 1976 · N101EH · Substantial damageNTSB SEA76DYG43Accident · No injuriesClosedGrumman G-164A · Genesee, IDApr 13, 1976 · N7372 · Substantial damage