# 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 7 of 9 · 409 cases

## Cases, newest first

- [NTSB MIA68D0434](https://openairdocs.org/ntsb/MIA68D0434.md): Cessna 172 · Isabela, PR · Accident · Minor injuries · Closed · Feb 23, 1968 · N2670U · Substantial damage
- [NTSB MIA68D0382](https://openairdocs.org/ntsb/MIA68D0382.md): Cessna 150 · Yabucoa, PR · Accident · No injuries · Closed · Jan 27, 1968 · N6412S · Substantial damage
- [NTSB MIA68F0415](https://openairdocs.org/ntsb/MIA68F0415.md): Cessna 150 · Humacao, PR · Accident · No injuries · Closed · Jan 19, 1968 · N4108U · Substantial damage
- [NTSB MIA68F0352](https://openairdocs.org/ntsb/MIA68F0352.md): Piper PA-28 · Mayaguez, PR · Accident · Minor injuries · Closed · Jan 3, 1968 · N9447J · Substantial damage
- [NTSB MIA68A0055](https://openairdocs.org/ntsb/MIA68A0055.md): Dehavilland 114 · Mayaguez, PR · Accident · No injuries · Closed · Dec 20, 1967 · N13663 · Substantial damage
- [NTSB MIA68F0333](https://openairdocs.org/ntsb/MIA68F0333.md): Cessna 206 · Toa Baja, PR · Accident · No injuries · Closed · Dec 17, 1967 · N4650F · Substantial damage
- [NTSB MIA68F0279](https://openairdocs.org/ntsb/MIA68F0279.md): Piper PA-32 · Humacao, PR · Accident · No injuries · Closed · Nov 12, 1967 · N4041W · Destroyed
- [NTSB MIA68D0217](https://openairdocs.org/ntsb/MIA68D0217.md): Piper PA-22 · San Juan, PR · Accident · No injuries · Closed · Oct 14, 1967 · N5611Z · Substantial damage
- [NTSB MIA68A0034](https://openairdocs.org/ntsb/MIA68A0034.md): Cessna 172 · Isle Culebra, PR · Accident · 2 fatal · Closed · Oct 8, 1967 · N8372U · Destroyed
- [NTSB MIA68F0214](https://openairdocs.org/ntsb/MIA68F0214.md): Piper PA-23 · Dorado Beach, PR · Accident · No injuries · Closed · Oct 3, 1967 · N377DW · Substantial damage
- [NTSB MIA68F0218](https://openairdocs.org/ntsb/MIA68F0218.md): Piper PA-22 · Humacao, PR · Accident · No injuries · Closed · Sep 23, 1967 · N5278Z · Substantial damage
- [NTSB MIA68D0215](https://openairdocs.org/ntsb/MIA68D0215.md): Beech B35 · Fajardo, PR · Accident · No injuries · Closed · Sep 11, 1967 · N5129C · Destroyed
- [NTSB MIA68F0160](https://openairdocs.org/ntsb/MIA68F0160.md): Cessna 172 · Salinas, PR · Accident · No injuries · Closed · Sep 6, 1967 · N2160Y · Substantial damage
- [NTSB MIA68F0158](https://openairdocs.org/ntsb/MIA68F0158.md): Piper PA-25 · Vega Baja, PR · Accident · No injuries · Closed · Aug 21, 1967 · N13314 · Substantial damage
- [NTSB MIA68A0012](https://openairdocs.org/ntsb/MIA68A0012.md): Champion 7ECA · Vega Baja, PR · Accident · Minor injuries · Closed · Jul 25, 1967 · N9671S · Destroyed
- [NTSB MIA68A0007](https://openairdocs.org/ntsb/MIA68A0007.md): Beech C-45H · Ponce, PR · Accident · No injuries · Closed · Jul 13, 1967 · N9978Z · Substantial damage
- [NTSB MIA68F0057](https://openairdocs.org/ntsb/MIA68F0057.md): Cessna 310 · San Juan, PR · Accident · No injuries · Closed · Jul 5, 1967 · N2668C · Substantial damage
- [NTSB MIA68A0002](https://openairdocs.org/ntsb/MIA68A0002.md): Piper PA-28 · Mayaguez, PR · Accident · 4 fatal · Closed · Jul 2, 1967 · N5100W · Destroyed
- [NTSB MIA67A0127](https://openairdocs.org/ntsb/MIA67A0127.md): Hughes 269B · San Sebastian, PR · Accident · No injuries · Closed · May 31, 1967 · N9395F · Substantial damage
- [NTSB MIA67D0533](https://openairdocs.org/ntsb/MIA67D0533.md): Cessna 150 · Guanica, PR · Accident · No injuries · Closed · May 9, 1967 · N3159X · Substantial damage
- [NTSB MIA67F0500](https://openairdocs.org/ntsb/MIA67F0500.md): Cessna 150 · San Juan, PR · Accident · No injuries · Closed · Apr 28, 1967 · N8470G · Substantial damage
- [NTSB MIA67F0493](https://openairdocs.org/ntsb/MIA67F0493.md): Piper PA-23 · Isabel Segunda, PR · Accident · No injuries · Closed · Apr 28, 1967 · N5632Y · Substantial damage
- [NTSB MIA67A0112](https://openairdocs.org/ntsb/MIA67A0112.md): Convair 640D · San Juan, PR · Accident · Minor injuries · Closed · Apr 25, 1967 · N3420 · Substantial damage
- [NTSB MIA67A0107](https://openairdocs.org/ntsb/MIA67A0107.md): Beech C-45G · Arecibo, PR · Accident · No injuries · Closed · Mar 19, 1967 · N9470Z · Destroyed
- [NTSB MIA67F0425](https://openairdocs.org/ntsb/MIA67F0425.md): Piper PA-28 · Fajardo, PR · Accident · Minor injuries · Closed · Mar 1, 1967 · N8080W · Substantial damage
- [NTSB MIA67D0397](https://openairdocs.org/ntsb/MIA67D0397.md): Cessna 172 · Cabo Rojo, PR · Accident · No injuries · Closed · Feb 18, 1967 · N7824X · Substantial damage
- [NTSB MIA67F0361](https://openairdocs.org/ntsb/MIA67F0361.md): Piper PA-28 · San Juan, PR · Accident · No injuries · Closed · Jan 23, 1967 · N6351R · Substantial damage
- [NTSB MIA67A0080](https://openairdocs.org/ntsb/MIA67A0080.md): Convair 640 · San Juan, PR · Accident · Minor injuries · Closed · Jan 23, 1967 · N3408 · Substantial damage
- [NTSB MIA67F0370](https://openairdocs.org/ntsb/MIA67F0370.md): Piper PA-28 · Arecibo, PR · Accident · No injuries · Closed · Jan 15, 1967 · N9439J · Substantial damage
- [NTSB MIA67F0354](https://openairdocs.org/ntsb/MIA67F0354.md): Piper PA-32 · San Juan, PR · Accident · Minor injuries · Closed · Dec 29, 1966 · N3712W · Substantial damage
- [NTSB MIA67F0325](https://openairdocs.org/ntsb/MIA67F0325.md): Beech D18S · San Juan, PR · Accident · No injuries · Closed · Dec 20, 1966 · N703D · Substantial damage
- [NTSB MIA67D0318](https://openairdocs.org/ntsb/MIA67D0318.md): Dehavilland 114 · San Juan, PR · Accident · No injuries · Closed · Nov 23, 1966 · N3999A · Substantial damage
- [NTSB MIA67D0240](https://openairdocs.org/ntsb/MIA67D0240.md): Beech 95 · Salinas, PR · Accident · No injuries · Closed · Oct 24, 1966 · N2711V · Substantial damage
- [NTSB MIA67F0249](https://openairdocs.org/ntsb/MIA67F0249.md): Cessna 180 · San Juan, PR · Accident · No injuries · Closed · Oct 20, 1966 · N4610A · Substantial damage
- [NTSB MIA67F0236](https://openairdocs.org/ntsb/MIA67F0236.md): Piper PA-30 · San Juan, PR · Accident · No injuries · Closed · Oct 7, 1966 · N7446Y · Substantial damage
- [NTSB MIA67A0019](https://openairdocs.org/ntsb/MIA67A0019.md): Dehavilland 114 · San Juan, PR · Accident · Minor injuries · Closed · Aug 3, 1966 · N4789C · Substantial damage
- [NTSB MIA67A0017](https://openairdocs.org/ntsb/MIA67A0017.md): Cessna 205 · Culebra, PR · Accident · Minor injuries · Closed · Jul 26, 1966 · N8405Z · Substantial damage
- [NTSB MIA67F0120](https://openairdocs.org/ntsb/MIA67F0120.md): Piper PA-30 · San Juan, PR · Accident · No injuries · Closed · Jul 17, 1966 · N7298Y · Substantial damage
- [NTSB MIA66A0006](https://openairdocs.org/ntsb/MIA66A0006-171668.md): Hughes 269B · Arecibo, PR · Accident · No injuries · Closed · Jul 13, 1966 · N9395F · Substantial damage
- [NTSB MIA66D0631](https://openairdocs.org/ntsb/MIA66D0631.md): Cessna 150 · Humacao, PR · Accident · No injuries · Closed · Jun 20, 1966 · N4108U · Substantial damage
- [NTSB MIA66D0613](https://openairdocs.org/ntsb/MIA66D0613.md): Aeronca 7ECA · Manati, PR · Accident · No injuries · Closed · Jun 9, 1966 · N2531F · Substantial damage
- [NTSB MIA66A0141](https://openairdocs.org/ntsb/MIA66A0141.md): Hughes 269B · Anasco, PR · Accident · No injuries · Closed · Jun 8, 1966 · N9407F · Substantial damage
- [NTSB MIA67F0019](https://openairdocs.org/ntsb/MIA67F0019.md): Beech 95-B55 · Arecibo, PR · Accident · No injuries · Closed · May 3, 1966 · N351RR · Substantial damage
- [NTSB MIA66F0524](https://openairdocs.org/ntsb/MIA66F0524.md): Cessna 150 · San Juan, PR · Accident · No injuries · Closed · Apr 18, 1966 · N8831S · Destroyed
- [NTSB MIA66A0110](https://openairdocs.org/ntsb/MIA66A0110.md): Air Space 18A · Santa Isabel, PR · Accident · Minor injuries · Closed · Mar 20, 1966 · N6112S · Destroyed
- [NTSB MIA66A0105](https://openairdocs.org/ntsb/MIA66A0105.md): Cessna 310F · San Juan, PR · Accident · No injuries · Closed · Mar 13, 1966 · N6763X · Substantial damage
- [NTSB MIA66A0089](https://openairdocs.org/ntsb/MIA66A0089.md): Cessna 172F · Palmer, PR · Accident · 3 fatal · Closed · Feb 15, 1966 · N7848U · Destroyed
- [NTSB MIA66F0416](https://openairdocs.org/ntsb/MIA66F0416.md): Cessna 172 · San Juan, PR · Accident · Minor injuries · Closed · Feb 5, 1966 · N8523U · Substantial damage
- [NTSB MIA66D0360](https://openairdocs.org/ntsb/MIA66D0360.md): Piper PA-28 · La Parguera, PR · Accident · No injuries · Closed · Dec 10, 1965 · N5417W · Substantial damage
- [NTSB MIA66F0321](https://openairdocs.org/ntsb/MIA66F0321.md): Beechcraft C-45H · San Juan, PR · Accident · No injuries · Closed · Nov 12, 1965 · N493DM · Substantial damage

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

## 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=7&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.
