NTSB investigations, 2008, TX

14 cases where the sequence of events included Loss of control on ground.

Cases per year

20082026
NTSB investigations, 2008, TX per year, 2008–2026: 319 cases
200814
200917
201020
201116
201213
201316
201414
201517
201628
201712
201818
201915
202019
202110
202225
202323
202415
202511
202616

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\" = '230' 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 CEN09CA048Accident · No injuriesData collectionFinal reportCessna 152 · Spring, TXFailure of the student pilot to apply appropriate actions following a bounced landing.Nov 3, 2008 · N47221 · Substantial damageNTSB CEN09CA042Accident · No injuriesData collectionFinal reportCessna 172H · Ingleside, TXThe pilot's decision to land in crosswind conditions, leading to his inability to maintain directional control. Contributing to the accident were the crosswinds.Oct 27, 2008 · N1714F · Substantial damageNTSB CEN09LA036Accident · No injuriesLimited investigationFinal reportCessna 180 · Justin, TXThe pilot's failure to maintain control of the airplane during landing.Oct 26, 2008 · N1846Z · Substantial damageNTSB CEN09CA027Accident · Minor injuriesData collectionFinal reportCessna 180 · Denton, TXThe pilot's loss of directional control and subsequent "ground-loop."Oct 19, 2008 · N1729F · Substantial damageNTSB DFW08LA231Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Roanoke, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot's lack of flight experience in the make and model of airplane.Sep 12, 2008 · N901LA · Substantial damageNTSB DEN08LA112Accident · No injuriesLimited investigationFinal reportCessna 195 · Houston, TXThe pilot's failure to maintain directional control, causing the design stress limits of the airplane to be exceeded. Excessive sideloads incurred caused the right main landing gear wheel and strut to fail.Jun 23, 2008 · N4426C · Substantial damageNTSB DFW08CA151Accident · No injuriesData collectionFinal reportCessna CE-172M · San Antonio, TXThe student pilots improper short field landing procedure and excessive rate of descent. A contributing factor was the student pilots improper recovery from a bounced landing.May 18, 2008 · N1281U · Substantial damageNTSB DFW08CA141Accident · No injuriesData collectionFinal reportPiper PA-30 · Houston, TXThe pilot's loss of directional control during the landing. A contributing factor was the flight instructor's delayed remedial action.May 12, 2008 · N8511Y · 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 DFW08CA102Accident · No injuriesData collectionFinal reportNorth American T-6G · Dallas, TXThe pilot's failure to maintain directional control while landing.Apr 19, 2008 · N3518G · Substantial damageNTSB DFW08CA098Accident · No injuriesData collectionFinal reportWeatherly 620B · Coleman, TXThe pilot's failure to maintain airplane control on the landing roll. A contributing factor was the variable wind.Apr 13, 2008 · N2035J · Substantial damageNTSB DFW08CA096Accident · No injuriesData collectionFinal reportCessna C-182 · Porter, TXThe pilot's loss of directional control due to the partial failure of the left brake.Apr 6, 2008 · N42892 · Substantial damageNTSB DFW08CA072Accident · No injuriesData collectionFinal reportBeech 58P · Hereford, TXThe pilot's loss of control on landing. A factor was a gusting crosswind component.Jan 16, 2008 · N42SM · Substantial damageNTSB DFW08CA054Accident · No injuriesData collectionFinal reportMicco MAC-145B · Arcola, TXThe pilot's failure to maintain directional control. A contributing factor was the prevailing crosswind.Jan 1, 2008 · N579RM · Substantial damage