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, newest first
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' 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' 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 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.NTSB CEN23LA296Accident · Minor injuriesClass 3 · LimitedFinal reportMagni M24 · Mineral Point, MOThe inflight loss of the engine’s air filter which collided with the propeller which resulted in a vibration.NTSB CEN23LA294Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Lsa S R L Alpha Trainer · Lee's Summit, MOAn engine fire after landing for reasons that could not be determined.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 CEN23LA261Accident · No injuriesClass 3 · LimitedFinal reportQuad City Challenger · Cedar Creek, MOA seizure of the power takeoff piston due to inadequate maintenance to the lubrication system, which resulted in a lack of oil lubrication and subsequent engine failure.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 CEN23LA221Accident · No injuriesClass 3 · LimitedFinal reportQuad City Challenger · Doniphan, MOA partial loss of engine power for undetermined reasons.NTSB CEN23LA196Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Kansas City, MOThe student pilot's failure to maintain directional control during takeoff.NTSB WPR23LA158Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18A 150 · Garrison, MOThe pilot’s inadequate fuel planning which resulted in fuel starvation, a loss of engine power and a subsequent impact with terrain.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 CEN23LA061Accident · Minor injuriesClass 3 · LimitedFinal reportOrlican S R O M-8 Eagle · St. Louis, MOThe pilot’s failure to maintain adequate airspeed/angle-of-attack during the landing approach, which resulted in an aerodynamic stall and hard landing.NTSB CEN23LA041Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Saint Joseph, MOThe pilot lost control of the airplane while on the ground due to temporary incapacitation.NTSB CEN22LA412Accident · Serious injuriesClass 3 · LimitedFinal reportZenith 750 · Silex, MOThe pilot’s failure to maintain clearance from the powerlines during takeoff.NTSB CEN22LA394Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Liberty, MOThe flight instructor’s improper decision to take off without adequate airspeed which resulted in degraded performance and a collision with trees.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 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 CEN22LA392Accident · No injuriesClass 3 · LimitedFinal reportMooney M20C · Farmington, MOThe collapse of the landing gear during landing for undetermined reasons.NTSB CEN22LA360Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Neosho, MOThe pilot’s inadvertent application of the right brake and subsequent loss of airplane directional control, which resulted in a taxiway excursion and impact with trees.NTSB CEN22LA330Accident · No injuriesClass 3 · LimitedFinal reportBeech N35 · Wardsville, MOEngine failure due to oil starvation resulting from an oil leak at the improperly installed aftermarket oil filter adapter.NTSB CEN22LA324Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Grain Valley, MOThe loss of engine power due to fuel exhaustion.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 CEN22FA223Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7AC · Bowling Green, MOThe pilots’ failure to maintain adequate airspeed while maneuvering, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.