The basic question I would ask should one fly the non-precision approach into the Comores at night time during bad weather conditions?
Most airlines decided not to fly there at night and certainly not during bad weather conditions. This is matter of basic risk assessment. It seems Yemenia has not made the same risk assessment as other airlines have.
A lot of media attention as focussed on technical issues (relation to EU SAFA checks) or crew error but the main reason of this accident is probably caused by the rather challenging approach in the conditions the crew faced.