In the two centuries since the first attempt , the majority of plots have been uncovered or prevented , however several have come close to achieving their aims , and four have resulted in the successful assassination of a sitting president .