# NTSB investigations: Aerospatiale/Alenia ATR-72-212

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 DCA04MA045](https://openairdocs.org/ntsb/DCA04MA045.md): ATR 72 · San Juan, PR · Accident · Serious injuries · Class 1 · Major · Final report · May 9, 2004 · N438AT · Destroyed
  > the captain's failure to execute proper techniques to recover from the bounced landings and his subsequent failure to execute a go-around.
- [NTSB ATL03LA051](https://openairdocs.org/ntsb/ATL03LA051.md): Aerospatiale ATR-72-212 · Atlanta, GA · Accident · Serious injuries · Limited investigation · Final report · Mar 1, 2003 · N642AS · No damage
  > The flight's encounter with severe turbulence that resulted in serious injury to a flight attendant.
- [NTSB MIA99LA039](https://openairdocs.org/ntsb/MIA99LA039.md): Aerospatiale ATR-72-212 · Fort Lauderdale, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 1998 · N414WF · No damage
  > an abrupt maneuver in response to a traffic avoidance system alert, resulting in a flight attendant falling and breaking a leg.
- [NTSB FTW97IA222](https://openairdocs.org/ntsb/FTW97IA222.md): Aerospatiale ATR-72-12 · Dallas, TX · Incident · No injuries · Incident investigation · Final report · Jun 14, 1997 · N438AT · Minor damage
  > the engine fire during descent resulting from a loose, leaking fuel transfer tube due to improper installation and alignment of the transfer tube's retaining clip. Contributing factors were the inadequate design of the clamp, the failure of the operator to…
- [NTSB CHI95IA313](https://openairdocs.org/ntsb/CHI95IA313.md): Aerospatiale ATR-72 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Sep 6, 1995 · N414WF · Minor damage
  > improper installation of the #7 and #8 fuel nozzle manifold transfer tubes by company maintenance personnel, and an inadequate exhaust drain fitting gasket, which resulted in fuel leaks at the respective 'O' ring/gasket fittings; blockage of the fuel/oil…

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

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

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