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 NYC89LA131Accident · Serious injuriesLimited investigationFinal reportAdams Unknown · Soleburg, PAThe pilot's inadequate weather evaluation which resulted in delaying the precautionary landing. Factors contributing to the accident included high winds and the lack of restraining devices inside the basket to help the occupants remain inside.NTSB NYC89LA130Accident · No injuriesLimited investigationFinal reportCessna C182Q · Beaver Falls, PAThe pilot failure to properly flare the airplane during landing and the improper recovery from a bounced landing.NTSB NYC89LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Hanover, PAThe failure of the student pilot to maintain airspeed and directional control during an attempted go around.NTSB FTW89LA084Accident · No injuriesLimited investigationFinal reportCessna 150 · San Antonio, TXImproper flare by the pilot, his delay in attempting to abort the landing, and his failure to maintain directional control. A factor related to the accident was: the pilot's failure to attain the proper touchdown point for a landing.NTSB DEN89LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Ogden, UTThe student pilot's improper flare which resulted in a hard landing & separation of the nose landing wheel. Contributing to the accident was the pilot's lack of total experience.NTSB FTW89LA080Accident · No injuriesLimited investigationFinal reportCessna 182Q · Leakey, TXThe pilot's improper compensation for wind conditions, improper flare, and improper recovery from a bounced landing. Factors related to the accident were: the gusty wind condition and the pilot's lack of experience in this make and model of aircraft.NTSB MKC89LA092Accident · No injuriesLimited investigationFinal reportVestal Quickie Q2 · St Joseph, MOThe pilot's improper flare and failure to maintain directional control of the aircraft. A factor related to the accident was: the pilot's lack of experience in this make and model of aircraft.NTSB NYC89LA118Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · W.Mifflin, PAThe improper level off of the aircraft by the pilot which resulted in a hard landing and subsequent gear collapse.NTSB DEN89LA100Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Cheyenne, WYFailure of the pilot-in-command to properly recover from a bounced landing.NTSB LAX89LA142Accident · No injuriesLimited investigationFinal reportBeech C24R · Tucson, AZPilot misjudged the landing. The pilot began his flare too high above the runway resulting in a hard landing.NTSB ATL89LA120Accident · No injuriesLimited investigationFinal reportCessna 150L · Bowling Green, OHThe student pilot failed to maintain control of the aircraft when he misjudged the height of the landing flare. The recovery from the bounced landing was inadequate and the nose gear collapsed upon impact with the runway.NTSB LAX89LA149Accident · No injuriesLimited investigationFinal reportCessna 182Q · Eureka, CAThe pilot's improper flare during the landing.NTSB DEN89LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Garrison, NDImproper flare by the student and inadequate supervision of the flight by the CFI which damaged the nose gear and restricted movement of the nosewheel steering and rudder control.NTSB SEA89LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Tacoma, WAThe pilot's improper flare and improper recovery from the bounced landing. Contributing factors were the pilot's low total flight time and his inexperience in the Cessna 180 airplane.NTSB LAX89LA309Accident · No injuriesLimited investigationFinal reportHughes 269C · Mesa, AZImproper flare by the student pilot, and improper supervision by the instructor pilot (CFI).NTSB MKC89LA084Accident · No injuriesLimited investigationFinal reportCessna 177 · Fort Dodge, IAThe failure of the pilot to adequately compensate for existing wind conditions, to flare properly, and to recover properly from a bounced landing. The gusty x-wind conditions contributed to the accident.NTSB SEA89LA067Accident · No injuriesLimited investigationFinal reportCessna TU206 · Anacortes, WAThe pilot diverted his attention during the landing, which resulted in an improper flare & hard landing. His lack of recent flying experience was a related factor.NTSB ATL89LA109Accident · No injuriesLimited investigationFinal reportCessna 182Q · Pickens, SCImproper flare by the pilot and inadequate supervision of the flight by the other crew member.NTSB MIA89LA104Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · St Augustine, FLInadvertently retraction of the landing gear, and failure of the instructor pilot (CFI) to note that the gear had been retracted. A factor related to the accident was: improper flare by the student pilot.NTSB CHI89LA060Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · West Chicago, ILImproper flare by the pilot. The crosswind (quartering headwind) was considered to be a factor.NTSB CHI89LA056Accident · No injuriesLimited investigationFinal reportCessna TR182 II · Sandwich, ILThe pilot's poor handling of the aircraft, improper flare and inadequate recovery from a bounced landing.NTSB MKC89LA071Accident · No injuriesLimited investigationFinal reportCessna 310 · Des Moines, IAThe failure of the pilot to properly flare the airplane. Contributing to the accident were the weather conditions.NTSB FTW89DQA03Accident · No injuriesFinal reportBurkhart Grob G109B · El Paso, TXPilot in command's loss of control due to overcontrolling the aircraft. The situation was proceeded by a high sink rate that resulted in a hard landing with an inadequate recovery from a bounced landing. Contributing to the accident was the pilot's…NTSB LAX89LA107Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Deer Valley, AZThe pilot's failure to raise the wing flaps during the aborted landing, and his failure to maintain airspeed during the climbing right turn.NTSB MIA89LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLFailure of the pilot to flare for landing and improper recovery from a bounced landing.NTSB SEA89LA037Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Port Townsend, WAImproper approach and flare technique on the part of the pilot, resulting in a hard landing. Contributing to the accident were tall trees surrounding the airstrip.NTSB ATL89DEK01Accident · No injuriesFinal reportCessna 182Q · Columbus, OHThe pilot's improper flared and improper recovery from a bounced landing. A factor related to the accident was: the gusty wind condition.NTSB ANC89LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Port Lions, AKThe pilots inadequate compensation for wind conditions which resulted in a stall/mush and subsequent hard landing. The downdraft which the aircraft encountered was a factor in the accident.NTSB NYC89LA070Accident · No injuriesLimited investigationFinal reportCessna 150L · Shirley, NYA poorly planned final approach, an improper landing flare, and failure of the pilot to correct a bounced landing.NTSB DEN89LA052Accident · No injuriesLimited investigationFinal reportBeech 19 · Santa Fe, NMThe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB ANC89LA025Accident · No injuriesLimited investigationFinal reportCessna 207 · Kotzebue, AKThe air taxi pilot stated that he had encountered freezing drizzle and other icing conditions prior to landing, accumulating approximately 3/8' of ice on the airplane. He said that as he began his landing flare, the airplane stalled, and he was unable to…NTSB MKC89LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Creve Coeur, MOThe student pilot said that after practicing locally and returning to the base airport, he discovered the winds to be greater than anticipated. On his third attempt to land, he bounced twice, then lost control and hit nose first on the runway. An eighty…NTSB MIA89IA052Incident · Minor injuriesIncident investigationFinal reportCessna 150 · Naples, FLTower personnel observed the acft on a high fast final apch. They stated that it appeared the acft was forced on the rwy, where it hit on the nosewheel & bounced back into the air. On the 2nd contact with the rwy, the nosewheel fork split & the nosewheel…NTSB DEN89LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Watkins, COThe student plt was practicing touch and go landings during an unsupervised solo flight. Runway 26 was in use, with winds reported as 320 deg at 5 KTS. At the first landing, the acft touched down nose first, thirty feet left of the center line. The acft…NTSB ATL89FA051Accident · No injuriesField investigationFinal reportBell 206B · Pinson, ALTwo FAA inspectors were conducting currency training when the helicopter landed hard during a practice power recovery autorotation. The pilot had delayed in applying power and collective pitch. Upon contact with the ground, all engine instruments indicated…NTSB BFO89LA013Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Washington, DCPilots failure to maintain control of the airplane during a touch and go landing.NTSB ATL89LA041Accident · No injuriesLimited investigationFinal reportCessna 150M · Toledo, OHThe airplane was found wrecked on an airport taxiway when airport personnel reported for duty in the morning. It had been stolen from the blue horizon flying club at the airport and, according to the hobbs meter, had been operated for about 0.4 hours since…NTSB MIA89IA035Incident · No injuriesIncident investigationFinal reportBoeing 707-355C · Sanford, FLThe non-type rated FAA flight test engineer executed a visual approach and was observed to be erratic and flying at v-ref when he chopped the power at 50 ft AGL and the aircraft landed hard. The instructor pilot then took control of the aircraft and executed…NTSB LAX89LA037Accident · No injuriesLimited investigationFinal reportCessna 150 · Madera, CAThe pilot stated that on the last landing, the airplane touched down hard. Subsequently, the nose gear collapsed & the airplane went off the left side of the runway. There were no reported mechanical failures or malfunctions with the airplane prior to the…NTSB MIA89LA021Accident · No injuriesLimited investigationFinal reportCessna 182J · Okeechobee, FLThe plt rprtd that while landing at night, the acft bounced twice. Subsequently, it went off the rwy & onto a grass area. During the occurrence, the nose gear collapsed.NTSB MKC89LA016Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Davenport, IAWhile demonstrating an autorotation touchdown, a tailboom strike was experienced. Damage was incurred to the tailboom, the tail rotor drive shaft, and one main rotor blade. The CFI said everthing felt normal during touchdown and believed the soft terrain…NTSB SEA89LA014Accident · No injuriesLimited investigationFinal reportCessna 150G · Post Falls, IDThe plt rprtd that due to the airstrip conds, he was making a low, flat apch. He was using carb heat. When power application became necessary, just before landing, the eng did not respond immediately. The plt maintained a nose high attitude to avoid obstacles…NTSB ANC89LA013Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Ivanof Bay, AKThe pilot was attempting to land on a 30 foot wide, 1200 foot gravel strip in gusty wind conditions. He said just prior to touchdown, the airplane encountered a strong gust of wind resulting in a hard landing short of the runway. The left main landing gear…NTSB MKC89LA009Accident · No injuriesLimited investigationFinal reportCessna 140 · Lawrence, KSThe plt elected to terminate a local flt due to windy, turbulent conditions aloft. He initiated a landing in a slight crosswind that he rprtd was gusting to 20 knots. Drg the landing, he lost control & the acft touched down hard in a nose low attitude.…NTSB LAX89LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Petaluma, CADuring a telephone interview, the pilot stated that she was attempting a touch and go landing when the airplane landed hard on its nosewheel. She lost directional control and the airplane collided with a hangar. There were no problems with the nosewheel…NTSB CHI89LA019Accident · No injuriesLimited investigationFinal reportCessna 182 · Pekin, ILThe pilot reported that he attempted to make a 'wheels' landing in the Cessna 182 (tricycle gear), and made a hard landing on the turf runway. The pilot aborted the landing, requested emergency equipment and circled the airport until the emergency equipment…NTSB CHI89DEC01Accident · No injuriesFinal reportExperimental Barracuda · Ypsilanti, MIPilot's failure to maintain control of the aircraft during landing and inability to appropriately correct for the porpoise action of the aircraft.NTSB CHI89LA006Accident · No injuriesLimited investigationFinal reportBeech 55B · Quincy, ILThe pilot in command's failure to maintain control of the aircraft and to take appropriate action to correct the porpoise.NTSB ATL89LA011Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Hatteras, NCThe plt reported that he initially flared too high during the landing. He recovered and the acft subsequently touched down 'firmly' on the main gear. The acft then began to veer to the rt 'as if the rt brake was locked'. The plt attempted to abort the ldg &…NTSB LAX89LA007Accident · No injuriesLimited investigationFinal reportHughes 269C · Fontana, CAThe pilot was demonstrating a run-on landing for his passenger when the accident occurred. The pilot reported that he allowed the tail of the helicopter to get too low and it collided with the terrain. There were no mechanical difficulties reported prior to…