# NTSB investigations: Piper PA-28R-200, 2012

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 ERA13LA097](https://openairdocs.org/ntsb/ERA13LA097.md): Piper PA-28R-200 · Lock Haven, PA · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 2012 · N2074T · Substantial damage
  > The reinstallation of improper connecting rods at engine overhaul, which resulted in abnormal wear of the connecting rod bearings; while the bearings did not meet the manufacturer’s specifications, the use of the unapproved connecting rods more likely caused…
- [NTSB CEN12CA671](https://openairdocs.org/ntsb/CEN12CA671.md): Piper PA-28R-200 · Goldsby, OK · Accident · No injuries · Data collection · Final report · Aug 29, 2012 · N7602C · Substantial damage
  > The commercial pilot did not attain the proper touchdown point during the landing, which resulted in a premature touchdown and an impact with the edge of the runway surface.
- [NTSB WPR12LA377](https://openairdocs.org/ntsb/WPR12LA377.md): Piper PA-28R-200 · Everett, WA · Accident · No injuries · Limited investigation · Final report · Aug 28, 2012 · N4922T · Substantial damage
  > A hard landing likely made by the private pilot on a solo flight that preceded the dual instructional flight during which the wing damage became obvious.
- [NTSB CEN12IA377](https://openairdocs.org/ntsb/CEN12IA377.md): Piper PA-28R-200 · Lacon, IL · Incident · No injuries · Incident investigation · Final report · Jun 18, 2012 · N4350T · Minor damage
  > The propeller blade’s failure due to a fatigue crack that originated from a surface gouge that resulted from foreign object damage to the propeller blade that occurred at an unknown time.
- [NTSB ERA12LA267](https://openairdocs.org/ntsb/ERA12LA267.md): Piper PA-28R-200 · Eastover, SC · Accident · No injuries · Limited investigation · Final report · Apr 3, 2012 · N961JD · Substantial damage
  > Inadequate or loss of through bolt preload tension, which resulted in fretting between the engine halves, the subsequent failure of one cylinder through bolt, the loosening of additional cylinder retaining studs, and the fracture of the crankcase.…
- [NTSB ERA12CA242](https://openairdocs.org/ntsb/ERA12CA242.md): Piper PA-28R-200 · New Smyrna, FL · Accident · No injuries · Data collection · Final report · Mar 18, 2012 · N15764 · Substantial damage
  > The pilot's improper flare, which resulted in a hard landing. Contributing to the accident was the flight instructor's inadequate remedial action.
- [NTSB CEN12LA189](https://openairdocs.org/ntsb/CEN12LA189.md): Piper PA-28R-200 · Arcola, TX · Accident · No injuries · Limited investigation · Final report · Mar 18, 2012 · N56273 · Substantial damage
  > The pilot did not maintain adequate crosswind correction during the landing flare and the flight instructor's delayed remedial action.

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

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

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