# NTSB investigations: Cessna 185, 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 FTW87LA201](https://openairdocs.org/ntsb/FTW87LA201.md): Cessna 185 · San Marcos, TX · Accident · No injuries · Limited investigation · Final report · Aug 16, 1987 · N9930X · Substantial damage
  > The pilot stated that he landed long and downwind on his private strip. In an attempt to stop he applied heavy braking and at the end of the strip the aircraft nosed over and came to rest on a fence.
- [NTSB FTW83LA268](https://openairdocs.org/ntsb/FTW83LA268.md): Cessna 185 · Mcallen, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 6, 1983 · N4016Y · Substantial damage
  > The eng quit during climbout. Inspection revealed that the fuel system contained about 50% clear liquid other than gasoline. The acft had sat with its tanks empty for the past 7-10 days.
- [NTSB FTW80DRA50](https://openairdocs.org/ntsb/FTW80DRA50.md): Cessna 185 · New Caney, TX · Accident · No injuries · Closed · Sep 11, 1980 · N185U · 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" = '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 ('2072802'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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