{"dot_number":"810475","summary":{"total":11,"fatalities":1,"injuries":9},"crashes":[{"crash_id":"294023","dot_number":"810475","report_state":"PA","report_date":"20010511","report_time":"1851","city":"PHILADELPHIA","state":"PA","fatalities":0,"injuries":1,"tow_away":0,"vin":"","vehicle_license":"AA69848","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"CARLOS LEFFLER","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:41"},{"crash_id":"1669033","dot_number":"810475","report_state":"PA","report_date":"20010417","report_time":"0730","city":"LONDONDERRY TOWNSHIP","state":"PA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XKDDR9X3TS721971","vehicle_license":"YFW3503","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"CARLOS R LEFFLER","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:41"},{"crash_id":"940982","dot_number":"810475","report_state":"PA","report_date":"20000221","report_time":"0805","city":"EAST COCALICO","state":"PA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUYDZYB6KH344110","vehicle_license":"AD17084","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"CARLOS R LEFFLER","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:48"},{"crash_id":"941303","dot_number":"810475","report_state":"PA","report_date":"20000118","report_time":"0945","city":"LONDONDERRY","state":"PA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XKDDR9X8NJ579707","vehicle_license":"AD17278","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"COLUMBIA PETROLEUM CORP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:48"},{"crash_id":"1001335","dot_number":"810475","report_state":"PA","report_date":"19990823","report_time":"1259","city":"UPPER NAZARETH","state":"PA","fatalities":0,"injuries":0,"tow_away":0,"vin":"3NKMHD7XXTF723623","vehicle_license":"AD17113","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"COLUMBIA PETROLEUM","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:01"},{"crash_id":"1001268","dot_number":"810475","report_state":"PA","report_date":"19990819","report_time":"1105","city":"NORTH ANNVILLE","state":"PA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XKDDR9X8NJ579707","vehicle_license":"AD17278","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"COLUMBIA PETRO CO / DBA CARLOS R LEFFLER","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:01"},{"crash_id":"998887","dot_number":"810475","report_state":"PA","report_date":"19990311","report_time":"0920","city":"BETHEL","state":"PA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1HTZSZ3R3KH644406","vehicle_license":"AB57720","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"CARLOS LEFFLER","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:15"},{"crash_id":"981006","dot_number":"810475","report_state":"PA","report_date":"19960521","report_time":"9999","city":"MARION","state":"PA","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"YB60597","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"CARLOS R LEFFLER","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:51:35"},{"crash_id":"972383","dot_number":"810475","report_state":"PA","report_date":"19941205","report_time":"0741","city":"WEST EARL","state":"PA","fatalities":1,"injuries":1,"tow_away":0,"vin":"D2127JGB25152","vehicle_license":"YF49852","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"CARLOS R LEFFLER INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:52:22"},{"crash_id":"966283","dot_number":"810475","report_state":"PA","report_date":"19940129","report_time":"0817","city":"SINKING SPRING","state":"PA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUYDZYBXKH344112","vehicle_license":"AA69846","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"CARLOS R LEFFLER INC","federal_recordable":"N","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:52:32"},{"crash_id":"962994","dot_number":"810475","report_state":"PA","report_date":"19930626","report_time":"0345","city":"CUMRU","state":"PA","fatalities":0,"injuries":2,"tow_away":0,"vin":"1XKDDR9X7PJ610755","vehicle_license":"YW09863","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"CARLOS R LEFFLER INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:52:47"}]}