# NTSB investigations: Cessna 402C, 2017

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 GAA18CA071](https://openairdocs.org/ntsb/GAA18CA071.md): Cessna 402 · Hyannis, MA · Accident · No injuries · Data collection · Final report · Dec 4, 2017 · N2748Y · Substantial damage
  > Encounter with a flock of birds during takeoff at night, resulting in multiple bird strikes and structural damage.
- [NTSB CEN17WA291](https://openairdocs.org/ntsb/CEN17WA291.md): Cessna 402 · British Virgin Islands, British Virgin Islands · Incident · No injuries · Foreign investigation · Jul 27, 2017 · N618CA · No damage
  > On July 27, 2017, a Cessna 402C airplane, N618CA, exited the prepared surface during an aborted takeoff at the Terrance B. Lettsome International Airport, British Virgin Islands. The pilots and occupants were not injured and the airplane was not damaged.The…
- [NTSB CEN17WA107](https://openairdocs.org/ntsb/CEN17WA107.md): Cessna 402C · Virgin Gorda, British Virgin Islands · Accident · No injuries · Foreign investigation · Feb 11, 2017 · N603AB · Substantial damage
  > On February 11, 2017, at 2004 UTC, a Cessna 402C, N603AB, experienced brake failure during landing roll and impacted terrain at the Virgin Gorda Airport (TUPW), British Virgin Islands. The pilot and 8 passengers on board were not injured. The airplane…

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

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

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