# NTSB investigations: Piper PA-23-160, 2005

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 CHI06FA030](https://openairdocs.org/ntsb/CHI06FA030.md): Piper PA-23-160 · Bloomington, IL · Accident · 1 fatal · Field investigation · Final report · Nov 10, 2005 · N4319P · Substantial damage
  > The aircraft control not possible by the pilot during a visual approach to the runway due to the physical impairment of the pilot.
- [NTSB LAX06CA013](https://openairdocs.org/ntsb/LAX06CA013.md): Piper PA-23-160 · Upland, CA · Accident · Minor injuries · Data collection · Final report · Oct 19, 2005 · N4252P · Substantial damage
  > the pilot's failure to maintain directional control during landing.
- [NTSB LAX05LA221](https://openairdocs.org/ntsb/LAX05LA221.md): Piper PA-23-160 · Honolulu, HI · Accident · No injuries · Limited investigation · Final report · Jul 1, 2005 · N3369P · Substantial damage
  > the flight crew's failure to ensure that the landing gear lever was in the full down position prior to utilizing the hand pump, and the certified flight instructor's failure to utilize the blow down emergency landing gear system. The instructor's inadequate…

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

This list as a web page: https://openairdocs.org/ntsb?model=7102304&year=2005

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