NTSB investigations, KY
21 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 4 |
| 1985 | 3 |
| 1987 | 2 |
| 1992 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2003 | 1 |
| 2005 | 2 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'KY' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'KY' AND c."eventCountry" = 'USA' AND 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 NYC05FA094Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-11F · Louisville, KYThe flying pilot's improper aircraft handling after main landing gear touchdown, which resulted in the collapse of the nose landing gear assembly. Conributing to the accident was the pilot-in-command's inadequate supervision during the landing.NTSB IAD05LA060Accident · No injuriesLimited investigationFinal reportCessna 172 · Pikeville, KYThe pilot's improper flare, which resulted in a hard landing.NTSB IAD04CA006Accident · No injuriesData collectionFinal reportPiper PA-30 · Louisville, KYThe pilot's improper flare, which resulted a hard landing. A factor was the glare from the setting sun.NTSB NYC01LA231Accident · No injuriesLimited investigationFinal reportLet 33 · Bardstown, KYThe pilot's improper flare, which resulted in a nose-first, hard touchdown.NTSB IAD01TA051Accident · Minor injuriesFinal reportHughes 369D · Taylorsville, KYthe flight instructor's inadequate aircraft control during a practice autorotation which resulted in a hard landing.NTSB NYC01LA055Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Mount Sterling, KYThe student pilot's inadequate recovery from a bounced landing.NTSB BFO93LA013Accident · No injuriesLimited investigationFinal reportCessna 152 · Danville, KYThe student pilot's inadequate flare. A factor was the gusty wind.NTSB BFO92LA139Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Shelbyville, KYAn improper flare made by the pilot resulting in a hard landing and main rotor blade tail boom strike.NTSB ATL88LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lexington, KYDuring a dual instructional flight the student leveled the acft abv the rwy during the landing flare. The CFI told the FAA inspector that he was verbally coaching the student and did not assume the flt controls. The acft landed hard and the student applied…NTSB ATL87LA183Accident · No injuriesLimited investigationFinal reportCessna 140 · Falmouth, KYThe pilot was on a cross-country flight and had made several refueling stops during the day. He stated that during landing he experienced a crosswind of approximately 7 to 10 knots. The aircraft bounced, rocked up on the left main landing gear, departed the…NTSB ATL85LA235Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Burnsdie, KYThe acft bounced during touchdown on a grass airstrip and veered off the left side of the rwy. Before proper alignment was gained the left wing struck a parked acft and both acft incurred substantial damage.NTSB ATL85LA218Accident · No injuriesLimited investigationFinal reportCessna 177 · Stanton, KYThe pilot reported that during takeoff, he believed that the flight controls were not responding to control inputs. Moments after lift-off, he aborted the takeoff. The airplane continued off the departure end of the runway, where the nose gear and engine…NTSB ATL85LA215Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Owensboro, KYThe plt had a single eng land rating & was preparing for a multi-eng check ride. While practicing a touch-&-go landing, the acft bounced. The plt applied power, made a go-around & landed without further incident. However, during a post-flt exam, substantial…NTSB ATL84LA023Accident · No injuriesLimited investigationFinal reportCessna 177 · Albany, KYThe plt stated that just prior to touchdown the acft encountered an updraft which lifted the acft from 2 or 3 ft above the rwy to about 20 ft where the acft stalled & fell to the rwy. A witness stated that the acft was 40 ft above the rwy before it dropped.NTSB ATL83LA200Accident · No injuriesLimited investigationFinal reportCessna 172N · Pikeville, KYThe acft made a hard landing, bounced, landed on the nose gear and repeated this sequence twice. Then the acft veered off the runways right side and careened down an embankment. The pilots reports stated that the acft was landed on the nose gear twice. The…NTSB ATL83LA190Accident · No injuriesLimited investigationFinal reportCessna 414 · Irvine, KYDuring arrival, the pilot made his landing approach to rwy 14 with a x-wind from 230 deg, gusting from 6 to 22 KTS. The airport was on a knoll & the terrain sloped downward from the approach end of the runway. The plt stated that as the acft was flying over…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 ATL82DA215Accident · No injuriesFinal reportCessna 172N · Somerset, KYThe student piot was on a controlled cross-country flight. While landing at the first en route airport, the aircraft veered off the runway and the nose gear collapsed. A witness stated that the aircraft bounced during the landing and the nose gear collapsed…NTSB ATL82DA173Accident · Serious injuriesFinal reportCameron Ballon 0-77 · Peewee Valley, KYThe pilot reported that he took off in light to moderate wind conditions. During a 30 minute flight, the wind velocity increased. The pilot said that he briefed his passenger on how to position himself to avoid injury in the event of a hard landing. A shallow…NTSB ATL82DA111Accident · No injuriesFinal reportCessna 320A · Paintsville, KYThe pilot reported encountering wind shear at about 300 ft from the approach end of runway 31. He stated that the aircraft crabbed to the left and right rudder was applied. Also, he reported that the plane stalled about six to ten feet above the runway and…NTSB ATL82DA079Accident · No injuriesFinal reportHughes H-369HS · Lexington, KYThe pilot was practicing autorotation from 15 to 20 ft AGL. On the final landing, the helicopter touched down hard and the main rotor blades fexed downward and struck the tail boom.