# NTSB investigations: Piper PA-32R-300, 2020

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 WPR20LA238](https://openairdocs.org/ntsb/WPR20LA238.md): Piper PA32R · West Jordan, UT · Accident · 5 fatal · Class 3 · Limited · Final report · Jul 25, 2020 · N7677C · Substantial damage
  > The pilot's failure to maintain the airplane’s speed during takeoff near the airplane’s maximum gross weight in high-density altitude conditions, which resulted in the exceedance of the airplane's critical angle of attack and led to an aerodynamic stall, loss…
- [NTSB ANC20FA017](https://openairdocs.org/ntsb/ANC20FA017.md): Piper PA32R · Tuntutuliak, AK · Accident · 5 fatal · Class 3 · Field · Final report · Feb 6, 2020 · N7632C · Substantial damage
  > The pilot's continued visual flight rules flight into reduced visibility, including likely flat light and/or white out conditions, which resulted in a controlled flight into terrain. Contributing to the accident were the operator’s inadequate operational…

## 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 year(c."eventDate") = 2020
  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&year=2020

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