{"dot_number":"208170","summary":{"total":35,"fatalities":0,"injuries":6},"crashes":[{"crash_id":"5127364","dot_number":"208170","report_state":"OK","report_date":"20260329","report_time":"1528","city":"SAVANNA","state":"OK","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJHHDR8RSUS9951","vehicle_license":"3463697","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:32"},{"crash_id":"5049960","dot_number":"208170","report_state":"CO","report_date":"20250930","report_time":"0940","city":"Not Reported","state":"CO","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJHHDR4SSVR0464","vehicle_license":"5366906","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORP","federal_recordable":"Y","state_recordable":"","source":"mcmis","ingested_at":"2026-05-16 00:30:49"},{"crash_id":"4626061","dot_number":"208170","report_state":"OH","report_date":"20230919","report_time":"1101","city":"ADAMS (TOWNSHIP OF)","state":"OH","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJGEDR3KLKF0036","vehicle_license":"3263756","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE AND STEEL","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:29"},{"crash_id":"4165892","dot_number":"208170","report_state":"NC","report_date":"20210607","report_time":"0559","city":"SALISBURY","state":"NC","fatalities":0,"injuries":0,"tow_away":0,"vin":"3WKDD49X9KF292234","vehicle_license":"177744","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MERFISH UNITED","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:07"},{"crash_id":"4126856","dot_number":"208170","report_state":"PA","report_date":"20210312","report_time":"1332","city":"UPPER SOUTHAMPTON TOWNSHI","state":"PA","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJHLDR5KSKR8678","vehicle_license":"2755846","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:14"},{"crash_id":"4091617","dot_number":"208170","report_state":"NY","report_date":"20210113","report_time":"1118","city":"","state":"NY","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGED56FSGT0518","vehicle_license":"2662400","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:14"},{"crash_id":"4000263","dot_number":"208170","report_state":"NY","report_date":"20200714","report_time":"1139","city":"","state":"NY","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJHLDR0KSKR8670","vehicle_license":"8580A","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:42"},{"crash_id":"3952309","dot_number":"208170","report_state":"AL","report_date":"20200325","report_time":"1228","city":"MONTGOMERY","state":"AL","fatalities":0,"injuries":1,"tow_away":0,"vin":"3AKJGEDV6ESFT9781","vehicle_license":"2890066","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:52"},{"crash_id":"3979175","dot_number":"208170","report_state":"IL","report_date":"20200320","report_time":"0451","city":"ZUMA TWP","state":"IL","fatalities":0,"injuries":1,"tow_away":0,"vin":"3AKJGEDV8ESFV3343","vehicle_license":"2190530","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:34:52"},{"crash_id":"3892607","dot_number":"208170","report_state":"NY","report_date":"20191118","report_time":"0805","city":"","state":"NY","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUJGEDV3ELFT9779","vehicle_license":"2755181","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:11"},{"crash_id":"3879777","dot_number":"208170","report_state":"CA","report_date":"20190930","report_time":"0455","city":"BEAUMONT","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGLDRXJSJZ6312","vehicle_license":"2629021","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:22"},{"crash_id":"3813896","dot_number":"208170","report_state":"NH","report_date":"20190607","report_time":"0604","city":"Laconia","state":"NH","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGLD52FSGT0522","vehicle_license":"93911","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:34"},{"crash_id":"3753559","dot_number":"208170","report_state":"NJ","report_date":"20190228","report_time":"0425","city":"NEWARK CITY","state":"NJ","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUJGEDV7ELFT9784","vehicle_license":"2012789L","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:36:04"},{"crash_id":"3755259","dot_number":"208170","report_state":"AZ","report_date":"20190121","report_time":"1314","city":"SURPRISE","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGEDV5ESFT9786","vehicle_license":"2191449","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:36:05"},{"crash_id":"3686680","dot_number":"208170","report_state":"SC","report_date":"20181029","report_time":"1105","city":"GREENVILLE","state":"SC","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJGEDV3ELFT9782","vehicle_license":"1168511","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:36:24"},{"crash_id":"3578773","dot_number":"208170","report_state":"KY","report_date":"20180419","report_time":"0820","city":"BARDSTOWN","state":"KY","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGEDV9ESFT9788","vehicle_license":"2196607","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:36:49"},{"crash_id":"3524720","dot_number":"208170","report_state":"OH","report_date":"20180108","report_time":"0850","city":"VANDALIA","state":"OH","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGED58FSGT0519","vehicle_license":"23023961","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:37:16"},{"crash_id":"3482304","dot_number":"208170","report_state":"NC","report_date":"20171026","report_time":"0538","city":"WINSTON SALEM","state":"NC","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUJGEDV3ELFT9782","vehicle_license":"1168511","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:37:17"},{"crash_id":"3514191","dot_number":"208170","report_state":"IL","report_date":"20170609","report_time":"1543","city":"Rockford Twp","state":"IL","fatalities":0,"injuries":1,"tow_away":0,"vin":"3AKJGEDV8FSGK5790","vehicle_license":"2248263","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:37:41"},{"crash_id":"3371509","dot_number":"208170","report_state":"TX","report_date":"20170228","report_time":"0546","city":"RURAL MCLENNAN COUNTY","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJGLDR3DSBZ4054","vehicle_license":"2328168","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:37:54"},{"crash_id":"3346471","dot_number":"208170","report_state":"NM","report_date":"20161225","report_time":"0240","city":"","state":"NM","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJGLDR1CSBM9791","vehicle_license":"2119482","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:37:54"},{"crash_id":"3269249","dot_number":"208170","report_state":"IN","report_date":"20160829","report_time":"1022","city":"NEW CASTLE","state":"IN","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGEDV6ESFV3342","vehicle_license":"2434100","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE AND STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:12"},{"crash_id":"3121784","dot_number":"208170","report_state":"WY","report_date":"20151112","report_time":"1645","city":"SUNDANCE","state":"WY","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJGLDR0BSAX7643","vehicle_license":"1223276","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:48"},{"crash_id":"3122679","dot_number":"208170","report_state":"MI","report_date":"20151026","report_time":"0831","city":"Royal Oak","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGEDVXESFV3344","vehicle_license":"2191121","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:48"},{"crash_id":"3022107","dot_number":"208170","report_state":"KY","report_date":"20150205","report_time":"0550","city":"LOUISVILLE","state":"KY","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGEDV6ESFV2342","vehicle_license":"2190529","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:21"},{"crash_id":"3003252","dot_number":"208170","report_state":"OH","report_date":"20141230","report_time":"1030","city":"CIRCLEVILLE","state":"OH","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGEDV5ESFT9786","vehicle_license":"2191449","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:22"},{"crash_id":"2883907","dot_number":"208170","report_state":"IA","report_date":"20140627","report_time":"0830","city":"CRESTON","state":"IA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJGLDR1CSBM9791","vehicle_license":"2119482","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:42"},{"crash_id":"2727472","dot_number":"208170","report_state":"OH","report_date":"20120717","report_time":"1625","city":"Columbus","state":"OH","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"11","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATIO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:55"},{"crash_id":"2571750","dot_number":"208170","report_state":"OH","report_date":"20120517","report_time":"1348","city":"BRUNSWICK","state":"OH","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJA6CK47LX56126","vehicle_license":"2040716","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:56"},{"crash_id":"2389402","dot_number":"208170","report_state":"KY","report_date":"20110207","report_time":"1122","city":"SHELBYVILLE","state":"KY","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJA6CKX7LX77174","vehicle_license":"258644","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:43"},{"crash_id":"2239897","dot_number":"208170","report_state":"OH","report_date":"20100326","report_time":"0730","city":"Staunton","state":"OH","fatalities":0,"injuries":0,"tow_away":0,"vin":"IFTCR14A8HPA52944","vehicle_license":"1096482","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:43"},{"crash_id":"2076678","dot_number":"208170","report_state":"MI","report_date":"20081215","report_time":"1240","city":"COOPER TWP","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJA6CK59DAK3230","vehicle_license":"1096480","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:19"},{"crash_id":"1363050","dot_number":"208170","report_state":"MA","report_date":"20040923","report_time":"0310","city":"PEABODY","state":"MA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M2AA11C7YW133214","vehicle_license":"10909","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:17"},{"crash_id":"1197301","dot_number":"208170","report_state":"CT","report_date":"20030821","report_time":"0937","city":"MILFORD","state":"CT","fatalities":0,"injuries":0,"tow_away":0,"vin":"4V4MC9GH41N307169","vehicle_license":"51627","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:06"},{"crash_id":"499803","dot_number":"208170","report_state":"CT","report_date":"19991021","report_time":"0725","city":"DANBURY","state":"CT","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M1AA1346SW047851","vehicle_license":"10522","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"UNITED PIPE & STEEL CORPORATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:49"}]}