Safety-critical Geometric Control Design with Application to Aerial Transportation