A woman was confirmed dead at the scene in the incident involving a lorry, two cars, a motorcycle and an excavator.