NTSB investigations, TX

9 cases where NTSB found Airport facilities/design.

Cases per year

20092026
NTSB investigations, TX per year, 2009–2026: 9 cases
20092
20122
20131
20201
20211
20221
20231

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 c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030170'))
  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 CEN23LA097Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172L · Cleveland, TXThe pilot’s decision to attempt the night flight under visual flight rules when instrument meteorological conditions prevailed resulting in the airplane striking trees while on final approach. Contributing to the accident were the unserviceable runway lights…Jan 29, 2023 · N621EW · Substantial damageNTSB CEN22LA293Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Bynum, TXThe pilot was not able to stop the airplane on the remaining runway after an aborted takeoff, which resulted in a runway excursion and the airplane impacting a fence.Jun 17, 2022 · N2975U · Substantial damageNTSB CEN21FA239Accident · 1 fatalClass 3 · FieldFinal reportPZL Warszawa-Okecie PZL-104 · Pearland, TXThe pilot’s loss of directional control during landing. Contributing to the severity of the accident was the presence of a drainage ditch between the runway and taxiway.May 29, 2021 · N124MS · Substantial damageNTSB CEN20CA218Accident · No injuriesClass 4 · Data collectionFinal reportGlasflugel Mosquito · Alvarado, TXThe pilot's decision to divert to the private airport and his subsequent failure to maintain directional control while landing on a turf runway that contained tall grass.Jun 4, 2020 · N24HC · Substantial damageNTSB CEN13LA170Accident · No injuriesLimited investigationFinal reportCessna 195 · Austin, TXThe pilot's use of an excessive taxi speed, which resulted in the airplane overrunning the end of the unlit taxiway after the failure of the right wing landing light.Feb 17, 2013 · N4426C · Substantial damageNTSB CEN13LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Roanoke, TXThe student pilot's failure to maintain clearance from obstacles on the runway approach path. Contributing to the accident was the airport management's decision to relocate the runway displaced threshold, which did not provide an adequate safety margin for…Nov 3, 2012 · N985GE · Substantial damageNTSB CEN12CA568Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Bogata, TXThe pilot’s inadequate preflight planning, which resulted in the airplane’s loading beyond its maximum gross weight.Aug 17, 2012 · N6047G · Substantial damageNTSB CEN09FA601Accident · 1 fatalField investigationFinal reportCessna T210 · Hilltop Lakes, TXThe loss of control of the airplane in dark night light conditions due to the pilot’s spatial disorientation.Sep 24, 2009 · N9734Y · DestroyedNTSB CEN09MA142Accident · Serious injuriesClass 1 · MajorFinal reportAerospatiale Alenia ATR 42-320 · Lubbock, TXThe flight crew's failure to monitor and maintain a minimum safe airspeed while executing an instrument approach in icing conditions, which resulted in an aerodynamic stall at low altitude. Contributing to the accident were 1) the flight crew's failure to…Jan 27, 2009 · N902FX · Substantial damage