NTSB investigations, AZ
151 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 3 |
| 1984 | 9 |
| 1985 | 1 |
| 1986 | 3 |
| 1987 | 4 |
| 1988 | 4 |
| 1989 | 5 |
| 1990 | 2 |
| 1991 | 6 |
| 1992 | 3 |
| 1993 | 5 |
| 1994 | 5 |
| 1995 | 5 |
| 1996 | 9 |
| 1997 | 3 |
| 1998 | 5 |
| 1999 | 5 |
| 2000 | 7 |
| 2001 | 6 |
| 2002 | 11 |
| 2003 | 11 |
| 2004 | 11 |
| 2005 | 6 |
| 2006 | 5 |
| 2007 | 10 |
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\" = 200)
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" = 200) 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 LAX08CA040Accident · No injuriesData collectionFinal reportEldredge Aircamper SDE · Sahuarita, AZThe pilot's failure to maintain adequate airspeed. A contributing factor was the pilot's distraction due to the presence of an automobile, which appeared to encroach upon the runway environment.NTSB LAX08CA031Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA-20-C1 · Mesa, AZthe student pilot's failure to maintain the proper glide path and misjudged flare, which resulted in a hard landing.NTSB LAX08CA010Accident · No injuriesData collectionFinal reportCessna 172R · Glendale, AZthe student pilot's improper bounced landing recovery technique, improper use of the flight controls, and the instructor's inadequate supervision of the flight.NTSB SEA07CA233Accident · No injuriesData collectionFinal reportRobinson R-22 Beta II · Tucson, AZThe student pilot's failure to maintain rotor RPM during landing approach, and the delayed remedial action by the flight instructor. A contributing factor was the high density altitude weather condition.NTSB LAX07CA226Accident · No injuriesData collectionFinal reportBeech C23 · Taylor, AZthe student pilot's misjudged landing flare and inadequate recovery from a bounced landing that resulted in a hard landing and a loss of directional control.NTSB LAX07CA171Accident · No injuriesData collectionFinal reportCessna 172S · Payson, AZThe pilot's inadequate in-flight planning/decision, excessive airspeed on final approach, and failure to execute a go-around resulting in a misjudged flare and hard landing.NTSB LAX07CA139Accident · No injuriesData collectionFinal reportCessna T206H · Grand Canyon, AZThe pilot's misjudged landing flare, which resulted in a bounced landing and a porpoise.NTSB SEA07CA077Accident · No injuriesData collectionFinal reportCessna 172S · Kingman, AZThe pilot's misjudged flare, which resulted in a hard landing and a porpoise.NTSB LAX07CA090Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Tucson, AZThe failure of the student pilot to maintain an adequate main rotor rpm and the instructor’s failure to maintain control of the aircraft.NTSB LAX07CA071Accident · Serious injuriesData collectionFinal reportBalloon Works Firefly 9B-15 · Peoria, AZThe balloon’s inadvertent encounter with a downdraft, which resulted in a hard landing.NTSB LAX07CA036Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Tucson, AZThe pilot's improper use of the spoilers during the landing flare, which resulted in a hard landing, and his inadequate bounced landing recovery technique.NTSB LAX07CA007Accident · No injuriesData collectionFinal reportCessna 172P · Glendale, AZthe student's inadequate compensation for the gusting crosswind and inadequate flare that resulted in a hard landing. The certified flight instructor's inadequate supervision of the flight is also causal.NTSB LAX06CA208Accident · No injuriesData collectionFinal reportCessna 210B · Flagstaff, AZThe pilot's misjudged flare and inadequate recovery from a bounced landing, which resulted in a hard landing and a porpoise.NTSB ANC06CA034Accident · No injuriesData collectionFinal reportPiper PA-22 · Grand Canyon, AZThe pilot's improper recovery from a bounced landing during touchdown, which resulted in a loss of control and encounter with terrain. Factors associated with the accident are the pilot's misjudged flare, and a gusty wind.NTSB ANC06CA036Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot's improper recovery from a bounced landing, which resulted in structural damage to the firewall and fuselage.NTSB LAX06CA003Accident · No injuriesData collectionFinal reportAerospatiale AS350B · Grand Canyon, AZthe pilot's failure to maintain control of the helicopter during landing in gusty wind conditions, which resulted in a hard landing and ground resonance.NTSB LAX06CA001Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Tucson, AZthe student pilot's failure to maintain adequate airspeed and rotor rpm during a practice autorotation, and the instructor's failure to adequately monitor the maneuver, which resulted in a hard landing and roll over.NTSB LAX05CA299Accident · No injuriesData collectionFinal reportCessna 172S · San Manuel, AZThe pilot's misjudged flare during a touch-and-go landing.NTSB LAX05LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Tucson, AZThe student pilot's improper flare that induced a porpoise, which resulted in the overload failure of the nose wheel assembly.NTSB LAX05CA181Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Tucson, AZthe improper flare by an undetermined crewmember, which resulted in a hard landing.NTSB LAX05LA170Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Glendale, AZthe pilot's misjudged landing flare that resulted in a stall and hard landing.NTSB LAX05CA028Accident · No injuriesData collectionFinal reportCessna 172S · Chandler, AZthe pilot's improper flare, which resulted in a hard landing. Contributing factors were his improper recovery from the subsequent bounced landing and pilot-induced oscillations.NTSB LAX04CA310Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-33A · Maricopa, AZthe pilot's encounter with a dust devil during landing flare, which resulted in a hard touchdown.NTSB LAX04CA289Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Scottsdale, AZthe pilot's misjudged flare, resulting in a stall and hard landing, and his failure to maintain directional control. The pilot's improper recovery from a bounced landing is a contributing factor.NTSB LAX04LA285Accident · No injuriesLimited investigationFinal reportEurocopter France AS350B3 · Cibecue, AZthe pilot's failure to maintain a proper decent rate during the landing approach and misjudged landing flare, which resulted in a hard landing. A factor in the accident was the brownout conditions created by the dust cloud that interfered with the pilot's…NTSB LAX04LA211Accident · No injuriesLimited investigationFinal reportCessna T182T · Paulden, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed.NTSB LAX04CA200Accident · No injuriesData collectionFinal reportCessna 182K · Phoenix, AZthe pilot's inadequate flare, which resulted in a hard landing. Also causal was the pilot's inadequate recovery from a bounced landing, which resulted in an inadvertent porpoise and collision with a sign.NTSB LAX04LA201Accident · No injuriesLimited investigationFinal reportCessna U206A · Lake Havasu, AZThe pilot's misjudged flare during landing, which resulted in a hard landing and structural damage to the firewall.NTSB LAX04LA149Accident · No injuriesLimited investigationFinal reportCessna 402A · Peach Springs, AZthe pilot's inadequate flare and touchdown that imparted high side loadings on the right main landing gear, which resulted in an overload failure of the landing gear bellcrank and the collapse of that gear.NTSB LAX04CA122Accident · No injuriesData collectionFinal reportMcDonnell Douglas 369FF · Mesa, AZthe pilot's inadequate compensation for the wind gusts and subsequent failure to maintain directional control of the helicopter, which resulted in a hard landing. A contributing factor was a wind gust.NTSB LAX04LA119Accident · No injuriesLimited investigationFinal reportCessna 182S · Phoenix, AZthe pilot's misjudged landing flare, which led to a hard touchdown and a porpoise.NTSB LAX04CA097Accident · No injuriesData collectionFinal reportEurocopter AS350 B3 · Mesa, AZthe pilot's excessive flare and mistimed collective application during a practice autorotation, which resulted in a loss of main rotor rpm and a subsequent hard landing. Also causal, was the flight instructor's delayed remedial action and inadequate…NTSB LAX04LA247Accident · No injuriesLimited investigationFinal reportCessna 150M · Tucson, AZthe pilot's misjudged flare and improper recovery from a bounced landing, which resulted in a pilot induced porpoise/oscillation.NTSB LAX04CA063Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Morenci, AZthe pilot's excessive landing flare, which resulted in an improper touchdown and hard landing.NTSB LAX04CA059Accident · No injuriesData collectionFinal reportCessna 172N · Winslow, AZthe pilot's misjudged landing flare, which resulted in a pilot induced porpoise oscillation and hard landing.NTSB LAX04CA014Accident · Minor injuriesData collectionFinal reportMayfield RAF 2000 · Buckeye, AZthe pilot misjudged the landing flare.NTSB LAX04CA008Accident · No injuriesData collectionFinal reportVelocity XL · Casa Grande, AZthe pilot's misjudged landing flare and inadequate compensation for crosswind conditions, which resulted in his failure to maintain runway alignment.NTSB LAX03CA288Accident · No injuriesData collectionFinal reportCessna 172M · Tucson, AZthe pilot's improper flare. A contributing factor was the tailwind.NTSB LAX03CA257Accident · No injuriesData collectionFinal reportLancair 235 · Page, AZThe pilot's misjudged landing flare, which resulted in a hard landing and his improper recovery from a bounced landing. Inadvertent entry into a porpoise pilot-induced oscillation, and high density altitude were contributing factors.NTSB LAX03LA231Accident · No injuriesLimited investigationFinal reportCessna 172S · Chandler, AZThe pilot's misjudged landing flare, improper recovery from a bounced landing and failure to maintain directional control, resulting in a runway sign collision.NTSB LAX03CA248Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe student's misjudged landing flare and inadvertent entry into a porpoise pilot-induced oscillation.NTSB LAX03LA191Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Phoenix, AZThe student pilot's improper use of the throttle control, the certified flight instructor (CFI) inadequate supervision, and the student's control interference, which resulted in a loss of main rotor rpm.NTSB LAX03LA115Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Chandler, AZThe student pilot's improper flare and his failure to maintain directional control. A contributing factor is the student pilot's improper recovery from a bounced landing.NTSB LAX02LA284Accident · No injuriesLimited investigationFinal reportSiemens Rotorway Exec 162 F · Overgaard, AZThe pilot's failure to check the wind direction prior to practicing autorotations, and his misjudged flare maneuver. The tailwind was a factor.NTSB LAX02LA239Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Prescott, AZthe student pilot's failure to maintain adequate main rotor rpm, the CFI's delayed remedial action and inadequate supervision of the flight, resulting in a hard landing. Wind gusts and the high density altitude were factors in the accident.NTSB LAX02LA222Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Mesa, AZthe pilot's inadequate compensation for the crosswind conditions, and failure to maintain an appropriate airspeed for the gusts, which resulted in a hard landing.NTSB LAX02LA194Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sedona, AZThe pilot's inadequate recovery from a bounced landing.NTSB LAX02LA167Accident · No injuriesLimited investigationFinal reportCessna 172S · Scottsdale, AZthe student pilot's improper recovery from a bounced landing and failure to maintain directional control on the landing roll, which resulted in a collision with a runway sign.NTSB LAX02LA168Accident · No injuriesLimited investigationFinal reportCessna 170B · Show Low, AZThe pilot's improper recovery from a bounced landing resulted in a loss of aircraft control. A factor was a sudden wind shift on final approach.NTSB LAX02LA153Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Green Valley, AZThe pilot's failure to identify the wind direction, which led to an attempted downwind landing approach that resulted in a hard landing and severe bounce. Also causal was the pilot's failure to promptly retract the flaps during the rejected landing after…