My reading is that the "assessment" (tax) will be borne by all banks, not just the bank that fails.
My gut says that the incidence will fall primarily on deposit holders (likely in the form of marginally lower interest rates), and not significantly on bank equity holders, but I suspect it'd take an econ phd to fully parse that out.
Shareholders and bondholders will likely lose everything as nothing will be left after selling off assets.