Final NTSB investigations: Rolls-Royce RB-211 series
64 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.\"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 ('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."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 ('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 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 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 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