# NTSB investigations: Piper PA-11, OH

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 CEN16FA370](https://openairdocs.org/ntsb/CEN16FA370.md): Piper PA 11 · Arcanum, OH · Accident · 2 fatal · Field investigation · Final report · Sep 14, 2016 · N4910M · Substantial damage
  > The student pilot's reckless flying attitude and use of multiple psychoactive drugs, which likely impaired his ability to maintain clearance from terrain while maneuvering at low altitude.
- [NTSB CHI85LA190](https://openairdocs.org/ntsb/CHI85LA190.md): Piper PA-11-494 · Alliance, OH · Accident · No injuries · Limited investigation · Final report · May 7, 1985 · N4707H · Substantial damage
  > The acft approach was high and fast. The landing was made with 500-600 ft of runway remaining. The acft brakes were not sufficient to stop on the runway. The pilot added power and veered left off the end of the runway to avoid a heavily traveled road, the…
- [NTSB CHI75AC045](https://openairdocs.org/ntsb/CHI75AC045.md): Piper PA-11 · Brunswick, OH · Accident · 2 fatal · Closed · Dec 21, 1974 · N4703M · Destroyed
- [NTSB CHI67D0180](https://openairdocs.org/ntsb/CHI67D0180.md): Piper PA-11 · Avon, OH · Accident · No injuries · Closed · Jul 1, 1966 · N4703M · 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" = 'OH' 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 ('7101102', '7101106'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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