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 FTW83LA344Accident · No injuriesLimited investigationFinal reportCessna 172D · New Braunfels, TXThe acft made a hard landing which was hard enough to blow the nose gear tire and collapse the nose gear assembly.NTSB FTW83LA228Accident · No injuriesLimited investigationFinal reportCessna 182P · Searcy, ARThe plt reported that during a landing, the acft touched down hard. On touchdown, the right main gear failed & the acft veered off the rwy. After departing the rwy, the nose gear collapsed. Also, the fire wall was damaged during the landing.NTSB LAX83LA202Accident · No injuriesLimited investigationFinal reportCessna 180 · Long Beach, CAAccording to an on-duty, air traffic controller, the plt was practicing takeoffs & landings. After completing several landings, the plt made an apch to rwy 16R. During the landing, the acft reportedly pitched downward, and after touchdown became airborne…NTSB FTW83LA208Accident · No injuriesLimited investigationFinal reportCessna 152 · Cotulla, TXAccording to the pilot, on landing the acft bounced back into the air. The same thing happened on the second touchdown and on the third touchdown, the nose gear failed and the acft nosed over. The pilot reported that after the second touchdown a gust of wind…NTSB MIA83LA125Accident · No injuriesLimited investigationFinal reportHughes 300C · Vero Beach, FLThe helicopter landed hard during a practice autorotation.NTSB CHI83LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Harrison, MIThe pilot stated that he executed a go-around on the first landing attempt because of a strong crosswind and high airspeed. On the second approach, he executed a go-around from the flare because of a 'strong updraft'. The pilot statedthat during the…NTSB NYC83LA096Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-26 · West Mifflin, PAAccording to the pilot, he increased the power, and subsequently the airspeed, while on final approach, to compensate for strong winds and turbulence. The wind was reported to be from 150 deg. At 18 gusting 28 KTS. Reportedly, the acft crossed over the…NTSB LAX83LA193Accident · No injuriesLimited investigationFinal reportCessna 152 · Riverside, CAThe pilot stated that the acft became misaligned with the rwy as he flared. The acft also ballooned and at touchdown the nose gear collapsed. The acft skidded off the right side of the rwy and destroyed a rwy light during the maneuver.NTSB NYC83LA097Accident · No injuriesLimited investigationFinal reportCessna 182 · Rochester, NYThe acft went off the runway in strong gusty winds and nosed down in mud. The pilot stated that he bounced on landing and came down about 35 degrees to the centerline. He judged it too risky to try to realign so he continued to land off the runway. The acft…NTSB CHI83LA167Accident · No injuriesLimited investigationFinal reportCessna 172M · Holland, MIThe acft landed nose wheel first in a gusty crosswind. The active runway was 5 and the wind was 150 degrees at 15 KTS gusting to 21 KTS. The pilot stated that before she could round out a wind gust caused the acft to drop and make contacton the nose gear. The…NTSB CHI83LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Kankakee, ILThe student plt was on a round robin, cross-country training flt. His first landing was made on rwy 4 at the greater Kankakee arpt. During touchdown in a strong cross-wind, the acft bounced, then veered off the rwy. The acft then encountered soft terrain and…NTSB NYC83LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Jamaica, NYThe aircraft made a hard landing after an ILS approach to runway 31L at jfk international airport. The acft broke out ofthe clouds at 600 feet. As descent continued 2 notches of flaps were applied and flare was begun at 20 feet AGL. About 10 ft. above the…NTSB LAX84LA247Accident · No injuriesLimited investigationFinal reportChampion 7FC · Auburn, CAThe student plt was on his 2st solo flt. On the 3rd landing, the acft bounced & the student added power to recover. The acft veered left, & when the student observed that he was rapidly approaching trees, he banked the acft. The right wing tip impacted the…NTSB FTW83LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hugo, OKThe pilot reported that during the first approach strong gusts were encountered over the threshold and a go-around was was initiated. During the second approach he flew a little higher on final with a steeper descent. He again encountered gusty winds just…NTSB ATL83LA154Accident · No injuriesLimited investigationFinal reportCessna 152B · Conway, SCThe acft bounced during a hard landing and stalled about 10 feet AGL. The second contact with the runway occurred with the nose gear first. The nose gear then collapsed. This was a training flight with a solo student pilot as pilot in command. The weather was…NTSB SEA83LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32-112 · Vancouver, WAAccording to the instructor (CFI), the student was approaching the rwy at 60 KTS with the power reduced when he chopped the power & flared at aprx 10 to 15 ft AGL. The right wing dropped & the acft landed hard before the CFI corrected the situation. The right…NTSB LAX83LA175Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Chino, CAThe rated airplane plt was endorsed for local solo flts in the helicopter & was practicing autorotative landings. He stated that during a landing, he flared late & allowed the tail & tail rotor to impact the rwy.NTSB DEN83LA088Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Aspen, COWhile inbound, the plt checked the ATIS which was reporting a wind from 350 deg at 10 KTS. He continued inbound, and when he checked with the tower, the wind was from 350 deg at 6 KTS. The plt was cleared to land on the rwy of his choice, he stated that he…NTSB CHI83LA158Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Fraser, MIThe pilot stated he lost directional control of the aircraft after touchdown during a crosswind landing. The aircraft departed the right side of the runway into a muddy area and nosed over.NTSB CHI83LA157Accident · No injuriesLimited investigationFinal reportMooney M20-K · Indianapolis, INThe acft landed hard and bounced enough to make the propeller hit the rwy during landing. The pilot had made an ILS approach and when the acft broke out of the clouds it crossed the rwy threshold at about 70 KTS. At 10 ft AGL the pilot cut the power, flared,…NTSB NYC83LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Plainville, CTThe plt reported that just prior to a landing touchdown, he pushed the control yoke forward, then the acft hit the rwy and began to bounce. After the 4th bounce, the acft touched down on the rwy on the right wheel and yawed abruptly to the right. Reportedly,…NTSB LAX83LA170Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Mesa, AZAccording to the plt, there was no wind when he began the sight-seeing flt; however, after takeoff, the wind steadily increased to aprx 12 KTS. By this time, the balloon was approaching a large green field, so he elected to land rather than take a chance of…NTSB CHI83LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukegan, ILThe student pilot made a hard landing on his first solo flight. The aircraft bounced several times and damaged the nose landing gear. The student had made four full stop landings with an instructor pilot. Then the instructor deplaned for the student to make…NTSB LAX83LA139Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAThe acft made a hard landing as a student pilot was making his second supervised solo landing. The acft had been clearedfor a touch and go landing. The student pilot was unable to maintain directional control in a cross wind condition. He attempted alignment…NTSB FTW83LA155Accident · Serious injuriesLimited investigationFinal reportPiccard AX-6 · Springtown, TXThe balloon was on a 'hare & hound' competition flight with a commercial plt & student plt on board. After the competition portion was completed, the pilot-in-command told the student to take control & continue flying, then land at her discretion. After about…NTSB ATL83LA131Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Charlotte, NCThe aircraft collided with a tree during the landing roll. The weather was VMC and no flight plan was filed. The student pilot had been doing airwork for about one hour and returned for touch and go landing. After several successful landings he made another…NTSB ATL83LA126Accident · No injuriesLimited investigationFinal reportBeech C-23 · Florence, KYThe nose gear collapsed during landing. The acft was allowed to bounce twice and on the third touchdown the nose gear hit first and collapsed. A post impact fire was confined to the engine compartment and was extinguished by CFR personnel.NTSB MKC83FA073Accident · Minor injuriesField investigationFinal reportHughes TH-55A · Council Bluffs, IAThe student, who was a rated helicopter plt, and a helicopter instructor (CFI) were on a dual instructional flt. After takeoff, the aircrew remained in a right traffic pattern for rwy 13 , intending for the student to make a 180 deg autorotation to a parallel…NTSB LAX83LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · Corona, CAThe acft was landed hard twice and on the 2nd touchdown the nose gear collapsed. The 1st landing had been nose gear 1st,followed by a go-around and the gear appeared bent. On the second landing the nose gear again hit first and this time itcollapsed. This was…NTSB ATL83LA114Accident · No injuriesLimited investigationFinal reportCessna 172K · Scottsboro, ALThe acft was damaged in a hard landing. The plt did not believe the acft was substantially damaged and has disagreed with filing an accident report. Examination of the acft by a mechinic showed a partially collapsed nose gear buckled firewall and deformed…NTSB MKC83LA070Accident · No injuriesLimited investigationFinal reportCessna 140 · Scottsbluff, NEThe aircraft made a hard landing while landing at Scottsbluff NE during a pleasure flight. The aircraft was landing on runway 30 with the wind from 350 degrees at 8 KTS. A witness said the aircraft bounced 2 times before groundlooping off the left side of the…NTSB DEN83LA063Accident · No injuriesLimited investigationFinal reportCessna 182 · Salida, COThe acft collapsed the nose gear and damaged the propeller during a landing. The pilot was practicing cross-wind landings when the acft started to porpoise. The nose gear and the propeller struck the rwy several time before the acft was stopped.NTSB ATL83LA106Accident · No injuriesLimited investigationFinal reportCessna TU206G · Marietta, GAThe plt reported that he took off to practice engine out procedures & touch-and-go landings. Two successful touch- and-go landings were executed, the 1st with 20 deg of flaps & the 2nd with 10 deg of flaps. A 3rd engine-out landing was initiated, but with no…NTSB FTW83LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · Tyler, TXWhile making a short field approach, the acft touched down hard & the nose gear failed.NTSB ATL83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hampton, SCThe left main landing gear of the aircraft collapsed during a hard landing. The pilot stated that he cleared tall pine trees north of the runway at about 90 mhp (78 KTS). Shortly thereafter the aircraft started to sink 'real fast'. The pilot stated that he…NTSB SEA83LA047Accident · No injuriesLimited investigationFinal reportCessna 172 · Payette, IDThe acft bounced after a hard landing and drifted off the runway into a tree. The acft then stopped in the mud and nosedover. The landing was on runway 31 and the wind was 360 degrees at 8 KTS.NTSB ANC83LA035Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Anchorage, AKThe helicopter made a landing during which the tail boom was severed. This was a dual instructional flight and accordingto the instructor, a high reconnaissance was performed before selecting their approach to the pinnacle. The pinnacle is a 3000 foot landing…NTSB FTW83LA095Accident · No injuriesLimited investigationFinal reportCessna 421C · Houston, TXThe pilot stated that after a normal coupled ILS approach he broke out at about 250 ft AGL and 1/2 mile from the rwy. He disconnected the approach coupler and lined up with the rwy. He stated that during the transition from IFR to visual his rate of descent…NTSB ANC83LA029Accident · No injuriesLimited investigationFinal reportBell 212 · Tigvariak Isl., AKThe helicopter made a hard landing at night at an unlighted drill rig site. The pilot called the rig site on the radio to ask for lights but they were not turned on. The pilot tried to land without the lights and encountered blowing snow from the rotor wash.…NTSB NYC83LA047Accident · No injuriesLimited investigationFinal reportCessna 172N · Centre Hall, PAThe student plt took off to practice touch-and-go landings. The takeoff was accomplished without difficulty and the landing approach was uneventful until touchdown. The plt stated that on touchdown, the nose of the acft was too low and the nosewheel hit the…NTSB LAX83FA066Accident · No injuriesField investigationFinal reportCessna 152 · Van Nuys, CAThe student pilot was flying his second solo flight. On the first attempted touch and go he made a hard landing, bounced, porpoised and collapsed the nose gear. Fire erupted from the engine area. Examination revealed that on contact with the runway the nose…NTSB CHI83LA072Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Detroit, MIThe plt stated that as she was crossing the threshold she noticed that the acft had been blown over too FAR to the rightof the rwy. After correcting for this, she leveled off too high & the acft nosed down onto the rwy.NTSB MKC83LA051Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B · Indianola, IAThe pilot elected to make a touch and go landing in wind that was from 010 deg at 7, gusting 9 KTS. During touchdown, the basket was drifting and tilted over sideways. The passenger weithed 290 lbs and was unable to maintain his balance. When the basket…NTSB LAX83LA093Accident · Serious injuriesLimited investigationFinal reportPiccard AX-6 · Arroyo Grande, CAThe plt reported that he experienced a downdraft when he was on an apch to land near power lines, and was forced to 'rip out early.' The balloon landed landed relatively hard, but was not damaged. However, the plt's legs were crossed when the balloon touched…NTSB ATL83LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student pilot stated he attempted to land beyond the mid-point of the runway from a high threshold position with full flaps deployed. The aircraft was forced onto the runway, bounced 3 times, and the nose gear collapsed.NTSB MKC83LA043Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Lee'S Summit, MOThe student pilot was on a supervised solo flight in a tail wheel equipped aircraft. The instructor pilot was observing from about 300 ft from the touchdown point. He stated that the plane touched down hard, bounced and turned to the left. The right main gear…NTSB DEN83LA037Accident · No injuriesLimited investigationFinal reportCessna TR182 · Lander, WYThe aircraft nose wheel collapsed during landing. The plane then turned left went off the runway and collided with a snowbank. An examination of the aircraft revealed no evidence of a mechanical malfunction or failure of the nose gear prior to touchdown.NTSB MIA83LA053Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Stuart, FLAircraft made a hard landing and damaged wings.NTSB CHI83LA056Accident · No injuriesLimited investigationFinal reportCessna 172 · Cincinnati, OHThe student pilot touched down on runway 06, bounced, the nose gear collapsed and the pilot loss direction control. The aircraft nosed over.NTSB MIA83LA049Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ocoee, FLPlt approached with a higher than normal airspeed. The acft touched down nose wheel first about 1/3 down the rwy collapsing the nose gear causing the propeller to strike the rwy.