NTSB investigations, 2009, TX

11 cases where the sequence of events included Runway excursion.

Cases per year

20082026
NTSB investigations, 2009, 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\") = 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\" = '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 CEN09CA585Accident · Minor injuriesData collectionFinal reportCessna 170B · Dalhart, TXThe pilot’s decision to land with a tailwind resulting in a loss of directional control.Sep 11, 2009 · N2929N · Substantial damageNTSB CEN09CA581Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Spicewood, TXThe pilot's failure to maintain directional control of the airplane during landing.Sep 5, 2009 · N117EM · Substantial damageNTSB CEN09CA484Accident · Minor injuriesData collectionFinal reportPiper PA22 · Terrell, TXThe pilot's improper decision to continue the approach and landing during thunderstorm activity, resulting in the loss of aircraft control.Aug 1, 2009 · N8602C · 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 CEN09TA374Accident · Minor injuriesFinal reportPiper PA-18-150 · Alpine, TXThe pilot's failure to maintain control of the aircraft.Jun 22, 2009 · N2320P · Substantial damageNTSB CEN09CA346Accident · No injuriesData collectionFinal reportMeyers OTW · Haskell, TXThe pilot's failure to maintain directional control while landing in a crosswind.Jun 8, 2009 · N34335 · Substantial damageNTSB CEN09LA329Accident · Serious injuriesLimited investigationFinal reportJohnston Coyt E T-18 · Granbury, TXThe pilot's failure to maintain directional control during landing.May 29, 2009 · N118TX · Substantial damageNTSB CEN09CA310Accident · No injuriesData collectionFinal reportLuscombe 8E · Ozona, TXThe pilot's failure to maintain directional control of the airplane during landing.May 21, 2009 · N2450K · 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 CEN09CA246Accident · No injuriesData collectionFinal reportCessna 195 · Burnet, TXThe pilot's inadequate compensation for the gusting crosswinds during landing.Apr 9, 2009 · N4495C · Substantial damageNTSB CEN09CA184Accident · No injuriesData collectionFinal reportMarrero Andres Starduster · San Antonio, TXThe pilot's loss of control during take off. Contributing to the accident was the crosswind component.Mar 2, 2009 · N2262D · Substantial damage