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 CHI96LA275Accident · No injuriesLimited investigationFinal reportBeech V35B · Walker, MNfailure of the pilot to properly flare the airplane for landing, and her improper recovery from a bounced landing.NTSB ANC96LA114Accident · No injuriesLimited investigationFinal reportCessna 185 · Wainwright, AKThe pilot's excessive application of the brakes during the landing roll.NTSB SEA96LA174Accident · No injuriesLimited investigationFinal reportCessna 182B · Metaline Falls, WAthe pilot's improper flare and improper recovery from a bounced landing. The inadvertent porpoise was a related factor.NTSB MIA96LA196Accident · No injuriesLimited investigationFinal reportCessna 150M · Knightdale, NCthe student pilot's improper recovery from a bounced landing by applying power and slight nose up elevator input.NTSB IAD96LA119Accident · No injuriesLimited investigationFinal reportCessna 172M · Tremont City, OHthe student pilot's misjudged flare which resulted in a hard landing.NTSB NYC96LA153Accident · Serious injuriesLimited investigationFinal reportKolb Mark III · Gowanda, NYfailure of the pilot to properly flare the airplane during the landing.NTSB MIA96LA184Accident · No injuriesLimited investigationFinal reportCessna 172M · Orlando, FLthe student pilot's improper level off during landing.NTSB FTW96LA308Accident · No injuriesLimited investigationFinal reportDearinger Duce · Corning, ARThe pilot's failure to arrest his rate of descent and his improper recovery from a bounced landing.NTSB SEA96LA150Accident · No injuriesLimited investigationFinal reportCessna 150 · Puyallup, WAimproper flare by the pilot during a touch-and-go landing.NTSB FTW96LA303Accident · No injuriesLimited investigationFinal reportRaven Ralley RX7 · Gunnison, COthe pilot's inadequate weather evaluation. A factor was the high wind.NTSB NYC96LA138Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Wolfeboro, NHThe pilot's improper flare, which resulted in a hard landing and nose over. The glassy water condition was a related factor.NTSB SEA96LA139Accident · No injuriesLimited investigationFinal reportAgusta A109 · Newport, ORthe pilot's failure to adequately compensate for the gusty wind condition during the landing. The gusty wind was a related factor.NTSB NYC96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeport, CTthe student pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB LAX96LA250Accident · No injuriesLimited investigationFinal reportCessna 172 · Camarillo, CAthe student pilot misjudged the landing flare resulting in a hard landing. A factor in the accident was high airspeed.NTSB FTW96LA283Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tulsa, OKThe student pilot's improper flare during the landing, which resulted in a collapsed nose gear, ground swerve, and collision with an object.NTSB FTW96LA277Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Providence, LAthe pilot's improper flare and improper recovery from a bounced landing, which resulted in an inadvertent porpoise motion of the airplane and subsequent damage.NTSB NYC96LA132Accident · No injuriesLimited investigationFinal reportCessna 140A · Edinboro, PAThe pilot's improper flare, which resulted in a hard landing and subsequent nose over. The tailwind was a related factor.NTSB IAD96LA101Accident · No injuriesLimited investigationFinal reportCessna 182P · White Marsh, MDThe pilot's improper flare which resulted in a hard landing. A related factor was the pilot's improperly planned approach.NTSB MIA96LA158Accident · Minor injuriesLimited investigationFinal reportAeronca 11-AC · Green Cove Spgs, FLThe pilot's improper planning/decision by failing to ensure that the airplane would be able to clear obstructions at the end of the runway, while taking off with a tailwind component; and his failure (or inability) to flare the airplane after turning back to…NTSB LAX96LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Avalon, CAthe pilot's failure to initiate a landing flare, which resulted in a bounced landing and porpoise, and his loss of directional control during an attempt to initiate a go-around with insufficient airspeed, which resulted in an inadvertent stall/mush and…NTSB FTW96LA256Accident · No injuriesLimited investigationFinal reportCessna R172K · Watkins, COan improper flare by the pilot, which resulted in a hard landing.NTSB NYC96LA127Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Fulton, NYthe student pilot's improper flare and the flight instructor's inadequate supervision.NTSB LAX96LA246Accident · No injuriesLimited investigationFinal reportCessna 172M · Sedona, AZthe pilot's improper recovery from a bounced landing. The variable/gusty/quartering tail wind was a related factor.NTSB FTW96LA245Accident · No injuriesLimited investigationFinal reportBeech 23 · Weiner, ARan improper flare by the pilot, which resulted in a hard landing.NTSB MIA96LA155Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Wayside, MSFailure of the pilot to maintain the proper descent rate at touchdown resulting in collapse of the right main landing gear.NTSB MIA96LA152Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · San Juan, PRFailure of the student pilot to maintain the proper descent rate resulting in a hard landing. Contributing to the accident was: the failure of other maintenance personnel to remove tape that was placed by company personnel over each static port before washing…NTSB MIA96LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Crestview, FLFailure of the pilot-in-command to maintain the proper descent rate on landing resulting in separation of the nose landing gear after touchdown. Contributing to the accident was the pilot's lack of experience in the type of operation.NTSB LAX96LA237Accident · No injuriesLimited investigationFinal reportCessna 172N · Ramona, CAthe pilot's misjudged and delayed landing flare, and inadequate recovery technique from a bounced landing (porpoise). Sun glare was a factor in the accident.NTSB FTW96LA233Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Longview, TXan improper flare by the pilot rated student, while landing with a tailwind; and inadequate supervision by the flight instructor.NTSB CHI96LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · Troy, MIthe pilot's failure to maintain directional control of the airplane while recovering from a bounced landing. Factors associated with the accident were the misjudged landing flare and the raised taxiway edge which the airplane contacted.NTSB LAX96LA208Accident · No injuriesLimited investigationFinal reportBoeing B75-A75N1 · Page, AZthe pilot's improper flare, improper recovery from a bounced landing, inadequate compensation for wind conditions, and failure to maintain directional control of the airplane, while landing in gusty/crosswind conditions. The gusty, crosswind condition was a…NTSB SEA96LA101Accident · No injuriesLimited investigationFinal reportCessna 177 · Corvallis, ORfailure of the pilot to properly judge the distance and altitude to the runway just before touching down, and his premature flare for landing. Factors relating to the accident were: the presence of sun glare during the landing, and the resultant degradation…NTSB NYC96LA120Accident · No injuriesLimited investigationFinal reportCessna 150L · Matawan, NJthe student pilot's improper flare and improper recovery from a bounced landing. The gusty wind condtion was a related factor.NTSB LAX96FA206Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-11 · Los Angeles, CAthe crew's failure to maintain the proper approach airspeed and rate of descent. Contributing to the accident was the crew's failure to follow the checklist and inadequate supervision by the pilot-in-command.NTSB LAX96LA202Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Kernville, CAthe pilot's inadequate compensation for the downdraft condition and subsequent failure to maintain a proper rate of descent.NTSB FTW96LA217Accident · No injuriesLimited investigationFinal reportCessna 182J · Jacksonville, TXthe pilot's inadequate compensation for the wind conditions. A factor was the gusting wind conditions.NTSB IAD96LA084Accident · No injuriesLimited investigationFinal reportCessna 172M · Findlay, OHthe student pilot's misjudged flare during landing.NTSB CHI96LA159Accident · No injuriesLimited investigationFinal reportCessna 140 · Brooklyn, MIthe pilot's improper use of brakes during the landing. Factors relating to the accident were: the pilot's improper flare and improper recovery from a bounced landing, and the soft runway condition.NTSB ATL96LA086Accident · No injuriesLimited investigationFinal reportCessna 172 · Winston-Salem, NCThe pilot's improper use of the elevator in response to a bounced landing.NTSB LAX96LA209Accident · No injuriesLimited investigationFinal reportCessna 172 · Marana, AZthe pilot's improper flare and improper recovery from a bounced landing.NTSB CHI96LA153Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Layfayette, INthe pilot's improper flare and improper recovery from a bounced landing.NTSB ANC96LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairbanks, AKThe student pilot's premature flare and the flight instructor's failure to perform remedial action prior to the hard landing.NTSB LAX96FA185Accident · Serious injuriesField investigationFinal reportRobinson R22 · Santa Ana, CAthe pilot misjudged the helicopter's distance and altitude and failed to attain the proper descent rate.NTSB NYC96LA093Accident · No injuriesLimited investigationFinal reportCessna 172P · Rutland, VTthe pilot's improper flare and recovery from a bounced landing. A contributing factor was his lack of recent flight experience.NTSB ANC96LA057Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe pilot's inadequate compensation for the wind conditions. A factor in the accident was the gusty wind conditions.NTSB FTW96LA191Accident · No injuriesLimited investigationFinal reportCessna 172P · Denton, TXthe student pilot's delayed landing flare and his improper bounced landing recovery technique.NTSB FTW96LA185Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Alice, TXthe student pilot's improper landing flare and improper bounced landing recovery.NTSB FTW96LA176Accident · Serious injuriesLimited investigationFinal reportRaven S-66A · San Antonio, TXThe pilot's inadequate briefing of his passengers. A factor was the high wind.NTSB NYC96LA086Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Linden, NJimproper flare by the pilot, and his failure to take proper corrective action after the helicopter touched down hard and entered ground resonance.NTSB SEA96LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Cheyenne, WYthe pilot's improper flare during the landing and improper recovery from the subsequent bounced landing. A factor relating to the accident was: the pilot's failure to maintain the proper approach path during the approach for landing.