# NTSB investigations: Piper PA-23-250, LA

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 FTW96GA365](https://openairdocs.org/ntsb/FTW96GA365.md): Piper PA-23-250 · Jennings, LA · Accident · 2 fatal · Final report · Aug 31, 1996 · N14196 · Destroyed
  > The pilot's failure to maintain clearance. Factors were the pilot's lack of recent experience in the make and model of airplane, the dark night, and fog.
- [NTSB FTW95LA327](https://openairdocs.org/ntsb/FTW95LA327.md): Piper PA-23-250 · Monroe, LA · Accident · No injuries · Limited investigation · Final report · Aug 3, 1995 · N76SR · Substantial damage
  > The pilot's improper positioning of the fuel selector resulting in fuel starvation and the failure of the pilot to follow the published emergency procedures for propeller feathering. Factors were the fence and the trees.
- [NTSB FTW83LA307](https://openairdocs.org/ntsb/FTW83LA307.md): Piper PA-23-250 · Franklinton, LA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1983 · N4903P · Destroyed
  > The acft slid into a tree during a landing on a wet rwy. The plt had encountered the rain shortly after takeoff and returned to the arpt. The private strip had become soft from the rain and the plt lost control of the acft. The acft veered off the strip and…
- [NTSB FTW81FA024](https://openairdocs.org/ntsb/FTW81FA024.md): Piper PA-23 · New Orleans, LA · Accident · 3 fatal · Closed · Jan 15, 1981 · N6812Y · Destroyed
- [NTSB FTW80DRJ40](https://openairdocs.org/ntsb/FTW80DRJ40.md): Piper PA-23 · Pineville, LA · Accident · No injuries · Closed · Sep 11, 1980 · N62730 · Substantial damage
- [NTSB FTW80FRD01](https://openairdocs.org/ntsb/FTW80FRD01.md): Piper PA-23 · Opelousas, LA · Accident · No injuries · Closed · Oct 3, 1979 · N62267 · Substantial damage
- [NTSB FTW70A0043](https://openairdocs.org/ntsb/FTW70A0043.md): Piper PA-23 · Norwood, LA · Accident · 4 fatal · Closed · Dec 19, 1969 · N4723P · Destroyed
- [NTSB FTW69F0010](https://openairdocs.org/ntsb/FTW69F0010.md): Piper PA-23 · Alexandria, LA · Accident · No injuries · Closed · Jun 5, 1968 · N6033Y · Substantial damage
- [NTSB FTW68F0412](https://openairdocs.org/ntsb/FTW68F0412.md): Piper PA-23 · Baton Rouge, LA · Accident · No injuries · Closed · Jan 4, 1968 · N6285Y · Substantial damage
- [NTSB FTW67D0314](https://openairdocs.org/ntsb/FTW67D0314.md): Piper PA-23 · Eunice, LA · Accident · No injuries · Closed · Nov 13, 1966 · N6209Y · Substantial damage
- [NTSB UNK64X3983](https://openairdocs.org/ntsb/UNK64X3983.md): Piper PA-18 · Rayville, LA · Accident · 1 fatal · Closed · Sep 14, 1964 · N40602 · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?model=7102308&state=LA

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