NTSB investigations, 2011
240 cases where NTSB found Directional control.
Cases per year
| 2008 | 224 |
|---|---|
| 2009 | 240 |
| 2010 | 229 |
| 2011 | 240 |
| 2012 | 250 |
| 2013 | 185 |
| 2014 | 201 |
| 2015 | 183 |
| 2016 | 245 |
| 2017 | 236 |
| 2018 | 247 |
| 2019 | 211 |
| 2020 | 195 |
| 2021 | 195 |
| 2022 | 206 |
| 2023 | 214 |
| 2024 | 205 |
| 2025 | 175 |
| 2026 | 90 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062020'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01062020')) 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 ERA12CA160Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Raleigh, NCThe pilot's loss of directional control while landing in gusting wind conditions.NTSB ERA12CA129Accident · Minor injuriesData collectionFinal reportKoth Larry Jabiru Calypso · Mansfield, MAThe pilot did not maintain directional control during landing. Contributing to the accident was the pilot’s not closing the throttle upon landing and his improper adjustment of the airplane’s brakes.NTSB CEN12CA117Accident · No injuriesData collectionFinal reportLuscombe 8E · Atchison, KSThe pilot's inadequate directional control during the landing roll.NTSB WPR12CA068Accident · No injuriesData collectionFinal reportBeech J35 · Cheyenne, WYThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.NTSB WPR12CA061Accident · No injuriesData collectionFinal reportGrumman AA5 · Furnace Creek, CAThe pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.NTSB CEN12CA099Accident · No injuriesData collectionFinal reportCessna 172N · Wauseon, OHThe student pilot's loss of directional control during landing.NTSB ERA12CA094Accident · No injuriesData collectionFinal reportNuse George F1H Rocket · Caroleen, NCThe pilot did not maintain directional control during takeoff at night due to his distraction with a dropped flashlight, and he delayed his decision to abort the takeoff.NTSB WPR12CA049Accident · No injuriesData collectionFinal reportCessna 172K · Napa, CAThe student pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.NTSB ERA12CA083Accident · Minor injuriesData collectionFinal reportCessna 162 · Lincoln Park, NJThe pilot's inadequate recovery from a bounced landing, which resulted in a loss of airplane control, a runway excursion, and collision with trees.NTSB WPR12LA045Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Boulder City, NVThe pilot's failure to maintain directional control while taxiing with a gusting crosswind.NTSB ERA12CA075Accident · No injuriesData collectionFinal reportBellanca 17-30A · Pine Mountain, GAThe pilot's inadequate directional control during landing, which resulted in a runway excursion.NTSB CEN12LA066Accident · Minor injuriesLimited investigationFinal reportPiaggio Aero Industries P180 · Flint, MIThe captain's failure to maintain directional control during landing with one engine inoperative. Contributing to the accident was an improperly installed clevis pin in the left engine power lever, the crew’s delay in accurately identifying their heading, and…NTSB WPR12CA038Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe student pilot's inadequate directional control during takeoff.NTSB CEN12CA065Accident · No injuriesData collectionFinal reportCessna 182J · Alexandria, MNThe pilot's failure to maintain directional control during the night landing.NTSB CEN12CA062Accident · Minor injuriesData collectionFinal reportBeech 58 · Connersville, INThe pilot's failure to maintain directional control of the airplane during landing.NTSB WPR12CA033Accident · No injuriesData collectionFinal reportCasler Scott CX-4 · San Carlos, AZThe pilot's inadequate directional control during takeoff.NTSB ERA12CA064Accident · No injuriesData collectionFinal reportStinson 108-3 · Whitefield, NHThe student pilot did not maintain directional control during the landing flare.NTSB ERA12LA061Accident · Minor injuriesLimited investigationFinal reportCessna 172R · Frederick, MDThe student pilot’s inadequate directional control during the landing roll.NTSB WPR12CA028Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Grangeville, IDThe pilot's failure to maintain directional control during the landing roll.NTSB CEN12LA056Accident · No injuriesLimited investigationFinal reportCessna 182K · Branson West, MOThe pilot's failure to ensure that his seat was in a locked position before takeoff, which resulted in the seat sliding rearward and the subsequent loss of directional control.NTSB ANC12CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Portage, AKThe pilot's selection of unsuitable terrain for landing.NTSB CEN12CA028Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Brookings, SDThe pilot's inadequate compensation for gusty wind conditions while landing.NTSB CEN12CA038Accident · No injuriesData collectionFinal reportPipistrel Sinus 912 · Indianapolis, INThe pilot's failure to maintain directional control of the motor-glider while landing in gusty wind conditions.NTSB CEN12CA024Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Moriarty, NMThe pilot's failure to maintain control of the airplane during the landing roll.NTSB ERA12CA037Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Deland, FLThe pilot's inadequate directional control during the landing roll.NTSB ERA12CA029Accident · No injuriesData collectionFinal reportCessna 180H · Houston, MSThe pilot did not maintain directional control during the landing roll.NTSB WPR12CA011Accident · Minor injuriesData collectionFinal reportCessna 170B · Ramona, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB ERA12CA168Accident · No injuriesData collectionFinal reportMaule MX-7-180C · Zelienople, PAThe pilot did not maintain directional control during landing.NTSB ANC12CA003Accident · No injuriesData collectionFinal reportPiper PA-18 · Skwentna, AKThe pilot's inadequate clearance from a tree during an off-airport landing.NTSB ERA12LA358Accident · No injuriesLimited investigationFinal reportCessna 182C · Efland, NCThe pilot’s loss of directional control during the landing roll, which resulted in a collision with a ditch.NTSB ERA12CA116Accident · No injuriesData collectionFinal reportCessna 188 · Starkville, MSThe pilot did not maintain directional control of the airplane during landing, which resulted in a runway excursion.NTSB CEN12LA013Accident · No injuriesLimited investigationFinal reportWilhelm Calidus · Thompsonville, MIThe pilot 's inability to maintain control of the gyrocraft during the landing roll for undetermined reasons.NTSB ERA12LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Norfolk, VAThe pilot's inability to maintain directional control during takeoff for undetermined reasons. Contributing to the accident was the pilot's delayed decision to abort the takeoff.NTSB CEN12CA005Accident · No injuriesData collectionFinal reportCampbell John Mustang II · Brush, COThe pilot’s failure to maintain directional control during taxi, which resulted in a runway excursion.NTSB ANC11CA112Accident · No injuriesData collectionFinal reportCessna 180 · Haines, AKThe pilot's loss of directional control during takeoff in a float-equipped airplane for an undetermined reason, which resulted in the airplane colliding with trees and the shore.NTSB WPR11CA466Accident · Minor injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe pilot’s failure to maintain directional control during the landing rollout.NTSB WPR11CA465Accident · No injuriesData collectionFinal reportCessna 182 · Roosevelt, UTThe pilot's loss of directional control during the landing rollout.NTSB WPR11CA464Accident · No injuriesData collectionFinal reportCessna 180 · Orcas Island, WAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB ANC11CA096Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain control of the airplane while taking off with a gusting crosswind.NTSB CEN11CA668Accident · No injuriesData collectionFinal reportCessna R172K · Jonesboro, ARThe pilot's failure to maintain directional control of the airplane while taxiing.NTSB WPR11CA456Accident · No injuriesData collectionFinal reportCub Crafters CC11-100 · San Jose, CAThe pilot's failure to maintain directional control while taxiing due to his distraction by a cockpit warning light.NTSB ANC11CA104Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of experience/training in tailwheel-equipped airplanes.NTSB ERA11CA494Accident · No injuriesData collectionFinal reportMooney M20K · Anderson, SCThe pilot's failure to maintain directional control during an attempted go-around.NTSB ERA11CA490Accident · No injuriesData collectionFinal reportCessna 172R · Naples, FLThe student pilot's improper flare, which resulted in a hard landing and subsequent loss of directional control.NTSB CEN11LA642Accident · No injuriesLimited investigationFinal reportPiper PA16 · Muskegan, MIThe pilot's loss of directional control during the takeoff roll and the flight instructor's inability to apply remedial action due to the opposite corrective control inputs by the pilot.NTSB WPR11LA444Accident · Minor injuriesLimited investigationFinal reportMaule M-4-220C · Show Low, AZThe pilot’s failure to maintain directional control during the landing, which resulted in a ground loop.NTSB WPR11CA445Accident · No injuriesData collectionFinal reportAero SP Z O O AT-4 LSA · San Diego, CAThe pilot's improper recovery from a bounced landing and failure to maintain control during an attempted go-around.NTSB WPR11CA440Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll.NTSB ERA11LA491Accident · No injuriesLimited investigationFinal reportCessna TR182 · Stevensville, MDThe pilot did not maintain directional control during the landing roll.NTSB ERA11CA482Accident · No injuriesData collectionFinal reportQuestair Venture · Memphis, TNThe pilot's inability to maintain directional control during landing with a flat tire. Contributing to the accident was the failure of the left main landing gear tire for undetermined reasons.