NTSB investigations: CFM International CFM56 series, 2012
6 cases on aircraft whose registry engine model is CFM International CFM56 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
| 1970 | 1 |
|---|---|
| 1971 | 1 |
| 1983 | 2 |
| 1985 | 1 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 6 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 16 |
| 1996 | 8 |
| 1997 | 6 |
| 1998 | 5 |
| 1999 | 8 |
| 2000 | 4 |
| 2001 | 13 |
| 2002 | 4 |
| 2003 | 7 |
| 2004 | 7 |
| 2005 | 14 |
| 2006 | 11 |
| 2007 | 9 |
| 2008 | 10 |
| 2009 | 9 |
| 2010 | 11 |
| 2011 | 6 |
| 2012 | 6 |
| 2013 | 3 |
| 2014 | 6 |
| 2015 | 12 |
| 2016 | 10 |
| 2017 | 4 |
| 2018 | 4 |
| 2019 | 5 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 5 |
| 2023 | 3 |
| 2024 | 8 |
| 2025 | 9 |
| 2026 | 4 |
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\") = 2012
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('13802'))
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") = 2012
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('13802'))
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 WPR13CA016Accident · Serious injuriesData collectionFinal reportBoeing 737-3H4 · Las Vegas, NVThe flight attendant's encounter with an unseen obstruction in the aisle, which resulted in a fall.NTSB DCA12IA113Incident · No injuriesIncident investigationFinal reportBoeing 737-3H4 · El Paso, TXthe rupture of the nose landing gear hydraulic line that resulted from abrasions due to contact with the nose landing gear tire. Contributing to the incident was the incorrect installation of union and restrictor on the actuator.NTSB DCA12LA091Accident · Serious injuriesLimited investigationFinal reportBoeing 737-724 · Winnie, TXthe flight crew's penetration of a rapidly developing thunderstorm cell in an area of forecasted convective activity. The serious injuries were the result of a misunderstanding between the captain and cabin crew regarding the potential for turbulence.NTSB DCA12CA088Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320-212 · Minneapolis, MNInadvertent encounter with convective turbulence while in descent.NTSB DCA12FA046Accident · Serious injuriesField investigationFinal reportAirbus A321 · Millville, NJan encounter with convective turbulence that resulted in injury to a passenger who was not seated when the seatbelt sign was illuminated.NTSB CEN12LA166Accident · Serious injuriesLimited investigationFinal reportBoeing 737-832 · Detroit, MIAn in-flight encounter with forecasted turbulence, which resulted in a serious injury to a flight attendant. Contributing to the accident was the flight attendant not being seated with her seatbelt fastened when the encounter occurred.