# NTSB investigations: Piper PA-22-150, 2017

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 CEN17FA315](https://openairdocs.org/ntsb/CEN17FA315.md): Piper PA 22-150 · Las Vegas, NM · Accident · 1 fatal · Field investigation · Final report · Aug 9, 2017 · N3664Z · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to land, which resulted in an accelerated stall and the pilot’s subsequent loss of control. Contributing to the accident was the gap in the pilot’s flight experience, his…
- [NTSB GAA17CA392](https://openairdocs.org/ntsb/GAA17CA392.md): Piper PA22 · Berlin, NH · Accident · No injuries · Data collection · Final report · Jul 5, 2017 · N6936B · Substantial damage
  > The pilot’s failure to maintain directional control during the landing roll.
- [NTSB GAA17CA377](https://openairdocs.org/ntsb/GAA17CA377.md): Piper PA 22-150 · Mammoth Lakes, CA · Accident · No injuries · Data collection · Final report · Jul 1, 2017 · N1737P · Substantial damage
  > The pilot’s failure to maintain directional control during the landing roll.
- [NTSB GAA17CA281](https://openairdocs.org/ntsb/GAA17CA281.md): Piper PA22 · South Boston, VA · Accident · No injuries · Data collection · Final report · May 15, 2017 · N31JP · Substantial damage
  > The pilot’s failure to maintain directional control during the landing roll.
- [NTSB WPR17LA088](https://openairdocs.org/ntsb/WPR17LA088.md): Piper PA 22-150 · Kernville, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 21, 2017 · N9975D · Substantial damage
  > The pilot’s exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/mush.
- [NTSB GAA17CA199](https://openairdocs.org/ntsb/GAA17CA199.md): Piper PA 22 · Scappoose, OR · Accident · No injuries · Data collection · Final report · Apr 4, 2017 · N7822D · Substantial damage
  > The student pilot’s loss of directional control during the landing roll and his subsequent inadvertent brake application, which resulted in a nose-over.
- [NTSB GAA17CA159](https://openairdocs.org/ntsb/GAA17CA159.md): Piper PA22 · Big Lake, AK · Accident · No injuries · Data collection · Final report · Feb 23, 2017 · N6024D · Substantial damage
  > The contamination of snow and ice on the left main landing gear and brake, which prevented the wheel from rolling during touchdown and resulted in a nose-over.
- [NTSB ERA17LA097](https://openairdocs.org/ntsb/ERA17LA097.md): Piper PA22 · Georgetown, DE · Accident · Minor injuries · Limited investigation · Final report · Jan 28, 2017 · N3659Z · Destroyed
  > An in-flight fire for reasons that could not be determined due to extensive thermal damage to the airplane.

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

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

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