# NTSB investigations, TN: Abrupt maneuver

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 ATL88FA123](https://openairdocs.org/ntsb/ATL88FA123.md): Beech C23 · Sevierville, TN · Accident · 4 fatal · Field investigation · Final report · Mar 22, 1988 · N9272S · Substantial damage
  > The aircraft was not certified for acrobatic flight. According to several witnesses the pilot was practicing acrobatics with three passengers on board. The pilot lost control of the aircraft and did not recover.
- [NTSB ATL86LA095](https://openairdocs.org/ntsb/ATL86LA095.md): Cessna 150 · Lafayette, TN · Accident · No injuries · Limited investigation · Final report · Mar 17, 1986 · N2618J · Substantial damage
  > The pilot stated that he had completed a touchdown and was on rollout when he noticed a deer on the runway. He increased the power enough to avoid colliding with the deer, but stalled the aircraft and collided with the runway surface failing the nose gear.…
- [NTSB ATL85LA205](https://openairdocs.org/ntsb/ATL85LA205.md): McCulloch J-2 · Union City, TN · Accident · No injuries · Limited investigation · Final report · Apr 21, 1985 · N4374G · Substantial damage
  > Pilot with 7900 total hours and four hours in gyoplane was on solo cross country training flight. During takeoff at enroute stop rotor blades struck vertical stabilizer. Pilots instructor said witnesses reported that the gyroplane was rotated abruptly during…

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

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