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

Page 6 of 7 · 327 cases

## Cases, newest first

- [NTSB NYC72AN010](https://openairdocs.org/ntsb/NYC72AN010.md): Cessna 172K · Esmond, RI · Accident · 2 fatal · Closed · Jul 25, 1971 · N84446 · Destroyed
- [NTSB NYC71FNA60](https://openairdocs.org/ntsb/NYC71FNA60.md): Grumman F8F-2 · No.Kingstown, RI · Accident · 1 fatal · Closed · Jun 5, 1971 · N7700C · Destroyed
- [NTSB NYC71FFD41](https://openairdocs.org/ntsb/NYC71FFD41.md): Piper PA-24 · Lincoln, RI · Accident · No injuries · Closed · Mar 30, 1971 · N8233P · Substantial damage
- [NTSB NYC71FFD38](https://openairdocs.org/ntsb/NYC71FFD38.md): Piper PA-24 · Smithfield, RI · Accident · No injuries · Closed · Feb 6, 1971 · N1Q · Substantial damage
- [NTSB NYC71AN061](https://openairdocs.org/ntsb/NYC71AN061.md): Cessna 310D · Warwick, RI · Accident · Serious injuries · Closed · Nov 17, 1970 · N6769T · Destroyed
- [NTSB NYC71AN024](https://openairdocs.org/ntsb/NYC71AN024.md): Erco 415-E · Lincoln, RI · Accident · 1 fatal · Closed · Aug 19, 1970 · N94832 · Destroyed
- [NTSB NYC71AN045](https://openairdocs.org/ntsb/NYC71AN045.md): Aero Comdr 680-FL · Middletown, RI · Accident · No injuries · Closed · Jul 18, 1970 · N4528E · Substantial damage
- [NTSB NYC70AN126](https://openairdocs.org/ntsb/NYC70AN126.md): Mess-Boelkw B0-105 · Little Compton, RI · Accident · 2 fatal · Closed · Jun 3, 1970 · N197F · Destroyed
- [NTSB NYC70DFD17](https://openairdocs.org/ntsb/NYC70DFD17.md): Bensen B-8M · Charlestown, RI · Accident · No injuries · Closed · May 30, 1970 · N8212 · Substantial damage
- [NTSB NYC70DFD20](https://openairdocs.org/ntsb/NYC70DFD20.md): Piper PA-22 · Smithfield, RI · Accident · No injuries · Closed · May 28, 1970 · N4932Z · Substantial damage
- [NTSB NYC70DFD12](https://openairdocs.org/ntsb/NYC70DFD12.md): Piper PA-32 · Smithfield, RI · Accident · No injuries · Closed · May 2, 1970 · N3913W · Substantial damage
- [NTSB NYC70AN110](https://openairdocs.org/ntsb/NYC70AN110.md): Cessna 150B · Cranston, RI · Accident · 1 fatal · Closed · Apr 5, 1970 · N1198Y · Destroyed
- [NTSB NYC70AN090](https://openairdocs.org/ntsb/NYC70AN090.md): Lear Jet 24B · Warwick, RI · Accident · No injuries · Closed · Feb 15, 1970 · N754M · Substantial damage
- [NTSB NYC70F0249](https://openairdocs.org/ntsb/NYC70F0249.md): Stinson 108-1 · Warwick, RI · Accident · No injuries · Closed · Dec 25, 1969 · N400T · Substantial damage
- [NTSB NYC70F0186](https://openairdocs.org/ntsb/NYC70F0186.md): Bell 47G-4 · E Providence, RI · Accident · No injuries · Closed · Oct 16, 1969 · N73943 · Substantial damage
- [NTSB NYC70A0035](https://openairdocs.org/ntsb/NYC70A0035.md): N.American NA-265 · Westerly, RI · Accident · No injuries · Closed · Sep 18, 1969 · N881MC · Substantial damage
- [NTSB NYC70A0020](https://openairdocs.org/ntsb/NYC70A0020.md): Beech E35 · Block Island, RI · Accident · 1 fatal · Closed · Aug 6, 1969 · N8818A · Destroyed
- [NTSB NYC70D0041](https://openairdocs.org/ntsb/NYC70D0041.md): Beech C55 · Block Island, RI · Accident · No injuries · Closed · Jun 26, 1969 · N9562Q · Substantial damage
- [NTSB NYC70D0016](https://openairdocs.org/ntsb/NYC70D0016.md): Cessna 150G · Coventry, RI · Accident · Minor injuries · Closed · May 30, 1969 · N3688J · Destroyed
- [NTSB NYC69F0441](https://openairdocs.org/ntsb/NYC69F0441.md): Cessna 150F · Coventry, RI · Accident · No injuries · Closed · May 13, 1969 · N8066S · Substantial damage
- [NTSB NYC69A0095](https://openairdocs.org/ntsb/NYC69A0095.md): Cessna 150H · Middletown, RI · Accident · 5 fatal · Closed · Apr 23, 1969 · N23140 · 2 aircraft · Destroyed
- [NTSB NYC69A0083](https://openairdocs.org/ntsb/NYC69A0083.md): Piper PA-30B · Warwick, RI · Accident · No injuries · Closed · Feb 26, 1969 · N8555Y · Substantial damage
- [NTSB NYC69A0037](https://openairdocs.org/ntsb/NYC69A0037.md): Piper PA-28 · Lincoln, RI · Accident · No injuries · Closed · Sep 19, 1968 · N6690J · 2 aircraft · Minor damage
- [NTSB NYC69D0099](https://openairdocs.org/ntsb/NYC69D0099.md): Beech T-34A · Lincoln, RI · Accident · No injuries · Closed · Aug 1, 1968 · N5504A · Substantial damage
- [NTSB NYC69A0013](https://openairdocs.org/ntsb/NYC69A0013.md): Cessna 182H · Jamestown, RI · Accident · 3 fatal · Closed · Aug 1, 1968 · N8317S · Destroyed
- [NTSB NYC69D0112](https://openairdocs.org/ntsb/NYC69D0112.md): Luscombe 8F · Westerly, RI · Accident · No injuries · Closed · Jul 20, 1968 · N1885B · Substantial damage
- [NTSB NYC68A0128](https://openairdocs.org/ntsb/NYC68A0128.md): Cessna 210 · Middletown, RI · Accident · No injuries · Closed · May 28, 1968 · N6599X · Substantial damage
- [NTSB NYC68A0108](https://openairdocs.org/ntsb/NYC68A0108.md): Cessna 182 · Potters Cove, RI · Accident · 2 fatal · Closed · Mar 19, 1968 · N2623F · Substantial damage
- [NTSB NYC68D0366](https://openairdocs.org/ntsb/NYC68D0366.md): Cessna 210F · Slocum, RI · Accident · No injuries · Closed · Feb 11, 1968 · N5811F · Substantial damage
- [NTSB NYC68D0148](https://openairdocs.org/ntsb/NYC68D0148.md): Piper PA-30 · Block Island, RI · Accident · No injuries · Closed · Aug 18, 1967 · N7324Y · Substantial damage
- [NTSB NYC68D0089](https://openairdocs.org/ntsb/NYC68D0089.md): Champion 7FC · Block Island, RI · Accident · No injuries · Closed · Aug 13, 1967 · N9893B · Substantial damage
- [NTSB NYC68A0007](https://openairdocs.org/ntsb/NYC68A0007.md): Bell 47D1 · N Kingston, RI · Accident · No injuries · Closed · Jul 13, 1967 · N210B · Substantial damage
- [NTSB NYC68F0266](https://openairdocs.org/ntsb/NYC68F0266.md): Piper PA-22 · Block Island, RI · Accident · Serious injuries · Closed · Jul 4, 1967 · N2768P · Destroyed
- [NTSB NYC68D0158](https://openairdocs.org/ntsb/NYC68D0158.md): Cessna 140 · No-Kingstown, RI · Accident · No injuries · Closed · May 30, 1967 · N72708 · Substantial damage
- [NTSB NYC68F0127](https://openairdocs.org/ntsb/NYC68F0127.md): Stinson V-77 · Lincoln, RI · Accident · No injuries · Closed · May 20, 1967 · N69985 · Substantial damage
- [NTSB NYC68F0180](https://openairdocs.org/ntsb/NYC68F0180.md): Cessna 310K · Block Island, RI · Accident · No injuries · Closed · May 4, 1967 · N6921L · Substantial damage
- [NTSB NYC67D0637](https://openairdocs.org/ntsb/NYC67D0637.md): Piper PA-22 · Coventry, RI · Accident · No injuries · Closed · Apr 25, 1967 · N2469A · Substantial damage
- [NTSB NYC67D0626](https://openairdocs.org/ntsb/NYC67D0626.md): Cessna 182 · Providence, RI · Accident · No injuries · Closed · Apr 11, 1967 · N2092R · Substantial damage
- [NTSB NYC67D0624](https://openairdocs.org/ntsb/NYC67D0624.md): Cessna 172E · Block Island, RI · Accident · No injuries · Closed · Mar 25, 1967 · N3500S · Substantial damage
- [NTSB NYC67D0503](https://openairdocs.org/ntsb/NYC67D0503.md): Cessna 172 · Warwick, RI · Accident · No injuries · Closed · Feb 16, 1967 · N9810T · Substantial damage
- [NTSB NYC67F0478](https://openairdocs.org/ntsb/NYC67F0478.md): Piper PA-24 · Lincoln, RI · Accident · No injuries · Closed · Jan 29, 1967 · N9002P · Substantial damage
- [NTSB NYC67F0409](https://openairdocs.org/ntsb/NYC67F0409.md): Navion A · Warwick, RI · Accident · No injuries · Closed · Dec 15, 1966 · N91454 · Substantial damage
- [NTSB NYC67F0403](https://openairdocs.org/ntsb/NYC67F0403.md): Mooney M20C · Smithfield, RI · Accident · No injuries · Closed · Nov 23, 1966 · N1384W · Substantial damage
- [NTSB NYC67A0087](https://openairdocs.org/ntsb/NYC67A0087.md): Cessna 182B · Block Island, RI · Accident · No injuries · Closed · Nov 22, 1966 · N2570G · Substantial damage
- [NTSB NYC67D0207](https://openairdocs.org/ntsb/NYC67D0207.md): Cessna 172 · Slocum, RI · Accident · No injuries · Closed · Sep 18, 1966 · N7062A · Substantial damage
- [NTSB NYC67A0049](https://openairdocs.org/ntsb/NYC67A0049.md): Hughes 269A · Lincoln, RI · Accident · 1 fatal · Closed · Sep 16, 1966 · N8799F · Destroyed
- [NTSB NYC67A0029](https://openairdocs.org/ntsb/NYC67A0029.md): Cessna U206 · Westerly, RI · Accident · Minor injuries · Closed · Aug 17, 1966 · N8077Z · Destroyed
- [NTSB NYC67D0137](https://openairdocs.org/ntsb/NYC67D0137.md): Beech 23 · Block Island, RI · Accident · No injuries · Closed · Jul 15, 1966 · N2370L · Substantial damage
- [NTSB NYC67F0054](https://openairdocs.org/ntsb/NYC67F0054.md): Luscombe 8E · Newport, RI · Accident · No injuries · Closed · Jul 12, 1966 · N1689K · Substantial damage
- [NTSB NYC67D0356](https://openairdocs.org/ntsb/NYC67D0356.md): Culver V · Westerly, RI · Accident · No injuries · Closed · Jun 15, 1966 · N6544C · Substantial damage

Next page: https://openairdocs.org/ntsb.md?state=RI&page=7

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

This list as a web page: https://openairdocs.org/ntsb?page=6&state=RI

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