NTSB investigations: IAE V2500SERIES, CA
7 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 per year
| 1991 | 1 |
|---|---|
| 2001 | 2 |
| 2005 | 1 |
| 2010 | 1 |
| 2019 | 1 |
| 2025 | 1 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND 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 DCA25LA268Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A319-131 · Santa Barbara, CAThe ramp worker’s premature entry into the jet blast hazard area of an operating engine due to his failure to maintain situational awareness and his misinterpretation of the marshaller’s hand signals.NTSB DCA19CA192Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 737 · SFO International Airport, CAthe ramp controller directing a Boeing 737 to hold in a location that was marked for a regional jet.NTSB WPR10IA430Incident · Minor injuriesIncident investigationFinal reportAirbus A320-232 · Sacramento, CAThe first officer’s inadvertent activation of the parking brake in flight, which led to the airplane abruptly stopping and all four of its main landing gear tires deflating, and his use of a nonstandard procedure to cancel the airplane's monitoring alert…NTSB LAX05IA312Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320 · Los Angeles, CAThe fatigue failure of two anti-rotation lugs due to repeated cyclic pre-landing tests, which allowed the nosewheels to deviate from the 0-degree position on landing gear retraction. A contributing factor was the design of the Brake Steering Control Unit…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 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.