NTSB investigations, TX
107 cases where the sequence of events included Miscellaneous/other.
Cases, newest first
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '900' 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.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN16FA261Accident · 4 fatalField investigationFinal reportPiper PA 32R-300 · Houston, TXThe pilot's failure to maintain adequate airspeed after becoming distracted by the open baggage door while operating in the airport traffic pattern, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at…NTSB GAA16CA328Accident · No injuriesData collectionFinal reportAirbus AS350 · McAllen, TXThe pilot's inadvertent input of the right tail rotor pedal, which resulted in a loss of directional control and an impact with service equipment.NTSB CEN16LA213Accident · Minor injuriesLimited investigationFinal reportBell 47G 5 · Laureles, TXThe pilot's failure to apply additional engine power when he applied collective input, which led to a loss of rotor speed and the exceedance of the helicopter’s performance capability.NTSB CEN16FA114Accident · 2 fatalField investigationFinal reportOhlgren RV 6A · Abilene, TXThe pilot's failure to maintain airplane control during takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's impairment due to his combined use of central…NTSB DCA16CA009Accident · Serious injuriesData collectionFinal reportBoeing 757 223 · Dallas, TXthe disabled passenger not being properly secured during the transfer from the aisle chair causing him to slide to floor and receive a serious injury.NTSB GAA15CA295Accident · No injuriesData collectionFinal reportBeech V35B · Houston, TXThe pilot's failure to properly secure the cabin door prior to takeoff, resulting in the door opening during takeoff, an aborted takeoff, runway overrun, and collision with terrain.NTSB GAA15CA242Accident · No injuriesData collectionFinal reportCessna 305A · Midlothian, TXThe failure of the brake line tubing for the right main landing gear brake, due to a non-standard method used to secure the brake line, which resulted in a loss of control during landing, and a ground loop.NTSB GAA15LA191Accident · Minor injuriesLimited investigationFinal reportCelier Xenon RST · Livingston, TXThe pilot’s loss of directional control after aborting the takeoff due to a grinding noise coming from the main rotor area, which resulted in a runway excursion.NTSB CEN15LA298Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Houston, TXMaintenance personnel's improper installation of the propeller governor, which resulted in damage to the governor drive gear and its subsequent failure and a subsequent loss of engine power.NTSB CEN15FA232Accident · 4 fatalField investigationFinal reportPiper PA 24-260 · Spring Branch, TXThe pilot's failure to maintain control during takeoff due to his impairment from marijuana. Contributing to the accident was the pilot’s impaired decision to fly after using a disqualifying drug.NTSB GAA15CA002Accident · No injuriesData collectionFinal reportBell 407 · Justin, TXAbnormal ground contact during an autorotation demonstration, resulting in a severed tailrotor driveshaft.NTSB CEN15LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Slaton, TXMaintenance personnel’s improper installation of the engine data monitor (EDM), which was not in accordance with the supplemental type certificate instructions and resulted in engine warning indications and the pilot’s subsequent reaction to the warning…NTSB CEN15CA095Accident · No injuriesData collectionFinal reportCessna 152 · Mount Pleasant, TXThe pilot's decision to maneuver the airplane at low altitude resulting in the airplane impacting power lines.NTSB CEN14LA465Accident · No injuriesLimited investigationFinal reportBell 206B · Spring, TXThe pilot's distraction by a cell phone call, which led to his failure to perform an exterior check of the helicopter and resulted in a tie-down strap remaining attached to the main rotor during the engine start.NTSB CEN14LA197Accident · No injuriesLimited investigationFinal reportRobinson R44 - II · Menard, TXThe pilot’s inadequate recovery from a practice autorotation, which resulted in an improper touchdown attitude and collision with terrain.NTSB CEN13LA551Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Clemville, TXThe uncommanded inflight application of parking brake due to a loose valve, which resulted in a noseover during landing.NTSB CEN13CA277Accident · No injuriesData collectionFinal reportCessna 140 · Groesbeck, TXThe pilot's failure to maintain control of the airplane during an aborted takeoff.NTSB CEN13CA162Accident · No injuriesData collectionFinal reportBeech A60 · Abilene, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN13CA206Accident · No injuriesData collectionFinal reportCessna T206H · Sabinal, TXThe pilot’s failure to properly identify the airstrip, which resulted in him landing the airplane off of the airstrip in soft soil causing the nose over.NTSB CEN13LA147Accident · No injuriesLimited investigationFinal reportWebb Webb 2 · Gainsville, TXThe pilot’s failure to follow his test plan and abort the takeoff after inadvertently lifting off during a high speed taxi test. Contributing to the accident was the pilot’s lack of flight experience in the gyroplane.NTSB CEN13LA056Accident · Minor injuriesLimited investigationFinal reportCessna 210L · La Grange, TXThe total loss of engine power due to the loss of oil to the engine. Contributing to the accident was maintenance personnel’s improper installation of the engine oil filter adaptor, which resulted in the loss of oil to the engine.NTSB CEN13LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Roanoke, TXThe student pilot's failure to maintain clearance from obstacles on the runway approach path. Contributing to the accident was the airport management's decision to relocate the runway displaced threshold, which did not provide an adequate safety margin for…NTSB CEN12CA618Accident · No injuriesData collectionFinal reportBeech V35 · Decatur, TXThe pilot's inattention during the landing roll, which resulted in retraction of the landing gear instead of the flaps.NTSB CEN12CA631Accident · No injuriesData collectionFinal reportPowrachute Pegasus · Luling, TXCollision with a powerline resulting from the pilot's not maintaining adequate clearance while on a day VFR approach to land.NTSB CEN12CA548Accident · No injuriesData collectionFinal reportSchleicher ASW22 · Uvalde, TXThe pilot did not fully stow the glider’s airbrakes, which prevented the glider from obtaining adequate airspeed during the takeoff roll.NTSB DCA12IA113Incident · No injuriesIncident investigationFinal reportBoeing 737-3H4 · El Paso, TXthe rupture of the nose landing gear hydraulic line that resulted from abrasions due to contact with the nose landing gear tire. Contributing to the incident was the incorrect installation of union and restrictor on the actuator.NTSB CEN12CA474Accident · No injuriesData collectionFinal reportEurocopter Deutschland MBB-BK 117 C-2 · Houston, TXThe pilot’s inadequate preflight inspection, which failed to detect the unsecured cowling latches and resulted in the in-flight opening of an engine cowling.NTSB CEN12LA335Accident · No injuriesLimited investigationFinal reportShort Bros Shorts SD3-60 · Houston, TXThe pilots’ improper decision to burn fuel during the taxi by operating the engines at a higher-than-normal power setting and using the wheel brakes to control taxi speed, which resulted in a wheel fire.NTSB CEN12CA328Accident · No injuriesData collectionFinal reportShiver Tailwind W-10 · Pipe Creek, TXAn inadvertent collision with a deer during takeoff and the airplane’s subsequent departure from the runway and impact with a tree.NTSB CEN12CA301Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · El Campo, TXThe pilot's decision to rotate early, the airplane’s subsequent inability to climb, and the pilot’s delayed decision to abort the takeoff.NTSB CEN12LA260Accident · No injuriesLimited investigationFinal reportThrush S2R-H80 · Bryan, TXThe pilot's diverted attention, which resulted in a loss of control while maneuvering the airplane at a low altitude.NTSB CEN12CA051Accident · Minor injuriesData collectionFinal reportDowner Bellanca 14-19-2 · Borger, TXA total loss of engine power due to fuel starvation as a result of the pilot’s improper fuel management. Contributing to the accident was the pilot’s diverted attention with the broken fuel gauge knob.NTSB CEN11CA627Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Batesville, TXThe pilot’s inadequate preflight inspection that failed to ensure all tie-down clamps were removed prior to takeoff, which resulted in the helicopter’s dynamic rollover.NTSB CEN11CA438Accident · No injuriesData collectionFinal reportCessna A188 · Castroville, TXThe pilot's failure to maintain obstacle clearance during the agricultural spraying flight.NTSB CEN11FA358Accident · 2 fatalField investigationFinal reportRockwell 112 · Bryan, TXThe pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and his improper control inputs following the loss of engine power, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to…NTSB CEN11LA251Accident · Minor injuriesLimited investigationFinal reportCessna 425 · Canadian, TXThe pilot’s continuation of the approach with excessive airspeed, which resulted in a hard landing and a loss of directional control.NTSB CEN11LA254Accident · No injuriesLimited investigationFinal reportNorth American B25 · Encinal, TXThe co-pilot’s premature retraction of the landing gear during takeoff, which resulted in a gear collapse and impact with the runway surface.NTSB CEN11CA212Accident · No injuriesData collectionFinal reportBeech G35 · Brenham, TXThe pilot’s failure to extend the landing gear during the approach resulting in a gear-up landing.NTSB 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.NTSB CEN11CA059Accident · No injuriesData collectionFinal reportHawker MK-20 Sea Fury · Breakenridge, TXThe improperly adjusted brakes and the pilot's failure to lock the tailwheel, resulting in a loss of directional control. Contributing to the accident was the pilot's decision to continue flying the airplane with a known brake deficiency.NTSB CEN10CA466Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Pettus, TXThe pilot's decision to exit the helicopter with the engine running.NTSB CEN10FA448Accident · 2 fatalField investigationFinal reportAmerican Champion Aircraft Cor 7GCBC · Midlothian, TXThe flight instructor’s incapacitation due to preexisting but unrecognized coronary disease, and the student pilot’s distraction and inability to recover the airplane from a stall/spin at low altitude.NTSB CEN10CA369Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Austin, TXThe pilot's failure to maintain directional control of the helicopter, resulting in impact with trees. Contributing to the accident was the pilot's failure to ensure the door was properly secured prior to flight.NTSB CEN10CA213Accident · No injuriesData collectionFinal reportWaco YPF-7 · Houston, TXThe pilot's inability to maintain control during landing due to the failure of the tailwheel locking mechanism to remain engaged prior to landing.NTSB CEN10FA107Accident · 2 fatalField investigationFinal reportCostruzioni Aeronautiche Tecna P2002 · Waxahachie, TXA loss of aircraft control while maneuvering for undetermined reasons.NTSB CEN09LA611Accident · 1 fatalLimited investigationFinal reportMckenna James E AVID-CATAL · Inks Lake, TXThe pilot’s decision to take off with a known airframe deficiency.NTSB CEN09FA601Accident · 1 fatalField investigationFinal reportCessna T210 · Hilltop Lakes, TXThe loss of control of the airplane in dark night light conditions due to the pilot’s spatial disorientation.NTSB CEN09LA525Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caddo Mills, TXThe failure of the operator to ensure that the airplane engine was shutdown during passenger unloading and the lack of adequate supervision of the passenger by the pilot and ground crewmember.NTSB CEN09IA294Incident · Minor injuriesIncident investigationFinal reportBoeing 737 · Houston, TXThe pilot's inadvertent application of excessive braking after touchdown, which caused the right wheels to lock and several tires to blow and resulted in a subsequent brake fire.NTSB CEN09LA274Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33 · Addison, TXA loss of engine power in flight due to fuel starvation as a result of the pilots' inadequate fuel management.