# Final NTSB investigations, RI: Maneuvering

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 ERA24LA171](https://openairdocs.org/ntsb/ERA24LA171.md): Robinson Helicopter R44 II · South Kingstown, RI · Accident · No injuries · Class 4 · Limited · Final report · Apr 9, 2024 · N331EL · Substantial damage
  > The pilot’s failure to maintain clearance from the water while maneuvering at low altitude.
- [NTSB ERA16LA244](https://openairdocs.org/ntsb/ERA16LA244.md): Cessna 305 · Narragansett, RI · Accident · No injuries · Limited investigation · Final report · Jul 4, 2016 · N5291G · Substantial damage
  > A total loss of engine power for reasons that could not be determined during a postaccident examination of the airframe and engine.
- [NTSB NYC91LA217](https://openairdocs.org/ntsb/NYC91LA217.md): Waco YMF-5 · Jamestown, RI · Accident · Minor injuries · Limited investigation · Final report · Aug 28, 1991 · N44JS · Substantial damage
  > The pilot's improper use of carburetor heat, resulting in carburetor ice formation and subsequent loss of engine power and a forced landing in trees.
- [NTSB NYC91LA011](https://openairdocs.org/ntsb/NYC91LA011.md): Robinson R22 · Woonsocket, RI · Accident · No injuries · Limited investigation · Final report · Oct 14, 1990 · N666U · Substantial damage
  > Pilot's failure to maintain sufficient altitude above the terrain to avoid getting the right skid caught in the grass, resulting in a loss of control.
- [NTSB NYC90FA075](https://openairdocs.org/ntsb/NYC90FA075.md): Piper PA-38-112 · Smithfield, RI · Accident · 2 fatal · Field investigation · Final report · Mar 8, 1990 · N2603G · Destroyed
  > Improper in-flight planning/decision by the pilot, which resulted in insufficient altitude to recover from a stall. Factors related to the accident were: the pilot's lack of total experience and excessive gross weight of the airplane.
- [NTSB NYC89FA021](https://openairdocs.org/ntsb/NYC89FA021.md): Cessna 152 · Smithfield, RI · Accident · 2 fatal · Field investigation · Final report · Nov 6, 1988 · N5462B · Destroyed
  > Failure of the pilot to maintain airspeed after beginning an ascent from a low pass, which resulted in a stall & loss of aircraft control. Inadequate altitude to recover from a stall was considered to be a contributing factor.
- [NTSB NYC88LA237](https://openairdocs.org/ntsb/NYC88LA237.md): Robinson R-22 · W.Kingston, RI · Accident · No injuries · Limited investigation · Final report · Sep 17, 1988 · N47CS · Substantial damage
  > The plt said it was a clear, calm night. When he got to his helicopter he found the windshield covered with a heavy dew. He cleaned the windshield but during takeoff the dew reformed on the windshield and he lost all visual references outside the helicopter.…
- [NTSB NYC88LA160](https://openairdocs.org/ntsb/NYC88LA160.md): Enstrom F-28C · Westerly, RI · Accident · No injuries · Limited investigation · Final report · Jun 5, 1988 · N580H · Substantial damage
  > The instructor pilot stated that after executing several straight-in and 180 degree autorotations they decided to attempt some hovering autorotations. After executing the first one successfully in a tailwind situation, the student initiated the second one,…
- [NTSB NYC86FA112](https://openairdocs.org/ntsb/NYC86FA112.md): Cessna 310 · Lincoln, RI · Accident · 1 fatal · Field investigation · Final report · Apr 21, 1986 · N128K · Destroyed
  > The air taxi cargo aircraft was observed maneuvering over the airport in IMC conditions for a VFR approach to land. Witnesses described an abrupt turn to reverse direction of flight followed by a nose dive into the ground. The pilot, age 22, had accummulated…
- [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 NYC82DA128](https://openairdocs.org/ntsb/NYC82DA128.md): Bell 206B · Jamestown, RI · Accident · No injuries · Final report · Jun 20, 1982 · N20303 · Substantial damage
  > The helicopter was being used to photograph ships. According to the pilot, it began to spin while he was in a low level hover over the water. Subsequently, the helicopter struck the water, rolled over, then sank in about 104 ft of water and was not recovered.
- [NTSB NYC71FNA60](https://openairdocs.org/ntsb/NYC71FNA60.md): Grumman F8F-2 · No.Kingstown, RI · Accident · 1 fatal · Closed · Jun 5, 1971 · N7700C · Destroyed
- [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 NYC68A0007](https://openairdocs.org/ntsb/NYC68A0007.md): Bell 47D1 · N Kingston, RI · Accident · No injuries · Closed · Jul 13, 1967 · N210B · Substantial damage
- [NTSB NYC66A0013](https://openairdocs.org/ntsb/NYC66A0013.md): Bell 47D1 · West Kingston, RI · Accident · No injuries · Closed · Jul 27, 1965 · N210B · Substantial damage
- [NTSB UNK64X2832](https://openairdocs.org/ntsb/UNK64X2832.md): Bell 47D1 · Kingston, RI · Accident · No injuries · Closed · Jul 14, 1964 · N210B · Substantial damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?state=RI&status=final

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