NTSB investigations: CFM International CFM56 series, 1997
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\") = 1997
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") = 1997
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 SEA98IA027Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Eugene, ORA checklist procedure was not followed. The initiation of an evacuation was a factor.NTSB MIA97IA237Incident · Minor injuriesIncident investigationFinal reportBoeing 737-300 · Tampa, FLin-flight collision with a bird.NTSB LAX97IA243Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Ontario, CAa laser light source of undetermined origin directed toward the cockpit window of an aircraft in-flight by a person or persons unknown.NTSB FTW97IA187Incident · No injuriesIncident investigationFinal reportBoeing 737-524 · Corpus Christi, TXThe flightcrew's inadequate in-flight planning and decision, and their failure to refer to the navaids needed for the instrument approach procedure. A factor was the lack of a minimum safe altitude warning from approach control.NTSB LAX97IA161Incident · Minor injuriesIncident investigationFinal reportBoeing 737-500 · Rialto, CAa laser light source of undetermined origin, directed by unknown person(s) toward the cockpit window of the aircraft, while the aircraft was on an approach to land.NTSB SEA97IA071Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Portland, ORimproper installation of four attach bolts on the elevator drive torque tube.