# NTSB investigations: IAE V2500SERIES: 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 DEN06LA095](https://openairdocs.org/ntsb/DEN06LA095.md): Airbus A319-131 · Masonville, CO · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 2006 · N839UA · No damage
  > the flight's encounter with unexpected turbulence, which resulted in a passenger sustaining a fractured ankle.
- [NTSB NYC04LA168](https://openairdocs.org/ntsb/NYC04LA168.md): Airbus Industrie A319 · Flat Rock, VA · Accident · Serious injuries · Limited investigation · Final report · Jul 17, 2004 · N812AW · No damage
  > An inadvertent encounter with turbulence in clouds during descent.
- [NTSB LAX03LA181](https://openairdocs.org/ntsb/LAX03LA181.md): Airbus Industrie A320-321 · Payson, AZ · Accident · Serious injuries · Limited investigation · Final report · Jun 5, 2003 · N644AW · No damage
  > The flight's encounter with convectively induced turbulence associated with developing thunderstorms while the flight crew attempted to deviate around an area of adverse weather. The turbulence event occurred while the crew was attempting to maneuver around…
- [NTSB MIA01LA224](https://openairdocs.org/ntsb/MIA01LA224.md): Airbus Industrie A320-232 · Needles, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 20, 2001 · N605AW · No damage
  > an inadvertent in-flight encounter with turbulence.
- [NTSB LAX01LA136](https://openairdocs.org/ntsb/LAX01LA136.md): Airbus Industrie A320-232 · Las Vegas, NV · Accident · Serious injuries · Limited investigation · Final report · Apr 19, 2001 · N654AW · No damage
  > The failure of the pilot-in-command to properly evaluate a hazardous weather advisory and his failure to adequately alter course and flight altitude to avoid the area of hazardous weather.
- [NTSB NYC99LA240](https://openairdocs.org/ntsb/NYC99LA240.md): Airbus Industrie 319-131 · Sparta, NJ · Accident · Serious injuries · Limited investigation · Final report · Sep 30, 1999 · N821UA · No damage
  > The airplane's encounter with clear air turbulence.
- [NTSB NYC97LA071](https://openairdocs.org/ntsb/NYC97LA071.md): Airbus Industrie A-320-232 · Newark, NJ · Accident · Serious injuries · Limited investigation · Final report · Apr 7, 1997 · N413UA · No damage
  > an encounter with unforecasted turbulence, during cruise flight, which resulted in serious injury to the flight attendant.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('34601')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND 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?engine=34601&occurrence=240

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