NTSB investigations, 1966, UT

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

19632026
NTSB investigations, 1966, UT per year, 1963–2026: 2,267 cases
19631
196454
196554
196665
196752
196844
196945
197039
197127
197239
197344
197433
197538
197657
197742
197842
197941
198052
198158
198241
198345
198453
198541
198632
198737
198828
198940
199032
199131
199226
199336
199431
199524
199627
199736
199835
199929
200049
200133
200239
200340
200434
200525
200632
200744
200842
200937
201035
201131
201226
201320
201425
201525
201618
201727
201826
201929
202021
202123
202228
202335
202427
202522
202623

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\" = 'UT' 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 DEN67D0186Accident · Minor injuriesClosedAeronca 7AC · Layton, UTDec 16, 1966 · N81973 · Substantial damageNTSB DEN67I0036Incident · No injuriesClosedConvair 580 · Salt Lake City, UTDec 14, 1966 · N73155 · Substantial damageNTSB DEN67A0035Accident · 2 fatalClosedBeech 65-88 · Woods Cross, UTDec 6, 1966 · N886E · DestroyedNTSB DEN67F0170Accident · No injuriesClosedCessna 210 · Ogden, UTNov 4, 1966 · N2375F · Substantial damageNTSB DEN67F0171Accident · No injuriesClosedBeech C35 · Salt Lake City, UTNov 3, 1966 · N756D · Substantial damageNTSB DEN67D0172Accident · No injuriesClosedPiper PA-28 · Tooele, UTOct 30, 1966 · N5132W · Substantial damageNTSB DEN67D0145Accident · No injuriesClosedCessna 310B · Bluff, UTOct 22, 1966 · N6622B · Substantial damageNTSB DEN67F0169Accident · No injuriesClosedCessna 172 · Panguitch, UTOct 14, 1966 · N3659L · Substantial damageNTSB DEN67A0026Accident · 1 fatalClosedCessna 150F · Tooele, UTOct 4, 1966 · N7798F · DestroyedNTSB DEN67D0109Accident · No injuriesClosedCessna 172 · Vernon, UTOct 2, 1966 · N6188E · Substantial damageNTSB DEN67A0028Accident · 4 fatalClosedPiper PA-24 · Alton, UTOct 2, 1966 · N7555P · DestroyedNTSB DEN67F0116Accident · Serious injuriesClosedBeech B35 · Salt Lake City, UTOct 1, 1966 · N8931A · Substantial damageNTSB DEN6MD0107Accident · No injuriesClosedCessna 150D · Salt Lake City, UTSep 20, 1966 · N4448U · Substantial damageNTSB DEN67A0023Accident · No injuriesClosedCessna 182B · Green River, UTSep 20, 1966 · N2365G · Substantial damageNTSB DEN67D0117Accident · No injuriesClosedCessna 150 · Salt Lake City, UTSep 18, 1966 · N4411U · Substantial damageNTSB DEN67D0119Accident · Minor injuriesClosedCessna 180E · Hanksville, UTSep 14, 1966 · N2661Y · DestroyedNTSB DEN67F0100Accident · No injuriesClosedHelio H-295 · Salt Lake City, UTSep 5, 1966 · N6302V · Substantial damageNTSB DEN67F0108Accident · No injuriesClosedCessna 320D · Vernal, UTSep 1, 1966 · N429T · Substantial damageNTSB DEN67D0118Accident · No injuriesClosedCessna 170B · Midvale, UTSep 1, 1966 · N2970D · Substantial damageNTSB DEN67F0093Accident · 1 fatalClosedChampion 7GC · Heber, UTAug 29, 1966 · N7590E · Substantial damageNTSB DEN67A0017Accident · 2 fatalClosedAeronca 11AC · Sandy, UTAug 24, 1966 · N9775E · DestroyedNTSB DEN67D0077Accident · No injuriesClosedCessna 182 · Green River, UTAug 16, 1966 · N4918D · Substantial damageNTSB DEN67A0014Accident · 5 fatalClosedPiper PA-28 · Vernal, UTAug 6, 1966 · N8300W · DestroyedNTSB DEN67D0053Accident · No injuriesClosedCessna 150 · Roosevelt, UTJul 23, 1966 · N2079Z · Substantial damageNTSB DEN67A0008Accident · Serious injuriesClosedHiller UH-12E · Escalante, UTJul 21, 1966 · N5360V · DestroyedNTSB DEN67D0043Accident · No injuriesClosedCessna 170 · Moab, UTJul 16, 1966 · N3455C · Substantial damageNTSB DEN67D0042Accident · No injuriesClosedBellanca 14-13 · Panguitch, UTJul 13, 1966 · N74209 · Substantial damageNTSB DEN66F0044Accident · No injuriesClosedCessna 182 · Sandy, UTJul 10, 1966 · N4968D · Substantial damageNTSB DEN67D0052Accident · No injuriesClosedPiper PA-12 · Blanding, UTJul 9, 1966 · N7909H · Substantial damageNTSB DEN67A0001Accident · 2 fatalClosedCessna T210F · Cisco, UTJul 6, 1966 · N6790R · DestroyedNTSB DEN67F0024Accident · No injuriesClosedN American AT-6 · Delta, UTJul 5, 1966 · N3326G · Substantial damageNTSB DEN67F0029Accident · No injuriesClosedBeech B35 · Salt Lake City, UTJul 2, 1966 · N8693A · Substantial damageNTSB DEN67D0028Accident · No injuriesClosedPiper PA-24 · Coalville, UTJul 2, 1966 · N6884P · Substantial damageNTSB DEN67F0011Accident · Serious injuriesClosedBeec 23 · Bountiful, UTJun 17, 1966 · N2352Z · DestroyedNTSB DEN66F0360Accident · No injuriesClosedPiper PA24 · Salt Lake City, UTJun 16, 1966 · N8771P · Substantial damageNTSB DEN67F0004Accident · Minor injuriesClosedCessna 205 · Erron, UTJun 11, 1966 · N1873Z · Substantial damageNTSB DEN67D0014Accident · Minor injuriesClosedCessna 182A · Dutch John, UTJun 10, 1966 · N5109D · DestroyedNTSB DEN66A0088Accident · Minor injuriesClosedBell 47G3B1 · Ogden, UTJun 7, 1966 · N1323X · Substantial damageNTSB DEN67D0002Accident · No injuriesClosedCessna 150 · Provo, UTJun 5, 1966 · N8654S · Substantial damageNTSB DEN67F0003Accident · Minor injuriesClosedCessna 182 · Salt Lake City, UTJun 2, 1966 · N5185D · Substantial damageNTSB DEN66D0333Accident · No injuriesClosedPiper PA-22 · Hanksville, UTJun 1, 1966 · N829A · Substantial damageNTSB DEN66F0342Accident · No injuriesClosedCessna 182 · Salt Lake City, UTMay 28, 1966 · N8580S · Substantial damageNTSB DEN66D0340Accident · No injuriesClosedCessna 210 · Logan, UTMay 22, 1966 · N9439T · Substantial damageNTSB DEN66F0341Accident · No injuriesClosedPiper PA-25 · St.George, UTMay 15, 1966 · N6389Z · Substantial damageNTSB DEN66F0332Accident · No injuriesClosedBellanca 14-13 · Mexican Hat, UTMay 15, 1966 · N86825 · Substantial damageNTSB DEN66F0339Accident · No injuriesClosedCessna 170 · Oljato, UTMay 14, 1966 · N9130A · Substantial damageNTSB DEN66D0294Accident · No injuriesClosedBeech T-34A · Provo, UTApr 30, 1966 · N12271 · Substantial damageNTSB DEN66F0295Accident · No injuriesClosedBeech G35 · Salt Lake City, UTApr 26, 1966 · N4603D · Substantial damageNTSB DEN66D0309Accident · No injuriesClosedCessna 210A · Riverton, UTApr 23, 1966 · N9418X · Substantial damageNTSB DEN66D0285Accident · No injuriesClosedCessna 120 · Tremonton, UTApr 22, 1966 · N72233 · Substantial damage