Thalidomide was supposed to be the wonder drug that helped women manage morning sickness until they discovered it caused birth defects. Asbestos was supposed to be the ultimate fire resistant material that was later found out to cause mesothelioma when produced or when disturbed.
