While it was a scientist who proposed piltdown man as an ancestor to humans, the vast majority of scientists never accepted the finding and it was soon determined to be a fraud by scientists, not by creationists.
This does not show that science is inadequate or faulty but rather that it can learn from its mistakes, improve, get closer to the truth. It is a self-correcting system and falsities are weeded out as more and more evidence is uncovered.