Scuba diving has evolved to become a relatively safe sport. In fact, there are more accidents in a kitchen compared to diving. Nevertheless, you will never know when an accident can happen.
Keep in mind that not all insurances have or provide scuba diving coverage.
Always make sure to check your insurance coverage before going diving.
Why do you need it ? Just think of a small accident and the expenses that follows.