Weather warning: North East the ‘prime location’ for storms