NTSB investigations, 2010, TX

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

Cases per year

20082026
NTSB investigations, 2010, 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\") = 2010
    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 CEN10IA535Incident · No injuriesIncident investigationFinal reportEmbraer 500 · Brenham, TXThe pilots’ decision to depart with a known failed brake control unit.Sep 10, 2010 · N226CP · Minor damageNTSB CEN10LA457Accident · No injuriesLimited investigationFinal reportCessna 180B · Burnet, TXThe failure of the tailwheel compression spring, which resulted in a loss of directional control during landing.Aug 2, 2010 · N5177E · Substantial damageNTSB CEN10IA453Incident · No injuriesIncident investigationFinal reportPiper PA-32R-301T · Mount Pleasant, TXThe failure of an aileron control cable due to a seized idler pulley bearing.Aug 1, 2010 · N4184X · No damageNTSB CEN10LA389Accident · No injuriesLimited investigationFinal reportCessna 210 · Houston, TXThe failure of a hydraulic fluid line, which caused a loss of hydraulic pressure to the landing gear extension system and resulted in the partial collapse of the right main landing gear during touchdown.Jul 9, 2010 · N2157S · Substantial damageNTSB CEN10LA302Accident · No injuriesLimited investigationFinal reportBeech C90 · Fort Worth, TXThe failure of the nose gear actuator due to insufficient lubrication of the nut assembly threads.Jun 3, 2010 · N20 · Substantial damageNTSB CEN10FA277Accident · Serious injuriesField investigationFinal reportAveko Sro VL-3 LSA · Boyd, TX***This report was modified on November 15, 2012. Please see the docket for this accident to view the original report with revisions shown.*** The pilots’ failure to avoid and recover from the prohibited maneuver of aerodynamic spin during a training flight,…May 30, 2010 · N801GB · Substantial damageNTSB CEN10FA278Accident · 1 fatalField investigationFinal reportEvektor Aerotechnik Sportstar Plus · Richmond, TXThe opening of the cockpit canopy in-flight due to improper latching, which resulted in a loss of control and impact with terrain.May 29, 2010 · N121EV · Substantial damageNTSB CEN10LA207Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche Tecna P92 Echo Super · Baytown, TXThe failure of the landing gear bolts.Mar 7, 2010 · N323BR · Substantial damage