NTSB investigations, MO
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 WPR22FA184Accident · 1 fatalClass 3 · FieldFinal reportBruce R Prouse M24 Orion Plus · Cape Girardeau, MOThe pilot’s failure to maintain controlled flight, which resulted in a hard left roll, excessive blade flapping and a subsequent in-flight separation of the right horizontal stabilizer.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 CEN22LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Moberly, MOThe student pilot's improper landing flare, which resulted in a bounced hard landing.NTSB CEN22LA116Accident · Serious injuriesClass 4 · LimitedFinal reportBeech C35 · Shell Knob, MOThe pilot’s failure to maintain airplane control that resulted in an aerodynamic stall during approach and impact with terrain.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 CEN22LA087Accident · 1 fatalClass 3 · LimitedFinal reportJ&J Ultralights Seawing · Golden, MOThe noncertificated pilot’s failure to maintain aircraft control while aggressively maneuvering at low altitude.NTSB CEN22LA063Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · St. Louis, MOThe pilot’s failure to apply power during the recovery procedure for the practice autorotation, which resulted in a hard landing.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 CEN22LA001Accident · 2 fatalClass 3 · LimitedFinal reportTandem Air-Bike · Warrensburg, MOThe improper judgment of both pilots to attempt a flight while impaired by drugs/medications and their failure to maintain control of the aircraft, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN21LA446Accident · Serious injuriesClass 4 · LimitedFinal reportCole Paul B Challenger I · Higginsville, MOThe non-certificated pilot's exceedance of the airplane's critical angle of attack during a low-level turn, which resulted in an aerodynamic stall.NTSB CEN21LA453Accident · No injuriesClass 4 · LimitedFinal reportBeech M35 · Osage Beach, MOThe pilot and flight instructor’s failure to ensure that the landing gear were extended prior to landing.NTSB CEN21FA380Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Adrian, MOThe pilot’s failure to maintain control of the airplane which resulted in an aerodynamic stall and impact with terrain.NTSB CEN21LA307Accident · Serious injuriesClass 4 · LimitedFinal reportQuad City Challenger · Ste. Genevieve, MOAn impact with terrain for reasons that could not be determined based on available evidence.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 CEN21LA137Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46R-350T · Kansas City, MOThe loss of directional control during landing for reasons that could not be determined.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 CEN21LA098Accident · Serious injuriesClass 4 · LimitedFinal reportQuad City Challenger II · Waldron, MOThe pilot’s improper landing flare during the rejected takeoff that resulted in a hard landing and nose landing gear collapse.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 CEN21LA053Accident · 1 fatalClass 3 · LimitedFinal reportTrick Trikes Stss · Holden, MOThe noncertificated pilot’s failure to maintain aircraft control during takeoff.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 CEN20LA397Accident · No injuriesClass 3 · LimitedFinal reportZenith CH 750 · Montgomery City, MOThe pilot’s inadequate fuel management and flight planning, which led to a total loss of engine power due to fuel exhaustion and a forced landing into rough terrain.NTSB CEN20CA362Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Lebanon, MOThe pilot's failure to maintain directional control during landing.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 CEN20LA336Accident · 2 fatalClass 3 · LimitedFinal reportCirrus SR22 · Osage Beach, MOAn in-flight fire and subsequent loss of airplane control shortly after takeoff. The source of the in-flight fire or the reason for the loss of airplane control could not be determined based on the available information.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 CEN20CA320Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna A188 · Memphis, MOThe pilot did not remove the rudder gust lock during the preflight inspection, which resulted in a forced landing and collision with a tree.NTSB CEN20LA288Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Independence, MOFailure of the No. 5 piston head and ring, which resulted in a total loss of engine power and the pilot’s decision to takeoff with a known mechanical issue.NTSB CEN20CA241Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Bowling Green, MOThe pilot's improper flare, which resulted in a hard, bounced landing.NTSB CEN20LA203Accident · Minor injuriesClass 3 · LimitedFinal reportMagni Magni M 16 · Cape Girardeau, MOThe student pilot’s decision to take off with inadequate runway remaining, and his subsequent failure to attain proper airspeed, which resulted in the gyroplane’s descent into terrain.NTSB CEN20LA189Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Steele, MOThe loss of oil pressure for a reason that could not be determined leading to failure of the engine connecting rod.NTSB CEN20CA184Accident · No injuriesClass 4 · Data collectionFinal reportRhoads, Larry E Sopwith Baby · Lee's Summit, MOThe airplane builder's improper installation of the lower right wing which resulted in an uncommanded left roll and the subsequent loss of control.NTSB CEN20LA149Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Kirksville, MOA loss of engine power after takeoff for undetermined reasons.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 CEN20LA095Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Chesterfield, MOThe flight instructor’s and student pilot’s failure to ensure that the landing gear was extended before landing.NTSB CEN20LA084Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · St Louis, MOThe pilot’s loss of directional control and the subsequent nose landing gear collapse of for undetermined reasons.NTSB CEN20CA062Accident · No injuriesData collectionFinal reportBeech 76 · St. Charles, MOThe pilot receiving instruction’s misunderstanding of the flight instructor’s instruction and the pilot's and the instructor’s insufficient use of rudder while adding power to the operating engine, which resulted in the airplane rolling left and the wing…NTSB DCA20CA050Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 737 · Kansas City, MOa bird strike during descentNTSB ERA20LA050Accident · Minor injuriesClass 3 · LimitedFinal reportZenith Zodiac CH-650 · Willow Springs, MOImproper maintenance practices on the fuel system causing fuel starvation and a total loss of engine power.NTSB GAA20CA072Accident · No injuriesData collectionFinal reportCessna U206 · Mexico, MOThe pilot's failure to properly set the parking brake before exiting an operating airplane, which resulted in a runaway airplane and subsequent impact with trees.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 CEN19TA333Accident · No injuriesClass 3Final reportLancair Lancair 320 · Bolivar, MOInadequate maintenance of the airplane, which resulted in a lack of adequate hydraulic fluid, malfunction of the landing gear extension system, and the landing gear collapse on landing.NTSB GAA19CA549Accident · No injuriesData collectionFinal reportCessna L19 · Kennett, MOThe pilot's failure to install the engine oil filler cap before the first flight of the day; his subsequent failure to conduct a preflight check before the accident flight, which resulted in his failure to note that the cap was not installed; and his improper…