# NTSB investigations: Cessna 140A, 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 CEN20LA291](https://openairdocs.org/ntsb/CEN20LA291.md): Cessna 140 · Arlington, TX · Accident · No injuries · Class 3 · Limited · Final report · Jul 18, 2020 · N140AB · Substantial damage
  > The pilot's failure to maintain directional control during a forced landing with a quartering tailwind, following a partial loss of engine power due to carburetor icing.
- [NTSB FTW98FA291](https://openairdocs.org/ntsb/FTW98FA291.md): Cessna 140A · Edgewood, TX · Accident · 1 fatal · Field investigation · Final report · Jul 1, 1998 · N9689A · Substantial damage
  > The pilot's failure to maintain minimum required airspeed for flight. Factors were the worn fuel line, which separated, and the failure of the maintenance personnel to locate the worn fuel line during the annual inspection.
- [NTSB FTW98LA105](https://openairdocs.org/ntsb/FTW98LA105.md): Cessna 140A · Justin, TX · Accident · No injuries · Limited investigation · Final report · Jan 24, 1998 · N377V · Substantial damage
  > the pilot's improper planning/decision and failure to ensure that the airplane would be able to remain clear of the fence during takeoff. Factors relating to the accident were: the wet/soft/short runway (and terrain) conditions.
- [NTSB FTW89LA164](https://openairdocs.org/ntsb/FTW89LA164.md): Cessna 140A · Austin, TX · Accident · No injuries · Limited investigation · Final report · Sep 11, 1989 · N9687A · Substantial damage
  > The pilot's failure to maintain directional control of the aidrcraft. The gusty crosswind condition was a related factor.
- [NTSB FTW77DPD20](https://openairdocs.org/ntsb/FTW77DPD20.md): Cessna 140A · Crowell, TX · Accident · No injuries · Closed · Mar 12, 1977 · N5350C · Substantial damage
- [NTSB FTW75FRG36](https://openairdocs.org/ntsb/FTW75FRG36.md): Cessna 140A · Port Lavaca, TX · Accident · No injuries · Closed · Nov 10, 1974 · N9650A · Substantial damage
- [NTSB FTW74FPA23](https://openairdocs.org/ntsb/FTW74FPA23.md): Cessna 140A · Sherman, TX · Accident · No injuries · Closed · May 4, 1974 · N5350C · Destroyed
- [NTSB FTW72DPD24](https://openairdocs.org/ntsb/FTW72DPD24.md): Cessna 140A · Meridian, TX · Accident · No injuries · Closed · Dec 7, 1971 · N1156D · Substantial damage
- [NTSB FTW71FRA26](https://openairdocs.org/ntsb/FTW71FRA26.md): Cessna 140A · Port Oconner, TX · Accident · No injuries · Closed · Nov 7, 1970 · N9650A · Substantial damage
- [NTSB FTW67D0601](https://openairdocs.org/ntsb/FTW67D0601.md): Cessna 140A · Dalhart, TX · Accident · No injuries · Closed · Apr 26, 1967 · N5630C · Substantial damage
- [NTSB FTW67D0421](https://openairdocs.org/ntsb/FTW67D0421.md): Cessna 140A · Midland, TX · Accident · Minor injuries · Closed · Jan 20, 1967 · N81H · Substantial damage
- [NTSB FTW66D0269](https://openairdocs.org/ntsb/FTW66D0269.md): Cessna 140 · Corsicana, TX · Accident · No injuries · Closed · Aug 24, 1965 · N9493A · Substantial damage
- [NTSB FTW66F0101](https://openairdocs.org/ntsb/FTW66F0101.md): Cessna 140A · Conroe, TX · Accident · No injuries · Closed · Jun 16, 1965 · N5646C · Substantial damage
- [NTSB UNK64X2237](https://openairdocs.org/ntsb/UNK64X2237.md): Cessna 140A · Fort Worth, TX · Accident · 1 fatal · Closed · Jun 11, 1964 · N9490A · Destroyed

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

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