# NTSB investigations: Cessna L-19E, TX

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 CEN23LA011](https://openairdocs.org/ntsb/CEN23LA011.md): Cessna L-19E · Navasota, TX · Accident · No injuries · Class 4 · Limited · Final report · Oct 5, 2022 · N9019V · Substantial damage
  > The pilot’s loss of control while landing resulting in a runway excursion and ground loop.
- [NTSB CEN12CA614](https://openairdocs.org/ntsb/CEN12CA614.md): Cessna L-19E · Lancaster, TX · Accident · No injuries · Data collection · Final report · Sep 1, 2012 · N4431F · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.
- [NTSB FTW88DRA11](https://openairdocs.org/ntsb/FTW88DRA11.md): Cessna L-19E · Conroe, TX · Accident · 1 fatal · Final report · Apr 30, 1988 · N3946L · Destroyed
  > The airplane was observed by witnesses making a chandelle-like maneuver from takeoff. At the top, the nose and right wing dropped for approximately 180 degrees of turn. The wings were almost level when the airplane hit the runway. The airplane burned after…
- [NTSB FTW86FA049](https://openairdocs.org/ntsb/FTW86FA049.md): Spencer Pitts S-1 · Mckinney, TX · Accident · Serious injuries · Field investigation · Final report · Mar 28, 1986 · N66D · 2 aircraft · Substantial damage
  > As a pitts special, N66D, was in the traffic pattern to lnd, a Cessna L-19E towplane, N4431B, was on the 1300' grass overrun near the apch end of the rwy with a glider being readied for tow. The glider (sailplane) was a grob 103, N226BG.the plt of the pitts…
- [NTSB FTW85LA340](https://openairdocs.org/ntsb/FTW85LA340.md): Cessna L-19E · Palo Pinto, TX · Accident · 1 fatal · Limited investigation · Final report · Aug 30, 1985 · N3255X · Destroyed
  > The acft was reported by witnesses to have been flying very low over a lake just prior to accident. The acft collided with pwr lines after passing over a dam and was destroyed on ground impact. The plt reported a loss pwr was experienced. The eng was test run…
- [NTSB FTW85LA150](https://openairdocs.org/ntsb/FTW85LA150.md): Cessna 305E · Mckinney, TX · Accident · No injuries · Limited investigation · Final report · Mar 15, 1985 · N3946K · Substantial damage
  > The engine quit shortly after takeoff. The pilot landed in soft terrain (muddy field) and the aircraft nosed over. The pilot reported finding 1/2 cup of water in the fuel tank and gascolator.

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

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

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