Flight
Charlotte is the by far biggest airport in the area - it's about 1.5hrs from Columbia
Flight
Columbia is the closest airport, however it is only a regional one
Flight
Charleston Airport is about 1.5hrs away from Columbia but a great option if you're planning to do sightseeing there on the front- or backend!