# Fatal 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 2 of 2 · 65 cases

## Cases, newest first

- [NTSB MIA71AM108](https://openairdocs.org/ntsb/MIA71AM108.md): Cessna 172E · Villalba, PR · Accident · 1 fatal · Closed · Jun 6, 1971 · N3710S · Destroyed
- [NTSB MIA71AM089](https://openairdocs.org/ntsb/MIA71AM089.md): Piper PA-28 · Yabucoa, PR · Accident · 4 fatal · Closed · Apr 18, 1971 · N4853L · Destroyed
- [NTSB MIA71AM070](https://openairdocs.org/ntsb/MIA71AM070.md): Piper PA-28 · Aguadilla, PR · Accident · 3 fatal · Closed · Feb 7, 1971 · N3680K · Destroyed
- [NTSB MIA71AM038](https://openairdocs.org/ntsb/MIA71AM038.md): Beech C-45H · Carolina, PR · Accident · 1 fatal · Closed · Oct 28, 1970 · N349V · Minor damage
- [NTSB MIA71AM024](https://openairdocs.org/ntsb/MIA71AM024.md): Brittnorman BN-2A · Orocovis, PR · Accident · 1 fatal · Closed · Sep 9, 1970 · N855JA · Destroyed
- [NTSB MIA70A0030](https://openairdocs.org/ntsb/MIA70A0030.md): Beech C-45H · Loiza Aldea, PR · Accident · 1 fatal · Closed · Oct 11, 1969 · N9957Z · Destroyed
- [NTSB MIA69A0090](https://openairdocs.org/ntsb/MIA69A0090.md): Cessna 150G · Vega Baja, PR · Accident · 1 fatal · Closed · Jun 17, 1969 · N3159X · Destroyed
- [NTSB MIA69A0051](https://openairdocs.org/ntsb/MIA69A0051.md): Dehavilland DH1142 · San Juan, PR · Accident · 19 fatal · Closed · Mar 5, 1969 · N563PR · Destroyed
- [NTSB MIA68A0090](https://openairdocs.org/ntsb/MIA68A0090.md): Aero Comdr 680 · San Juan, PR · Accident · 1 fatal · Closed · Apr 20, 1968 · N408EE · Destroyed
- [NTSB MIA68A0072](https://openairdocs.org/ntsb/MIA68A0072.md): Beech 35-33 · Gurabo, PR · Accident · 4 fatal · Closed · Feb 26, 1968 · N9577Y · Destroyed
- [NTSB MIA68A0034](https://openairdocs.org/ntsb/MIA68A0034.md): Cessna 172 · Isle Culebra, PR · Accident · 2 fatal · Closed · Oct 8, 1967 · N8372U · Destroyed
- [NTSB MIA68A0002](https://openairdocs.org/ntsb/MIA68A0002.md): Piper PA-28 · Mayaguez, PR · Accident · 4 fatal · Closed · Jul 2, 1967 · N5100W · Destroyed
- [NTSB MIA66A0089](https://openairdocs.org/ntsb/MIA66A0089.md): Cessna 172F · Palmer, PR · Accident · 3 fatal · Closed · Feb 15, 1966 · N7848U · Destroyed
- [NTSB MIA66A0013](https://openairdocs.org/ntsb/MIA66A0013.md): Cessna 170B · Corozal, PR · Accident · 1 fatal · Closed · Jul 20, 1965 · N2860C · Destroyed
- [NTSB MIA65A0096](https://openairdocs.org/ntsb/MIA65A0096.md): Piper PA-22 · Caguas, PR · Accident · 3 fatal · Closed · Mar 27, 1965 · N9518D · 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'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&page=2&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
