Regular incandescents won't consume any electricity if the bulb is dead, since there's no continuous path for the current to take. It's just like an open switch. With CFLs and LEDs, it depends on why the bulb burned out, but in general they will consume some amount of electricity even when burned out.