# Final NTSB investigations, 1970, 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 MIA71FKA07](https://openairdocs.org/ntsb/MIA71FKA07.md): Beech 95-C55 · Mayaguez, PR · Accident · Serious injuries · Closed · Nov 7, 1970 · N263Q · 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 MIA71AM031](https://openairdocs.org/ntsb/MIA71AM031.md): Dehavilland 114-2X · Ponce, PR · Accident · No injuries · Closed · Oct 5, 1970 · N571PR · Substantial damage
- [NTSB MIA71FKA09](https://openairdocs.org/ntsb/MIA71FKA09.md): Grumman G-164 · Toa Baja, PR · Accident · No injuries · Closed · Sep 12, 1970 · N10223 · Substantial damage
- [NTSB MIA71AM024](https://openairdocs.org/ntsb/MIA71AM024.md): Brittnorman BN-2A · Orocovis, PR · Accident · 1 fatal · Closed · Sep 9, 1970 · N855JA · Destroyed
- [NTSB MIA71AM018](https://openairdocs.org/ntsb/MIA71AM018.md): Douglas A-26C · Mayaguez, PR · Accident · No injuries · Closed · Aug 27, 1970 · N1221 · Substantial damage
- [NTSB MIA71FKA04](https://openairdocs.org/ntsb/MIA71FKA04.md): Cessna 177 · San Sebastian, PR · Accident · No injuries · Closed · Aug 9, 1970 · N2229Y · Substantial damage
- [NTSB MIA71FKA01](https://openairdocs.org/ntsb/MIA71FKA01.md): Cessna 172D · Vega Baja, PR · Accident · No injuries · Closed · Jul 25, 1970 · N2160Y · Substantial damage
- [NTSB MIA70AM096](https://openairdocs.org/ntsb/MIA70AM096.md): Douglas DC-3C · San Juan, PR · Accident · No injuries · Closed · Jun 13, 1970 · N1549V · Substantial damage
- [NTSB MIA70FKA06](https://openairdocs.org/ntsb/MIA70FKA06.md): Hughes 269B · San Sebastian, PR · Accident · Minor injuries · Closed · Mar 23, 1970 · N9383F · Destroyed
- [NTSB MIA70FKA05](https://openairdocs.org/ntsb/MIA70FKA05.md): Hiller Acft FH1100 · San Juan, PR · Accident · No injuries · Closed · Mar 15, 1970 · N382FH · Substantial damage
- [NTSB MIA70FKA04](https://openairdocs.org/ntsb/MIA70FKA04.md): Beech C-45H · Carolina, PR · Accident · No injuries · Closed · Feb 17, 1970 · N140W · 2 aircraft · Substantial damage
- [NTSB MIA70AM067](https://openairdocs.org/ntsb/MIA70AM067.md): Beech E18S · San Juan, PR · Accident · No injuries · Closed · Feb 10, 1970 · N64B · Substantial damage
- [NTSB MIA70DKA01](https://openairdocs.org/ntsb/MIA70DKA01.md): Cessna 172 · Guayma, PR · Accident · Serious injuries · Closed · Jan 24, 1970 · N3218L · 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 year(c."eventDate") = 1970
  AND c."eventStateOrRegion" = 'PR' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?state=PR&status=final&year=1970

---
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.
