how many aviation incidents as a result of mechanical failure have there been?
Value
5
class entity
aviation.airliner_accident m.04zj7qs
aviation.airliner_accident aviation.accident_type
Aviation incident Mechanical failure
count none
aviation.airliner_accident.accident_type
Type
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX : <http://rdf.freebase.com/ns/> 
SELECT (COUNT(?x0) AS ?value) WHERE {
SELECT DISTINCT ?x0  WHERE { 
?x0 :type.object.type :aviation.airliner_accident . 
VALUES ?x1 { :m.04zj7qs } 
?x0 :aviation.airliner_accident.accident_type ?x1 . 
FILTER ( ?x0 != ?x1  )
}
}
(COUNT (AND aviation.airliner_accident (JOIN aviation.airliner_accident.accident_type m.04zj7qs)))