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

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 WPR12CA401](https://openairdocs.org/ntsb/WPR12CA401.md): Piper PA-22-108 · Lewiston, ID · Accident · No injuries · Data collection · Final report · Sep 4, 2012 · N4798Z · Substantial damage
  > The pilot’s inadequate postmaintenance and preflight inspections, which resulted in the separation of the left main wheel after takeoff. Contributing to the accident was the improperly secured left main wheel spindle nut.
- [NTSB SEA75DYA38](https://openairdocs.org/ntsb/SEA75DYA38.md): Piper PA-22 · Gooding, ID · Accident · No injuries · Closed · May 3, 1975 · N4626Z · Substantial damage
- [NTSB SEA71DWG35](https://openairdocs.org/ntsb/SEA71DWG35.md): Piper PA-22 · Hayden Lake, ID · Accident · No injuries · Closed · Dec 12, 1970 · N5372Z · Substantial damage
- [NTSB SEA70DXM01](https://openairdocs.org/ntsb/SEA70DXM01.md): Piper PA-22 · Baker, ID · Accident · No injuries · Closed · Jan 8, 1970 · N4807Z · Substantial damage
- [NTSB SEA69D0145](https://openairdocs.org/ntsb/SEA69D0145.md): Piper PA-22 · Leadore, ID · Accident · No injuries · Closed · Nov 28, 1968 · N4807Z · Substantial damage
- [NTSB SEA66D0279](https://openairdocs.org/ntsb/SEA66D0279.md): Piper PA-22 · Boise, ID · Accident · No injuries · Closed · May 30, 1966 · N5368Z · Substantial damage
- [NTSB UNK64X1818](https://openairdocs.org/ntsb/UNK64X1818.md): Piper PA22 · Blackfoot, ID · Accident · No injuries · Closed · May 18, 1964 · N5002Z · 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" = 'ID' 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 ('7102204'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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