NTSB investigations: CFM International CFM56 series
11 cases on aircraft whose registry engine model is CFM International CFM56 series, where the first occurrence was “On ground/water collision with object”. 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
| 1992 | 1 |
|---|---|
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 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 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310))
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310))
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 LAX06LA009Accident · No injuriesLimited investigationFinal reportBoeing 737-7H4 · Phoenix, AZThe failure of the other flight crew to maintain an adequate clearance from obstructions while taxiing.NTSB CHI05LA179Accident · No injuriesLimited investigationFinal reportBoeing 737-7H4 · Chicago, ILThe pushback tow driver not maintaining visual lookout for the wing walker's visual signal, and the driver not maintaining clearance from the vehicle during the pushback for taxi. Factors to the accident were the standing vehicle behind the airplane, the…NTSB DEN05IA098Incident · No injuriesIncident investigationFinal reportBoeing 737-524 · Salt Lake City, UTthe left wing walker's failure to maintain an adequate visual lookout. Contributing factors were his inadequate initial training, and the failure of other ground personnel to follow company procedures/directives.NTSB DEN05IA076Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Denver, COthe improper use of procedure used by the ground personnel resulting in the right wing of the aircraft colliding with the left wing of another aircraft. A factor in this incident was the failure to maintain clearance by the flight crew of the other aircraft.NTSB NYC04IA152Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-114 · Manchester, NHThe Airbus captain's misjudged clearance, which resulted the left wing of the Airbus contacting the rudder of the stationary Canadair.NTSB CHI03IA055Incident · No injuriesIncident investigationFinal reportBoeing 737-83N · Indianapolis, INThe ground tow personnel not maintaining clearance from the de-icing vehicle during the tow back to the gate. Factors were the de-icing vehicle that parked by the airplane's left wing, the ground personnel not following the operator's towing…NTSB NYC01LA094Accident · No injuriesLimited investigationFinal reportBoeing 767-200ER · Boston, MAThe Boeing 767 captain's misjudgment of the distance between his airplane and the stationary Boeing 737, which resulted in a ground collision. A factor was sunglare.NTSB FTW98FA273Accident · Minor injuriesField investigationFinal reportBoeing 737-322 · Denver, COInadequate visual lookout by ground personnel (tug operator). Factors include failure of the airline to provide proper assistance (wing walkers) to the tug operator, and inadequate pushback procedures by the airline; inattention of the catering truck driver,…NTSB CHI95LA170Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-320-211 · St Paul, MNthe captain's not maintaining crew/group coordination. Factors were the captain's diverted attention and his not maintaining visual separation.NTSB FTW95IA053Incident · No injuriesIncident investigationFinal reportBoeing B-737-300 · Houston, TXThe failure of maintenance personnel to follow the taxi checklist resulting in the hydraulic pumps not being turned on.NTSB NYC93LA040Accident · 1 fatalLimited investigationFinal reportBoeing 737-300LR · Flushing, NYA lack of adequate clearance between the walker and tug which resulted in the walker being struck by the tug when he fell for unknown reason(s). A factor related to the accident was the lack of a policy to stay clear of the tug, towbar, and nosewheel of the…