NTSB investigations: IAE V2500SERIES, CO
6 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
| 2004 | 1 |
|---|---|
| 2005 | 1 |
| 2006 | 3 |
| 2012 | 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\" = 'CO' 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" = 'CO' 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 DCA12CA062Accident · Serious injuriesData collectionFinal reportAirbus Industrie A319-132 · Buena Vista, COan inadvertent encounter with mountain wave turbulence.NTSB DEN07FA008Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-90-30 · Denver, COA fractured nose gear assembly spray deflector that blocked the nose gear from extending during landing, and resulted in an intentional nose gear up landing.NTSB DEN06LA095Accident · Serious injuriesLimited investigationFinal reportAirbus A319-131 · Masonville, COthe flight's encounter with unexpected turbulence, which resulted in a passenger sustaining a fractured ankle.NTSB DEN06IA083Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-90-30 · Denver, COa brake fire for reasons undetermined. A contributing factor was the inadequate inspection by the maintenance crew.NTSB DFW05IA200Incident · No injuriesIncident investigationFinal reportAirbus A320-232 · Denver, COThe captain's failure to maintain sufficient clearance while taxiing to an assigned gate, which resulted in a collision with an airplane that had been pushed back (and holding) from another gate. Also causal was the tug operator's failure to follow published…NTSB DEN04IA050Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-232 · Denver, COthe failure of the other flight crew to maintain clearance from the airplane and the ground crews failure to follow proper pushback procedures.