NTSB investigations, 2009
98 cases where the sequence of events included Abnormal runway contact.
Cases per year
| 2008 | 55 |
|---|---|
| 2009 | 98 |
| 2010 | 83 |
| 2011 | 79 |
| 2012 | 91 |
| 2013 | 61 |
| 2014 | 67 |
| 2015 | 99 |
| 2016 | 144 |
| 2017 | 107 |
| 2018 | 129 |
| 2019 | 94 |
| 2020 | 72 |
| 2021 | 74 |
| 2022 | 46 |
| 2023 | 49 |
| 2024 | 63 |
| 2025 | 58 |
| 2026 | 46 |
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\") = 2009
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '090' 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") = 2009 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '090' 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 CEN10LA083Accident · No injuriesLimited investigationFinal reportBeech B35 · Santa Fe, NMAn engine overpressure condition that resulted in oil getting on the exhaust and producing smoke which entered the cockpit. Contributing to the accident was the pilot's obscured vision due to smoke.NTSB DCA10RA017Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Kingston, JamaicaNTSB CEN10LA076Accident · No injuriesLimited investigationFinal reportBeech 200 · St. Louis, MOThe pilot's failure to properly follow the manual landing gear extension procedure, resulting in a gear-up landing.NTSB CEN10CA075Accident · No injuriesData collectionFinal reportCessna 172 · Pearland, TXThe student pilot's failure to control the airplane's descent rate during the short-field landing, resulting in a hard landing. Contributing to the accident was the flight examiner's delayed response.NTSB WPR10CA065Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe flight instructor's failure to arrest the helicopter's descent and to maintain lateral control during a hovering autorotation practice.NTSB ERA10LA063Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright Travel AIR · Fort Myers, FLThe pilot's improper recovery from a bounced landing and failure to maintain directional control, which resulted in a ground loop. Contributing to the accident was the pilot's minimal experience in the airplane make and model.NTSB CEN10CA038Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Three Lakes, WIThe pilot's improper flare and touchdown during the water landing.NTSB ERA10CA033Accident · No injuriesData collectionFinal reportElkins Christen Eagle II · Athens, KYThe pilot's improper liftoff, resulting in a collision with the ground during climbout.NTSB CEN10CA026Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Grand Forks, NDThe flight instructor's failure to ensure the landing gear was extended prior to landing.NTSB CEN10CA025Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.NTSB CEN10CA015Accident · Serious injuriesData collectionFinal reportAerostar International RX8 · Albuquerque, NMThe pilot’s failure to select an adequate landing area.NTSB CEN09CA608Accident · No injuriesData collectionFinal reportPiper J3C-65 · Spearfish, SDThe pilot's failure to maintain directional control during the takeoff roll.NTSB ERA09LA547Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Glen St. Mary, FLThe pilot's failure to maintain control of the airplane during the landing.NTSB WPR09CA469Accident · No injuriesData collectionFinal reportCessna 182 · Parowan, UTThe pilot's improper flare and recovery from a bounced landing.NTSB WPR09CA466Accident · Minor injuriesData collectionFinal reportBeech A23-19 · Tehachapi, CAThe pilot's failure to attain an established approach path while on final approach resulting in an improper flare and bounced landing.NTSB CEN09CA604Accident · No injuriesData collectionFinal reportBell 407 · Fort Worth, TXFailure of the pilot to maintain control during landing.NTSB CEN09CA599Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Sibley, IAThe pilot's long and fast landing and her delayed decision to execute a go-around.NTSB CEN09CA589Accident · Serious injuriesData collectionFinal reportDiehl KR-2 · Mt. Vernon, ILThe pilot's improper landing flare while landing with gusting winds and his failure to perform a go-around.NTSB CEN09LA579Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Park Rapids, MNThe pilot's failure to maintain a proper climb rate during a night takeoff.NTSB CEN09CA583Accident · No injuriesData collectionFinal reportSierra E5A Replica · Port Huron, MIThe pilot's failure to maintain aircraft control during landing.NTSB WPR09CA443Accident · No injuriesData collectionFinal reportCessna 305A · Helena, MTThe pilot's improper landing flare and recovery from a bounced landing.NTSB CEN09CA585Accident · Minor injuriesData collectionFinal reportCessna 170B · Dalhart, TXThe pilot’s decision to land with a tailwind resulting in a loss of directional control.NTSB CEN09LA586Accident · No injuriesLimited investigationFinal reportCessna 172S · Duluth, MNThe pilot's failure to maintain aircraft control during landing, resulting in a hard landing and a propeller strike with the ground.NTSB CEN09CA577Accident · No injuriesData collectionFinal reportKetonen Schreder · Ionia, MIThe pilot failed to maintain control of the glider during the aero-tow launch.NTSB CEN09CA615Accident · No injuriesData collectionFinal reportCessna 175 · Rio Blanco, COThe pilot's failure to maintain directional control during landing and his failure to execute a go-around.NTSB WPR09CA430Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAThe pilot's improper flare which resulted in a hard landing and subsequent collapse of the nose landing gear strut.NTSB CEN09CA556Accident · No injuriesData collectionFinal reportAlon A2 · Richmond Hts., OHThe pilot's failure to maintain control of the airplane during the landing flare.NTSB ERA09LA529Accident · No injuriesLimited investigationFinal reportBombardier DHC-8-202 · Sterling, VAUndetermined.NTSB CEN09CA554Accident · No injuriesData collectionFinal reportSocata TBM 700 · Ann Arbor, MIThe pilot's hard landing during gusty wind conditions.NTSB CEN09CA552Accident · No injuriesData collectionFinal reportCessna 150F · Abilene, KSThe pilot's inadequate crosswind landing technique, resulting in an excessive side load on the left landing gear that led to an overload failure of its axle.NTSB CEN09CA545Accident · Minor injuriesData collectionFinal reportDekkinga Vans RV-7A · Jenison, MIThe pilot's failure to maintain aircraft control during the landing.NTSB ERA09CA484Accident · No injuriesData collectionFinal reportPiper PA-34 · Savannah, GAThe student pilot's failure to maintain pitch control during landing and the flight instructor's delayed remedial action, resulting in a hard landing.NTSB CEN09LA542Accident · No injuriesLimited investigationFinal reportCessna 182 · Weeping Water, NEThe pilots' improper execution of soft/short field take-off procedures.NTSB CEN09CA520Accident · No injuriesData collectionFinal reportGrahn J/Grahn G Pitts S2S · Rifle, COThe pilot's excessive landing speed and subsequent excessive brake application which resulted in a loss of control and impact with an airport sign.NTSB WPR09CA392Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · Kamiah, IDThe failure of the student pilot to maintain directional control during landing.NTSB ERA09CA443Accident · No injuriesData collectionFinal reportCessna 172S · Alabaster, ALThe student pilot's failure to maintain directional control during landing.NTSB CEN09CA496Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 240A · Albuquerque, NMA run-on landing of the balloon causing the basket to tip over, resulting in a passenger's injury.NTSB CEN09CA495Accident · No injuriesData collectionFinal reportCessna 172S · New Braunfels, TXThe student pilot's improper flare resulting in a bounced landing.NTSB ERA09CA437Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Lincoln Park, NJThe pilot's improper flare, which resulted in a bounced landing, and the subsequent collapse of the landing gear.NTSB CEN09CA482Accident · No injuriesData collectionFinal reportCessna 182K · Conway, ARThe pilot's improper recovery from a bounced landing.NTSB ERA09CA439Accident · No injuriesData collectionFinal reportMooney M20S · Mayfield, KYThe pilot prematurely retracting the landing gear and flaps during the aborted landing.NTSB ERA09CA425Accident · Minor injuriesData collectionFinal reportCessna 177 · Towanda, PAThe failure of the pilot to maintain control of the airplane during a go around following a bounced landing.NTSB CEN09CA472Accident · No injuriesData collectionFinal reportFisher RV-7A · Brodhead, WIThe pilot's improper landing flare and recovery from a bounced landing.NTSB CEN09CA521Accident · No injuriesData collectionFinal reportMaule M-4-220C · Abernathy, TXThe failure of the fuselage's tube structure due to corrosion during a hard landing.NTSB CEN09CA587Accident · No injuriesData collectionFinal reportTolbert Robert R Rans S-6 · Santa Rosa, NMThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall during takeoff.NTSB CEN09CA458Accident · No injuriesData collectionFinal reportCessna 172M · New Braunfels, TXThe pilot's inadequate recovery from a bounced landing.NTSB WPR09CA345Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Tucson, AZA hard landing or abnormal runway contact by one or both pilots.NTSB WPR09CA370Accident · No injuriesData collectionFinal reportChristopher Vans RV-4 · Wendover, UTThe pilot's inadequate flare during touchdown and failure to maintain directional control, which resulted in a ground loop.NTSB ERA09CA390Accident · No injuriesData collectionFinal reportPiper J3C · South Charleston, WVThe pilot's failure to maintain control during the attempted go-around.NTSB WPR09CA352Accident · No injuriesData collectionFinal reportCessna T210N · Corona, CAThe pilot's inadequate flare during touchdown, which resulted in a hard landing.