NTSB investigations: IAE V2500SERIES
62 cases on aircraft whose registry engine model is IAE V2500SERIES. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('34601'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('34601'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CHI03IA027Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-131 · Chicago, ILThe maintenance facililty improperly assembled and installed the nose landing gear shock absorber assembly. Factors were the improper assembly which allowed the nose gear to turn 90 degrees to the direction of travel.NTSB FTW02IA027Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-132 · Midland, TXthe #1 engine's fatigue failure of the #3 bearing due to the manufacturer's inadequate design of the high-pressure compressor stubshaft coating, which resulted in a loss of engine power and an emergency landing.NTSB MIA01LA224Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-232 · Needles, CAan inadvertent in-flight encounter with turbulence.NTSB LAX01LA240Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-232 · San Diego, CAthe flight crew's excessive descent rate, which resulted in an injury to a flight attendant.NTSB LAX01LA136Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-232 · Las Vegas, NVThe failure of the pilot-in-command to properly evaluate a hazardous weather advisory and his failure to adequately alter course and flight altitude to avoid the area of hazardous weather.NTSB NYC01IA068Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-232 · Jamaica, NYThe pilot's decision to perform an auto rollout on a snow contaminated runway, which had not been demonstrated, and which resulted in a loss of directional control, when the capability of the autoland system to maintain directional control was exceeded.…NTSB DEN01IA036Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-90-30 · Salt Lake City, UTthe captain's failure to maintain the proper glide path. Contributing factors were the weather conditions that included low visibility and fog.NTSB LAX00LA223Accident · No injuriesLimited investigationFinal reportAirbus Industrie A320-232 · Las Vegas, NVThe failure of the mechanic to refasten the cowling door prior to returning the aircraft to service.NTSB NYC99LA240Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie 319-131 · Sparta, NJThe airplane's encounter with clear air turbulence.NTSB LAX99LA087Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-232 · Las Vegas, NVThe injured passenger's failure to follow the instructions of the cabin attendants.NTSB NYC97LA071Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-232 · Newark, NJan encounter with unforecasted turbulence, during cruise flight, which resulted in serious injury to the flight attendant.NTSB LAX91IA415Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-320-231 · Santa Ana, CAThe failure of the flight attendant assigned to the aft galley jumpseat to secure a beverage cart in accordance with company policy.