Can you connect something like a raspberry pi to the modem and send a request to some server?

You could build a heartbeat app. So you send a request to the heartbeat app and just save the timestamp of the last request.

If the heartbeat app doesn't get a request for some time, you can assume the modem or e.g. raspberry is down.