NTSB investigations, 2010, CO

8 cases where the sequence of events included Hard landing.

Cases per year

20082026
NTSB investigations, 2010, CO per year, 2008–2026: 73 cases
20084
20094
20108
20115
20122
20137
20143
20153
20166
20175
20182
20194
20203
20211
20221
20233
20243
20253
20266

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\") = 2010
    AND c.\"eventStateOrRegion\" = 'CO' 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 CEN11CA068Accident · No injuriesData collectionFinal reportSchweizer 300C · Broomfield, COThe pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's improper execution of an autorotation, which resulted in a hard landing.Nov 14, 2010 · N299RJ · Substantial damageNTSB CEN11CA022Accident · No injuriesData collectionFinal reportSchweizer 269C · Englewood, COThe student pilot’s failure to maintain directional control of the helicopter during landing.Oct 16, 2010 · N20130 · Substantial damageNTSB CEN11CA031Accident · No injuriesData collectionFinal reportBeech A36 · Pagosa Springs, COThe pilot's improper flare, which resulted in a hard landing.Oct 14, 2010 · N4979M · Substantial damageNTSB CEN10LA563Accident · No injuriesLimited investigationFinal reportCessna 172S · Longmont, COThe pilot's inadequate landing flare and improper recovery from a bounced landing.Sep 22, 2010 · N2459K · Substantial damageNTSB CEN10CA545Accident · Serious injuriesData collectionFinal reportAerospatiale AS 355F1 · Pikes Peak, COThe helicopter's encounter with an unexpected downdraft, which resulted in a hard landing.Sep 17, 2010 · N5802W · Substantial damageNTSB CEN10CA528Accident · No injuriesData collectionFinal reportClem William B III Dominator Gyrocopter · Brighton, COThe pilot's failure to maintain control of the gyroplane during landing.Aug 15, 2010 · N36MR · Substantial damageNTSB CEN10CA485Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Mack, COThe flight instructor's failure to maintain control of the helicopter during a practice autorotation, which resulted in a hard landing.Aug 14, 2010 · N404LE · Substantial damageNTSB CEN10CA183Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Idledale, COThe flight instructor's delayed remedial actions to regain rotor rpm, resulting in a rapid descent and hard landing.Apr 4, 2010 · N67TK · Substantial damage