Skip to content

Instantly share code, notes, and snippets.

@brucejackson
Created November 5, 2021 19:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save brucejackson/01e7025df3057755914a669391714aea to your computer and use it in GitHub Desktop.
Save brucejackson/01e7025df3057755914a669391714aea to your computer and use it in GitHub Desktop.
TSB
OccID OccNo OccClassID OccClassID_DisplayEng OccClassID_DisplayFre OccDate OccYear OccTime TimeZoneID TimeZoneID_DisplayEng TimeZoneID_DisplayFre OccurrenceTypeID OccurrenceTypeID_DisplayEng OccurrenceTypeID_DisplayFre AccIncTypeID AccIncTypeID_DisplayEng AccIncTypeID_DisplayFre ActivityTypeID ActivityTypeID_DisplayEng ActivityTypeID_DisplayFre CollistionTypeID CollistionTypeID_DisplayEng CollistionTypeID_DisplayFre NumberTrainsInvolved SubdOwnerID SubdOwnerID_DisplayEng SubdOwnerID_DisplayFre SubdNameID SubdNameID_DisplayEng
130707 R21H0088 5 5 5 6/29/2021 3:31:00 AM 2021 331 2 EST HNE 3 INCIDENT INCIDENT 38 MOVEMENT EXCEEDS LIMITS OF AUTHORITY MOUVEMENT DEPASSE LIMITES AUTORISEES 4 PROCEEDING MARCHE AVANT 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
130697 R21H0085 5 5 5 6/27/2021 10:25:00 AM 2021 1025 2 EST HNE 1 ACCIDENT ACCIDENT 45 R/S COLL. WITH OBJECT MATERIEL ROULANT AVEC OBJET 2 MAINTENANCE ENTRETIEN 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
130663 R21H0082 5 5 5 6/20/2021 2:49:00 AM 2021 249 2 EST HNE 1 ACCIDENT ACCIDENT 45 R/S COLL. WITH OBJECT MATERIEL ROULANT AVEC OBJET 2 MAINTENANCE ENTRETIEN 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
130546 R21H0066 5 5 5 5/22/2021 4:00:00 PM 2021 1600 2 EST HNE 1 ACCIDENT ACCIDENT 45 R/S COLL. WITH OBJECT MATERIEL ROULANT AVEC OBJET 4 PROCEEDING MARCHE AVANT 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
130494 R21H0059 5 5 5 5/11/2021 1:34:00 AM 2021 134 2 EST HNE 3 INCIDENT INCIDENT 38 MOVEMENT EXCEEDS LIMITS OF AUTHORITY MOUVEMENT DEPASSE LIMITES AUTORISEES 4 PROCEEDING MARCHE AVANT 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
130370 R21H0051 5 5 5 4/14/2021 2:25:00 PM 2021 1425 2 EST HNE 1 ACCIDENT ACCIDENT 45 R/S COLL. WITH OBJECT MATERIEL ROULANT AVEC OBJET 15 SWITCHING SHOVING MANOEUVRE EN POUSSANT 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
130356 R21H0048 5 5 5 4/9/2021 8:28:00 AM 2021 828 2 EST HNE 1 ACCIDENT ACCIDENT 45 R/S COLL. WITH OBJECT MATERIEL ROULANT AVEC OBJET 4 PROCEEDING MARCHE AVANT 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
130244 R21H0033 5 5 5 3/14/2021 1:30:00 PM 2021 1330 4 EDT HAE 1 ACCIDENT ACCIDENT 32 NON-MAIN-TRACK TRAIN DERAILMENT DERAILLEMENT HORS VOIE PRINCIPALE 4 PROCEEDING MARCHE AVANT 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
130191 R21H0026 5 5 5 3/1/2021 9:28:00 PM 2021 2128 2 EST HNE 1 ACCIDENT ACCIDENT 45 R/S COLL. WITH OBJECT MATERIEL ROULANT AVEC OBJET 4 PROCEEDING MARCHE AVANT 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
129989 R21H0004 5 5 5 1/7/2021 2:20:00 PM 2021 1420 2 EST HNE 3 INCIDENT INCIDENT 38 MOVEMENT EXCEEDS LIMITS OF AUTHORITY MOUVEMENT DEPASSE LIMITES AUTORISEES 4 PROCEEDING MARCHE AVANT 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
129829 R20H0126 5 5 5 11/18/2020 6:27:00 AM 2020 627 2 EST HNE 1 ACCIDENT ACCIDENT 32 NON-MAIN-TRACK TRAIN DERAILMENT DERAILLEMENT HORS VOIE PRINCIPALE 4 PROCEEDING MARCHE AVANT 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
129727 R20H0117 5 5 5 10/18/2020 10:44:00 PM 2020 2244 4 EDT HAE 3 INCIDENT INCIDENT 54 NON-MAIN-TRACK TRAIN DERAILMENT (NO DAMAGE) DERAILLEMENT HORS VOIE PRINCIPALE (AUCUN DOMMAGE) 4 PROCEEDING MARCHE AVANT 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
129703 R20H0115 5 5 5 10/12/2020 11:45:00 PM 2020 2345 4 EDT HAE 3 INCIDENT INCIDENT 38 MOVEMENT EXCEEDS LIMITS OF AUTHORITY MOUVEMENT DEPASSE LIMITES AUTORISEES 17 PROCEEDING AFTER COLLISION MARCHE AVANT APRÈS COLL. 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
129654 R20H0111 5 5 5 9/29/2020 11:09:00 AM 2020 1109 4 EDT HAE 1 ACCIDENT ACCIDENT 45 R/S COLL. WITH OBJECT MATERIEL ROULANT AVEC OBJET 15 SWITCHING SHOVING MANOEUVRE EN POUSSANT 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
129495 R20H0100 5 5 5 8/18/2020 9:00:00 PM 2020 2100 4 EDT HAE 3 INCIDENT INCIDENT 55 COMPONENT FAILURE THAT AFFECTS SAFE OPERATION OF R/S DÉFAILLANCE D'UN COMPOSANT QUI AFFECTE LA SÉCURITÉ D'EXPLOITATION DU MATÉRIEL ROULANT 1 INSPECTION INSPECTION 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
129481 R20H0099 5 5 5 8/11/2020 4:00:00 AM 2020 400 4 EDT HAE 3 INCIDENT INCIDENT 55 COMPONENT FAILURE THAT AFFECTS SAFE OPERATION OF R/S DÉFAILLANCE D'UN COMPOSANT QUI AFFECTE LA SÉCURITÉ D'EXPLOITATION DU MATÉRIEL ROULANT 1 INSPECTION INSPECTION 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
129404 R20H0087 5 5 5 7/19/2020 6:54:00 PM 2020 1854 4 EDT HAE 1 ACCIDENT ACCIDENT 32 NON-MAIN-TRACK TRAIN DERAILMENT DERAILLEMENT HORS VOIE PRINCIPALE 4 PROCEEDING MARCHE AVANT 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
129383 R20H0084 5 5 5 7/13/2020 3:50:00 PM 2020 1550 4 EDT HAE 3 INCIDENT INCIDENT 53 DERAILMENT INVOLVING TRACK UNIT (NO DAMAGE) DERAILLEMENT - VEHICULES D'ENTRETIEN (AUCUN DOMMAGE) 7 REVERSING MARCHE ARRIÈRE 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
129353 R20H0081 5 5 5 7/3/2020 11:55:00 AM 2020 1155 4 EDT HAE 3 INCIDENT INCIDENT 55 COMPONENT FAILURE THAT AFFECTS SAFE OPERATION OF R/S DÉFAILLANCE D'UN COMPOSANT QUI AFFECTE LA SÉCURITÉ D'EXPLOITATION DU MATÉRIEL ROULANT 1 INSPECTION INSPECTION 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
129352 R20H0080 5 5 5 7/3/2020 12:01:00 AM 2020 1 4 EDT HAE 3 INCIDENT INCIDENT 55 COMPONENT FAILURE THAT AFFECTS SAFE OPERATION OF R/S DÉFAILLANCE D'UN COMPOSANT QUI AFFECTE LA SÉCURITÉ D'EXPLOITATION DU MATÉRIEL ROULANT 1 INSPECTION INSPECTION 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
129351 R20H0079 3 3 3 7/2/2020 6:00:00 PM 2020 1800 4 EDT HAE 3 INCIDENT INCIDENT 55 COMPONENT FAILURE THAT AFFECTS SAFE OPERATION OF R/S DÉFAILLANCE D'UN COMPOSANT QUI AFFECTE LA SÉCURITÉ D'EXPLOITATION DU MATÉRIEL ROULANT 2 MAINTENANCE ENTRETIEN 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
129324 R20H0076 5 5 5 6/28/2020 3:17:00 PM 2020 1517 4 EDT HAE 3 INCIDENT INCIDENT 38 MOVEMENT EXCEEDS LIMITS OF AUTHORITY MOUVEMENT DEPASSE LIMITES AUTORISEES 4 PROCEEDING MARCHE AVANT 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
129271 R20H0066 5 5 5 6/14/2020 6:17:00 AM 2020 617 4 EDT HAE 1 ACCIDENT ACCIDENT 34 DERAILMENT INVOLVING TRACK UNIT DERAILLEMENT- VEHICULES D'ENTRETIEN 5 PROCEEDING ACCELERATING MARCHE AVANT - ACCÉL. 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
129270 R20H0065 5 5 5 6/12/2020 3:12:00 AM 2020 312 4 EDT HAE 3 INCIDENT INCIDENT 53 DERAILMENT INVOLVING TRACK UNIT (NO DAMAGE) DERAILLEMENT - VEHICULES D'ENTRETIEN (AUCUN DOMMAGE) 4 PROCEEDING MARCHE AVANT 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
128829 R20H0019 5 5 5 2/23/2020 6:23:00 AM 2020 623 2 EST HNE 3 INCIDENT INCIDENT 53 DERAILMENT INVOLVING TRACK UNIT (NO DAMAGE) DERAILLEMENT - VEHICULES D'ENTRETIEN (AUCUN DOMMAGE) 19 UNKNOWN INCONNU 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
128727 R20H0009 5 5 5 1/24/2020 3:12:00 AM 2020 312 2 EST HNE 1 ACCIDENT ACCIDENT 31 NON-MAIN-TRACK TRAIN COLLISION COLLISION HORS DE VOIE PRINCIPALE 4 PROCEEDING MARCHE AVANT 122 SIDE, ONE STANDING, OTHER MOVING LATÉRALE, UN EN MOUV., L'AUTRE IMMOB. 2 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
128571 R19H0154 5 5 5 12/12/2019 11:00:00 AM 2019 1100 2 EST HNE 1 ACCIDENT ACCIDENT 32 NON-MAIN-TRACK TRAIN DERAILMENT DERAILLEMENT HORS VOIE PRINCIPALE 11 SWITCHING MANŒUVRE D'AIGUILLAGE 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
128470 R19H0146 5 5 5 11/12/2019 3:37:00 PM 2019 1537 11 CST HNC 1 ACCIDENT ACCIDENT 34 DERAILMENT INVOLVING TRACK UNIT DERAILLEMENT- VEHICULES D'ENTRETIEN 4 PROCEEDING MARCHE AVANT 1 94 OTTAWA LIGHT RAIL TRANSIT SYSTEM OTTAWA LIGHT RAIL TRANSIT SYSTEM 977 O-TRAIN LINE 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment