Final NTSB investigations, TX
3,401 cases where the phase of flight was Landing.
Cases per year
| 1964 | 154 |
|---|---|
| 1965 | 175 |
| 1966 | 168 |
| 1967 | 202 |
| 1968 | 118 |
| 1969 | 133 |
| 1970 | 101 |
| 1971 | 97 |
| 1972 | 75 |
| 1973 | 78 |
| 1974 | 81 |
| 1975 | 76 |
| 1976 | 86 |
| 1977 | 82 |
| 1978 | 72 |
| 1979 | 84 |
| 1980 | 87 |
| 1981 | 91 |
| 1982 | 74 |
| 1983 | 61 |
| 1984 | 61 |
| 1985 | 48 |
| 1986 | 40 |
| 1987 | 48 |
| 1988 | 24 |
| 1989 | 26 |
| 1990 | 24 |
| 1991 | 19 |
| 1992 | 22 |
| 1993 | 21 |
| 1994 | 16 |
| 1995 | 28 |
| 1996 | 35 |
| 1997 | 35 |
| 1998 | 27 |
| 1999 | 35 |
| 2000 | 25 |
| 2001 | 24 |
| 2002 | 27 |
| 2003 | 31 |
| 2004 | 33 |
| 2005 | 29 |
| 2006 | 29 |
| 2007 | 32 |
| 2008 | 34 |
| 2009 | 28 |
| 2010 | 42 |
| 2011 | 30 |
| 2012 | 32 |
| 2013 | 32 |
| 2014 | 28 |
| 2015 | 22 |
| 2016 | 39 |
| 2017 | 26 |
| 2018 | 33 |
| 2019 | 24 |
| 2020 | 36 |
| 2021 | 23 |
| 2022 | 38 |
| 2023 | 33 |
| 2024 | 26 |
| 2025 | 25 |
| 2026 | 16 |
Where
Latest cases
Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
current_codes AS (
SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
),
phases AS (
SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
FROM current_codes WHERE n = 1
UNION ALL
SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
),
case_phases AS (
SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
)
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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
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.
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
current_codes AS (
SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
),
phases AS (
SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
FROM current_codes WHERE n = 1
UNION ALL
SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
),
case_phases AS (
SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
)
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN26LA305Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75L300 · Taylor, TXThe pilot’s failure to maintain directional control during landing.NTSB CEN26LA307Accident · No injuriesClass 4 · LimitedFinal reportCessna Claassen 305A(0-1A) · Midland, TXThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB WPR26LA278Accident · No injuriesClass 4 · LimitedFinal reportNeuberg Bill Glastar · Wills Point, TXThe pilot’s failure to maintain directional control during landing with a right crosswind, which resulted in the airplane’s impact with terrain.NTSB CEN26LA212Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Georgetown, TXThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB CEN26LA196Accident · No injuriesClass 4 · LimitedFinal reportGuenther Glen A Searey LSX · Briarcliff, TXThe pilot's failure to maintain sufficient altitude and aircraft control during the base to final turn, which resulted in the airplane impacting the water. Contributing to the accident was reported downdraft wind conditions.NTSB CEN26LA195Accident · Minor injuriesClass 4 · LimitedFinal reportCub Crafters CC18-180 · Littlefield, TXThe pilot's excessive approach speed, which resulted in a hard, bounced landing and nose-over.NTSB CEN26LA188Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-220T · Corpus Christi, TXThe pilot's failure to extend the main landing gear prior to landing, which resulted in a gear up landing. Contributing to the accident was the pilot’s distraction during the approach.NTSB CEN26LA182Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Waco, TXThe pilot’s failure to maintain directional control during the landing with a crosswind.NTSB CEN26LA171Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Sherman, TXThe pilot's failure to maintain airplane control during recovery from a bounced landing.NTSB CEN26LA161Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Seguin, TXThe failure of the landing gear weldment that resulted in separation of the right main landing gear.NTSB CEN26LA157Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Houston, TXThe pilot’s failure to maintain directional control of the airplane during landing in gusty wind conditions.NTSB DCA26LA142Accident · No injuriesClass 4 · LimitedFinal reportBoeing 787 · Houston, TXThe captain’s inadvertent activation of the takeoff/go around switch at touchdown that caused an increase in the airplane pitch attitude that was not corrected before the lower fuselage contacted the runway.NTSB CEN26LA120Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Pottsboro, TXThe pilot’s failure to maintain control during the landing roll with a crosswind.NTSB CEN26LA119Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Graford, TXThe pilot’s failure to maintain sufficient rotor speed during a practice autorotation to soft terrain which resulted in a loss of control and roll over.NTSB CEN26LA088Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Early, TXThe unsecured cup holder that restricted left rudder pedal movement, which resulted in a loss of directional control during landing roll.NTSB CEN26LA078Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Sealy, TXThe failure of the nose wheel during landing that resulted in a loss of directional control and impact with terrain.NTSB CEN26LA065Accident · Minor injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 505 · Fort Worth, TXThe flight instructor’s inadequate supervision during the approach and delayed remedial action, which resulted in a loss of control.NTSB CEN26LA028Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Hondo, TXThe pilot’s failure to extend the landing gear before landing due to distraction and his failure to conduct the Before Landing checklist.NTSB CEN26LA018Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Wallis, TXThe pilot’s failure to maintain control during landing roll that resulted in an impact with terrain.NTSB CEN25LA394Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Henderson, TXThe pilot’s failure to extend the main landing gear prior to landing, which resulted in a gear up landing. Contributing to the accident was the pilot’s distraction during the approach.NTSB CEN25LA389Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Decatur, TXThe pilot’s loss of control during an off-airport, pinnacle landing, and the flight instructor’s inadequate supervision of the instructional flight.NTSB CEN25LA371Accident · No injuriesClass 4 · LimitedFinal reportCessna 560 · Dallas, TXThe pilot's failure to extend the landing gear before landing.NTSB CEN25LA356Accident · Serious injuriesClass 3 · LimitedFinal reportSikorsky S-76 · Round Mountain, TXThe flight crew’s failure to properly identify the heliport in dark night conditions, which resulted in the flight crew attempting to land and a subsequent impact with trees and terrain.NTSB CEN25LA228Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20M · Ben Bolt, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN25LA222Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Sweetwater, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN25LA227Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob G-103A Twin II Acro · Midlothian, TXThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN25LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brookshire, TXThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapsing.NTSB CEN25LA209Accident · No injuriesClass 4 · LimitedFinal reportVans RV-14 · Sealy, TXThe pilot’s improper use of airplane’s wheel brakes during the landing roll-out.NTSB CEN25LA185Accident · No injuriesClass 4 · LimitedFinal reportCessna 401 · Arlington, TXThe failure of the left landing gear system and subsequent intentional gear up landing.NTSB CEN25LA160Accident · No injuriesClass 4 · LimitedFinal reportGrumman G164 · Louise, TXThe reported loss of engine power for undetermined reasons.NTSB CEN25LA154Accident · No injuriesClass 4 · LimitedFinal reportBeech C90 · Temple, TXThe failure of the left main landing gear down lock to engage and subsequent collapse of the left main landing gear.NTSB CEN25LA137Accident · No injuriesClass 4 · LimitedFinal reportJust Highlander · Rusk, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN25LA145Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra Mkii · Nacogdoches, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN25LA134Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Denton, TXThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing. Contributing to the accident was the gusty crosswind and windshear during landing.NTSB CEN25LA131Accident · No injuriesClass 4 · LimitedFinal reportCessna P206 · Frankston, TXThe pilot’s failure to maintain directional control during the landing with a gusting crosswind.NTSB CEN25LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Weslaco, TXThe pilot’s improper landing flare while attempting to land with a tailwind, which resulted in a hard landing.NTSB CEN25LA109Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · San Antonio, TXThe pilot’s failure to maintain directional control during a gusty crosswind landing.NTSB CEN25LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Waco, TXThe student pilot’s inadequate landing flare that led to a bounced landing, and her improper pitch control during the attempted recovery that resulted in a nose down pitch attitude upon the second touchdown.NTSB CEN25LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Llano, TXThe flight instructor’s failure to maintain directional control during the landing roll, that resulted in a ground loop, and a susbquent runway excursion.NTSB CEN25LA087Accident · No injuriesClass 4 · LimitedFinal reportEpic E1000 · Arcola, TXThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB CEN25LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · McKinney, TXThe flight instructor’s inadequate supervision and delayed remedial action and the student pilot’s failure to maintain a proper landing flare, which resulted in a nose down impact with the runway.NTSB CEN25LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna 182T · Pearland, TXThe AA-5 pilot’s failure to maintain separation from the 182T during approach and landing, which resulted in a ground collision during the landing roll. Contributing to the accident was the failure of the AA-5’s electrical system, which prevented the AA-5…NTSB CEN25LA055Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Pearland, TXThe flight instructor’s inadequate supervision of the student pilot that resulted in a loss of directional control during landing, and the excessive use of wheel brakes to regain directional control which resulted in the airplane nosing over.NTSB CEN25LA039Accident · No injuriesClass 4 · LimitedFinal reportAtkinson Jeffrey M RV-8 · Denton, TXThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB CEN25LA030Accident · No injuriesClass 4 · LimitedFinal reportStinson L-5 · Pleasanton, TXThe pilot’s failure to maintain control of the airplane during the landing.NTSB DCA25LA025Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-9 · Houston, TXBrake application before all three landing gears were on the ground, which caused the failure of the right main landing gear tires and resulted in tire fragments impacting the fuselage.NTSB CEN24LA371Accident · No injuriesClass 4 · LimitedFinal reportCessna 210-5(205) · Bryan, TXThe pilot’s failure to maintain aircraft control during the landing.NTSB CEN24LA348Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Amarillo, TXThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB CEN24LA347Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Weslaco, TXThe student pilot’s failure to maintain control of the airplane during landing.NTSB CEN24LA314Accident · No injuriesClass 4 · LimitedFinal reportCessna 208 · Whitewright, TXThe pilot’s incomplete flare which resulted a hard, flat landing.