NTSB investigations: CFM International CFM56 series
9 cases on aircraft whose registry engine model is CFM International CFM56 series, where the defining event was Cabin safety event. 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
| 2012 | 1 |
|---|---|
| 2013 | 1 |
| 2015 | 4 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 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 ('13802')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '110'))
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 ('13802')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '110'))
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 DCA19CA137Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Fort Meyers, FLmissing attach screws on the aft galley oven, which allowed it to become dislodged landing, injuring a flight attendant.NTSB DCA19CA006Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · San Jose, CAA passenger falling while returning to her seat which resulted in a serious injury.NTSB DCA17CA087Accident · Serious injuriesData collectionFinal reportAirbus A319 114 · Los Angeles, CAmalfunction of the parking brake electrical control valve that resulted in a sudden stop.NTSB DCA16CA008Accident · Serious injuriesData collectionFinal reportBoeing 737 3H4 · Pound Ridge, NYhot water spilled from a cup onto the flight attendant's arm resulting in a 2nd degree burn.NTSB DCA15CA145Accident · Serious injuriesData collectionFinal reportBoeing 737 832 · Salt Lake City, UTinadvertent contact by beverage cart during cabin service.NTSB DCA15CA152Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320 212 · Boston, MAan inadvertent fall by the passenger while exiting the lavatory when the seat belt light was illuminated.NTSB DCA15CA125Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320 212 · Atlanta, GAthe flight attendant's failure to secure her lap belt and shoulder harness prior to the takeoff that resulted in her being thrown from her jumpseat shortly after takeoff.NTSB DCA13CA091Accident · Serious injuriesData collectionFinal reportAirbus 320 · Dallas, TXThe flight attendant's inadvertent trip over the jumpseat that had not retracted automatically.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.