{"dot_number":"476823","summary":{"total":78,"fatalities":5,"injuries":47},"crashes":[{"crash_id":"5145227","dot_number":"476823","report_state":"FL","report_date":"20260328","report_time":"0220","city":"BOCA RATON","state":"FL","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJHLDVXLSMD3194","vehicle_license":"NNUU51","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:32"},{"crash_id":"5075404","dot_number":"476823","report_state":"IN","report_date":"20251121","report_time":"2342","city":"WHITESTOWN","state":"IN","fatalities":0,"injuries":3,"tow_away":0,"vin":"3ALACXFC8RDUZ8351","vehicle_license":"3663763","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:49"},{"crash_id":"5026362","dot_number":"476823","report_state":"MI","report_date":"20250823","report_time":"2021","city":"COMMERCE TWP","state":"MI","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FDNF7DC3MDF08264","vehicle_license":"186816H","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:59"},{"crash_id":"5019903","dot_number":"476823","report_state":"LA","report_date":"20250820","report_time":"0023","city":"SCOTT","state":"LA","fatalities":0,"injuries":0,"tow_away":0,"vin":"3ALACWFC3RDUZ8347","vehicle_license":"128N64","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:59"},{"crash_id":"5001437","dot_number":"476823","report_state":"MI","report_date":"20250721","report_time":"0453","city":"WARREN","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"3HCDZAPR7LL108949","vehicle_license":"2915192","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:59"},{"crash_id":"4936991","dot_number":"476823","report_state":"OH","report_date":"20250501","report_time":"2239","city":"CLINTON (TOWNSHIP OF)","state":"OH","fatalities":0,"injuries":0,"tow_away":0,"vin":"3ALACXFC4LDLX7551","vehicle_license":"2929402","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTINO INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:15"},{"crash_id":"4932645","dot_number":"476823","report_state":"FL","report_date":"20250423","report_time":"2308","city":"UNINCORPORATED","state":"FL","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJHLDVXLSMD3194","vehicle_license":"NNUU51","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:15"},{"crash_id":"4942719","dot_number":"476823","report_state":"FL","report_date":"20250420","report_time":"2236","city":"BOCA RATON","state":"FL","fatalities":0,"injuries":1,"tow_away":0,"vin":"3AKJHLDV4LSMD3191","vehicle_license":"3282493","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:15"},{"crash_id":"4908924","dot_number":"476823","report_state":"KS","report_date":"20250304","report_time":"2127","city":"KANSAS CITY","state":"KS","fatalities":0,"injuries":0,"tow_away":0,"vin":"3ALACWFC3LDLX7549","vehicle_license":"IMX760","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:15"},{"crash_id":"4871189","dot_number":"476823","report_state":"MI","report_date":"20241213","report_time":"0430","city":"DEARBORN","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJHHDR5MSMT4338","vehicle_license":"3005321","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:21"},{"crash_id":"4855473","dot_number":"476823","report_state":"NC","report_date":"20241109","report_time":"1730","city":"CHARLOTTE","state":"NC","fatalities":0,"injuries":4,"tow_away":0,"vin":"1FVACWFC9RHUZ8301","vehicle_license":"ZS6922","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:34"},{"crash_id":"4844054","dot_number":"476823","report_state":"NC","report_date":"20241109","report_time":"1732","city":"CHARLOTTE","state":"NC","fatalities":0,"injuries":3,"tow_away":0,"vin":"1FVACWFC9RHUZ8301","vehicle_license":"ZS6922","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:34"},{"crash_id":"4797971","dot_number":"476823","report_state":"MI","report_date":"20240728","report_time":"0030","city":"ERIE TWP","state":"MI","fatalities":1,"injuries":0,"tow_away":0,"vin":"3HAEUMML7LL847283","vehicle_license":"2910760","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:40"},{"crash_id":"4793537","dot_number":"476823","report_state":"WI","report_date":"20240726","report_time":"0235","city":"MILWAUKEE","state":"WI","fatalities":0,"injuries":0,"tow_away":0,"vin":"3ALACXFC4LDLX7565","vehicle_license":"2929333","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:40"},{"crash_id":"4745952","dot_number":"476823","report_state":"IL","report_date":"20240510","report_time":"1355","city":"CAPITAL TWP","state":"IL","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FDTF4GN4NDA08666","vehicle_license":"184793F","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:31:40"},{"crash_id":"4735166","dot_number":"476823","report_state":"FL","report_date":"20240405","report_time":"2132","city":"OKEECHOBEE","state":"FL","fatalities":0,"injuries":2,"tow_away":0,"vin":"3ALACWFC9KDKJ7027","vehicle_license":"QDAY66","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:02"},{"crash_id":"4713342","dot_number":"476823","report_state":"MO","report_date":"20240302","report_time":"1158","city":"ROLLA","state":"MO","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FDTF4GT6PDA06077","vehicle_license":"195227F","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:02"},{"crash_id":"4689916","dot_number":"476823","report_state":"IL","report_date":"20240124","report_time":"0401","city":"PERU","state":"IL","fatalities":0,"injuries":0,"tow_away":0,"vin":"3ALACXFC5LDLM6728","vehicle_license":"2915407","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:02"},{"crash_id":"4674071","dot_number":"476823","report_state":"MI","report_date":"20231210","report_time":"2050","city":"WARREN","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJHLDR8KLKW1264","vehicle_license":"3350990","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:09"},{"crash_id":"4638675","dot_number":"476823","report_state":"FL","report_date":"20231007","report_time":"2325","city":"UNINCOPORATED(LAKELAND)","state":"FL","fatalities":0,"injuries":0,"tow_away":0,"vin":"3ALACWFC8NDNG9242","vehicle_license":"AG00GW","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:29"},{"crash_id":"4635015","dot_number":"476823","report_state":"TX","report_date":"20230928","report_time":"2245","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"3HCDZAPRXKL655616","vehicle_license":"3281560","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:29"},{"crash_id":"4613201","dot_number":"476823","report_state":"TN","report_date":"20230902","report_time":"0458","city":"MOUNT JULIET","state":"TN","fatalities":0,"injuries":0,"tow_away":0,"vin":"3HAEUMMN5LL331442","vehicle_license":"2927446","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:29"},{"crash_id":"4573100","dot_number":"476823","report_state":"FL","report_date":"20230601","report_time":"1417","city":"UNINCORPORATED","state":"FL","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FVACXFC5NHNK7857","vehicle_license":"P2136F","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:40"},{"crash_id":"4550217","dot_number":"476823","report_state":"MI","report_date":"20230413","report_time":"0103","city":"ROYAL OAK","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FVACXCS57HX68073","vehicle_license":"P1144942","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:40"},{"crash_id":"4549129","dot_number":"476823","report_state":"TX","report_date":"20230413","report_time":"0505","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGEDV1HSJF6604","vehicle_license":"UNKNOWN","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:40"},{"crash_id":"4479043","dot_number":"476823","report_state":"SC","report_date":"20221214","report_time":"1057","city":"GEORGETOWN","state":"SC","fatalities":0,"injuries":1,"tow_away":0,"vin":"3ALACWFC7NDNJ0641","vehicle_license":"3273348","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:05"},{"crash_id":"4472503","dot_number":"476823","report_state":"MA","report_date":"20221204","report_time":"0115","city":"FOXBOROUGH","state":"MA","fatalities":0,"injuries":1,"tow_away":0,"vin":"UNKNOWN","vehicle_license":"88385","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:05"},{"crash_id":"4447243","dot_number":"476823","report_state":"MI","report_date":"20221026","report_time":"0005","city":"STERLING HEIGHTS","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1HTEUMMNXLH801521","vehicle_license":"2908355","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:05"},{"crash_id":"4428903","dot_number":"476823","report_state":"IA","report_date":"20221003","report_time":"2223","city":"DES MOINES","state":"IA","fatalities":0,"injuries":0,"tow_away":0,"vin":"3ALACXFC2LDLX7547","vehicle_license":"2928604","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:05"},{"crash_id":"4439342","dot_number":"476823","report_state":"MI","report_date":"20220928","report_time":"0457","city":"WOODHAVEN","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1HTEUMMNXLH801521","vehicle_license":"2908355","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:15"},{"crash_id":"4414792","dot_number":"476823","report_state":"FL","report_date":"20220822","report_time":"0216","city":"MELBOURNE","state":"FL","fatalities":0,"injuries":0,"tow_away":0,"vin":"3ALHCYFE0LDLX7553","vehicle_license":"2928698","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:16"},{"crash_id":"4415214","dot_number":"476823","report_state":"IN","report_date":"20220821","report_time":"0109","city":"CARMEL","state":"IN","fatalities":0,"injuries":1,"tow_away":0,"vin":"3ALACWFC1LDLS6955","vehicle_license":"3286128","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:16"},{"crash_id":"4411102","dot_number":"476823","report_state":"IN","report_date":"20220731","report_time":"2326","city":"EVANSVILLE","state":"IN","fatalities":0,"injuries":0,"tow_away":0,"vin":"3ALACWFC8JDJY4715","vehicle_license":"A426003","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:16"},{"crash_id":"4388359","dot_number":"476823","report_state":"IN","report_date":"20220601","report_time":"0330","city":"MARTINSVILLE","state":"IN","fatalities":0,"injuries":0,"tow_away":0,"vin":"3ALACWFC2KDKJ7029","vehicle_license":"167998H","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:22"},{"crash_id":"4333181","dot_number":"476823","report_state":"WI","report_date":"20220403","report_time":"0456","city":"LOMIRA","state":"WI","fatalities":0,"injuries":0,"tow_away":0,"vin":"3ALACXFC4LDLX7565","vehicle_license":"2929333","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:23"},{"crash_id":"4332081","dot_number":"476823","report_state":"MI","report_date":"20220306","report_time":"0248","city":"Scio Twp","state":"MI","fatalities":2,"injuries":0,"tow_away":0,"vin":"3HAEUMML2NL630369","vehicle_license":"3229819","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:38"},{"crash_id":"4246874","dot_number":"476823","report_state":"WI","report_date":"20211102","report_time":"0326","city":"LA FAYETTE","state":"WI","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FDTF4GT4KEG68288","vehicle_license":"165407F","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:46"},{"crash_id":"4250560","dot_number":"476823","report_state":"IL","report_date":"20210910","report_time":"0251","city":"HOFFMAN ESTATES","state":"IL","fatalities":1,"injuries":5,"tow_away":0,"vin":"3ALACWDT7GDHG3155","vehicle_license":"2364683","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:33:59"},{"crash_id":"4086263","dot_number":"476823","report_state":"IN","report_date":"20201122","report_time":"2220","city":"CAMBRIDGE CITY","state":"IN","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGEDVXFDGP1383","vehicle_license":"2308106","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:25"},{"crash_id":"4065227","dot_number":"476823","report_state":"NC","report_date":"20201119","report_time":"1533","city":"LEXINGTON","state":"NC","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJHLDV1LSMD3200","vehicle_license":"2985744","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:25"},{"crash_id":"4030013","dot_number":"476823","report_state":"OH","report_date":"20200831","report_time":"1554","city":"PERRY (TOWNSHIP OF)","state":"OH","fatalities":0,"injuries":2,"tow_away":0,"vin":"3AKJHLDR0JSKA6418","vehicle_license":"2714173","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:41"},{"crash_id":"4020511","dot_number":"476823","report_state":"WI","report_date":"20200820","report_time":"0904","city":"OAK CREEK","state":"WI","fatalities":0,"injuries":1,"tow_away":0,"vin":"3ALHCYFE9LDLX7552","vehicle_license":"2928568","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:41"},{"crash_id":"3986661","dot_number":"476823","report_state":"NC","report_date":"20200615","report_time":"1603","city":"RALEIGH","state":"NC","fatalities":0,"injuries":1,"tow_away":0,"vin":"3ALACWFC5KDKJ7025","vehicle_license":"167980H","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:42"},{"crash_id":"3989922","dot_number":"476823","report_state":"FL","report_date":"20200614","report_time":"2200","city":"UNINCORPORATED","state":"FL","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJHLDV4LSMD3191","vehicle_license":"NNVE30","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:42"},{"crash_id":"3947224","dot_number":"476823","report_state":"MI","report_date":"20200306","report_time":"0149","city":"GRAND BLANC TWP","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1HSHXAHR94J089341","vehicle_license":"P921235","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:52"},{"crash_id":"3939131","dot_number":"476823","report_state":"MI","report_date":"20200213","report_time":"0145","city":"BATTLE CREEK","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"2FZHCHBS78AZ24655","vehicle_license":"P889592","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:52"},{"crash_id":"3928808","dot_number":"476823","report_state":"WI","report_date":"20200129","report_time":"0105","city":"MARSHFIELD","state":"WI","fatalities":0,"injuries":0,"tow_away":0,"vin":"3ALACXFC2LDLX7564","vehicle_license":"2928600","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:52"},{"crash_id":"3946971","dot_number":"476823","report_state":"NC","report_date":"20200124","report_time":"2352","city":"CARY","state":"NC","fatalities":0,"injuries":0,"tow_away":0,"vin":"3ALACWDT4EDFZ0941","vehicle_license":"ZK8223","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:11"},{"crash_id":"3808488","dot_number":"476823","report_state":"MI","report_date":"20190525","report_time":"0505","city":"Northfield Twp","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1HSDHSJR8DJ079394","vehicle_license":"P911961","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:34"},{"crash_id":"3790997","dot_number":"476823","report_state":"IN","report_date":"20190520","report_time":"1205","city":"INDIANAPOLIS","state":"IN","fatalities":0,"injuries":1,"tow_away":0,"vin":"3ALACXDT7DDFH9996","vehicle_license":"2575172","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREW DISTRIBUTION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:34"}]}