# Final NTSB investigations, 1978, RI

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 NYC78FNA46](https://openairdocs.org/ntsb/NYC78FNA46.md): Cessna 170 · Block Island, RI · Accident · No injuries · Closed · Aug 19, 1978 · N4417V · Substantial damage
- [NTSB NYC78FNA37](https://openairdocs.org/ntsb/NYC78FNA37.md): Beech A23-24 · E Providence, RI · Accident · Serious injuries · Closed · Jul 22, 1978 · N5785V · Substantial damage
- [NTSB NYC78FNA36](https://openairdocs.org/ntsb/NYC78FNA36.md): Luscombe 8A · Kingstown, RI · Accident · No injuries · Closed · Jul 10, 1978 · N1352K · Substantial damage
- [NTSB NYC78FA069](https://openairdocs.org/ntsb/NYC78FA069.md): Piper PA-32 · Westerly, RI · Accident · 4 fatal · Closed · Jul 9, 1978 · N5254S · Substantial damage
- [NTSB NYC78FNA33](https://openairdocs.org/ntsb/NYC78FNA33.md): Curtiss C 12Q · Westerly, RI · Accident · No injuries · Closed · Jun 25, 1978 · N370N · Substantial damage
- [NTSB NYC78FNA32](https://openairdocs.org/ntsb/NYC78FNA32.md): Grum Amer AA1-A · Lincoln, RI · Accident · No injuries · Closed · Jun 25, 1978 · N9334L · No damage
- [NTSB NYC78FNA30](https://openairdocs.org/ntsb/NYC78FNA30.md): Piper PA-24 · Block Island, RI · Accident · No injuries · Closed · Jun 14, 1978 · N7900P · Substantial damage
- [NTSB NYC78FNA23](https://openairdocs.org/ntsb/NYC78FNA23.md): Mooney M20C · Westerly, RI · Accident · No injuries · Closed · May 20, 1978 · N9474V · Substantial damage
- [NTSB NYC78FNA09](https://openairdocs.org/ntsb/NYC78FNA09.md): Piper PA-22 · Westerly, RI · Accident · No injuries · Closed · Feb 12, 1978 · N5632Z · Substantial damage
- [NTSB NYC78FNA06](https://openairdocs.org/ntsb/NYC78FNA06.md): Aeronca 7AC · Lincoln, RI · Accident · No injuries · Closed · Jan 24, 1978 · N83865 · Substantial damage
- [NTSB NYC78FA024](https://openairdocs.org/ntsb/NYC78FA024.md): Temco GC1B · Newport, RI · Accident · 1 fatal · Closed · Jan 14, 1978 · N2406B · 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 year(c."eventDate") = 1978
  AND c."eventStateOrRegion" = 'RI' 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=RI&status=final&year=1978

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