# NTSB investigations: Piper PA-22-108, 1985

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 DEN85LA206](https://openairdocs.org/ntsb/DEN85LA206.md): Piper PA-22 · Boulder, CO · Accident · No injuries · Limited investigation · Final report · Jul 30, 1985 · N5430Z · Substantial damage
  > According to the plt, he was approaching the Boulder municipal arpt, Boulder, Colorado, for a VFR landing when his engine failed to develop sufficient power to sustain flight. A forced landing was made to a farmer's field. The acft sustained substantial…
- [NTSB NYC85LA176](https://openairdocs.org/ntsb/NYC85LA176.md): Piper PA-22-108 · Hookstown, PA · Accident · No injuries · Limited investigation · Final report · Jul 16, 1985 · N5322Z · Substantial damage
  > The instructor and student were practicing normal takeoffs and landings. According to the pilot, on the sixth landing, at the correct airspeed, the aircraft touched down on the main gear and then the noise wheel collapsed. The aircraft then nosed over.…
- [NTSB CHI85LA238](https://openairdocs.org/ntsb/CHI85LA238.md): Piper PA-22-108 · Starbuck, MN · Accident · No injuries · Limited investigation · Final report · Jun 16, 1985 · N5355Z · Substantial damage
  > Plt landed in crosswind conditions, veered off the edge of tha rwy onto rough, unleveled terrain. The nosewheel collapsed and the aircraft nosed over.

## 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") = 1985
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102204'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102204&year=1985

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