Adriana La Cerva gets killed in the episode called "Long Term Parking" (Season 5, Episode 12).
Adriana's death isn’t actually shown but Silvio Dante shot her as she crawls out of the frame.
In an interview, Writer Terence Winter was asked Why didn’t you show it? he said:
”I realized that I didn’t want to see it myself. I completely didn’t think about it when I wrote it. But it just felt like the right thing to do, filmically and cinematically. I think it worked really great, but I guess I did not want to see Adriana/Drea get shot. It speaks more to how much we fell in love with this character and that actress."
Check out these 25 things you might not know about The Sopranos shared by Mentalfloss.com.