NTSB investigations, 2016, TX
24 cases where the sequence of events included Runway excursion.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 11 |
| 2010 | 19 |
| 2011 | 12 |
| 2012 | 13 |
| 2013 | 9 |
| 2014 | 16 |
| 2015 | 14 |
| 2016 | 24 |
| 2017 | 10 |
| 2018 | 15 |
| 2019 | 13 |
| 2020 | 12 |
| 2021 | 13 |
| 2022 | 13 |
| 2023 | 21 |
| 2024 | 18 |
| 2025 | 10 |
| 2026 | 11 |
Where
Open the mapLatest 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\") = 2016
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\" = '300' 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 year(c."eventDate") = 2016 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" = '300' 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 GAA17CA050Accident · No injuriesData collectionFinal reportCessna 305 · Llano, TXThe pilot's failure to maintain directional control during the landing roll in cross wind conditions.NTSB CEN17LA022Accident · No injuriesLimited investigationFinal reportCessna T210L · Pflugerville, TXLanding gear collapse upon landing due to a hydraulic leak that led to insufficient pressure to fully extend and lock the gear in a down position.NTSB GAA17CA013Accident · No injuriesData collectionFinal reportCessna A185 · San Antonio, TXThe pilot's failure to recognize the tailwind condition and maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA16CA481Accident · Minor injuriesData collectionFinal reportStinson L 5 · San Antonio, TXThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN16CA319Accident · No injuriesData collectionFinal reportCessna 172S · Arlington, TXThe student pilot's improper recovery from a bounced landing.NTSB CEN16LA356Accident · No injuriesLimited investigationFinal reportCessna P210N · Waco, TXThe failure of the right main landing gear (MLG) down-lock mechanism, which resulted in the collapse of the landing gear. The root cause of the right MLG down-lock mechanism could not be determined because the components were not available for examination.NTSB CEN16FA286Accident · Minor injuriesClass 3 · FieldFinal reportEmbraer EMB-505 · Sugar Land, TXThe airplane’s hydroplaning during the landing roll, which resulted in a runway excursion. Contributing to the accident was the pilot’s continuation of an unstabilized approach, his decision to land in heavy rain conditions, and his improper use of the main…NTSB CEN16LA259Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe pilot's unstabilized approach and uneven braking due to insufficient runway remaining, which resulted in a loss of directional control during landing. Contributing to the accident was the bound flap jackscrew, which jammed the flaps and led to the pilot’s…NTSB GAA16CA368Accident · No injuriesData collectionFinal reportAvions Mudry ET Cie CAP · Spring Branch, TXThe flight instructor's inability to maintain directional control during the landing roll as a result of the malfunctioning brake master cylinder.NTSB GAA16CA385Accident · No injuriesData collectionFinal reportRockwell International 114 · Munday, TXThe pilot's failure to maintain directional control during takeoff, which resulted in an aborted takeoff, runway excursion, collision with a fence, and substantial damage.NTSB CEN16LA185Accident · No injuriesLimited investigationFinal reportJewett Brandon RV 6 · McKinney, TXThe pilot’s loss of directional control during takeoff.NTSB GAA16CA223Accident · No injuriesData collectionFinal reportCessna T206 · Jasper, TXThe pilot's failure to maintain pitch control during the landing flare, which resulted in abnormal runway contact, a nose wheel landing gear collapse, and runway excursion.NTSB GAA16CA184Accident · No injuriesData collectionFinal reportDehavilland DHC 6 Twin Otter · Fentress, TXThe pilot's failure to maintain directional control during the aborted landing in gusty crosswind conditions, which resulted in a runway excursion and a collision with a tree.NTSB GAA16CA206Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Spring, TXThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion and substantial damage to the lower left wing spar.NTSB CEN16LA153Accident · No injuriesLimited investigationFinal reportGill Craig Lancair IV P Propjet · Addison, TXCollapse of the nose landing gear during landing for reasons that could not be determined, because postaccident examination did not detect any anomalies consistent with a preimpact failure or malfunction.NTSB GAA16CA171Accident · No injuriesData collectionFinal reportRockwell International 114 · Addison, TXThe private pilot's failure to maintain directional control during the landing roll and the flight instructor's delayed remedial action, which resulted in a runway excursion, collision with an airport sign, and a nose gear collapse.NTSB GAA16CA164Accident · No injuriesData collectionFinal reportPphu Ekolot KR-030 Topaz · Lake Dallas, TXThe pilot's failure to maintain directional control during the landing in a crosswind, which resulted in a runway excursion and an impact with terrain.NTSB CEN16LA131Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Del Rio, TXThe pilot’s loss of directional control while departing with a gusting tailwind.NTSB GAA16CA155Accident · No injuriesData collectionFinal reportPiper PA 46 · Pflugerville, TXThe pilot's failure to maintain directional control during the landing touchdown in gusty crosswind conditions, which resulted in runway excursion, and nose gear collapse.NTSB GAA16CA147Accident · No injuriesData collectionFinal reportPiper PA 28 · Pearland, TXThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and a collision with an airport sign.NTSB GAA16CA145Accident · No injuriesData collectionFinal reportAeropro CZ A220 · Canton, TXThe pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and a collision with trees.NTSB GAA16CA130Accident · Minor injuriesData collectionFinal reportCessna 182 · Hudson Oaks, TXThe pilot's decision to continue the high approach, resulting in excessive speed during the landing roll, a loss of directional control, runway excursion, and nose over.NTSB GAA16CA133Accident · Minor injuriesData collectionFinal reportNorth American P 51 · Dallas, TXThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing.NTSB GAA16CA106Accident · No injuriesData collectionFinal reportPiper PA 28RT-201 · Terrell, TXThe private pilot's exceedance of the airplane's critical angle-of-attack during a go-around in gusting crosswind conditions, which resulted in an aerodynamic stall and a collision with terrain short of the runway.