NTSB investigations: Rolls-Royce 250-C20B
73 cases on aircraft whose registry engine model is Rolls-Royce 250-C20B. 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 ('54385'))
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 ('54385'))
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 CEN12LA282Accident · No injuriesLimited investigationFinal reportBell 206B-III · Flora, INThe pilot allowed the helicopter to settle with power.NTSB WPR12CA183Accident · No injuriesData collectionFinal reportBell 206B · Arvin, CAThe pilot did not maintain clearance from power lines during low altitude maneuvering.NTSB ERA12LA260Accident · Minor injuriesLimited investigationFinal reportHughes 369D · McCormick, SCThe pilot's decision to use automotive fuel instead of the approved alternate fuel, which resulted in a total loss of engine power.NTSB ERA12CA119Accident · No injuriesData collectionFinal reportHughes 369D · Fall Branch, TNThe pilot's improper decision to continue a visual flight into instrument meteorological conditions, which resulted in a wire strike.NTSB CEN11GA218Accident · Minor injuriesFinal reportHughes 369D · Meeker, COMain rotor contact with the tail boom resulting in tail boom separation.NTSB WPR11LA048Accident · Serious injuriesLimited investigationFinal reportMD Helicopter 369D · Salem, ORThe pilot’s failure to maintain clearance between the longline and trees, which resulted in the longline snagging a tree and then recoiling into the main rotor blades and a subsequent loss of helicopter control.NTSB CEN10CA428Accident · No injuriesData collectionFinal reportBell 206B · New Hampton, IAThe pilot's failure to maintain clearance from wires.NTSB ERA10CA367Accident · No injuriesData collectionFinal reportBell 206 · Roseville, PAThe pilot's failure to maintain clearance from a known wire hazard.NTSB CEN10CA246Accident · No injuriesData collectionFinal reportCarlesimo Glasair III T · Lynwood, ILA loss of engine power due to fuel starvation as a result of the pilot's failure to follow the pre-landing checklist and verifying the position of the fuel selector.NTSB ERA10LA053Accident · No injuriesLimited investigationFinal reportHughes 369 · Baxley, GAA loss of engine power due to fuel starvation resulting from the pilot’s inadequate preflight inspection of the main fuel valve position.NTSB WPR09LA010Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cougar, WAThe pilot's failure to maintain clearance between his external load and trees while maneuvering. Contributing to the accident were hilly terrain and trees.NTSB SEA07LA147Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Troy, ORThe inadvertent entanglement of the crewmemeber's helmet's communication cord with the structure of the helicopter during the helicopter's ascent, which resulted in the crewmember being elevated above ground level before the helmet's cord separated, resulting…NTSB SEA07LA135Accident · 1 fatalLimited investigationFinal reportHughes 369D · Columbus, MTThe fatigue failure of a turbine blade due to a localized over-temperature of the turbine section as result of a non-uniform fuel distribution by the fuel nozzle. Contributing to the accident was the close proximity of a power line support structure which…NTSB DFW05LA066Accident · No injuriesLimited investigationFinal reportBell 206B · Pinehurst, TXThe flight instructor's delay in taking remedial action, which resulted in a hard landing.NTSB SEA03TA116Accident · Minor injuriesFinal reportMcDonnell Douglas 369E · Big Timber, MTFretting on the outside diameter of the compressor coupling adapter which resulted in fatigue and subsequent fracture of the adapter, and ultimately the disconnection of the compressor from the turbine assembly. Contributing factors were low rotor RPM, uneven…NTSB DEN03LA097Accident · No injuriesLimited investigationFinal reportBell 206B III · Broomfield, COthe student pilot's failure to maintain aircraft control and the instructor's inadequate supervision.NTSB SEA02TA067Accident · No injuriesFinal reportHughes 369D · Richland, WAFailure of the netting material securing a net weight while maneuvering. The net weight was a factor.NTSB LAX01LA079Accident · No injuriesLimited investigationFinal reportHughes 369D · Ely, NVThe mechanic's inadvertent activation of the bleed valve, which resulted in a loss of engine oil and loss of engine power while in cruise flight.NTSB SEA90FA079Accident · No injuriesField investigationFinal reportBell 206B-3 · Coeur D'Alene, IDFailure of the pilot-in-command (PIC) to maintain rotor RPM, and a delay by the FAA inspector (flight examiner) in taking remedical action.NTSB LAX84LA117Accident · Serious injuriesLimited investigationFinal reportBell 206B III · Mountain City, NVThe helicopter collided with the snow covered ground after the eng quit during a power-line patrol at about 30 ft AGL. The plt reported that the visibility was 1/2 mile with light snow falling. He also said he could see 4 to 7 of the supporting structures.…NTSB DEN81FA035Accident · 1 fatalClosedBell 206B · Evanston, WYNTSB OAK73DXQ36Accident · Minor injuriesClosedBell 47G3B1 · Belden, CANTSB OAK70A0008Accident · Serious injuriesClosedBell 47G-3B · Willow Crek, CA