NTSB investigations, 2002, TX

8 cases where the first occurrence was “In flight collision with object”.

Cases per year

19822026
NTSB investigations, 2002, TX per year, 1982–2026: 353 cases
198232
198324
198416
198517
198615
198713
19888
198918
19909
199111
199210
199313
199410
199516
199613
199712
199811
199919
200015
200113
20028
20038
200413
200515
20067
20077

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\" = 220)
  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 FTW03LA019Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Plainview, TXThe pilot's failure to maintain clearance with the wires. Contributing factors were the low ceilings and the prevailing haze.Oct 25, 2002 · N602GB · Substantial damageNTSB FTW02LA266Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Freer, TXThe pilot's failure to maintain clearance with the power lines while manuevering. A factor was the sunglare.Sep 26, 2002 · N888MH · Substantial damageNTSB FTW02LA245Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Hearne, TXThe pilot's failure to maintain clearance with a pump rig while maneuvering during an aerial application flight. A factor was the object.Aug 30, 2002 · N9193Y · Substantial damageNTSB FTW02LA124Accident · No injuriesLimited investigationFinal reportCessna 172R · Longview, TXThe in-flight collision with a bird.Apr 12, 2002 · N61LU · Substantial damageNTSB FTW02LA110Accident · Serious injuriesLimited investigationFinal reportThornley Thornley 2000 · Granite Shoals, TXthe pilot's failure to maintain clearance with a power line while maneuvering. Contributing factors were the pilot's diverted attention and the power lines.Apr 2, 2002 · N248JT · Substantial damageNTSB FTW02LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Terrell, TXthe inadequate supervision by the flight instructor resulting in the dual student's failure to maintain the proper glidepath during the short field approach. A contributing factor was the downdraft.Mar 22, 2002 · N3687M · Substantial damageNTSB FTW02FA071Accident · 1 fatalField investigationFinal reportBeech C23 · Sinton, TXThe pilot's failure to maintain clearance with trees while executing a missed approach procedure. Contributing factors were the prevailing fog and the dark night conditions.Jan 18, 2002 · N6622X · DestroyedNTSB FTW02LA270Accident · Serious injuriesLimited investigationFinal reportRaven S60A · La Vernia, TXThe pilot's improper planning of the approach and failure to maintain clearance with the powerlines. A factor was the power lines.Jan 12, 2002 · N804DL · Minor damage