NTSB investigations: IAE V2533-A5, 2017
5 cases on aircraft whose registry engine model is IAE V2533-A5. 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
| 2010 | 1 |
|---|---|
| 2013 | 1 |
| 2016 | 3 |
| 2017 | 5 |
| 2018 | 1 |
| 2019 | 2 |
| 2021 | 2 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 2 |
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 year(c.\"eventDate\") = 2017
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('34611'))
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 year(c."eventDate") = 2017
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('34611'))
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 DCA18CA055Accident · Serious injuriesData collectionFinal reportAirbus A321 231 · Fort Lauderdale, FLan inadvertent encounter with convective turbulence that resulted in a flight attendant injury.NTSB DCA17CA214Accident · No injuriesData collectionFinal reportBoeing 737 823 · Arlington, VAThe failure N841NNs captain to maintain appropriate clearance from N982VJ, which was stopped on the taxiway.NTSB DCA17WA209Accident · No injuriesForeign investigationAirbus A321 231 · Christ Church, BarbadosThe Barbados Civil Aviation Department has notified the NTSB of an accident involving a AIRBUS A321 231 airplane that occurred on September 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Barbados's investigation…NTSB DCA17CA147Accident · No injuriesData collectionFinal reportAirbus A321 231 · Chicago, ILthe A321 flight crew's incorrect evaluation of the clearance between the aircraft, leading to the inadvertent collision with the horizontal stabilizer of the CRJ700. Contributing to the accident was traffic congestion that resulted in the CRJ700 having to…NTSB DCA17WA115Incident · No injuriesForeign investigationAirbus A321 · Cancun, MexicoThe Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a AIRBUS A321 airplane that occurred on February 20, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…