# NTSB investigations, 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.

Page 8 of 9 · 409 cases

## Cases, newest first

- [NTSB MIA66F0251](https://openairdocs.org/ntsb/MIA66F0251.md): Cessna 172E · Cabo Rojo, PR · Accident · Minor injuries · Closed · Oct 10, 1965 · N5462T · Substantial damage
- [NTSB MIA66F0247](https://openairdocs.org/ntsb/MIA66F0247.md): Champion 7FC · Cabo Rojo, PR · Accident · No injuries · Closed · Sep 22, 1965 · N8909R · Substantial damage
- [NTSB MIA66F0221](https://openairdocs.org/ntsb/MIA66F0221.md): Beechcraft Dumod · San Juan, PR · Accident · No injuries · Closed · Sep 21, 1965 · N496DM · Substantial damage
- [NTSB MIA66D0201](https://openairdocs.org/ntsb/MIA66D0201.md): Piper PA-22 · Guayama, PR · Accident · No injuries · Closed · Sep 6, 1965 · N5817Z · Substantial damage
- [NTSB MIA66F0237](https://openairdocs.org/ntsb/MIA66F0237.md): Piper PA-23 · San Juan, PR · Accident · No injuries · Closed · Aug 23, 1965 · N4325Y · Substantial damage
- [NTSB MIA66F0183](https://openairdocs.org/ntsb/MIA66F0183.md): Piper PA-24 · Coloso, PR · Accident · No injuries · Closed · Aug 15, 1965 · N7330P · Substantial damage
- [NTSB MIA66F0154](https://openairdocs.org/ntsb/MIA66F0154.md): Mooney M21 · Arecibo, PR · Accident · No injuries · Closed · Aug 13, 1965 · N6840U · Substantial damage
- [NTSB MIA66F0207](https://openairdocs.org/ntsb/MIA66F0207.md): Beechcraft P-35 · Arecibo, PR · Accident · No injuries · Closed · Jul 20, 1965 · N1489G · Substantial damage
- [NTSB MIA66A0013](https://openairdocs.org/ntsb/MIA66A0013.md): Cessna 170B · Corozal, PR · Accident · 1 fatal · Closed · Jul 20, 1965 · N2860C · Destroyed
- [NTSB MIA66F0137](https://openairdocs.org/ntsb/MIA66F0137.md): Cessna 205 · Fajardo, PR · Accident · No injuries · Closed · Jul 4, 1965 · N8131Z · Substantial damage
- [NTSB MIA66F0151](https://openairdocs.org/ntsb/MIA66F0151-176530.md): Beechcraft C-45H · Mercedita, PR · Accident · No injuries · Closed · Jul 1, 1965 · N496DM · Substantial damage
- [NTSB MIA66F0058](https://openairdocs.org/ntsb/MIA66F0058.md): Beechcraft C45H · San Juan, PR · Accident · No injuries · Closed · Jun 30, 1965 · N494DM · Substantial damage
- [NTSB MIA65A0118](https://openairdocs.org/ntsb/MIA65A0118.md): Hughes 269B · Anasco, PR · Accident · No injuries · Closed · Jun 12, 1965 · N9395F · Substantial damage
- [NTSB MIA66F0036](https://openairdocs.org/ntsb/MIA66F0036.md): De Haviland 114-2A · Ponce, PR · Accident · No injuries · Closed · Jun 4, 1965 · N3999A · Substantial damage
- [NTSB MIA65D0093](https://openairdocs.org/ntsb/MIA65D0093.md): Cessna 172 · Vieques Is, PR · Accident · No injuries · Closed · May 4, 1965 · N5408T · Substantial damage
- [NTSB MIA65A0109](https://openairdocs.org/ntsb/MIA65A0109.md): Convair CV-340 · Ponce, PR · Accident · No injuries · Closed · Apr 27, 1965 · N3412 · Substantial damage
- [NTSB MIA65F0072](https://openairdocs.org/ntsb/MIA65F0072.md): Hiller UH12 · Guaynabo, PR · Accident · Minor injuries · Closed · Apr 26, 1965 · N9795C · Substantial damage
- [NTSB MIA66F0009](https://openairdocs.org/ntsb/MIA66F0009.md): Cessna 310F · Vieques Island, PR · Accident · No injuries · Closed · Apr 15, 1965 · N6763X · Substantial damage
- [NTSB MIA65A0110](https://openairdocs.org/ntsb/MIA65A0110.md): Hughes 269B · Lares, PR · Accident · No injuries · Closed · Apr 3, 1965 · N9395F · Substantial damage
- [NTSB MIA65A0096](https://openairdocs.org/ntsb/MIA65A0096.md): Piper PA-22 · Caguas, PR · Accident · 3 fatal · Closed · Mar 27, 1965 · N9518D · Destroyed
- [NTSB MIA65F0035](https://openairdocs.org/ntsb/MIA65F0035.md): Beechcraft C45H · San Juan, PR · Accident · No injuries · Closed · Mar 26, 1965 · N494DM · Substantial damage
- [NTSB MIA65A0094](https://openairdocs.org/ntsb/MIA65A0094.md): Hiller UH12E · San Sebastian, PR · Accident · No injuries · Closed · Mar 26, 1965 · N5363V · Substantial damage
- [NTSB MIA65F0128](https://openairdocs.org/ntsb/MIA65F0128.md): Piper PA-25 · Cabo Rojo, PR · Accident · No injuries · Closed · Mar 16, 1965 · N6878Z · Substantial damage
- [NTSB MIA65F0014](https://openairdocs.org/ntsb/MIA65F0014.md): Beechcraft C-18S · San Juan, PR · Accident · Minor injuries · Closed · Feb 15, 1965 · N8025H · Substantial damage
- [NTSB UNK65X1309](https://openairdocs.org/ntsb/UNK65X1309.md): Beechcraft C18S · Mayaguez, PR · Accident · No injuries · Closed · Jan 18, 1965 · N65432 · Substantial damage
- [NTSB MIA65A0073](https://openairdocs.org/ntsb/MIA65A0073.md): Douglas DC-8 · San Juan, PR · Accident · No injuries · Closed · Jan 8, 1965 · N8781 · Substantial damage
- [NTSB MIA65D0013](https://openairdocs.org/ntsb/MIA65D0013.md): Beechraft F35 · Ponce, PR · Accident · No injuries · Closed · Dec 30, 1964 · N3365C · Substantial damage
- [NTSB UNK65X1097](https://openairdocs.org/ntsb/UNK65X1097.md): Hughes 269A · Cortada, PR · Accident · Minor injuries · Closed · Dec 22, 1964 · N9383F · Substantial damage
- [NTSB UNK65X0957](https://openairdocs.org/ntsb/UNK65X0957.md): Piper PA23 · San Juan, PR · Accident · No injuries · Closed · Dec 9, 1964 · N4082P · Substantial damage
- [NTSB UNK65X0910](https://openairdocs.org/ntsb/UNK65X0910.md): Piper PA23 · San Juan, PR · Accident · No injuries · Closed · Dec 3, 1964 · N3473P · Substantial damage
- [NTSB UNK65X0751](https://openairdocs.org/ntsb/UNK65X0751.md): Beechcraft F35 · Arecibo, PR · Accident · No injuries · Closed · Nov 18, 1964 · N3327C · Substantial damage
- [NTSB UNK65X0651](https://openairdocs.org/ntsb/UNK65X0651.md): Cessna 150 · Ramey Afb, PR · Accident · No injuries · Closed · Nov 11, 1964 · N4275U · Substantial damage
- [NTSB UNK65X0627](https://openairdocs.org/ntsb/UNK65X0627.md): Mooney M21 · Fajardo, PR · Accident · No injuries · Closed · Nov 9, 1964 · N7102U · Substantial damage
- [NTSB UNK65X0569](https://openairdocs.org/ntsb/UNK65X0569.md): Beechcraft C45G · Fajardo, PR · Accident · No injuries · Closed · Nov 5, 1964 · N161U · Substantial damage
- [NTSB UNK65X0552](https://openairdocs.org/ntsb/UNK65X0552.md): Piper PA28 · Mayaguez, PR · Accident · No injuries · Closed · Nov 4, 1964 · N6051W · Substantial damage
- [NTSB UNK65X0315](https://openairdocs.org/ntsb/UNK65X0315.md): Cessna 150 · Las Piedras, PR · Accident · Closed · Oct 18, 1964 · N7995Z · Destroyed
- [NTSB UNK64X4128](https://openairdocs.org/ntsb/UNK64X4128.md): Ercoupe E · Vieques, PR · Accident · No injuries · Closed · Sep 24, 1964 · N94822 · Substantial damage
- [NTSB UNK64X4120](https://openairdocs.org/ntsb/UNK64X4120.md): Douglas DC-8 · San Juan, PR · Accident · No injuries · Closed · Sep 23, 1964 · N8612 · No damage
- [NTSB UNK64X4104](https://openairdocs.org/ntsb/UNK64X4104.md): Douglas DC-3 · San Juan, PR · Accident · No injuries · Closed · Sep 22, 1964 · N1549V · Substantial damage
- [NTSB UNK64X4058](https://openairdocs.org/ntsb/UNK64X4058.md): Champion 7FC · Humacao, PR · Accident · Minor injuries · Closed · Sep 20, 1964 · N8915R · Substantial damage
- [NTSB UNK64X4043](https://openairdocs.org/ntsb/UNK64X4043.md): Convair CV-340 · San Juan, PR · Incident · No injuries · Closed · Sep 19, 1964 · N3410 · No damage
- [NTSB UNK64X4027](https://openairdocs.org/ntsb/UNK64X4027.md): Piper PA28 · Parguera, PR · Accident · Minor injuries · Closed · Sep 17, 1964 · N7038W · Destroyed
- [NTSB UNK64X3327](https://openairdocs.org/ntsb/UNK64X3327.md): Piper PA22 · Yabucoa, PR · Accident · No injuries · Closed · Aug 11, 1964 · N5899Z · Substantial damage
- [NTSB UNK64X2730](https://openairdocs.org/ntsb/UNK64X2730.md): Piper PA22 · Roosevelt Rds, PR · Accident · No injuries · Closed · Jul 9, 1964 · N3815P · Destroyed
- [NTSB UNK64X2721](https://openairdocs.org/ntsb/UNK64X2721.md): Hiller 12E · San Juan, PR · Accident · No injuries · Closed · Jul 8, 1964 · N5386V · Substantial damage
- [NTSB UNK64X2515](https://openairdocs.org/ntsb/UNK64X2515.md): Beechcraft K35 · San Juan, PR · Accident · No injuries · Closed · Jun 27, 1964 · N555E · Substantial damage
- [NTSB UNK64X2441](https://openairdocs.org/ntsb/UNK64X2441.md): Piper PA22 · San German, PR · Accident · No injuries · Closed · Jun 23, 1964 · N5915Z · Substantial damage
- [NTSB UNK64X2275](https://openairdocs.org/ntsb/UNK64X2275.md): Boeing 707 121 · San Juan, PR · Incident · Minor injuries · Closed · Jun 14, 1964 · N778PA · Minor damage
- [NTSB UNK64X2055](https://openairdocs.org/ntsb/UNK64X2055.md): Piper PA28 · Lobos Island, PR · Accident · No injuries · Closed · May 31, 1964 · N7038W · Substantial damage
- [NTSB UNK64X1943](https://openairdocs.org/ntsb/UNK64X1943.md): Beechcraft 23 · Lobos Island, PR · Accident · No injuries · Closed · May 24, 1964 · N8733M · Substantial damage

Next page: https://openairdocs.org/ntsb.md?state=PR&page=9

## 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'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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