# NTSB investigations: Boeing 727-223, TN

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 ATL91IA094](https://openairdocs.org/ntsb/ATL91IA094.md): Boeing 727-223 · Nashville, TN · Incident · No injuries · Incident investigation · Final report · May 15, 1991 · N882AA · Minor damage
  > The captain's failure to maintain a proper glide path after disconnection of the autopilot during the final approach. Factors in this accident were: the captain's failure to follow company procedures for category ii approaches, the first officer's failure to…
- [NTSB ATL86LA090](https://openairdocs.org/ntsb/ATL86LA090.md): Boeing 727-223 · Memphis, TN · Accident · Serious injuries · Limited investigation · Final report · Mar 12, 1986 · N877AA · No damage
  > American airlines flight 502 experienced a fire warning light illumination on no. 1 engine as the aircraft was climbing through 6000 feet. The pilot declared an emergency and returned to Memphis. Following the landing the pilot ordered a passenger emergency…
- [NTSB FTW83IA086](https://openairdocs.org/ntsb/FTW83IA086.md): Boeing 727-223 · Memphis, TN · Incident · No injuries · Incident investigation · Final report · Dec 26, 1982 · N6810 · Minor damage
  > During a go-around from an ILS approach, the left wing tip was dragged. This resulted in minor damage to the leading edge slats, trailing edge flaps and outboard flap track housing on the left wing. An uneventful landing was made after the go-around. The…

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

This list as a web page: https://openairdocs.org/ntsb?model=1384074&state=TN

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