NTSB investigations, 2013, TX

5 cases where the sequence of events included Sys/Comp malf/fail (non-power).

Cases per year

20082026
NTSB investigations, 2013, TX per year, 2008–2026: 71 cases
20085
20094
20108
20112
20124
20135
20142
20153
20164
20171
20185
20192
20201
20217
20223
20234
20246
20251
20264

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\") = 2013
    AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '330' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 CEN13LA567Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12 D · Laguna Park, TXThe pilot’s inadequate flare during landing, which resulted in a hard landing and the subsequent collapse of the left main landing gear.Sep 22, 2013 · N96473 · Substantial damageNTSB CEN13LA534Accident · No injuriesLimited investigationFinal reportBarrow Rose Parrakeet · Castroville, TXThe failure of the left main landing gear wheel on landing due to overstress, which resulted in the pilot’s loss of directional control. Contributing to the accident was the pilot's improper decision to install wheels with insufficient loading capacity for…Sep 7, 2013 · N1732 · Substantial damageNTSB CEN13LA531Accident · No injuriesLimited investigationFinal reportCessna/Weaver 305 - E · Paris, TXThe failure of a landing gear O-ring, which prevented the pilot from being able to maintain directional control of the airplane during landing.Aug 31, 2013 · N862 · Substantial damageNTSB CEN13IA285Incident · No injuriesIncident investigationFinal reportCirrus SR22 · Dallas, TXThe failure of the airplane’s parachute to deploy when activated during a loss of control in cruise flight due to the dynamic maneuvering of the airplane at the time of the activation, which exceeded the parachute system’s certification requirements.May 16, 2013 · N715CD · No damageNTSB CEN13LA170Accident · No injuriesLimited investigationFinal reportCessna 195 · Austin, TXThe pilot's use of an excessive taxi speed, which resulted in the airplane overrunning the end of the unlit taxiway after the failure of the right wing landing light.Feb 17, 2013 · N4426C · Substantial damage