Will Vancouver Island sink when a megathrust earthquake occurs?
No. Vancouver Island is part of the North American plate. The fact that there is water between Vancouver Island and the mainland is function of the current position of sea level. However, the west coast of Vancouver Island will drop as much as a metre or two when the next megathrust earthquake occurs.
