Does making a mistake mean you lose your cert?
Probably not.  Depending on how poor your planning was (or appeared to be) you may have nothing happen, have letter placed in your file (not a violation), receive a violation, have to make a 709 ride with a Fed, or have your cert suspended, or maybe even a combination of some of these.

If you were a real goober and just went flying without checking fuel, and then lied about checking fuel, and then get caught lying to federal investigators then, yeah, revocation is a realistic possibility.  They don't like liars.  They can deal with stupid mistakes, but they will not tolerate a liar.

//thanks for the edit but was written as a runon//