# NTSB investigations: Piper PA-32R-300, 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 CEN21LA014](https://openairdocs.org/ntsb/CEN21LA014.md): Piper PA32R · Kimberling City, MO · Accident · Serious injuries · Class 4 · Limited · Final report · Oct 10, 2020 · N3445Q · Destroyed
  > The pilot’s inadequate preflight inspection, which resulted in his inadvertent departure with the tow bar connected to the nose wheel, and the low approach while returning to the airport, which allowed the tow bar to contact trees.
- [NTSB CEN11FA263](https://openairdocs.org/ntsb/CEN11FA263.md): Piper PA-32R-300 · Fredricktown, MO · Accident · 3 fatal · Field investigation · Final report · Mar 29, 2011 · N4085F · Substantial damage
  > The pilot's decision to attempt to maintain visual flight by descending below an area of deteriorating forecast weather to an altitude that did not provide adequate terrain clearance.
- [NTSB MKC81FCG04](https://openairdocs.org/ntsb/MKC81FCG04.md): Piper PA-32R · Ozark, MO · Accident · No injuries · Closed · Oct 15, 1980 · N7698C · Substantial damage
- [NTSB MKC79FCG22](https://openairdocs.org/ntsb/MKC79FCG22.md): Piper PA-32R · Higginsville, MO · Accident · No injuries · Closed · Jan 24, 1979 · N9621K · Substantial damage

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

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