The most hairs-on-the-back-of-the-neck-standing-up female vocal duet song I know is this one:
Landini, Ecco la primavera
The second half of that video is the unaccompanied one, probably the way it was meant to be sung. Syntagma Musicum did the best version of it I've heard.