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

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 CHI85LA216](https://openairdocs.org/ntsb/CHI85LA216.md): Piper PA-32T-300 · Milwaukee, WI · Accident · No injuries · Limited investigation · Final report · May 19, 1985 · N39628 · Substantial damage
  > The pilot stated that the approach was normal and flown at 90 KIAS. He flared high and the acft landed hard on the right main landing gear, due to the excessive rate of decent. The damage was limited to the right wing spar and ribs.
- [NTSB CHI85LA056](https://openairdocs.org/ntsb/CHI85LA056.md): Piper PA-32RT-300T · Chambers Island, WI · Accident · Serious injuries · Limited investigation · Final report · Nov 22, 1984 · N21596 · Destroyed
  > The plt reported that during takeoff upon reaching an alt of 8-10 ft AGL a down draft was encountered and the acft contacted the rwy on the rt landing gear which was in the transient position. He reported he was able to remain airborne but the rate of climb…
- [NTSB CHI81DER40](https://openairdocs.org/ntsb/CHI81DER40.md): Piper PA-32 · Crivitz, WI · Accident · Minor injuries · Closed · Sep 14, 1981 · N39628 · Substantial damage
- [NTSB CHI68D0154](https://openairdocs.org/ntsb/CHI68D0154.md): Piper PA-23 · Fond Du Lac, WI · Accident · No injuries · Closed · Jul 6, 1967 · N2225P · 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" = 'WI' 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=WI

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