NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 SEA67D0218Accident · No injuriesClosedNavion A · Boise, IDDec 24, 1966 · N5235K · Substantial damageNTSB SEA67D0199Accident · No injuriesClosedCessna 172 · Dubois, IDDec 4, 1966 · N1691F · Substantial damageNTSB SEA67D0198Accident · No injuriesClosedTaylorcraft BC12-D · Jerome, IDNov 20, 1966 · N39230 · Substantial damageNTSB SEA67D0177Accident · No injuriesClosedCessna 150 · Twin Falls, IDNov 5, 1966 · N8800S · Substantial damageNTSB SEA67D0178Accident · Minor injuriesClosedCessna 150 · Wayan, IDNov 2, 1966 · N4800X · Substantial damageNTSB SEA67D0164Accident · Minor injuriesClosedAeronca 7AC · Twin Falls, IDOct 29, 1966 · N3085E · Substantial damageNTSB SEA67F0170Accident · No injuriesClosedPiper PA-18 · Weiser, IDOct 28, 1966 · N4395A · Substantial damageNTSB SEA67A0035Accident · 2 fatalClosedCessna 180C · Ngrangeville, IDOct 20, 1966 · N9175T · Substantial damageNTSB SEA67A0034Accident · 3 fatalClosedBeech 35 · Stanley, IDOct 15, 1966 · N3234V · DestroyedNTSB SEA67F0143Accident · No injuriesClosedPiper J4 · Homedale, IDOct 2, 1966 · N22961 · Substantial damageNTSB SEA67D0159Accident · Minor injuriesClosedCessna 150 · Avery, IDOct 1, 1966 · N5812E · DestroyedNTSB SEA67A0028Accident · 5 fatalClosedCessna 185E · Ngrangeville, IDSep 23, 1966 · N1590F · DestroyedNTSB SEA67A0024Accident · No injuriesClosedBell 47G-3 · Challis, IDSep 17, 1966 · N8461E · Substantial damageNTSB SEA67A0023Accident · 3 fatalClosedPiper PA-23 · Stanley, IDSep 14, 1966 · N4242P · Substantial damageNTSB SEA67F0096Accident · 1 fatalClosedWaco UPF-7 · Wilder, IDAug 12, 1966 · N170E · DestroyedNTSB SEA67F0101Accident · Serious injuriesClosedSchweizer 1-26B · Ketchum, IDAug 5, 1966 · N2763R · Substantial damageNTSB SEA67D0094Accident · No injuriesClosedCessna 182 · Caldwell, IDAug 2, 1966 · N9940B · Substantial damageNTSB SEA67D0066Accident · Minor injuriesClosedPiper PA-24 · Challis, IDJul 24, 1966 · N7870P · Substantial damageNTSB SEA67A0006Accident · 3 fatalClosedCessna 172 · Cascade, IDJul 24, 1966 · N988TA · Substantial damageNTSB SEA67D0090Accident · No injuriesClosedPiper PA-18 · Hamer, IDJul 23, 1966 · N7083D · Substantial damageNTSB SEA67D0088Accident · No injuriesClosedCessna 210 · Rigby, IDJul 20, 1966 · N7476E · Substantial damageNTSB SEA67D0067Accident · Minor injuriesClosedPiper PA-18A · Rupert, IDJul 18, 1966 · N7886D · DestroyedNTSB SEA67D0038Accident · No injuriesClosedPiper PA-18A · Clover, IDJul 15, 1966 · N7284D · Substantial damageNTSB SEA67A0003Accident · 1 fatalClosedStinson L-5 · Emmett, IDJul 15, 1966 · N58990 · DestroyedNTSB SEA67D0072Accident · No injuriesClosedCessna 180 · Genesee, IDJul 12, 1966 · N9488C · Substantial damageNTSB SEA67D0063Accident · No injuriesClosedAeronca 7FC · Twin Falls, IDJul 10, 1966 · N7686E · Substantial damageNTSB SEA67D0036Accident · No injuriesClosedCessna 182 · Riggins, IDJul 10, 1966 · N3401S · Substantial damageNTSB SEA67D0031Accident · No injuriesClosedLuscombe 8A · Montpelier, IDJul 10, 1966 · N20687 · Substantial damageNTSB SEA67D0016Accident · No injuriesClosedTaylorcraft BC12-D · Hailey, IDJul 3, 1966 · N39230 · Substantial damageNTSB SEA67D0037Accident · Serious injuriesClosedBellanca 14-13 · Mackay, IDJul 2, 1966 · N41878 · DestroyedNTSB SEA67D0030Accident · No injuriesClosedLuscombe 8E · Idaho City, IDJun 29, 1966 · N1332K · Substantial damageNTSB SEA67D0023Accident · No injuriesClosedPiper PA-18A · Idaho Falls, IDJun 27, 1966 · N7165B · Substantial damageNTSB SEA67D0080Accident · No injuriesClosedPiper PA-24 · Challis, IDJun 25, 1966 · N8982P · Substantial damageNTSB SEA67D0039Accident · Serious injuriesClosedStinson 108 · Buhl, IDJun 25, 1966 · N97306 · DestroyedNTSB SEA67D0058Accident · Minor injuriesClosedPiper PA-24 · Montpelier, IDJun 21, 1966 · N7093P · Substantial damageNTSB SEA67D0012Accident · No injuriesClosedAeronca 15AC · Coeur D'Alene, IDJun 19, 1966 · N1346H · Substantial damageNTSB SEA67D0057Accident · Serious injuriesClosedLuscombe 8A · Challis, IDJun 18, 1966 · N45554 · DestroyedNTSB SEA67D0025Accident · No injuriesClosedCessna 172 · Atomic City, IDJun 17, 1966 · N3826L · Substantial damageNTSB SEA66A0064Accident · 1 fatalClosedPiper PA-18A · St Anthony, IDJun 2, 1966 · N3490Z · DestroyedNTSB SEA66D0279Accident · No injuriesClosedPiper PA-22 · Boise, IDMay 30, 1966 · N5368Z · Substantial damageNTSB SEA67D0011Accident · Minor injuriesClosedCessna 180A · Albion, IDMay 28, 1966 · N7770A · DestroyedNTSB SEA67D0015Accident · No injuriesClosedPiper PA-18A · Swan Valley, IDMay 27, 1966 · N7165B · Substantial damageNTSB SEA66D0300Accident · No injuriesClosedCessna 180 · Grace, IDMay 27, 1966 · N2269C · Substantial damageNTSB SEA66A0061Accident · Minor injuriesClosedCessna 206 · Elk City, IDMay 25, 1966 · N206KA · Substantial damageNTSB SEA66D0283Accident · No injuriesClosedCessna 150C · Orofino, IDMay 16, 1966 · N1964Z · Substantial damageNTSB SEA66D0282Accident · No injuriesClosedCessna 182 · Grangeville, IDMay 15, 1966 · N3824D · Substantial damageNTSB SEA67D0024Accident · Serious injuriesClosedPiper PA-28 · Big Springs, IDMay 14, 1966 · N8108W · DestroyedNTSB SEA66D0269Accident · No injuriesClosedCessna 120 · Boise, IDMay 10, 1966 · N76892 · Substantial damageNTSB SEA66D0263Accident · Minor injuriesClosedPiper PA-22 · Union, IDMay 1, 1966 · N5830P · Substantial damageNTSB SEA66D0246Accident · No injuriesClosedCessna 180 · Moose Creek, IDApr 29, 1966 · N6531A · Substantial damage