NTSB investigations, 2010, TX

7 cases where the sequence of events included Miscellaneous/other.

Cases per year

20082026
NTSB investigations, 2010, TX per year, 2008–2026: 107 cases
20086
20096
20107
20117
201211
20135
20143
20158
20167
20174
201816
20196
20207
20213
20223
20231
20242
20252
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\") = 2010
    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\" = '900' 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 CEN11CA046Accident · No injuriesData collectionFinal reportHughes J/Hughes J Rand-Robinson · Pearland, TXThe pilot's improper flare, which resulted in a hard landing. Contributing to the accident was an engine oil leak which partially obscured the pilot’s forward vision.Oct 29, 2010 · N128JH · Substantial damageNTSB CEN11CA059Accident · No injuriesData collectionFinal reportHawker MK-20 Sea Fury · Breakenridge, TXThe improperly adjusted brakes and the pilot's failure to lock the tailwheel, resulting in a loss of directional control. Contributing to the accident was the pilot's decision to continue flying the airplane with a known brake deficiency.Oct 20, 2010 · C-FGAT · Substantial damageNTSB CEN10CA466Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Pettus, TXThe pilot's decision to exit the helicopter with the engine running.Aug 8, 2010 · N792SH · Substantial damageNTSB CEN10FA448Accident · 2 fatalField investigationFinal reportAmerican Champion Aircraft Cor 7GCBC · Midlothian, TXThe flight instructor’s incapacitation due to preexisting but unrecognized coronary disease, and the student pilot’s distraction and inability to recover the airplane from a stall/spin at low altitude.Jul 31, 2010 · N5027G · Substantial damageNTSB CEN10CA369Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Austin, TXThe pilot's failure to maintain directional control of the helicopter, resulting in impact with trees. Contributing to the accident was the pilot's failure to ensure the door was properly secured prior to flight.Jul 4, 2010 · N74546 · Substantial damageNTSB CEN10CA213Accident · No injuriesData collectionFinal reportWaco YPF-7 · Houston, TXThe pilot's inability to maintain control during landing due to the failure of the tailwheel locking mechanism to remain engaged prior to landing.Mar 27, 2010 · N32077 · Substantial damageNTSB CEN10FA107Accident · 2 fatalField investigationFinal reportCostruzioni Aeronautiche Tecna P2002 · Waxahachie, TXA loss of aircraft control while maneuvering for undetermined reasons.Jan 23, 2010 · N145AG · Substantial damage