NTSB investigations, MO
36 cases where NTSB found Landing gear system.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 4 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 2 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 3 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 1 |
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.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010232'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010232')) 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 CEN25LA407Accident · No injuriesClass 4 · LimitedFinal reportCessna 414 · Maryville, MOThe left landing gear collapsed on landing rollout due to a fractured retract bellcrank on the left landing gear lower fork assembly.NTSB CEN25LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Springfield, MOThe flight instructor’s inability to confirm landing gear position before landing due to the sun glare which resulted in gear up landing. Contributing to the accident was an undetected tripped circuit breaker for the landing gear and the inoperative gear…NTSB CEN24LA234Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20J · Ava, MOThe pilot’s failure to maintain control of the airplane resulting in a runway excursion during landing. Contributing to the accident was the degraded brake system on the airplane.NTSB CEN23LA417Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28RT-201 · Chesterfield, MOThe partial retraction of the right main and nose landing gear during landing rollout for undetermined reasons.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 CEN22LA392Accident · No injuriesClass 3 · LimitedFinal reportMooney M20C · Farmington, MOThe collapse of the landing gear during landing for undetermined reasons.NTSB CEN22LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Cassville, MOThe pilot’s failure to reinstall the nose landing gear linkage prior to the flight which resulted in a loss of directional control during landing.NTSB CEN21LA453Accident · No injuriesClass 4 · LimitedFinal reportBeech M35 · Osage Beach, MOThe pilot and flight instructor’s failure to ensure that the landing gear were extended prior to landing.NTSB CEN21LA137Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46R-350T · Kansas City, MOThe loss of directional control during landing for reasons that could not be determined.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 CEN20LA084Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · St Louis, MOThe pilot’s loss of directional control and the subsequent nose landing gear collapse of for undetermined reasons.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 CEN19TA333Accident · No injuriesClass 3Final reportLancair Lancair 320 · Bolivar, MOInadequate maintenance of the airplane, which resulted in a lack of adequate hydraulic fluid, malfunction of the landing gear extension system, and the landing gear collapse on landing.NTSB GAA19CA231Accident · No injuriesData collectionFinal reportBeech 76 · St Charles, MOThe pilot receiving instruction's failure to extend the landing gear. Contributing to the accident were the pilot receiving instruction's failure to complete the landing checklist and the flight instructor's inadequate monitoring of the pilot.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 CEN18LA128Accident · No injuriesLimited investigationFinal reportCessna 310R · Kansas City, MOThe landing gear collapse due to the separation of the end fitting bolt for reasons that could not be determined based on the available evidence.NTSB CEN17LA280Accident · No injuriesLimited investigationFinal reportStinson 108 · Lee's Summit, MOThe pilot’s loss of directional control during landing due to the failure of the right brake seal.NTSB CEN16LA354Accident · No injuriesLimited investigationFinal reportNorth American Navion · Monett, MOMaintenance personnel’s failure to properly rig the right main landing gear locking mechanism, which resulted in a gear collapse during landing.NTSB GAA16CA350Accident · No injuriesData collectionFinal reportPiper PA 24 · Springfield, MOThe pilot's failure to ensure that the landing gear was in the down and locked position prior to touchdown.NTSB CEN16LA187Accident · No injuriesLimited investigationFinal reportBeech B100 · Dexter, MOA collapse of the right main landing gear for reasons that could not be determined because of the damage to the landing gear system.NTSB CEN16LA100Accident · No injuriesLimited investigationFinal reportMaule M 7-235C · Macon, MOThe failure of the right main landing gear assembly for reasons that could not be determined based on the available information.NTSB CEN15LA116Accident · No injuriesLimited investigationFinal reportCessna 210 · Sullivan, MOThe loss of hydraulic fluid and subsequent pressure due to cracks in the right main landing gear (MLG) actuator, which resulted in the collapse of the MLG during landing.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 CEN12LA353Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Chesterfield, MOThe undercharged and overcharged landing gear dampers, which allowed initiation of the ground resonance event from which the pilot was unable to recover due to his limited experience in helicopters. Contributing to the accident was the ineffective damper…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 CEN11LA494Accident · No injuriesLimited investigationFinal reportCessna T210L · Columbia, MOThe collapse of the right main landing gear during landing due to a lack of component lubrication, which resulted in the failure of the landing gear to lock once extended.NTSB CEN11LA281Accident · No injuriesLimited investigationFinal reportReeves Avid Mark IV · Brookfield, MOThe pilot’s failure to maintain directional control during landing, which resulted in the airplane departing the runway.NTSB CEN11CA277Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Kansas City, MOThe pilot's failure to extend the landing gear for a landing.NTSB CEN11CA203Accident · No injuriesData collectionFinal reportCessna 195A · Hannibal, MOThe pilot's inability to maintain control during landing due to seized main landing gear wheels, which caused the airplane to nose over.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 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 CEN09CA493Accident · Minor injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Cape Girardeau, MOThe airplane's inoperative brakes while taxiing. Contributing to the accident was the pilot's inadequate preflight.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 CEN09CA356Accident · No injuriesData collectionFinal reportBeech A36 · Charleston, MOThe pilot's inadvertent use of the landing gear selector handle instead of the flap handle during landing rollout, which resulted in the collapse of the nose landing gear.NTSB DEN08LA159Accident · No injuriesLimited investigationFinal reportCessna 172RG · St. Louis, MOThe improper maintenance performed resulting in a jammed nose landing gear door preventing the extension of the nose landing gear.NTSB DFW08CA219Accident · No injuriesData collectionFinal reportPiper PA46-500TP · St. Louis, MOThe pilot's failure to ensure that the landing gear was placed in the down position prior to landing.