AI Analysis: Railway transport survey, inventory of equipment in service summary of regional railways

Executive Summary

Statistics Canada's regional railway equipment inventory dataset (Table 23100059) tracks 7 categories of railway equipment annually from 1986 to 2024, revealing a dramatic long-term contraction in Canada's regional rail fleet. Freight cars — by far the largest category — plummeted over 66% from 14,750 to 5,007 units, while most other equipment types also declined. The notable exceptions are total locomotives and yard locomotives, which saw modest growth over the nearly four-decade period.

Key Findings

• Total freight cars declined by over 66%, falling from 14,750 units in 1986 to 5,007 in 2024, representing the largest absolute reduction across all equipment categories.
• Freight cars dominate the inventory with an average of ~10,177 units per year — more than 26 times larger than the next largest category — heavily skewing the overall dataset mean to 1,577 against a median of just 83.
• Total locomotives and freight locomotives were the only major categories to grow over the period, rising from 382 to 442 and 298 to 343 units respectively.
• Passenger equipment shrank significantly, with passenger cars dropping from 108 to 50 units and passenger locomotives declining from 26 to 15 units between 1986 and 2024.
• Associated equipment recorded the steepest proportional decline among smaller categories, falling from 39 to just 9 units — a reduction of approximately 77% over the study period.
• Yard locomotives bucked the overall downward trend, increasing modestly from 19 to 28 units across the 39-year period.
• The dataset's value range spans from just 3 to 17,514 units with a standard deviation of 4,068.5, reflecting extreme variability driven almost entirely by the freight car category.