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 CEN13CA575Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Mariner · Lee's Summit, MOThe student pilot's improper flare while performing an autorotation and the flight instructor's delayed remedial action to correct the high sink rate, which resulted in a hard landing.NTSB CEN13FA456Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Chesterfield, MOThe pilot’s failure to establish and maintain a positive climb rate during the initial climb in night instrument meteorological conditions.NTSB CEN13LA520Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Boonville, MOThe pilot’s failure to maintain directional control of the airplane during landing on a gravel road.NTSB CEN13CA386Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Climax Springs, MOThe pilot’s inadequate planning and poor decision to attempt to take off on a runway from which the airplane could not obtain flight.NTSB CEN13LA396Accident · No injuriesLimited investigationFinal reportBell 47D1 · Lake Ozark, MOThe improper rebuild and maintenance of the helicopter and inadequate subsequent inspections, which resulted in undetected fuel contamination and a subsequent total loss of engine power during cruise flight.NTSB CEN13LA379Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Salisbury, MOThe airplane's reduced braking efficiency and the pilot's subsequent delayed decision to go around, which resulted in a loss of directional control.NTSB CEN13LA339Accident · Serious injuriesLimited investigationFinal reportYoungs William D T211 · Festus, MOFuel exhaustion due to the pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power.NTSB CEN13LA378Accident · No injuriesLimited investigationFinal reportBell 206B · St Louis, MOThe loss of engine power due to the separation of compressor blades, which resulted from fatigue cracking.NTSB CEN13FA295Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 II · Cross Timbers, MOThe pilot's failure to see and avoid a power line during the low-altitude flight.NTSB CEN13CA281Accident · No injuriesData collectionFinal reportHughes 369D · Camdenton, MOThe piece of wood/tree that contacted the main rotor blade during the low altitude tree-trimming flight.NTSB CEN13FA259Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Lamar, MOThe pilot's in-flight loss of control, which was likely due to a sudden cardiac event.NTSB CEN13CA268Accident · Minor injuriesData collectionFinal reportHook Zodiac CH-650 · Gainesville, MOThe pilot misjudged the landing approach, which resulted in the airplane hitting a tree.NTSB CEN13LA252Accident · No injuriesLimited investigationFinal reportCessna P210N · Saint Louis, MOThe pilot's failure to extend the landing gear or check that it was in the down position before landing.NTSB CEN13LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Bowling Green, MOThe failure of the engine supercharger's rear bearing, which resulted in the loss of engine power.NTSB CEN13LA091Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Halfway, MOThe pilot's failure to properly maintain the airplane and engine, which resulted in a total loss of engine power due to improperly installed magnetos and a broken camshaft.NTSB CEN13CA077Accident · No injuriesData collectionFinal reportChristen Industries Pitts S-2S · Grain Valley, MOThe pilot's improper landing flare, which led to a bounced landing and subsequent loss of control.NTSB CEN13FA044Accident · 2 fatalField investigationFinal reportCessna 310 · Stotts City, MOThe pilot's failure to maintain airplane control after he shut down the right engine in flight due a loss of oil pressure. Contributing to the accident was the pilot's decision to reposition the unairworthy airplane during twilight after extensive maintenance…NTSB CEN13FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Maryland Heights, MOThe pilot’s failure to activate the carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a loss of engine power due to carburetor ice.NTSB CEN12LA645Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Branson, MOThe pilot's failure to maintain airplane control during an attempted go-around in dark night conditions.NTSB CEN12LA636Accident · 1 fatalLimited investigationFinal reportJDT Mini-Max 1500R · Cameron, MOThe pilot's failure to maintain adequate airspeed during initial climb, which resulted in an aerodynamic stall and spin at a low altitude.NTSB CEN12FA633Accident · 5 fatalField investigationFinal reportCirrus Design SR22 · Willard, MOThe pilot's loss of airplane control as a result of spatial disorientation experienced in night instrument meteorological conditions.NTSB CEN12CA656Accident · Minor injuriesData collectionFinal reportFairchild PT-19A · Cape Girardeau, MOThe pilot’s failure to maintain sufficient airspeed during a low approach, which resulted in an aerodynamic stall.NTSB CEN12LA630Accident · No injuriesLimited investigationFinal reportHalderman, Floyd G. RV-6A · Eldon, MOThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB CEN12LA622Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Jasper, MOThe total loss of engine power due to separation of a carburetor air box support bracket and subsequent airflow obstruction to the carburetor.NTSB CEN12IA592Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE Jetstream 3101 · Kansas City, MOThe flight crew’s failure to ensure that the cargo door was properly fastened before departure.NTSB CEN12FA586Accident · 2 fatalField investigationFinal reportPiper PA-23-150 · Canton, MOThe pilot's improper decision to attempt to execute a forced landing to an open field with obstacles. Contributing to the accident was the left engine’s total loss of power due to fuel starvation as a result of the introduction of air into the fuel system…NTSB CEN12LA583Accident · No injuriesLimited investigationFinal reportCessna 150M · Arrow Rock, MOThe pilot's inadequate fuel management and in-flight decision making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN12LA642Accident · No injuriesLimited investigationFinal reportAeropro CZ A240 · Greenfield, MOThe pilot's failure to attain a proper takeoff speed or pitch attitude during takeoff, which resulted in the airplane settling on the runway and impacting trees.NTSB CEN12CA555Accident · Minor injuriesData collectionFinal reportBrown Mitch Challenger II · Dexter, MOThe operation of an airplane by a noncertificated pilot and his failure to maintain clearance from power lines during low-level flight.NTSB CEN12LA637Accident · No injuriesLimited investigationFinal reportSackman Sackman Special · Ste. Genevieve, MOThe loss of engine power during a low level maneuver due to oil starvation for reasons that could not be determined during postaccident examination.NTSB CEN12CA613Accident · No injuriesData collectionFinal reportBeech A36 · Washington, MOThe pilot raised the landing gear handle instead of the flap handle during a touch-and-go landing, resulting in the collapse of the nose landing gear while accelerating to takeoff.NTSB CEN12LA512Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bragg City, MOThe pilot's failure to properly tighten the b-nut from the engine-driven fuel pump to the fuel-metering unit during maintenance, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN12CA450Accident · No injuriesData collectionFinal reportCessna 195B · Camdenton, MOThe pilot's loss of directional control on landing, which resulted in a runway excursion.NTSB CEN12LA440Accident · 1 fatalLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Darksville, MOThe pilot did not maintain clearance from a tree line at the completion of an agricultural spray run.NTSB CEN12CA391Accident · No injuriesData collectionFinal reportLuscombe 8A · Mexico, MOThe airplane's encounter with a downdraft during the landing flare, which resulted in a hard landing.NTSB CEN12CA399Accident · No injuriesData collectionFinal reportEdson Robert W Pietenpol AIR Camper · Point Lookout, MOThe pilot's failure to maintain directional control during landing, resulting in a ground-loop.NTSB CEN12IA383Incident · No injuriesIncident investigationFinal reportCessna 560 · Ozark, MOThe airplane’s collision with a deer during the landing roll.NTSB CEN12LA362Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Mt. Vernon, MOThe pilot’s decision to continue the landing on a short grass runway with a tailwind after touching down beyond the touchdown point, and his subsequent failure to stop the airplane before colliding with trees off the end of that runway. Contributing to the…NTSB CEN12CA361Accident · No injuriesData collectionFinal reportCessna 172H · Moscow Mills, MOThe pilot's failure to maintain control of the airplane during takeoff in a gusty crosswind, which resulted in a runway excursion.NTSB CEN12LA353Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Chesterfield, MOThe undercharged and overcharged landing gear dampers, which allowed initiation of the ground resonance event from which the pilot was unable to recover due to his limited experience in helicopters. Contributing to the accident was the ineffective damper…NTSB CEN12CA279Accident · No injuriesData collectionFinal reportBalloon Works Firefly 7-15 · Hallsville, MOThe pilot’s failure to maintain clearance from power lines during landing.NTSB CEN12CA293Accident · No injuriesData collectionFinal reportCessna 152 · Lee's Summit, MOThe student pilot’s loss of directional control while landing.NTSB CEN12FA188Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Mexico, MOThe pilot’s failure to maintain airplane control during takeoff, which resulted in an aerodynamic stall and subsequent collision with trees. Contributing to the accident was the pilot’s inadequate preflight performance planning before departing on the soft,…NTSB CEN12CA193Accident · No injuriesData collectionFinal reportBellanca 17-30A · Branson, MOThe pilot did not maintain directional control of the airplane while landing with a gusting crosswind.NTSB CEN12LA187Accident · 1 fatalLimited investigationFinal reportBrice Ron Glastar Sportsman 2+ · Kimberling, MOThe pilot’s inadequate flare, which resulted in the airplane impacting into the water.NTSB CEN12FA158Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Osborn, MOThe pilot’s decision to conduct low-level passes above a residence and his failure to maintain sufficient altitude.NTSB CEN12LA147Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Kansas City, MOThe failure of the nosewheel steering pushrod, which resulted in a loss of airplane directional control and runway excursion.NTSB CEN12LA114Accident · Serious injuriesLimited investigationFinal reportSouthern Powered Parachute Condor · Rogersville, MOThe pilot's inadequate preflight inspection of the takeoff area, which resulted in a loss of control due to the binding of the parachute's lines.NTSB CEN12LA102Accident · No injuriesLimited investigationFinal reportShook Rans S-12 · Festus, MOThe certified flight instructor’s delayed remedial action as the airplane neared an aerodynamic stall/spin. Contributing to the accident was that the student pilot did not maintain adequate airspeed during the go-around attempt.NTSB CEN12CA089Accident · No injuriesData collectionFinal reportCessna 182L · Branson, MOThe pilot's improper landing flare and inadequate recovery from a bounced landing.