# Fatal NTSB investigations, PR: Enroute

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 ERA18LA183](https://openairdocs.org/ntsb/ERA18LA183.md): Bell 206 · Rio Grande, PR · Accident · 1 fatal · Limited investigation · Final report · Jun 30, 2018 · N10CV · Substantial damage
  > A total loss of engine power due to oil exhaustion, which resulted in an uncontrolled descent and hard landing.
- [NTSB ERA14MA060](https://openairdocs.org/ntsb/ERA14MA060.md): Fairchild SA227-AC · La Alianza, PR · Accident · 2 fatal · Major investigation · Final report · Dec 3, 2013 · N831BC · Destroyed
  > The 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…
- [NTSB ERA14LA007](https://openairdocs.org/ntsb/ERA14LA007.md): Britten-Norman BN-2A-8 · Culebra, PR · Accident · 1 fatal · Limited investigation · Final report · Oct 6, 2013 · N909GD · Substantial damage
  > The pilot's failure to maintain airplane control for reasons that could not be determined because the wreckage was not recovered.
- [NTSB ERA11FA376](https://openairdocs.org/ntsb/ERA11FA376.md): Cessna A185F · Yabucoa, PR · Accident · 5 fatal · Field investigation · Final report · Jul 1, 2011 · N8436Q · Substantial damage
  > The 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.
- [NTSB ERA09MA157](https://openairdocs.org/ntsb/ERA09MA157.md): Cessna 206H · Quebradillas, PR · Accident · 6 fatal · Major investigation · Final report · Feb 8, 2009 · N118ME · Destroyed
  > The pilot exceeded the design limits of the airplane, which resulted in an in-flight break up while maneuvering in adverse weather conditions.
- [NTSB ERA09FA078](https://openairdocs.org/ntsb/ERA09FA078.md): Rockwell International 690B · Rio Grande, PR · Accident · 3 fatal · Field investigation · Final report · Dec 3, 2008 · N318WA · Destroyed
  > The pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with terrain.
- [NTSB MIA07FA042](https://openairdocs.org/ntsb/MIA07FA042.md): Partenavia P 68C · Adjuntas, PR · Accident · 2 fatal · Field investigation · Final report · Jan 15, 2007 · N90KB · Substantial damage
  > The pilot's failure to maintain altitude/clearance with mountainous terrain for undetermined reasons during a normal descent under instrument meteorological and dark night conditions.
- [NTSB MIA04LA133](https://openairdocs.org/ntsb/MIA04LA133.md): Britten-Norman BN-2A-27 · Vega Baja, PR · Accident · 1 fatal · Limited investigation · Final report · Sep 29, 2004 · N902GD · Destroyed
  > The 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.
- [NTSB NYC04FA223](https://openairdocs.org/ntsb/NYC04FA223.md): Aero Commander 112 · Vieques, PR · Accident · 1 fatal · Field investigation · Final report · Feb 16, 2004 · N1261J · Substantial damage
  > The 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…
- [NTSB ATL02FA107](https://openairdocs.org/ntsb/ATL02FA107.md): Bell 47G-4A · Yauco, PR · Accident · 1 fatal · Field investigation · Final report · May 25, 2002 · N6SR · Destroyed
  > The 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.
- [NTSB ATL02FA031](https://openairdocs.org/ntsb/ATL02FA031.md): Cessna 441 · Rio Grande, PR · Accident · 5 fatal · Field investigation · Final report · Jan 5, 2002 · N441AW · Destroyed
  > The pilot continued visual flight flight into instrument flight conditions resulting in an in-flight collision with terrain. Low clouds were a factor.
- [NTSB MIA01FA140](https://openairdocs.org/ntsb/MIA01FA140.md): Cessna 404 · Pena Pobre, PR · Accident · 1 fatal · Field investigation · Final report · May 13, 2001 · N404BA · Destroyed
  > failure of the pilot-in-command to maintain altitude/clearance, resulting in an in-flight collision with rising terrain.
- [NTSB MIA81FA054](https://openairdocs.org/ntsb/MIA81FA054.md): Mooney M20F · San Juan, PR · Accident · 3 fatal · Closed · Mar 21, 1981 · N712CS · Destroyed
- [NTSB MIA81FA046](https://openairdocs.org/ntsb/MIA81FA046.md): Piper PA-32R · El Duque, PR · Accident · 5 fatal · Closed · Feb 16, 1981 · N7272F · Destroyed
- [NTSB MIA80FA106](https://openairdocs.org/ntsb/MIA80FA106.md): Cessna 182 · Rio Grande, PR · Accident · 4 fatal · Closed · Sep 18, 1980 · N4141C · Destroyed
- [NTSB MIA78FA016](https://openairdocs.org/ntsb/MIA78FA016.md): Brittnorman BN-2A · Vieques, PR · Accident · 5 fatal · Closed · Dec 19, 1977 · N862JA · Destroyed
- [NTSB MIA77FA031](https://openairdocs.org/ntsb/MIA77FA031.md): Bell 206-A · Jayuya, PR · Accident · 1 fatal · Closed · Feb 17, 1977 · N4046G · Destroyed
- [NTSB MIA76AM019](https://openairdocs.org/ntsb/MIA76AM019.md): Cessna 337C · San Juan, PR · Accident · 2 fatal · Closed · Aug 25, 1975 · N102CH · Destroyed
- [NTSB MIA71AM114](https://openairdocs.org/ntsb/MIA71AM114.md): Grumman G-21A · Culebra Island, PR · Accident · 2 fatal · Closed · Jun 18, 1971 · N703A · Destroyed
- [NTSB MIA71AM070](https://openairdocs.org/ntsb/MIA71AM070.md): Piper PA-28 · Aguadilla, PR · Accident · 3 fatal · Closed · Feb 7, 1971 · N3680K · Destroyed
- [NTSB MIA71AM038](https://openairdocs.org/ntsb/MIA71AM038.md): Beech C-45H · Carolina, PR · Accident · 1 fatal · Closed · Oct 28, 1970 · N349V · Minor damage
- [NTSB MIA70A0030](https://openairdocs.org/ntsb/MIA70A0030.md): Beech C-45H · Loiza Aldea, PR · Accident · 1 fatal · Closed · Oct 11, 1969 · N9957Z · Destroyed
- [NTSB MIA69A0090](https://openairdocs.org/ntsb/MIA69A0090.md): Cessna 150G · Vega Baja, PR · Accident · 1 fatal · Closed · Jun 17, 1969 · N3159X · Destroyed
- [NTSB MIA69A0051](https://openairdocs.org/ntsb/MIA69A0051.md): Dehavilland DH1142 · San Juan, PR · Accident · 19 fatal · Closed · Mar 5, 1969 · N563PR · Destroyed
- [NTSB MIA66A0089](https://openairdocs.org/ntsb/MIA66A0089.md): Cessna 172F · Palmer, PR · Accident · 3 fatal · Closed · Feb 15, 1966 · N7848U · Destroyed
- [NTSB MIA66A0013](https://openairdocs.org/ntsb/MIA66A0013.md): Cessna 170B · Corozal, PR · Accident · 1 fatal · Closed · Jul 20, 1965 · N2860C · Destroyed

## 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" = '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
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?fatal=1&state=PR

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