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 SEA95LA220Accident · No injuriesLimited investigationFinal reportHiller UH-12A · Bonners Ferry, IDThe flight instructor's misjudging his flare during a simulated autorotation.NTSB SEA95LA216Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Moab, UTThe pilot-in-command's landing long, precluding a go-around and not maintaining a proper descent rate. Factors were trees and the crosswind.NTSB CHI95FA307Accident · 1 fatalField investigationFinal reportCessna 172M · Orr, MNthe pilot misjudged the landing flare. Factors associated with the accident were the visual illusion caused by the glassy smooth water condition and the forward center of gravity.NTSB ANC95LA155Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Big Lake, AKThe pilot's failure to maintain a proper rate of descent during the approach to land, and his misjudgment of altitude to flare for landing on glassy water. The glassy water condition was a related factor.NTSB FTW95LA367Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Whitesboro, TXThe pilot's improper flare, which resulted in a hard landing.NTSB CHI95LA296Accident · No injuriesLimited investigationFinal reportBradley DQ2 · Newton, KSthe pilot's improper recovery from a bounced landing. A factor was the aircraft's inadequate handling capability.NTSB CHI95LA294Accident · No injuriesLimited investigationFinal reportCessna 152 · Ypsilanti, MIthe pilot misjudged the flare. Lack of total experience was a factor.NTSB BFO95LA084Accident · No injuriesLimited investigationFinal reportBell 47D1 · Sidney, OHthe student pilot's abrupt touchdown while landing in a field. Related factors are the student pilot's failure to attain the proper descent rate during the approach to landing, and the flight instructor's inadequate supervision of the student.NTSB NYC95LA200Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Hopedale, MAthe student pilot's improper flare and improper recovery from a bounced landing, which resulted in a loss of control and collision with a fence and a building.NTSB NYC95LA198Accident · Minor injuriesLimited investigationFinal reportBell 206B · Bingham, MEthe pilot's inadequate landing flare resulting in a hard landing and roll over, and a subsequent collision with trees.NTSB MIA95LA205Accident · No injuriesLimited investigationFinal reportBell 206B · Immokalee, FLThe pilot's improper use of the cyclic during a power-on autorotative landing (low flare), resulting in the ventral fin colliding with the ground.NTSB NYC95LA193Accident · No injuriesLimited investigationFinal reportCessna 172 · Fulton, NYthe pilot misjudged the flare, resulting in a hard landing and subsequent collapse of the nose gear.NTSB CHI95LA270Accident · Minor injuriesLimited investigationFinal reportBell 47 · Arlington Hts, ILplot misjudged the flare. The factors included the pilot getting too close to the lead helicopter, allowing his airspeed to get too slow, and encountering settling with power.NTSB FTW95LA344Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Monroe, LAThe student pilot's improper flare and the inadequate supervision by the flight instructor.NTSB ANC95LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Aniak, AKThe pilot's misjudged landing flare, which resulted in a hard landing and overload failure of the main landing gear.NTSB LAX95LA284Accident · No injuriesLimited investigationFinal reportAviat A-1 · Elko, NVthe pilot's misjudged landing flare, which resulted in a hard landing.NTSB CHI95LA262Accident · Serious injuriesLimited investigationFinal reportAerostar S-81-A · Custer, SDthe pilot's inadequate evaluation of the weather conditions.NTSB LAX95LA279Accident · No injuriesLimited investigationFinal reportMcnulty Kitfox IV 1200 · Weed, CAthe pilot's delayed application of sufficient power to arrest a high sink rate, which resulted in a hard landing. Factors in the accident were the pilot's lack of recent flight experience and the flight instructor's inadequate supervision of the flight.NTSB FTW95LA324Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Raton, NMThe pilot's inadvertent activation of the flaps. Factors in the accident were the weather conditions and the dark night.NTSB NYC95LA172Accident · No injuriesLimited investigationFinal reportCessna 172P · Teterboro, NJthe student pilot's improper flare which resulted in the airplane porpoising and the subsequent buckling of the firewall.NTSB FTW95LA314Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Center, COImproper recovery from a bounced landing by the pilot-in-command. A factor was a premature landing flare.NTSB NYC95LA165Accident · No injuriesLimited investigationFinal reportCessna 310Q · Buffalo, NYThe pilot misjudged the flare, resulting in a hard landing and subsequent collapse of the right main landing gear. Pilot fatigue was a related factor.NTSB CHI95LA254Accident · Minor injuriesLimited investigationFinal reportBeech 55 · Delavan, WIThe pilot misjudged the flare and improper recovery from a bounced landing. Lack of experience in the make and model aircraft was a factor.NTSB CHI95LA220Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Cedar Rapids, IAthe pilot's lack of experience in flying from the right seat. A factor was the steep final approach.NTSB ANC95TA102Accident · No injuriesFinal reportCessna 185C · Bettles, AKThe pilot-in-command's failure to properly judge the height of the airplane above the water during landing. Contributing to the accident were the glassy water conditions and an excessive descent rate at touchdown.NTSB NYC95LA154Accident · No injuriesLimited investigationFinal reportMooney M20J · Belmar, NJThe student pilot's (1) misjudged flare (2) inadequate recovery from a bounced landing (3) failure to maintain directional control and the certified flight instructor's inadequate supervision.NTSB FTW95LA280Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Littleton, COThe failure of the pilot to maintain control of the Balloon during landing.NTSB CHI95LA210Accident · No injuriesLimited investigationFinal reportBeech 76 · Wheeling, ILthe dual student's inadequate compensation for the wind conditions, and the CFI's inadequate supervision of the flight. A factor associated with the accident was the gusty crosswind condition.NTSB ANC95LA094Accident · No injuriesLimited investigationFinal reportBeech 36 · Chitina, AKAn inadvertent stall while on approach. The pilot-in-command's inadequate remedial action was a factor.NTSB LAX95LA237Accident · 1 fatalLimited investigationFinal reportAerostar S-77A · Davis, CAthe pilot's misjudgement of the balloon's excessive rate-of-descent in a high wind landing and her inadequate remedial action to correct the condition.NTSB CHI95LA201Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Cameron, MOThe pilot misjudged the flare and improper recovery from a bounced landing.NTSB SEA95LA124Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Renton, WAThe pilot misjudged the flare.NTSB LAX95LA208Accident · No injuriesLimited investigationFinal reportCessna 172N · North Las Vegas, NVThe pilot's improper recovery from a bounced landing. His misjudgment of the height above the runway during flare was a factor.NTSB MIA95LA146Accident · No injuriesLimited investigationFinal reportCessna 150G · Archer, FLThe pilot's improper landing flare/touchdown resulting in a hard/bounced landing, and subsequent nose over. Contributing to the accident was the pilot's improper recovery from a bounced landing.NTSB ANC95LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Manley Hot Spri, AKThe pilot's failure to correctly compensate for the existing wind conditions. The gusting wind condition was a factor.NTSB MIA95LA244Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, MSThe pilot's improper flare and/or improper recovery from a bounced landing.NTSB BFO95LA056Accident · No injuriesLimited investigationFinal reportKnoll-Bensen B-80 · Germansville, PAthe private pilot's misjudged flare, which resulted in a hard landing.NTSB CHI95LA168Accident · No injuriesLimited investigationFinal reportCessna 180D · Eveleth, MNthe pilot's improper setting of the flaps to the 30 degree position and an excessive descent rate during the landing.NTSB SEA95LA106Accident · No injuriesLimited investigationFinal reportCessna 206 · Grangeville, IDThe failure of the pilot to adequately recover from a bounced landing, and his failure to maintain directional control of the airplane during the landing roll. A factor contributing to the accident was a ditch.NTSB NYC95LA120Accident · No injuriesLimited investigationFinal reportCessna 177B · Allentown, PAthe pilot misjudged the flare, resulting in a hard, bounced landing and impact with the runway. A factor in this accident was an improper recovery from a bounced landing.NTSB FTW95LA196Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Durango, COThe student pilot's improper landing flare and improper bounced landing recovery.NTSB FTW95LA198Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Mount Pleasant, TXThe pilot's improper compensation for the crosswind component. A factor was the crosswind.NTSB ATL95LA096Accident · No injuriesLimited investigationFinal reportCessna 150M · Indian Trail, NCThe pilot's improper landing flare and improper recovery from a bounced landing.NTSB LAX95LA188Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Scottsdale, AZThe CFI's failure to apply adequate power during the flare which was a result of not maintaining the required engine and rotor rpm.NTSB LAX95LA182Accident · No injuriesLimited investigationFinal reportCessna 172N · Stockton, CAthe failure of the pilot to properly judge the landing flare, and his improper bounced landing recovery technique, which resulted in a landing gear collapse during a hard landing.NTSB MIA95LA128Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Miami, FLInadequate supervision by the CFI for allowing the student to initiate initial flare and power recovery at 100 feet instead of 40 feet and 40 feet instead of 8-10 feet respectively. Additionally, failure of the CFI to comply with the FAA approved flight…NTSB NYC95LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Old Bridge, NJThe pilot misjudged the landing flare and improperly recovered from a bounced landing.NTSB LAX95LA176Accident · 1 fatalLimited investigationFinal reportKnapp Packard Special · Wheaton Springs, CAthe pilot's misjudged altitude and landing flare timing which resulted in a hard landing and nose over.NTSB MIA95LA122Accident · No injuriesLimited investigationFinal reportCessna 172P · Clearwater, FLThe pilot-in-command's improper remedial action after the aircraft porpoised during the landing flare and touchdown.NTSB LAX95LA172Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Colt 180A · Tucson, AZthe inability of the pilot to compensate for the wind conditions which resulted in the basket tipping over following touchdown during a high-wind landing.