# NTSB investigations: Cessna 402B, MI

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 CHI04LA065](https://openairdocs.org/ntsb/CHI04LA065.md): Cessna 402B · Sturgis, MI · Accident · Serious injuries · Limited investigation · Final report · Feb 9, 2004 · N6387X · Substantial damage
  > The failure to maintain obstacle clearance during an intentional low altitude maneuver and the ostentatious display by the pilot-in-command. A factor to the accident was the tree.
- [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…
- [NTSB CHI92LA263](https://openairdocs.org/ntsb/CHI92LA263.md): Cessna 402B · Almont, MI · Accident · No injuries · Limited investigation · Final report · Sep 3, 1992 · N7882Q · Substantial damage
  > Excessive fuel system pump pressure and corresponding excessive fuel pressure and the pilot not maintaining the best single engine climb speed.
- [NTSB CHI81FEM02](https://openairdocs.org/ntsb/CHI81FEM02.md): Cessna 402B · Traverse City, MI · Accident · No injuries · Closed · Oct 30, 1980 · N3AP · 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" = 'MI' 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 ('207590P'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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