# Fatal NTSB investigations: Lycoming 0-320 series, 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 ERA15FA096](https://openairdocs.org/ntsb/ERA15FA096.md): Robinson Helicopter R22 Beta · Catano, PR · Accident · 1 fatal · Field investigation · Final report · Jan 10, 2015 · N348VH · Destroyed
  > The student pilot’s failure to maintain rotor rpm while maneuvering in the airport traffic pattern, which resulted in the helicopter’s uncontrolled descent to the water. Contributing to the accident was the student’s distraction with other aircraft operating…
- [NTSB ERA12FA484](https://openairdocs.org/ntsb/ERA12FA484.md): Cessna 172M · San Juan, PR · Accident · 1 fatal · Field investigation · Final report · Jul 25, 2012 · N73115 · Substantial damage
  > Maintenance personnel’s improper lubrication of the right direct aileron control cable and failure to detect the severe corrosion of the cable during a maintenance inspection, which resulted in the in-flight failure of the cable, the pilot’s subsequent…
- [NTSB MIA81FA001](https://openairdocs.org/ntsb/MIA81FA001.md): Piper PA-28 · Aguadilla, PR · Accident · 4 fatal · Closed · Oct 10, 1980 · N707XQ · Destroyed
- [NTSB MIA79FA082](https://openairdocs.org/ntsb/MIA79FA082.md): Cessna 172M · San Juan, PR · Accident · 4 fatal · Closed · May 13, 1979 · N707AC · Destroyed
- [NTSB MIA71AM070](https://openairdocs.org/ntsb/MIA71AM070.md): Piper PA-28 · Aguadilla, PR · Accident · 3 fatal · Closed · Feb 7, 1971 · N3680K · Destroyed
- [NTSB MIA68A0002](https://openairdocs.org/ntsb/MIA68A0002.md): Piper PA-28 · Mayaguez, PR · Accident · 4 fatal · Closed · Jul 2, 1967 · N5100W · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?engine=41508&fatal=1&state=PR

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