If you look at it from the point of view of you, the homeowner, then you don't see a good plumber but merely a plumber that follows procedures so the job is done correctly. Likewise, you see a bad plumber that screwed up the job and flooded your house.
Perhaps the "good" part of being a good plumber is doing the job correctly every single time and not making mistakes. If this were the case then I'd argue you are a perfect plumber. At what point on the scale does a mistake or mistakes take you from good to bad? A plumber with a 90% success rate is, in my definition, a good plumber as the stakes are not as high. A surgeon or airline pilot, in my mind, must have a 100% success rate in order to be considered competent since lives are at stake.
You'd be hard pressed to show that a former CEO that now has a different position at another company is not a CEO due to being a bad CEO as they likely wouldn't be hired at all for any high-level position.
To wrap this up, if there was still a plumber out there that was a bad plumber then I suspect he/she wouldn't be a plumber long enough to still get jobs.
A good plumber can make your house run better if they come up with a more efficient or innovative way of doing a process that you didn't think about but in your mind that wouldn't make them a good plumber but merely a plumber that follows processes and doesn't make mistakes. If not for mistakes then we may never find better ways of doing something.