NTSB investigations, 2002, TX

10 cases where the first occurrence was “Loss of control - on ground/water”.

Cases per year

19822026
NTSB investigations, 2002, TX per year, 1982–2026: 390 cases
198228
198335
198425
198514
198620
198726
198816
198911
199012
19916
19926
199311
199410
19957
19969
199715
199812
199915
200012
200111
200210
200310
200420
200512
200617
200720

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\") = 2002
    AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
  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 FTW03LA065Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Denver City, TXThe pilot's inadequate compensation for the prevailing wind conditions. A contributing factor was the crosswind.Dec 21, 2002 · N9096Q · Substantial damageNTSB FTW03LA017Accident · No injuriesLimited investigationFinal reportCessna 172L · San Antonio, TXThe pilot's inadequate compensation for wind resulting in a loss of directional control. A contributing factor was the prevailing crosswind.Oct 11, 2002 · N7616G · Substantial damageNTSB FTW03LA001Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235C · San Antonio, TXThe pilot's failure to compensate for the existing winds conditions. A contributing factor was the prevailing tailwind.Oct 1, 2002 · N4269B · DestroyedNTSB FTW02CA207Accident · No injuriesData collectionFinal reportGulfstream American AA-5B · Spicewood, TXthe pilot's failure to maintain directional control during landing roll.Jul 13, 2002 · N358RW · Substantial damageNTSB FTW02LA202Accident · Minor injuriesLimited investigationFinal reportJackie SNS-7-Hiperbipe 3 · Lancaster, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A contributing factor was the pilot's failure to maintain directional control during takeoff roll.Jul 6, 2002 · N234JD · Substantial damageNTSB DEN02LA058Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Giddings, TXthe failure of the pilot to maintain aircraft control during the landing rollout. A contributing factor was the subsequent inadvertent ground loop of the airplane.Jun 24, 2002 · N83DH · Substantial damageNTSB FTW02LA126Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Powderly, TXthe pilot's failure to maintain directional control during the takeoff roll, which resulted in an encounter with muddy terrain and a nose over. Contributing factors to the accident were the crosswind and muddy terrain.Apr 22, 2002 · N89343 · Substantial damageNTSB FTW02LA122Accident · No injuriesLimited investigationFinal reportCessna 172R · McKinney, TXthe pilot's failure to maintain directional control of the airplane while taxiing from landing.Apr 13, 2002 · N58AF · Substantial damageNTSB ATL02FA058Accident · 1 fatalField investigationFinal reportBeech BE-60 · Mexia, TXThe pilot's failure to remove the control lock before the flight and his failure to follow the checklist.Mar 3, 2002 · N7272D · DestroyedNTSB FTW02LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Iraan, TXThe pilot's failure to maintain directional control during landing roll. Contributing factors were the pilot's selection of a downwind runway for landing, the tail wind condition, and his lack of total experience in the type of aircraft.Jan 15, 2002 · N509R · Substantial damage