DC9-32 CREW MADE A NIGHT APCH TO THE WRONG ARPT AT CAE.

Narrative

THE FLT WAS FROM ZZZ; US; TO COLUMBIA; SC; (CAE); AT NIGHT. ABOUT 15 NM N OF THE COLUMBIA VOR WE LEVELED OFF AT 10000 FT TO SLOW TO 250 KIAS. AT THAT POINT COLUMBIA APCH HAD CLRED US DOWN TO 2000 FT. OUR HEADING WAS ABOUT 150 DEGS PROCEEDING DIRECT THE VOR (CAE); TIME XA30 EASTERN. AT THIS POINT WE HAD 2 ARPT BEACONS IN SIGHT; THAT OF OUR DEST CAE; COLUMBIA METRO AND THAT OF A 2ND ARPT COLUMBIA OWENS DOWNTOWN. I ASKED APCH TO VERIFY THE LOCATION OF CAE; 'IS IT AT 12 OR 2 O'CLOCK POS' I ASKED. APCH ANSWERED AT 12 O'CLOCK POS; AT WHICH POINT WE PROCEEDED TO A R DOWNWIND LEG AT THAT ARPT; WHICH TURNED OUT TO BE COLUMBIA OWENS DOWNTOWN. TURNING BASE LEG COLUMBIA TWR ASKED US IF WE HAD TURNED YET (APPARENTLY HE DIDN'T HAVE US IN SIGHT); WHICH I ACKNOWLEDGED. HE ASKED US IF WE HAD THE ARPT IN SIGHT NOW AT ABOUT 2 O'CLOCK POS 8 MI; OF WHICH I ANSWERED THAT IT LOOKED MORE LIKE 4 MI. AT THIS POINT WE HAD THE GEAR DOWN AND INTERMEDIATE FLAP SETTING AND WERE AT ABOUT 1500 FT MSL. TWR REALIZED WE WERE AT THE WRONG ARPT AND TOLD US TO CLB TO 1700 FT FLY A 200 DEG HDG AND LOOK FOR THE RIGHT ARPT; CAE. WE INITIATED A MISSED APCH AND LANDED WITHOUT INCIDENT AT CAE. 2 FACTORS CONTRIBUTED TO THIS: 1) APCH CTL'S INCORRECT POINTING OUT OF THE ARPT AND 2) UNFAMILIARITY OF BOTH PLTS WITH THE ARPTS AND FAILURE TO LOCATE COLUMBIA OWENS DOWNTOWN ON THE APCH PLATE.