Aviation data

Aviation occurrence and aircraft data from January 2004

Information about the data

The TSB is publishing selected data pertaining to accidents and reportable incidents from its Aviation Safety Information System (ASIS) for use by industry and the public, with a view to advancing transportation safety.

The aviation data files (in CSV format) are released on or soon after the 15th of each month, and contain data from 01 January 2004 to the last day of the month preceding their release.

There are two data sets, each in CSV format:

  1. The aviation occurrence data set can be used to obtain occurrence counts, but it also contains basic data on the aircraft involved in occurrences. Records for occurrences involving more than one aircraft show information on each aircraft in the same row; the title of each column contains a sequential number for each aircraft (the sequential number is non-hierarchical).
  2. More detailed data on the aircraft involved in occurrences are captured in the aircraft data set. Records for occurrences involving more than one aircraft show information on each aircraft in a separate row; the occurrence identification number is repeated in each row.

The data are described in the accompanying occurrence data dictionary (HTML or CSV) and aircraft data dictionary (HTML or CSV).

Note that the abbreviation N/A in these files means not applicable.

Because these data are extracted from a live database that captures the results of ongoing investigations, the data are subject to change, with the oldest data being the most stable. As many occurrences are not investigated formally (see the Occurrence Classification Policy), information recorded on some occurrences may not have been verified. Furthermore, a limited number of recent occurrences counted in the monthly statistics may not be included in the aviation occurrence and aircraft data files until information is validated.

TSB data are collected according to the mandatory occurrence reporting requirements described in the TSB Regulations. On 01 July 2014, the TSB issued new regulations that changed some reporting requirements. Data prior to this date were collected under the reporting requirements described in the TSB Regulations in effect at that time.

More data will be added to these data sets as they become available for publication.