A man and two children had an "almost miraculous" escape when the car they were travelling in went off a flyover and landed in a mangled heap on the road below.