# NTSB investigations: Piper PA-28R-201, 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 GAA17CA425](https://openairdocs.org/ntsb/GAA17CA425.md): Piper PA28R · Bowling Green, OH · Accident · No injuries · Data collection · Final report · Jul 18, 2017 · N786BG · Substantial damage
  > The pilot’s and flight instructor’s failure to extend the landing gear.
- [NTSB CEN16LA374](https://openairdocs.org/ntsb/CEN16LA374.md): Piper PA-28R-201 · Bowling Green, OH · Accident · No injuries · Limited investigation · Final report · Sep 13, 2016 · N786BG · Substantial damage
  > The pilots’ failure to complete the Emergency Landing Gear Extension checklist and maintenance personnel’s failure to correctly repair spliced wires on the left main landing gear down limit switch, which prevented the pilots from knowing whether the gear was…
- [NTSB ATL87LA164](https://openairdocs.org/ntsb/ATL87LA164.md): Piper PA-28R-201 · Unity, OH · Accident · No injuries · Limited investigation · Final report · Jun 9, 1987 · N3965M · Substantial damage
  > The CFI reported that he reduced pwr to near idle with the throttle, to have his student practice a simulated forced ldg. The engine subsequently lost pwr completely at about 400-500 ft AGL when he attempted to add pwr back so that the student could initiate…

## 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 ('7102816', '7102833'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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