# NTSB investigations: Cessna 150J, 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 ATL91FA025](https://openairdocs.org/ntsb/ATL91FA025.md): Cessna 150J · Ripley, TN · Accident · 1 fatal · Field investigation · Final report · Dec 8, 1990 · N51160 · Destroyed
  > Performing a stall maneuver at an altitude below prescribed minimums, and his failure to apply correct flight control inputs to recover from the stall and spin.
- [NTSB ATL88FA106](https://openairdocs.org/ntsb/ATL88FA106.md): Cessna 150 · Knoxville, TN · Accident · 2 fatal · Field investigation · Final report · Mar 6, 1988 · N60371 · 2 aircraft · Minor damage
  > The Cessna made a long straight in final approach. The aircraft's radio transmitter was inop. Afterward the Cessna PIC rpted that initially he saw the Beech on a left base. Later he stated the Beech was heading away from the traffic pattern. Witnesses…
- [NTSB ATL87LA125](https://openairdocs.org/ntsb/ATL87LA125.md): Cessna 150J · Waverly, TN · Accident · No injuries · Limited investigation · Final report · Apr 20, 1987 · N60696 · Substantial damage
  > The plt reported that he was taxiing to the rwy when the 'rudder failed to turn the (airplane) onto the rwy and the left brake failed.' The airplane subsequently ran off the end of the taxiway, traveled approx. 50 ft., went over a steep dropoff and collided…
- [NTSB IAD79FLT01](https://openairdocs.org/ntsb/IAD79FLT01.md): Cessna 150 · Covington, TN · Accident · No injuries · Closed · Nov 29, 1978 · N5585G · Substantial damage
- [NTSB IAD75AI024](https://openairdocs.org/ntsb/IAD75AI024.md): Cessna 150 · Johnson City, TN · Accident · 1 fatal · Closed · Oct 13, 1974 · N60125 · Destroyed
- [NTSB MIA70FKW03](https://openairdocs.org/ntsb/MIA70FKW03.md): Cessna 150J · College Grve, TN · Accident · Minor injuries · Closed · Apr 3, 1970 · N51409 · Destroyed
- [NTSB MIA70D0270](https://openairdocs.org/ntsb/MIA70D0270.md): Cessna 150 · Spring City, TN · Accident · Minor injuries · Closed · Dec 26, 1969 · N60192 · Destroyed
- [NTSB MIA70D0061](https://openairdocs.org/ntsb/MIA70D0061.md): Cessna 150 · Lobelville, TN · Accident · No injuries · Closed · Jul 14, 1969 · N61200 · Substantial damage

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

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