Final NTSB investigations: CFM International CFM56 series, 2000
4 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 | 12 |
| 2002 | 4 |
| 2003 | 7 |
| 2004 | 7 |
| 2005 | 13 |
| 2006 | 11 |
| 2007 | 8 |
| 2008 | 10 |
| 2009 | 8 |
| 2010 | 10 |
| 2011 | 6 |
| 2012 | 6 |
| 2013 | 3 |
| 2014 | 6 |
| 2015 | 12 |
| 2016 | 10 |
| 2017 | 4 |
| 2018 | 4 |
| 2019 | 4 |
| 2022 | 4 |
| 2023 | 1 |
| 2024 | 3 |
| 2025 | 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\") = 2000
AND c.\"completionStatus\" = 'Completed'
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") = 2000
AND c."completionStatus" = 'Completed'
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 ANC01LA018Accident · Serious injuriesLimited investigationFinal reportBoeing 737-790 · Anchorage, AKAn in-flight encounter with clear air turbulence.NTSB CHI00LA269Accident · Serious injuriesLimited investigationFinal reportBoeing 737-322 · Chicago, ILthe evasive maneuver performed by the pilot. A factor was the activation of the collision avoidance system.NTSB MIA00LA169Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Nashville, TNThe passenger's onboard disturbance and self-evacuation from the parked aircraft, resulting in injuries. A factor in the accident was the lack of backup electrical power to the terminal which necessitated a lengthy ground hold.NTSB NYC00LA097Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Boston, MAIn flight encounter with turbulence.