# NTSB investigations: Piper PA-23-250, 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 ANC18LA016](https://openairdocs.org/ntsb/ANC18LA016.md): Piper PA 23-250 · Knoxville, TN · Accident · Serious injuries · Limited investigation · Final report · Dec 19, 2017 · N40285 · Substantial damage
  > The flight instructor’s failure to comply with published engine-out procedures and recommended airspeeds, which resulted in a lack of directional control, collision with trees, and impact with the ground; the left engine lost total power due to fuel…
- [NTSB ERA17FA222](https://openairdocs.org/ntsb/ERA17FA222.md): Piper PA23 · Chatsworth, GA · Accident · 4 fatal · Field investigation · Final report · Jul 1, 2017 · N44HJ · Destroyed
  > The noninstrument-rated pilot's continued visual flight rules flight into adverse weather conditions, which resulted in an encounter with severe convective activity, spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.…
- [NTSB ERA17FA195](https://openairdocs.org/ntsb/ERA17FA195.md): Piper PA23 · San Juan, PR · Accident · 1 fatal · Field investigation · Final report · Jun 3, 2017 · N21WW · Destroyed
  > The pilot's failure to maintain adequate airspeed, properly correct for left yaw, and his exceedance of the airplane's critical angle of attack during initial climb, which resulted in an aerodynamic stall and subsequent uncontrolled descent into water.
- [NTSB GAA17CA282](https://openairdocs.org/ntsb/GAA17CA282.md): Piper PA23 · Fremont, OH · Accident · No injuries · Data collection · Final report · May 9, 2017 · N63944 · Substantial damage
  > The pilot’s failure to maintain an adequate glidepath during approach, which resulted in an impact with a semi-truck.

## 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 ('7102308'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102308&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.