NTSB investigations
679 cases where the defining event was Abnormal runway contact.
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.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '090') 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."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '090') 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 WPR14CA211Accident · No injuriesData collectionFinal reportFdr601 Zodiac 601XL · Lewiston, IDThe pilot's improper flare during landing.NTSB ERA14LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Brooksville, FLThe pilot’s loss of directional control while landing at night, which resulted in a runway excursion and collision with airport signage. Contributing to the accident was the total loss of electrical power, which necessitated the pilot having to land without…NTSB ERA14CA230Accident · No injuriesData collectionFinal reportCessna 172S · Deland, FLThe student pilot's failure to maintain control of the airplane during the landing, and the flight instructor's inadequate supervision of the student pilot resulting in abnormal runway contact and damage to the airplane.NTSB ERA14CA225Accident · Minor injuriesData collectionFinal reportLake LA-4 · Chapin, SCThe pilot's improper flare, which resulted in abnormal contact with the water and separation of the right pontoon..NTSB ERA14CA209Accident · No injuriesData collectionFinal reportCessna T206H · Gilford, NHThe pilot misjudged the float equipped airplane's altitude while maneuvering above the surface of a lake, which resulted in a float inadvertently contacting the water. Contributing to the accident were the glassy water conditions and pilot's lack of recent…NTSB ERA14CA190Accident · Minor injuriesData collectionFinal reportProgressive Aerodyne Searey LSA · Tavares, FLThe pilot's improper landing flare resulting in a bounced landing and his delay in performing a go around which resulted in a collision with trees.NTSB ERA14CA191Accident · Minor injuriesData collectionFinal reportTerry F King Zenith 701 · La Belle, FLThe pilot's failure to maintain airspeed after a total loss of engine power at takeoff, which resulted in a hard landing. Also causal was the pilot/owner/builder's improper installation of the magnetos which resulted in the engine power loss.NTSB DCA14MA081Accident · No injuriesClass 2 · MajorFinal reportAirbus A320 - 214 · Philadelphia, PAthe captain's decision to reject the takeoff after the airplane had rotated. Contributing to the accident was the flight crew's failure to follow standard operating procedures by not verifying that the airplane's flight management computer was properly…NTSB CEN14CA158Accident · Minor injuriesData collectionFinal reportAmerican Champion 8GCBC · Chisago City, MNThe unsuitable landing area encountered by the pilot due to wet soft snow conditions that resulted in a nose over.NTSB CEN14CA153Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Cleveland, OHThe pilot's improper flare and recovery from a bounced landing, which resulted in a loss of control and impact with terrain.NTSB CEN14LA146Accident · No injuriesLimited investigationFinal reportFogg Quicksilver MX II · Holland, MIThe pilot's inability to maintain airplane control after inadvertently landing in an area of deep snow on a frozen lake.NTSB ERA14CA078Accident · No injuriesData collectionFinal reportCessna 172S · Miami, FLThe pilot's improper flare during a gusty, crosswind landing.NTSB WPR14CA039Accident · No injuriesData collectionFinal reportYuneec Yuneec · Upland, CAThe pilot's improper flare, which resulted in a loss of aircraft control and hard landing.NTSB WPR14CA022Accident · No injuriesData collectionFinal reportCollins Zenith Stol CH 701 · Deer Park, WAThe pilot's inadequate flare and failure to maintain control of the airplane during the landing with a tailwind.NTSB WPR14CA011Accident · Serious injuriesData collectionFinal reportMooney M20J · Sedona, AZThe pilot's inadequate flare which resulted in a bounced landing and subsequent loss of aircraft control during an aborted landing.NTSB ANC13CA105Accident · No injuriesData collectionFinal reportPiper PA 18 · Big Lake, AKThe pilot's selection of unsuitable terrain for landing, resulting in abnormal contact with terrain.NTSB WPR13CA409Accident · No injuriesData collectionFinal reportCessna 195A · Meadow Creek, MTThe pilot's failure to maintain directional control during the takeoff roll on a rough turf runway.NTSB ANC13CA096Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Talkeetna, AKThe pilot's delayed decision to go-around, which resulted in a collision with water.NTSB ERA13CA395Accident · No injuriesData collectionFinal reportCessna 172S · Fort Lauderdale, FLThe student pilot’s failure to apply power to go-around following a bounced landing resulting in abnormal runway contact and collapse of the nose landing gear.NTSB CEN13CA515Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA-1B · Valparaiso, INThe pilot's improper recovery from a bounced landing.NTSB WPR13CA387Accident · No injuriesData collectionFinal reportTL Ultralight Stingsport · Burlington, WAThe pilot's improper flare and unsuccessful attempt to correct a bounced landing, which resulted in a nose gear collapseNTSB ERA13LA379Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe use of an improper nose landing gear through bolt, which decreased the overall strength of the gear and resulted in overload failure during a hard landing. Contributing to the accident was the student pilot's inadequate landing flare, which resulted in…NTSB WPR13CA365Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Independence, ORThe pilot's improper flare with a crosswind condition, and unsuccessful attempt to correct a bounced landing, which resulted in a runway excursion and subsequent nose over.NTSB CEN13CA434Accident · No injuriesData collectionFinal reportDavid W Oakes RV-7A · Charlottesville, INThe improper landing attitude which damaged the nosewheel and a resulted in a hard landing.NTSB CEN13LA380Accident · Minor injuriesLimited investigationFinal reportDiamond Aicraft Industries DA 20-C1 · Odessa, TXThe pilot's use of an improper flap setting and a subsequent inadequate flare of the airplane, which resulted in a bounced landing, and the pilot's delay in executing a go-around.NTSB CEN13LA376Accident · Serious injuriesLimited investigationFinal reportAvery Jack H Glastar GS-1 · Grand Rapids, MNThe loss of directional control during landing because the autopilot engaged for undetermined reasons because water and recovery damage precluded detailed examination of system components.NTSB WPR13CA260Accident · No injuriesData collectionFinal reportWampach Murphy Moose · Galt, CAThe pilot's improper landing flare, which resulted in an abnormal runway contact.NTSB ERA13CA266Accident · No injuriesData collectionFinal reportCessna 172L · Millinocket, METhe student pilot’s failure to maintain directional control during landing.NTSB ANC13CA052Accident · No injuriesData collectionFinal reportCessna U206A · Fairbanks, AKThe pilot’s inadequate flare, which resulted in a nose-low impact with glassy water and a subsequent nose-over.NTSB DCA13FA094Accident · No injuriesField investigationFinal reportBombardier DHC8 · Newark, NJthe frozen left main landing gear (MLG) uplock roller due to lack of lubrication and the uplock latch that had worn beyond acceptable tolerances, which prevented the flight crew from extending the left MLG using the alternate extension system. Contributing to…NTSB DCA13CA088Accident · No injuriesData collectionFinal reportGeneral Atomics MQ-9 · Cocoa Beach, FLan improper flare leading to a nose-wheel first touchdown, which resulted in a pilot induced oscillation (PIO). The PIO caused the UAS to pitch up abruptly on the third nose gear contact with the runway, resulting in the separation of the nose wheel assembly…NTSB ERA13CA206Accident · Minor injuriesData collectionFinal reportPoole Robert C JR Van's · Salisbury, NCThe pilot's improper landing flare, which resulted in a hard landing, and his subsequent decision to exit the paved runway onto the soft terrain.NTSB WPR13CA166Accident · No injuriesData collectionFinal reportBellanca 7ECA · Sonoma, CAThe student pilot’s failure to maintain directional control during the touchdown and landing roll.NTSB ANC13CA031Accident · Minor injuriesData collectionFinal reportNelson Larry L WAG Aero 2+2 · Chickaloon, AKThe pilot's delayed decision to abort the landing.NTSB WPR13LA111Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Boise, IDThe pilot's failure to maintain a proper glidepath and stabilized approach, which resulted in the airplane touching down short of the runway.NTSB CEN13CA144Accident · No injuriesData collectionFinal reportMooney M20J · Warsaw, INThe pilot's improper recovery from a bounced landing and failure to maintain control of the airplane during a go-around maneuver. Contributing to the accident were the pilot’s complacency flying the airplane and his lack of training on bounced landing…NTSB CEN13CA142Accident · No injuriesData collectionFinal reportCessna 172S · Peoria, ILThe pilot’s inadvertent activation of the electric trim to the nose-down position, which resulted in the airplane being improperly configured for takeoff, and the flight instructor’s incorrect remedial action that allowed the airplane to porpoise.NTSB WPR13CA104Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Torrance, CAThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB CEN13LA127Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Elkhart, INThe pilot’s improper flare, which resulted in a bounced landing.NTSB CEN13CA125Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Middle Bass Island, OHThe pilot did not attain the proper touchdown point during landing, which resulted in impact with the edge of the runway surface.NTSB ERA13CA098Accident · Minor injuriesData collectionFinal reportMckay Gene RV-9A · Brunswick, GAThe pilot’s failure to maintain airplane control while landing in gusting wind conditions.NTSB WPR13CA055Accident · No injuriesData collectionFinal reportPiper PA18 · Needles, CAThe flight instructor, while demonstrating a water landing to the pilot receiving instruction, did not maintain proper alignment with the landing surface, which resulted in a hard landing.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 CEN13CA098Accident · No injuriesData collectionFinal reportCessna 172N · Moline, ILThe student pilot's misjudgment of the landing flare, which resulted in a bounced landing.NTSB CEN13CA064Accident · Minor injuriesData collectionFinal reportLawson Ron Rans S-19 · Crowley, LAThe pilot’s improper landing flare, which resulted in the collapse of the nose landing gear and the airplane nosing over.NTSB ERA13CA035Accident · Minor injuriesData collectionFinal reportAB Sportine Aviacija Genesis 2 · Roseland, VAThe pilot’s failure to maintain glider control during takeoff.NTSB CEN13CA026Accident · Minor injuriesData collectionFinal reportMace Justin I Dragonfly · Durango, COThe pilot’s delayed decision to perform a go-around, which resulted in the airplane impacting trees. Contributing to the accident was the pilot’s inexperience in the accident airplane and his encounter with conditions that exceeded his capabilities.NTSB ERA12CA564Accident · Minor injuriesData collectionFinal reportLancair LC42-550FG · Okeechobee, FLThe pilot's improper landing flare, which resulted in a hard landing.NTSB CEN12LA635Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Mecosta, MIThe pilot's improper landing flare, which resulted in a bounced landing and loss of airplane control.NTSB CEN12CA624Accident · No injuriesData collectionFinal reportCessna 172R · Salina, KSThe flight instructor's improper flare in gusty wind conditions, which resulted in a hard landing.