# NTSB investigations: Piper PA-32RT-300T, MO

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 CHI95LA196](https://openairdocs.org/ntsb/CHI95LA196.md): Piper PA-32R · Columbia, MO · Accident · No injuries · Limited investigation · Final report · Jun 23, 1995 · N39620 · Substantial damage
  > A loose (or missing) nut and clip for the bottom magneto stud, due to inadequate maintenance, and fatigue failure of the magneto housing flange, which restulted in an oil leak, engine compartment fire, and a forced landing. A factor relating to the accident…
- [NTSB CHI92FA044](https://openairdocs.org/ntsb/CHI92FA044.md): Piper PA-32RT/300T · Camdenton, MO · Accident · 1 fatal · Field investigation · Final report · Dec 8, 1991 · N39555 · Destroyed
  > The pilot's disregard for wind conditions, not aborting the takeoff, and inadequate remedial action by the pilot after the airplane became airborne. Factors associated with the accident are an inadequate weather evaluation by the pilot, not maintaining…
- [NTSB MKC85LA009](https://openairdocs.org/ntsb/MKC85LA009.md): Piper PA32RT-300T · Columbia, MO · Accident · No injuries · Limited investigation · Final report · Oct 26, 1984 · N75DR · Substantial damage
  > The plt was high on the ILS approach and flew a VFR very low circling approach after clearance to change from rwy 2 to rwy 20. The tower controller said the acft was so low that at one point he lost sight of the acft. He advised the plt that he appeared to be…
- [NTSB MKC82DA177](https://openairdocs.org/ntsb/MKC82DA177.md): Piper PA32RT-300 · Excelsior Sprin, MO · Accident · No injuries · Final report · Sep 30, 1982 · N39591 · Substantial damage
  > Pilot did not attain enough airspeed and aborted takeoff too late to stop before going off end of runway into bushes, damaging landing gear.

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

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

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