NTSB investigations, MO
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 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 CEN15LA369Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Bolivar, MOTotal electrical failure due to a failed voltage regulator and the pilot’s failure to maintain a proper airspeed during a precautionary landing, which resulted in a loss of directional control and a runway excursion.NTSB CEN15LA361Accident · No injuriesLimited investigationFinal reportCessna 150 · Brookfield, MOThe pilot's failure to visually check the quantity of fuel in the fuel tanks in accordance with the Preflight checklist, which resulted in a loss of engine power due to fuel exhaustion and the subsequent forced landing.NTSB GAA15CA201Accident · No injuriesData collectionFinal reportAeronca 7BCM · Warsaw, MOThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and a collision with terrain.NTSB CEN15FA282Accident · 1 fatalField investigationFinal reportChristen Industries Pitts S-2B · Cameron, MOThe pilot’s failure to maintain airplane control during a low-level aerobatic flight maneuver.NTSB GAA15CA166Accident · No injuriesData collectionFinal reportBryan Jerry R CH750 · Gainesville, MOThe pilot's perception that the airplane was not climbing normally, which precipitated an aborted landing with insufficient runway remaining to stop the airplane safely.NTSB CEN15FA268Accident · 1 fatalField investigationFinal reportPiper PA 32 · Cuba, MOThe pilot's continued flight into thunderstorm activity, which resulted in his loss of airplane control, the exceedance of the airplane's design limits, and its subsequent in-flight breakup. Contributing to the accident was the pilot's reliance on onboard…NTSB CEN15FA267Accident · 4 fatalField investigationFinal reportBeech A36 · Huggins, MOThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack, which resulted in an aerodynamic stall and loss of control.NTSB GAA15CA112Accident · No injuriesData collectionFinal reportCessna 180 · Vichey, MOThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion and collision with terrain.NTSB CEN15CA261Accident · Minor injuriesData collectionFinal reportBrewer Sportcopter Votex M · Sikeston, MOThe pilot inadvertently reducing engine power to the idle position while maneuvering at a low altitude.NTSB GAA15CA091Accident · Minor injuriesData collectionFinal reportLefever Paul M RV12 · Caledonia, MOThe pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a nose over.NTSB CEN15LA237Accident · No injuriesLimited investigationFinal reportPiper PA-22 · St. Charles, MOA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN15LA229Accident · No injuriesLimited investigationFinal reportBell 206L 3 · Chesterfield, MOThe collision of the helicopter's skid shoe with the runway centerline light during landing, which abruptly stopped the helicopter and resulted in damage to the fuselage.NTSB GAA15CA052Accident · No injuriesData collectionFinal reportArion Lightning LS-1 · West Plains, MOThe pilot's failure to maintain control while landing in gusty wind conditions.NTSB GAA15CA036Accident · No injuriesData collectionFinal reportPiper PA 22-135 · Drexel, MOThe pilot's failure to maintain airplane control while taxiing in unfavorable wind conditions.NTSB DCA15CA108Accident · No injuriesData collectionFinal reportEmbraer EMB 145LR · Springfield, MOan in-flight collision with a bird.NTSB CEN15LA172Accident · Serious injuriesLimited investigationFinal reportBeech B19 · Osage Beach, MOThe failure of the No. 4 piston wrist pin plug and the subsequent entry of its metal shavings into the oil system, which clogged the oil passages and caused the engine to seize. Contributing to the accident was the installation of engine parts that were not…NTSB CEN15LA170Accident · No injuriesLimited investigationFinal reportMaule M 7-260C · Oregon, MOEngine vibration for reasons that could not be determined based on the available evidence.NTSB CEN15FA164Accident · 1 fatalField investigationFinal reportAirbus Helicopters (Eurocopte EC-130-B4 · St Louis, MOThe pilot's decision to land during unfavorable wind conditions, which resulted in a loss of control due to settling with power. Contributing to the accident were the lack of an adequate approach path due to numerous obstructions and the lack of available…NTSB CEN15CA158Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Kansas City, MOThe loss of engine power due to fuel starvation.NTSB CEN15CA165Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Lee's Summit, MOThe pilot-receiving-instruction's excessive pitch control during takeoff, which resulted in an aerodynamic stall shortly after liftoff and the subsequent loss of control. Contributing to the accident was the flight crew's decision to have the flight…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 CEN15CA130Accident · No injuriesData collectionFinal reportCessna 310B · Rothville, MOThe pilot's inadequate preflight planning and fuel management which resulted in fuel exhaustion.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 CEN15LA077Accident · Serious injuriesLimited investigationFinal reportNew Piper PA 32R-301T · Springfield, MOThe pilot’s decision to descend below the recommended altitude during approach for landing in night visual meteorological conditions, and his failure to see and avoid a lighted tower, which resulted in collision with the tower and a subsequent total loss of…NTSB CEN15FA060Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Boonville, MOThe pilot's failure to maintain adequate airspeed during a forced landing following a total loss of engine power due to fuel starvation, which resulted in the airplane exceeding its critical angle of attack, and an aerodynamic stall at a low altitude.…NTSB CEN15LA066Accident · Minor injuriesLimited investigationFinal reportMD Helicopter MD 900 · Highlandville, MOThe pilot's inability to identify the power line during the initial approach in night visual meteorological conditions and his subsequent failure to avoid the power line once he identified it on final approach.NTSB CEN15LA050Accident · Serious injuriesLimited investigationFinal reportCessna 401A · Fulton, MOA failure of the right engine magneto distributor drive gears, which resulted in a total loss of engine power during takeoff. Contributing to the accident was the operator’s failure to inspect and maintain the magnetos in accordance with the engine…NTSB CEN15CA065Accident · Serious injuriesData collectionFinal reportHughes Aero Predator · Branson, MOThe pilot's failure to maintain aircraft control when executing a landing with a tailwind, resulting in impact with a retaining wall.NTSB CEN14CA532Accident · Minor injuriesData collectionFinal reportAirborne Edge X · Willow Springs, MOThe pilot's loss of control after the weight-shift-control aircraft encountered low-level wind shear shortly before touchdown. Also causal to the accident was the pilot's inadequate preflight weather assessment that failed to correctly determine the actual…NTSB CEN14CA459Accident · No injuriesData collectionFinal reportPiper PA 32R-301T · Sedalia, MOThe loss of engine power due to fuel starvation.NTSB CEN14LA441Accident · Serious injuriesLimited investigationFinal reportBecker Elmer L Stol CH 750 · Grain Valley, MOThe pilot’s failure to maintain airplane control during a low-speed, high-pitch climb after the airplane experienced a loss of electrical power and subsequent total loss of engine power, which resulted in an aerodynamic stall. Contributing to the accident was…NTSB CEN14CA383Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · St. Louis, MOThe pilot's decision to operate an airplane with a known deficiency and to not properly secure the airplane before hand-starting the engine.NTSB CEN14CA382Accident · Serious injuriesData collectionFinal reportGremminger Greg Magni M 16 · Cape Girardeau, MOThe pilot's failure to maintain sufficient altitude while maneuvering which led to a collision with power lines.NTSB CEN14LA333Accident · No injuriesLimited investigationFinal reportCessna 172R · Joplin, MOThe partial loss of engine power for reasons that could not be determined because an operational test run of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN14LA324Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Maryland Heights, MOThe loss of left engine power for reasons that could not be determined due to impact and fire damage.NTSB CEN14LA313Accident · Minor injuriesLimited investigationFinal reportRobinson R22 - Beta · Moscow Mills, MOThe flight instructor’s delayed remedial action to correct the student pilot’s use of an excessive descent rate during a practice autorotation, which resulted in a hard landing.NTSB CEN14CA250Accident · No injuriesData collectionFinal reportSantschi Chris A Vans RV8 · Bonne Terre, MOThe pilot's failure to maintain aircraft control on takeoff.NTSB CEN14CA223Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Liberty, MOThe pilot's failure to maintain directional control while operating in gusty wind conditions at a low altitude.NTSB CEN14LA194Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Lee's Summit, MOThe pilots’ inadequate preflight planning and fuel management, which resulted in fuel exhaustion, a loss of engine power, and a forced landing on a soft field. Contributing to the accident was the flying pilot’s improper use of flaps during the forced landing.NTSB CEN14LA120Accident · No injuriesLimited investigationFinal reportCessna 414A · Ashland, MOThe in-flight failure of both engines due to water contamination.NTSB DCA14IA037Incident · No injuriesIncident investigationFinal reportBoeing 737 7H4 · Branson, MOThe Flight crew's failure to properly identify the airport and runway of intended landing. Contributing to the incident was the flight crew's failure to comply with procedures for use of navigation information and visual cues to verify the airport and runway…NTSB CEN14LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Forsyth, MOThe pilot's improper flight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ENG14IA005Incident · No injuriesIncident investigationFinal reportBoeing 737 3H4 · St. Louis, MOThe initial damage to the fan blades was caused by the ingestion of two mallard ducks that caused one or more fan blades to fracture, striking the fan shroud, as well as other passing fan blades, producing various sized blades fragments that created a…NTSB CEN14FA042Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Kirksville, MOA loss of control due to spatial disorientation. Contributing to the accident were the private pilot's impairment due to a sedating antihistamine and both pilots' fatigue.NTSB CEN14CA040Accident · No injuriesData collectionFinal reportCessna 182Q · Braggadocio, MOThe pilot's failure to maintain directional control during landing rollout, which resulted in a runway excursion and the airplane nosing over.NTSB CEN14TA020Accident · Minor injuriesFinal reportBell OH-58A · Jefferson City, MOThe loss of engine power for reasons that could not be determined because postaccident examinations of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN14CA039Accident · Minor injuriesData collectionFinal reportWohaska John Parsons Stiles Gyro · Festus, MOThe pilot's improper propeller adjustment, which resulted in decreased performance and a loss of aircraft control.NTSB CEN13CA521Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Osage Beach, MOThe pilot’s failure to maintain aircraft control during initial climb in gusty wind conditions.NTSB CEN13FA496Accident · 2 fatalField investigationFinal reportMooney M20J · Kansas City, MOThe pilot's improper decision to attempt continued flight after a momentary loss of engine power with usable runway remaining. Contributing to the accident were the pilot's premature retraction of the landing gear, the loss of engine power due to fuel system…