NTSB investigations: CFM International CFM56 series
30 cases on aircraft whose registry engine model is CFM International CFM56 series, where the first occurrence was “In flight encounter with weather”. 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
| 1987 | 1 |
|---|---|
| 1988 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 3 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 4 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 2 |
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\" = 240))
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" = 240))
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 DFW07LA164Accident · Serious injuriesLimited investigationFinal reportBoeing B737-800 · McAlester, OKAn in-flight encounter with clear air turbulence, which resulted in a serious injury to a flight attendant.NTSB NYC07LA105Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · La Plata, MDAn in-flight encounter with turbulence and the flight crew's failure to advise the cabin crew about potential forecast turbulence, as reported by the flight attendant.NTSB NYC06LA223Accident · Serious injuriesLimited investigationFinal reportBoeing 737-700 · Hastings, NEThe airplane's in flight encounter with thunderstorm related turbulence.NTSB NYC06LA016Accident · Serious injuriesLimited investigationFinal reportBoeing 737-832 · Atlantic Ocean (Atlantic Ocean)An encounter with turbulence during cruise flight.NTSB DEN05LA090Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-319-114 · Scottsbluff, NEthe inflight encounter with moderate turbulence.NTSB DFW05LA112Accident · Serious injuriesLimited investigationFinal reportBoeing 737-700 · Little Rock, ARAn encounter with moderate turbulence during cruise flight.NTSB CHI04LA148Accident · Serious injuriesLimited investigationFinal reportBoeing 737-7H4 · Liberal, KSThe adverse weather encountered during cruise flight by the flight crew and the flight attendant not being restrained. A contributing factor was the convective activity.NTSB NYC04LA107Accident · Serious injuriesLimited investigationFinal reportBoeing 737-700 · Beach Haven, NJAn encounter with turbulence during cruise flight.NTSB DEN04LA019Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Denver, COthe in-flight encounter with heavy to moderate turbulence.NTSB DEN03LA094Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A319-111 · Denver, COthe inflight encounter with severe turbulence.NTSB FTW03LA121Accident · Serious injuriesLimited investigationFinal reportBoeing 737-924 · Palestine, TXThe airplane's encounter with unforecasted clear air turbulence during cruise flight.NTSB DEN03LA063Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A319-111 · Pueblo, COin-flight encounter with turbulence.NTSB LAX02LA138Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A319-114 · Reno, NVThe failure of an undetermined cabin crewmember to securely close an aft galley compartment door, which necessitated the injured crewmember leaving her seat to secure the compartment door.NTSB NYC02LA065Accident · Serious injuriesLimited investigationFinal reportBoeing 737-724 · Beaumont, TXAn inadvertent encounter with convective induced turbulence, which injured a flight attendant. Factors were the failure of the airline to supply direction to the flight crew to indicate when the flight attendants could begin cabin service, and the convective…NTSB LAX01LA275Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Klamath Falls, ORAn encounter with turbulence from a developing thunderstorm during cruise flight.NTSB MIA01LA146Accident · Serious injuriesLimited investigationFinal reportBoeing 737-301 · Toccoa, GAAn in-flight encounter with unforecasted weather (turbulence) during an enroute climb resulting in one flight attendant sustaining serious injury.NTSB ANC01LA018Accident · Serious injuriesLimited investigationFinal reportBoeing 737-790 · Anchorage, AKAn in-flight encounter with clear air turbulence.NTSB NYC00LA097Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Boston, MAIn flight encounter with turbulence.NTSB IAD99FA052Accident · Serious injuriesField investigationFinal reportBoeing 737-824 · Atlantic Ocean (Atlantic Ocean)the aircrew's inadvertent encounter with unforecast clear air turbulence.NTSB FTW99LA207Accident · Serious injuriesLimited investigationFinal reportBoeing 737-3H4 · Lafayette, LAThe pilot's inadvertent flight into an adverse weather condition. A factor was the turbulence.NTSB ANC97LA015Accident · Serious injuriesLimited investigationFinal reportBoeing 737-400 · Yakutat, AKan in-flight encounter with unforecast severe clear air turbulence.NTSB LAX97LA051Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Bishop, CAa clear air turbulence encounter.NTSB MIA96LA220Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Chattanooga, TNclear air turbulence, which was encountered during cruise flight and resulted in injuries to passengers.NTSB SEA96LA026Accident · Serious injuriesLimited investigationFinal reportBoeing 737-522 · Portland, ORAn unexpected encounter with unforecast moderate high level windshear and turbulence as the flight attendant was performing his duties during descent.NTSB MIA95LA133Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Tallahassee, FLThe failure of a passenger to comply with flight crew instructions to remain seated with her seat belt fastened which resulted in her being injured while walking in the aisle during a turbulence encounter.NTSB MIA94LA214Accident · Serious injuriesLimited investigationFinal reportBoeing 737-400 · Atlantic Ocean (Atlantic Ocean)The inflight encounter with turbulence in clouds.NTSB FTW92LA200Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Springfield, MOThe encounter with severe turbulence while deviating around convective activity.NTSB FTW90LA156Accident · Serious injuriesLimited investigationFinal reportBoeing B-737-300 · Corpus Christi, TXThe airplane's unexpected encounter with clear air turbulence.NTSB FTW88IA141Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Kenton, DEA flameout of the #1 engine occurred due to water ingestion when the aircraft penetrated a vip level 5 thunderstorm and encountered heavy rain while descending with the throttles a flight idle. The engine suffered overtemperature damage to the turbine section…NTSB FTW87LA082Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Midland, TXWhile penetrating a line of thunderstorms at 35,000 en route to Midland, TX, from dallas, TX, severe turbulence was encountered. One flight attendant had just sat down but had not fastened his seat belt and was thrown to the floor sustaining serious injuries.