NTSB investigations, 2009, TX

32 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2009, TX per year, 2008–2026: 786 cases
200856
200932
201049
201158
201259
201349
201453
201559
201668
201744
201864
201953
202031
202120
202222
202321
202420
202514
202614

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\" = '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\" = '470' 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 CEN10CA081Accident · Minor injuriesData collectionFinal reportCessna 182P · Bowie, TXA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to properly secure the right wing fuel cap and monitor the available fuel supply.Dec 25, 2009 · N21177 · Substantial damageNTSB CEN10LA052Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Saginaw, TXThe pilot's inability to maintain control of the airplane due to a pinched trim system wire that resulted in a runaway nose-down pitch trim.Nov 17, 2009 · N8297P · Substantial damageNTSB CEN10FA044Accident · 3 fatalField investigationFinal reportBeech A36 · Spring Branch, TXThe pilot's failure to maintain control of the airplane during cruise flight in instrument meteorological conditions. Contributing to this accident was the pilot’s lack of recent experience in flying in instrument meteorological conditions.Nov 8, 2009 · N91TD · Substantial damageNTSB CEN10LA041Accident · 2 fatalLimited investigationFinal reportWicks Air Center Hornet · Bonham, TXThe pilot's loss of control shortly after takeoff due to spatial disorientation in fog and/or low-level clouds.Nov 7, 2009 · N651WA · DestroyedNTSB CEN10LA039Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Brenham, TXThe loss of engine power (right engine) during initial climb for undetermined reasons.Nov 4, 2009 · N725GS · Substantial damageNTSB CEN10FA007Accident · Serious injuriesField investigationFinal reportBeech 100 · Aurora, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.Oct 6, 2009 · N2TX · Substantial damageNTSB CEN10TA006Accident · No injuriesFinal reportBeech E18S · Jones Creek, TXThe pilot's failure to see and avoid the radio tower.Oct 3, 2009 · N797SB · Substantial damageNTSB CEN10LA005Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Refugio, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management. Contributing to the accident was the pilot's failure to follow the correct engine restart checklist.Oct 2, 2009 · N991PP · Substantial damageNTSB CEN09LA572Accident · Minor injuriesLimited investigationFinal reportWright Bruce M Avid Flyer · Hitchcock, TXA total loss of engine power for undetermined reasons.Sep 3, 2009 · N583AF · Substantial damageNTSB CEN09LA445Accident · Serious injuriesLimited investigationFinal reportMarvin Faulk Tinker Bell · La Porte, TXThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in a collision with terrain.Jul 18, 2009 · N62431 · Substantial damageNTSB CEN09LA442Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Boyd, TXA total loss of engine power due to the pilot's improper leaning procedures, resulting in a forced landing and collision with a fence.Jul 14, 2009 · N2446F · Substantial damageNTSB CEN09FA405Accident · 1 fatalField investigationFinal reportBeech C35 · Weslaco, TXThe pilot's failure to maintain aircraft control while operating with a fuel imbalance. Contributing to the accident was the pilot/owner's decision to fly the airplane outside of the operating limitations.Jul 3, 2009 · N2043D · Substantial damageNTSB CEN09LA400Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Bastrop, TXA loss of engine power due to fuel exhaustion as a result of the pilot's failure to properly verify the fuel load prior to departure.Jun 29, 2009 · N220TX · Substantial damageNTSB CEN09CA383Accident · No injuriesData collectionFinal reportPietenpol GN-1 · Waxahachie, TXThe pilot's failure to maintain control of the airplane during a landing.Jun 24, 2009 · N1736 · DestroyedNTSB CEN09CA382Accident · Serious injuriesData collectionFinal reportBakeng Deuce · Beach City, TXThe loss of engine power due to fuel starvation resulting from a partially crimped fuel tank vent tube.Jun 24, 2009 · N26MR · Substantial damageNTSB CEN09LA375Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Mineola, TXThe pilot's failure to maintain control of the airplane during taxi, and his subsequent failure to maintain control after the inadvertent takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of flight experience.Jun 23, 2009 · N2719S · Substantial damageNTSB CEN09CA349Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Hamilton, TXThe pilot's failure to maintain clearance from a tree while on short final.Jun 7, 2009 · N3812F · Substantial damageNTSB CEN09CA315Accident · No injuriesData collectionFinal reportHolsclaw Francis E Starduster · Ranger, TXThe pilot's inability to maintain directional control due to the buckling of the right landing gear as a result of corrosion.May 23, 2009 · N42WT · Substantial damageNTSB CEN09CA298Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Midland, TXThe student pilot's failure to maintain directional control during takeoff.May 14, 2009 · N225BC · Substantial damageNTSB CEN09CA290Accident · No injuriesData collectionFinal reportBolton Ricky D Rotorway E · Brookeland, TXThe pilot failed to maintain control while hovering in gusty conditions.May 10, 2009 · N602DB · Substantial damageNTSB CEN09LA288Accident · 1 fatalLimited investigationFinal reportSmysor Kevin Velocity · Katy, TXThe pilot's loss of control following an in-flight failure of the propeller.May 9, 2009 · N45YV · Substantial damageNTSB CEN09LA284Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Alpine, TXThe loss of engine power due to disengagement of the magneto idler gear support pin.May 8, 2009 · N60HG · Substantial damageNTSB CEN09CA253Accident · No injuriesData collectionFinal reportCessna 172N · Roanoke, TXThe partial loss of engine power due to a failure of the throttle control rod-end to carburetor arm hardware. A contributing factor was the pilot's decision to fly the airplane without a current annual inspection.May 8, 2009 · N172SV · Substantial damageNTSB CEN09FA241Accident · 1 fatalField investigationFinal reportCessna T210N · Edinburg, TXA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to select a suitable alternate landing site.Apr 9, 2009 · N127TC · DestroyedNTSB CEN09LA233Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Georgetown, TXA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management. Contributing to the accident was the pilot's improper engine restart procedures.Mar 29, 2009 · N210BF · Substantial damageNTSB CEN09CA180Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · O'Donnell, TXThe pilot's failure to maintain control while performing a quick stop maneuver to an out of ground effect (OGE) hover. Contributing to the accident was the high density altitude and near calm wind condition.Feb 25, 2009 · N387AC · Substantial damageNTSB CEN09CA157Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Cypress, TXThe student pilot's failure to maintain adequate main rotor rpm and the instructor's delayed remedial action.Feb 6, 2009 · N234LA · Substantial damageNTSB CEN09LA144Accident · 3 fatalLimited investigationFinal reportCox William M Bearhawk · Anahuac, TXA loss of control in flight for undetermined reasons.Jan 29, 2009 · N3WC · Substantial damageNTSB CEN09MA142Accident · Serious injuriesClass 1 · MajorFinal reportAerospatiale Alenia ATR 42-320 · Lubbock, TXThe flight crew's failure to monitor and maintain a minimum safe airspeed while executing an instrument approach in icing conditions, which resulted in an aerodynamic stall at low altitude. Contributing to the accident were 1) the flight crew's failure to…Jan 27, 2009 · N902FX · Substantial damageNTSB CEN09LA143Accident · No injuriesLimited investigationFinal reportCessna 172E · Plano, TXA loss of engine power in flight due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Jan 23, 2009 · N5420T · Substantial damageNTSB CEN09LA128Accident · 1 fatalLimited investigationFinal reportProbst Baby Ace D · Kilgore, TXA loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel planning. Contributing to the accident was the pilot's failure to maintain situational awareness, resulting in him being lost.Jan 12, 2009 · N610DD · Substantial damageNTSB CEN09FA115Accident · 2 fatalField investigationFinal reportNanchang China CJ-6 · Justin, TXThe pilot's failure to maintain adequate airspeed while maneuvering on approach, which resulted in an accelerated stall and subsequent loss of control.Jan 3, 2009 · N99YK · Destroyed