NTSB investigations, 2008, TX

8 cases where the sequence of events included Runway excursion.

Cases per year

20082026
NTSB investigations, 2008, TX per year, 2008–2026: 262 cases
20088
200911
201019
201112
201213
20139
201416
201514
201624
201710
201815
201913
202012
202113
202213
202321
202418
202510
202611

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\" = '300' 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 CEN09CA020Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lufkin, TXThe student pilot's improper decision to takeoff with a known brake problem. Contributing to the accident were the malfunctioning brake and the rough terrain in the excursion area.Oct 11, 2008 · N764C · 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 DFW08CA165Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Taylor, TXThe student pilot's improper flare during landing. Contributing to the accident was the gusty winds.Jun 15, 2008 · N2345G · Substantial damageNTSB DFW08CA107Accident · Minor injuriesData collectionFinal reportTecnam P2002 Sierra · La Porte, TXThe student pilot's improper recovery from the bounced landing and the instructor's delayed remedial action.Apr 19, 2008 · N532MA · 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 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