NTSB investigations, AZ
17 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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\" = 320)
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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" = 320) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA07CA180Accident · No injuriesData collectionFinal reportRobinson R22 · Tucson, AZThe certified flight instructor's inadequate supervision of the practice autorotation. Contributing factors included the terrain drop off and the failure of the pilot undergoing instruction to maintain adequate rotor rpm.NTSB LAX07LA024Accident · No injuriesLimited investigationFinal reportCessna U206G · Willcox, AZThe pilot's misjudged flare and porpoising during landing.NTSB LAX05CA001Accident · No injuriesData collectionFinal reportCessna TU206A · Nogales, AZthe pilot's failure to remain on the designated taxiway surface, which resulted in the airplane's collision with the ditch. The dark lighting condition was a factor to the accident.NTSB LAX98LA121Accident · No injuriesLimited investigationFinal reportCessna 421B · Show Low, AZThe pilot's failure to attain the proper alignment on the runway due to the obscuration by snow of the runway and on the airplane's windows.NTSB LAX97LA174Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Peoria, AZfailure of the student pilot to maintain proper runway alignment and wing tip clearance from high vegetation beside the runway during landing, and the flight instructor's inadequate supervision of the flight. High vegetation on the runway shoulder was a…NTSB LAX96LA337Accident · No injuriesLimited investigationFinal reportCessna 152 · San Carlos, AZthe pilot's decision to attempt a takeoff with the runway lights inoperative, and his failure to maintain runway alignment during an aborted takeoff, after failure of the landing light. Factors relating to the accident were: darkness, inoperative runway…NTSB LAX92LA340Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tolleson, AZThe pilot's selection of unsuitable terrain for takeoff. Contributing to this accident was the ravine that crossed the runway.NTSB LAX92LA071Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZThe failure of the pilot to maintain an adequate visual lookout while taxiing the aircraft.NTSB LAX89LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Flagstaff, AZThe pilot's failure to maintain proper runway alignment while expediting to exit the runway. His lack of experience in this type of aircraft, self-induced pressure & the snow covered terrain were contributing factors.NTSB LAX88LA286Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Parker, AZThe pilot reported that just after tkof from a river the eng was not developing sufficient power to maintain altitude. The pilot made a landing and during the landing roll collided with rough terrain. After the accident, the engine was test run and found to…NTSB LAX85LA357Accident · No injuriesLimited investigationFinal reportCessna 172P · Glendale, AZThe acft ran off the rwy and into a ditch after a landing at Glendale, AZ. The rwy is 2400 ft long and 50 ft wide. The plt stated he landed about 40% down the rwy, bounced three times, steered off the rwy and hit a shallow ditch. The plt reported no…NTSB LAX84LA427Accident · No injuriesLimited investigationFinal reportCessna TU206C · Catalina, AZThe acft ran into ruts washed out by recent rains on a private arpt. The plt reported that he circled the arpt to look for hazards. He concluded that it was ok to land. After the accident he said that he should have called the arpt operator prior to flying…NTSB LAX84LA297Accident · No injuriesLimited investigationFinal reportLet L-13 · El Mirage, AZThe glider plt reported that after a release from the tow line, he had difficulty finding lift. He concentrated on finding lift so much that he became disoriented with respect to the rwy. When he elected to return to the arpt, he inadvertently selected a…NTSB LAX84LA426Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · San Carlos, AZDuring a night landing on a road, the acft was damaged when it hit a berm. According to customs officials. The plt had circled while ground personnel placed rows of lights adjacent to the road, then he landed. There was evidence that illegal drugs had been…NTSB LAX84LA003Accident · No injuriesLimited investigationFinal reportBeech S35 · Elgin, AZWhile taking off from a dirt, ranch strip, the plt elected to use tracks that were worn in the vegetation beside the strip. He believed that these tracks had been formed by other acft & thought the takeoff would be smoother if he used them. However, the…NTSB LAX83LA363Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Clifton, AZThe acft collided with soft terrain and nosed over during an attempted takeoff. Custom officials said the acft was being tracked on radar. The plt of the accident acft saw the customs acft after he landed and attempted to takeoff, lost control and nosed over…NTSB LAX82DUJ34Accident · No injuriesFinal reportCessna 180K · Meadview, AZThe flight had originated at north las vegas, NV. According to the pilot, he landed at an unprepared strip when his engine did not sound right, but it checked out on the ground. While at the unprepared strip, the right tire blew out when it struck a rock.…