Final NTSB investigations: Rolls-Royce 250-C20J
12 cases on aircraft whose registry engine model is Rolls-Royce 250-C20J. 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
| 1996 | 1 |
|---|---|
| 2007 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
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.\"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 ('54181'))
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 ('54181'))
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 CEN24LA275Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Cuba City, WIThe pilot’s failure to maintain clearance from a wire during an agricultural application pass.NTSB CEN24LA172Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Baton Rouge, LAThe pilot’s loss of control during takeoff that resulted in a hard landing.NTSB WPR24LA067Accident · No injuriesClass 3 · LimitedFinal reportBell 206B · El Centro, CAAn in-flight failure of the engine-to-transmission driveshaft due to a fatigue fracture of the forward-most flex plate in the forward KAflex coupling that resulted from a loose bolt attachment between the flex plate and the forward driveshaft coupling.…NTSB ERA22FA383Accident · 2 fatalClass 3 · FieldFinal reportBell 206B · Whiteside, TNThe pilot’s failure to maintain clearance from the powerlines.NTSB CEN19LA318Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Hill City, SDA total loss of engine power for undetermined reasons, which resulted in a hard landing.NTSB CEN19LA269Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Blair, NEThe loss of main rotor rpm for reasons that could not be determined based on the available evidence, which resulted in a hard landing.NTSB CEN19FA024Accident · 3 fatalField investigationFinal reportBell 206 · Uvalde, TXThe pilot's controlled flight into terrain during night visual meteorological conditions. Contributing to the accident was the pilot improper decision to inhibit the helicopter's terrain warning systems and flight at low altitude.NTSB ERA12LA210Accident · Minor injuriesLimited investigationFinal reportBell 206B · Titusville, FLThe flight instructor's attempted takeoff in gusting wind conditions while the student pilot was adjusting her anti-torque pedals, which resulted in a dynamic rollover event.NTSB WPR11CA101Accident · No injuriesData collectionFinal reportBell 206B3 · Three Forks, MTThe pilot’s inadequate use of throttle during the practice autorotation that resulted in a hard landing.NTSB ERA10TA292Accident · No injuriesFinal reportBell 206B · Memphis, TNThe pilot’s failure to maintain adequate rotor rpm and the certificated flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB CHI07CA181Accident · No injuriesData collectionFinal reportBell 206B · Grand Forks, NDThe certified flight instructor's inadequate compensation for the gusting wind conditions and failure to maintain control of the helicopter during a hover for takeoff. A factor contributing to the accident was the gusting wind conditions.NTSB IAD96LA067Accident · No injuriesLimited investigationFinal reportBell 206B · Logan, WVthe pilot's failure to maintain an adequate fuel supply for the flight which resulted in a loss of engine power due to fuel exhaustion, and the loss of rotor rpm during the autorotation. The downhill sloping terrain was a related factor.