# NTSB investigations: Cessna 402B, MA

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 ERA18LA136](https://openairdocs.org/ntsb/ERA18LA136.md): Cessna 402 · Barre Plains, MA · Accident · No injuries · Limited investigation · Final report · Apr 26, 2018 · N87266 · Substantial damage
  > The pilot's improper decision to land with a tailwind, which resulted in a touchdown with insufficient runway remaining to stop the airplane.
- [NTSB ERA17LA329](https://openairdocs.org/ntsb/ERA17LA329.md): Cessna 402 · Nantucket, MA · Accident · Minor injuries · Limited investigation · Final report · Sep 13, 2017 · N836GW · Substantial damage
  > The separation of the pushrod from the elevator trim tab actuator, which rendered controlled flight impossible. Contributing to the separation of the pushrod was the failure of maintenance personnel to properly secure it to the elevator trim tab actuator.
- [NTSB ERA12IA090](https://openairdocs.org/ntsb/ERA12IA090.md): Cessna 402B · Nantucket, MA · Incident · No injuries · Incident investigation · Final report · Nov 29, 2011 · N303PJ · Minor damage
  > The failure of the right main fuel tank transfer pump, which resulted in a total loss of engine power on the right engine during approach due to fuel starvation, and a subsequent hard landing. Contributing to the incident was the pilot's operation of the…
- [NTSB NYC89LA081](https://openairdocs.org/ntsb/NYC89LA081.md): Cessna 402B · Hyannis, MA · Accident · No injuries · Limited investigation · Final report · Feb 4, 1989 · N49PB · Substantial damage
  > Inadequate preflight planning and preparation by the pilot which resulted in improper weight and balance (aft CG). The aft CG also contributed to the uncommanded altitude deviation after takeoff.

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

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