# NTSB investigations, PR: In flight encounter with weather

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 MIA07LA086](https://openairdocs.org/ntsb/MIA07LA086.md): Aerospatiale ATR 72-212 · San Juan, PR · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 2007 · N407AT · No damage
  > In-flight encounter with turbulence that resulted in injuries to a flight attendant and a passenger.
- [NTSB MIA06LA071](https://openairdocs.org/ntsb/MIA06LA071.md): Cessna 402C · Dorado, PR · Accident · Serious injuries · Limited investigation · Final report · Mar 27, 2006 · N223PB · No damage
  > The failure of the pilot to use on-board weather radar equipment for weather avoidance and the pilot's continued operation into known adverse weather conditions, resulting in injury to passengers.
- [NTSB MIA05CA144](https://openairdocs.org/ntsb/MIA05CA144.md): Grumman American G-164 · Sabana Grande, PR · Accident · Minor injuries · Data collection · Final report · Aug 4, 2005 · N460Y · Substantial damage
  > The pilot's inadvertent encounter with a downdraft in mountainous terrain resulting in an uncontrolled descent and collision with the terrain.
- [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 MIA02FA084](https://openairdocs.org/ntsb/MIA02FA084.md): Mitsubishi MU-2B-35 · Carolina, PR · Accident · 2 fatal · Field investigation · Final report · Apr 15, 2002 · N45BS · Destroyed
  > The failure of the pilot to maintain airspeed (Vs) while maneuvering following inadvertent encounter with clouds resulting in an inadvertent stall and uncontrolled descent and subsequent in-flight collision with trees, a wall, and a building.
- [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.

## 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 c."eventStateOrRegion" = 'PR' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=240&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.