NTSB investigations, MO
177 cases where NTSB found Environmental issues.
Cases per year
| 2008 | 16 |
|---|---|
| 2009 | 9 |
| 2010 | 6 |
| 2011 | 8 |
| 2012 | 14 |
| 2013 | 9 |
| 2014 | 9 |
| 2015 | 15 |
| 2016 | 10 |
| 2017 | 15 |
| 2018 | 15 |
| 2019 | 7 |
| 2020 | 9 |
| 2021 | 7 |
| 2022 | 6 |
| 2023 | 6 |
| 2024 | 10 |
| 2025 | 4 |
| 2026 | 2 |
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\", '03'))
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", '03')) 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 CEN26LA180Accident · Serious injuriesClass 4 · LimitedFinal reportJust JA-30 · Hartville, MOThe pilot’s failure to maintain clearance from a power line after takeoff.NTSB CEN26LA101Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Sullivan, MOThe pilot’s failure to maintain clearance from powerlines during low-level operations.NTSB CEN26LA039Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Pineville, MOThe change in wind direction during landing, which resulted in a tailwind condition and runway overrun.NTSB CEN26LA027Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 · Springfield, MOThe pilot’s failure to maintain directional control and the flight instructor’s lack of proper remedial action during the practice autorotation that resulted in the helicopter impacting terrain. Contributing to the accident was the presence of the gusting…NTSB CEN25LA180Accident · No injuriesClass 4 · LimitedFinal reportExcalibur Excalibur · Mountain View Airport, MOAn in-flight collision with a bird while enroute.NTSB CEN25LA098Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopters 369FF · Cookville, MOThe pilot’s failure to maintain adequate clearance from a tree during the low altitude operation.NTSB DCA25LA041Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757-231 · Cooper Hill, MOAn encounter with convective induced turbulence which resulted in a flight attendant serious injury.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 CEN25LA011Accident · Serious injuriesClass 4 · LimitedFinal reportPowrachute SKY Rascal · Peculiar, MOThe failure of the pilot to use appropriate engine power during descent in turbulent air which resulted in a loss of control.NTSB DCA24LA254Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Linneus, MOAn inadvertent encounter with convectively induced turbulence during cruise.NTSB CEN24LA252Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · New Florence, MOThe pilot’s failure to maintain proper altitude/clearance from a dead tree limb during an aerial application flight.NTSB CEN24LA241Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Andover, MOThe pilot’s inability to maintain altitude and airspeed during cruise flight likely due to a decrease in engine performance associated with the unauthorized use of automobile fuel, which led to an inflight collision with a tree and hard landing.NTSB CEN24LA205Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Palmyra, MOThe pilot’s failure to maintain clearance from power lines during approach.NTSB CEN24LA197Accident · Serious injuriesClass 4 · LimitedFinal reportCessna U206 · Butler, MOThe jumper’s unintentional deployment of his emergency parachute and subsequent impact with the airplane’s horizontal stabilizer.NTSB CEN24FA160Accident · 1 fatalClass 3 · FieldFinal reportPiper PA 46-350P · Hartsburg, MOThe pilot’s encounter with convective weather conditions, which resulted in a loss of airplane control, the exceedance of the airplane’s never exceed speed, and the resulting overload failure of the horizontal stabilizer and subsequent failure of the…NTSB CEN24LA084Accident · Serious injuriesClass 4 · LimitedFinal reportSlipStream International Genesis · Buffalo, MOThe student pilot’s failure to maintain control of the airplane during the crosswind landing, which resulted in the airplane drifting off the left side of the runway and into trees.NTSB DCA24LA051Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737 · St. Louis, MOA bird strike during climbout.NTSB CEN23LA280Accident · Serious injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Amity, MOThe pilot’s failure to see and avoid wires while conducting a low-level aerial application flight.NTSB CEN23LA260Accident · No injuriesClass 4 · LimitedFinal reportSharp Glennis Escapade · Bolivar, MOThe pilot’s failure to maintain aircraft control during a soft-field takeoff after encountering a wind gust.NTSB CEN23LA242Accident · Minor injuriesClass 4 · LimitedFinal reportTipton Kitfox Kitfox IV · Odessa, MOThe pilot’s failure to attain the proper touchdown speed, which resulted in a runway excursion and subsequent nose over.NTSB WPR23LA218Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A188B · Chillicothe, MOA partial loss of engine power due to a tear in the fuel manifold diaphragm, which prevented sufficient fuel flow to the engine.NTSB CEN23LA143Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Hillsboro, MOThe pilot’s failure to maintain clearance from trees during final approach to landing.NTSB CEN22LA412Accident · Serious injuriesClass 3 · LimitedFinal reportZenith 750 · Silex, MOThe pilot’s failure to maintain clearance from the powerlines during takeoff.NTSB CEN22LA350Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Marshall, MOThe pilot’s failure to adequately survey a field for obstructions prior to a low-level aerial application pass, which resulted in an impact with a powerline.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 DCA22LA125Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A320-232 · Springfield, MOThe flight’s encounter with clear air moderate turbulence.NTSB CEN22LA200Accident · Minor injuriesClass 4 · LimitedFinal reportThrush S2R-H80 · Aurora, MOThe pilot did not ensure clearance from a power line during a surveillance pass of a field to be sprayed.NTSB CEN22FA096Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Defiance, MOThe pilot’s loss of airplane control while flying in night instrument conditions due to spatial disorientation and the flight crew’s inability to recover from an unusual airplane attitude.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 CEN22LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Chesterfield, MOThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard, bounced landing and the nose landing gear collapsing. .NTSB CEN22LA006Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Delta, MOThe pilot’s inadequate inflight planning and his failure to see and avoid a wire which resulted in contact with the wire and subsequent ground impact.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 CEN21LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Poplar Bluff, MOThe pilot’s decision to make a precautionary landing in a field that contained soft terrain, which resulted in the airplane nosing over. Contributing to the accident was the pilot’s decision to fly without a printed VFR sectional chart to identify the…NTSB CEN21FA125Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Galt, MOThe pilot’s decision to takeoff into instrument meteorological conditions consisting of low ceilings and icing and his failure to remain clear of terrain while attempting to remain below the clouds, which resulted in impact with terrain.NTSB CEN21LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna T182T · Hollister, MOThe pilot’s failure to maintain proper airspeed control during an instrument approach in instrument meteorological conditions, which led to a bounced landing, collapsing the nose landing gear, and resulting in substantial damage.NTSB CEN21LA014Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA32R · Kimberling City, MOThe pilot’s inadequate preflight inspection, which resulted in his inadvertent departure with the tow bar connected to the nose wheel, and the low approach while returning to the airport, which allowed the tow bar to contact trees.NTSB CEN20LA429Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Higginsville, MOThe airplane’s collision with a deer on the runway during takeoff at night.NTSB CEN20LA412Accident · No injuriesClass 3 · LimitedFinal reportZenith CH 750 · Montrose, MOA total loss of engine power due to an electrical overload in the engine control unit wiring system; the electrical overload occurred as a result of improper installation by the airplane builder.NTSB CEN20LA360Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · St Louis, MOA total loss of engine power due to improper maintenance of the mixture control cable and attachment hardware, which led to a forced landing into a congested area.NTSB CEN20CA326Accident · No injuriesClass 4 · Data collectionFinal reportHughes 369A · St Louis, MOThe flight instructor's failure to maintain helicopter control which resulted in a hard landing while preforming a practice autorotation.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 CEN20LA113Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Clark, MOThe fatigue failure of the pneumatic line for reasons that could not be determined, which resulted in a loss of engine power and subsequent hard landing.NTSB CEN20LA107Accident · No injuriesClass 3 · LimitedFinal reportZenith CH601 · Cabool, MOThe loss of engine power due to failure of the No. 1 cylinder piston for reasons that could not be determined based on available evidence.NTSB CEN20FA003Accident · 1 fatalClass 3 · FieldFinal reportLancair Legacy · Bixby, MOThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB GAA19CA451Accident · No injuriesData collectionFinal reportCessna 402 · St. Louis, MOThe airplane’s collision with a bird during short final.NTSB CEN19LA229Accident · No injuriesClass 3 · LimitedFinal reportCessna 305A · Houston, MOA total loss of engine power during initial climb due to carburetor icing, which resulted in a forced landing and impact with trees and terrain.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 GAA19CA331Accident · Minor injuriesData collectionFinal reportCessna 150 · Lee's Summit, MOThe student pilot’s exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.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.