{"dot_number":"337941","summary":{"total":28,"fatalities":0,"injuries":22},"crashes":[{"crash_id":"4846544","dot_number":"337941","report_state":"TX","report_date":"20241008","report_time":"1722","city":"HOUSTON","state":"TX","fatalities":0,"injuries":2,"tow_away":0,"vin":"1M1AK06Y87N023714","vehicle_license":"1L10270","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:34"},{"crash_id":"4512127","dot_number":"337941","report_state":"TX","report_date":"20230209","report_time":"1400","city":"HOUSTON","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGLDR1ESFL2048","vehicle_license":"589290G","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:53"},{"crash_id":"4119761","dot_number":"337941","report_state":"TX","report_date":"20210225","report_time":"0648","city":"HOUSTON","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPXD49X7FD285497","vehicle_license":"1M16279","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:14"},{"crash_id":"3626518","dot_number":"337941","report_state":"TX","report_date":"20180713","report_time":"1550","city":"HOUSTON","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M1AK06YX7N024251","vehicle_license":"1L10268","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:36:48"},{"crash_id":"3504253","dot_number":"337941","report_state":"TX","report_date":"20171111","report_time":"1535","city":"HOUSTON","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJBBCK95LU14416","vehicle_license":"1L10262","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:37:17"},{"crash_id":"3163664","dot_number":"337941","report_state":"TX","report_date":"20160123","report_time":"0817","city":"HOUSTON","state":"TX","fatalities":0,"injuries":3,"tow_away":0,"vin":"1M1AK06Y17N023716","vehicle_license":"1G09896","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:48"},{"crash_id":"3130852","dot_number":"337941","report_state":"TX","report_date":"20151102","report_time":"1130","city":"HOUSTON","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUJA6CK97DX80805","vehicle_license":"1G09892","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:48"},{"crash_id":"3036534","dot_number":"337941","report_state":"TX","report_date":"20150411","report_time":"1400","city":"HOUSTON","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUJA6CKX7LW20079","vehicle_license":"90C3154","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:05"},{"crash_id":"2943744","dot_number":"337941","report_state":"TX","report_date":"20141025","report_time":"0750","city":"HOUSTON","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJBBCG83LK61648","vehicle_license":"1E42537","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:33"},{"crash_id":"2800182","dot_number":"337941","report_state":"TX","report_date":"20131206","report_time":"1420","city":"HOUSTON","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJF0CV35LU09554","vehicle_license":"01C9913","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:11"},{"crash_id":"2732064","dot_number":"337941","report_state":"TX","report_date":"20130703","report_time":"1506","city":"RURAL HARRIS COUNTY","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUYDDYB5YMF13670","vehicle_license":"1C09905","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:24"},{"crash_id":"2606025","dot_number":"337941","report_state":"TX","report_date":"20120725","report_time":"1340","city":"","state":"TX","fatalities":0,"injuries":4,"tow_away":0,"vin":"NONE","vehicle_license":"1A10041","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:55"},{"crash_id":"2614790","dot_number":"337941","report_state":"TX","report_date":"20120528","report_time":"1215","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"2HSCEAMR2YC030447","vehicle_license":"1A47045","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:55"},{"crash_id":"2435608","dot_number":"337941","report_state":"TX","report_date":"20110616","report_time":"1545","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUYDDYB5TP785138","vehicle_license":"2AL012","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:42"},{"crash_id":"2147456","dot_number":"337941","report_state":"TX","report_date":"20090630","report_time":"0440","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUPDSZB0XD984751","vehicle_license":"2CR619","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:09"},{"crash_id":"2070080","dot_number":"337941","report_state":"TX","report_date":"20081116","report_time":"0631","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUYDDY5YMF013670","vehicle_license":"ZAL134","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:20"},{"crash_id":"2036467","dot_number":"337941","report_state":"TX","report_date":"20081004","report_time":"0905","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"2FUYDSEB6VA617078","vehicle_license":"2AL132","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:20"},{"crash_id":"2052200","dot_number":"337941","report_state":"TX","report_date":"20080102","report_time":"1411","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUYDDYB8YMF13677","vehicle_license":"2CJ756","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:08"},{"crash_id":"1903839","dot_number":"337941","report_state":"TX","report_date":"20071120","report_time":"0605","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUYDDYB0YLG50165","vehicle_license":"2CP233","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:08"},{"crash_id":"1847653","dot_number":"337941","report_state":"TX","report_date":"20070628","report_time":"1955","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUFYDYB2FP270979","vehicle_license":"25Y033","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:17"},{"crash_id":"1711361","dot_number":"337941","report_state":"TX","report_date":"20061005","report_time":"1410","city":"","state":"TX","fatalities":0,"injuries":2,"tow_away":0,"vin":"1FUJA3CG21LB23998","vehicle_license":"R8KW91","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:38"},{"crash_id":"1917046","dot_number":"337941","report_state":"TX","report_date":"20060212","report_time":"1500","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUY3LCB0NH523654","vehicle_license":"R6X71","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:08"},{"crash_id":"1828877","dot_number":"337941","report_state":"TX","report_date":"20050920","report_time":"1720","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUYSDYBXYLB91930","vehicle_license":"R5MD06","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:28"},{"crash_id":"1827181","dot_number":"337941","report_state":"TX","report_date":"20050917","report_time":"1150","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUYTMDBXWH923764","vehicle_license":"2EK999","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:28"},{"crash_id":"1378730","dot_number":"337941","report_state":"TX","report_date":"20041019","report_time":"1024","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUYDZYB5TP709495","vehicle_license":"2AK377","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:17"},{"crash_id":"1370085","dot_number":"337941","report_state":"TX","report_date":"20040914","report_time":"0630","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUYDCYB9NH2206","vehicle_license":"2AK372","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:17"},{"crash_id":"1093658","dot_number":"337941","report_state":"TX","report_date":"20030123","report_time":"1025","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"2HSFBT6R3FCA16863","vehicle_license":"1NA840","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:32"},{"crash_id":"361546","dot_number":"337941","report_state":"TX","report_date":"20010831","report_time":"0800","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUYTWEB4WH951246","vehicle_license":"2B6693","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HOUSTON TUBULARS INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:19"}]}