# NTSB investigations: Piper PA-24-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 CEN15LA444](https://openairdocs.org/ntsb/CEN15LA444.md): Piper PA 24-250 · New Orleans, LA · Accident · No injuries · Limited investigation · Final report · Sep 19, 2015 · N7803P · Substantial damage
  > The collapse of the landing gear for reasons that could not be determined based on the available information.
- [NTSB FTW85LA326](https://openairdocs.org/ntsb/FTW85LA326.md): Piper PA-24-250 · Farmerville, LA · Accident · No injuries · Limited investigation · Final report · Aug 20, 1985 · N8050P · Substantial damage
  > The plt took off and started his climbout with the fuel selector on a fuel tank which was virtually empty. The eng stopped reaching an alt of 200 feet AGL. The plt made forced landing in trees. There was an ample supply of fuel (about 70 gallons) distributed…
- [NTSB FTW81DRJ20](https://openairdocs.org/ntsb/FTW81DRJ20.md): Piper PA-24 · Many, LA · Accident · No injuries · Closed · Jun 24, 1981 · N8136P · Substantial damage
- [NTSB FTW73FRD17](https://openairdocs.org/ntsb/FTW73FRD17.md): Piper PA-24 · New Orleans, LA · Accident · No injuries · Closed · Feb 17, 1973 · N8348P · Substantial damage
- [NTSB FTW73DRJ14](https://openairdocs.org/ntsb/FTW73DRJ14.md): Piper PA-24 · West Monroe, LA · Accident · Minor injuries · Closed · Sep 2, 1972 · N6166P · Destroyed
- [NTSB FTW71DRJ07](https://openairdocs.org/ntsb/FTW71DRJ07.md): Piper PA-24 · Cottonport, LA · Accident · No injuries · Closed · Aug 10, 1970 · N5717P · Substantial damage
- [NTSB FTW70FRD15](https://openairdocs.org/ntsb/FTW70FRD15.md): Piper PA-24 · Opelousas, LA · Accident · No injuries · Closed · May 14, 1970 · N7691P · Substantial damage
- [NTSB FTW69A0046](https://openairdocs.org/ntsb/FTW69A0046.md): Piper PA-24 · Oakdale, LA · Accident · 5 fatal · Closed · Dec 30, 1968 · N7702P · Destroyed
- [NTSB FTW66F0491](https://openairdocs.org/ntsb/FTW66F0491.md): Piper PA-24 · Montgomery, LA · Accident · No injuries · Closed · Jan 15, 1966 · N7950P · Substantial damage
- [NTSB FTW66A0062](https://openairdocs.org/ntsb/FTW66A0062.md): Piper PA-24 · Jonesboro, LA · Accident · 1 fatal · Closed · Jan 1, 1966 · N5783P · Destroyed
- [NTSB FTW66A0006](https://openairdocs.org/ntsb/FTW66A0006.md): Piper PA-24 · Lake Charles, LA · Accident · 4 fatal · Closed · Jul 22, 1965 · N7769P · Destroyed
- [NTSB FTW66F0005](https://openairdocs.org/ntsb/FTW66F0005.md): Piper PA-24 · Baton Rouge, LA · Accident · No injuries · Closed · Mar 8, 1965 · N8086P · Substantial damage
- [NTSB UNK65X1339](https://openairdocs.org/ntsb/UNK65X1339.md): Piper PA24 · Lake Charles, LA · Accident · No injuries · Closed · Jan 24, 1965 · N5623P · Substantial damage
- [NTSB UNK65X1263](https://openairdocs.org/ntsb/UNK65X1263.md): Piper PA24 · Baton Rouge, LA · Accident · No injuries · Closed · Jan 10, 1965 · N7812P · Substantial damage
- [NTSB UNK64X3534](https://openairdocs.org/ntsb/UNK64X3534.md): Piper PA24 · Baton Rouge, LA · Accident · No injuries · Closed · Aug 22, 1964 · N8447P · Substantial damage
- [NTSB UNK64X1873](https://openairdocs.org/ntsb/UNK64X1873.md): Piper PA24 · Freemason Is, LA · Accident · No injuries · Closed · May 22, 1964 · N6206P · Substantial damage
- [NTSB UNK64X0704](https://openairdocs.org/ntsb/UNK64X0704.md): Piper PA24 · New Orleans, LA · Accident · 2 fatal · Closed · Feb 27, 1964 · N7871P · 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 ('7102404'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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