NTSB investigations, 2012
236 cases where the defining event was Loss of control on ground.
Cases per year
| 2008 | 225 |
|---|---|
| 2009 | 226 |
| 2010 | 191 |
| 2011 | 203 |
| 2012 | 236 |
| 2013 | 180 |
| 2014 | 171 |
| 2015 | 185 |
| 2016 | 220 |
| 2017 | 231 |
| 2018 | 240 |
| 2019 | 230 |
| 2020 | 204 |
| 2021 | 186 |
| 2022 | 202 |
| 2023 | 210 |
| 2024 | 199 |
| 2025 | 156 |
| 2026 | 148 |
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\") = 2012
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230')
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") = 2012 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '230') 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 WPR13TA081Accident · No injuriesFinal reportBell Helicopter Textron Canada 407 · Renton, WAThe pilot's failure to maintain helicopter control during takeoff from an unstable landing platform. Contributing to the accident was the operator's inadequate chocking procedures for the wheeled landing platform, which included chocking only two of the…NTSB CEN13LA115Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Corcoran, MNThe pilot’s improper decision to land the helicopter in a position that placed the tail rotor near tarps, which resulted in the tarps being lifted into the tail rotor, subsequent tail rotor damage, a loss of tail rotor authority, and an uncommanded tail rotor…NTSB ERA13CA079Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Easton, MDThe pilot's failure to maintain directional control while landing.NTSB CEN13CA074Accident · No injuriesData collectionFinal reportCessna 172N · Poplar Grove, ILThe pilot’s failure to maintain directional control of the airplane while landing.NTSB CEN13WA173Accident · No injuriesForeign investigationSwearingen SA226 · Murcia, SpainOn November 13, 2012, at 1205 coordinated universal time, a Swearingen Fairchild SA-226-TC, Spanish registered EC-JYC, operated by Zorex.org, sustained minor damage during the takeoff roll from the Murcia-San Javier Airport (LELC), Murcia, Spain. Visual…NTSB CEN13LA057Accident · No injuriesLimited investigationFinal reportCessna T182T · San Antonio, TXThe pilot’s misjudgment of the landing speed and the runway distance remaining and his delay in applying the brakes, which resulted in an overrun.NTSB CEN13CA053Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Bryan, TXThe pilot’s over-correction in an attempt to stabilize the helicopter during liftoff.NTSB CEN13LA050Accident · No injuriesLimited investigationFinal reportWaco SRE · Lafayette, LAThe pilot’s inability to maintain directional control of the airplane during the landing roll.NTSB CEN13CA043Accident · Minor injuriesData collectionFinal reportFairchild Heli-Porter Pilatus PC6/B1A-H2 · Georgetown, OHThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.NTSB WPR13CA040Accident · No injuriesData collectionFinal reportSpackman Avid Flyer · Casper, WYThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR13CA033Accident · Minor injuriesData collectionFinal reportCessna 140 · Watsonville, CAThe pilot’s failure to maintain airplane control during the landing roll.NTSB CEN13CA040Accident · No injuriesData collectionFinal reportCessna 172S · McKinney, TXThe student pilot's loss of directional control during landing.NTSB WPR13CA024Accident · No injuriesData collectionFinal reportCessna 170A · Calexico, CAThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion.NTSB ERA13LA041Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Fairhope, ALThe Grumman pilot’s loss of directional control during landing for undetermined reasons because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the Piper pilot…NTSB ANC13CA005Accident · No injuriesData collectionFinal reportCessna A185E · Talkeetna, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a ground loop.NTSB CEN13CA021Accident · Minor injuriesData collectionFinal reportPiper PA-18-105 Special · Lonoke, ARThe pilot's failure to maintain directional control during the landing.NTSB WPR13CA012Accident · No injuriesData collectionFinal reportMaule MX-7-180C · Bishop, CAThe pilot's inadequate compensation for the variable wind conditions and his failure to maintain directional control.NTSB ANC12GA114Accident · No injuriesFinal reportQuest Kodiak 100 · Anchorage, AKThe pilot's failure to maintain directional control while landing, which resulted in a collision with the water. Contributing to the accident were the pilot's lack of experience conducting waterborne operations in the accident make and model airplane and the…NTSB WPR12CA440Accident · No injuriesData collectionFinal reportCessna 180 · Huntington, UTThe pilot's inadvertent encounter with a gust front during the takeoff roll, which resulted in loss of control of the airplane.NTSB WPR12LA443Accident · No injuriesLimited investigationFinal reportBeech V35A · Torrance, CAThe pilot's failure to maintain directional control during taxi, which resulted in a collision with a parked vehicle.NTSB ANC12LA113Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Fairbanks, AKThe pilot’s excessive application of brakes during landing, which resulted in a noseover.NTSB WPR12CA438Accident · No injuriesData collectionFinal reportCessna 150 · St Johns, AZThe pilot's failure to maintain directional control during landing in gusty crosswind conditions.NTSB ERA12CA573Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Berlin, NJThe pilot’s failure to maintain directional control during landing.NTSB ANC12CA110Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Port Alsworth, AKThe pilot's loss of directional control during takeoff in gusting wind conditions from an off-airport site, which resulted in a collision with terrain and a nose over.NTSB CEN12LA668Accident · No injuriesLimited investigationFinal reportThompson RV-6 · Pagosa Springs, COThe pilot’s failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot’s lack of landing experience at high density altitudes.NTSB WPR12CA427Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Lincoln, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR12CA424Accident · No injuriesData collectionFinal reportCessna A185F · Andrews, ORThe pilot's failure to maintain directional control during a crosswind landing.NTSB ANC12CA108Accident · No injuriesData collectionFinal reportCessna 172K · Atqasuk, AKThe student pilot's failure to maintain directional control while performing a high-speed taxi in windy conditions.NTSB ANC12CA105Accident · No injuriesData collectionFinal reportCessna 170B · Bethel, AKThe pilot's failure to maintain directional control during takeoff, which resulted in a ground loop.NTSB WPR12CA412Accident · No injuriesData collectionFinal reportGrob-Werke G 120A · Mobile, AZThe student pilot’s failure to maintain directional control of the airplane during the takeoff roll and the subsequent aborted takeoff in a gusting crosswind.NTSB CEN12CA641Accident · No injuriesData collectionFinal reportPiper PA-11 · Ft. Morgan, COThe pilot's loss of control during landing after encountering an unexpected wind gust.NTSB ANC12CA104Accident · No injuriesData collectionFinal reportStinson 108-2 · Nikiski, AKThe pilot's selection of an unsuitable landing surface, which resulted in a loss of control during the landing roll.NTSB WPR12CA404Accident · Minor injuriesData collectionFinal reportKorrison Tom Sparrow Hawk · Spanish Fork, UTThe pilot's failure to maintain directional control of the gyroplane during an aborted takeoff.NTSB ERA12CA547Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Tail Dragger · Elizabethtown, KYThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane during a takeoff in gusty crosswind conditions. Contributing to the accident was the pilot's decision to take off in gusty wind conditions associated with approaching…NTSB CEN12CA627Accident · No injuriesData collectionFinal reportSchneider John W PT-2A · Watkins, COThe pilot's loss of control during takeoff resulting in a runway excursion. Contributing to the accident was an unexpected wind gust.NTSB WPR12LA391Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Toledo, ORThe pilot’s failure to maintain directional control of the airplane after landing.NTSB WPR12CA397Accident · No injuriesData collectionFinal reportChampion 7GC · Spanish Fork, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN12CA614Accident · No injuriesData collectionFinal reportCessna L-19E · Lancaster, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB CEN12CA596Accident · No injuriesData collectionFinal reportArvold Jordon R CH 750 · Colfax, WIThe pilot did not maintain control of the airplane while landing with a gusty crosswind.NTSB WPR12CA381Accident · No injuriesData collectionFinal reportCessna A185F · Gerlach, NVThe pilot's failure to maintain directional control during the takeoff roll.NTSB CEN12CA607Accident · No injuriesData collectionFinal reportNorth American AT-6F · Council Bluffs, IAAn unlocking of the excessively worn tailwheel lock mechanism, which resulted in a loss of directional control during landing.NTSB ANC12CA102Accident · No injuriesData collectionFinal reportPiper PA-12 · Aniak, AKThe pilot's excessive use of brakes during the landing roll, which resulted in a nose over.NTSB ANC12CA098Accident · No injuriesData collectionFinal reportMaule M-5-210C · Juneau, AKThe pilot's failure to maintain directional control of the tailwheel-equipped airplane during landing, resulting in a ground loop. Contributing to the accident was the flight instructor's failure to adequately monitor the landing.NTSB CEN12LA593Accident · No injuriesLimited investigationFinal reportMudge Ray KIT FOX 5 · Bowling Green, OHThe pilot receiving instruction's excessive braking during the landing roll, which resulted in a loss of control.NTSB CEN12CA585Accident · No injuriesData collectionFinal reportCessna 180 · Brookville, OHThe pilot's failure to maintain directional control of the airplane during the attempted takeoff in gusting crosswind conditions.NTSB ERA12CA533Accident · Minor injuriesData collectionFinal reportStearman M-2 · Robbinsville, NJThe pilot's failure to maintain directional control during the landing roll.NTSB ERA12CA531Accident · No injuriesData collectionFinal reportCessna 172P · Lyman, MSThe pilot's loss of directional control during takeoff as a result of his attempt to close an unsecured cockpit window.NTSB ERA12CA529Accident · No injuriesData collectionFinal reportStinson 108-2 · Winter Haven, FLThe pilot’s failure to maintain directional control during the takeoff, which resulted in a runway excursion.NTSB CEN12CA574Accident · No injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Centralia, ILThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB WPR12CA368Accident · No injuriesData collectionFinal reportPiper PA-28-140 · McMinnville, ORThe pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion.