I worked in a district where a principal got a DWI. He was removed from his position in the building and given a promotion to upper admin. He ended up as my supervisor, great admin, nice guy, just had problem with booze. Eventually he tripped up again and was asked to leave. Sad story, the teachers loved him, the kids loved him but he couldn't overcome his alcohol addiction.