# NTSB investigations: Piper PA-22: Loss of control - in flight

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 ANC93LA008](https://openairdocs.org/ntsb/ANC93LA008.md): Piper PA-22 · Seward, AK · Accident · Serious injuries · Limited investigation · Final report · Oct 17, 1992 · N1660A · Substantial damage
  > The pilots failure to maintain directional control on the ground. Contributing to the accident was the pilots failure to maintain airspeed during the takeoff climb, his inadequate training, his lack of total experience, and the ditch.
- [NTSB MKC86FA029](https://openairdocs.org/ntsb/MKC86FA029.md): Piper PA-22-135 · Osage Beach, MO · Accident · 2 fatal · Field investigation · Final report · Nov 17, 1985 · N8042C · Destroyed
  > Witnesses observed N80426 lt of the final apch course for rwy 14 heading toward the arpt for landing. One witness said the acft was at 300 to 400 ft AGL when the nose of the acft rose abruptly, the lt wing went down and the acft descended to the ground. Other…
- [NTSB ATL85FA182](https://openairdocs.org/ntsb/ATL85FA182.md): Piper PA-22-108 · Cartersville, GA · Accident · 2 fatal · Field investigation · Final report · Jun 6, 1985 · N5668Z · Destroyed
  > The circumstances & purpose of the flt was not determined. According to witnesses, the owner/student plt & another psn, who was a certified mechanic & an instructor plt, took off & entered what appeared to be a closed traffic pattern for rwy 18. The traffic…
- [NTSB MIA83FA145](https://openairdocs.org/ntsb/MIA83FA145.md): Piper PA-22 · Pompano Beach, FL · Accident · 1 fatal · Field investigation · Final report · May 23, 1983 · N8983C · Destroyed
  > The surviving pax stated that about 1 mi from the rwy their alt was 1,000 ft & 'lots of speed.' The plt was cleared to land on rwy 13. The plt then reported 'we go around again...' He was advised by the tower to make left traffic. He was then observed…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102202')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102202&occurrence=250

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