NTSB investigations, MO
18 cases where the sequence of events included Sys/Comp malf/fail (non-power).
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 4 |
| 2011 | 1 |
| 2015 | 3 |
| 2017 | 2 |
| 2019 | 1 |
| 2024 | 1 |
| 2025 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '330' 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" = '330' 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 CEN26LA191Accident · Minor injuriesClass 3 · LimitedPreliminary reportVertical Hummingbird · Lee's Summit, MOOn May 16, 2026, about 0950 central daylight time, a Vertical Aviation Technologies 300L Hummingbird helicopter, N284ST, was substantially damaged when it was involved in an accident near Lee’s Summit, Missouri. One passenger sustained minor injuries. The…NTSB CEN25LA326Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Cape Girardeau, MOOn August 16, 2025, at 1150 central daylight time, a Robinson R44 II helicopter, N24DF was substantially damaged when it was involved in an accident near Cape Girardeau, Missouri. The pilot and three passengers were not injured. The helicopter was operated as…NTSB CEN25LA295Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182P · Bolivar, MOOn July 28, 2025, at about 1800 central daylight time, a Cessna 182P, N8243M, was destroyed when it was involved in an accident near Bolivar, Missouri. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB CEN24LA315Accident · No injuriesClass 3 · LimitedFinal reportGrumman American Avn. AA-5B · Camdenton, MOThe inadequate maintenance of the seat locking mechanism, which resulted in the pilot’s seat sliding back during takeoff and a subsequent loss of control.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 CEN18LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · Versailles, MOThe total loss of engine power due to fuel starvation when the cap fitting came off the inlet tee fitting on the throttle body/fuel metering unit.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 CEN15LA396Accident · No injuriesLimited investigationFinal reportBurns Mini 500 · Butler, MOThe pilot's failure to attain a proper landing flare following an autorotation for reasons that could not be determined based on available information.NTSB DCA15FA073Accident · Serious injuriesField investigationFinal reportMcdonnell Douglas MD 11F · St. Louis, MOa partial inflation of the 1L escape slide/raft due to undetermined reasons resulting in insufficient capability to support the weight of the crewmember.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 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 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 CEN09LA335Accident · No injuriesLimited investigationFinal reportCessna 140 · St. Louis, MOThe improper installation of the wing fairing during recent maintenance, which resulted in the partial separation of the fairing shortly after takeoff.NTSB CEN09LA167Accident · No injuriesLimited investigationFinal reportBeech H35 · Grain Valley, MOThe loss of engine power due to fuel starvation (mechanical). Contributing to the accident was the forced landing on unsuitable terrain.NTSB CEN09CA025Accident · Serious injuriesData collectionFinal reportHolmes William E Predator · Branson, MOThe pilot's failure to maintain directional control. Contributing to the accident was the wing's failure to open all cells for undetermined reasons and the trees near the runway.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 DFW08LA206Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7-15 · Mountain Grove, MOAn on-board fire following a propane leak. Contributing to the accident was the lack of training/experience of the non-certificated pilot.