# NTSB investigations: Cessna 195A, AZ

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 LAX98LA069](https://openairdocs.org/ntsb/LAX98LA069.md): Cessna 195A · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Jan 12, 1998 · N1073D · Substantial damage
  > The student's inadequate compensation for the wind conditions and his failure to maintain directional control. Factors in this accident were the inadequate supervision of the flight by the flight instructor, and the student's failure to relinquish the…
- [NTSB LAX78FA060](https://openairdocs.org/ntsb/LAX78FA060.md): Cessna 195 · Grand Canyon, AZ · Accident · 2 fatal · Closed · Jul 4, 1978 · N9809A · Destroyed
- [NTSB LAX76DUJ07](https://openairdocs.org/ntsb/LAX76DUJ07.md): Cessna 195 · Tucson, AZ · Accident · No injuries · Closed · Jul 12, 1975 · N1090D · 2 aircraft · Minor damage
- [NTSB LAX67F0175](https://openairdocs.org/ntsb/LAX67F0175.md): Cessna 195 · Nogales, AZ · Accident · No injuries · Closed · Oct 20, 1966 · N1527D · 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" = 'AZ' 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 ('2073110'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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