Brahmastra is said to have been used only once when Rama kills Ravana through this. However, Karna tried to use it on Arjuna, but forgot the mantra due the curse given by his Guru Parashuram. In mythology yes a couple of times the famous one is Ashwadhama and Arjuna countering it. Karna and Drona as per KMG used it.