# NTSB investigations: Cessna 402, 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 FTW94FA282](https://openairdocs.org/ntsb/FTW94FA282.md): Cessna 402 · Harlingen, TX · Accident · Minor injuries · Field investigation · Final report · Aug 28, 1994 · N966JW · Substantial damage
  > The pilot's failure to maintain airspeed resulting in an inadvertent stall. Factors were a partial loss of power on all engines due to worn and fouled spark plugs and inadequate maintenance by company maintenance personnel, aircraft weight beyond limitations,…
- [NTSB FTW84FA372](https://openairdocs.org/ntsb/FTW84FA372.md): Cessna 402 · Dfw Airport, TX · Accident · No injuries · Field investigation · Final report · Aug 17, 1984 · N19DA · Substantial damage
  > According to the plt, a rwy change accepted late in the apch required a steep turn and rapid descent. At aprx 400 ft AGL both throttles were advanced but neither eng responsed. The acft landed in unimproived terrain short of the rwy collapsing the left main…
- [NTSB FTW79FPA25](https://openairdocs.org/ntsb/FTW79FPA25.md): Cessna 402 · Dallas, TX · Accident · No injuries · Closed · Aug 14, 1979 · N8138F · Substantial damage
- [NTSB FTW68D0341](https://openairdocs.org/ntsb/FTW68D0341.md): Cessna 402 · Longview, TX · Accident · No injuries · Closed · Oct 11, 1967 · N3254Q · 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 ('207590K'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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