# NTSB investigations: Piper PA-32RT-300, MS

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 MIA90LA173](https://openairdocs.org/ntsb/MIA90LA173.md): Piper PA-32RT-300 · Hattiesburg, MS · Accident · No injuries · Limited investigation · Final report · Aug 24, 1990 · N289PC · Substantial damage
  > Failure of the pilot in command to attain adequate airspeed prior to liftoff during an attempted takeoff. The pilot then lost control of the airplane in flight. The pilot also delayed in his decision to abort the takeoff.
- [NTSB MIA87FA031](https://openairdocs.org/ntsb/MIA87FA031.md): Piper PA-32RT-300 · Columbus, MS · Accident · 1 fatal · Field investigation · Final report · Nov 12, 1986 · N21188 · Destroyed
  > The acft departed Columbus, MS, en route to meridian, MS, to pick up cargo for a return flt to Columbus. The acft did not arrive at its destination and was later found in an open field about 2 miles southwest of the golden triangle regional airport in…

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

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

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