Why do parasites sometimes kill their hosts?
I can think of several (non-exclusive and probably non-exhaustive) hypotheses:


Maladaptive. It is maladaptive. Maybe because it is a virus coming from another species (e.g. SIV and HIV) or because it is not adapted to our modern lifespan.
Benefit of the host immune system to the parasite. Some parasites might benefit from host immune defence (e.g. sneezing helps bacteria to spread) and death is a consequence of the selection for increasing disease symptoms to the host.
Pathogen's and host's fate. The pathogen's fate is not linked to the host's fate. This is especially true if the pathogens spread well (easily jump from one host to another) I guess or for parasitoïd because the pathogen leaves its parasitic life after the death of its single host.
intra- and inter-host selection. Among hosts, there might have a selection for reducing resource consumptions and therefore for decreasing the probability for the host to die. But within a host (among individuals of a parasite population or even among parasite species), it is a prisoner's dilemma (tragedy of the commons). The more you invest in foraging, the more competitive you are. This might not be adaptative at the population level but it is at the individual level. We might think of this prisoner's dilemma happening among individuals of a single parasite species or among several parasite species. You may want to have a look at the work of Martin Nowak on the subject incl. Consider for example his book; Evolutionary Dynamics.
Consequence of harming on trade-offs. Harming an individual will cause him not to spend energy into reproduction in order that more energy is available for the pathogen use. Moreover, by causing symptoms, the infected individual will be sexually less attractive and will again have less opportunity to spend energy into reproduction.
The pathogen does not mean much harm. When fighting pathogens, many of the symptoms we experience (such as fever typically) are actually caused by the immune system and not the pathogen itself. A maladaptive overreaction of the immune system can cause our death.


The book Why we get sick by Randolph Nesse and George Williams, will probably interest you.