Transportation Safety Board of Canada / Bureau de la sécurité des transports du Canada
Menu (access key: M)
Skip first menu (access key: 1)
TSB Reports

Skip all menus (access key: 2)

Curve Graphic

SR 111 Investigation Report

Heading Graphic

Horizontal Line

1.19.1  Exhibit Tracking Process Physical Wreckage Databases Document Control Photograph Database

Back to the top  Physical Wreckage Databases

Aircraft debris was recovered from the crash site and transported to the CF facilities at 12 Wing Shearwater, Nova Scotia. The progress of the recovery effort was monitored by tracking the weight of all recovered items as a percentage of the total structural weight of the aircraft. Recovered items were sorted and classified by their location on the aircraft and by their potential significance to the investigation. Items that were not considered significant were placed together with other similar items corresponding to the location of the item within the aircraft, and were stored in large boxes. Items categorized as significant for priority examination were photographed and assigned a unique exhibit number; a textual summary description was created for each exhibit. This information was entered into an Evidence and Reports III database used by the RCMP for case management; this factual exhibit information was available to the RCMP and the TSB and was ultimately imported into a separate safety investigation database developed by the TSB. Storage boxes containing items that were sorted and categorized as less significant to the investigation were also entered into the database as composite exhibits, to permit tracking and potential future retrieval as required. The exhibit and reporting database allowed investigators to view photographs and exhibit descriptions for each significant individual item, and to generate summary reports based on that exhibit information.

A separate database was established to track exhibit descriptions and information related to aircraft wiring.

Back to the top  Document Control

Records supporting the investigation were assigned a document control number and registered in an electronic document control log database. A cover page, known as a "header banner," was produced for each document that was to be optically scanned to be converted to an electronic format. The header banner was used to identify the document content, and provides sufficient details to assist in document retrieval.

SUPERText® case management software,[110] which merges imaging technology, full-text search capability and structured database technology and allows full text query, was used as the document management system. Components of the software were used to scan and process the records using optical character recognition technology, and further organize the records. SUPERText® search utilities allowed users to retrieve documents using a variety of search criteria including keyword searches, and to view or print high-quality images of these documents.

Back to the top  Photograph Database

A photograph database was developed to archive the large volume of digital and 35 mm images that were taken by RCMP and TSB investigators. The database was indexed to allow flexible searches by exhibit number, subject matter, date, location, and various other parameters.

[110]    SUPERText® by Supergravity Incorporated.

Previous | Next

Horizontal Line
Updated: 2003-03-27

Back to the top

Important Notices