Experimental identification of two distinct skyrmion collapse mechanisms