Safety Level

The view is broken down by Table Name vs. Airline. The view is filtered on Table Name, which keeps 6 of 6 members. Airlines are categorized based on safety level. The level are created as below.

• A-safety - includes airlines which have no incident, no fatal accidents and no fatalities.
• B-safety - includes airlines which have incidents, but no fatal accidents and no fatalities.
• C-safety - includes airlines which have fatalities less than 10.
• D-safety - includes airlines which have fatalities less than 50.
• E-safety - includes airlines which have fatalities less than 100.
• F-safety - includes airlines which have fatalities more than 100.