I am in the final year of BCA with an average score of 56%. Should I pursue MBA in aviation management or M.Sc after my BCA?

This would depend on your interest areas and career aspirations. In case, you intend to pursue a career in Technical/ research/academics area then MCA/ M.Sc. ( IT) is better, However, if you want to move into general management the MBA is a better option.