# NTSB investigations: Cessna 402B, ID

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 ANC19LA039](https://openairdocs.org/ntsb/ANC19LA039.md): Cessna 402 · Boise, ID · Accident · No injuries · Class 3 · Limited · Final report · Jul 22, 2019 · N7947Q · Substantial damage
  > A ductile overstress fracture failure of the right main landing gear bell crank assembly pivot bolt, which resulted in a collapse of the right main landing gear.
- [NTSB SEA06LA011](https://openairdocs.org/ntsb/SEA06LA011.md): Cessna 402B · Sandpoint, ID · Accident · No injuries · Limited investigation · Final report · Oct 21, 2005 · N402CA · Substantial damage
  > The pilot's misjudged distance/altitude, which led to him landing short of the runway and impacting the runway's elevated lip. Contributing factors were the elevated runway lip and the right main landing gear failure.
- [NTSB SEA92FA019](https://openairdocs.org/ntsb/SEA92FA019.md): Cessna C-402B · Boise, ID · Accident · 2 fatal · Field investigation · Final report · Nov 16, 1991 · N29517 · Destroyed
  > The loss of power on the right engine during initial climb after takeoff due to inadequate maintenance inspection and adjustment of the engine by company maintenance personnel, and the loss of control by the pilot due to his failure to properly configure 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;…

## 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" = 'ID' 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=ID

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