Is there a famous tornado that killed many people?

Yes. There is no shortage of examples. Perhaps the mos infamous is the Tri-State tornado of 1925, which left nearly 700 people dead.