# NTSB investigations, AZ: Unknown

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 WPR18FA228](https://openairdocs.org/ntsb/WPR18FA228.md): Pietenpol Aircamper · Camp Verde, AZ · Accident · 2 fatal · Class 3 · Field · Final report · Aug 18, 2018 · N88HK · Substantial damage
  > Loss of control for reasons that could not be determined because postaccident examination of the airframe and engine revealed no mechanical anomalies that would have precluded normal operation.
- [NTSB WPR13CA348](https://openairdocs.org/ntsb/WPR13CA348.md): Cessna 172S · Phoenix, AZ · Accident · No injuries · Data collection · Final report · Jul 26, 2013 · N635ND · Substantial damage
  > A substantially damaged firewall that occurred during an unknown phase of flight for reasons that could not be determined.
- [NTSB WPR13LA203](https://openairdocs.org/ntsb/WPR13LA203.md): Hoffman RV-4 · Bullhead City, AZ · Accident · 1 fatal · Limited investigation · Final report · Apr 20, 2013 · N194BD · Substantial damage
  > The pilot’s suicidal act.
- [NTSB LAX08LA050](https://openairdocs.org/ntsb/LAX08LA050.md): Air Creation Clipper · Green Valley, AZ · Accident · 2 fatal · Limited investigation · Final report · Jan 19, 2008 · N614LF · Substantial damage
  > An in-flight loss of control and an uncontrolled descent into terrain for undetermined reasons.
- [NTSB LAX05LA227](https://openairdocs.org/ntsb/LAX05LA227.md): Piper PA-28R-200 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Mar 11, 2005 · N2882R · Substantial damage
  > substantial damage to the airplane during an unknown phase of flight for undetermined reasons.
- [NTSB LAX04LA313](https://openairdocs.org/ntsb/LAX04LA313.md): Redgate Europa Classic · Marble Canyon, AZ · Accident · 2 fatal · Limited investigation · Final report · Sep 2, 2004 · N912EE · Destroyed
  > an in-flight collision with terrain for undetermined reasons.
- [NTSB DEN03FAMS1](https://openairdocs.org/ntsb/DEN03FAMS1.md): Beech F33A · Greer, AZ · Accident · 2 fatal · Missing aircraft · Final report · Sep 21, 2003 · N927JL · Destroyed
  > The airplane is missing for unknown reason.
- [NTSB LAX98FA064](https://openairdocs.org/ntsb/LAX98FA064.md): Piper PA-11 · Willow Beach, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 30, 1997 · N5532H · Destroyed
  > The pilot's failure to maintain control of the aircraft for undetermined reasons.
- [NTSB LAX91LA053](https://openairdocs.org/ntsb/LAX91LA053.md): Cessna T210N · Douglas, AZ · Accident · 2 fatal · Limited investigation · Final report · Dec 22, 1990 · XBBCR · Destroyed
  > An inflight loss of control of the airplane due to the pilot's physical impairment from the consumption of alcohol. A factor which contributed to the accident was an inoperative vacuum system.
- [NTSB LAX90LA158](https://openairdocs.org/ntsb/LAX90LA158.md): Bellanca 8KCAB · Phoenix, AZ · Accident · 1 fatal · Limited investigation · Final report · Jun 7, 1990 · N50353 · Destroyed
  > The pilot failed to maintain control of the airplane.
- [NTSB DEN88FA036](https://openairdocs.org/ntsb/DEN88FA036.md): Cessna A152 · Benson, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 8, 1987 · N234ZN · Destroyed
  > Abt 20 min after tkof, the acft crashed in VMC conds, aprx 26 mi along the route fm tucson to las cruces. Initial impactoccurred with the l wing hitting the top of a yucca plant as the acft was in a slgt nose down, l wing low attitude. Justbyd this point, the…
- [NTSB LAX87LA334](https://openairdocs.org/ntsb/LAX87LA334.md): Cessna 206 · Williams, AZ · Accident · 1 fatal · Limited investigation · Final report · Jul 26, 1987 · N4651Z · Destroyed
  > The aircraft was reported stolen on July 26, 1987. It is believed that the aircraft departed the grand canyon airport in grand canyon, Arizona on July 26, 1987, at 0300 MST. A search of records or airports in the area revealed that the aircraft was refueled…
- [NTSB LAX86FUJ02](https://openairdocs.org/ntsb/LAX86FUJ02.md): Cessna 182G · Gila Bend, AZ · Accident · 2 fatal · Final report · Dec 5, 1985 · N3205S · Destroyed
  > On December 4, 1985, at 1928 MST, a Cessna 182, N3205S, collided with a power utility pole near paloma, AZ. Visual meteorological conditions prevailed at the time and no flight plan was filed. The aircraft was destroyed and the two people on board the…
- [NTSB LAX85FA150](https://openairdocs.org/ntsb/LAX85FA150.md): Jim Mckinstry Arestia Ganador · Marana, AZ · Accident · 1 fatal · Field investigation · Final report · Feb 22, 1985 · N2JM · Destroyed
  > The aircraft was observed to land fast from a low approach with its canopy open. The aircraft then veered right, and went over on its back at the edge of the runway where it burned. One counterweight had separated from the propeller hub assembly and was not…
- [NTSB LAX84FA421](https://openairdocs.org/ntsb/LAX84FA421.md): Fairchild Hiller FH-1100 · Meadview, AZ · Accident · 3 fatal · Field investigation · Final report · Jul 29, 1984 · N711KH · Destroyed
  > Purpose of the flt was s sightseeing tour of lake mead, hoover dam and the western rim of the grand canyon. Before reaching the canyon the flt was to travel over a 5500 ft MSL ridge. The helicopter contacted a juniper tree at the bottom of a 3-sided canyon at…
- [NTSB LAX84LA354](https://openairdocs.org/ntsb/LAX84LA354.md): Cessna T210N · Camp Verde, AZ · Accident · No injuries · Limited investigation · Final report · Jun 15, 1984 · N6406Y · Substantial damage
  > The plt reported that during the landing, the acft rolled about 200 to 250 ft after touchdown, then began veering to the left. He attempted to maintain directional control by applying right rudder & brake, but was unusccessful. The left main gear hit a berm,…
- [NTSB LAX84FA258](https://openairdocs.org/ntsb/LAX84FA258.md): Bellanca 7AC · Skull Valley, AZ · Accident · 2 fatal · Field investigation · Final report · Apr 16, 1984 · N85034 · Destroyed
  > The acft had been flown on several local flts, earlier that day. The last known flt originated at the ernest j love arpt, prescott, AZ, at 1600 MST. Subsequently, it crashed near the departure end of rwy 02 at the quarter circle 'j' arpt, which was in the…
- [NTSB LAX83FA260](https://openairdocs.org/ntsb/LAX83FA260.md): Piper PA-32 300C · Buckeye, AZ · Accident · 2 fatal · Field investigation · Final report · Jun 1, 1983 · N8926N · Destroyed
  > The acft collided with a utility pole about 36 ft AGL less than a mile north of a private dirt airstrip. The acft had departed scottsdale municipal arpt at about 0045. The accident occurred at about 0200 aproximately 4 miles west of Buckeye,AZ. A witness…
- [NTSB LAX82DA359](https://openairdocs.org/ntsb/LAX82DA359.md): Piper PA-18 · Casa Grande, AZ · Accident · 1 fatal · Final report · Sep 27, 1982 · N1851A · Destroyed
  > Student pilot with no night flying experience flew into wires at night on a personal flight with a passenger. VFR conditions existed and no flight plan was filed.
- [NTSB LAX80FA115](https://openairdocs.org/ntsb/LAX80FA115.md): Cessna 172M · Tombstone, AZ · Accident · 2 fatal · Closed · Jul 4, 1980 · N73290 · Destroyed
- [NTSB LAX80FA012](https://openairdocs.org/ntsb/LAX80FA012.md): Piper PA-28 · Phoenix, AZ · Accident · 2 fatal · Closed · Nov 10, 1979 · N6350W · Destroyed
- [NTSB LAX79DUK13](https://openairdocs.org/ntsb/LAX79DUK13.md): Rockwell 112TC · Tucson, AZ · Accident · No injuries · Closed · Jun 6, 1979 · N4564W · Destroyed
- [NTSB LAX77FUJ87](https://openairdocs.org/ntsb/LAX77FUJ87.md): Cessna 182 · Wellton, AZ · Accident · Serious injuries · Closed · Aug 8, 1977 · N1367S · Substantial damage
- [NTSB LAX77FUJ74](https://openairdocs.org/ntsb/LAX77FUJ74.md): Cessna 207 · Willcox, AZ · Accident · No injuries · Closed · Aug 3, 1977 · N9440G · Substantial damage
- [NTSB LAX77DUJ35](https://openairdocs.org/ntsb/LAX77DUJ35.md): Maule M-4210 · Prescott, AZ · Accident · No injuries · Closed · Feb 4, 1977 · N4745T · Substantial damage
- [NTSB LAX77DUJ25](https://openairdocs.org/ntsb/LAX77DUJ25.md): Champion 7GCAA · Marana, AZ · Accident · Minor injuries · Closed · Jan 28, 1977 · N5175T · Substantial damage
- [NTSB LAX76DUK05](https://openairdocs.org/ntsb/LAX76DUK05.md): Cessna 182 · Young, AZ · Accident · No injuries · Closed · Aug 13, 1976 · N2633Q · Destroyed
- [NTSB LAX76DUJ57](https://openairdocs.org/ntsb/LAX76DUJ57.md): Cessna 182 · Lukeville, AZ · Accident · No injuries · Closed · Dec 21, 1975 · N91592 · Substantial damage
- [NTSB LAX75DUJ80](https://openairdocs.org/ntsb/LAX75DUJ80.md): Cessna 182D · Mesa, AZ · Accident · No injuries · Closed · Mar 10, 1975 · N9076X · Substantial damage
- [NTSB LAX73DUJ30](https://openairdocs.org/ntsb/LAX73DUJ30.md): Cessna 182 · Tucson, AZ · Accident · No injuries · Closed · Oct 13, 1972 · XB-ZUM · Substantial damage
- [NTSB LAX72DUJ71](https://openairdocs.org/ntsb/LAX72DUJ71.md): Cessna 182 · Vail, AZ · Accident · No injuries · Closed · Jan 28, 1972 · XB-DOF · Destroyed
- [NTSB LAX69F0066](https://openairdocs.org/ntsb/LAX69F0066.md): Alon A-2 · Carefree, AZ · Accident · 1 fatal · Closed · Jul 22, 1968 · N5667F · Destroyed
- [NTSB LAX67A0109](https://openairdocs.org/ntsb/LAX67A0109.md): Helton LARK95 · Ft Mcdowell, AZ · Accident · 1 fatal · Closed · May 22, 1967 · N1509H · Destroyed
- [NTSB LAX67A0117](https://openairdocs.org/ntsb/LAX67A0117.md): Cessna 170 · Roosevelt, AZ · Accident · 1 fatal · Closed · Jun 19, 1966 · N9724A · Destroyed
- [NTSB UNK65X0974](https://openairdocs.org/ntsb/UNK65X0974.md): Cessna 172 · Kingman, AZ · Accident · No injuries · Closed · Dec 11, 1964 · N1326Y · Substantial damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 990)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/990/cases?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.