NTSB investigations, MO
61 cases where the defining event was Loss of control on ground.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 5 |
| 2012 | 6 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 5 |
| 2017 | 6 |
| 2018 | 7 |
| 2019 | 4 |
| 2020 | 3 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 2 |
| 2026 | 1 |
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 c.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA' 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 ANC26LA073Accident · No injuriesClass 4 · LimitedInvestigation openAviat A-1C-200 · Springfield, MONTSB CEN25LA063Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Springfield, MOThe student pilot’s failure to maintain control of the helicopter while turning on the blower fan switch after landing that resulted in a dynamic rollover sequence.NTSB CEN24LA225Accident · No injuriesClass 4 · LimitedFinal reportRobert L Staton Javron INC PA-18 REP · Schell City, MOThe pilot’s failure to maintain directional control during landing that resulted in a ground loop and impact with the runway surface.NTSB CEN23LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna A188B · Chillicothe, MOThe pilot’s decision to operate the airplane with a known tailwheel anomaly, which resulted in a loss of directional control.NTSB CEN23LA196Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Kansas City, MOThe student pilot's failure to maintain directional control during takeoff.NTSB CEN22LA360Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Neosho, MOThe pilot’s inadvertent application of the right brake and subsequent loss of airplane directional control, which resulted in a taxiway excursion and impact with trees.NTSB CEN22LA280Accident · No injuriesClass 4 · LimitedFinal reportAero Commander S2R · Maryville, MOThe pilot’s failure to maintain control during the landing with a quartering tailwind.NTSB CEN21LA312Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · St. Louis, MOThe pilot’s failure to maintain directional control during the landing roll with hydroplaning conditions.NTSB CEN21LA217Accident · No injuriesClass 4 · LimitedFinal reportSmith Miniplane DSA-1 · Fulton, MOThe pilot’s failure to maintain control of the airplane during landing in gusty crosswinds.NTSB CEN20CA362Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Lebanon, MOThe pilot's failure to maintain directional control during landing.NTSB CEN20CA184Accident · No injuriesClass 4 · Data collectionFinal reportRhoads, Larry E Sopwith Baby · Lee's Summit, MOThe airplane builder's improper installation of the lower right wing which resulted in an uncommanded left roll and the subsequent loss of control.NTSB CEN20CA117Accident · Minor injuriesData collectionFinal reportPiper PA28-180 · Eolia, MOThe pilot's improper landing flare in gusting wind conditions, which resulted in a bounced landing, loss of directional control, runway excursion, and impact with a tree.NTSB GAA20CA072Accident · No injuriesData collectionFinal reportCessna U206 · Mexico, MOThe pilot's failure to properly set the parking brake before exiting an operating airplane, which resulted in a runaway airplane and subsequent impact with trees.NTSB GAA19CA443Accident · No injuriesData collectionFinal reportValldejuli John A Aerocomp · Jefferson City, MOThe pilot's failure to maintain directional control during a touch-and-go landing in gusting crosswind conditions, which resulted in a runway excursion, impact with runway lights, and a nose-over.NTSB CEN19LA198Accident · No injuriesClass 3 · LimitedFinal reportVans RV8 · Joplin, MOThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB GAA19CA170Accident · No injuriesData collectionFinal reportPiper PA 11 · Moberly, MOThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions.NTSB WPR19LA006Accident · 1 fatalClass 2 · LimitedFinal reportVans RV6 · Cape Girardeau, MOThe pilot's improper landing flare in gusting crosswind conditions, his failure to conduct a go-around, and his failure to maintain directional control, which resulted in a runway departure and nose-over.NTSB GAA19CA008Accident · Minor injuriesData collectionFinal reportCessna 188 · Rolla, MOThe pilot's failure to maintain directional control during takeoff in a left quartering tailwind.NTSB GAA19CA012Accident · No injuriesData collectionFinal reportBearden Biplane Sopwith Camel · Bolivar, MOThe pilot's failure to maintain directional control during landing.NTSB WPR18LA255Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Richland, MOA loss of directional control during a touch-and-go landing in gusting crosswind conditions.NTSB GAA18CA524Accident · No injuriesData collectionFinal reportLuscombe 8 · Fulton, MOThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB GAA18CA516Accident · No injuriesData collectionFinal reportPiper PA28 · Point Lookout, MOThe student pilot's inadvertent left brake application during the landing roll, which resulted in a runway excursion and collision with runway lights.NTSB CEN18LA220Accident · No injuriesLimited investigationFinal reportBeech A23 · Sedalia, MOThe pilot’s loss of directional control during the landing rollout due to the unexpected wind shift, which resulted in a runway excursion.NTSB GAA18CA055Accident · No injuriesData collectionFinal reportBellanca 8KCAB · El Dorado, MOThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA525Accident · No injuriesData collectionFinal reportCessna 182 · Lockwood, MOThe pilot’s unstabilized approach and failure to go around, which resulted in a runway overrun on a wet, grass runway.NTSB GAA17CA498Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Perryville, MOThe pilot’s failure to maintain directional control during takeoff.NTSB CEN17LA326Accident · No injuriesLimited investigationFinal reportCessna 182 · Booneville, MOThe pilot’s failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion.NTSB GAA17CA246Accident · No injuriesData collectionFinal reportThomas B Mcgrath JA30 Superstol · Chesterfield, MOThe pilot’s failure to maintain directional control of the airplane during the landing roll in crosswind conditions.NTSB GAA17CA195Accident · No injuriesData collectionFinal reportIniziative Industriali Italian SKY Arrow 600 Sport · Mosby, MOThe student pilot's failure to maintain directional control during an attempted go-around.NTSB GAA17CA046Accident · No injuriesData collectionFinal reportCirrus SR22 · Kirksville, MOThe pilot’s improper compensation for changing wind during the landing flare, which resulted in an off-centered landing and a subsequent loss of directional control.NTSB GAA16CA473Accident · No injuriesData collectionFinal reportCessna 172 · Fulton, MOThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the airplane porpoising.NTSB GAA16CA203Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Maryville, MOThe pilot's unintentional brake application during the landing roll, which resulted in a nose over.NTSB GAA16CA192Accident · No injuriesData collectionFinal reportCessna E162 · Lee's Summit, MOThe flight instructor's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and collision with a taxiway sign.NTSB GAA16CA217Accident · No injuriesData collectionFinal reportCessna A185 · Chesterfield, MOThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop and a wing strike.NTSB GAA15CA201Accident · No injuriesData collectionFinal reportAeronca 7BCM · Warsaw, MOThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and a collision with terrain.NTSB GAA15CA166Accident · No injuriesData collectionFinal reportBryan Jerry R CH750 · Gainesville, MOThe pilot's perception that the airplane was not climbing normally, which precipitated an aborted landing with insufficient runway remaining to stop the airplane safely.NTSB GAA15CA112Accident · No injuriesData collectionFinal reportCessna 180 · Vichey, MOThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion and collision with terrain.NTSB GAA15CA036Accident · No injuriesData collectionFinal reportPiper PA 22-135 · Drexel, MOThe pilot's failure to maintain airplane control while taxiing in unfavorable wind conditions.NTSB CEN14CA383Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · St. Louis, MOThe pilot's decision to operate an airplane with a known deficiency and to not properly secure the airplane before hand-starting the engine.NTSB CEN14CA250Accident · No injuriesData collectionFinal reportSantschi Chris A Vans RV8 · Bonne Terre, MOThe pilot's failure to maintain aircraft control on takeoff.NTSB CEN14CA040Accident · No injuriesData collectionFinal reportCessna 182Q · Braggadocio, MOThe pilot's failure to maintain directional control during landing rollout, which resulted in a runway excursion and the airplane nosing over.NTSB CEN13LA379Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Salisbury, MOThe airplane's reduced braking efficiency and the pilot's subsequent delayed decision to go around, which resulted in a loss of directional control.NTSB CEN12CA450Accident · No injuriesData collectionFinal reportCessna 195B · Camdenton, MOThe pilot's loss of directional control on landing, which resulted in a runway excursion.NTSB CEN12CA399Accident · No injuriesData collectionFinal reportEdson Robert W Pietenpol AIR Camper · Point Lookout, MOThe pilot's failure to maintain directional control during landing, resulting in a ground-loop.NTSB CEN12LA362Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Mt. Vernon, MOThe pilot’s decision to continue the landing on a short grass runway with a tailwind after touching down beyond the touchdown point, and his subsequent failure to stop the airplane before colliding with trees off the end of that runway. Contributing to the…NTSB CEN12CA293Accident · No injuriesData collectionFinal reportCessna 152 · Lee's Summit, MOThe student pilot’s loss of directional control while landing.NTSB CEN12CA193Accident · No injuriesData collectionFinal reportBellanca 17-30A · Branson, MOThe pilot did not maintain directional control of the airplane while landing with a gusting crosswind.NTSB CEN12LA147Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Kansas City, MOThe failure of the nosewheel steering pushrod, which resulted in a loss of airplane directional control and runway excursion.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 CEN11CA613Accident · Minor injuriesData collectionFinal reportTaylorcraft DCO-65 · Higginsville, MOThe pilot's failure to maintain directional control during landing and his failure to maintain clearance from trees during the attempted aborted landing.