# NTSB investigations: Cessna 402B, 2003

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 SEA03LA133](https://openairdocs.org/ntsb/SEA03LA133.md): Cessna 402 B · Lakeview, OR · Accident · No injuries · Limited investigation · Final report · Jul 8, 2003 · N98635 · Substantial damage
  > Failure of the landing gear shaft roll pin resulting in a main gear collapse during the taxi phase of operation.
- [NTSB MIA03WA126](https://openairdocs.org/ntsb/MIA03WA126.md): Cessna 402B · LittleWhale Cay, Bahamas · Accident · No injuries · Foreign investigation · Jun 17, 2003 · N3748C · Substantial damage
- [NTSB ANC03LA065](https://openairdocs.org/ntsb/ANC03LA065.md): Cessna 402B · Telida, AK · Accident · No injuries · Limited investigation · Final report · Jun 9, 2003 · N710WS · Substantial damage
  > The pilot's selection of an unsuitable landing site, which resulted in the collapse of the nose landing gear. A factor in the accident was a soft runway.
- [NTSB MIA03IA110](https://openairdocs.org/ntsb/MIA03IA110.md): Cessna 402C · Miami, FL · Incident · No injuries · Incident investigation · Final report · May 22, 2003 · N402DD · No damage
  > The inadequate annual inspection of the airplane by other maintenance personnel for failure to note an incorrect washer was installed securing the upper and lower torque links, resulting in separation of the upper and lower links and subsequent rotation of…
- [NTSB MIA03LA064](https://openairdocs.org/ntsb/MIA03LA064.md): Cessna 402B · Marathon, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 20, 2003 · N554AE · Substantial damage
  > The loss of engine power to both engines for undetermined reasons.

## 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") = 2003
  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=2003

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