The team will make an on-the-spot visit.
There will be an on-the-spot inspection of the damaged goods.
As an adverb, its use is mostly idiomatic, where as In a spot is always used idiomatically; as:
I am in a spot. Can you lend me $200 just now?
- For Teachers