NTSB investigations, 2009, AZ

11 cases where the sequence of events included Hard landing.

Cases per year

20082026
NTSB investigations, 2009, AZ per year, 2008–2026: 96 cases
200811
200911
20107
20117
20128
20136
201410
20155
20162
20173
20181
20205
20214
20222
20235
20245
20252
20262

Latest 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 year(c.\"eventDate\") = 2009
    AND c.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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.

NTSB WPR10CA081Accident · No injuriesData collectionFinal reportCessna 182P · Payson, AZThe pilot's improper landing flare, which resulted in a hard landing.Dec 11, 2009 · N11PG · Substantial damageNTSB WPR10CA086Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Nogales, AZThe student's improper landing flare and the flight instructor's inadequate remedial action.Dec 3, 2009 · N2085T · Substantial damageNTSB WPR10CA028Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Marana, AZThe improper use of the throttle by the pilot receiving instruction, and the check pilot's inadequate supervision and delayed remedial action, which resulted in the collision with terrain.Oct 22, 2009 · N105LN · Substantial damageNTSB WPR09FA464Accident · No injuriesField investigationFinal reportEurocopter AS 350 B3 · Tucson, AZThe loss of directional control for undetermined reasons.Sep 25, 2009 · N103LN · Substantial damageNTSB WPR09CA462Accident · No injuriesData collectionFinal reportAgusta A109 · Page, AZA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate in-flight planning and his decision to continue flight with a known low fuel level state.Sep 22, 2009 · N129AL · Substantial damageNTSB WPR09CA360Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta · Jerome, AZThe pilot’s failure to maintain adequate main rotor rpm's, and the certified flight instructor’s inadequate supervision of the flight.Jul 21, 2009 · N747ER · Substantial damageNTSB WPR09LA480Accident · No injuriesLimited investigationFinal reportCessna R172K · Page, AZThe pilot's improper landing flare and inadequate recovery from a bounced landing.Jul 1, 2009 · N1055V · Substantial damageNTSB WPR09TA277Accident · No injuriesFinal reportHughes OH-6A · Benson, AZThe pilot under instruction's inadequate autorotation technique and the instructor pilot’s delayed remedial action to arrest the rate of descent of the helicopter while in an autorotation flare.Jun 4, 2009 · N6641D · Substantial damageNTSB WPR09LA125Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B2 · Cave Creek, AZThe pilot's misjudged landing flare. Contributing to the accident was the brownout condition created by the dust cloud that interfered with the pilot's perception of proximity to the ground, and the glare interference from the parked fire vehicles headlights…Feb 23, 2009 · N353P · Substantial damageNTSB DCA09FA028Accident · No injuriesField investigationFinal reportGeneral Atomics MQ-9 · Sierra Vista, AZThe student pilot's improper flare while landing with a tailwind and the instructor pilot's delayed response.Feb 19, 2009 · CBP-108 · Substantial damageNTSB WPR09CA106Accident · No injuriesData collectionFinal reportGrumman AA-5 · Payson, AZThe pilot's inadequate recovery from a bounced landing and failure to maintain directional control. Contributing to the accident was the crosswind condition.Feb 1, 2009 · N5423L · Substantial damage