NTSB investigations, TX

5 cases where NTSB found Design.

Cases per year

20092026
NTSB investigations, TX per year, 2009–2026: 5 cases
20092
20121
20131
20161

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\", '040110'))
  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 DCA16FA199Accident · 2 fatalClass 2 · FieldFinal reportBell 525 · Italy, TXA severe vibration of the helicopter that led to the crew's inability to maintain sufficient rotor rotation speed (Nr), leading to excessive main rotor blade flapping, subsequent main rotor blade contact with the tail boom, and the resultant in-flight…Jul 6, 2016 · N525TA · DestroyedNTSB CEN13LA283Accident · No injuriesLimited investigationFinal reportAir Tractor AT-302 · Winnie, TXThe improper decision by the pilot to attempt a flight with a known fuel system-related maintenance discrepancy, which resulted in a fuel imbalance and subsequent fuel starvation during an approach to an alternate airport with a rough field. Contributing to…May 9, 2013 · N3650B · Substantial damageNTSB DCA12FA058Accident · No injuriesField investigationFinal reportBombardier DHC-8-402 · Houston, TXthe nose landing gear alternate release handle was not pulled with sufficient enough force or distance to release the uplocks and allow extension of the nose landing gear. Contributing to the accident was the dissimilar pull force and pull length set on the…Apr 7, 2012 · N213WQ · Substantial damageNTSB CEN10LA050Accident · 1 fatalLimited investigationFinal reportAugustine David L Sonex · Burnet, TXThe pilot’s failure to maintain aircraft control, resulting in an aerodynamic stall. Contributing to the accident was the loss of engine power due to a clogged fuel screen that resulted in fuel starvation caused by the builder's inappropriate use of a fuel…Nov 14, 2009 · N10DA · Substantial damageNTSB CEN09LA341Accident · Minor injuriesLimited investigationFinal reportHuston Charles D Pitts S-12 · Spicewood, TXA total loss of engine power due to fuel starvation as a result of the presence of an unidentified contaminant in the fuel system which clogged the fuel flow sensor. Contributing to the accident was the manufacturer’s installation of the fuel flow sensor…Jun 5, 2009 · N922TP · Substantial damage