NTSB investigations: Rolls-Royce RB-211 series
86 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, newest first
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'))
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'))
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 CHI07LA078Accident · Serious injuriesLimited investigationFinal reportBoeing 777 · Chicago, ILAn in-flight encounter with turbulence during cruise flight.NTSB NYC07IA015Incident · No injuriesIncident investigationFinal reportBoeing 757-224 · Newark, NJThe flight crew's misidentification of the parallel taxiway as the active runway, resulting in the flight crew executing a landing on the taxiway. Contributing was the night lighting conditions.NTSB DCA06WA075Incident · No injuriesForeign investigationBoeing 777-200 · Brindisi, ItalyNTSB DFW06LA115Accident · Serious injuriesLimited investigationFinal reportBoeing 777-233ER · DFW Int'l Apt, TXThe in-flight encounter with turbulence in clouds resulting in a flight attendant being injured.NTSB DCA06WA008Accident · No injuriesForeign investigationBoeing B-777 · Heathrow IAP, United KingdomNTSB CHI05LA135Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · New Chicago, INThe inadvertent encounter with convectively induced turbulence (CIT) while the aircraft was descending into the terminal area.NTSB DCA05WA067Accident · No injuriesForeign investigationBoeing B-777-232 · London, United KingdomNTSB DCA05WA042Accident · Minor injuriesForeign investigationBoeing B777 · Buenos Aires, ArgentinaNTSB DCA04MA061Accident · Serious injuriesMajor investigationFinal reportBoeing 777 · Miami, FLthe in-flight encounter with unforecasted clear air turbulence.NTSB MIA03IA168Incident · No injuriesIncident investigationFinal reportBoeing 757-223 · Miami, FLThe failure of maintenance personnel from the aircraft operator to identify a missing left main landing gear truck beam shield and damage to the left main landing gear truck beam which resulted in the fracture of the truck beam as a result of stress corrosion…NTSB LAX03LA167Accident · No injuriesLimited investigationFinal reportBoeing 757-223 · Santa Ana, CAthe vehicle driver's failure to deploy the parking brake or use wheel chocks to secure the vehicle prior to leaving it unattended.NTSB MIA03LA067Accident · Serious injuriesLimited investigationFinal reportBoeing 777-223 · Miami, FLThe flight crew's inadvertent encounter with turbulence while attempting to maneuver through an area of convective activity during descent.NTSB IAD02LA007Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · Dulles, VAA passenger sustained a broken ankle during an emergency evacuation.NTSB DCA01MA064Accident · 64 fatalMajor investigationFinal reportBoeing 757-200 · Arlington, VAThe Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided…NTSB MIA00LA271Accident · Serious injuriesLimited investigationFinal reportBoeing 777-223 · Miami, FLan in-flight encounter with turbulence.NTSB FTW00LA244Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · Gulf Of Mexicothe flight crew's inadvertent encounter with convective turbulence while in cruise flight. A factor was the rapidly developing convective activity.NTSB CHI00LA268Accident · Serious injuriesLimited investigationFinal reportBoeing 777-223 · Baraboo, WIthe unexpected turbulence encountered by the airplane.NTSB CHI00IA125Incident · No injuriesIncident investigationFinal reportBoeing 777-223ER · Chicago, ILthe flightcrew not detecting the runway closure NOTAM and the Air Traffic Control personnel on the metering, ground, and local positions giving an improper clearance to taxi to a closed runway. Factors were the closed runway, ATIS information not issued by…NTSB FTW00RA126Accident · No injuriesForeign investigationLockheed L-1011-385 · Guayaquil, EcuadorNTSB LAX00LA146Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2G7 · Dallas, TXThe en route cruise encounter with forecast moderate turbulence.NTSB LAX00LA072Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2G7 · Las Vegas, NVEncounter with Clear Air Turbulence. Poor communication between the captain and flight attendants as to the urgency for the flight attendants to take their seats was a contributing factor.NTSB LAX99FA315Accident · Serious injuriesField investigationFinal reportBoeing 757-2S7 · Agua Caliente, AZthe systemic failure of the airline's maintenance department to identify and correct the long standing history of intermittent faults, nuisance warnings, and erratic behavior in this airplane's GPWS system. Also causal is the airline's failure to perform the…NTSB LAX99LA322Accident · No injuriesLimited investigationFinal reportBoeing 757-2G7 · Phoenix, AZThe failure of the flight crew and the tug driver to verify that the aircraft was properly configured for pushback. Factors in the accident were the left wing walker's failure to notify the tug driver of his observations that the jet bridge was still in…NTSB DCA99WA062Incident · No injuriesForeign investigationBoeing 757 · Tegucigalpa, HondurasNTSB LAX97FA276Accident · Serious injuriesField investigationFinal reportLockheed L-1011-385-1-15 · Honolulu, HIthe cumulative distance taxied immediately prior to takeoff that precipitated an excessive heat buildup in the tires and resulted in the bead separation of a single tire during the takeoff roll. The absence of cockpit procedures/directives or monitoring…NTSB MIA97WA226Accident · 1 fatalForeign investigationBoeing 757-200 · Lima, PeruNTSB ATL97LA075Accident · Serious injuriesLimited investigationFinal reportLockheed L-1011-385-3 · Atlantic Ocean (Atlantic Ocean)The failure of the flight attendants to maintain control of loose cabin service equipment, a salt shaker, that resulted in an uncorrected tripping hazard.NTSB FTW97IA112Incident · No injuriesIncident investigationFinal reportBoeing 757-2S7 · Denver, COthe pilot-in-command's failure to comply with company procedures/directives to not taxi the aircraft beneath the bridge/overpass, and his misjudgment of clearance between the vertical stabilizer and the bridge/overpass.NTSB IAD96LA058Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Atlantic Ocean (Atlantic Ocean)the in-flight encounter with unforecast, unexpected turbulence.NTSB FTW95LA167Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · San Antonio, TXThe pilot-in-command's failure to set the parking brake.NTSB LAX94LA333Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Phoenix, AZthe failure of the headset operator to adhere to established company safety procedures when he diverted his attention during pushback. A factor in the accident was the airline's failure to modify its ground handling procedures and equipment to eliminate the…NTSB FTW92LA100Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · Hayden, COFailure of the ground personnel to follow published procedures/directives. A factor was the inadequate equipment.NTSB LAX90LA021Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2S7 · Phoenix, AZThe ground handler improperly crossing under the aircraft while it was moving.NTSB LAX88IA311Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385 · San Francisco, CADuring cruise flight, approximately one hour after departure, the captain complained of possible indigestion. A few hours later, the captain complained of tingling in his fingers and numbness in his shoulder. Another captain was on board and was asked to sit…NTSB ATL87FA240Accident · No injuriesField investigationFinal reportLockheed L-1011-385-1 · Atlanta, GAThe acft was being flown manually for an ILS apch to rwy 8L at Atlanta. The apch was allowed to become unstable at about the middle marker and the vertical speed was increased to about 1290 feet per minute about five seconds before touchdown. The ioe capt in…NTSB MIA78DA096Accident · No injuriesClosedLockheed L-1011 · Atlanta, GA