Fatal infection is very rare, as noted in the stories below, which apparently cites a specific bacteria in bad tap water. The more common infections appear to be mostly the result of not keeping the Neti Pot clean. Like I said, I use mine sparingly and make sure I keep it clean.
http://well.blogs.nytimes.com/2012/09/03/rare-infection-prompts-neti-pot-warning/
http://www.fda.gov/ForConsumers/ConsumerUpdates/ucm316375.htm
Doctors say its important to keep the risk of Naegleria fowleri contamination in perspective. Most cases are in the South, although some have been documented in the Midwest and as far north as Minnesota. Millions of people swim and dive in lakes and rivers each year, yet from 2002 to 2011 there were only 32 reported Naegleria fowleri infections, according to the disease centers. By comparison, from 1996 to 2005, the most recent period with available data, the United States had more than 36,000 drowning deaths.
With neti pots and other forms of nasal lavage, the greater risk comes from improper cleaning. Bacteria or fungi can form on the spout of a used neti pot or in a partly used nasal lavage bottle. Regular use of an improperly cleaned neti pot or contaminated lavage bottle can lead to chronic irritation or allergies.
And like toothbrushes, neti pots shouldnt be shared with anyone. People with a compromised immune system should consult a doctor before using a neti pot.
(snip)
If you talk about the general population, there are more common things to be aware of and worry about than a scary amoebic infection, said Dr. Hagen, who is also the editor of The Mayo Clinic Book of Home Remedies. Its an opportunity to remind people to be cautious and use good cleaning approaches and maintenance of their neti pot.