Police investigating after the motorcycle rider, a woman in her 20s, sadly died at the scene