NTSB investigations, 2018, TX

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

Cases per year

20082026
NTSB investigations, 2018, 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\") = 2018
    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 GAA19CA011Accident · Minor injuriesData collectionFinal reportBeech 55 · San Antonio, TXThe pilot's improper takeoff trim setting and failure to properly secure his seatbelt, which resulted in a loss of airplane control. Contributing to the accident was the pilot's failure to follow the Before Takeoff checklist.Oct 5, 2018 · N6674Y · Substantial damageNTSB GAA19CA002Accident · Minor injuriesData collectionFinal reportAirborne Windsports PTY Edge XT 912 · Frankston, TXThe pilot's improper landing flare, which resulted in the weight-shift-controlled aircraft landing crooked on a turf runway.Oct 2, 2018 · N20179 · Substantial damageNTSB GAA18CA536Accident · No injuriesData collectionFinal reportAeronca 11AC · Midland, TXThe pilot’s improper landing flare, which resulted in a bounced landing.Sep 2, 2018 · N86146 · Substantial damageNTSB GAA18CA350Accident · No injuriesData collectionFinal reportCessna 152 · Denison, TXThe student pilot’s improper landing flare in crosswind conditions, which resulted in a hard, bounced landing.Jun 14, 2018 · N67404 · Substantial damageNTSB GAA18CA346Accident · No injuriesData collectionFinal reportPiper PA32R · Caddo Mills, TXThe student pilot’s failure to extend the landing gear before landing and to follow the Before Landing checklist, which resulted in an attempted go-around and subsequent hard landing.Jun 13, 2018 · N82303 · Substantial damageNTSB GAA18CA340Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, TXThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent porpoise.Jun 9, 2018 · N363CK · Substantial damageNTSB GAA18CA143Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot’s improper approach and landing flare, which resulted in a porpoised landing.Jan 24, 2018 · N9520Z · Substantial damage