# NTSB investigations: Cessna 402B: In flight encounter with weather

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 CHI98LA098](https://openairdocs.org/ntsb/CHI98LA098.md): Cessna 402B · Mason City, IA · Accident · Minor injuries · Limited investigation · Final report · Feb 27, 1998 · N108RS · Substantial damage
  > the accumulation of airframe ice during flight, and failure of the pilot to attain a proper flare for landing. Factors relating to the accident were: the adverse weather (icing) condition; and the pilot's limited forward visibility, due to ice on the…
- [NTSB SEA91LA014](https://openairdocs.org/ntsb/SEA91LA014.md): Cessna 402B · Pocatello, ID · Accident · No injuries · Limited investigation · Final report · Nov 8, 1990 · N1683T · Substantial damage
  > The loss of engine power due to a burned piston resulting from arcing and partial failure of the left magneto because of improper overhaul, the contamination of the right magneto and improper adjustment of the fuel system at the last major engine overhaul;…
- [NTSB SEA90FA045](https://openairdocs.org/ntsb/SEA90FA045.md): Cessna 402B · Baker, OR · Accident · 1 fatal · Field investigation · Final report · Feb 5, 1990 · N50GP · Destroyed
  > Pilot displayed poor inflight planning by selecting to fly into known adverse weather conditions. The pilot did not maintain an adequate visual lookout when operating in snow shower conditions and collided into the terrain.
- [NTSB DCA89MA026](https://openairdocs.org/ntsb/DCA89MA026.md): Cessna 402B · Corona, CA · Accident · 10 fatal · Major investigation · Final report · Feb 19, 1989 · N69383 · Destroyed
  > The pilot's failure to properly preflight and plan for flight and his intentional flight into IMC conditions. Factors contributing to the accident were the low ceiling conditions in conjunction with the mountainous terrain.
- [NTSB DEN85FA167](https://openairdocs.org/ntsb/DEN85FA167.md): Cessna 402B · Bailey, CO · Accident · 8 fatal · Field investigation · Final report · Jun 17, 1985 · N100HK · Destroyed
  > Ground witnesses observed the acft enter low clouds going south, then emerge from clouds going went. Acft collided with mountain in wings-level and powered attitude. Mountains were reported to be obscured by clouds and fog.

## 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" = 240))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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