NTSB investigations, 2011
38 cases where the defining event was Abnormal runway contact.
Cases per year
| 2008 | 19 |
|---|---|
| 2009 | 47 |
| 2010 | 45 |
| 2011 | 38 |
| 2012 | 39 |
| 2013 | 28 |
| 2014 | 42 |
| 2015 | 36 |
| 2016 | 58 |
| 2017 | 45 |
| 2018 | 59 |
| 2019 | 34 |
| 2020 | 37 |
| 2021 | 34 |
| 2022 | 20 |
| 2023 | 20 |
| 2024 | 26 |
| 2025 | 33 |
| 2026 | 16 |
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\") = 2011
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '090')
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") = 2011 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '090') 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 ERA12CA098Accident · No injuriesData collectionFinal reportCessna 172P · Schenectady, NYThe pilot’s inadequate recovery from a bounced landing, which resulted in a loss of control.NTSB CEN12CA089Accident · No injuriesData collectionFinal reportCessna 182L · Branson, MOThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB WPR12CA014Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Las Vegas, NVThe inadvertent opening of the airplane’s canopy during takeoff, which distracted the pilot and resulted in his failure to maintain control of the airplane. Contributing to the accident was the pilot's failure to comply with the manufacturer's recommended…NTSB WPR12CA008Accident · No injuriesData collectionFinal reportCessna 172P · Cornelius, ORThe airplane’s encounter with an unseen hole or obstacle on the grass runway.NTSB CEN12CA011Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Englewood, COThe student pilot's improper flare, which resulted in a bounced landing from which he was unable to recover.NTSB WPR12CA006Accident · Minor injuriesData collectionFinal reportLudwig Larry E Bushman · Diamond, WAThe pilot's inadequate recovery from a bounced landing and subsequent failure to maintain aircraft control.NTSB DCA11WA107Accident · No injuriesForeign investigationBoeing DC-9 · Puerto Ordaz, VenezuelaThe Venezuelan Junta Investigadora de Accidentes de Aviación Civil (JIAAC) has notified the NTSB of an incident involving a Boeing DC-9 that occurred on September 26, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the JIAAC's…NTSB WPR11LA443Accident · No injuriesLimited investigationFinal reportCessna 152 · Redlands, CAThe flight instructor’s delayed remedial action and failure to maintain airplane control while performing a simulated aborted landing.NTSB CEN11CA677Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Monte Vista, COThe student pilot's loss of control while landing, which resulted in a ground loop.NTSB CEN11CA684Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Fort Worth, TXThe certified flight instructor’s improper flare during a simulated emergency landing.NTSB ANC11CA085Accident · No injuriesData collectionFinal reportMaule M-5-210C · Tok, AKThe pilot's failure to go-around soon enough to preclude the necessity of a forced landing due to the airplane's inability to outclimb ascending terrain.NTSB CEN11CA586Accident · Minor injuriesData collectionFinal reportCessna TU206G · Shawno, WIThe pilot's loss of control on final approach, while maneuvering to avoid birds.NTSB CEN11LA591Accident · Minor injuriesLimited investigationFinal reportAmerican Autogyro Sparrowhawk · Delaware, OHThe noncertificated pilot did not maintain adequate airspeed and aircraft control during initial climb.NTSB CEN11CA560Accident · No injuriesData collectionFinal reportCessna 182S · Los Cruces, NMThe pilot's loss of aircraft control due to insufficient aircraft performance during takeoff, with a heavy gross weight and a high density altitude.NTSB CEN11CA519Accident · No injuriesData collectionFinal reportAero SP Z O O AT-4 LSA · Colorado Springs, COThe pilot's failure to maintain proper approach speed and his inadequate recovery from a bounced landing.NTSB CEN11CA583Accident · No injuriesData collectionFinal reportMooney M20K · Cresson, TXThe pilot’s inadequate recovery from a bounced landing and subsequent failure to maintain directional control of the airplane.NTSB CEN11CA520Accident · Serious injuriesData collectionFinal reportCameron Balloons US AX10 · Clark, COThe pilot's encounter with high wind which resulted in a hard landing and passenger injury.NTSB 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.NTSB CEN11CA496Accident · No injuriesData collectionFinal reportCirrus SR20 · Battle Creek, MIThe student pilot's improper flare which resulted in a hard landing.NTSB WPR11CA336Accident · No injuriesData collectionFinal reportStearman C3-B · Spokane, WAThe pilot's failure to maintain directional control on landing. Contributing to the accident was the touch down in a slide-slip.NTSB WPR11CA330Accident · No injuriesData collectionFinal reportCessna 210-5(205) · McKenzie Bridge, ORThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB CEN11LA464Accident · Serious injuriesLimited investigationFinal reportBurtner Charles W Derjager D IX · East Liverpool, OHThe pilot's improper landing flare, which resulted in a porpoised landing and propeller contact with the runway, which caused an in-flight disintegration of the propeller during the go-around, and subsequent collision with trees.NTSB ERA11CA384Accident · No injuriesData collectionFinal reportAeronca 7DC · Greenland, NHThe pilot's improper flare, which resulted in a bounced landing, and subsequent loss of control during an attempted go-around maneuver.NTSB CEN11CA454Accident · No injuriesData collectionFinal reportVan Kalker John E RAF 2000 GTX SE · Decker, INThe improper landing flare, which resulted in the gyroplane's main rotor contacting the runway surface.NTSB ERA11CA408Accident · No injuriesData collectionFinal reportCessna 172S · Cambridge, MDThe student pilot's improper recovery from a bounced landing.NTSB ANC11CA057Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK 1 · Talkeetna, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB WPR11LA276Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 MK.3 · Jefferson, ORThe pilot's failure to maintain airplane control while on short final after experiencing a downdraft, which resulted in a subsequent hard landing.NTSB CEN11LA356Accident · Minor injuriesLimited investigationFinal reportBell 206 · Walton, KSA loss of engine power for undetermined reasons because postaccident examination of the airframe and engine revealed no anomalies.NTSB ERA11CA280Accident · No injuriesData collectionFinal reportBombardier BD700 1A10 · Teterboro, NJThe pilot's loss of aircraft control during landing in gusty wind conditions.NTSB ERA11CA248Accident · No injuriesData collectionFinal reportWalker J C Lancair 320 · Baltimore, MDThe pilot's improper recovery from a bounced landing.NTSB ERA11CA241Accident · No injuriesData collectionFinal reportCessna 172 · Ft Pierce, FLThe student pilot's inadequate flare which resulted in a hard landing.NTSB CEN11CA278Accident · No injuriesData collectionFinal reportCessna 152 · Stow, OHThe student pilot's improper recovery from a bounced landing.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 ERA11CA202Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Allentown, PAThe pilot's failure to adequately compensate for crosswind conditions, resulting in a hard landing.NTSB ERA11CA169Accident · No injuriesData collectionFinal reportLiberty Aerospace Liberty XL-2 · Burlington, NCThe student pilot's improper recovery from a bounced landing.NTSB ERA11CA144Accident · No injuriesData collectionFinal reportCessna 172H · Plattsburgh, NYThe student pilot's loss of directional control during the landing flare in gusting wind conditions and the certified flight instructor's delayed remedial action.NTSB ERA11CA134Accident · Serious injuriesData collectionFinal reportPiper PA-12 · Sebago Lake, METhe pilot’s initiation of a right turn with insufficient altitude remaining during an aborted landing resulting in a collision with the landing surface.NTSB ANC11LA009Accident · No injuriesLimited investigationFinal reportCessna 208B · Kipnuk, AKThe pilot’s decision to land long on the icy snow-covered runway, resulting in a runway excursion and collision with terrain.