That's why it is always good to take extra precautions and backup saved game data, like whole neighborhoods. However, improperly installed mods or mods that do not work correctly can result in corrupt data, saved game losses, and severe glitches.
Mods, when they are programmed, installed and used correctly, can be safe to use without risking damage to game data or saved games.