# NTSB investigations, PR: Airframe/component/system failure/malfunction

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 MIA05LA079](https://openairdocs.org/ntsb/MIA05LA079.md): Rockwell Aero Commander 500 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Mar 12, 2005 · N8498C · Substantial damage
  > The failure of the pilot to follow the emergency checklist and his inadvertent operation of the airplane with known discrepancies resulting in landing overrun and on-ground collision with a ditch during the landing roll.
- [NTSB NYC04FA223](https://openairdocs.org/ntsb/NYC04FA223.md): Aero Commander 112 · Vieques, PR · Accident · 1 fatal · Field investigation · Final report · Feb 16, 2004 · N1261J · Substantial damage
  > The pilot's inadequate preflight and in-flight planning and decision making which resulted in the airplane entering instrument meteorological conditions. Contributing to the accident was the pilot's lack of instrument experience, a vacuum pump failure, and…
- [NTSB MIA02LA051](https://openairdocs.org/ntsb/MIA02LA051.md): Cessna 172P · Levittown, PR · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 2002 · N99295 · Substantial damage
  > the failure of maintenance personnel to comply with aircraft manufacturer's inspection procedures, resulting in corrosion and separation of the aileron control cable in flight and the subsequent forced landing in a swamp.
- [NTSB MIA99TA206](https://openairdocs.org/ntsb/MIA99TA206.md): Hughes OH-6A · Aguadilla, PR · Accident · No injuries · Final report · Jul 29, 1999 · N66377 · Substantial damage
  > An unidentified foreign object passing through the oil cooler blower assembly resulting in fracture and seizure of the oil cooler blower, and slowing of the main transmission and main rotor, which resulted in the pilot being unable to arrest the descent…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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