NTSB investigations, 2008, TX

6 cases where the sequence of events included Ground collision.

Cases per year

20082026
NTSB investigations, 2008, TX per year, 2008–2026: 40 cases
20086
20093
20103
20113
20122
20131
20142
20151
20162
20182
20191
20211
20224
20232
20241
20253
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\") = 2008
    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\" = '200' 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 CEN09LA107Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Palenstine, TXThe failure of the pilot to ensure security of the cockpit switches before rotating the propeller.Dec 28, 2008 · N8212F · Substantial damageNTSB CEN09CA077Accident · No injuriesData collectionFinal reportPiper PA-15 · Pleasanton, TXThe pilot's failure to adequately secure the airplane while hand-starting the engine.Nov 30, 2008 · N4659H · Substantial damageNTSB DFW08CA154Accident · No injuriesData collectionFinal reportCessna 172M · San Antonio, TXThe pilot's failure to maintain clearance from an object while taxiing. Contributing to the accident were the pilot's diverted attention and a vehicle.May 28, 2008 · N9144H · Substantial damageNTSB DFW08LA144Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Roanoke, TXThe departing pilot's inadequate visual lookout resulting in his airplane colliding with the landing airplane. Contributing to the accident was the trees/visual obstructions along the runway's approach path.May 15, 2008 · N6805M · 2 aircraft · Substantial damageNTSB DFW08LA118Accident · No injuriesLimited investigationFinal reportVickers Spitfire · Galveston, TXThe Hurricane pilot's failure to maintain directional control during roll-out. Contributing factors were the restricted forward visibility of the tail-wheel equipped Spitfire, the lack of communication to the other aircraft following the Hurricane, and the…Apr 26, 2008 · N308WK · 2 aircraft · Substantial damageNTSB DFW08IA074Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Dallas, TXThe failure of the taxiing flight crew to maintain an adequate clearance from the stationary airplane.Mar 1, 2008 · N741SA · 2 aircraft · Minor damage