What member of the Beatles died from drug overdose?

None of them.

John Lennon was murdered on December 8, 1980 by Mark David Chapman and George Harrison died of Lung Cancer on November 29, 2001. Paul McCartney and Ringo Starr are both still alive.