NTSB investigations, TX

5 cases where NTSB found Manufacture/production.

Cases per year

20082026
NTSB investigations, TX per year, 2008–2026: 5 cases
20081
20191
20242
20251

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\", '040130'))
  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 CEN25LA117Accident · No injuriesClass 3 · LimitedFinal reportVans RV-7A · Plainview, TXThe improper machining of the propeller blade bearing seat, which resulted in an inflight propeller blade fatigue failure. Contributing to the accident was the improper machining of the propeller hub and propeller blade root and machining surface quality…Mar 10, 2025 · N923ZA · Substantial damageNTSB CEN25LA043Accident · No injuriesClass 3 · LimitedFinal reportPitts S1E · Seguin, TXThe improper construction of the rudder cable assembly by the airplane builder, which resulted in the fatigue failure of the left rudder cable during the landing roll and the pilot’s subsequent inability to maintain directional control.Nov 17, 2024 · N52B · Substantial damageNTSB CEN24FA218Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Gainesville, TXThe fuel pump manufacturer’s improper torquing of screws on the engine-driven fuel pump, which resulted in a disruption in the fuel system and a loss of engine power on initial climb.Jun 12, 2024 · N656MA · Substantial damageNTSB CEN19LA159Accident · No injuriesClass 3 · LimitedFinal reportLancair LC41 · Cleburne, TXA total loss of engine power due to oil starvation as the result of the oil pressure switch failure due to a manufacturing defect.May 30, 2019 · N2514F · Substantial damageNTSB DEN08FA140Accident · Serious injuriesField investigationFinal reportAircraft Mfg & Dev. CH601XLi · Farmersville, TXThe inadvertent tail stall and subsequent loss of airplane control as a result of the open canopy. Contributing to the accident was the inadequate emergency procedures provided by the airplane manufacturer and the inadequate design of the canopy latching…Aug 14, 2008 · N451BB · Substantial damage