# NTSB investigations: Cessna 401A, CA

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 LAX95LA232](https://openairdocs.org/ntsb/LAX95LA232.md): Cessna 401A · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Jul 1, 1995 · N444RJ · Substantial damage
  > the failure of the wing rib web due to undetected cracking in an area of known crack development around the landing gear side brace fitting. The operator's failure to accomplish a Service Letter addressing the problem is a factor in the accident.
- [NTSB LAX84LA161](https://openairdocs.org/ntsb/LAX84LA161.md): Cessna 401A · San Francisco, CA · Accident · No injuries · Limited investigation · Final report · Jan 28, 1984 · N7KF · Substantial damage
  > The acft was landed gear up after attempts to lower the gear were unsuccessful. The system malfunctioned because the nose gear jammed the main gear during retraction. The jamming occurred because the nose strut did not extend due to lackof air pressure. The…
- [NTSB LAX74AL030](https://openairdocs.org/ntsb/LAX74AL030.md): Cessna 401A · Laverne, CA · Accident · 2 fatal · Closed · Oct 31, 1973 · N6273Q · 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" = 'CA' 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 ('207590D'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=207590D&state=CA

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