# Final NTSB investigations: British Aerospace AVRO 146-RJ70A

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 FTW96IA124](https://openairdocs.org/ntsb/FTW96IA124.md): British Aerospace Avro 146-RJ70A · Rifle, CO · Incident · No injuries · Incident investigation · Final report · Feb 21, 1996 · N832BE · No damage
  > The copilot's failure to compensate for wind conditions, resulting in excessive airspeed, and his failure to attain the proper runway touch down point. Factors were inadequate dispatch procedures and the captain's improper inflight planning/decision in that…
- [NTSB NYC95IA178](https://openairdocs.org/ntsb/NYC95IA178.md): British Aerospace RJ-70 · New York, NY · Incident · No injuries · Incident investigation · Final report · Jul 25, 1995 · N833BE · No damage
  > the aileron interconnect became uncoupled, when an abrupt and/or large aileron movement was made in response to a wake turbulence encounter, while on a VOR approach with the autopilot engaged. A factor relating to the incident was: inadequate in-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 c."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1500095'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1500095&status=final

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