Skip to content

NTSB investigations, MO

75 cases where the first occurrence was “Hard landing”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200)
  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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200)
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 CHI07TA015Accident · No injuriesFinal reportCessna 182R · Dexter, MOThe pilot's improper runway selection for landing and the pilot's inadequate flare. A factor was the tailwind.Oct 17, 2006 · N873MP · Substantial damage NTSB CHI07CA008Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Osage Beach, MOThe pilot's inadequate compensation for wind conditions which resulted in the hard landing. The gusting crosswind was a factor.Oct 12, 2006 · N8546P · Substantial damage NTSB CHI07CA004Accident · No injuriesData collectionFinal reportCessna 172N · St Charles, MOThe pilot's failure to properly judge the landing flare and his inadequate recovery from the resulting bounced landing. A contributing factor was the inadvertent pilot induced oscillation (porpoise) after initial runway contact.Oct 8, 2006 · N4775D · Substantial damage NTSB CHI06CA131Accident · No injuriesData collectionFinal reportSchweizer 269C · Lees Summit, MOThe flight instructor's delay in taking remedial action which led to the hard landing during the practice autorotation. The misjudged glide path, the dual student restricting the throttle control, and the trees were factors in the accident.May 12, 2006 · N7506L · Substantial damage NTSB CHI06CA003Accident · No injuriesData collectionFinal reportDallMeyer Zenith CH-701 · Rolla, MOThe pilot misjudged the power required during the landing flare which resulted in a hard landing on the nose wheel. A factor associated with the accident was the pilot's lack of experience in the airplane.Oct 10, 2005 · N701PR · Substantial damage NTSB CHI05CA132Accident · No injuriesData collectionFinal reportCessna 182F · Osage Beach, MOThe pilot's improper flare and his inadequate recovery from the bounced landing which resulted in a hard landing. A factor associated with the accident was the improper landing flare.May 30, 2005 · N3225U · Substantial damage NTSB CHI05CA133Accident · Serious injuriesData collectionFinal reportAerostar S-57A · Sparta, MOThe pilot's inability to maintain a proper descent rate due to the wind gust resulting in a hard landing. Contributing factors were the wind gust and the tree struck during the landing.May 28, 2005 · N71072 · Minor damage NTSB CHI04CA287Accident · No injuriesData collectionFinal reportCessna 182P · Washington, MOThe misjudged flare by the student pilot and the inadequate supervision by the flight instructor. A factor was the overload failure of the nose landing gear.Sep 25, 2004 · N4637K · Substantial damage NTSB CHI04CA088Accident · Minor injuriesData collectionFinal reportCessna 172A · Springfield, MOThe pilot failed to initiate a go-around and the airplane porpoised during the hard landing. Factors associated with the accident were the excessive groundspeed and the overload failure of the nose gear.Mar 21, 2004 · N7265T · Substantial damage NTSB CHI03LA062Accident · No injuriesLimited investigationFinal reportBell 206L-1 · West Plains, MOThe excessive descent rate that required an abrupt flare, resulting in the main rotor severing the tailboom.Jan 31, 2003 · N27AE · Substantial damage NTSB CHI03LA054Accident · No injuriesLimited investigationFinal reportCessna 150M · Charleston, MOthe inadequate flare by the pilot. Factors were the loose trim tab cable for undetermined reasons.Jan 12, 2003 · N66507 · Substantial damage NTSB CHI03LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cuba, MOThe pilots inadequate flare and recovery from a bounced landing. Contributing factors to this accident were the crosswind and the ditch.Nov 28, 2002 · N4901S · Substantial damage NTSB CHI02LA170Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 · Kansas City, MOThe inadequate flare by the flying pilot and the remedial action not performed by the company check airman.Jun 17, 2002 · N140NJ · Substantial damage NTSB CHI02LA012Accident · No injuriesLimited investigationFinal reportBeech 200 · Osage Beach, MOThe inadequate planning/decision and the exceeded crosswind component by the pilot. The gusts were a contributing factor.Oct 25, 2001 · N200RW · Substantial damage NTSB CHI01LA208Accident · No injuriesLimited investigationFinal reportCessna 210 · Saint Charles, MOthe inadequate flare by the pilot.Jul 10, 2001 · N9657T · Substantial damage NTSB CHI00LA005Accident · No injuriesLimited investigationFinal reportZenair CH 2000 · St. Louis, MOthe student pilot misjudged the landing flare which resulted in a hard landing. A factor associated with the accident was the student's lack of total experience.Oct 6, 1999 · N25ZA · Substantial damage NTSB CHI99TA232Accident · No injuriesFinal reportHughes OH-6A · Chesterfield, MOthe pilot-in-command's improper autorotational landing.Jul 13, 1999 · N911EP · Substantial damage NTSB CHI99LA181Accident · Minor injuriesLimited investigationFinal reportRobbins Verieze · Odessa, MOThe pilot's misjudgment of altitude during landing.Jun 10, 1999 · N83HR · Substantial damage NTSB CHI99LA025Accident · No injuriesLimited investigationFinal reportCessna 150M · Warrensburg, MOthe student pilot's inadequate flare and his failure to maintain directional control of the airplane. Factors associated with the accident were, the student's lack of total experience and the dirt bank which was contacted.Nov 5, 1998 · N704LV · Substantial damage NTSB CHI97LA305Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B-15 · Columbia, MOthe pilot's improper planning/decision. The unfavorable wind was a related factor.Aug 10, 1997 · N90755 · No damage NTSB CHI97LA182Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Willard, MOremedial action delayed by the flight instructor. A factor in this accident was the instructor's lack of recent experience in this type airplane.Jun 21, 1997 · N7506F · Substantial damage NTSB CHI97LA165Accident · No injuriesLimited investigationFinal reportCessna 182RG · Kansas City, MOthe pilot's improper flare, which resulted in a hard landing. A factor relating to the accident was the excessive airspeed.May 21, 1997 · N736YZ · Substantial damage NTSB CHI96LA356Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Chesterfield, MOimproper flare by the dual student during the landing, and delayed remedial action by the flight instructor (CFI).Sep 30, 1996 · N6008H · Substantial damage NTSB CHI96LA076Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chesterfield, MOthe pilot misjudged the flare and performed an improper recovery from a bounced landing. A factor was the inadequate ground instruction concerning recovery from a bounced landing.Jan 14, 1996 · N24311 · Destroyed NTSB CHI95LA201Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Cameron, MOThe pilot misjudged the flare and improper recovery from a bounced landing.Jun 24, 1995 · N84FB · Substantial damage NTSB CHI95LA067Accident · No injuriesLimited investigationFinal reportCessna 172N · Kansas City, MOAn improper recovery from a bounced landing. Factors associated with the accident were an improper airspeed and not attaining a proper descent rate by the pilot.Jan 15, 1995 · N75585 · Substantial damage NTSB CHI94LA142Accident · No injuriesLimited investigationFinal reportBell 47G · Springfield, MOthe pilot-in-command misjudging the autorotation and improper use of collective.Apr 27, 1994 · N46DH · Substantial damage NTSB CHI94LA133Accident · No injuriesLimited investigationFinal reportBell 47-62 · Aurora, MOThe dual students inadequate flare and the pilot in command's (flight instructor) delayed remedial action.Mar 5, 1994 · N6711D · Substantial damage NTSB CHI93LA307Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Excelsior Spgs, MOthe private pilot's failure to maintain adequate aircraft control during landing.Jul 31, 1993 · N4411V · Substantial damage NTSB CHI93LA265Accident · No injuriesLimited investigationFinal reportBeech C24R · Chesterfield, MOthe pilot's improper recovery from a bounced landing.Jul 17, 1993 · N2256L · Substantial damage NTSB CHI93LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Shell Knob, MOThe pilot's misjudging of the landing flare.Dec 5, 1992 · N4152W · Destroyed NTSB CHI92LA292Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape Girardeau, MOThe pilot's failure to recover from the bounced landing.Sep 27, 1992 · N69225 · Substantial damage NTSB CHI92LA107Accident · No injuriesLimited investigationFinal reportBeech C23 · Ozark, MOThe CFI pilot-in-command's failure to provide adequate supervision of a dual student. A factor contributing to the accident was the student pilot's failure to maintain airspeed.Mar 7, 1992 · N9183S · Substantial damage NTSB CHI91LA067Accident · No injuriesLimited investigationFinal reportBeech 200 · Vichy, MOA restricted visual outlook and go-around was not performed by the pilot. Factors related to the accident were a dark night, fog and glare, ice covered runway and whiteout conditions.Jan 12, 1991 · N200MR · Substantial damage NTSB CHI91LA056Accident · No injuriesLimited investigationFinal reportCessna 340 · Chesterfield, MOFailure of the pilot to maintain directional control during the landing roll. Factors related to the accident are a foggy windshield, misjudgement of altitude, premature landing flare, and slush on the runway.Jan 3, 1991 · N14DB · Substantial damage NTSB CHI91LA013Accident · No injuriesLimited investigationFinal reportMooney M20/231 · Stockton, MOThe pilot's failure to maintain vso (minimum controllable airspeed) in a landing configuration. An associated factor is the pilot's inadequate remedial action.Oct 19, 1990 · N1002X · Substantial damage NTSB CHI90LA245Accident · No injuriesLimited investigationFinal reportCessna 172 · Farmington, MORemedial action was not attained by the CFI. Contributing to the accident was inadequate airspeed and porpoise encountered by the dual student pilot.Aug 25, 1990 · N4347R · Substantial damage NTSB CHI90LA178Accident · No injuriesLimited investigationFinal reportCessna 182 · Rich Hill, MOInadequate landing flare by the pilot.May 27, 1990 · N71818 · Substantial damage NTSB MKC89LA195Accident · No injuriesLimited investigationFinal reportBell 47G · Ozark, MOThe failure of the dual student to properly flare during an autorotative landing resulting in a hard landing and partial failure of the right skid. The CFI also failed to properly monitor the student's actions on the flight controls.Sep 2, 1989 · N182JR · Substantial damage NTSB MKC89LA171Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Liberty, MOControl interference by the dual student as the instructor tried to recover from the student's bounced landing, and failure to maintain proper runway alignment. Contributing factors were: improper flare by the student, the crosswind, the student's…Jul 29, 1989 · N4278E · Substantial damage NTSB MKC89LA160Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Camdenton, MOAircraft control was not maintained by the pilot in command.Jul 14, 1989 · N2892A · Substantial damage NTSB MKC89LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Charles, MOAircraft control was not maintained by the pilot in command due to improper use of the flight controls in flaring the aircraft for landing and counteracting the effects of the cross-wind on the drifting aircraft.Jul 3, 1989 · N49554 · Substantial damage NTSB MKC89LA092Accident · No injuriesLimited investigationFinal reportVestal Quickie Q2 · St Joseph, MOThe pilot's improper flare and failure to maintain directional control of the aircraft. A factor related to the accident was: the pilot's lack of experience in this make and model of aircraft.Apr 18, 1989 · N14VV · Substantial damage NTSB MKC89LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Creve Coeur, MOThe student pilot said that after practicing locally and returning to the base airport, he discovered the winds to be greater than anticipated. On his third attempt to land, he bounced twice, then lost control and hit nose first on the runway. An eighty…Dec 18, 1988 · N757YE · Substantial damage NTSB MKC88LA066Accident · No injuriesLimited investigationFinal reportBeech 23 · Fulton, MOWhile attempting a crosswind landing, the acft began to porpoise and veered off the runway. The left ldg gear failed and the wheel struck the aft section of the fuselage, then the horizontal stabilator. The PIC then applied full power, became airborne and…Mar 20, 1988 · N4704J · Substantial damage NTSB MKC88LA020Accident · No injuriesLimited investigationFinal reportCessna 177 · Warrensburg, MOPIC stated she had misjudged ldg, resulting in an uncontrolled porpoise, damaging nose wheel and stabilator. She aborted ldg attempt and returned to departure airport. Considerable difficulty controlling the acft was encountered, but with outside radio…Oct 17, 1987 · N2969X · Substantial damage NTSB MKC88LA011Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Warrensburg, MOThe plt indicated that on final app, when ovr the rwy threshold, he leveled the acft off at abt 10 ft and it dropped in. Subsequent inspection revealed that all four wing spars had longitudinal cracks. The plt had recently purchased the acft and had abt 14…Oct 8, 1987 · N9967Y · Substantial damage NTSB MKC87LA081Accident · No injuriesLimited investigationFinal reportCessna 152 · Kirksville, MODrg a night landing, the plt did not get the acft flared before touchdown. Subsequently, it contacted the rwy with the nose wheel. Drg the occurrence, the nose gear, prop & eng fire wall were damaged.Apr 9, 1987 · N5515Q · Substantial damage NTSB MKC86LA095Accident · No injuriesLimited investigationFinal reportCessna 150D · Marshfield, MOThe pilot stated that the approach speed was faster than normal due to erroneous airspeed indications. The aircraft floated upon flaring and the pilot raised the flaps. He states that the aircraft lost lift, bounced after a hard landing and subsequently…Apr 22, 1986 · N4169U · Substantial damage NTSB MKC86LA076Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · St.Charles, MOThe PIC was nervously concerned about an acft that was close behind him in the traffic pattern. The PIC landed fast on the rwy and the right main gear axle broke. The gear leg dug into the rwy and the acft veered off the left side into the soft terrain which…Mar 30, 1986 · N5055G · Substantial damage