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 ATL87LA008Accident · No injuriesLimited investigationFinal reportBeech C23 · Middlefield, OHStudent plt stated that he was preparing to land after a business x-country flt. On downwind he noted the wind sock ind a x-wind. Made a long final and did not notice x-wind. Stated that at flare he seemed to have a little tailwind since his spd was 85 KTS…NTSB MIA87FA009Accident · Serious injuriesField investigationFinal reportCessna 152 · Hattiesburg, MSThe student plt was on a supervised solo flt. He stated that he had always been 'scared' of landings & when he returned to the airport to land, the wind sock was standing 'straight out.' He later stated that he intended to continue flying and thought that he…NTSB NYC87LA019Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Leroy, NYFlight instructor simulating an emergency landing, landed on main landing gears and tail. Aircraft veered to the right off the runway and collided with bushes.NTSB DEN87LA006Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Price, UTThe student plt was on a solo cross-country flt. She stated that on landing, the acft ballooned. She initiated a go-around and during the climbout, the acft began to settle. It drifted off to the side of the rwy and the wing tip struck the ground. The acft…NTSB NYC87LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · So. Dayton, NYThe student pilot came in long and high, bounced the aircraft a few times. The nose wheel collpased and the aircraft was substantially damaged.NTSB LAX86DVM07Accident · No injuriesFinal reportWalter D. Burleson KR-2 · Hollister, CADuring a first proving flt for the experimental homebuilt, the pilot said the aircraft 'hit hard' during the landing, bounced and came down on the left wing and nose. According to the pilot, he had accrued less than an hour of flight time in the accident…NTSB DCA86IA001Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-51 · Raleigh-Durham, NCDrg arrival, the flt crew made a visual apch to rwy 23L in calm wind conds. Flt crew statements indicated that when they were on final apch at about 100 ft AGL, the acft was on the proper glidepath for landing. However the resulting grnd contact was harder…NTSB DEN86LA257Accident · No injuriesLimited investigationFinal reportBeech V35 · Albuquerque, NMThe plt landed hard at the abq municipal arpt. The plt said he had runaway trim causing loss of control. The pax felt the plt lost control due to temporary physical incapacitation. Exam of the flt control system revealed no evidence of a flt control system…NTSB MKC86LA191Accident · Serious injuriesLimited investigationFinal reportBarnes AX-7 · Creston, IAThe pilot of the hot air balloon made a landing that was hard enough to break her right ankle. The pilot stated the accident possibly could have been avoided if she had been wearing hightop shoes with laces.NTSB LAX86LA341Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Mesa, AZAt the end of the first leg of a solo cross-country flight the plt experienced a hard landing and the acft porpoised. On the second bounce the plt added power. The acft then bounced a third time collapsing the nose gear.NTSB NYC86LA242Accident · No injuriesLimited investigationFinal reportCessna 172 · Seven Springs, PAPilot came in long and high for landing, attempted to land then decided to abort due to insufficient runway remaining. The aircraft continued off the end of the runway.NTSB CHI86FEE07Accident · Minor injuriesFinal reportMurphy LONG-EZE · Princeton, ILThe pilot stated that he held the aircraft in a crabbed attitude throughout the touchdown phase of landing to compensate for a crosswind condition. On touchdown the nose and main landing gear collapsed and the aircraft slid on its belly for approximately 330…NTSB LAX86LA345Accident · No injuriesLimited investigationFinal reportCessna 150 · Modesto, CAAt the end of one leg of a solo cross-country flight the student pilot experienced a hard landing which resulted in a porpoise on the rwy. The pilot did not realize the severity of the initial bounce and tried to re-flare the aircraft without adding power.…NTSB ATL86LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Smithfield, NCThe pilot reported that during a practice landing he flared too high off the runway surface. The pilot lowered the nose, causing the nosewheel to strike the runway. The pilot lost control and the acft skidded off the left side, down an embankment and flipped…NTSB BFO86FIG03Accident · No injuriesFinal reportChampion 7FC · Baltimore, MDThe acft was observed to touch down hard on the sod rwy, bounce into the air, and come back down on the left main and nose wheel. The nose wheel fork broke and the nose wheel departed the acft. The acft continued to slide for aprx 24 ft after which time it…NTSB NYC86LA222Accident · No injuriesLimited investigationFinal reportCessna 170B · Danbury, CTThe aircraft bounced on touchdown, but then settled back to the runway with the tail swinging to the left. Hard left brake was applied but the pilot could not maintain direction control and the aircraft ran off the runway into the turf striking the left wing…NTSB LAX86LA333Accident · No injuriesLimited investigationFinal reportCessna 182R · Kernville, CAThe plt stated he made a hard landing and the acft bounced. After taxiing the acft to parking it was discovered that substantial damage was sustained. The plt also indicated that the winds at the time were calm.NTSB DEN86LA240Accident · No injuriesLimited investigationFinal reportCessna 170B · Greeley, COPlt was ferrying acft from glenwood springs, CO to troy, MO. Acft was out of annual (3-84) and a special airworthiness certificate was issued. Plt likewise had not flown for 2 years. Plt accomplished the mandatory biennial flight review the day before the…NTSB BFO86LA043Accident · No injuriesLimited investigationFinal reportPiper 601P · Indian Head, MDThe owner of the Aerostar 601P was flying his family and a friend from bedford, Massachusetts to Indian Head, Maryland. After monitoring the dca ATIS he elected to make an ILS to fort belvoir, Virginia, break off the missed approach and proceed VFR over to…NTSB CHI86LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Galesburg, ILThe non-instrament rated pilot, landing in IFR conditions, flared too high resulting in a hard landing, nose gear failure and buckling of the engine mounts.NTSB CHI86LA204Accident · No injuriesLimited investigationFinal reportCessna 182G · Chesaning, MIThe pilot was making his first landing to a sod runway. While decelerating over the runway at about 6' AGL. The aircraft began to sink rapidly. He added power, but the landing gear hit hard and the aircraft bounced several feet back into the air. He added…NTSB FTW86LA153Accident · No injuriesLimited investigationFinal reportCessna 206 · Ardmore, OKThe pre-solo student pilot had taken the aircraft without the owner's permission. He flew around the area for approximately 30 minutes before returning to the airport. After a hard landing, the nose wheel tire blew causing the nose wheel to collapse. The…NTSB NYC86LA204Accident · No injuriesLimited investigationFinal reportHughes 369HS · Norwood, MAThe plt was practicing an autorotation from a closed traffic pattern to the numbers on rwy 35. He rprtd that he made a normal flare & power recovery. However, as the helicopter was nosing forward out of the flare, the plt heard a noise & felt a percussion…NTSB NYC86LA203Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Hazleton, PAThe Bell 47G2 made a hard landing in a field. The main rotor contacted the tail rotor and boom. The helicopter received substantial damage and the pilot received minor injuries. On scene examination revealed no evidence of any defect or malfunction of the…NTSB ATL86LA214Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Lenoir, NCThe student plt was executing full stop landings then making a take off after each landing. He was attempting his fourth landing when the acft bounced, he applied power to try to regain control of the acft. The nose gear collapsed upon touch down, the strut…NTSB DEN86LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Monument Valley, UTThe plt was landing on a 3100 ft dirt rwy, at an arpt with mtns nearby. He said that just before landing, the acft encountered a downdraft at about 100 ft AGL & 'the bottom fell out.' Subsequently, the acft landed hard & the rgt main lndg gear failed. There…NTSB CHI86LA190Accident · No injuriesLimited investigationFinal reportBeech B-19 · Manchester, MIThe pilot states, that on flare out the aircraft ballooned and then settled, sustaining a hard landing. The nose gear failed upon touchdown.NTSB CHI86LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Traverse City, MIWhile flaring to land, the aircraft had excessive speed and ballooned. Subsequently, it bounced twice, then began to veer to the left. The pilot performed a go-around. During the initial portion of the go-around, the left wing struck a runway edge identifier…NTSB SEA86LA175Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAStudent pilot, with about 2 hours solo time, was making touch and go's. during the last landing the aircraft was observed to make several bouncing contacts with the runway before the nose gear collapsed.NTSB NYC86LA180Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kingston, NYThe student plt was on his 1st solo flt. After a go-around, his next apch was good until the acft encountered a gust of wind just before touchdown. Subsequently, the acft landed hard (hit on rear section), veered off the rwy & nosed over.NTSB LAX86LA291Accident · No injuriesLimited investigationFinal reportEnstrom EN-280-C · Los Altos, CAThe instructor stated that during a practice auto rotative landing the helicopter lost rotor RPM and a hard landing followed. On ground contact, the main rotor blades struck the tail cone, resulting in substantial damage. The instructor further stated that…NTSB LAX86LA299Accident · No injuriesLimited investigationFinal reportBoeing N25-3 · Van Nuys, CAA Boeing N2S-3 nosed over on landing while on a local VFR flight. The pilot indicated that he had logged a total of 2.4 hours in this make and model aircraft all within the previous ninety days. The pilot stated that on his last approach, the speed was too…NTSB LAX86LA285Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Lincoln, CAThe student pilot indicated that this was his first solo flight. He had accumulated a total of 6.8 hours of flight time prior to this flight and he had flown earlier in the day with his flight instructor. After two landings with the flight instructor, the…NTSB CHI86FEC04Accident · Serious injuriesFinal reportCameron 77 · Hamburg, MIPlt made a precautionary landing reportedly due to high winds. Upon touchdown the basket tipped and one of the pax received a fractured left leg.NTSB DEN86LA184Accident · No injuriesLimited investigationFinal reportCessna 172N · Tooele, UTAfter successive aircraft bounces during a touchdown phase of landing, the pilot lost control. The aircraft departed the side of the runway into an area of soft terrain. The landing gear nose wheel sank into the ground and the aircraft nosed over into an…NTSB LAX86LA276Accident · No injuriesLimited investigationFinal reportCessna 320D · Compton, CAThe plt attempted a night landing after he was unable to extend the acft's landing lights. He stated that, over the end of the rwy at about 25 ft AGL, everything blended into a large black spot. As the plt attempted a go-around, the acft contacted the rwy,…NTSB NYC86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, RIThe plt intended to practice a short field landing & extended full flaps. Initially, his apch was higher & faster than normal. However, before landing, a high sink rate developed. The acft touched down hard, the right wing dropped & the acft started to turn…NTSB DEN86LA180Accident · No injuriesLimited investigationFinal reportMathew M. Kerr Starduster TOO · Roundup, MTDuring the telephone interview, the plt stated the acft landed hard, collapsing the right main gear & broke the right wing spar.NTSB CHI86LA160Accident · No injuriesLimited investigationFinal reportBeech V35B · Mackinac Island, MIAfter making two go-arounds the aircraft's landing gear collapsed as the aircraft porpoised on the runway during the third landing attempt.NTSB CHI86LA158Accident · No injuriesLimited investigationFinal reportCessna 182P · Gary, INThe student pilot was on a supervised solo flight. According to him, he closed the throttle over the threshold due to excessive speed and the plane floated for some distance as he brought the control column back. The nose of the aircraft then dropped and the…NTSB CHI86FET03Accident · No injuriesFinal reportEdward R. Merkner MUSTANG-II · Valparaiso, INAfter three apparent hard touch-&-go landings, the left main landing gear collapsed on the fourth & final landing. The pilot stated that there were no mechanical malfunctions of the aircraft prior to the accident.NTSB LAX86LA246Accident · No injuriesLimited investigationFinal reportBellanca Kcab · Taft, CAThe citabrea bounced on landing and ground looped on the runway. The pilot indicated that on touchdown the aircraft bounced. Throttle was advanced and on the second touchdown the aircraft veered left. The left wing rose placing the aircraft on the right main…NTSB BFO86FID07Accident · No injuriesFinal reportCessna 172M · Lynchburg, VAThe accident occurred as the plt was attempting to land at an unfamiliar arpt during a x-country flt because a passenger was feeling ill. The rwy was 2900 ft long with a 5% upslope at mid-field. The plt stated he misjudged his alt and airspeed during the…NTSB MIA86LA172Accident · No injuriesLimited investigationFinal reportCessna 172N · Bartow, FLThe plt stated that she landed hard on the nose wheel and the prop struck the ground, damaging the structure of the aircraft.NTSB CHI86FEM06Accident · No injuriesFinal reportCessna 170 · Houghton Lake, MIThis student pilot on his initial solo flight bounced the acft during landing. On the second bounce, the pilot inadvertently applied the toe braked and aircraft nosed over.NTSB FTW86LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Vega, TXThe pilot was practicing touch and go landings, when the aircraft began veering to the left after landing. He tried to apply full right rudder, but the aircraft continued to veer left off the runway. The pilot pulled the nose up to clear a tractor. The…NTSB FTW86LA090Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe student plt was practicing touch and go landings when he landed nose wheel first, causing the acft to bounce several times and veer off the rwy toward a ditch. The student plt, in his attempt to avoid the ditch, over compensated with the brakes and the…NTSB LAX86LA232Accident · No injuriesLimited investigationFinal reportCessna 172 · Huntington Bch, CAThe acft contacted a parked car and a hangar following a loss of control during an attempted go-around. The plt reported the acft was high and fast on final apch. He selected full flaps and a nose up attitude to lose airspeed and alt. He flared the acft at 20…NTSB NYC86LA137Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-32A · Kurtztown, PAAfter flying in thermals for about 45 minutes, the plts returned to the arpt to land. The instructor (CFI) stated they came over the initial approach point at about 1000 ft for a landing on runway 30. The glider passed over the end of the runway at about 150…NTSB BFO86LA025Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Washington, DCThe acft was reportedly too high to land on the rwy initially assigned by ATC. ATC directed the acft to fly over the arpt and enter downwind traffic for another rwy. The plt was later asked by ATC if he could make a short apch and he replied affirmative. The…