NTSB investigations, 2000, TX

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

Cases per year

19822026
NTSB investigations, 2000, 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\") = 2000
    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 FTW01LA012Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Stanton, TXThe failure of the pilot to maintain clearance with the power lines, while maneuvering during an aerial application flight.Oct 19, 2000 · N53211 · DestroyedNTSB FTW01LA011Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Littlefield, TXthe pilot's failure to maintain clearance with a guy wire while maneuvering during an aerial application flight.Oct 18, 2000 · N3165G · DestroyedNTSB FTW00LA270Accident · 1 fatalLimited investigationFinal reportCessna 188B · Stanton, TXThe pilot's failure to maintain clearance from guy wires and tower.Sep 29, 2000 · N4983Q · DestroyedNTSB FTW00LA259Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Lariat, TXThe pilot's failure to maintain clearance with the antenna guy wire. A factor was the pilot's physical impairment from his use of diphenhydramine.Sep 14, 2000 · N1508V · Substantial damageNTSB FTW00LA257Accident · No injuriesLimited investigationFinal reportAir Tractor 402B · Segraves, TXThe pilot's failure to maintain clearance with the irrigation system. A factor was the whirlwind weather condition.Sep 6, 2000 · N6174H · Substantial damageNTSB FTW00LA217Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Olney, TXThe pilot's inadequate compensation for wind conditions. A factor was the gusty crosswind.Jul 27, 2000 · N7501X · Substantial damageNTSB FTW00LA206Accident · No injuriesLimited investigationFinal reportMbb BK-117-A3 · Allen, TXthe pilot's failure to maintain obstacle clearance while hovering the helicopter. A contributing factor was the dark night light conditions.Jul 16, 2000 · N312LS · Substantial damageNTSB FTW00LA213Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Stephenville, TXThe collision with a bird while in cruise flight.Jul 14, 2000 · N99236 · Substantial damageNTSB FTW00LA195Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Anahuac, TXThe pilot's failure to maintain clearance with the power line. A factor was the lack of suitable terrain for the forced landing.Jul 5, 2000 · N2252N · DestroyedNTSB FTW00LA192Accident · Minor injuriesLimited investigationFinal reportAyres S2R-G10 · Brownfield, TXThe loss of engine power due to the blocked engine intake, which resulted from ingesting birds. Factors were the lack of suitable terrain for the forced landing and the pilot's intentional ground loop in an attempt to avoid a ditch.Jul 3, 2000 · N4061H · Substantial damageNTSB FTW00TA142Accident · 1 fatalFinal reportAir Tractor AT-802A · Fort Stockton, TXThe pilot's failure to maintain clearance with the antenna tower. A factor was the smoke weather condition.May 7, 2000 · N60471 · DestroyedNTSB FTW00LA123Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Rocksprings, TXThe pilot's failure to maintain proper glidepath. A factor was the dark night light conditions.Apr 12, 2000 · N789CA · DestroyedNTSB FTW00LA122Accident · No injuriesLimited investigationFinal reportMooney M20A · Houston, TXThe pilot's delayed go-around and his failure to maintain the aircraft's clearance with trees.Apr 5, 2000 · N8159E · Substantial damageNTSB FTW00LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · New Ulm, TXThe pilot's failure to maintain clearance with a fence during the aborted landing.Feb 26, 2000 · N8967C · Substantial damageNTSB FTW00FA079Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Frisco, TXThe pilot's failure to maintain clearance with trees during an intentional low altitude flight maneuver.Feb 4, 2000 · N6506J · Destroyed