It's important to note that the book doesn't explicitly state that this is what caused him to see Thestrals. However, seeing someone die is the only way described in the series for a person to be able to see Thestrals.
This event, combined with the trauma of his parents being tortured into insanity, helps explain Neville's initial anxieties and his later growth into a brave and powerful wizard.