Fatal NTSB investigations, RI

17 cases where the phase of flight was Enroute.

Cases per year

19682026
Fatal NTSB investigations, RI per year, 1968–2026: 17 cases
19682
19701
19711
19741
19761
19802
19822
19851
19861
19871
19921
19981
20001
20011

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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
  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 NYC01FA109Accident · 2 fatalField investigationFinal reportBeech A-36 · Middletown, RIThe pilot's failure to maintain airspeed while landing.Apr 28, 2001 · N55588 · DestroyedNTSB NYC00FA248Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · South Kingstown, RIThe pilot's loss of control, and his subsequent overstress of the airplane after a vacuum system failure during flight in instrument meteorological conditions. Factors included the instrument meteorological conditions, a sheared coupling on the vacuum pump,…Sep 3, 2000 · N8230G · DestroyedNTSB NYC98FA112Accident · 2 fatalField investigationFinal reportBeech A36 · Middletown, RIThe shift of the number 2 engine bearing, which in turn blocked oil lubrication, and resulted in crankshaft failure. Also causal, was the pilot's decision to continue toward the airport instead of performing a forced landing to an available field. Factors…May 25, 1998 · N4507S · DestroyedNTSB BFO92FA133Accident · 2 fatalField investigationFinal reportCessna 182R · Westerly, RIInadvertent 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…Sep 9, 1992 · N5533N · DestroyedNTSB NYC87FA109Accident · 1 fatalField investigationFinal reportCessna P210R · Block Island, RIThe aircraft disappeared from the controller's scope while receiving radar vectors. The aircraft was missing until March 20, 1987 when fishermen pulled part of the wreckage out of ocean waters near Block Island, RI. The engine and propeller, engine firewall,…Mar 13, 1987 · N6434A · DestroyedNTSB NYC87LA012Accident · 1 fatalLimited investigationFinal reportEnstrom 280C · Newport, RIAircraft 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.Dec 11, 1986 · N647H · Substantial damageNTSB NYC85FA244Accident · 2 fatalField investigationFinal reportBeech V35B · Warwick, RIWhile en route at 5000' MSL, the plt transmitted that he had an eng problem & requested clearance to land at the providence/theodore francis green state arpt, which was aprx 12 mi away. The plt then asked the controller if that was the closest arpt; however,…Sep 21, 1985 · N5NG · DestroyedNTSB NYC82FNA16Accident · 1 fatalFinal reportDavis DA-2A · Lincoln, RIThe pilot was on a local pleasure flight to see that the aircraft was functioning properly after a routine inspection. Just prior to the accident, witnesses heard the engine sputter, then become quiet. The plane was observed to continue straight ahead for…Jun 22, 1982 · N2281Z · DestroyedNTSB DCA82AA016Accident · 1 fatalFinal reportde Havilland DHC-6 · Providence, RIAprx 15 min aft tkof, lgt icg was noted on the windshield. The aircrew activated the windshield washer/deice sys which used isopropyl alcohol. However, only a little deicing fluid was noted on either side. The sys was activated again. Aft hldg the sw svrl…Feb 21, 1982 · N127PM · DestroyedNTSB NYC81FA005Accident · 1 fatalClosedCessna 210 · Newport, RISep 28, 1980 · N9662T · Substantial damageNTSB NYC80FA075Accident · 1 fatalClosedPiper PA-18 · Exeter, RIAug 22, 1980 · N9863D · Substantial damageNTSB NYC76AN107Accident · 1 fatalClosedPiper PA-28 · Jamestown, RIJul 1, 1976 · N9184K · DestroyedNTSB NYC75FNA13Accident · 1 fatalClosedCorben Ace MOD-1 · Narragansett, RIAug 25, 1974 · N6442 · DestroyedNTSB NYC72AN069Accident · 1 fatalClosedAero Comdr 560-A · East Greenwich, RINov 22, 1971 · N87K · Substantial damageNTSB NYC70AN126Accident · 2 fatalClosedMess-Boelkw B0-105 · Little Compton, RIJun 3, 1970 · N197F · DestroyedNTSB NYC69A0013Accident · 3 fatalClosedCessna 182H · Jamestown, RIAug 1, 1968 · N8317S · DestroyedNTSB NYC68A0108Accident · 2 fatalClosedCessna 182 · Potters Cove, RIMar 19, 1968 · N2623F · Substantial damage