# NTSB investigations: Cessna 195, 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 CEN13LA170](https://openairdocs.org/ntsb/CEN13LA170.md): Cessna 195 · Austin, TX · Accident · No injuries · Limited investigation · Final report · Feb 17, 2013 · N4426C · Substantial damage
  > The pilot's use of an excessive taxi speed, which resulted in the airplane overrunning the end of the unlit taxiway after the failure of the right wing landing light.
- [NTSB CEN09CA246](https://openairdocs.org/ntsb/CEN09CA246.md): Cessna 195 · Burnet, TX · Accident · No injuries · Data collection · Final report · Apr 9, 2009 · N4495C · Substantial damage
  > The pilot's inadequate compensation for the gusting crosswinds during landing.
- [NTSB DEN08LA112](https://openairdocs.org/ntsb/DEN08LA112.md): Cessna 195 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jun 23, 2008 · N4426C · Substantial damage
  > The pilot's failure to maintain directional control, causing the design stress limits of the airplane to be exceeded. Excessive sideloads incurred caused the right main landing gear wheel and strut to fail.
- [NTSB FTW90LA011](https://openairdocs.org/ntsb/FTW90LA011.md): Cessna 195 · San Antonio, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 1989 · N3893V · Substantial damage
  > Pilot's improper recovery from a bounced landing and subsequent stall of the aircraft.
- [NTSB FTW77FRG35](https://openairdocs.org/ntsb/FTW77FRG35.md): Cessna 195 · Port O'Connor, TX · Accident · No injuries · Closed · Apr 6, 1977 · N9308A · Destroyed
- [NTSB FTW71FRH30](https://openairdocs.org/ntsb/FTW71FRH30.md): Cessna 195A · San Antonio, TX · Accident · No injuries · Closed · May 30, 1971 · N1544D · Substantial damage
- [NTSB FTW70F0245](https://openairdocs.org/ntsb/FTW70F0245.md): Cessna 195 · Panola, TX · Accident · No injuries · Closed · Sep 14, 1969 · N1025D · Substantial damage
- [NTSB FTW70D0162](https://openairdocs.org/ntsb/FTW70D0162.md): Cessna 195 · San Antonio, TX · Accident · No injuries · Closed · Jul 6, 1969 · N9301A · Substantial damage
- [NTSB FTW68F0470](https://openairdocs.org/ntsb/FTW68F0470.md): Cessna 195 · Dallas, TX · Accident · No injuries · Closed · Feb 24, 1968 · N4346N · Substantial damage
- [NTSB FTW67D0271](https://openairdocs.org/ntsb/FTW67D0271.md): Cessna 195 · Port Isabel, TX · Accident · No injuries · Closed · Sep 14, 1966 · N2115C · Substantial damage
- [NTSB FTW67F0098](https://openairdocs.org/ntsb/FTW67F0098.md): Cessna 195 · Odessa, TX · Accident · No injuries · Closed · Jul 16, 1966 · N272CG · Substantial damage
- [NTSB FTW66F0356](https://openairdocs.org/ntsb/FTW66F0356.md): Cessna 195 · Odessa, TX · Accident · No injuries · Closed · Oct 19, 1965 · N9371A · Substantial damage
- [NTSB UNK65X0471](https://openairdocs.org/ntsb/UNK65X0471.md): Cessna 195 · Del Rio, TX · Accident · No injuries · Closed · Oct 29, 1964 · N272CG · Substantial damage
- [NTSB UNK64X3723](https://openairdocs.org/ntsb/UNK64X3723.md): Cessna 195 · Austin, TX · Accident · No injuries · Closed · Sep 1, 1964 · N9898A · Substantial damage
- [NTSB UNK64X2605](https://openairdocs.org/ntsb/UNK64X2605.md): Cessna 195 · Ft Worth, TX · Accident · No injuries · Closed · Jul 2, 1964 · N72C · 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 ('2073102'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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