# NTSB investigations: Piper PA-31-325, FL

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 ERA19LA125](https://openairdocs.org/ntsb/ERA19LA125.md): Piper PA31 · Leesburg, FL · Accident · No injuries · Class 3 · Limited · Final report · Mar 8, 2019 · N45MJ · Substantial damage
  > Maintenance personnel’s improper rigging of the main landing gear actuators, which resulted in the collapse of the right main landing gear.
- [NTSB MIA02IA072](https://openairdocs.org/ntsb/MIA02IA072.md): Piper PA-31-325 · Fort Laudedale, FL · Incident · No injuries · Incident investigation · Final report · Mar 23, 2002 · N49RB · Minor damage
  > The failure of the pilot to assure all items of the before landing checklist were complied with before landing, resulting in the wheels up landing.
- [NTSB MIA94FA167](https://openairdocs.org/ntsb/MIA94FA167.md): Piper PA-31-325 · Lantana, FL · Accident · 2 fatal · Field investigation · Final report · Jun 24, 1994 · N27872 · Substantial damage
  > The pilot's impairment of judgment and performance due to drugs, his failure to abort the takeoff after experiencing reduced takeoff performance, and his failure to maintain minimum control speed. Factors in the accident were: a partial loss of engine power…
- [NTSB MIA90FA145](https://openairdocs.org/ntsb/MIA90FA145.md): Piper PA-31 · Panama City, FL · Accident · 2 fatal · Field investigation · Final report · Jun 26, 1990 · N18PA · Destroyed
  > A loss of power on both engines during takeoff as a result of inadequate maintenance. In addition, the pilot failed to abort the takeoff.

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

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

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