NTSB investigations: Rolls-Royce RB-211 series
15 cases on aircraft whose registry engine model is Rolls-Royce RB-211 series, where the defining event was Turbulence encounter. 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
| 2011 | 1 |
|---|---|
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 2 |
| 2024 | 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 ('54555')
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\" = '360'))
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 ('54555')
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" = '360'))
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 DCA25LA047Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Brasilia, BrazilThe airplane’s encounter with unanticipated turbulence during cruise flight, which resulted in serious injury to one passenger who was not seated.NTSB DCA23LA252Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Atlantic Ocean (Atlantic Ocean)An encounter with inadvertent convective turbulence during cruise flight.NTSB DCA23LA477Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757 · Lake Butler, FLAn inadvertent encounter with convectively induced turbulence.NTSB DCA21LA095Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Fort Worth, TXan encounter with clear air turbulence during approachNTSB DCA21LA018Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777 · Anchorage, AKThe airplane’s encounter with severe turbulence while flying over a mountain range during cruise.NTSB DCA19CA088Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 777 · Honolulu, HIthe airplanes encounter with clear air turbulence.NTSB DCA18CA201Accident · Serious injuriesData collectionFinal reportBoeing 777 223 · Decatur, TXthe passengers failure to comply with the fasten seatbelt sign when the airplane encountered convective turbulence.NTSB DCA18WA027Accident · Serious injuriesForeign investigationBoeing 757 224 · Bogota, ColombiaThe Colombia Civil Aviation Authority (CAA) has notified the NTSB of an accident involving a Boeing 757, which occurred on November 28, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State…NTSB DCA16CA050Accident · Serious injuriesData collectionFinal reportBoeing 777 223 · Buenos Aires, Argentinaan inadvertant encounter with convective turbulence.NTSB DCA15WA041Accident · Serious injuriesForeign investigationBoeing 777 223 · Ishikawa, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 777-200 that occurred on December 16, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO…NTSB DCA15WA002Accident · Serious injuriesForeign investigationBoeing 777 223 · Buenos Aires, ArgentinaNTSB DCA14WA084Incident · Minor injuriesForeign investigationBoeing 757-200 · Dublin, IrelandThe Air Accident Investigation Unit (AAIU) of Ireland, has notified the NTSB of an incident involving a Boeing 757-200 that occurred on October 20, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…NTSB DCA13CA128Accident · Serious injuriesData collectionFinal reportBoeing 777-232 · Atlanta, GAUnexpected encounter with convective turbulence while the flight attendants were preparing the cabin for arrival.NTSB DCA12CA086Accident · Serious injuriesData collectionFinal reportBoeing 757 2B7 · Philadelphia, PAan inadvertent encounter with convective turbulence.NTSB WPR11LA203Accident · Serious injuriesLimited investigationFinal reportBoeing 777-223 · Pacific OceanAn inadvertent encounter with convective-induced turbulence upon entering cumulonimbus clouds.