NTSB investigations
3,969 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 | 88 |
Where
Latest 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 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 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 ERA26LA359Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Mount Pleasant, SCThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.NTSB CEN26LA315Accident · No injuriesClass 4 · LimitedFinal reportProgressive Aerodyne Searey · DeQuincy, LAThe pilot’s failure to maintain directional control during takeoff after encountering a wind gust. Contributing to the accident was nearby convective activity.NTSB ERA26LA334Accident · Minor injuriesClass 4 · LimitedFinal reportNorth American Harvard III · Sanatoga, PAThe pilot’s failure to maintain control of the airplane while landing in a crosswind.NTSB ERA26LA330Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Leesburg, FLThe instructor’s delayed remedial action during an aborted landing, which resulted in a loss of airplane control.NTSB CEN26LA304Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Hudson Oaks, TXThe pilot’s loss of directional control during the rejected takeoff, which resulted in a runway excursion. Contributing to the accident was the pilot’s decision to abort the takeoff after the airplane had accelerated above its normal rotation speed. Also…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 ERA26LA315Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Rural Retreat, VAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN26LA297Accident · Minor injuriesClass 4 · LimitedFinal reportAeroprakt Manufacturing SP Zoo A22LS · Searcy, ARThe flight instructor’s failure to maintain airplane control during landing in gusting wind conditions.NTSB CEN26LA298Accident · Minor injuriesClass 4 · LimitedFinal reportRotor Effects M24 Plus · Waelder, TXThe pilot’s improper execution of rejected takeoff procedures, which resulted in loss of control and subsequent runway excursion.NTSB ERA26LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna 680 · Statesville, NCThe pilot’s failure to maintain directional control while landing in a strong gusting crosswind.NTSB ERA26LA282Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Sanford, METhe pilot’s loss of directional control during landing and the flight instructor’s inadequate remedial action, which resulted in a ground loop.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 ERA26LA279Accident · No injuriesClass 4 · LimitedFinal reportBeech A23-24 · Middlefield, OHThe flight instructor’s failure to maintain directional control during landing.NTSB ERA26LA276Accident · Minor injuriesClass 4 · LimitedFinal reportChristen Industries Pitts S-2 · Porter Center, NYThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR26LA261Accident · No injuriesClass 4 · LimitedFinal reportKitfox S7 STI · Greenwater, WAThe pilot’s failure to maintain directional control during the landing roll, in variable wind conditions.NTSB ERA26LA272Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Hartwell, GAThe pilot’s failure to compensate for the gusty and variable wind conditions, which resulted in a loss of control and collision with trees during takeoff.NTSB WPR26LA253Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Marbleton, WYThe pilot's failure to maintain directional control during the landing roll.NTSB WPR26LA259Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Monte Vista, COThe pilot’s failure to maintain directional control during takeoff in gusty crosswind conditions.NTSB WPR26LA250Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Buffalo, WYThe pilot’s improper flare and subsequent failure to maintain directional control of the airplane during the aborted landing.NTSB WPR26LA248Accident · No injuriesClass 4 · LimitedFinal reportDean J Irvin KFA Safari XL · Saratoga, WYThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB CEN26LA245Accident · Serious injuriesClass 4 · LimitedFinal reportXag P150 MAX · Wolcott, INThe pilot’s failure to maintain control of the UAS during takeoff.NTSB ERA26LA255Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Lafayette, TNThe passenger’s abrupt manipulation of the flight controls during takeoff, which resulted in a loss of directional control and collision with a fence.NTSB CEN26LA243Accident · Serious injuriesClass 4 · LimitedFinal reportEvolution Revolt · Peyton, COThe flight instructor’s inadequate supervision of the student pilot, which resulted in the loss of control during a rejected takeoff.NTSB WPR26LA239Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · El Cajon, CAThe pilot's failure to maintain directional control during landing with a right crosswind,.NTSB WPR26LA238Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A185F · Angel Fire, NMThe pilot’s loss of directional control during landing with a crosswind.NTSB ERA26LA247Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Morganton, NCThe pilot and flight instructor’s failure to maintain directional control while maneuvering on the runway, which resulted in a runway excursion. Contributing to the accident was the pilot’s failure to complete a positive exchange of flight control following…NTSB WPR26LA244Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18A · Minden, NVThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB WPR26LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Port Angeles, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA26LA236Accident · Minor injuriesClass 4 · LimitedFinal reportCub Crafters CC19-215 · Plymouth, NHThe pilot’s failure to maintain control of the airplane during an aborted landing attempt which resulted in an aerodynamic stall.NTSB ERA26LA237Accident · No injuriesClass 4 · LimitedFinal reportSinclair Pete Lancair ES · Youngstown, OHThe pilot’s failure to maintain directional control during takeoff roll, which resulted in a runway excursion and collision with an approach lighting system.NTSB WPR26LA231Accident · No injuriesClass 4 · LimitedFinal reportRans S-7 Courier · Wessington Springs, SDThe pilot’s failure to maintain directional control during landing and subsequent go-around with a gusty right crosswind.NTSB ERA26LA240Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-108 · Westminster, MDThe pilot’s failure to maintain airplane control during takeoff, which resulted in a runway excursion and collision with terrain.NTSB WPR26LA207Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-2 · Mettler, CAThe pilot's failure to ensure the loading hose had been disconnected before takeoff, which resulted in an interrupted takeoff and subsequent loss of control. Contributing to the accident was the ground loader's failure to disconnect the hose before…NTSB CEN26LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Colorado Springs, COThe student pilot’s failure to maintain directional control of the airplane during the takeoff, which resulted in a runway excursion and collision with runway signs.NTSB CEN26LA206Accident · No injuriesClass 4 · LimitedFinal reportPitts Special S-1S · Bartlesville, OKThe pilot’s failure to maintain control during the landing rollout and subsequent aborted landing.NTSB ERA26LA218Accident · No injuriesClass 4 · LimitedFinal reportGulfstream Aerospace GVII-G600 · Birmingham, ALThe flight crew’s decision to continue the landing approach into adverse weather conditions, which resulted in a loss visual reference and loss airplane control during landing.NTSB WPR26LA200Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll with gusting crosswind conditions.NTSB ERA26LA212Accident · Minor injuriesClass 4 · LimitedFinal reportGranito Joseph R RV-7A · Jaffrey, NHThe pilot’s failure to maintain directional control of the airplane during landing, which resulted in a touchdown off the paved runway surface and a collision with terrain during the subsequent aborted landing.NTSB CEN26LA193Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Rice Lake, WIThe pilot’s failure to maintain directional control during landing.NTSB WPR26LA195Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Arco, IDThe pilot's failure to maintain directional control during the landing roll with a right crosswind.NTSB WPR26LA192Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Vernal, UTThe pilot's failure to maintain control during the landing flare with a gusting crosswind.NTSB WPR26LA193Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ACA · Pacific City, ORThe pilot’s loss of directional control during a precautionary landing following a partial reduction in engine rpm.NTSB WPR26LA194Accident · Minor injuriesClass 4 · LimitedFinal reportAutogyro Cavalon · Palo Alto, CAThe pilot’s failure to maintain directional control during the landing roll, in gusting crosswind conditions.NTSB CEN26LA185Accident · No injuriesClass 3 · LimitedFinal reportBell 407 · Dallas, TXThe pilot’s failure to maintain situational awareness and clearance from the helipad surveillance camera during liftoff.NTSB WPR26LA187Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Sedona, AZThe pilot’s inability to maintain directional control due to a plastic foreign object jammed in the rudder pedals, while landing with a gusting left crosswind.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 ERA26LA202Accident · No injuriesClass 4 · LimitedFinal reportSherry Grobstein LSA-8X · Hyannis, MAThe pilot’s failure to maintain control of the airplane while landing, which resulted in a ground loop and subsequent nose over.NTSB WPR26LA175Accident · No injuriesClass 4 · LimitedFinal reportCosmos Phase II · Prineville, ORThe pilot's inability to maintain directional control during the landing roll due to a flat tire.NTSB ERA26LA187Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Quakertown, PAThe pilot receiving instruction’s failure to maintain aircraft directional control during the takeoff roll. Contributing was the flight crew’s failure to ensure a positive exchange of flight controls during the takeoff roll.NTSB ERA26LA184Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Tampa, FLThe pilot’s failure to maintain directional control of the airplane during the aborted landing, which resulted in a runway excursion, collision with a runway sign, and nose over.