NTSB investigations, 2013, AZ

6 cases where the sequence of events included Hard landing.

Cases per year

20082026
NTSB investigations, 2013, 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\") = 2013
    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 WPR13LA390Accident · Serious injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · Payson, AZA partial loss of engine power due to an overtemperature event that thermally damaged the turbine blades and vanes, which resulted in a hard landing.Aug 28, 2013 · N2018R · Substantial damageNTSB WPR13CA375Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot’s improper flare, which resulted in a hard landing.Aug 10, 2013 · N544ER · Substantial damageNTSB WPR13LA290Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Casa Grande, AZThe total loss of engine power due to the ingestion of a foreign object and maintenance personnel's failure to remove shop rags before completing the installation of the air inlet barrier system.Jun 25, 2013 · N34CT · Substantial damageNTSB WPR13TA198Accident · No injuriesFinal reportBell OH-58C · Phoenix, AZThe pilot receiving instruction's delay in adding power during a recovery from a practice autorotation.Apr 12, 2013 · N119FT · Substantial damageNTSB WPR13CA155Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Chino Valley, AZThe pilot receiving instruction’s failure to maintain rotor rpm during the pinnacle landing. Contributing to the accident was the flight instructor’s delayed remedial action.Mar 18, 2013 · N223G · Substantial damageNTSB WPR13LA099Accident · No injuriesLimited investigationFinal reportGoetz Helicycle · Mesa, AZThe pilot's failure to properly install and secure the wire connecting the electronic speed controller unit to the fuel controller actuator motor, which resulted in the wire’s disconnection in flight and the resultant partial loss of engine power.Jan 22, 2013 · N143PG · Substantial damage