Pathways towards instability in financial networks