# NTSB investigations: Piper PA-22-160, 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 CHI97LA099](https://openairdocs.org/ntsb/CHI97LA099.md): Piper PA-22 · Oshkosh, WI · Accident · Minor injuries · Limited investigation · Final report · Apr 4, 1997 · N9231D · Substantial damage
  > the pilot's inadequate compensation for the wind conditions, and his failure to maintain proper runway alignment, which resulted in a subsequent nose over. The gusty crosswind condition was a related factor.
- [NTSB CHI90LA035](https://openairdocs.org/ntsb/CHI90LA035.md): Piper PA-22 · Barron, WI · Accident · No injuries · Limited investigation · Final report · Nov 30, 1989 · N8749D · Substantial damage
  > Improper use of the carburetor heat by the pilot and subsequent carburetor ice. Contributing factors were: carburetor icing conditions, slick (wet/snow covered) runway, and trees/brush near the departure end of the runway.
- [NTSB CHI83LA354](https://openairdocs.org/ntsb/CHI83LA354.md): Piper PA-22 · Juneau, WI · Accident · No injuries · Limited investigation · Final report · Jul 31, 1983 · N8632D · Substantial damage
  > The pilot stated that he made the approach at 85-90 mph with 40 degrees flaps and 1100 RPM. The winds were from 270 degrees at 10 KTS gusting to 20 KTS the acft started to sink on the short final and the pilot applied power and pulled back on the stick in an…
- [NTSB CHI67D0120](https://openairdocs.org/ntsb/CHI67D0120.md): Piper PA-22 · Whitewater, WI · Accident · Minor injuries · Closed · Jul 10, 1966 · N8494D · Destroyed
- [NTSB CHI65F0033](https://openairdocs.org/ntsb/CHI65F0033.md): Piper PA-22 · Milwaukee, WI · Accident · No injuries · Closed · Jan 30, 1965 · N9533D · 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 ('7102214'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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