# NTSB investigations, TN: Near collision between aircraft

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 OPS08IA001](https://openairdocs.org/ntsb/OPS08IA001.md): Cessna C 525 · Memphis, TN · Incident · No injuries · Incident investigation · Final report · Oct 12, 2007 · N241EP · No damage
  > The probable cause of this incident was the pilot's inadvertent departure from a taxiway instead of a runway.
- [NTSB ATL91LA135](https://openairdocs.org/ntsb/ATL91LA135.md): Piper PA-24-260 · Springfield, TN · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 1991 · N8739P · Substantial damage
  > The PA-24 pilot's failure to maintain proper airspeed while executing a go-around, resulting in the stalling of the airplane. A factor in the accident was the PA-24 pilot's failure to visually detect the J-3 in a timely manner.
- [NTSB ATL87IA179](https://openairdocs.org/ntsb/ATL87IA179.md): Boeing 727-232 · Nashville, TN · Incident · No injuries · Incident investigation · Final report · Jun 19, 1987 · N482DA · 2 aircraft · No damage
  > At aprx 2211 CDT, delta flt 314 (Boeing 727, N482DA) was clrd to taxi to rwy 31 with info india. Info india indcd rwy 31WAS active. Soon thereafter, southwest flt 715 (Boeing 737, N50SW) reqd & recd taxi clnc to rwy 13 for tkof. To accommo-date incoming…
- [NTSB ATL87IA020](https://openairdocs.org/ntsb/ATL87IA020.md): Boeing 727-227 · Livingston, TN · Incident · No injuries · Incident investigation · Final report · Nov 12, 1986 · N471BN · 2 aircraft · No damage
  > The braniff and united Boeing 727 jetliners were approaching 'swapp' intersection on converging jetways at their proper assigned alt of 35,000'. The controller was in the process of issuing radar vectors to assure proper lateral separation when the control…
- [NTSB ATL86IA100](https://openairdocs.org/ntsb/ATL86IA100.md): Boeing 737-200 · Nasville, TN · Incident · No injuries · Incident investigation · Final report · Mar 21, 1986 · N774N · 2 aircraft · No damage
  > A nr midair collision occurred aprx 38 mi se of the nashville metro arpt as a Boeing 737, piedmont flt 488, was dscndg thru aprx 12,000' & a flt of 4 F-4'S, call sign peach 41, were joining. Flt 488 was inbnd to nashville on an IFR clnc & memphis ARTCC had…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 280)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=280&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.