NTSB investigations: CFM International CFM56-5B4/3 series
8 cases on aircraft whose registry engine model is CFM International CFM56-5B4/3 series. 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
| 2017 | 1 |
|---|---|
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('13090'))
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 ('13090'))
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 DCA25WA145Incident · Minor injuriesClass 5 · ForeignAirbus A320-214 · Bogotá, ColombiaNTSB ENG23WA042Incident · No injuriesClass 5 · ForeignAirbus A320 · Enroute Bogota - Barranquilla, ColombiaNTSB DCA23LA378Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-214 · Inverness, FLAn inadvertent encounter with convectively induced turbulence during descent.NTSB ENG22WA035Incident · No injuriesClass 4 · ForeignAirbus A320-214 · Bogota, ColombiaNTSB DCA22WA023IncidentClass 5 · ForeignAirbus A320-214 · Ibague, ColombiaNTSB DCA21WA098IncidentClass 5 · ForeignAirbus A320-214 · Bogata, ColombiaNTSB DCA19CA079Accident · No injuriesClass 4 · Data collectionFinal reportAirbus A320 · Denver, COloss of control of the tug by the driver during pushback operations as a result of the contaminated ramp, angle of the towbar, and the airplane engines being at idle thrust.NTSB DCA17WA170Incident · No injuriesForeign investigationAirbus A320 214 · Cali, ColombiaThe Grupo de Investigacion de Accidentes of Colombia has notified the NTSB of an incident involving a AIRBUS A320 214 airplane that occurred on July 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's…