# NTSB investigations: Cessna 172M, 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 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 ERA12CA211](https://openairdocs.org/ntsb/ERA12CA211.md): Cessna 172M · Mayaquez, PR · Accident · No injuries · Data collection · Final report · Feb 19, 2012 · N5286H · Substantial damage
  > The pilot did not maintain control of the airplane while landing in crosswind conditions.
- [NTSB MIA02LA031](https://openairdocs.org/ntsb/MIA02LA031.md): Cessna 172M · Barceloneta, PR · Accident · Minor injuries · Limited investigation · Final report · Nov 23, 2001 · N61582 · Substantial damage
  > The pilot's failure to maintain control of the aircraft which resulted in an uncontrolled descent and an in flight collision with water. Contributing to the accident was the impairment of the pilot due to alcohol.
- [NTSB MIA79FA082](https://openairdocs.org/ntsb/MIA79FA082.md): Cessna 172M · San Juan, PR · Accident · 4 fatal · Closed · May 13, 1979 · N707AC · Destroyed
- [NTSB MIA79FKA01](https://openairdocs.org/ntsb/MIA79FKA01.md): Cessna 172 · San Juan, PR · Accident · Serious injuries · Closed · Oct 25, 1978 · N61567 · Substantial damage

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

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