I was trying to open the door from inside and heard a loud "ping" like a metal spring or pin broke and it did not open.
It opens fine from outside but inside handle feels not connected to anything.
I haven't taken anything apart yet, any advice before I do?

 

Go to youtube and look at videos of door panel removal. Also go to DiY forum, Online Manuals post and download the 94-97 Accord manual. It has diagrams and procedures. Pay particular attention to how to remove the inner door handle; remove screw, slide handle assy forward, and release clip to door handle actuator rod. Here is one example:

I would suspect that inside door handle mechanism has failed. I had this happen on 90 Accord. It was a plastic part failure.

After removing inner door handle assy, check whether you can open door by pulling on actuator rod. If problem is w/ connection of rod to door latch mechanism, you may have a more difficult problem to repair.

good luck