# NTSB investigations, 2004, PR

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 MIA05LA013](https://openairdocs.org/ntsb/MIA05LA013.md): Piper PA-23-250 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Oct 25, 2004 · N62711 · Substantial damage
  > The pilot-in-command's failure to maintain airspeed while on base to final leg, which resulted in an inadvertent stall/mush and subsequent impact with the runway.
- [NTSB MIA05CA009](https://openairdocs.org/ntsb/MIA05CA009.md): Robinson R-22 · Vega Baja, PR · Accident · Serious injuries · Data collection · Final report · Oct 19, 2004 · N2314T · Substantial damage
  > The pilot's failure to select a suitable landing area resulting in a tangled skid with vegetation during an aborted landing and subsequent dynamic roll over.
- [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 ATL04LA183](https://openairdocs.org/ntsb/ATL04LA183.md): Piper PA-18 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Sep 12, 2004 · N5546Z · Substantial damage
  > The pilot's failure to apply carburetor heat which resulted in carburetor ice and the subsequent loss of engine power. A factor was weather conditions favorable for carburetor ice.
- [NTSB DCA04MA045](https://openairdocs.org/ntsb/DCA04MA045.md): ATR 72 · San Juan, PR · Accident · Serious injuries · Class 1 · Major · Final report · May 9, 2004 · N438AT · Destroyed
  > the captain's failure to execute proper techniques to recover from the bounced landings and his subsequent failure to execute a go-around.
- [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…

## The whole list in SQL

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

```sql
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 year(c."eventDate") = 2004
  AND c."eventStateOrRegion" = 'PR' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?state=PR&year=2004

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