# NTSB investigations: Cessna 402C: In flight collision with terrain/water

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 SEA97LA125](https://openairdocs.org/ntsb/SEA97LA125.md): Cessna 402C · Rawlins, WY · Accident · Serious injuries · Limited investigation · Final report · Jun 2, 1997 · N1233P · Substantial damage
  > The pilot's failure to maintain clearance from the terrain during the initial climb after a night takeoff. Factors include a dark night and rising terrain off the departure end of the runway.
- [NTSB MIA97FA082](https://openairdocs.org/ntsb/MIA97FA082.md): Cessna 402C · St. Thomas · Accident · 2 fatal · Field investigation · Final report · Feb 8, 1997 · N318AB · Destroyed
  > The failure of the pilot to maintain altitude while making a visual approach at night over water in black hole conditions resulting in the aircraft descending and crashing into the sea. Contributing to the accident was the failure of the pilot and operator to…
- [NTSB ATL84FA274](https://openairdocs.org/ntsb/ATL84FA274.md): Cessna 402C · Albertville, AL · Accident · 2 fatal · Field investigation · Final report · Aug 31, 1984 · N55LP · Destroyed
  > Plt was executing an non-directional beacon approach to rwy 23. Instrument meteorological conditions prevailed at the time of the accident. Radar information obtained during the investigation revealed the plt did not stabilize the airspeed while executing 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 ('207590R')
    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" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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