Aviation Occurrence Categories

Introduction

“Occurrence” is defined as “accident or incident”. This includes accidents or incidents, as defined in Annex 13 to the Convention on International Civil Aviation, involving manned aircraft or unmanned aircraft that have a design and/or operational approval. Generally, accidents and incidents differ only in the degree of injury sustained by persons involved or in damage sustained to the aircraft. Each category has a unique name and identifier to permit common coding in accident/incident systems, a text definition, and usage notes to clarify the category and aid in coding occurrences. An important element of the occurrence category design is that it permits the association of multiple categories with an occurrence. Meaning, for example, if an engine failure occurred, AND loss of control followed, the occurrence would be coded in both categories. Multiple coding supports the primary focus of CICTT—accident prevention—in which every pertinent element should be investigated, recorded, and analyzed.

Data Source Characteristics

  • Data file: OccurrenceCategoryDefinitions.pdf

  • Format: pdf

  • Size: < 1 MB

  • Update frequency: extremely rare (last October 2013 (4.6))

  • URL: OccurrenceCategoryDefinitions.pdf

Data Target Characteristics

  • Database management system: PostgreSQL

  • Database name: io_avstats_db

  • Database table: io_aviation_occurrence_categories

Data Processing

  • Repository: io-avstats

  • Script: run_io_avstats_dev

  • Task: a_o_c (Load aviation occurrence categories into PostgreSQL)

Processing Steps:

  1. Download the Aviation Occurrence Categories pdf file from here.

  2. Manually create an MS Excel file from the pdf document with the columns CICTT Code, Identifier and Definition.

  3. Load the MS Excel file with the task a_o_c into the PostgreSQL database.

For detailed processing steps, refer to the external repository: io-avstats

Configuration Parameter:

download_file_aviation_occurrence_categories = "data/Aviation_Occurrence_Categories/aviation_occurrence_categories.xlsx"
download_file_aviation_occurrence_categories_url = "https://www.ntsb.gov/safety/data/Documents/datafiles/OccurrenceCategoryDefinitions.pdf"

Contact Information

  • Email: CICTT@intlaviationstandards.org