NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 MIA67F0373Accident · No injuriesClosedPiper PA-30 · Greenville, SCDec 19, 1966 · N8147Y · Substantial damageNTSB MIA67A0067Accident · 2 fatalClosedCessna 337A · Nbowling Green, SCDec 19, 1966 · N5303S · DestroyedNTSB MIA67F0342Accident · No injuriesClosedPiper PA-22 · West Columbia, SCDec 16, 1966 · N5482Z · Substantial damageNTSB MIA67F0350Accident · No injuriesClosedPiper PA-23 · Charleston, SCDec 8, 1966 · N6162Y · Substantial damageNTSB MIA67D0316Accident · No injuriesClosedBeech T-34A · Spartanburg, SCNov 19, 1966 · N94595 · Substantial damageNTSB MIA67A0049Accident · 4 fatalClosedPiper PA-22 · Cross, SCOct 17, 1966 · N4502A · DestroyedNTSB MIA67D0264Accident · No injuriesClosedBoeing B75N1 · Trenton, SCOct 13, 1966 · N1390V · DestroyedNTSB MIA67F0262Accident · No injuriesClosedMooney M20E · Columbia, SCSep 22, 1966 · N9359M · Substantial damageNTSB MIA67F0255Accident · No injuriesClosedErcoupe 415-C · Lancaster, SCSep 21, 1966 · N2249H · Substantial damageNTSB MIA67D0260Accident · No injuriesClosedCessna 150 · Hartsville, SCSep 18, 1966 · N8680S · Substantial damageNTSB MIA67A0034Accident · 2 fatalClosedPiper PA-22 · Newberry, SCSep 11, 1966 · N1923P · DestroyedNTSB MIA67F0261Accident · Minor injuriesClosedAeronca 65-LB · St-Stephens, SCSep 10, 1966 · N33701 · DestroyedNTSB MIA67F0252Accident · No injuriesClosedPiper PA-30 · Columbia, SCSep 5, 1966 · N7628Y · Substantial damageNTSB MIA67F0138Accident · No injuriesClosedCessna 172 · Spartanburg, SCSep 4, 1966 · N8070X · Substantial damageNTSB MIA67F0304Accident · No injuriesClosedCallair A-9 · Estill, SCSep 3, 1966 · N3574G · DestroyedNTSB MIA67F0251Accident · No injuriesClosedWaco ASO · Timmonsville, SCSep 2, 1966 · N9500 · Substantial damageNTSB MIA67D0254Accident · No injuriesClosedCessna 210 · Spartanburg, SCSep 2, 1966 · N9542T · Substantial damageNTSB MIA67F0259Accident · No injuriesClosedPiper PA-22 · Pageland, SCAug 22, 1966 · N606A · Substantial damageNTSB MIA67A0028Accident · 1 fatalClosedBoeing D75N1 · Reidville, SCAug 22, 1966 · N65W · DestroyedNTSB MIA67F0253Accident · No injuriesClosedCallair A-9 · Allendale, SCAug 19, 1966 · N3579G · DestroyedNTSB MIA67D0237Accident · No injuriesClosedChampion 7GCB · Darlington, SCAug 18, 1966 · N9951Y · Substantial damageNTSB MIA67A0025Accident · No injuriesClosedBell 47D1 · Crescent Beach, SCAug 13, 1966 · N4253A · Substantial damageNTSB MIA67F0216Accident · Minor injuriesClosedCessna 150D · No. Charleston, SCAug 8, 1966 · N5975T · Substantial damageNTSB MIA67D0143Accident · No injuriesClosedPiper J-3 · Newberry, SCAug 8, 1966 · N42595 · Substantial damageNTSB MIA67F0184Accident · No injuriesClosedPiper PA-25 · Darlington, SCAug 4, 1966 · N7276Z · Substantial damageNTSB MIA67A0021Accident · 1 fatalClosedBrantly B-2 · Charleston Hts, SCAug 4, 1966 · N5943X · Substantial damageNTSB MIA67D0180Accident · No injuriesClosedCessna 185E · Moncks Corner, SCJul 25, 1966 · N4552F · Substantial damageNTSB MIA67A0016Accident · No injuriesClosedBeech D18S · Landrum, SCJul 24, 1966 · N84U · Substantial damageNTSB MIA67A0004Accident · No injuriesClosedHughes 269B · Cope, SCJul 7, 1966 · N9410F · Substantial damageNTSB MIA67D0130Accident · No injuriesClosedCessna 150 · Johns Island, SCJul 4, 1966 · N8483G · Substantial damageNTSB MIA67D0131Accident · No injuriesClosedPiper PA-22 · Johns Island, SCJul 2, 1966 · N3164Z · Substantial damageNTSB MIA67D0089Accident · Minor injuriesClosedAeronca 7AC · Denmark, SCJun 30, 1966 · N85026 · Substantial damageNTSB MIA67F0079Accident · Minor injuriesClosedPiper PA-22 · Starr, SCJun 15, 1966 · N3659P · Substantial damageNTSB MIA67F0053Accident · Minor injuriesClosedPiper PA-28 · Charleston, SCJun 4, 1966 · N4586R · Substantial damageNTSB MIA66A0139Accident · 1 fatalClosedStits Ray SA3 · Columbia, SCMay 29, 1966 · N177S · DestroyedNTSB MIA66F0594Accident · No injuriesClosedCessna 150F · Crescent Beach, SCMay 20, 1966 · N8479G · Substantial damageNTSB MIA66A0135Accident · 1 fatalClosedPiper PA-28 · Summerton, SCMay 19, 1966 · N8632W · DestroyedNTSB MIA67F0052Accident · Serious injuriesClosedCessna 140 · Beaufort, SCMay 18, 1966 · N73023 · Substantial damageNTSB MIA67F0004Accident · No injuriesClosedPiper PA-28 · Ridgeland, SCMay 13, 1966 · N4586R · Substantial damageNTSB MIA66D0626Accident · No injuriesClosedPiper PA-22 · Cayce, SCMay 12, 1966 · N5668Z · Substantial damageNTSB MIA66D0600Accident · Serious injuriesClosedCessna 170 · Darlington, SCMay 7, 1966 · N2595V · Minor damageNTSB MIA66D0589Accident · No injuriesClosedBeech A23 · Greenville, SCMay 5, 1966 · N1467L · Substantial damageNTSB MIA66D0544Accident · No injuriesClosedCessna 182 · Little River, SCMay 4, 1966 · N8607T · Substantial damageNTSB MIA66A0127Accident · No injuriesClosedHughes 269B · Landrum, SCMay 4, 1966 · N9323F · Substantial damageNTSB MIA66D0581Accident · Minor injuriesClosedPiper PA14 · Lane, SCApr 29, 1966 · N4245H · Substantial damageNTSB MIA66A0123Accident · No injuriesClosedHughes 269A · Orangeburg, SCApr 22, 1966 · N8917F · Substantial damageNTSB MIA66A0122Accident · No injuriesClosedBell 47G-5 · Mcbee, SCApr 21, 1966 · N8556F · Substantial damageNTSB MIA66D0521Accident · No injuriesClosedCessna 172 · Bishopville, SCApr 8, 1966 · N2005Y · Substantial damageNTSB MIA66D0510Accident · No injuriesClosedCessna 172 · Moncks Corner, SCMar 27, 1966 · N5340T · Substantial damageNTSB MIA66F0506Accident · Minor injuriesClosedErco 415-C · St Stephen, SCMar 20, 1966 · N93538 · Substantial damage