NTSB investigations, 1965, 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, 1965, 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\") = 1965
    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 MIA66A0075Accident · 2 fatalClosedUniv Acft GC-1B · Greenville, SCDec 31, 1965 · N2381B · DestroyedNTSB MIA66F0376Accident · Serious injuriesClosedPiper PA22 · Lexington, SCDec 28, 1965 · N4502Z · Substantial damageNTSB MIA66D0361Accident · No injuriesClosedPiper J3C-65 · St George, SCDec 12, 1965 · N98519 · Substantial damageNTSB MIA66F0343Accident · No injuriesClosedPiper PA-22 · Beaufort, SCDec 1, 1965 · N4593Z · DestroyedNTSB MIA66D0339Accident · No injuriesClosedPiper PA-22 · Greenville, SCNov 28, 1965 · N5265Z · Substantial damageNTSB MIA66D0344Accident · No injuriesClosedPiper PA-28 · Pinewood, SCNov 25, 1965 · N8293W · Substantial damageNTSB MIA66D0347Accident · No injuriesClosedPiper PA-24 · Chester, SCNov 13, 1965 · N7375P · Substantial damageNTSB MIA66A0046Accident · 1 fatalClosedPiper PA-18 · Gaffney, SCOct 25, 1965 · N8794D · DestroyedNTSB MIA66D0318Accident · No injuriesClosedPiper J3C-65 · Monetta, SCOct 11, 1965 · N7023H · Substantial damageNTSB MIA66A0039Accident · 1 fatalClosedMong Sport BR SPL · Summerville, SCOct 10, 1965 · N47L · DestroyedNTSB MIA66F0281Accident · No injuriesClosedPiper PA-22 · Columbia, SCOct 5, 1965 · N9630D · Substantial damageNTSB MIA66F0278Accident · No injuriesClosedGlobe GC-1B · Harleyville, SCAug 29, 1965 · N2395B · DestroyedNTSB MIA66D0256Accident · No injuriesClosedPiper PA-24 · Barnwell, SCAug 20, 1965 · N8839P · Substantial damageNTSB MIA66F0174Accident · No injuriesClosedCessna 172 · Little Mtn., SCAug 18, 1965 · N7476A · Substantial damageNTSB MIA66F0146Accident · Serious injuriesClosedPiper PA-25 · Bennettsville, SCAug 6, 1965 · N6673Z · Substantial damageNTSB MIA66D0153Accident · No injuriesClosedCessna 210 · Charleston, SCJul 25, 1965 · N4974U · Substantial damageNTSB MIA66A0015Accident · No injuriesClosedHughes 269B · Cope, SCJul 21, 1965 · N9410F · Substantial damageNTSB MIA66D0087Accident · No injuriesClosedCessna 205 · Florence, SCJul 14, 1965 · N8420Z · Substantial damageNTSB MIA66A0002Accident · No injuriesClosedHughes 269A · Bishopville, SCJul 2, 1965 · N8858F · Substantial damageNTSB MIA65A0121Accident · 1 fatalClosedPiper PA-18 · Hartsville, SCJun 18, 1965 · N7160B · DestroyedNTSB MIA65A0120Accident · No injuriesClosedHughes 269A · Lamar, SCJun 18, 1965 · N8853F · Substantial damageNTSB MIA66F0022Accident · No injuriesClosedPiper PA-30 · Charleston, SCJun 11, 1965 · N7447Y · Substantial damageNTSB MIA66D0038Accident · No injuriesClosedCessna 172E · Bamberg, SCJun 6, 1965 · N3650S · Substantial damageNTSB MIA65F0105Accident · Minor injuriesClosedCessna 172 · Mcbee, SCMay 16, 1965 · N8288B · Substantial damageNTSB MIA65D0109Accident · Serious injuriesClosedCessna 182 · Anderson, SCMay 4, 1965 · N8430T · No damageNTSB MIA65F0127Accident · No injuriesClosedAeronca 7AC · Rock Hill, SCApr 29, 1965 · N82989 · Substantial damageNTSB MIA65D0049Accident · No injuriesClosedCessna 172 · Anderson, SCApr 8, 1965 · N3744S · Substantial damageNTSB MIA65F0060Accident · No injuriesClosedRepublic RC-3 · Georgetown, SCApr 6, 1965 · N6103K · Substantial damageNTSB UNK65X1479Accident · No injuriesClosedCallair A-9 · Allendale, SCMar 27, 1965 · N3579G · Substantial damageNTSB MIA65F0037Accident · Serious injuriesClosedMonocoupe 125 · Johns Island, SCMar 25, 1965 · N797H · Substantial damageNTSB MIA65F0036Accident · No injuriesClosedPiper PA-24 · Georgetown, SCMar 14, 1965 · N8367P · Substantial damageNTSB MIA65F0033Accident · No injuriesClosedStinson 10A · Greenville, SCMar 14, 1965 · N22535 · Substantial damageNTSB MIA65F0041Accident · No injuriesClosedStinson 108-1 · Hampton, SCMar 7, 1965 · N97091 · Substantial damageNTSB MIA65F0016Accident · No injuriesClosedPiper J3C · New Ellenton, SCFeb 27, 1965 · N87841 · Substantial damageNTSB UNK65X1440Accident · No injuriesClosedCessna 182 · Varnville, SCFeb 20, 1965 · N2435R · Substantial damageNTSB MIA65I0081Incident · 1 fatalClosedCessna 172F · Aiken, SCFeb 9, 1965 · N3021U · DestroyedNTSB MIA65A0078Accident · 1 fatalClosedBeech C35 · Awendaw, SCFeb 3, 1965 · N1815D · DestroyedNTSB UNK65X1322Accident · No injuriesClosedNorth AM P51D · Myrtle Beach, SCJan 20, 1965 · N2251D · Substantial damageNTSB UNK65X1255Accident · No injuriesClosedPiper PA28 · Ridgeland, SCJan 8, 1965 · N6309W · Substantial damageNTSB UNK65X1246Accident · Minor injuriesClosedPiper PA24 · Jamestown, SCJan 7, 1965 · N6242P · Substantial damageNTSB UNK65X1245Accident · No injuriesClosedBeechraft D95A · Charleston, SCJan 7, 1965 · N179Q · Substantial damage