# NTSB investigations: Cessna 402B, 2002

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 CHI02LA210](https://openairdocs.org/ntsb/CHI02LA210.md): Cessna 402B · St. Louis, MO · Accident · No injuries · Limited investigation · Final report · Jul 24, 2002 · N22PB · Substantial damage
  > The landing gear collapsed for undetermined reasons.
- [NTSB MIA02WA083](https://openairdocs.org/ntsb/MIA02WA083.md): Cessna 402B · Nassau, Bahamas · Accident · No injuries · Foreign investigation · Apr 3, 2002 · N768WC · Substantial damage
- [NTSB CHI02FA067](https://openairdocs.org/ntsb/CHI02FA067.md): Cessna 402B · Bronson, MI · Accident · 1 fatal · Field investigation · Final report · Jan 23, 2002 · N371JD · Destroyed
  > The maneuver to avoid the utility wire while maneuvering resulting in an inadvertent stall and subsequent impact with the ground. Factors were the pilot's inadvertent activation of the elevator trim, resulting in a loss of control during flight in instrument…

## 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 year(c."eventDate") = 2002
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590P'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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