# NTSB investigations, AZ: On ground/water 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 ANC06CA037](https://openairdocs.org/ntsb/ANC06CA037.md): Piper PA-38-112 · Marana, AZ · Accident · No injuries · Data collection · Final report · Mar 27, 2006 · N939RG · Substantial damage
  > The pilot's inadequate evaluation of weather conditions and loss of directional control, which resulted in the airplane exiting the runway during the takeoff roll, and striking a sign. A factor associated with the accident was a dust devil.
- [NTSB LAX99LA079](https://openairdocs.org/ntsb/LAX99LA079.md): Cessna 152 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Jan 21, 1999 · N96640 · Substantial damage
  > The CFI's loss of airplane control upon encountering a dust devil due to his improper in-flight decision to land in proximity to the observed adverse weather conditions.
- [NTSB LAX92LA158](https://openairdocs.org/ntsb/LAX92LA158.md): Piper PA-28-161 · Douglas, AZ · Accident · Minor injuries · Limited investigation · Final report · Apr 1, 1992 · N28723 · Substantial damage
  > An encounter with an unforecasted high velocity wind gust which caused the airplane to nose over to an inverted position.
- [NTSB LAX87LA206](https://openairdocs.org/ntsb/LAX87LA206.md): Cessna T182 · Carefree, AZ · Accident · Serious injuries · Limited investigation · Final report · May 16, 1987 · N9545H · Substantial damage
  > At the end of a cross-country flt, the plt was approaching the arpt for landing on rwy 6 and noticed light turbulence. On the first attempt to land the plt went around. On the second attempt the plt landed the acft. Aprx 100 ft down the rwy the acft became…
- [NTSB LAX87LA201](https://openairdocs.org/ntsb/LAX87LA201.md): Piper PA-38-112 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · May 2, 1987 · N25111 · Substantial damage
  > During and instructional flight on short and soft field landings, the pilot reported that during the landing roll an unobserved dust devil hit the aircraft. The aircraft was raised approximately 60 ft AGL. The instructor was unable to regain control and the…
- [NTSB LAX86LA162](https://openairdocs.org/ntsb/LAX86LA162.md): Cessna 182J · Saint Johns, AZ · Accident · No injuries · Limited investigation · Final report · Apr 2, 1986 · N2691F · Substantial damage
  > The plt said his wx briefing indcd VFR conds along the route with ocnl thunderstorm (tstm) activity that might require diversion. As he was apchg the st Johns arpt, the plt saw tstms & ovrcst clds ahead & decided to land & wait for the wx to improve. The…

## 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" = 'AZ' 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" = 330)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=330&state=AZ

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