# NTSB investigations: Aerospatiale/Aeritalia ATR 42-320

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 CEN09MA142](https://openairdocs.org/ntsb/CEN09MA142.md): Aerospatiale Alenia ATR 42-320 · Lubbock, TX · Accident · Serious injuries · Class 1 · Major · Final report · Jan 27, 2009 · N902FX · Substantial damage
  > The flight crew's failure to monitor and maintain a minimum safe airspeed while executing an instrument approach in icing conditions, which resulted in an aerodynamic stall at low altitude. Contributing to the accident were 1) the flight crew's failure to…
- [NTSB NYC02LA008](https://openairdocs.org/ntsb/NYC02LA008.md): Aerospatiale ATR 42-320 · Yardley, PA · Accident · No injuries · Limited investigation · Final report · Oct 13, 2001 · N34820 · Substantial damage
  > an in flight collision with birds.
- [NTSB FTW97LA081](https://openairdocs.org/ntsb/FTW97LA081.md): Aerospatiale ATR-42-320 · Houston, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 8, 1997 · N14829 · Substantial damage
  > The pilot's failure to follow the proper taxi route while taxiing back to the terminal. A factor was the glare radiating from the airport's terminal area.
- [NTSB NYC92LA005](https://openairdocs.org/ntsb/NYC92LA005.md): Aerospatiale ATR-42-320 · Bridgeport, CT · Accident · 1 fatal · Limited investigation · Final report · Oct 12, 1991 · N25811 · Minor damage
  > The employee's failure to follow proper procedures and the diversion of her attention which resulted in her being struck by a spinning propeller.
- [NTSB ATL89MA012](https://openairdocs.org/ntsb/ATL89MA012.md): Aerospatiale ATR-42-300 · Yardley, PA · Incident · No injuries · Major investigation · Final report · Oct 12, 1988 · N17810 · 2 aircraft · No damage
  > Bfr tkof, corrected flt plan was put in ATC computer for airforce 1 (AF1) to take nonstandard rte to newark. After tkof,AF1 was vctrd nw with handoff to NY ARTCC (zny), then east via Yardley (ard) to newark; 15 mi west of ard, zny initiatedhandoff to NY…

## 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.aircraft_model_code IN ('8680930'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=8680930

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