NTSB investigations, 2010, TX

7 cases where the sequence of events included Abnormal runway contact.

Cases per year

20082026
NTSB investigations, 2010, TX per year, 2008–2026: 109 cases
20082
200910
20107
20117
20124
20136
20146
20154
201610
20177
20187
20195
20205
20214
20224
20233
20246
20257
20265

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\" = '090' 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 CEN11CA127Accident · No injuriesData collectionFinal reportCessna 182P · Clifton, TXThe pilot's inadequate compensation for the crosswind and inadequate flare, which resulted in a hard landing.Dec 21, 2010 · N9317G · Substantial damageNTSB CEN11CA046Accident · No injuriesData collectionFinal reportHughes J/Hughes J Rand-Robinson · Pearland, TXThe pilot's improper flare, which resulted in a hard landing. Contributing to the accident was an engine oil leak which partially obscured the pilot’s forward vision.Oct 29, 2010 · N128JH · Substantial damageNTSB CEN10CA347Accident · No injuriesData collectionFinal reportMooney M20F · Lubbock, TXThe student pilot's failure to maintain control during a go-around.Jun 26, 2010 · N3495X · Substantial damageNTSB CEN10CA237Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Houston, TXThe pilot's failure to attain the proper touchdown point which resulted in an overrun.Apr 30, 2010 · N4397T · Substantial damageNTSB CEN10CA167Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Sugar Land, TXThe pilot's failure to maintain a proper glidepath and rate of descent during approach, resulting in a hard landing.Mar 22, 2010 · N616CP · Substantial damageNTSB CEN10CA152Accident · No injuriesData collectionFinal reportBeech A35 · Marfa, TXThe pilot's failure to extend the landing gear.Mar 11, 2010 · N541B · Substantial damageNTSB CEN10CA120Accident · No injuriesData collectionFinal reportAviat A1 · Austin, TXThe pilot's failure to maintain directional control during landing and his failure to properly execute a go-around.Feb 13, 2010 · N741MA · Substantial damage