OpenAirDocs.org

NTSB investigations, RI

16 cases where the phase of flight was Maneuvering.

Cases per year

19642026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "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.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB ERA24LA171Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · South Kingstown, RIThe pilot’s failure to maintain clearance from the water while maneuvering at low altitude.Apr 9, 2024 · N331EL · Substantial damageNTSB ERA16LA244Accident · No injuriesLimited investigationFinal reportCessna 305 · Narragansett, RIA total loss of engine power for reasons that could not be determined during a postaccident examination of the airframe and engine.Jul 4, 2016 · N5291G · Substantial damageNTSB NYC91LA217Accident · Minor injuriesLimited investigationFinal reportWaco YMF-5 · Jamestown, RIThe pilot's improper use of carburetor heat, resulting in carburetor ice formation and subsequent loss of engine power and a forced landing in trees.Aug 28, 1991 · N44JS · Substantial damageNTSB NYC91LA011Accident · No injuriesLimited investigationFinal reportRobinson R22 · Woonsocket, RIPilot'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.Oct 14, 1990 · N666U · Substantial damageNTSB NYC90FA075Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Smithfield, RIImproper 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.Mar 8, 1990 · N2603G · DestroyedNTSB NYC89FA021Accident · 2 fatalField investigationFinal reportCessna 152 · Smithfield, RIFailure 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.Nov 6, 1988 · N5462B · DestroyedNTSB NYC88LA237Accident · No injuriesLimited investigationFinal reportRobinson R-22 · W.Kingston, RIThe 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.…Sep 17, 1988 · N47CS · Substantial damageNTSB NYC88LA160Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Westerly, RIThe 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,…Jun 5, 1988 · N580H · Substantial damageNTSB NYC86FA112Accident · 1 fatalField investigationFinal reportCessna 310 · Lincoln, RIThe 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…Apr 21, 1986 · N128K · DestroyedNTSB NYC85FA014Accident · 2 fatalField investigationFinal reportCessna 150M · Providence, RIAcft 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…Oct 26, 1984 · N45397 · DestroyedNTSB NYC82DA128Accident · No injuriesFinal reportBell 206B · Jamestown, RIThe 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.Jun 20, 1982 · N20303 · Substantial damageNTSB NYC71FNA60Accident · 1 fatalClosedGrumman F8F-2 · No.Kingstown, RIJun 5, 1971 · N7700C · DestroyedNTSB NYC70F0186Accident · No injuriesClosedBell 47G-4 · E Providence, RIOct 16, 1969 · N73943 · Substantial damageNTSB NYC68A0007Accident · No injuriesClosedBell 47D1 · N Kingston, RIJul 13, 1967 · N210B · Substantial damageNTSB NYC66A0013Accident · No injuriesClosedBell 47D1 · West Kingston, RIJul 27, 1965 · N210B · Substantial damageNTSB UNK64X2832Accident · No injuriesClosedBell 47D1 · Kingston, RIJul 14, 1964 · N210B · Substantial damage