Smaller companies with ageing North Sea assets were especially vulnerable to financial losses, researchers found.