# NTSB investigations: Turbomeca ARRIEL-1SER, NJ

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 ERA09MA447](https://openairdocs.org/ntsb/ERA09MA447.md): Piper PA-32R-300 · Hoboken, NJ · Accident · 9 fatal · Class 1 · Major · Final report · Aug 8, 2009 · N71MC · 2 aircraft · Substantial damage
  > (1) the inherent limitations of the see-and-avoid concept, which made it difficult for the airplane pilot to see the helicopter until the final seconds before the collision, and (2) the Teterboro Airport local controller’s nonpertinent telephone conversation,…
- [NTSB MIA08CA072](https://openairdocs.org/ntsb/MIA08CA072.md): Eurocopter France AS350B1 · Linden, NJ · Accident · No injuries · Data collection · Final report · Mar 4, 2008 · N152TA · Substantial damage
  > The pilot's improper preflight preparation and his failure to maintain control of the helicopter.

## 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" = 'NJ' 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 ('60030'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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