# NTSB investigations: Cessna 401A: Airframe/component/system failure/malfunction

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 CHI96FA171](https://openairdocs.org/ntsb/CHI96FA171.md): Cessna 401 · Great Bend, KS · Accident · No injuries · Field investigation · Final report · May 20, 1996 · N701CJ · Substantial damage
  > the failure of the exhaust header. Additional factors include the visual restrictions which prevented a detailed examination of the exhaust system, and the inadequate inspection procedures required in AD 75-23-08 R5.
- [NTSB ATL88LA031](https://openairdocs.org/ntsb/ATL88LA031.md): Cessna 401A · Mobile, AL · Accident · No injuries · Limited investigation · Final report · Nov 6, 1987 · N6250Q · Substantial damage
  > The plt related that he was climbing through 4,300 ft when he lost the left turbocharger. He then noted sparks and then fire from the engine. He shut off the fuel, waited for the fire to go out and feathered the propeller. The flt was continued to montgomery,…
- [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…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590D')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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