Yes, South Carolina State Fairgrounds is close to Columbia and is a great place to spend time with the family when the weather is right. Amusement parks and waterparks are often most enjoyable when the weather is 70 degrees fahrenheit or more and the chance of rain is moderate at most. With that in mind, consider planning your flight to Columbia for June or September if these attractions interest you or your family.