# NTSB investigations: Cessna 195A, 1998

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 SEA98LA058](https://openairdocs.org/ntsb/SEA98LA058.md): Cessna 195A · Bend, OR · Accident · No injuries · Limited investigation · Final report · Apr 1, 1998 · N1069D · Substantial damage
  > Separation by fracture of the left main gear leg, as the result of fatigue cracks that initiated in corrosion pits on the gear leg surface.
- [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…

## 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 year(c."eventDate") = 1998
  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&year=1998

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