PWA sometimes stops working on Android with ERR_FAILED

I found a previous version of this error #7045 marked as "Closed" however I believe that this is still very much a problem for Google to address on Android and Chrome.
I downloaded Jake's Super Simple Service Worker: https://github.com/jakearchibald/simple-serviceworker-tutorial and placed it on one of my HTTPS servers, added a manifest, lighthoused it, and after a bit of trial and error got it working on my Android (8.0.0) Chrome (68.0.3440.91) and added to home screen. All works fine both on and off-line however sometimes (random and after a few minutes opening and closing app) when off-line, I get the attached error.

Start with the simple-serviceworker-tutorial example and reproduce the offline flow on Android 8.0.0 with Chrome 68 after repeatedly opening and closing the installed app. Check the service worker, manifest, HTTPS setup, and the reported ERR_FAILED state. Done means identifying a reproducible cause and preventing the offline app from reaching that error.

Written by the indexing model from the issue text.