Name: Major Safety Events
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Major Safety Events

This is a list of all Major Safety and Security Events from January of 2014 to the most recently published data within the Federal Transit Administration's major event time series.
Organization: Department of Transportation
Last updated: 2020-11-12T12:41:02.709799
Tags: safety, security, transit

Tables

Table 1

@usgov.dot_gov_major_safety_events.table_1

23.7 MB
100,656 rows
122 columns

CREATE TABLE table_1 (
  "ntd_id" BIGINT,
  "agency" VARCHAR,
  "primary_uza_uace_code" BIGINT,
  "rail_bus_ferry" VARCHAR,
  "mode_name" VARCHAR,
  "mode" VARCHAR,
  "tos" VARCHAR,
  "fixed_route_flag" BOOLEAN,
  "year" BIGINT,
  "event_description" VARCHAR,
  "incident_number" BIGINT,
  "event_date" VARCHAR,
  "event_time" VARCHAR,
  "event_type" VARCHAR,
  "event_type_group" VARCHAR,
  "transit_worker_type" VARCHAR,
  "transit_worker_assault_detail_type" VARCHAR,
  "transit_worker_assault_flag" BOOLEAN,
  "other_event_type_description" VARCHAR,
  "event_category" VARCHAR,
  "runaway_train_flag" VARCHAR,
  "safety_security" VARCHAR,
  "collision_with" VARCHAR,
  "property_damage" DOUBLE,
  "substantial_property_damage_type" VARCHAR,
  "total_injuries" BIGINT,
  "total_fatalities" BIGINT,
  "towed_y_n" VARCHAR  -- Towed (Y/N),
  "number_of_transit_vehicles_involved" BIGINT,
  "number_of_non_transit_vehicles_involved" BIGINT,
  "number_of_cars_on_involved_transit_vehicles" BIGINT,
  "number_of_derailed_cars_on_involved_transit_vehicles" DOUBLE,
  "non_transit_vehicle_type_list" VARCHAR,
  "location_type" VARCHAR,
  "multiple_locations_list" VARCHAR,
  "approximate_address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "latlon" VARCHAR,
  "evacuation" BOOLEAN,
  "evacuation_for_life_safety_y_n" VARCHAR  -- Evacuation For Life Safety (Y/N),
  "evacuation_to_right_of_way" VARCHAR,
  "evacuation_comment" VARCHAR,
  "self_evacuation_y_n" VARCHAR  -- Self Evacuation (Y/N),
  "evacuation_location" VARCHAR,
  "hazmat_type" VARCHAR,
  "hazmat_type_description" VARCHAR,
  "fire_type" VARCHAR,
  "fire_fuel" VARCHAR,
  "other_fire_fuel_description" VARCHAR,
  "weather" VARCHAR,
  "weather_comment" VARCHAR,
  "lighting" VARCHAR,
  "current_condition" VARCHAR,
  "tide" VARCHAR,
  "road_configuration" VARCHAR,
  "track_configuration" VARCHAR,
  "path_condition" VARCHAR,
  "rail_alignment" VARCHAR,
  "rail_grade_crossing_control" VARCHAR,
  "rail_grade_crossing_comment" VARCHAR,
  "right_of_way_condition" VARCHAR,
  "intersection_control_device" VARCHAR,
  "service_stop_control_device" VARCHAR,
  "operator_location" VARCHAR,
  "intentional_y_n" VARCHAR  -- Intentional (Y/N),
  "transit_vehicle_action" VARCHAR,
  "other_transit_vehicle_action_description" VARCHAR,
  "non_transit_vehicle_action_list" VARCHAR,
  "derailment_type" VARCHAR,
  "transit_y_n" VARCHAR  -- Transit (Y/N),
  "revenue_vehicle_identifier_list" VARCHAR,
  "fuel_type" VARCHAR,
  "vehicle_speed" DOUBLE,
  "transit_vehicle_type" VARCHAR,
  "non_transit_vehicle_type" VARCHAR,
  "transit_vehicle_manufacturer" VARCHAR,
  "other_transit_vehicle_manufacturer_description" VARCHAR,
  "transit_vehicle_rider_fatalities" BIGINT,
  "people_waiting_or_leaving_fatalities" BIGINT,
  "transit_vehicle_operator_fatalities" BIGINT,
  "non_operator_transit_employee_fatalities" BIGINT,
  "other_worker_fatalities" BIGINT,
  "bicyclist_fatalities" BIGINT,
  "pedestrian_in_crosswalk_fatalities" BIGINT,
  "pedestrian_not_in_crosswalk_fatalities" BIGINT,
  "pedestrian_crossing_tracks_fatalities" BIGINT,
  "pedestrian_walking_along_tracks_fatalities" BIGINT,
  "occupant_of_other_vehicle_fatalities" BIGINT,
  "other_fatalities" BIGINT,
  "suicide_fatalities" BIGINT,
  "trespasser_fatalities_subtotal" BIGINT  -- Trespasser Fatalities (Subtotal),
  "transit_vehicle_rider_injuries" BIGINT,
  "transit_vehicle_rider_serious_injuries" BIGINT,
  "people_waiting_or_leaving_injuries" BIGINT,
  "people_waiting_or_leaving_serious_injuries" BIGINT,
  "transit_vehicle_operator_injuries" BIGINT,
  "transit_vehicle_operator_serious_injuries" BIGINT,
  "non_operator_transit_employee_injuries" BIGINT,
  "non_operator_transit_employee_serious_injuries" BIGINT
);