NTSB investigations, 2010, TX

7 cases where the sequence of events included Other weather encounter.

Cases per year

20082026
NTSB investigations, 2010, TX per year, 2008–2026: 124 cases
20085
20097
20107
20117
20122
20131
20148
20156
201617
20176
201815
20195
20202
20215
20226
20238
20247
20257
20263

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\" = '400' 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 CEN11CA122Accident · No injuriesData collectionFinal reportCessna 170B · Houston, TXThe pilot's failure to maintain directional control during landing. Contributing to the accident was the flight instructor's delayed remedial action.Dec 11, 2010 · N1634D · Substantial damageNTSB CEN10LA559Accident · No injuriesLimited investigationFinal reportBeech A36TC · Snook, TXThe pilot's failure to recognize the change in wind velocity and his decision to make a downwind takeoff from the grass airstrip, which led to the airplane's degraded climb capability.Sep 26, 2010 · N468SG · Substantial damageNTSB CEN10LA416Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Krum, TXA total loss of engine power in flight due to carburetor icing.Jul 14, 2010 · N35645 · Substantial damageNTSB CEN10CA249Accident · Minor injuriesData collectionFinal reportQuicksilver GT-500 · Big Lake, TXThe pilot's loss of control when the airplane unexpectedly encountered a downdraft shortly after takeoff.May 11, 2010 · N5502D · Substantial damageNTSB CEN10CA192Accident · Minor injuriesData collectionFinal reportStroup Robert RV-6 · Muleshoe, TXThe pilot's failure to maintain directional control during takeoff in strong, gusting winds.Apr 5, 2010 · N58BD · Substantial damageNTSB CEN10CA160Accident · No injuriesData collectionFinal reportUltralight America Spitfire II Modelctv · Cameron, TXThe pilot's failure to maintain control while maneuvering during a forced landing after a partial loss of engine power.Mar 13, 2010 · N6524R · Substantial damageNTSB CEN10LA117Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Amarillo, TXThe pilot's loss of directional control while landing on an ice/snow covered runway.Feb 4, 2010 · N644EM · Substantial damage