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 LAX01LA203Accident · No injuriesLimited investigationFinal reportMooney M20J · Jackson, CAFailure of the pilot to maintain proper airspeed for landing and airplane control with an existing crosswind. A contributing factor was the distraction of the pilot by a yelling passenger.NTSB LAX01LA202Accident · No injuriesLimited investigationFinal reportBeech 76 · Prescott, AZThe certified flight instructor's inadequate supervision of the student who failed to maintain adequate airspeed on approach, resulting in a stall/mush, and delayed remedial action when the flight instructor ordered a go-around.NTSB FTW01LA135Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Amarillo, TXthe pilot's inadequate compensation for the crosswind, which resulted in a hard landing. A contributing factor was the crosswind.NTSB ATL01LA086Accident · No injuriesLimited investigationFinal reportCessna R172-K · Culebras Island, PRPilots improper flare which resulted in a hard landing.NTSB DEN01LA104Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · West Jordan, UTthe pilot inadvertently flaring the airplane too high above the ground, resulting in a hard landing that sheared a bolt in the tail wheel assembly. This rendered directional control impossible and induced an uncontrolled ground loop. A contributing factor was…NTSB CHI01LA316Accident · No injuriesLimited investigationFinal reportCessna 172R · Alton, ILThe misjudged flare by the pilot.NTSB DEN01LA099Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Sterling, COfailure by the pilot to control descent rate during approach to land. A factor was a temperature inversion.NTSB IAD01LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe pilot's improper landing flare. A factor was the crosswind.NTSB LAX01LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAthe student pilot's misjudged landing flare and improper use of the elevator control.NTSB SEA01LA086Accident · No injuriesLimited investigationFinal reportCessna U206 · Yamhill, ORthe pilot's failure to adequately compensate for gusty tailwind conditions, resulting in an excessive rate of descent at touchdown. Factors include gusty tailwinds during the landing sequence.NTSB LAX01LA174Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Adelanto, CAThe pilot's stall/mush as a result of his inadequate airspeed and improperly planned final approach.NTSB LAX01LA164Accident · No injuriesLimited investigationFinal reportCessna T210N · Truckee, CAThe pilot's failure to maintain the proper descent and his failure to maintain directioinal control during landing.NTSB ATL01LA050Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Lake Wales, FLThe pilot's improper use of flight controls during a bounced landing, and subsequent collision with the ground. A factor of the collision is the rough and uneven terrain.NTSB IAD01TA051Accident · Minor injuriesFinal reportHughes 369D · Taylorsville, KYthe flight instructor's inadequate aircraft control during a practice autorotation which resulted in a hard landing.NTSB LAX01LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe pilot's premature flare, which resulted in an inadvertent stall and a bounced landing. A factor was the improper recovery from a bounced landing.NTSB IAD01LA042Accident · No injuriesLimited investigationFinal reportCessna 172R · Lawrence, MAThe pilot's improper flare.NTSB LAX01LA137Accident · No injuriesLimited investigationFinal reportCessna 172S · Long Beach, CAThe student pilot's inadequate compensation for the exisiting crosswind and his improper landing flare that resulted in a hard landing, and loss of directional control during the landing roll.NTSB LAX01FA127Accident · No injuriesField investigationFinal reportAgusta A109A · Hanapepe, Kauai, HIthe pilot's misjudged flare during an autorotation, which resulted in a hard landing. A contributing factor was the check airman's failure to demonstrate a stuck pedal maneuver prior to assigning the procedure to the pilot.NTSB LAX01LA125Accident · No injuriesLimited investigationFinal reportRobinson R22B · Long Beach, CAFailure of the CFI to adequately monitor the flight, which resulted in a low airspeed autorotation and hard landing.NTSB FTW01LA070Accident · No injuriesLimited investigationFinal reportBartels Rans S-7 · Lafayette, LAthe pilot's improper flare which resulted in a hard landing.NTSB MIA01LA078Accident · No injuriesLimited investigationFinal reportLearjet 35A · Punta Gorda, FLthe pilot misjudged the flare resulting in a hard landing, and impact with the runway. A factor in the accident was reduced visibility because of ground fog.NTSB ATL01LA035Accident · Minor injuriesLimited investigationFinal reportMichael E. Nourse RV-6A · Immokalee, FLThe pilot's improper flare, and his evaluation of the gusty wind conditions resulted in the collision with the terrain.NTSB ANC01LA034Accident · No injuriesLimited investigationFinal reportDouglas DC-6B · Crooked Creek, AKThe flight crew's misjudged flare while landing. Factors associated with the accident were flat light conditions, snow-covered terrain, and an uphill runway grade.NTSB SEA01LA044Accident · No injuriesLimited investigationFinal reportBell 206B · McMinnville, ORThe pilot's failure to apply adequate power during a practice autorotation. A factor contributing to the accident was a rough/uneven area on the asphalt landing surface.NTSB LAX01LA076Accident · No injuriesLimited investigationFinal reportPurvis/Thorpe T-18 · Chiriaco Summit, CAThe dual student's improper recovery from a bounced landing, his failure to maintain directional control during the go-around, and the flight instructor's inadequate supervision of the go-around attempt.NTSB LAX01LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Livermore, CAThe student pilot's inadequate compensation for a tailwind during final approach and her improper recovery from a bounced landing.NTSB MIA01LA049Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Ciales, PRthe flight crew's failure to follow procedures for a straight-in autorotation with power recovery that resulted in their improper use of collective resulting in a hard landing and substantial damage to the helicopter.NTSB DEN01LA032Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Aspen, COA hard landing which exceeded the design stress limits of the aircraft.NTSB LAX01LA058Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe pilot-in-command's inadequate supervision of the second pilot and delay taking control of the aircraft and implementing remedial action. A factor in the accident was the second pilot's interference with the pilot-in-command's operation of the collective…NTSB DEN01LA031Accident · No injuriesLimited investigationFinal reportCessna R182 · Broomfield, COthe flight instructor's inadequate supervision of the dual student, which resulted in a hard landing. Contributing factors were the dual student flaring the airplane prematurely, resulting in an inadvertent stall/mush.NTSB NYC01LA055Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Mount Sterling, KYThe student pilot's inadequate recovery from a bounced landing.NTSB LAX01LA053Accident · No injuriesLimited investigationFinal reportHughes 269C · Carlsbad, CAThe CFI's inadequate supervision and failure to maintain control of the helicopter during a practice autorotation. A contributing factor was the student's improper in-flight planning/decision.NTSB NYC01LA049Accident · No injuriesLimited investigationFinal reportCessna 182J · College Park, MDThe pilot's inadequate flare, which resulted in a hard landing. A factor related to the accident was the downdraft wind conditions.NTSB LAX01LA048Accident · No injuriesLimited investigationFinal reportCessna 172N · Marana, AZThe student pilot's improper flare and improper recovery from a bounced landing. A factor in the accident was the morning sun, which momentarily restricted the pilot's vision.NTSB ATL01LA018Accident · No injuriesLimited investigationFinal reportCessna 172 · Mobile, ALThe pilot's improper flare during landing that resulted in a hard landing and the subsequent overload failure of the nose gear assembly.NTSB NYC01LA041Accident · No injuriesLimited investigationFinal reportCessna 182Q · Blacksburg, VAThe pilot's improper flare while landing.NTSB DEN01LA015Accident · No injuriesLimited investigationFinal reportMurdock RAF 2000 GTX · Ogden, UTThe pilot's improper touchdown which resulted in a hard landing. Factors were lack of familiarity with the aircraft and lack of total experience.NTSB LAX01LA042Accident · No injuriesLimited investigationFinal reportEurocopter AS 350B-3 · Mesa, AZThe dual student's misjudged landing flare and level off, which resulted in a heel first touchdown and subsequent hard landing during a practice autorotation. Also causal was the instructor pilot's inadequate supervision of the student.NTSB NYC01LA035Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Babylon, NYThe student pilot's inadequate use of the collective, and the instructor pilot's inadequate remedial action.NTSB LAX01LA037Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Tucson, AZThe pilot's misjudged landing flare and improper recovery from the bounced landing resulting in the overload failure of the nose gear and the airplane nosing over.NTSB LAX01LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Ramona, CAThe dual student's habit interference, from his previous training in a different type of airplane, that precipitated his improper use of the elevator control during a go-around.NTSB MIA01LA014Accident · Minor injuriesLimited investigationFinal reportCraig R. Merrill Luton Beta · Ridgeland, SCThe pilot's failure to maintain airspeed on final approach resulting in the aircraft settling fast, touching down hard, and colliding with an embankment on the side of the runway, where it came to rest inverted.NTSB CHI01LA028Accident · No injuriesLimited investigationFinal reportPiper PT-46 · Eden Prairie, MNthe pilot misjudging the landing flare, and his failure to recover from the bounced landing.NTSB IAD01LA004Accident · No injuriesLimited investigationFinal reportYakovlev 52 · Berryville, VAThe pilot's improper flare, which resulted in a hard landing and separation of the nose landing gear.NTSB NYC01LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Poughkeepsie, NYThe student pilot's improper recovery from a bounced landing.NTSB LAX01LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sedona, AZThe pilot's inadequate compensation for wind conditions while on short final landing approach. A factor was the unfavorable wind condition.NTSB DEN01LA023Accident · No injuriesLimited investigationFinal reportCessna 310N · Montrose, COthe pilot's inadequate airspeed on final approach which resulted in a hard landing. A contributing factor was wind shear.NTSB NYC01LA008Accident · No injuriesLimited investigationFinal reportBeech BE-23-B24R · Fork Union, VAThe pilot's inadequate flare which resulted in a hard landing. A factor related to the accident was the uneven landing area condition.NTSB LAX01LA005Accident · Serious injuriesLimited investigationFinal reportGalaxy Balloons Galaxy 7 · Inyokern, CAThe pilot's hard landing during a high wind condition.NTSB LAX01LA008Accident · No injuriesLimited investigationFinal reportCessna 172H · Hilo, HIAn inadvertent pilot-induced porpoise resulting from the pilot's improper landing flare and inadequate power management.