NTSB investigations: Rolls-Royce RB-211 series, 2018
5 cases on aircraft whose registry engine model is Rolls-Royce RB-211 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
| 1978 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 4 |
| 1999 | 3 |
| 2000 | 7 |
| 2001 | 2 |
| 2003 | 3 |
| 2004 | 1 |
| 2005 | 4 |
| 2006 | 3 |
| 2007 | 4 |
| 2008 | 4 |
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 5 |
| 2014 | 4 |
| 2015 | 3 |
| 2017 | 3 |
| 2018 | 5 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 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\") = 2018
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('54555'))
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") = 2018
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('54555'))
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 DCA19CA066Accident · No injuriesData collectionFinal reportBoeing 757 · Charlotte, NCan inadvertent loss of airspeed and increased pitch attitude prior to touchdown.NTSB DCA19RA025Accident · No injuriesForeign investigationBoeing 757 · Georgetown, GuyanaThe Guyana Civil Aviation Authority (GCAA) has notified the NTSB of an accident involving a Boeing 757, which occurred on November 9, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA investigation under the provisions of ICAO…NTSB DCA18CA299Accident · Serious injuriesData collectionFinal reportBoeing 757 · Newark, NJthe catering cart striking the flight attendant's foot.NTSB DCA18CA266Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 757 · Philadelphia, PAThe captain's improper control of the airplane during the landing flare.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.