# NTSB investigations: Piper PA-28-235, 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 CEN16LA021](https://openairdocs.org/ntsb/CEN16LA021.md): Piper PA 28-235 · Winneconne, WI · Accident · No injuries · Limited investigation · Final report · Oct 24, 2015 · N3979X · Substantial damage
  > An engine compartment fire during landing, which resulted in extensive fire damage, for reasons that could not be determined during examinations of the remaining wreckage.
- [NTSB CHI87LA082](https://openairdocs.org/ntsb/CHI87LA082.md): Piper PA-28-235 · Oshkosh, WI · Accident · No injuries · Limited investigation · Final report · Feb 12, 1987 · N9451W · Substantial damage
  > According to the plt, at aprx 1800 feet 'the engine abruptly quit with no runon or sputter' following takeoff from rwy 18 at Oshkosh, WI. The plt stated that he banked the acft back to the airport, but the aileron controls became jammed or 'frozen'. According…
- [NTSB CHI77FEP13](https://openairdocs.org/ntsb/CHI77FEP13.md): Piper PA-28 · Cable, WI · Accident · No injuries · Closed · Dec 24, 1976 · N210KB · Substantial damage
- [NTSB CHI70FDM07](https://openairdocs.org/ntsb/CHI70FDM07.md): Piper PA-28 · Minong, WI · Accident · No injuries · Closed · Jun 17, 1970 · N8659W · Substantial damage
- [NTSB CHI68F0125](https://openairdocs.org/ntsb/CHI68F0125.md): Piper PA-28 · Three Lakes, WI · Accident · Minor injuries · Closed · Jul 15, 1967 · N8956W · 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 ('7102810'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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