Does this get activated only when there's an aircraft in the dangerous
vicinity or will it also trigger if the aircraft is hurtling towards
some terrain such as a hill?

And does every aircraft have this system these days, regardless of
size?

Ramapriya