# NTSB investigations: Cessna 172N, 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 CEN26FA192](https://openairdocs.org/ntsb/CEN26FA192.md): Cessna 172N · Westerly, RI · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 18, 2026 · N733CP · Substantial damage
  > On May 18, 2026, about 1205 eastern daylight time, a Cessna 172N, N733CP, was substantially damaged when it was involved in an accident near Westerly, Rhode Island. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB NYC02LA145](https://openairdocs.org/ntsb/NYC02LA145.md): Cessna 172N · Middletown, RI · Accident · No injuries · Limited investigation · Final report · Jul 14, 2002 · N733NQ · Substantial damage
  > The pilot's improper flare. A factor was the shifting wind.
- [NTSB NYC93LA163](https://openairdocs.org/ntsb/NYC93LA163.md): Cessna 172 · Hope Valley, RI · Accident · No injuries · Limited investigation · Final report · Aug 19, 1993 · N9845J · Substantial damage
  > The engine failure as the result of ingestion of pieces of carburetor into the cylinders, and the subsequent forced landing and nose over during the landing roll after encountering soft terrain.
- [NTSB NYC85FAMS1](https://openairdocs.org/ntsb/NYC85FAMS1.md): Cessna 172N · Block Island, RI · Accident · 2 fatal · Missing aircraft · Final report · Sep 14, 1985 · N1423E · Destroyed
  > The acft departed long Island on a VFR flt plan for Block Island. The plt did not close the flt plan after arrival at Block Island and departed Block Island without refiling a flt plan. The flt departed Block Island at night to the east over the ocean and has…
- [NTSB NYC81FNA16](https://openairdocs.org/ntsb/NYC81FNA16.md): Cessna 172N · Cranston, RI · Accident · Minor injuries · Closed · May 29, 1981 · N3543E · Substantial damage
- [NTSB NYC81FNA02](https://openairdocs.org/ntsb/NYC81FNA02.md): Cessna 172 · Warwick, RI · Accident · Minor injuries · Closed · Nov 26, 1980 · N73725 · 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 c."eventStateOrRegion" = 'RI' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072434'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072434&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.