# NTSB investigations: Rolls-Royce 250-C47B, 2022

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CEN23FA071](https://openairdocs.org/ntsb/CEN23FA071.md): Bell 407 · Galliano, LA · Accident · 4 fatal · Class 3 · Field · Final report · Dec 29, 2022 · N595RL · Substantial damage
  > The pilot’s failure to ensure the helicopter was clear of obstacles before takeoff from the helideck, which resulted in the helicopter’s right landing skid pivoting about a helideck perimeter light during takeoff and a dynamic rollover. Additionally, the…
- [NTSB CEN23LA053](https://openairdocs.org/ntsb/CEN23LA053.md): Bell 407 · Searcy, AR · Accident · No injuries · Class 4 · Limited · Final report · Nov 19, 2022 · N184SF · Substantial damage
  > The pilot’s failure to maintain clearance from the electrical box while repositioning.
- [NTSB ERA22FA257](https://openairdocs.org/ntsb/ERA22FA257.md): Bell Helicopter Textron Canada 407 · Fairfield, NJ · Accident · Serious injuries · Class 3 · Field · Final report · Jun 4, 2022 · N98ZA · Substantial damage
  > The failure of maintenance personnel to properly secure the tail rotor crosshead drive plate and the failure of maintenance personnel, the maintenance pilot, and the accident pilot to detect the error, which led to the helicopter’s loss of tail rotor…
- [NTSB WPR22LA174](https://openairdocs.org/ntsb/WPR22LA174.md): Bell Helicopter Textron Canada 407 · Livermore, CA · Accident · Serious injuries · Class 3 · Limited · Final report · May 11, 2022 · N999GH · Substantial damage
  > Loss of engine power due to the pilot inadvertently selecting engine IDLE mode while in flight, which reduced rotor and engine speed to a level that could not sustain flight.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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") = 2022
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('54585'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=54585&year=2022

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.