NTSB investigations, 1981, ID

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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, 1981, 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\") = 1981
    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 SEA82DYA04Accident · No injuriesClosedPiper PA-28 · Majic Rsrvoir, IDDec 9, 1981 · N7267F · Substantial damageNTSB SEA82FA005Accident · 3 fatalClosedCessna 421C · Shoshone, IDNov 21, 1981 · N8369G · DestroyedNTSB SEA82DYA03Accident · No injuriesClosedPiper PA-32 · Rexburg, IDNov 17, 1981 · N2106J · DestroyedNTSB SEA82FYP05Accident · No injuriesClosedCessna 172F · Orofino, IDNov 13, 1981 · N5428R · Substantial damageNTSB SEA82FA002Accident · 1 fatalClosedCessna 175B · Springfield, IDNov 5, 1981 · N8197T · DestroyedNTSB SEA82DYP02Accident · No injuriesClosedMaule M-5 · Priest River, IDNov 3, 1981 · N56312 · Substantial damageNTSB SEA82DYA02Accident · Minor injuriesClosedLuscombe 8F · Howe, IDOct 15, 1981 · N9018Y · Substantial damageNTSB SEA82FYA01Accident · Serious injuriesClosedChampion 7ECA · Ola, IDOct 1, 1981 · N9056L · DestroyedNTSB SEA81FYP41Accident · No injuriesClosedCessna 170B · Athol, IDSep 20, 1981 · N1954C · Substantial damageNTSB SEA81DYA25Accident · Serious injuriesClosedAerospatle SA315B · Driggs, IDSep 7, 1981 · N47309 · DestroyedNTSB SEA81DYA26Accident · No injuriesClosedCessna 172F · Arco, IDSep 5, 1981 · N5123F · Substantial damageNTSB SEA81DYA27Accident · No injuriesClosedAerospatle SA316B · Driggs, IDAug 30, 1981 · N84850 · Substantial damageNTSB SEA81FA053Accident · 3 fatalClosedSoloy UH-12E · Riggins, IDAug 19, 1981 · N544HA · DestroyedNTSB SEA81DYA24Accident · No injuriesClosedGrumman G-164 · Rigby, IDAug 18, 1981 · N715Y · Substantial damageNTSB SEA81FYA23Accident · No injuriesClosedPiper PA-25 · Caldwell, IDAug 17, 1981 · N7435Z · Substantial damageNTSB SEA81DYA22Accident · Serious injuriesClosedCessna 150M · Driggs, IDAug 13, 1981 · N714GQ · Substantial damageNTSB SEA81FYA21Accident · No injuriesClosedPiper PA-25 · Middleton, IDAug 6, 1981 · N4573Y · DestroyedNTSB SEA81DYP32Accident · Minor injuriesClosedPiper PA-28 · Warren, IDJul 23, 1981 · N2103U · DestroyedNTSB SEA81DYA19Accident · No injuriesClosedCessna 180J · Yellow Pine, IDJul 20, 1981 · N9921N · Substantial damageNTSB SEA81FYP29Accident · No injuriesClosedCessna 177 · Priest River, IDJul 19, 1981 · N2213Y · Substantial damageNTSB SEA81FA047Incident · No injuriesClosedPiper PA-34 · Boise, IDJul 17, 1981 · N40036 · Minor damageNTSB SEA81DYA20Accident · No injuriesClosedCessna 180A · Challis, IDJul 17, 1981 · N9748B · Substantial damageNTSB SEA81DYA16Accident · No injuriesClosedPiper PA-18A · Firth, IDJul 10, 1981 · N7160D · Substantial damageNTSB SEA81DYA15Accident · No injuriesClosedPiper PA-25 · Shelley, IDJul 10, 1981 · N8553L · Substantial damageNTSB SEA81IA045Incident · No injuriesClosedPiper PA-31 · Hailey, IDJun 30, 1981 · N3516A · Minor damageNTSB SEA81FA044Accident · 3 fatalClosedCessna 182Q · Burley, IDJun 26, 1981 · N759NP · DestroyedNTSB SEA81DYA13Accident · No injuriesClosedCessna 188A · Richfield, IDJun 24, 1981 · N8134G · Substantial damageNTSB SEA81FA042Accident · 3 fatalClosedPiper PA-28 · Bliss, IDJun 21, 1981 · N2214X · 2 aircraft · DestroyedNTSB SEA81DYA14Accident · No injuriesClosedPiper PA-32R · Stanley, IDJun 20, 1981 · N3402Q · Substantial damageNTSB SEA81DYA12Accident · Serious injuriesClosedPiper PA-25 · Rockford, IDJun 11, 1981 · N7312Z · Substantial damageNTSB SEA81DYA11Accident · No injuriesClosedGrumman G-164 · Monteview, IDJun 10, 1981 · N730Y · Substantial damageNTSB SEA81FA039Accident · 1 fatalClosedMaule M5235C · Dixie, IDMay 31, 1981 · N5637H · DestroyedNTSB SEA81DYP20Accident · No injuriesClosedPiper PA-28 · Lucille, IDMay 28, 1981 · N38421 · Substantial damageNTSB SEA81FA038Accident · 3 fatalClosedPiper PA-28 · Malad City, IDMay 25, 1981 · N2816F · DestroyedNTSB SEA81FYP18Accident · 1 fatalClosedGrumman G-164B · Harrison, IDMay 23, 1981 · N48574 · Substantial damageNTSB SEA81DYA09Accident · No injuriesClosedCessna 188 · Idaho Falls, IDMay 5, 1981 · N4729Q · Substantial damageNTSB SEA81FYP08Accident · No injuriesClosedCessna 172G · Lewiston, IDMar 3, 1981 · N4612L · Substantial damageNTSB SEA81FYA07Accident · 1 fatalClosedPitts S-1S · Boise, IDJan 10, 1981 · N43BW · DestroyedNTSB SEA81DYA08Accident · No injuriesClosedBellanca 7GCBC · Hailey, IDJan 8, 1981 · N4133Y · Substantial damageNTSB SEA81FA014Accident · 4 fatalClosedBeech V35A · Rexburg, IDJan 2, 1981 · N861S · Destroyed