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 ATL06CA116Accident · No injuriesData collectionFinal reportCessna 172M · Augusta, GAThe pilot's improper flare on landing with excessive altitude resulting in a hard landing.NTSB ANC06LA102Accident · Serious injuriesLimited investigationFinal reportLiberty XL2 · Ormond Beach, FLThe pilot's improper recovery from a bounced landing, and failure to maintain minimum airspeed during the subsequent aborted landing, which resulted in an inadvertent stall and impact with terrain. A factor associated with the accident was the inadvertent…NTSB NYC06CA189Accident · No injuriesData collectionFinal reportCessna 172P · Poughkeepsie, NYThe student pilot's improper flare and failure to recover from a bounced landing, which resulted in a hard landing.NTSB DEN06CA108Accident · Serious injuriesData collectionFinal reportFirefly Balloons Galaxy 11B · Albuquerque, NMfuel exhaustion, resulting in the pilot's inability to relight one of two burners, and resulting in a hard landing.NTSB DEN06CA104Accident · Serious injuriesData collectionFinal reportTop Dog 582 · Pleasanat View, COthe pilot's improper flare resulting in a hard landing.NTSB LAX06CA237Accident · No injuriesData collectionFinal reportBeech A36 · Bakersfield, CAthe pilot's improper flare, which resulted in a hard landing.NTSB ATL06CA107Accident · No injuriesData collectionFinal reportCessna 182Q · Lafayette, GAThe pilot's improper flare which resulted in a hard landing.NTSB CHI06CA227Accident · No injuriesData collectionFinal reportCessna 172M · Cahokia, ILThe pilot's inadequate flare. A factor was the night light conditions.NTSB LAX06TA234Accident · No injuriesFinal reportLet Super Blanik L-23 · Los Alamitos, CAfailure of the winch operator to maintain an adequate winch tow speed, resulting in a stall and hard landing.NTSB LAX06LA229Accident · No injuriesLimited investigationFinal reportVelocity 173/RG-XL · Modesto, CAthe pilot's misjudged flare and improper recovery from a bounced landing, which resulted in a hard landing and landing gear collapse. A contributing factor was the pilot/builder's inadequate adjustment of the landing gear cable tension.NTSB ATL06CA104Accident · No injuriesData collectionFinal reportCessna 182H · Birmingham, ALThe pilot's failure to maintain airspeed during final approach resulting in a stall/mush and a hard landing.NTSB LAX06CA226Accident · No injuriesData collectionFinal reportBarnard RV-6 · Groveland, CAthe misjudged flare by the pilot that resulted in a hard bounced landing, and his failure to maintain directional control during the attempted recovery.NTSB CHI06CA185Accident · Minor injuriesData collectionFinal reportCessna 172K · Sullivan, ILThe pilot's misjudged flare and his improper recovery from the bounced landing which led to a loss of directional control and subsequent collision with crops and the ground.NTSB SEA06CA137Accident · No injuriesData collectionFinal reportHughes 369A · Medford, ORThe pilot's misinterpretation of the wind direction (in-flight planning) and subsequent improper descent rate to the ground during a landing attempt. A factor was the tailwind conditions.NTSB NYC06CA168Accident · No injuriesData collectionFinal reportLiberty Aerospace XL2 · Mansfield, MAThe pilot's improper recovery from a bounced landing.NTSB CHI06LA175Accident · 1 fatalLimited investigationFinal reportCessna A185E · Clear Lake, MNThe pilot's misjudged flare that resulted in a hard landing and subsequent nose over. A factor to the accident was the grass runway that the forward landing gear dug into during the hard landing, resulting in the amphibian airplane nosing over.NTSB SEA06CA131Accident · No injuriesData collectionFinal reportCessna 177A · Olympia, WAThe pilot's inadequate recovery from a bounced landing which resulted in a hard landing.NTSB DFW06CA167Accident · Minor injuriesData collectionFinal reportAgin Jeffrey T RV-4 · Arlington, TXThe pilot's improper recovery from a bounced landing.NTSB LAX06CA209Accident · No injuriesData collectionFinal reportCessna 152 · Concord, CAthe student pilot's unstabilized approach, misjudged landing flare, inadequate recovery from a bounced landing, and failure to maintain directional control. A contributing factor to the accident was the in-flight distraction.NTSB ATL06CA095Accident · No injuriesData collectionFinal reportFantasy Air Allegro 2000 · Sanford, NCThe student pilot's improper flare, and inadequate recovery from a bounced landing.NTSB LAX06CA208Accident · No injuriesData collectionFinal reportCessna 210B · Flagstaff, AZThe pilot's misjudged flare and inadequate recovery from a bounced landing, which resulted in a hard landing and a porpoise.NTSB LAX06CA199Accident · No injuriesData collectionFinal reportMooney M20K · Fresno, CAThe pilot's improper flare and his inadequate recovery from a bounced landing that resulted in a porpoise.NTSB SEA06CA113Accident · No injuriesData collectionFinal reportPiper PA-20 · Salt Lake City, UTAn improper flare and the pilot's failure to maintain directional control during the landing which resulted in the aircraft nosing over. Delayed remedial action was a factor.NTSB LAX06CA189Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Llano, CAthe student pilot's failure to recover from a porpoise/pilot induced oscillation, which resulted in a hard landing.NTSB DFW06CA153Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Mena, ARThe pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB MIA06CA113Accident · No injuriesData collectionFinal reportCessna 172R · Kissimmee, FLThe pilot's improper flare.NTSB ANC06CA065Accident · No injuriesData collectionFinal reportPiper PA-12 · Wasilla, AKThe pilot's inadequate compensation for a tailwind during the landing flare, which resulted in an in-flight collision with snow-covered terrain during an aborted landing. Factors contributing to the accident were a tailwind and rising terrain.NTSB CHI06LA149Accident · No injuriesLimited investigationFinal reportBeech A23 · Troy, MIThe improper flare and improper recovery from a bounced landing by the unknown pilot.NTSB NYC06CA117Accident · Serious injuriesData collectionFinal reportCameron Balloons Z-120 · Montvale, VAThe pilot's failure to arrest an excessive descent rate prior to ground contact, which resulted in a hard landing. A factor in the accident were the wind gusts.NTSB CHI06CA135Accident · No injuriesData collectionFinal reportCessna 172SP · Indianapolis, INThe pilot's improper flare during landing.NTSB SEA06LA100Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Battle Ground, WAthe pilot's excessive airspeed and exceeding the proper touchdown point during landing, which resulted in a hard landing and subsequent overrun of the runway. Factors contributing to the accident included the fence, the trees and the pilot's failure to…NTSB SEA06CA102Accident · No injuriesData collectionFinal reportHughes 369A · Banks, ORThe pilot's failure to maintain rotor rpm while performing a simulated autorotation, which resulted in a hard landing. A contributing factor was the pilot's incorrect interpretation of the examiner's instruction to add power.NTSB ANC06CA057Accident · No injuriesData collectionFinal reportRobinson R-44 · Indiantown, FLA hard landing and subsequent nose down when the helicopter pilot misjudged the landing flare during a touchdown autorotation.NTSB DFW06TA127Accident · Serious injuriesFinal reportAerospatiale AS350-B3 · Santa Teresa, NMThe flight instructor's improper supervision of the flight which resulted in a hard landing.NTSB DEN06LA076Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Del Norte, COthe pilot's failure to maintain airspeed, resulting in an inadvertent stall and impact with terrain during a power-on landing. Contributing factors were the pilot's improper recovery from a bounced landing, and windshear.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.NTSB DFW06CA120Accident · Minor injuriesData collectionFinal reportCessna 150L · Levelland, TXThe pilot's misjudged landing flare and his improper recovery from a bounced landing.NTSB MIA06CA101Accident · No injuriesData collectionFinal reportCessna 172N · Miami, FLThe improper flare by the pilot resulting in a hard landing and substantial damage to the airplane.NTSB LAX06CA173Accident · No injuriesData collectionFinal reportCirrus SR-20 · Willows, CAthe pilot's misjudged landing flare and improper recovery from a bounced landing.NTSB LAX06CA150Accident · No injuriesData collectionFinal reportCessna 172S · Honolulu, HIthe pilot's misjudged flare resulting in a hard landing and a porpoise pilot induced oscillation.NTSB SEA06CA093Accident · No injuriesData collectionFinal reportZenair CH 2000 · Tooele, UTThe flight instructor's inadequate supervision of the student pilot during the landing flare, which resulted in a hard landing. A contributing factor was the student pilot's failure to maintain aircraft control during the landing flare.NTSB DEN06CA069Accident · Serious injuriesData collectionFinal reportAerostar International RX 8 · Albuquerque, NMthe pilot's inability to maintain a proper descent rate due to the high winds, resulting in a hard landing. A contributing factor was the high wind conditions.NTSB DFW06LA108Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Denton, TXThe flight instructor's failure to maintain rotor RPM, resulting in a hard landing.NTSB CHI06CA132Accident · No injuriesData collectionFinal reportCessna 177B · Cleveland, OHThe pilot's misjudged flare which resulted in a bounced landing, and his inadequate recovery from the bounced landing that led to a hard landing.NTSB ATL06CA068Accident · No injuriesData collectionFinal reportCessna 172S · Gainsville, GAThe pilot's improper landing flare which resulted in a hard landing.NTSB ATL06CA062Accident · No injuriesData collectionFinal reportCessna C-172S · Sanford, NCThe pilot's improper landing flare which resulted in a hard landing.NTSB CHI06CA144Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Logansport, INThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB MIA06CA084Accident · No injuriesData collectionFinal reportLinwood R. Lawrence Van's Aircraft RV-9A · Venice, FLThe pilot's improper landing flare/touchdown which resulted in a hard landing and damage to the airplane.NTSB LAX06CA272Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Coalinga, CAthe pilot's misjudged landing flare, which resulted in a bounced landing, and his inadequate recovery technique that led to a hard landing.NTSB MIA06CA081Accident · No injuriesData collectionFinal reportWoolley John A Lancair 320 · Lakeland, FLThe pilot's improper landing flare/touchdown which resulted in a hard landing and damage to the airplane.