TSB Investigation Aviation

Owned by Diego Cesa de Meira (Unlicensed)
Last updated: Sept 11, 2019
2 min read

Description

Transportation Safety Board (TSB) Air Investigation
Air transport is an important component of Canada's overall transportation mix, with local, regional, national and international airlines flying passengers and cargo to destinations across the country and around the world.

The TSB is an independent agency, created by an Act of Parliament (the Canadian Transportation Accident Investigation and Safety Board Act). Its mandate is to advance transportation safety in the marine, pipeline, rail and air modes of transportation by:

  • conducting independent investigations, including public inquiries when necessary, into selected transportation occurrences in order to make findings as to their causes and contributing factors;

  • identifying safety deficiencies, as evidenced by transportation occurrences;

  • making recommendations designed to eliminate or reduce any such safety deficiencies; and

  • reporting publicly on our investigations and on the findings in relation thereto.

Air Incidents (Occurrence) consists of two types:

  • Reportable - Class 2 or 3

  • Non-reportable

Originator

  1. Transportation Safety Board (TSB)

Use Cases

  1.  

Source(s)

Description

Source

Format

Date

Update Frequency

Metadata

Cost

Link

Remarks

Description

Source

Format

Date

Update Frequency

Metadata

Cost

Link

Remarks

Air Incidents

TSB

CSV

Current

Monthly

Occurrence Dictionary
Aircraft Dictionary

Free

Occurrence Data
Aircraft Data

Updated on 15th of the month

Remarks

  1. Join two tables using OccNo as primary key to form a superset.

  2. The data on occurrences are released on or soon after the 15th of each month, and date to the last day of the month preceding their release.

Process for EGIS integration

CSV File:

  1. Download the Occurrence and Aircraft CSV file from TSB.

  2. In FME, use the Feature Merger transformer to join the Occurrence and Aircraft dataset using OccNo as the primary key.

  3. Insert a new attribute to hyperlink TSB Report for records with OccClassID=2 or 3.

  4. A typical Report URL looks like this: http://www.tsb.gc.ca/eng/rapports-reports/aviation/2018/a18w0113/a18w0113.asp

  5. Replace a18w0113 with the OccNo and 2018 with OccYear.

  6. Transform the Lat/Long to point.

  7. Output to KML, SHP or GDB as required.

  8. Import into EGIS

Display Optimization:

  1. Sampled/thinned data (generated using data sampling technique) and Class 2 & 3 incidents are displayed at small and medium scale. With scale transition, original data are displayed at large scale thus improve display performance and reduce cluttering.

TC Smart Maps:

  1. Not all GIS applications can consume KML file directly due to its unique data structures such as networklinks, folders, models etc.

  2. Please contact Lawrence Chong, Digital Services Directorate for TC Smart Maps KML dataset and format translation.

  3. TC Smart Maps KML link: \\tc.gc.ca\tcgis\GISData\Google Mashup\TSB_Investigation\Air\TSB_Investigation-Aviation.kmz

Customization:

  1. Schema transformation: As required

  2. Denormalization: Not required

  3. Value coding: Not required

  4. Attribute renaming: As required to improve readability

  5. Attribute removal: It is highly recommended as some fields are unnecessary, this will also reduce file size and improve performance

  6. Geoenrichment: Feature symbolization is recommended to improve visualization. OccClassID=2 or 3 are reportable incidents. It can be symbolized differently and display at smaller scale.

  7. Format translation: Not required

  8. Language translation: French version available

  9. Update frequency: As identified