# NTSB investigations: Piper PA-23: In flight encounter with weather

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 FTW93LA035](https://openairdocs.org/ntsb/FTW93LA035.md): Piper PA-23-150 · Jayton, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 1992 · N2078P · Substantial damage
  > The pilot failed to maintain flying speed while maneuvering for landing and allowed the a/c to stall. Factors were the low ceilings, the pilots disregard of the forecast weather, the carburetor icing conditions, and the pilots delayed application of…
- [NTSB DCA87MA010](https://openairdocs.org/ntsb/DCA87MA010.md): Piper PA-23-150 · Tampa, FL · Accident · 1 fatal · Class 1 · Major · Final report · Nov 6, 1986 · N2185P · 2 aircraft · Destroyed
  > At aprx 0612 EST, an eastern airline capt (owner of Piper PA-23, N2185P) departed a rwy near his home in VFR conds to commute to work at Tampa, FL. Shortly after takeoff, he contacted a fss & updated the wx info he had obtained on the previous evening. At…
- [NTSB ATL86FA092](https://openairdocs.org/ntsb/ATL86FA092.md): Piper PA-23 · Toledo, OH · Accident · 1 fatal · Field investigation · Final report · Mar 13, 1986 · N3124P · No damage
  > N3124P crashed while attempting an ILS approach to rwy 07 at express airport in Toledo, OH. The pilot had attempted an approach at metcalf airport but missed the approach because of the weather. The aircraft crashed about 1 mile short of the airport in a…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102302')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102302&occurrence=240

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