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 DEN90LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Three Forks, MTPilot's misjudged landing flare.NTSB LAX90LA121Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Canyon Lake, CAThe pilot to maintain proper rotor RPM during a practice autorotation. Contributing to the accident was the uneven terrain selected by the pilot to conduct practice touch maneuvers.NTSB MIA90LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Clearwater, FLThe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise and loss of aircraft control. Factors related to the accident were: the gusty crosswind, and failure of the pilot to maintain runway alignment.NTSB MKC90LA060Accident · No injuriesLimited investigationFinal reportCessna 140 · Brinkley, ARRecovery from bounced landing not performed and porpoise encountered by the pilot in command.NTSB ATL90LA065Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Chamblee, GAThe pilot misjudged the landing flare. Contributing to the accident was the pilot's failure to defrost the windshield during the approach.NTSB FTW90LA066Accident · No injuriesLimited investigationFinal reportCessna 180 · Portland, TXThe pilot's inadequate compensation for wind conditions, which resulted in a failure to attain a flare during the landing. The unfavorable wind conditon was a related factor.NTSB LAX90LA079Accident · No injuriesLimited investigationFinal reportCessna 152 · Bermuda Dunes, CAThe student pilot's improper flare, and failure to avoid or correct the resultant porpoise.NTSB LAX90LA069Accident · No injuriesLimited investigationFinal reportCessna 172 · Mesa, AZThe failure of the pilot to maintain directional control and compensate for gusty wind conditions which resulted in a hard landing.NTSB CHI90LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Steubenville, OHThe student pilot's improper landing flare.NTSB MIA90LA045Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Sarasota, FLExcessive airspeed for landing and improper flare by the pilot, which resulted in an inadvertent porpoise; and the pilot's improper recovery from a bounced landing, which resulted in a hard landing. A related factor was the crosswind condition.NTSB FTW90DRD01Accident · No injuriesFinal reportLong E-Z-E Long E-Z-E- · Hammond, LAInadequate aircraft handling and recovery from a bounced landing. Factors were gusty wind conditions, the pilot's failure to maintain directional control, and the pilot's lack of familiarity with the airplane.NTSB BFO90LA018Accident · No injuriesLimited investigationFinal reportBeech BE-24 · Martinsville, VAThe pilot failed to maintain adequate airspeed, causing the aircraft to stall and land hard.NTSB ATL90LA039Accident · No injuriesLimited investigationFinal reportBeech B19 · Muscle Shoals, ALThe premature flare initiated by the student pilot and the flight instructor's delay in taking remedial action, which led to an inadvertent stall and a hard landing.NTSB LAX90LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Big Bear, CAThe pilot's improper level-off and improper recovery from a bounced landing.NTSB FTW90LA026Accident · No injuriesLimited investigationFinal reportCessna 172K · Fabens, TXThe pilot's improper flare during landing and inadequate recovery from the ensuing bounced landing. The unfavorable wind was a related factor.NTSB CHI90LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Mcleansboro, ILThe pilot-in-command's failure to maintain control of the aircraft while recovering from a bounced landing.NTSB SEA90LA012Accident · No injuriesLimited investigationFinal reportMcCulloch J-2 · Scappoose, ORDelayed remedial action by the flight instructor and failure of the student to relinguish control. Factors include inadequate airspeed and an excessive descent rate.NTSB MKC90LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Hays, KSThe pilot's failure to properly flare the airplane during landing.NTSB LAX90LA053Accident · No injuriesLimited investigationFinal reportCessna 177 · Tucson, AZImproper flare by the student pilot, which resulted in a porpoise, and his improper recovery from a bounced landing.NTSB DEN90LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDThe pilot's improper flare and improper recovery from a bounced landing. The wind condition was considered to be a contributing factor.NTSB CHI90LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHThe pilot's improper flare and recovery from a bounced landing.NTSB CHI90LA008Accident · No injuriesLimited investigationFinal reportBeech C23 · Rock Falls, ILImproper flare by the pilot, which resulted in a hard landing.NTSB CHI90LA004Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHThe student pilot's improper flare and improper recovery from a bounced landing.NTSB FTW90LA003Accident · No injuriesLimited investigationFinal reportAerospatiale 350D · New Iberia, LAThe second pilot's (under instruction) misjudgement of aircraft attitude during the level off phase of the autorotationNTSB LAX90LA001Accident · No injuriesLimited investigationFinal reportCessna 501 · Sedona, AZImproper in-flight planning/decision by the pilot which resulted in his inability to flare the aircraft and/or recover from a bounced landing. Contributing factors were: crosswind, gusts, turbulence, downdraft, and the pilot's inadequate compensation for wind…NTSB LAX89LA332Accident · No injuriesLimited investigationFinal reportCessna 182 · Eureka, CAImproper flare by the student, and a delay in remedial action by the instructor (CFI).NTSB SEA89LA177Accident · Minor injuriesLimited investigationFinal reportBell 47G · Corvallis, ORStudent pilot's improper use of the collective control while performing hovering autorotations, and the instructor's inadequate supervision of the student's actions, which resuled in hard landings. In addition, the engine mount was significantly weakened…NTSB FTW89LA173Accident · No injuriesLimited investigationFinal reportBeech B-19 · Mckinney, TXPilot's improper technique in recovery from a bounced landing. Factors contributing to the accident were the pilot's failure to maintain directional control during the go around.NTSB CHI89LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lebanon, OHThe pilot allowed his final approach airspeed to get too slow, he delayed in initiating remedial action, then attempted an aborted landing with inadequate airspeed, which resulted in an inadvertent stall. The pilot's lack total experience was considered a…NTSB CHI89LA188Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wash Courthouse, OHImproper flare by the student pilot. Factors related to the accident were: the student's selection of the wrong runway, and the tailwind.NTSB MIA89LA254Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Fort Myers, FLThe pilot's improper flare and improper recovery from a bounced landing. Darkness was a related factor.NTSB SEA89LA172Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Hillsboro, ORThe pilot misjudging altitude and airspeed.NTSB CHI89LA181Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · South Haven, MIImproper flare by the pilot, which resulted in a hard landing.NTSB NYC89LA210Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · South Harpswell, MEA delay by the pilot in aborting a late go-around. Factors related to the accident were: the pilot's improper flare for landing, his improper recovery from the subsequent bounced landing, and tree(s) near the runway.NTSB LAX89LA301Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Torrance, CAThe student pilot's improper flare and improper recovery from a bounced landing, which resulted in an inadvertent porpoise. A factor related to the accident was: the lack of training in recovery from bounced landings from her instructor pilot (CFI).NTSB MKC89LA195Accident · No injuriesLimited investigationFinal reportBell 47G · Ozark, MOThe failure of the dual student to properly flare during an autorotative landing resulting in a hard landing and partial failure of the right skid. The CFI also failed to properly monitor the student's actions on the flight controls.NTSB FTW89LA158Accident · No injuriesLimited investigationFinal reportCessna 172M · Bellville, TXImproper flare by the pilot and his improper recovery from a bounced landing, which resulted in an inadvertent porpoise and subsequent nose gear failure.NTSB ATL89LA210Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Hanceville, ALImproper flare by the pilot/owner and his failure to obtain/maintain proper airspeed for the go-around; and inadequate supervision and remedial action by the instructor pilot (other crew member). The uneven surface of the private strip was a contributing…NTSB DEN89LA211Accident · No injuriesLimited investigationFinal reportCessna 182L · Moab, UTInadequate compensation for the wind conditions by the pilot, and his failure to attain a flare. The unfavorable (variable & gusty) wind condition was a related factor.NTSB MIA89LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, MSThe pilot's improper flare and improper recovery from a bounced landing, which resulted in porpoising of the aircraft and an uncontrolled ground swerve.NTSB LAX89LA290Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Columbia, CAThe pilot's improper recovery from a bounced landing and loss of directional control.NTSB FTW89LA153Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Jonesboro, LAThe pilot's improper flare, improper recovery from a bounced landing, and failure to maintain directional control, which resulted in a porpoise off the side of the runway. The tree was a related factor.NTSB NYC89LA200Accident · No injuriesLimited investigationFinal reportCessna 182F · Albany, NYThe pilot's improper flare during landing.NTSB CHI89LA175Accident · Minor injuriesLimited investigationFinal reportCessna 182A · East Lansing, MIImproper corrective action on the part of the pilot to correct an excessive sink rate prior to landing touchdown.NTSB NYC89LA201Accident · No injuriesLimited investigationFinal reportCessna 182R · Warren, VTImproper flare by the pilot, and his improper recovery from a bounced landing.NTSB FTW89LA150Accident · No injuriesLimited investigationFinal reportBell 206B · Oak Grove, LAPilot's improper emergency procedures and flare that led to a hard landing and roll over. Factors in the accident were the pilot's decision to initiate an autorotation following an undetermined event and failure to maintain directional control during the…NTSB SEA89LA150Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20BL · Minden, NVMisunderstood emergency procedures, the glider pilot released from the tow which resulted in a hard landing. The pilot's preflight of the glider and radio communications were inadequate before and during the flight.NTSB CHI89FA165Accident · Serious injuriesField investigationFinal reportBell 47G-2A-1 · Wisconsin Dells, WIAttempt by the pilot to exceed the hover performance capabilities of the helicopter, and operating outside the weight and balance limitations. The pilot's overconfidence in the helicopter's ability and his subsequent failure to adequately prepare and plan…NTSB LAX89LA272Accident · No injuriesLimited investigationFinal reportCessna 172P · Redlands, CAThe pilot's improper level-off, recovery from bounced landing, and failure to maintain directional control during the landing. The pilot's limited recent experience was a contributing factor.NTSB CHI89LA168Accident · No injuriesLimited investigationFinal reportCessna P206A · Louisville, OHThe pilot's improper flare for landing.