# NTSB investigations: Rolls-Royce 250-C300/A1, PA

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 ERA21LA171](https://openairdocs.org/ntsb/ERA21LA171.md): Robinson Helicopter R66 · Palmyra, PA · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 3, 2021 · N577DD · Substantial damage
  > The pilot’s improper judgment to attempt a flight while impaired by medications, which resulted in the helicopter’s abnormal ground contact, loss of control, and collision with terrain.
- [NTSB ERA20FA074](https://openairdocs.org/ntsb/ERA20FA074.md): Robinson R66 · Mechanicsburg, PA · Accident · 2 fatal · Class 3 · Field · Final report · Jan 10, 2020 · N450MC · Destroyed
  > A severe left roll excursion after the onset of pitch and roll oscillations, which were not arrested by the pilot for undetermined reasons. This resulted in main rotor blade contact with the airframe and a subsequent inflight breakup of the helicopter.
- [NTSB ERA13FA336](https://openairdocs.org/ntsb/ERA13FA336.md): Robinson R66 · Noxen, PA · Accident · 5 fatal · Field investigation · Final report · Jul 28, 2013 · N646AG · Destroyed
  > The pilot's decision to continue VFR flight into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.

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

This list as a web page: https://openairdocs.org/ntsb?engine=54232&state=PA

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