Fatal NTSB investigations, PR

26 cases where the phase of flight was Enroute.

Cases per year

19652026
Fatal NTSB investigations, PR per year, 1965–2026: 26 cases
19651
19661
19693
19701
19712
19751
19772
19801
19812
20011
20022
20042
20071
20081
20091
20111
20132
20181

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\" = 'PR' 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 ERA18LA183Accident · 1 fatalLimited investigationFinal reportBell 206 · Rio Grande, PRA total loss of engine power due to oil exhaustion, which resulted in an uncontrolled descent and hard landing.Jun 30, 2018 · N10CV · Substantial damageNTSB ERA14MA060Accident · 2 fatalMajor investigationFinal reportFairchild SA227-AC · La Alianza, PRThe flight crew's excessive elevator input during a rapid descent under night lighting conditions, which resulted in the overstress and breakup of the airplane. Contributing to the accident was an initial loss of airplane control for reasons that could not be…Dec 3, 2013 · N831BC · DestroyedNTSB ERA14LA007Accident · 1 fatalLimited investigationFinal reportBritten-Norman BN-2A-8 · Culebra, PRThe pilot's failure to maintain airplane control for reasons that could not be determined because the wreckage was not recovered.Oct 6, 2013 · N909GD · Substantial damageNTSB ERA11FA376Accident · 5 fatalField investigationFinal reportCessna A185F · Yabucoa, PRThe pilot's inadequate weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in an encounter with a thunderstorm and subsequent loss of control.Jul 1, 2011 · N8436Q · Substantial damageNTSB ERA09MA157Accident · 6 fatalMajor investigationFinal reportCessna 206H · Quebradillas, PRThe pilot exceeded the design limits of the airplane, which resulted in an in-flight break up while maneuvering in adverse weather conditions.Feb 8, 2009 · N118ME · DestroyedNTSB ERA09FA078Accident · 3 fatalField investigationFinal reportRockwell International 690B · Rio Grande, PRThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with terrain.Dec 3, 2008 · N318WA · DestroyedNTSB MIA07FA042Accident · 2 fatalField investigationFinal reportPartenavia P 68C · Adjuntas, PRThe pilot's failure to maintain altitude/clearance with mountainous terrain for undetermined reasons during a normal descent under instrument meteorological and dark night conditions.Jan 15, 2007 · N90KB · Substantial damageNTSB MIA04LA133Accident · 1 fatalLimited investigationFinal reportBritten-Norman BN-2A-27 · Vega Baja, PRThe pilot's improper inflight planning which resulted in an inflight encounter with weather (low ceilings and thunderstorms), his loss of aircraft control, and an inflight collision with the ocean during uncontrolled descent.Sep 29, 2004 · N902GD · DestroyedNTSB NYC04FA223Accident · 1 fatalField investigationFinal reportAero Commander 112 · Vieques, PRThe pilot's inadequate preflight and in-flight planning and decision making which resulted in the airplane entering instrument meteorological conditions. Contributing to the accident was the pilot's lack of instrument experience, a vacuum pump failure, and…Feb 16, 2004 · N1261J · Substantial damageNTSB ATL02FA107Accident · 1 fatalField investigationFinal reportBell 47G-4A · Yauco, PRThe pilot's failure to apply carburetor heat that resulted in a partial loss of engine power and the subsequent collision with an object during the forced landing. A factor was weather conditions favorable for the formation of carburetor ice.May 25, 2002 · N6SR · DestroyedNTSB ATL02FA031Accident · 5 fatalField investigationFinal reportCessna 441 · Rio Grande, PRThe pilot continued visual flight flight into instrument flight conditions resulting in an in-flight collision with terrain. Low clouds were a factor.Jan 5, 2002 · N441AW · DestroyedNTSB MIA01FA140Accident · 1 fatalField investigationFinal reportCessna 404 · Pena Pobre, PRfailure of the pilot-in-command to maintain altitude/clearance, resulting in an in-flight collision with rising terrain.May 13, 2001 · N404BA · DestroyedNTSB MIA81FA054Accident · 3 fatalClosedMooney M20F · San Juan, PRMar 21, 1981 · N712CS · DestroyedNTSB MIA81FA046Accident · 5 fatalClosedPiper PA-32R · El Duque, PRFeb 16, 1981 · N7272F · DestroyedNTSB MIA80FA106Accident · 4 fatalClosedCessna 182 · Rio Grande, PRSep 18, 1980 · N4141C · DestroyedNTSB MIA78FA016Accident · 5 fatalClosedBrittnorman BN-2A · Vieques, PRDec 19, 1977 · N862JA · DestroyedNTSB MIA77FA031Accident · 1 fatalClosedBell 206-A · Jayuya, PRFeb 17, 1977 · N4046G · DestroyedNTSB MIA76AM019Accident · 2 fatalClosedCessna 337C · San Juan, PRAug 25, 1975 · N102CH · DestroyedNTSB MIA71AM114Accident · 2 fatalClosedGrumman G-21A · Culebra Island, PRJun 18, 1971 · N703A · DestroyedNTSB MIA71AM070Accident · 3 fatalClosedPiper PA-28 · Aguadilla, PRFeb 7, 1971 · N3680K · DestroyedNTSB MIA71AM038Accident · 1 fatalClosedBeech C-45H · Carolina, PROct 28, 1970 · N349V · Minor damageNTSB MIA70A0030Accident · 1 fatalClosedBeech C-45H · Loiza Aldea, PROct 11, 1969 · N9957Z · DestroyedNTSB MIA69A0090Accident · 1 fatalClosedCessna 150G · Vega Baja, PRJun 17, 1969 · N3159X · DestroyedNTSB MIA69A0051Accident · 19 fatalClosedDehavilland DH1142 · San Juan, PRMar 5, 1969 · N563PR · DestroyedNTSB MIA66A0089Accident · 3 fatalClosedCessna 172F · Palmer, PRFeb 15, 1966 · N7848U · DestroyedNTSB MIA66A0013Accident · 1 fatalClosedCessna 170B · Corozal, PRJul 20, 1965 · N2860C · Destroyed