{"dot_number":"2497677","summary":{"total":20,"fatalities":0,"injuries":18},"crashes":[{"crash_id":"5063991","dot_number":"2497677","report_state":"LA","report_date":"20251109","report_time":"0330","city":"WHITE CASTLE","state":"LA","fatalities":0,"injuries":0,"tow_away":0,"vin":"3HSDJAPR2EN786723","vehicle_license":"R655789","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:49"},{"crash_id":"4999028","dot_number":"2497677","report_state":"LA","report_date":"20250608","report_time":"0319","city":"WELSH","state":"LA","fatalities":0,"injuries":2,"tow_away":0,"vin":"1NPXGGGG90D390040","vehicle_license":"P246454","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:59"},{"crash_id":"4874729","dot_number":"2497677","report_state":"TX","report_date":"20241227","report_time":"0530","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGLD5XESFN2456","vehicle_license":"R329955","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:21"},{"crash_id":"4690102","dot_number":"2497677","report_state":"TX","report_date":"20240109","report_time":"1925","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJHHFG4JSJJ1471","vehicle_license":"R694979","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:09"},{"crash_id":"4601976","dot_number":"2497677","report_state":"TX","report_date":"20230728","report_time":"0036","city":"HOUSTON","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"3AKJGNDR4NDNK1011","vehicle_license":"R553845","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:29"},{"crash_id":"4593474","dot_number":"2497677","report_state":"LA","report_date":"20230712","report_time":"1542","city":"RURAL","state":"LA","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGLD5XESFN2456","vehicle_license":"R329955","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:29"},{"crash_id":"4579903","dot_number":"2497677","report_state":"TX","report_date":"20230510","report_time":"1601","city":"HOUSTON","state":"TX","fatalities":0,"injuries":2,"tow_away":0,"vin":"1XPXDP9X3ED243859","vehicle_license":"R604675","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:40"},{"crash_id":"4374793","dot_number":"2497677","report_state":"TX","report_date":"20220614","report_time":"1756","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGLD55FSGF1165","vehicle_license":"R496842","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:22"},{"crash_id":"4374388","dot_number":"2497677","report_state":"TX","report_date":"20220613","report_time":"1256","city":"HOUSTON","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPHD49X5DD186310","vehicle_license":"R453158","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:22"},{"crash_id":"4366286","dot_number":"2497677","report_state":"TX","report_date":"20220525","report_time":"0059","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBD49X6ED245016","vehicle_license":"R531472","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:22"},{"crash_id":"4243792","dot_number":"2497677","report_state":"LA","report_date":"20211021","report_time":"1948","city":"6003","state":"LA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPHD49X5DD186310","vehicle_license":"R453158","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:46"},{"crash_id":"4174822","dot_number":"2497677","report_state":"LA","report_date":"20210608","report_time":"0440","city":"2406","state":"LA","fatalities":0,"injuries":3,"tow_away":0,"vin":"1XKAD49X9DR329320","vehicle_license":"R439096","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:07"},{"crash_id":"4152421","dot_number":"2497677","report_state":"TX","report_date":"20210410","report_time":"1439","city":"HOUSTON","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"2HSCNAPR56C251405","vehicle_license":"R391566","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:07"},{"crash_id":"4134091","dot_number":"2497677","report_state":"TX","report_date":"20210323","report_time":"2127","city":"HOUSTON","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"3HSDJAPR2EN761112","vehicle_license":"R409257","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:14"},{"crash_id":"4135583","dot_number":"2497677","report_state":"TX","report_date":"20210313","report_time":"2049","city":"HOUSTON","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X66D882443","vehicle_license":"Z131906","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:14"},{"crash_id":"3950159","dot_number":"2497677","report_state":"TX","report_date":"20200311","report_time":"0801","city":"BEAUMONT","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPHD49X9DD186388","vehicle_license":"R453159","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:52"},{"crash_id":"3813786","dot_number":"2497677","report_state":"TX","report_date":"20190616","report_time":"1741","city":"RURAL FORT BEND COUNTY","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPXDP9X3ED243859","vehicle_license":"R307998","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:34"},{"crash_id":"3618738","dot_number":"2497677","report_state":"TX","report_date":"20180609","report_time":"1120","city":"RURAL HARRIS COUNTY","state":"TX","fatalities":0,"injuries":5,"tow_away":0,"vin":"1FUJA6CK77LW52276","vehicle_license":"R309614","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:36:49"},{"crash_id":"3581460","dot_number":"2497677","report_state":"TX","report_date":"20180403","report_time":"1439","city":"PASADENA","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJA6CK97LX48233","vehicle_license":"R234769","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:36:57"},{"crash_id":"3435832","dot_number":"2497677","report_state":"LA","report_date":"20170728","report_time":"0549","city":"2000","state":"LA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPXD49X6DD199062","vehicle_license":"R242446","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MIDSTREAM TRANSPORTATION COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:37:33"}]}