NTSB investigations, MO
31 cases where the sequence of events included Abnormal runway contact.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 3 |
| 2015 | 2 |
| 2016 | 6 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 2 |
| 2024 | 1 |
| 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '090' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '090' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN26LA122Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Golden, MOThe pilot’s failure to establish stabilized approach that would have allowed the airplane to touch down with adequate runway remaining. Contributing to the accident was the pilot’s failure to execute a go-around.NTSB CEN24LA159Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Chesterfield, MOThe student pilot’s failure to maintain control during takeoff. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB CEN22LA444Accident · No injuriesClass 4 · LimitedFinal reportRockwell International 112A · Lee's Summit, MOThe pilot’s improper landing flare, which resulted in a bounced landing and the nose landing gear collapse.NTSB CEN22LA435Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Grand Glaize, MOThe pilot’s improper landing flare which resulted in a bounced landing.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 CEN21LA098Accident · Serious injuriesClass 4 · LimitedFinal reportQuad City Challenger II · Waldron, MOThe pilot’s improper landing flare during the rejected takeoff that resulted in a hard landing and nose landing gear collapse.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 CEN20LA095Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Chesterfield, MOThe flight instructor’s and student pilot’s failure to ensure that the landing gear was extended before landing.NTSB GAA18CA518Accident · Minor injuriesData collectionFinal reportRans Rans S6S · Painton, MOThe pilot's failure to maintain the proper pitch attitude during landing, which resulted in a bounced, hard landing.NTSB CEN17LA206Accident · No injuriesLimited investigationFinal reportKenneth B Hines Nieuport 28 · Boonville, MOA partial loss of engine power due to a compromised induction system.NTSB GAA17CA120Accident · No injuriesData collectionFinal reportPiper PA28 · St. Louis, MOThe student pilot's improper landing flare, which resulted in a bounced landing.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 GAA16CA386Accident · No injuriesData collectionFinal reportCessna 172 · Chesterfield, MOThe student pilot's improper pitch control during the landing flare, which resulted in a porpoise and substantial damage to the firewall.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 DCA16LA100Accident · No injuriesLimited investigationFinal reportEmbraer EMB145 · St Louis, MOthe flight crews' failure to consider all available runways for landing to minimize the gusty crosswind component. Contributing to the accident was the captain's reduction of the engine thrust for about 1 second at low altitude immediately after the first…NTSB CEN15LA229Accident · No injuriesLimited investigationFinal reportBell 206L 3 · Chesterfield, MOThe collision of the helicopter's skid shoe with the runway centerline light during landing, which abruptly stopped the helicopter and resulted in damage to the fuselage.NTSB CEN15CA165Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Lee's Summit, MOThe pilot-receiving-instruction's excessive pitch control during takeoff, which resulted in an aerodynamic stall shortly after liftoff and the subsequent loss of control. Contributing to the accident was the flight crew's decision to have the flight…NTSB CEN13CA077Accident · No injuriesData collectionFinal reportChristen Industries Pitts S-2S · Grain Valley, MOThe pilot's improper landing flare, which led to a bounced landing and subsequent loss of control.NTSB CEN12LA645Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Branson, MOThe pilot's failure to maintain airplane control during an attempted go-around in dark night conditions.NTSB CEN12CA391Accident · No injuriesData collectionFinal reportLuscombe 8A · Mexico, MOThe airplane's encounter with a downdraft during the landing flare, which resulted in a hard landing.NTSB CEN12CA089Accident · No injuriesData collectionFinal reportCessna 182L · Branson, MOThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB CEN11IA179Incident · No injuriesIncident investigationFinal reportCessna 210N · Columbia, MOThe pilot did not extend the landing gear before touchdown due to his distraction during the landing approach and his not using a landing checklist.NTSB CEN11FA008Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Springfield, MOThe pilot's failure to maintain control of the airplane during an attempted go-around, which led to an aerodynamic stall.NTSB CEN10CA258Accident · No injuriesData collectionFinal reportCalcote Clarence E Glasair RG · Lee's Summit, MOThe failure of the landing gear to fully extend and lock in the down position for unknown reasons.NTSB CEN10CA197Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Creve Couer, MOThe pilot's failure to go-around during a simulated engine failure and the instructor pilot's delay in remedial actions.NTSB CEN10LA076Accident · No injuriesLimited investigationFinal reportBeech 200 · St. Louis, MOThe pilot's failure to properly follow the manual landing gear extension procedure, resulting in a gear-up landing.NTSB CEN09LA389Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · St. Louis, MOThe pilot’s failure to establish and maintain a stabilized final approach which resulted in a hard landing and runway overrun.NTSB CEN09CA175Accident · No injuriesData collectionFinal reportGates Learjet 35A · Kansas City, MOThe copilot's failure to maintain control of the airplane during the go-around. Contributing to the accident was the flight crew's delayed decision to perform a go-around.NTSB CEN09CA066Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Bowling Green, MOFailure of the pilot to maintain aircraft control during the landing sequence. A contributing factor was the sudden gusty crosswind.NTSB DFW08LA209Accident · No injuriesLimited investigationFinal reportEvektor Aerotechnik Sportstar · St Charles, MOThe student pilot's failure to maintain control due to his task saturation as a result of his failure to set the pitch trim to the neutral position before takeoff.