NTSB investigations, TX

6 cases where NTSB found Residence/building.

Cases per year

20152026
NTSB investigations, TX per year, 2015–2026: 6 cases
20152
20162
20171
20261

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\", '03022022'))
  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 CEN26LA177Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · El Campo, TXThe pilot’s failure to maintain aircraft control during takeoff resulting in a collision with a building during takeoff.May 5, 2026 · N422TW · DestroyedNTSB GAA17CA165Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Spofford, TXThe pilot's decision to hover-taxi out of the hangar and his subsequent failure to maintain clearance from the hangar.Feb 19, 2017 · N804DF · Substantial damageNTSB GAA16CA365Accident · No injuriesData collectionFinal reportCessna 172RG · Stamford, TXThe pilot's failure to maintain clearance from a hangar during taxi for departure.Jun 30, 2016 · N9318B · Substantial damageNTSB CEN16LA225Accident · Serious injuriesLimited investigationFinal reportPiper PA 24 · Houston, TXThe total loss of engine power due to fuel exhaustion.Jun 20, 2016 · N5661R · Substantial damageNTSB CEN15LA416Accident · Serious injuriesLimited investigationFinal reportCessna R172 · College Station, TXThe total loss of engine power due to the fatigue failure of the No. 1 connecting rod. Contributing to the accident was the manufacturer’s exclusion of the accident engine (by serial number) in a revision of a service bulletin.Sep 17, 2015 · N180CM · Substantial damageNTSB CEN15CA353Accident · Minor injuriesData collectionFinal reportRatte James Aventura II · Tyler, TXThe loss of airplane control during a go around, which resulted in impact with the water. Contributing to the accident was the pilot's lack of seaplane rating and inexperience in the accident airplane.Aug 10, 2015 · N6356Z · Substantial damage