# NTSB investigations, RI: In flight encounter with weather

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 NYC97LA014](https://openairdocs.org/ntsb/NYC97LA014.md): Cessna 340A · Pawtucket, RI · Accident · Serious injuries · Limited investigation · Final report · Nov 7, 1996 · N36JM · Destroyed
  > failure of the pilot to comply with the published instrument approach procedure, by continuing the ILS approach below the decision height, rather than performing a missed approach; and his failure to attain a proper touchdown point for the continued landing.…
- [NTSB BFO92FA133](https://openairdocs.org/ntsb/BFO92FA133.md): Cessna 182R · Westerly, RI · Accident · 2 fatal · Field investigation · Final report · Sep 9, 1992 · N5533N · Destroyed
  > Inadvertent VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: the adverse weather conditions, self-induced pressure…
- [NTSB ATL88LA084](https://openairdocs.org/ntsb/ATL88LA084.md): Boeing 767-332 · Block Island, RI · Accident · Serious injuries · Limited investigation · Final report · Jan 26, 1988 · N117DL · No damage
  > The capt rptdly advised the flight attendants to secure the cabin and be seated due to turbulence expected during descent. About 5 minutes later, the airplane briefly encountered severe turbulence while passing through about FL230. A flight attendant…
- [NTSB NYC87LA012](https://openairdocs.org/ntsb/NYC87LA012.md): Enstrom 280C · Newport, RI · Accident · 1 fatal · Limited investigation · Final report · Dec 11, 1986 · N647H · Substantial damage
  > Aircraft descended and collided with water when the pilot attempted to regain visual ground reference when weather deteriorated. No plt acc report was received. Plt time was not reported or available.
- [NTSB NYC86LA009](https://openairdocs.org/ntsb/NYC86LA009.md): Maule MX 7-235 · Westerly, RI · Accident · No injuries · Limited investigation · Final report · Oct 12, 1985 · N5661N · Substantial damage
  > The acft groundlooped during lndg. The plt reported that a sudden gust of wind was the cause. The sind was reported as calm.
- [NTSB NYC85FA014](https://openairdocs.org/ntsb/NYC85FA014.md): Cessna 150M · Providence, RI · Accident · 2 fatal · Field investigation · Final report · Oct 26, 1984 · N45397 · Destroyed
  > Acft collided with the waters of narragansett bay at a location aprx 1 mile from boys town arpt (destination of record),in water aprx 8 ft deep. The wx was IMC at departure (1845 EDT) and the ATP instrument rated plt had requested and been granted a special…
- [NTSB NYC82DA049](https://openairdocs.org/ntsb/NYC82DA049.md): Cessna 421C · Westerly, RI · Accident · No injuries · Final report · Feb 23, 1982 · N5358J · Substantial damage
  > The aircraft touched down hard during a night landing after the pilot encountered icing conditions in flight. Several witnesses reported that the aircraft had 1/2 to 3/4 inch of ice on the leading edges of the wings and verticle stabilizer. The gross landing…

## 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" = 240)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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