NTSB investigations
3,083 cases where the first occurrence was “Hard landing”.
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 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."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 SEA92LA088Accident · No injuriesLimited investigationFinal reportHughes 369E · Hillsboro, ORThe pilot in command's excessive application of collective.NTSB NYC92LA088Accident · No injuriesLimited investigationFinal reportWishon Baby Great Lakes · Ottawa, OHA hard landing due to inadequate flare by the pilot. Factors related to the accident were the inadequate transition training the pilot received and his lack of total experience.NTSB LAX92LA191Accident · No injuriesLimited investigationFinal reportBeech V35B · Hesperia, CAThe pilot's inadequate compensation for the existing wind conditions. Contributing to this accident was the downdraft.NTSB CHI92LA135Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Sidney, NEWas an inadvertent stall/mush during landing by the pilot. A factor related to the accident was lack of recent total experience.NTSB NYC92IA086Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385 · Flushing, NYThe captain's improper aircraft control which resulted in an excessive nosewheel rate of sink and subsequent overload failure of the nose gear tires.NTSB SEA92LA069Accident · No injuriesLimited investigationFinal reportCessna 150J · Tumwater, WAThe (student) pilot's improper recovery from a bounced landing. Factors contributing to the accident were excessive airspeed and the pilot's lack of total experience.NTSB ATL92LA084Accident · No injuriesLimited investigationFinal reportPZL-Okecie PZL-104 Wilga 80 · Mt. Pleasant, SCThe improper flare during the touchdown phase of the approach by the pilot which exceeded the design limits of the airframe and the right landing gear assembly.NTSB LAX92LA162Accident · No injuriesLimited investigationFinal reportRobinson R22B · Simi Valley, CAThe instructor pilot's delayed flare from the autorotation landing. A contributing factor was the soft nature of the terrain.NTSB LAX92LA155Accident · No injuriesLimited investigationFinal reportBeech C-24R · Phoenix, AZThe flight instructor's inadequate supervision of the flight and the private pilot's failure to maintain airspeed. Contributing to this accident was the failure of the main landing gear due to overload.NTSB BFO92LA045Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Brewer, METhe pilot's failure to correct an excessive descent rate during flare. Contributing to the accident was the pilots improper compensation for wind conditions.NTSB FTW92LA091Accident · No injuriesLimited investigationFinal reportCessna 172P · West Helena, ARPilot's improper flarea ND improper recovery from a bounced landing.NTSB LAX92LA140Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Monica, CAThe pilot's misjudged landing flare and her improper bounced landing recovery technique. Contributing factors were the airplane's excessive approach airspeed and the student's lack of experience.NTSB CHI92LA109Accident · No injuriesLimited investigationFinal reportCessna 177BII · Bloomington, ILPilot's improper recovery from a bounced landing. Factors in the accident were excessive airspeed at landing and habit interference.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.NTSB FTW92LA079Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Boerne, TXThe pilot in command inadvertently stalling the aircraft. Factors were the pilot not maintaining proper altitude during the approach and his abrupt aircraft handling.NTSB ATL92LA055Accident · No injuriesLimited investigationFinal reportPitts S-1 · Reidsville, NCThe pilot's failure to compensate for the tailwind and the improper touch down point. Factors were the tailwind and downdraft which resulted from the tall obstacles (trees) around the runway.NTSB LAX92LA132Accident · Minor injuriesLimited investigationFinal reportCessna 195A · San Jose, CAThe pilot's improper compensation for the existing wind conditions and improper recovery from a bounced landing. Contributing to the accident was the left quartering tail/crosswind.NTSB CHI92LA100Accident · No injuriesLimited investigationFinal reportCessna 340 · Ashland, WIThe pilot delayed initiating a go-around. Factors were icing conditions and inadequate windshield anti-ice which resulted in restricted visual lookout.NTSB LAX92LA116Accident · No injuriesLimited investigationFinal reportBeech D-18H · Lanai, HIFailure of the pilot to compensate for an encounter with a windshear phenomena. Contributing to the accident was the lack of a low level windshear warning system or a system for the collection and dissemination of weather advisories.NTSB CHI92LA090Accident · No injuriesLimited investigationFinal reportCessna 414 · Logansport, INThe pilot's failure to maintain an adequate approach speed which resulted in an improper flare. Factors contributing to the accident were the inadequate inflight deicing of the airframe surfaces and in icing conditions encountered.NTSB LAX92LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Alturas, CAThe pilot's misjudged landing flare and his improper bounced landing recovery technique.NTSB ATL92LA043Accident · No injuriesLimited investigationFinal reportCessna 152 · Shelbyville, TNThe improper level off by the student pilot because of misjudging the airplane's altitude above the runway. A factor was her diverted attention by an aircraft behind her in the traffic pattern.NTSB LAX92LA106Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Cottonwood, AZThe student pilot's failure to maintain airspeed and premature raising of the flaps. Contributing to this accident was the improper recovery from a bounced landing, lack of total experience, and the inadvertent stall.NTSB CHI92LA103Accident · No injuriesLimited investigationFinal reportCessna 182P · Monee, ILThe pilot misjudged the landing flare and touchdown. A related factor was: the dark night light conditions.NTSB MIA92LA064Accident · No injuriesLimited investigationFinal reportHughes 369D · Pompano Beach, FLImproper collective input by the pilot-in-command and inadequate supervision by the check pilot.NTSB DEN92LA021Accident · Minor injuriesLimited investigationFinal reportCameron V-77 · Littleton, COThe pilot's improper landing procedure, including wrong compensation for wind conditions and improper use of the envelope dump control. A factor was: high wind.NTSB LAX92LA073Accident · No injuriesLimited investigationFinal reportCessna 150F · Lancaster, CAThe pilot misjudging the landing flare. A factor in the accident was the pilot's lack of total flight experience.NTSB FTW92LA040Accident · No injuriesLimited investigationFinal reportBell 206L-3+ · Arlington, TXThe helicopter's autorotational landing performance capability was exceeded. Factors were the proper descent rate was not possible for the PIC and sufficient information from the manufacturer was not provided.NTSB ANC92LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Talkeetna, AKThe pilot's improper flare following an aborted takeoff, which resulted in a hard landing and the subsequent loss of control of the airplane. Contributing to the accident was the pilot's lack of total experience in the type of operation.NTSB FTW92LA037Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Southlake, TXThe pilots failure to maintain directional control of the airplane. A factor was improper airspeed prior to touchdown which resulted in a hard landing.NTSB CHI92LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Willmar, MNAn inadequate weather evaluation which resulted in flight into icing conditions. Factors in the accident were the icing conditions and the excessive descent during landing.NTSB BFO92LA009Accident · No injuriesLimited investigationFinal reportCessna 150 · Portsmouth, VAThe pilot's improper flare attitude during the landing flare/touchdown and his failure to initiate recovery from a bounced landing.NTSB LAX92LA048Accident · No injuriesLimited investigationFinal reportCessna 182H · Fortuna, CAThat the pilot misjudged the flare altitude. Contributing to the accident was the failure of the flight instructor to adequately supervise the flight.NTSB NYC92LA014Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S-60 · Trenton, NJExcessive descent rate by the pilot in command. A factor was overloading of the basket.NTSB NYC92LA016Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Edgartown, MAImproper recovery from a bounced landing by the pilot. Factors related to the accident were improper use of the flight controls and throttles.NTSB CHI92LA096Accident · Serious injuriesLimited investigationFinal reportCameron N120 · Goshen, INAn improper touchdown by the pilot in command.NTSB CHI92LA016Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Warsaw, INPilot's delayed inflight planning/decision to land.NTSB LAX92LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAThe student pilot's improper landing flare which resulted in a hard landing and the buckling of the airplane's nose gear.NTSB SEA91LA256Accident · No injuriesLimited investigationFinal reportLyons Stueckle Quickie Q-2 · Cheyenne, WYThe premature landing flare by the pilot.NTSB BFO91LA085Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Cheswold, DEThe pilot's failure to arrest an excessive sink rate and crab angle while landing his aircraft.NTSB DEN91LA137Accident · No injuriesLimited investigationFinal reportRaven Ralley RX7 · Englewood, COA hard landing and inadvertent deployment of the balloon heater. A factor was: inadvertent entanglement of a load cable with the heater activation device.NTSB SEA91LA250Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Redmond, WAThe pilot's failure to maintain the proper rate of descent. A factor contributing to the accident was unfavorable winds.NTSB SEA91LA236Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Kent, WAFailure of the pilot to maintain directional control and proper runway alignment during the landing and go-around (aborted landing). Factors related to the accident were: the pilot's improper flare and improper recovery from a bounced landing, which resulted…NTSB LAX91LA405Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Keaau, HIThe pilot's landing hard. A contributing factor in this accident was the aircraft emitting a vibration from an unknown source.NTSB CHI91LA293Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Duluth, MNPremature touchdown while landing by the pic/cfi. Factors related to the accident were low ceilings, rain, and haze; weather evaluation misjudged by the pic/cfi; and visual outlook reduced.NTSB CHI91LA292Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly X-7 · Altoona, IAWeather evaluation misjudged and overconfidence in personal ability. A factor related to the accident was high winds.NTSB ANC91LA141Accident · No injuriesLimited investigationFinal reportCessna 170-B · Iowa Ridge, AKThe pilot-in-command's failure to identify the rough and uneven, unsuitable terrain. Contributing to the accident was the rough and uneven terrain.NTSB CHI91LA284Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Pulaski, WIThe pilot's inadequate compensation for wind conditions. The gusty crosswind was a related factor.NTSB LAX91LA379Accident · No injuriesLimited investigationFinal reportCessna C-152 · Palo Alto, CAImproper recovery from a bounced landing by the student pilot and the delayed remedial action of the instructor pilot. Contributing to this accident was the student pilot's failure to maintain the proper descent rate which resulted in a bounced landing and…NTSB DEN91LA128Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe student pilot misjudged his landing flare. A factor was: the pilot's lack of experience.