# NTSB investigations: Piper PA-18A, 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 WPR17LA102](https://openairdocs.org/ntsb/WPR17LA102.md): Piper PA 18A · Coeur D'Alene, ID · Accident · Minor injuries · Limited investigation · Final report · May 8, 2017 · N245KW · Substantial damage
  > The loss of yaw control due to an inadequately compressed rudder swage, which resulted from inadequate maintenance and led to the separation of the forward right rudder cable.
- [NTSB SEA89LA023](https://openairdocs.org/ntsb/SEA89LA023.md): Piper PA-18A · Murphy, ID · Accident · No injuries · Limited investigation · Final report · Nov 11, 1988 · N8562C · Substantial damage
  > While making a low pass over a snow-covered airstrip, the plt misjudged his altitude. The aircraft's main gear made contact with six inch deep snow, & after traveling aprx 100 ft, the plane nosed over.
- [NTSB SEA83LA145](https://openairdocs.org/ntsb/SEA83LA145.md): Piper PA-18-125 · Fort Hall, ID · Accident · No injuries · Limited investigation · Final report · Jun 25, 1983 · N1144A · Substantial damage
  > The acft nosed over during a forced landing after a power loss. The pilot stated that during a descent to an arpt the engine suddenly lost power. Emergency start procedures failed and a forced landing was made in a grain field. During roll out the acft nosed…
- [NTSB SEA76DYA22](https://openairdocs.org/ntsb/SEA76DYA22.md): Piper PA-18 · Idaho Falls, ID · Accident · No injuries · Closed · Jan 25, 1976 · N3707A · Substantial damage
- [NTSB SEA74DYA08](https://openairdocs.org/ntsb/SEA74DYA08.md): Piper PA-18A · Mud Lake, ID · Accident · No injuries · Closed · Aug 13, 1973 · N3707A · Substantial damage
- [NTSB SEA72DYA11](https://openairdocs.org/ntsb/SEA72DYA11.md): Piper PA-18 · Burley, ID · Accident · No injuries · Closed · Aug 21, 1971 · N8562C · Substantial damage
- [NTSB SEA69D0269](https://openairdocs.org/ntsb/SEA69D0269.md): Piper PA-18A · Grasmere, ID · Accident · No injuries · Closed · Jun 14, 1969 · N2891P · Substantial damage
- [NTSB SEA68D0221](https://openairdocs.org/ntsb/SEA68D0221.md): Piper PA-18 · Preston, ID · Accident · No injuries · Closed · Dec 10, 1967 · N1148A · Substantial damage
- [NTSB SEA67A0072](https://openairdocs.org/ntsb/SEA67A0072.md): Piper PA-18 · Parma, ID · Accident · 2 fatal · Closed · Jun 10, 1967 · N2879P · Destroyed
- [NTSB SEA66F0155](https://openairdocs.org/ntsb/SEA66F0155.md): Piper PA18A · Homedale, ID · Accident · Serious injuries · Closed · Oct 31, 1965 · N7195D · Substantial damage
- [NTSB SEA66F0020](https://openairdocs.org/ntsb/SEA66F0020.md): Piper PA-18A · Burley, ID · Accident · Minor injuries · Closed · Jul 13, 1965 · N4874A · Destroyed
- [NTSB SEA66F0096](https://openairdocs.org/ntsb/SEA66F0096.md): Piper PA-18A · Copeland, ID · Accident · No injuries · Closed · Jun 24, 1965 · N1987P · Substantial damage
- [NTSB UNK64X2844](https://openairdocs.org/ntsb/UNK64X2844.md): Piper PA18 · Garden Valley, ID · Accident · No injuries · Closed · Jul 15, 1964 · N7195D · 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 ('7101804', '7102831'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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