NTSB investigations, 2019, TX

12 cases where the sequence of events included Nose over/nose down.

Cases per year

20082026
NTSB investigations, 2019, TX per year, 2008–2026: 147 cases
20085
20098
20107
20116
201212
20137
201414
201512
201610
20176
20189
201912
20204
20216
20224
20239
20246
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\") = 2019
    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\" = '096' 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 GAA20CA069Accident · No injuriesData collectionFinal reportCessna 180 · Tyler, TXThe pilot's improper wind correction while taking off with a tailwind, which resulted in a runway excursion and subsequent nose-over.Nov 8, 2019 · N9925N · Substantial damageNTSB ERA20LA028Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Odessa, TXA loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel.Nov 1, 2019 · N732JW · Substantial damageNTSB GAA19CA548Accident · No injuriesData collectionFinal reportCessna 180 · Lancaster, TXThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.Sep 4, 2019 · N9250T · Substantial damageNTSB GAA19CA510Accident · No injuriesData collectionFinal reportAmerican Legend AL3C · Waco, TXThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and noseover.Aug 24, 2019 · N173JE · Substantial damageNTSB GAA19CA371Accident · No injuriesData collectionFinal reportCessna 182 · Presidio, TXThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with vegetation.Jun 24, 2019 · N8521T · Substantial damageNTSB GAA19CA339Accident · No injuriesData collectionFinal reportAir Tractor AT502 · San Benito, TXThe pilot's improper decision to take off with the airplane near its maximum allowable gross takeoff weight and his subsequent exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.Jun 13, 2019 · N103CK · Substantial damageNTSB GAA19CA317Accident · No injuriesData collectionFinal reportPiper PA 11 · Paducah, TXThe pilot's failure to maintain directional control during the landing on a road in crosswind conditions, which resulted in the airplane exiting the road and subsequently nosing over.Jun 5, 2019 · N78641 · Substantial damageNTSB GAA19CA267Accident · Minor injuriesData collectionFinal reportCessna 172 · Manvel, TXThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in impact with a ditch.May 15, 2019 · N5788R · Substantial damageNTSB GAA19CA269Accident · No injuriesData collectionFinal reportCessna 172 · Tomball, TXThe student pilot's failure to maintain directional control during landing with a left crosswind, which resulted in a runway excursion and subsequent nose-over.May 14, 2019 · N8159U · Substantial damageNTSB GAA19CA192Accident · Minor injuriesData collectionFinal reportCessna 172 · Stephenville, TXThe student pilot's improper landing flare, which resulted in a hard landing, and his subsequent failure to maintain directional control in gusting crosswind conditions that exceeded the airplane’s demonstrated crosswind for landing, which resulted in a…Mar 31, 2019 · N902RA · Substantial damageNTSB CEN19LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA32RT · Pflugerville, TXThe pilot's fuel mismanagement and his improper use and placement of the fuel selector, contrary to operating procedures, which resulted in a partial loss of engine power due to fuel starvation.Jan 27, 2019 · N39650 · Substantial damageNTSB CEN19LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Aguilares, TXThe loss of engine power due to fuel starvation.Jan 20, 2019 · N99308 · Substantial damage