It’s inevitable that people make mistakes. Often, the impact of these mistakes are high - sometimes it breaks other team’s code, introduces regressions which can lurk around for a long time. On large projects, especially where a good chunk of legacy is in play, mistakes happen more often and are way more harder to find.
You can also make a mistake by having the wrong idea; you stick to it, pour more and more of your (and others’) energy into it, and it turns out not being a solution to your problem.
At the end of the day, you will fail as everyone else, and you have to be able to make that failure useful, so it can contribute to your next success.