There is a fairly good rule of thumb: use the same preposition that you would use with was or were:
He was in Spain. He arrived in Spain. He was in Cairo. He arrived in Cairo. He was at the station. He arrived at the station. He was at the bus stop. He arrived at the bus stop.