Final NTSB investigations, MO
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 1 |
|---|---|
| 1963 | 1 |
| 1964 | 118 |
| 1965 | 136 |
| 1966 | 155 |
| 1967 | 173 |
| 1968 | 100 |
| 1969 | 83 |
| 1970 | 111 |
| 1971 | 112 |
| 1972 | 80 |
| 1973 | 80 |
| 1974 | 80 |
| 1975 | 98 |
| 1976 | 101 |
| 1977 | 96 |
| 1978 | 111 |
| 1979 | 100 |
| 1980 | 85 |
| 1981 | 95 |
| 1982 | 86 |
| 1983 | 84 |
| 1984 | 74 |
| 1985 | 72 |
| 1986 | 54 |
| 1987 | 59 |
| 1988 | 67 |
| 1989 | 47 |
| 1990 | 41 |
| 1991 | 37 |
| 1992 | 40 |
| 1993 | 58 |
| 1994 | 47 |
| 1995 | 39 |
| 1996 | 28 |
| 1997 | 33 |
| 1998 | 29 |
| 1999 | 43 |
| 2000 | 31 |
| 2001 | 33 |
| 2002 | 30 |
| 2003 | 30 |
| 2004 | 32 |
| 2005 | 31 |
| 2006 | 27 |
| 2007 | 31 |
| 2008 | 31 |
| 2009 | 23 |
| 2010 | 23 |
| 2011 | 32 |
| 2012 | 33 |
| 2013 | 21 |
| 2014 | 19 |
| 2015 | 31 |
| 2016 | 29 |
| 2017 | 28 |
| 2018 | 22 |
| 2019 | 20 |
| 2020 | 24 |
| 2021 | 15 |
| 2022 | 19 |
| 2023 | 25 |
| 2024 | 22 |
| 2025 | 10 |
| 2026 | 4 |
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.\"completionStatus\" = 'Completed'
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."completionStatus" = 'Completed' 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 WPR26LA229Accident · Minor injuriesClass 4 · LimitedFinal reportRyan Navion · Bismarck, MOThe pilot’s failure to remove the maintenance spacer before takeoff, which resulted in restricted flight control movement and a loss of control.NTSB CEN26LA180Accident · Serious injuriesClass 4 · LimitedFinal reportJust JA-30 · Hartville, MOThe pilot’s failure to maintain clearance from a power line after takeoff.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 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 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 CEN25FA307Accident · 2 fatalClass 3 · FieldFinal reportHughes 369D · West Alton, MOThe pilot’s failure to maintain helicopter clearance from the powerline during the powerline maintenance operation for reasons that could not be determined.NTSB CEN25LA276Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-402A · Centralia, MOThe pilot’s failure to maintain clearance from power lines during low-level maneuvering.NTSB CEN25LA252Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 35 · Cedarcreek, MOThe student pilot’s failure to attain a proper airspeed and climb attitude during takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident were the student pilot’s lack of…NTSB CEN25LA223Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Unionville, MOThe pilot’s failure to maintain airplane control during a go-around.NTSB CEN25LA219Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Charleston, MOThe pilot’s loss of control during the spray pass, which resulted in impact with vegetation and terrain.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 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 CEN25LA062Accident · Minor injuriesClass 4 · LimitedFinal reportCapella FW1C50 · Ozark, MOThe pilot’s failure to maintain aircraft control during high-speed taxi.NTSB CEN25LA049Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Camdenton, MOThe pilot’s poor flight planning which resulted in a loss of engine power due to fuel exhaustion.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 CEN24LA333Accident · Minor injuriesClass 3 · LimitedFinal reportZenith Zodiac CH601 XL · Odessa, MOOverheating of the engine coolant for reasons that could not be determined, which resulted in a precautionary off-airport landing, during which the airplane sustained substantial damage.NTSB CEN24LA334Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Shell Knob, MOThe pilot’s failure to maintain aircraft control and airspeed during final approach, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB DCA24LA254Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Linneus, MOAn inadvertent encounter with convectively induced turbulence during cruise.NTSB CEN24LA281Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver GT-400 · Mansfield, MOThe pilot’s failure to maintain control after takeoff, which resulted in an aerodynamic stall.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 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 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 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 CEN24FA220Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Broseley, MOThe pilot’s inflight loss of airplane control for reasons that could not be determined.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 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 CEN24LA155Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-301 · Sullivan, MOA bearing failure that resulted in fatigue failure of the crankshaft and a subsequent total loss of engine power.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 CEN24LA077Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Washington, MOFuel starvation and a total loss of engine power due to an obstructed fuel vapor return path. Contributing to the accident was the pilot’s inadvertent aerodynamic stall/spin, which likely increased the severity of the ground impact.NTSB DCA24LA051Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737 · St. Louis, MOA bird strike during climbout.NTSB CEN24LA039Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Ozark, MOA reported total loss of engine power for undetermined reasons.NTSB CEN24LA008Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Warrenton, MOThe pilot’s failure to maintain directional control during the touch-and-go landing. Contributing was the pilot’s decision to land with a quartering tailwind.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 CEN23LA411Accident · Serious injuriesClass 4 · LimitedFinal reportRans S6 · LIberty, MOThe inflight fire and impact with terrain for reasons that could not be determined due to extensive fire damage.NTSB CEN23LA415Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Moberly, MOThe flight instructor’s inadequate fuel management that resulted in fuel starvation and a total loss of engine power during an approach for landing.NTSB CEN23LA414Accident · Minor injuriesClass 4 · LimitedFinal reportBuckeye Dream Machine · Fortuna, MOThe non-certificated pilot’s failure to maintain the unregistered powered parachute’s clearance from power lines.NTSB CEN23LA399Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-B33 · Ava, MOA loss of engine oil due for undetermined reasons, which resulted in failed connecting rods and total loss of engine power.NTSB CEN23LA383Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12A · Mosby, MOThe pilot’s failure to maintain adequate rotor rpm which resulted in a loss of control and impact with terrain.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 CEN23FA353Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802 · Gilman City, MOThe pilot's exceedance of the airplane's critical angle of attack and failure to maintain adequate airspeed during a steep turn, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB CEN23FA314Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-31P · Kearney, MOThe pilot’s decision to operate an airplane with known fuel leaks, his failure to conduct an engine run-up before takeoff, his subsequent failure to abort the takeoff, and the mechanic’s inadequate maintenance, which resulted in a partial loss of right engine…NTSB CEN23FA304Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Osage Beach, MOThe pilot’s failure to properly set the stabilator trim before takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.