# NTSB investigations, 2017, PR

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 ERA18LA002](https://openairdocs.org/ntsb/ERA18LA002.md): Cessna 182 · San Juan, PR · Accident · 1 fatal · Limited investigation · Final report · Oct 2, 2017 · N9021X · Substantial damage
  > The pilot's failure to maintain adequate distance from helicopters during the approach for landing, resulting in an encounter with wake turbulence and subsequent loss of control.
- [NTSB ERA17LA227](https://openairdocs.org/ntsb/ERA17LA227.md): Piper PA28 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Jul 4, 2017 · N9427J · Substantial damage
  > A partial loss of engine power during initial climb for reasons that could not be determined and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB ERA17FA195](https://openairdocs.org/ntsb/ERA17FA195.md): Piper PA23 · San Juan, PR · Accident · 1 fatal · Field investigation · Final report · Jun 3, 2017 · N21WW · Destroyed
  > The pilot's failure to maintain adequate airspeed, properly correct for left yaw, and his exceedance of the airplane's critical angle of attack during initial climb, which resulted in an aerodynamic stall and subsequent uncontrolled descent into water.
- [NTSB GAA17CA261](https://openairdocs.org/ntsb/GAA17CA261.md): Quicksilver Manufacturing SPORT2S R582 · Arecibo, PR · Accident · No injuries · Data collection · Final report · May 5, 2017 · N228KM · Substantial damage
  > The pilot’s failure to see and avoid trees during low-altitude flight.
- [NTSB ERA17LA126](https://openairdocs.org/ntsb/ERA17LA126.md): Eurocopter AS 350 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Feb 21, 2017 · N413LP · Substantial damage
  > The flight instructor's incorrect manipulations of the twist grip throttle control during a practice autorotation, which resulted in an engine overspeed and subsequent fire.

## 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") = 2017
  AND c."eventStateOrRegion" = 'PR' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?state=PR&year=2017

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