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

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 GAA18CA418](https://openairdocs.org/ntsb/GAA18CA418.md): Piper PA28R · Houston, TX · Accident · No injuries · Data collection · Final report · Jul 10, 2018 · N7716C · Substantial damage
  > The pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to ensure that the landing gear were extended during landing. Contributing to the accident was the pilot receiving instruction's and instructor's failure…
- [NTSB ERA18FA137](https://openairdocs.org/ntsb/ERA18FA137.md): Piper PA28R · Gainesville, GA · Accident · 1 fatal · Field investigation · Final report · Apr 28, 2018 · N4363F · Substantial damage
  > A partial loss of engine power due to inadequate thru-bolt and stud preload tension by undetermined maintenance personnel, which resulted in fretting between the engine crankcase halves, and the subsequent separation of the No. 2 cylinder due to the fatigue…
- [NTSB GAA18CA589](https://openairdocs.org/ntsb/GAA18CA589.md): Piper PA28R · Camarillo, CA · Accident · No injuries · Data collection · Final report · Apr 23, 2018 · N9368N · Substantial damage
  > The flight instructor's improper landing flare, which resulted in a hard landing.
- [NTSB WPR18LA101](https://openairdocs.org/ntsb/WPR18LA101.md): Piper PA28R · Paso Robles, CA · Accident · No injuries · Class 3 · Limited · Final report · Mar 7, 2018 · N33807 · Substantial damage
  > The pilots' inadequate preflight inspection, which failed to ensure that the oil filler cap was secured and resulted in oil starvation and a total loss of engine power.
- [NTSB GAA18CA145](https://openairdocs.org/ntsb/GAA18CA145.md): Piper PA28R · Milton-Freewater, OR · Accident · No injuries · Data collection · Final report · Feb 28, 2018 · N323MQ · Substantial damage
  > The pilot receiving instruction’s and flight instructor’s improper decision to enter a canyon surrounded by steep rising terrain and their subsequent failure to maintain clearance from terrain while maneuvering at a low altitude.

## 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") = 2018
  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=2018

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