Adding my voice to sibling comments, this is from European experience, I have had several times been dumped from consulting projects, and having to do competence transfer to the offshoring team that would take over our team roles.

Around five times since 2007.