{"dot_number":"470242","summary":{"total":18,"fatalities":3,"injuries":7},"crashes":[{"crash_id":"4994707","dot_number":"470242","report_state":"IA","report_date":"20250820","report_time":"0728","city":"ANKENY","state":"IA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJA6CV64LL97402","vehicle_license":"P851679","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MELYX INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:59"},{"crash_id":"4731861","dot_number":"470242","report_state":"IL","report_date":"20240410","report_time":"1353","city":"ORLAND PARK","state":"IL","fatalities":0,"injuries":0,"tow_away":0,"vin":"3ALXFB006EDFW2192","vehicle_license":"P1102729","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"XYLEM LTD","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:32:02"},{"crash_id":"3988513","dot_number":"470242","report_state":"IL","report_date":"20200511","report_time":"1343","city":"CHANNAHON TWP","state":"IL","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKDDU9X64J052038","vehicle_license":"P848190","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"Xylem Ltd","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:34:52"},{"crash_id":"3907977","dot_number":"470242","report_state":"IL","report_date":"20191028","report_time":"0347","city":"Wyanet Twp","state":"IL","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJGLDR3CSBJ4881","vehicle_license":"P930944","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"XYLEM LTD","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:35:11"},{"crash_id":"3570987","dot_number":"470242","report_state":"IL","report_date":"20180403","report_time":"1301","city":"Cordova Twp","state":"IL","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGNDV6JDJN7407","vehicle_license":"P650078","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"XYLEM LTD","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:36:57"},{"crash_id":"3296215","dot_number":"470242","report_state":"IL","report_date":"20160711","report_time":"1410","city":"Newton Twp","state":"IL","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XKDDB9X05J080505","vehicle_license":"P659005","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MELYX INC","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:38:12"},{"crash_id":"3320891","dot_number":"470242","report_state":"IL","report_date":"20160310","report_time":"0625","city":"Cordova","state":"IL","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUJA6CKX8LAB6810","vehicle_license":"P866578","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"Xylem LTD","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:38:26"},{"crash_id":"3001312","dot_number":"470242","report_state":"IN","report_date":"20150218","report_time":"1426","city":"WARSAW","state":"IN","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUJA6AV54LM62288","vehicle_license":"P329356","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"XYLEM LTD","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:21"},{"crash_id":"2937980","dot_number":"470242","report_state":"IA","report_date":"20141024","report_time":"1215","city":"GREELEY","state":"IA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJA6AV85LN45912","vehicle_license":"P695686","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"XYLEM LTD","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:33"},{"crash_id":"2281653","dot_number":"470242","report_state":"IL","report_date":"20100729","report_time":"0800","city":"Bloomingdale twp","state":"IL","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKDDB9X05J080505","vehicle_license":"P659005","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"XYLEM LTD","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:42:17"},{"crash_id":"2187974","dot_number":"470242","report_state":"IL","report_date":"20090826","report_time":"0725","city":"PORT BYRON","state":"IL","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKDDR9X2XR779826","vehicle_license":"P650078","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"XYLEM LTD","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:42:56"},{"crash_id":"1935873","dot_number":"470242","report_state":"IL","report_date":"20080227","report_time":"1120","city":"Joliet","state":"IL","fatalities":1,"injuries":2,"tow_away":0,"vin":"1FUYDDYB4XPA36758","vehicle_license":"P396339","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"XYLEM LTD","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:43:43"},{"crash_id":"1099821","dot_number":"470242","report_state":"IL","report_date":"20030415","report_time":"1045","city":"Chicago","state":"IL","fatalities":0,"injuries":0,"tow_away":0,"vin":"2140","vehicle_license":"217281ST","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"XYLEM LTD","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:47:17"},{"crash_id":"1070469","dot_number":"470242","report_state":"WI","report_date":"20021008","report_time":"1555","city":"CADY","state":"WI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUYSDYBXVP715465","vehicle_license":"P121072","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MELYX INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:33"},{"crash_id":"234311","dot_number":"470242","report_state":"WI","report_date":"19990712","report_time":"1250","city":"CRANDON","state":"WI","fatalities":1,"injuries":1,"tow_away":0,"vin":"1FUYDZYB0NP525732","vehicle_license":"P175367","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MELYX INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:01"},{"crash_id":"584473","dot_number":"470242","report_state":"IL","report_date":"19980616","report_time":"1420","city":"NEWTON TWNSP.","state":"IL","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP6D29X4KD603652","vehicle_license":"P257650","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"XYLEM, LTD.","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:38"},{"crash_id":"578010","dot_number":"470242","report_state":"IL","report_date":"19980601","report_time":"1730","city":"HOPKINS","state":"IL","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUY3ECB4RH641986","vehicle_license":"P255074","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MELYX INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:38"},{"crash_id":"565804","dot_number":"470242","report_state":"IA","report_date":"19970605","report_time":"1125","city":"WHEATLAND","state":"IA","fatalities":1,"injuries":0,"tow_away":0,"vin":"1FUYYRYB7JP311302","vehicle_license":"P37364","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MELYX INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:51:05"}]}