NTSB investigations, TX

16 cases where NTSB found Task performance, general.

Cases per year

20082026
NTSB investigations, TX per year, 2008–2026: 16 cases
20082
20105
20115
20121
20132
20201

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 c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020600'))
  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 CEN20CA395Accident · No injuriesClass 4 · Data collectionFinal reportBell 407 · Fort Worth, TXThe flight instructor’s delay in rolling the throttle to the fly position during a practice autorotation maneuver that resulted in a hard landing.Sep 15, 2020 · N489DM · Substantial damageNTSB CEN14LA022Accident · No injuriesLimited investigationFinal reportBell OH-58C · Omaha, TXThe pilot’s failure to assess and compensate for the landing surface, which included high grass and loose dirt.Oct 23, 2013 · N911CC · Substantial damageNTSB CEN13LA157Accident · No injuriesLimited investigationFinal reportNorth American-Medore SNJ-4 · Garden City, TXThe loss of engine power due to fuel starvation.Feb 8, 2013 · N2269U · Substantial damageNTSB CEN12FA570Accident · 2 fatalField investigationFinal reportAmerican AA-1 · Llano, TXThe flight instructor’s delayed remedial action and inadequate supervision during practice traffic pattern work. Contributing to the accident was the flight instructor’s use of sedating medication on the day of the accident and airplane’s high angle of attack…Aug 25, 2012 · N5796L · Substantial damageNTSB CEN11LA646Accident · No injuriesLimited investigationFinal reportBell 206B · Spicewood, TXThe pilot did not maintain adequate rotor rpm during a low-altitude maneuvering flight.Sep 15, 2011 · N3181J · Substantial damageNTSB CEN11CA684Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Fort Worth, TXThe certified flight instructor’s improper flare during a simulated emergency landing.Sep 3, 2011 · N242BC · Substantial damageNTSB CEN11CA503Accident · No injuriesData collectionFinal reportAero Commander 100 · Llano, TXThe student pilot's failure to attain the proper touchdown point and the flight instructor's delayed remedial action.Jul 20, 2011 · N3656X · Substantial damageNTSB CEN11CA322Accident · No injuriesData collectionFinal reportCessna 172K · Farmersville, TXA loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.May 5, 2011 · N46400 · Substantial damageNTSB CEN11LA209Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Kingsville, TXA pre-existing crack in the front spar of the right horizontal stabilizer near a riveted fitting, causing it to fail and separate from the airplane in flight. Contributing to the accident was the failure of maintenance personnel comply with existing service…Feb 26, 2011 · N6196L · Substantial damageNTSB 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 CEN11CA019Accident · No injuriesData collectionFinal reportCessna 195 · Midland, TXThe private pilot’s loss of control during the landing roll and the certificated flight instructor’s delayed remedial action, which resulted in a ground loop.Oct 2, 2010 · N4666T · Substantial damageNTSB CEN10CA454Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Petersburg, TXThe pilot's failure to maintain clearance from a signpost during an aerial application flight.Jul 29, 2010 · N57706 · Substantial damageNTSB CEN10CA270Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Belton, TXThe pilot's loss of directional control during landing.May 27, 2010 · N817P · Substantial damageNTSB CEN10CA156Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Houston, TXThe student pilot's loss of directional control during takeoff, resulting in a dynamic rollover of the helicopter.Mar 13, 2010 · N822SH · Substantial damageNTSB DFW08LA197Accident · 1 fatalLimited investigationFinal reportMarshall James J Cozy MK IV · Midlothian, TXThe pilot's failure to maintain clearance from the wall of the rock quarry.Jul 24, 2008 · N500K · Substantial damageNTSB DFW08LA122Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Bartlett, TXThe pilot's failure to maintain tail rotor clearance from terrain (embankment) during takeoff.Apr 28, 2008 · N477SH · Substantial damage