# NTSB investigations: Cessna 402B: 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 SEA01LA052](https://openairdocs.org/ntsb/SEA01LA052.md): Cessna 402B · Billings, MT · Accident · No injuries · Limited investigation · Final report · Feb 20, 2001 · N69316 · Substantial damage
  > Best rate-of-climb single-engine speed was not maintained. Delayed remedial action was a factor.
- [NTSB MIA99FA043](https://openairdocs.org/ntsb/MIA99FA043.md): Cessna 402B · Pahokee, FL · Accident · 3 fatal · Field investigation · Final report · Dec 9, 1998 · N788SP · Substantial damage
  > The pilot's failure to maintain adequate altitude during the approach.
- [NTSB CHI98LA050](https://openairdocs.org/ntsb/CHI98LA050.md): Cessna 402B · Spencer, IA · Accident · No injuries · Limited investigation · Final report · Nov 29, 1997 · N22NC · Substantial damage
  > The pilot failure to comply with the prescribed IFR procedure and his not following his company's operations specifications. Low clouds and fog were are contributing factors.
- [NTSB LAX96FA103](https://openairdocs.org/ntsb/LAX96FA103.md): Cessna 402B · Kamuela, HI · Accident · 1 fatal · Field investigation · Final report · Jan 29, 1996 · N999CR · Destroyed
  > failure of the copilot (pilot-rated cargo loader, who was flying the aircraft) to establish and maintain a positive rate of climb after taking off at night; and inadequate supervision by the pilot-in-command (PIC), by failing to ensure that proper altitude…
- [NTSB SEA93FA071](https://openairdocs.org/ntsb/SEA93FA071.md): Cessna 402B · Oakley, UT · Accident · 2 fatal · Field investigation · Final report · Mar 2, 1993 · N3103P · Destroyed
  > Poor inflight planning/decision. Factors to the accident were: dark night condition and terrain clearance was not maintained.
- [NTSB CHI93LA052](https://openairdocs.org/ntsb/CHI93LA052.md): Cessna 402B · Cedar Rapids, IA · Accident · Minor injuries · Limited investigation · Final report · Dec 14, 1992 · N17CH · Substantial damage
  > The pilot-in-command's failure to maintain a proper glidepath.
- [NTSB CHI90FA065](https://openairdocs.org/ntsb/CHI90FA065.md): Cessna 402B · Appleton, WI · Accident · 1 fatal · Field investigation · Final report · Jan 17, 1990 · N87163 · Destroyed
  > The pilot's decision to continue flight into known adverse weather conditions resulting in a windshear encounter with insufficient altitude for recovery. The existing adverse weather conditions were factors.
- [NTSB ANC88FA111](https://openairdocs.org/ntsb/ANC88FA111.md): Cessna 402B · Mt. Torbet, AK · Accident · 2 fatal · Field investigation · Final report · Aug 18, 1988 · N5718M · Substantial damage
  > The on-demand-charter flight was to originally pickup passengers and cargo but a landing gear problem forced another airplane with a mechanic to be dispatched. The other airplane returned with the passengers and the accident airplane was repaired by the…
- [NTSB MIA86LA132](https://openairdocs.org/ntsb/MIA86LA132.md): Cessna 402B · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Apr 25, 1986 · N401NA · Substantial damage
  > The plt stated that upon arrival at his destination he could not get his landing gear to extend. He then returned to Opa Locka airport where he intentionally landed with the gear up. Post crash investigation of the acft revealed that the landing gear would…

## 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 ('207590P')
    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=207590P&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.
