Finding the Galactic Habitable Zone | astrobites mentions
[1107.1286] A Model of Habitability Within the Milky Way Galaxy, which estimates a Type II supernova as having a sterilization distance of about 8 parsecs and a Type Ia one of having a sterilization distance of 20 parsecs.
The sterilization happens from destruction of ozone, which let's more of the planet's star's UV in. It's unlikely to be complete sterilization, however -- there are lots of organisms that live in UV-proof habitats, or may otherwise be able to survive it.
Gamma rays may have devastated life on Earth - 24 September 2003 - New Scientist -- speculation about the end-of-Ordovician mass extinction being due to a gamma-ray burst that does something similar to the Earth's atmosphere.
Type II supernovae will happen wherever there are recently-formed stars, because some of them will be massive to become a Type II supernova. There are about 2*10^(-3) Type II supernovae per year in our Galaxy, the mass density near the Sun is 0.05 solar masses / pc^3, and the mass of the Galactic disk is about 2*10^10 solar masses (http://www.mendeley.com/research/the-mass-distribution-in-the-galactic-disc-i-a-technique-to-determine-the-integral-surface-mass-density-of-the-disc-near-the-sun/; radius of 12 kpc assumed). So the volume of the Galactic disk is about 10^9 cubic parsecs, meaning a Type II supernova rate of 2*10^(-12) per pc^3 per year.
That means about 20 Type-II supernovae less than 8 pc from the Earth over its history, or 2 since the base of the Cambrian. Which may be about right for the end of the Ordovician.
Older stars have a probability of about 1% of becoming a Type Ia supernova; they have to become white dwarfs in close binaries. The rate of Type Ia supernovae in our Galaxy is about 4*10^(-3) per year. Using a Galactic core radius of about 1 kpc, and assuming that most Type Ia's are there, I find a rate of 1*10^(-12) per pc^3 per year. If the Solar System was in the core, it would be exposed to 150 supernovae over its history, and near the center, it would be even worse.