NTSB investigations, 2021, TX

6 cases where the sequence of events included Hard landing.

Cases per year

20082026
NTSB investigations, 2021, TX per year, 2008–2026: 157 cases
200815
20099
20104
20116
201212
201310
20147
20158
20166
20177
201813
201910
20207
20216
20229
20239
20248
20258
20263

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\") = 2021
    AND c.\"eventStateOrRegion\" = 'TX' 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 CEN22LA078Accident · Minor injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 407 · Bridgeport, TXThe pilot’s failure to maintain adequate main rotor RPM during an autorotation which resulted in a hard landing. Contributing to the accident was the pilot’s improper placement of the throttle during the initial practice power-on recovery autorotation.Dec 14, 2021 · N862YB · Substantial damageNTSB CEN22LA033Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Freer, TXThe pilot’s encounter with ‘settling with power’ while maneuvering at a low altitude, which resulted in a rapid descent and subsequent hard landing.Nov 10, 2021 · N7198A · Substantial damageNTSB CEN21LA397Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · New Braunfels, TXThe pilot’s failure to maintain control of the airplane during landing.Aug 19, 2021 · N55245 · Substantial damageNTSB CEN21LA346Accident · Serious injuriesClass 3 · LimitedFinal reportHpH, Spol. S.R.O. Glasflügel 304S · Briggs, TXThe overstress fracture of the elevator control tube due to reduced wall thickness from water intrusion and subsequent corrosion. Contributing to the accident was the lack of a drain hole at the bottom of the elevator control tube, which allowed the tube to…Jul 30, 2021 · N304AB · Substantial damageNTSB CEN21LA170Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Boerne, TXThe pilot’s failure to maintain control of the airplane during a full stop landing and the subsequent attempted go-around in turbulent conditions.Mar 27, 2021 · N689PG · Substantial damageNTSB CEN21LA109Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Albany, TXThe pilot’s inadequate pretakeoff checks which resulted in the magneto switch (key) remaining in the OFF position during the takeoff sequence and initial climb and the right magneto grounding intermittently.Jan 9, 2021 · N322SH · Substantial damage