NTSB investigations, 2018, TX

15 cases where the sequence of events included Runway excursion.

Cases per year

20082026
NTSB investigations, 2018, 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\") = 2018
    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 GAA19CA119Accident · No injuriesData collectionFinal reportCessna 172 · Sugar Land, TXThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a sign.Dec 27, 2018 · N17SJ · Substantial damageNTSB GAA19CA129Accident · No injuriesData collectionFinal reportCessna 182 · Marshall, TXThe pilot's failure to maintain directional control during landing.Dec 21, 2018 · N23YR · Substantial damageNTSB GAA19CA019Accident · No injuriesData collectionFinal reportChampion 7ECA · Cleveland, TXThe pilot’s failure to maintain directional control while landing in a gusting crosswind conditions.Oct 5, 2018 · N36268 · Substantial damageNTSB GAA18CA507Accident · Minor injuriesData collectionFinal reportVans RV10 · Spring Branch, TXThe pilot's failure to maintain the proper glidepath and his subsequent abrupt maneuver to avoid trees, which led to the exceedance of the airplane's critical angle of attack and resulted in an aerodynamic stall during landing and a subsequent loss of…Aug 23, 2018 · N110DV · Substantial damageNTSB CEN18LA341Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Granbury, TXThe pilot’s failure to maintain directional control during a crosswind landing, which resulted in the airplane exiting the runway and impacting a ditch, tree, and fence.Aug 20, 2018 · N1133T · Substantial damageNTSB CEN18TA330Accident · No injuriesFinal reportPiper J3C · Friendswood, TXThe pilot's decision to conduct a flight in an airplane that had a tailwheel with degraded locking pins, which allowed the tailwheel to unlock and swivel out of alignment and precluded the pilot from regaining directional control on the ground during a…Aug 13, 2018 · N42218 · Substantial damageNTSB GAA18CA403Accident · No injuriesData collectionFinal reportRockwell 114 · Corsicana, TXThe pilot’s failure to maintain the runway heading during a soft-field takeoff with a tailwind, which resulted in a rejected takeoff.Jul 7, 2018 · N314CT · Substantial damageNTSB GAA18CA346Accident · No injuriesData collectionFinal reportPiper PA32R · Caddo Mills, TXThe student pilot’s failure to extend the landing gear before landing and to follow the Before Landing checklist, which resulted in an attempted go-around and subsequent hard landing.Jun 13, 2018 · N82303 · Substantial damageNTSB GAA18CA242Accident · No injuriesData collectionFinal reportSeno Louis C SR KIS · Eagle Lake, TXThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.Apr 29, 2018 · N66SK · Substantial damageNTSB GAA18CA233Accident · No injuriesData collectionFinal reportMooney M20F · Bulberde, TXThe pilot’s unstabilized approach, which resulted in the airplane landing long and fast, and the pilot’s subsequent decision to steer the airplane off the side of the runway to avoid a runway overrun.Apr 19, 2018 · N3535X · Substantial damageNTSB GAA18CA224Accident · No injuriesData collectionFinal reportMooney M20R · San Antonio, TXThe pilot’s landing long in tailwind conditions with insufficient runway remaining to stop the airplane.Apr 16, 2018 · N6868 · Substantial damageNTSB GAA18CA205Accident · No injuriesData collectionFinal reportLuscombe 8 · Vernon, TXThe pilot’s failure to maintain directional control during landingApr 5, 2018 · N71617 · Substantial damageNTSB CEN18LA127Accident · Minor injuriesLimited investigationFinal reportMX MXS · Fulton, TXA total loss of engine power due to the fatigue failure of the crankshaft, which resulted in the pilot’s forced landing to an abandoned airport and the airplane’s subsequent impact with debris on the runway.Mar 25, 2018 · N540JH · Substantial damageNTSB GAA18CA170Accident · No injuriesData collectionFinal reportCessna 172 · Vernon, TXThe pilot's failure to maintain directional control while landing in gusty crosswind conditions.Mar 19, 2018 · N1103F · Substantial damageNTSB GAA18CA118Accident · No injuriesData collectionFinal reportSomerton David J JA30 Superstol · Kerrville, TXThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.Feb 5, 2018 · N726AD · Substantial damage