# NTSB investigations: Rolls-Royce 250-C47B: Loss of control in flight

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 ERA24FA003](https://openairdocs.org/ntsb/ERA24FA003.md): Bell Helicopter Textron Canada 407 · Croydon, NH · Accident · 1 fatal · Class 3 · Field · Final report · Oct 8, 2023 · N802JR · Substantial damage
  > The pilot’s loss of control during the initial climb in dark night conditions due to spatial disorientation, which resulted in a steep banking descent into trees and terrain. Contributing to the accident was the pilot’s lack of recent night flight experience,…
- [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 CEN13FA122](https://openairdocs.org/ntsb/CEN13FA122.md): Bell Helicopter 407 · Clear Lake, IA · Accident · 3 fatal · Field investigation · Final report · Jan 3, 2013 · N445MT · Destroyed
  > The pilot’s inadvertent encounter with localized icing conditions and his subsequent in-flight loss of helicopter control.
- [NTSB WPR12GA106](https://openairdocs.org/ntsb/WPR12GA106.md): Bell 407 · Moran Junction, WY · Accident · 1 fatal · Final report · Feb 15, 2012 · N407HL · Substantial damage
  > The pilot’s failure to maintain yaw control while hovering at high density altitude, which resulted in a loss of tail rotor effectiveness.
- [NTSB CEN09CA604](https://openairdocs.org/ntsb/CEN09CA604.md): Bell 407 · Fort Worth, TX · Accident · No injuries · Data collection · Final report · Sep 23, 2009 · N6040Y · Substantial damage
  > Failure of the pilot to maintain control during landing.

## 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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('54585')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '240'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/240/cases?engine=54585

---
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.