# NTSB investigations, AZ: Dragged wing,rotor,pod,float or tail/skid

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 LAX05CA302](https://openairdocs.org/ntsb/LAX05CA302.md): Cessna 172S · Show Low, AZ · Accident · No injuries · Data collection · Final report · Sep 18, 2005 · N121CW · Substantial damage
  > the pilot's selection of a downwind runway for landing and his inadequate compensation for the strong and gusty quartering tail wind conditions, which resulted in a tail strike during landing.
- [NTSB LAX00LA333](https://openairdocs.org/ntsb/LAX00LA333.md): Piper PA-28-180 · Payson, AZ · Accident · No injuries · Limited investigation · Final report · Sep 10, 2000 · N4208T · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll due to over-rotation, inadequate airspeed, and improper remedial action under the high density altitude condition.
- [NTSB LAX98LA102](https://openairdocs.org/ntsb/LAX98LA102.md): Lawrence Kitfox · Cottonwood, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 1998 · N99TL · Substantial damage
  > The pilot's failure to maintain directional control and attain the proper airspeed for takeoff. A factor in the accident was his lack of recent experience in the make and model of airplane.
- [NTSB LAX96LA240](https://openairdocs.org/ntsb/LAX96LA240.md): Experimental Mini Mustang · Page, AZ · Accident · 1 fatal · Limited investigation · Final report · Jun 21, 1996 · N61D · Destroyed
  > the pilot's inadequate compensation for crosswind conditions, and his failure to maintain control of the aircraft. A factor relating to the accident was: the gusty/crosswind condition.
- [NTSB LAX96LA238](https://openairdocs.org/ntsb/LAX96LA238.md): Cessna 182RG · Page, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 1996 · N6309T · Destroyed
  > the pilot's inadequate compensation for wind conditions, and failure to maintain control of the aircraft. Factors relating to the accident were: the gusty and crosswind conditions.
- [NTSB LAX94LA231](https://openairdocs.org/ntsb/LAX94LA231.md): Cessna 172N · Roosevelt, AZ · Accident · 1 fatal · Limited investigation · Final report · May 31, 1994 · N6305J · Destroyed
  > the pilot's selection of an inadequate terrain clearance altitude while maneuvering over a lake. A factor in the accident was the calm glassy water conditions which may have affected the pilot's perception of his actual height above the water.
- [NTSB LAX92LA193](https://openairdocs.org/ntsb/LAX92LA193.md): Piper PA-18A · Coolidge, AZ · Accident · Serious injuries · Limited investigation · Final report · Apr 30, 1992 · N1360C · Substantial damage
  > The pilot's use of unsuitable terrain and inadequate compensation for the existing wind conditions.
- [NTSB LAX84LA431](https://openairdocs.org/ntsb/LAX84LA431.md): Glasflugel H 301 B Libelle · Carefree, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 1984 · N3012 · Substantial damage
  > The acft veered off the rwy during takeoff and collided with a parked unoccupied Beech 35. According to the glider plt, the aero tow began normally. After about 50 ft of ground run his wing runner let go. The wings remained level for about another 50 ft then…

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

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