# NTSB investigations, RI: Loss of control - on ground/water

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 ATL07CA124](https://openairdocs.org/ntsb/ATL07CA124.md): Cessna C172R · Pawtucket, RI · Accident · No injuries · Data collection · Final report · Aug 30, 2007 · N2459Y · Substantial damage
  > The student pilot's failure to maintain control of the aircraft during the takeoff roll.
- [NTSB ATL07CA109](https://openairdocs.org/ntsb/ATL07CA109.md): Cessna 172P · Newport, RI · Accident · No injuries · Data collection · Final report · Jul 26, 2007 · N51250 · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll.
- [NTSB IAD02LA066](https://openairdocs.org/ntsb/IAD02LA066.md): Piper PA-28-161 · Providence, RI · Accident · No injuries · Limited investigation · Final report · Jul 4, 2002 · N8081G · Substantial damage
  > The student pilot's failure to maintain directional control during the landing.
- [NTSB NYC96LA043](https://openairdocs.org/ntsb/NYC96LA043.md): Piper J3F · Westerly, RI · Accident · No injuries · Limited investigation · Final report · Dec 26, 1995 · N28148 · Substantial damage
  > the pilot's inadequate compensation for the wind condition, which subsequently resulted in the aircraft nosing over. The gusty crosswind condition was a related factor.
- [NTSB NYC90LA140](https://openairdocs.org/ntsb/NYC90LA140.md): Piper PA-28-235 · Middleton, RI · Accident · No injuries · Limited investigation · Final report · Jun 14, 1990 · N8569N · Substantial damage
  > Loss of direction control by the pilot when he came in high and fast and touched down at improper touchdown point.
- [NTSB NYC87LA270](https://openairdocs.org/ntsb/NYC87LA270.md): Rockwell 112A · No Kingstown, RI · Accident · No injuries · Limited investigation · Final report · Jul 30, 1987 · N1223J · Substantial damage
  > The aircraft bounced on landing and directional control was lost. The airplane veered to the left side of the runway and struck a pile of rubble and continued into the bay.
- [NTSB NYC84LA006](https://openairdocs.org/ntsb/NYC84LA006.md): Piper PA-38-112 · Block Island, RI · Accident · No injuries · Limited investigation · Final report · Oct 8, 1983 · N9238T · Substantial damage
  > The flt was uneventful until the acft was landed at the destination. During the landing, the acft veered off the rwy & was damaged. An exam of the brake sys revealed that the reservoir still had fluid. When checked, the left brake was firm, but the right…
- [NTSB NYC83LA129](https://openairdocs.org/ntsb/NYC83LA129.md): Cessna 182N · Newport, RI · Accident · No injuries · Limited investigation · Final report · Jun 2, 1983 · N9283G · Substantial damage
  > The acft went off the wet runway onto the wet grass down an embankment and into some rocks. The instructor was making this final landing. Braking was poor from a light rain. As a turn was started onto a taxiway at the end of runway 22 the acft went onto the…
- [NTSB NYC83LA093](https://openairdocs.org/ntsb/NYC83LA093.md): Cessna 182P · Block Island, RI · Accident · No injuries · Limited investigation · Final report · Apr 13, 1983 · N575PM · Substantial damage
  > The acft veered off the runway during landing and collided with a ditch. The approach to Block Island was normal and thelanding was made about one third down the runway. On touchdown, directional control was lost and the acft veered to the left side of the…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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