An explosion that killed one employee and seriously injured another at a chemical plant was described as one of the worst in the history of the pharmaceutical industry in Ireland.