# NTSB investigations, NM: Turbulence encounter

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 DCA24LA290](https://openairdocs.org/ntsb/DCA24LA290.md): Boeing 737 · Highland Meadows, NM · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 19, 2024 · N7734H · No damage
  > An encounter with convectively induced turbulence during descent.
- [NTSB CEN12LA427](https://openairdocs.org/ntsb/CEN12LA427.md): Murray Richard F Aircam BY Lockwood · Taos, NM · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 2012 · N984AT · Substantial damage
  > The pilot's decision to fly in gusty wind conditions at low altitude over mountainous terrain contrary to guidance in the airplane flight manual and subsequent loss of airplane control due to wind and turbulence.
- [NTSB DEN08CA051](https://openairdocs.org/ntsb/DEN08CA051.md): Piper PA-32-301XTC · Taos, NM · Accident · No injuries · Data collection · Final report · Jan 17, 2008 · N819C · Substantial damage
  > The pilot's excessive airspeed during the approach and loss of control during the landing. Contributing factors were the mountain turbulence and the snowbank.

## 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" = 'NM' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '360' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/360/sequence?state=NM

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