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 MIA06CA088Accident · No injuriesData collectionFinal reportCessna 172N · Daytona Beach, FLThe pilot's improper landing flare/touchdown, which resulted in the airplane porpoising and incurring damage.NTSB NYC06CA094Accident · No injuriesData collectionFinal reportCessna 150M · Hazleton, PAThe student pilot's improper recovery from a bounced landing, resulting in a hard landing.NTSB SEA06CA082Accident · No injuriesData collectionFinal reportCessna 172 · Aurora, ORThe student pilot's misjudgment of the landing flare resulting in a hard landing. A related factor was the crosswind.NTSB ANC06LA035Accident · Minor injuriesLimited investigationFinal reportClaypool RV-6A · San Diego, CAThe pilot's improper recovery from a bounced landing, which resulted in a hard landing, the collapse of the nose landing gear, and a nose over. A factor associated with the accident was the pilot's failure to perform a go-around.NTSB ANC06CA034Accident · No injuriesData collectionFinal reportPiper PA-22 · Grand Canyon, AZThe pilot's improper recovery from a bounced landing during touchdown, which resulted in a loss of control and encounter with terrain. Factors associated with the accident are the pilot's misjudged flare, and a gusty wind.NTSB ANC06CA036Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot's improper recovery from a bounced landing, which resulted in structural damage to the firewall and fuselage.NTSB NYC06CA069Accident · No injuriesData collectionFinal reportCessna 152 · Augusta, METhe pilot's improper flare, which resulted in a hard landing.NTSB DFW06CA066Accident · No injuriesData collectionFinal reportRobinson R44 · Rayville, LAThe pilot's failure to maintain rotor RPM, which resulted in a hard landing.NTSB CHI06CA079Accident · No injuriesData collectionFinal reportSocata TBM 700 · Canton, OHThe pilot failed to flare the airplane properly.NTSB DFW06LA060Accident · No injuriesLimited investigationFinal reportCessna 175 · Lindsay, OKThe hard landing was the result of the pilot's failure to maintain adequate airspeed while misjudging the altitude above the runway. Contributing factors were the inadequate quality of the manufacturer's engine-support bracket and the prevailing night…NTSB DFW06CA062Accident · No injuriesData collectionFinal reportEurocopter France AS-350-B2 · Port Isabel, TXThe pilot's failure to maintain rotor RPM and his improper touchdown during a simulated hovering autorotation. A contributing factor was the flight instructor's delayed remedial action.NTSB DEN06LA035Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMthe student pilot's improper flare, resulting in a hard landing. Contributing factors were the flight instructor's inadequate supervision of the pilot, and the dark night light conditions.NTSB DFW06CA058Accident · No injuriesData collectionFinal reportBell 206L-4 · Fort Worth, TXThe flight instructors failure to maintain main rotor RPM and improper flare, which resulted in a hard landing.NTSB NYC06CA059Accident · No injuriesData collectionFinal reportCessna R182 · Bedford, MAThe pilot's improper flare resulting in a hard landing. A factor in the accident was the wind gusts.NTSB MIA06CA046Accident · No injuriesData collectionFinal reportPiper PA-46/Jetprop · Tampa, FLThe pilot's improper flare.NTSB NYC06CA049Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Lawrence, MAThe pilot's improper flare and recovery from a bounced landing.NTSB MIA06CA043Accident · No injuriesData collectionFinal reportAviat A-1B · Alexander City, ALThe failure of the pilot-in-command to maintain the proper rate of descent during approach for landing to the glassy water resulting in a hard landing and separation of the floats.NTSB ATL06CA047Accident · No injuriesData collectionFinal reportCessna 172 P · Wilmington, NCThe student pilot's improper landing flare which resulted in a hard landing.NTSB ATL06CA025Accident · No injuriesData collectionFinal reportCessna 172S · Mobile, ALThe pilot's improper landing flare, which resulted in a hard landing.NTSB CHI06CA054Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Rockford, ILFailure of the commercial pilot (dual student) to maintain a proper descent rate and a safe airspeed during the simulated forced landing. Additional causes were the failure of the flight instructor and the dual student to initiate a go-around in sufficient…NTSB ATL06CA033Accident · No injuriesData collectionFinal reportCessna 172H · Waycross, GAThe student pilot's improper landing flare and the CFI's inadequate supervision resulting in a hard landing.NTSB NYC06CA030Accident · Minor injuriesData collectionFinal reportCessna 208 · Southampton, NYThe flight instructor's improper flare and his inadequate remedial action, which resulted in a hard landing.NTSB NYC06CA031Accident · No injuriesData collectionFinal reportBeech F33A · Montgomery, NYThe pilot's misjudgment of the landing flare, which resulted in a hard landing short of the runway. Factors included the night lighting conditions, the time-out and reestablishment of the high intensity runway lighting, and the pilot's failure to go around.NTSB ATL06CA018Accident · No injuriesData collectionFinal reportCessna 152 · Durham, NCThe pilot's improper flare on landing flare touchdown resulting in a hard landing and collapse of the nose gear.NTSB MIA06CA014Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe pilots inadequate landing flare/touchdown which resulted in a hard landing.NTSB MIA06CA013Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe pilot-in-command's improper flare during a practice autorotative landing, which resulted in a hard landing.NTSB MIA06CA012Accident · No injuriesData collectionFinal reportCessna 152 · Titusville, FLThe student pilot's inadequate recovery from a bounced landing resulting in substantial damage to the airplane.NTSB LAX06CA019Accident · No injuriesData collectionFinal reportHarmel RV6A · Oceanside, CAthe pilot-induced oscillations encountered on landing following the pilot's misjudged landing flare and premature release of elevator backpressure during touchdown.NTSB LAX06CA010Accident · No injuriesData collectionFinal reportCessna 182B · Mokelumne Hill, CAthe pilot's improper flare resulting in a hard landing. A related factor was gusty wind conditions.NTSB CHI06CA009Accident · No injuriesData collectionFinal reportCessna U206G · Hanover, MIThe pilot misjudged the landing flare which resulted in the bounced landing and subsequent overload failure of the nose landing gear wheel. A factor associated with the accident was the grass airstrip.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.NTSB LAX06CA003Accident · No injuriesData collectionFinal reportAerospatiale AS350B · Grand Canyon, AZthe pilot's failure to maintain control of the helicopter during landing in gusty wind conditions, which resulted in a hard landing and ground resonance.NTSB LAX06CA001Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Tucson, AZthe student pilot's failure to maintain adequate airspeed and rotor rpm during a practice autorotation, and the instructor's failure to adequately monitor the maneuver, which resulted in a hard landing and roll over.NTSB ATL05CA164Accident · No injuriesData collectionFinal reportMaule MT-7-235 · Guyton, GAThe pilot's improper recovery from a bounced landing, and improper flare, which resulted in a hard landing.NTSB MIA05CA160Accident · No injuriesData collectionFinal reportBell 206B3 · Titusville, FLThe flight instructor's improper flare resulting in a hard landing and main rotor contact with tail boom.NTSB LAX05CA314Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kamuela, HIThe student's misjudged landing flare, and the instructor's inadequate supervision and delayed remedial action. A factor in the accident was the high density altitude.NTSB NYC05LA145Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland BK-117-B2 · Columbus, OHThe pilot's failure to maintain aircraft control during the landing flare, which resulted in a hard landing. A factor associated with this accident was a tailwind.NTSB DFW05CA248Accident · No injuriesData collectionFinal reportPiper PA-46T · El Reno, OKThe improper flare which resulted in a hard landing. A related factor was the instructor's delayed remedial action.NTSB CHI05CA270Accident · No injuriesData collectionFinal reportCessna 182S · Waukesha, WIThe misjudged flare by the pilot.NTSB ANC05CA140Accident · No injuriesData collectionFinal reportPiper PA-18 · Nenana, AKThe pilot's improper recovery from a bounced landing during the landing roll, which resulted in a loss of control and a nose over.NTSB CHI05CA265Accident · No injuriesData collectionFinal reportAviat A-1B · Drummond Island, MIThe pilot's failure to adequately compensate for the wind conditions, his failure to perform a go-around, and he flared improperly. Factors included the downdraft and the shoreline.NTSB ATL05CA160Accident · No injuriesData collectionFinal reportCessna 182T · Wilmington, NCThe pilot's improper flare which resulted in a hard landing, and the collapse of the nose gear.NTSB ANC05LA142Accident · No injuriesLimited investigationFinal reportCessna 185E · Pilot Point, AKThe pilot's misjudged landing flare, which resulted in a hard landing and an overload failure of the main landing gear during the landing touchdown.NTSB LAX05CA299Accident · No injuriesData collectionFinal reportCessna 172S · San Manuel, AZThe pilot's misjudged flare during a touch-and-go landing.NTSB CHI05CA253Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Rockton, ILThe pilot's excessive descent rate on approach for landing and the settling with power condition subsequently encountered. Contributing factors were the pilot's failure to reduce the descent rate prior to entering the settling with power condition and his…NTSB LAX05LA281Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Minden, NVthe student pilot's failure to ensure that the canopy was properly latched prior to departure. The inadequate supervision of the flight by the instructor and flight school was also causal.NTSB DFW05CA224Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe pilot's improper recovery from a bounced landing. A contributing factor was the dark night conditions.NTSB CHI05CA247Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Ypsilanti, MIThe pilot's failure to maintain adequate airspeed which resulted in his inability to properly flare the airplane and the subsequent hard landing.NTSB SEA05CA182Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Boise, IDInadequate communications between the certified flight instructor and student pilot, and the student pilot's delay in relinquishing controls resulting in a hard landing during a practice autorotation.NTSB DFW05CA220Accident · No injuriesData collectionFinal reportRobinson R-44 · Odessa, TXThe pilot's failure to maintain main rotor RPM and the improper landing flare which resulted in a hard landing.