NTSB investigations, 1964, SC

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, 1964, SC per year, 1964–2026: 1,853 cases
196446
196541
196658
196749
196862
196939
197051
197142
197258
197343
197449
197551
197639
197744
197856
197928
198029
198132
198252
198340
198435
198536
198625
198735
198841
198927
199023
199120
199231
199324
199430
199532
199619
199728
199828
199926
200019
200113
200221
200322
200420
200522
200617
200715
200820
200929
201019
201121
201221
201313
201413
201512
201615
201712
201821
201918
202013
202122
202221
202321
202410
202519
202615

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\") = 1964
    AND c.\"eventStateOrRegion\" = 'SC' 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 UNK65X0982Accident · No injuriesClosedCessna 182 · Columbia, SCDec 11, 1964 · N9019T · Substantial damageNTSB UNK65X0617Accident · Minor injuriesClosedPiper PA22 · James Island, SCNov 8, 1964 · N5905Z · Substantial damageNTSB UNK65X0514Accident · No injuriesClosedPiper PA24 · Columbia, SCNov 1, 1964 · N8231P · Substantial damageNTSB UNK65X0409Accident · Minor injuriesClosedTaylorcraft BC · Spantanburg, SCOct 24, 1964 · N22654 · Substantial damageNTSB UNK65X0226Accident · No injuriesClosedCurtiss C-46 · Charleston, SCOct 10, 1964 · N7923C · Substantial damageNTSB UNK64X4180Accident · No injuriesClosedWaco UPF7 · Steel Creek Tp, SCSep 27, 1964 · N184E · Substantial damageNTSB UNK64X4154Accident · Minor injuriesClosedAeronca 7AC · Newberry, SCSep 26, 1964 · N81939 · DestroyedNTSB UNK64X4055Accident · No injuriesClosedCessna 175B · Charleston, SCSep 19, 1964 · N8286T · Substantial damageNTSB UNK64X4024Accident · No injuriesClosedPiper PA22 · Kershaw, SCSep 17, 1964 · N2393A · Substantial damageNTSB UNK64X3922Accident · No injuriesClosedCessna 170 · Allendale, SCSep 11, 1964 · N3802V · Substantial damageNTSB UNK64X3675Accident · No injuriesClosedPiper PA28 · Anderson, SCAug 29, 1964 · N7224W · Substantial damageNTSB UNK64X3621Accident · Minor injuriesClosedCallair A9 · Hampton, SCAug 27, 1964 · N3614G · Substantial damageNTSB UNK64X3441Accident · No injuriesClosedAeronca 7AC · Newberry, SCAug 17, 1964 · N81939 · Substantial damageNTSB UNK64X3366Accident · Minor injuriesClosedPiper PA24 · Isle Of Palms, SCAug 13, 1964 · N5854P · DestroyedNTSB UNK64X3251Accident · No injuriesClosedPiper PA11 · Lydia, SCAug 7, 1964 · N4933H · Substantial damageNTSB UNK64X3209Accident · No injuriesClosedCessna 170B · Stuckey, SCAug 4, 1964 · N4588C · Substantial damageNTSB UNK64X3175Accident · No injuriesClosedBellanca 14192 · Laurens, SCAug 2, 1964 · N7699B · Substantial damageNTSB UNK64X3122Accident · No injuriesClosedPiper PA25 · Martin, SCJul 30, 1964 · N6132Z · Substantial damageNTSB UNK64X3027Accident · No injuriesClosedHughes 269A · Bowman, SCJul 25, 1964 · N8828F · Substantial damageNTSB UNK64X3023Accident · No injuriesClosedHughes 269A · Clio S C, SCJul 25, 1964 · N8854F · Substantial damageNTSB UNK64X2990Accident · 1 fatalClosedPiper PA22 · Bethune, SCJul 23, 1964 · N8611D · DestroyedNTSB UNK64X2786Accident · No injuriesClosedPiper PA28 · Johns Island, SCJul 12, 1964 · N7402W · Substantial damageNTSB UNK64X2435Accident · No injuriesClosedPiper PA28 · Columbia, SCJun 22, 1964 · N5780W · Substantial damageNTSB UNK64X2421Accident · Minor injuriesClosedAeronca 11AC · Cherry Grv Bch, SCJun 21, 1964 · N9321E · DestroyedNTSB UNK64X2278Accident · No injuriesClosedPiper PA22 · Ridgeland, SCJun 14, 1964 · N1948P · Substantial damageNTSB UNK64X1831Accident · No injuriesClosedErcoupe 415C · Harleyville, SCMay 18, 1964 · N3333H · Substantial damageNTSB UNK64X1809Accident · No injuriesClosedErcoupe 415C · Isle Of Palms, SCMay 17, 1964 · N94654 · Substantial damageNTSB UNK64X1669Accident · No injuriesClosedPiper PA24 · Cheraw, SCMay 8, 1964 · N5100P · Substantial damageNTSB UNK64X1636Accident · No injuriesClosedErcoupe 415C · Cheraw, SCMay 6, 1964 · N87159 · Substantial damageNTSB UNK64X1527Accident · No injuriesClosedPiper PA28 · Charleston, SCApr 30, 1964 · N6026W · Substantial damageNTSB UNK64X1451Accident · No injuriesClosedBeechcraft 35B33 · Mrytle Beach, SCApr 25, 1964 · N1718G · Substantial damageNTSB UNK64X1386Accident · Serious injuriesClosedFairchild 24 · Pickens, SCApr 19, 1964 · N79860 · DestroyedNTSB UNK64X1232Accident · No injuriesClosedPiper PA30 · Johns Island, SCApr 9, 1964 · N7001Y · Substantial damageNTSB UNK64X1213Accident · Serious injuriesClosedCessna 195 · York, SCApr 7, 1964 · N2185C · DestroyedNTSB UNK64X1171Accident · No injuriesClosedPiper PA22 · Charleston, SCApr 4, 1964 · N5905Z · Substantial damageNTSB UNK64X1113Accident · Minor injuriesClosedPiper PA24 · Lake City, SCMar 30, 1964 · N7100P · Substantial damageNTSB UNK64X1105Accident · Serious injuriesClosedPiper PA22 · Union, SCMar 29, 1964 · N8824C · Substantial damageNTSB UNK64X0818Accident · No injuriesClosedChampion 7FC · West Columbia, SCMar 6, 1964 · N9087B · Substantial damageNTSB UNK64X0622Accident · No injuriesClosedBoeing A75N1 · Campobello, SCFeb 20, 1964 · N9196R · Substantial damageNTSB UNK64X0591Accident · No injuriesClosedCessna 182 · Walterboro, SCFeb 16, 1964 · N4019D · Substantial damageNTSB UNK64X0529Accident · No injuriesClosedChampion 7GCB · Timmonsville, SCFeb 10, 1964 · N9834Y · Substantial damageNTSB UNK64X0443Accident · No injuriesClosedLuscombe 8E · Pontiac, SCFeb 2, 1964 · N1815K · Substantial damageNTSB UNK64X0441Accident · No injuriesClosedPiper PA23 · Spartanburg, SCFeb 2, 1964 · N1104P · Substantial damageNTSB UNK64X0321Accident · No injuriesClosedBeechcraft 95 · Charleston, SCJan 22, 1964 · N238AA · Substantial damageNTSB UNK64X0219Accident · No injuriesClosedBeechcraft N35 · Columbia, SCJan 11, 1964 · N9396Y · Substantial damageNTSB UNK64X0159Accident · Serious injuriesClosedPiper PA-24 · Hartsville, SCJan 5, 1964 · N5121P · Substantial damage