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 ATL07CA118Accident · No injuriesData collectionFinal reportPiper PA28-140 · Front Royal, VAThe pilot's improper recovery from a bounced landing.NTSB SEA07CA233Accident · No injuriesData collectionFinal reportRobinson R-22 Beta II · Tucson, AZThe student pilot's failure to maintain rotor RPM during landing approach, and the delayed remedial action by the flight instructor. A contributing factor was the high density altitude weather condition.NTSB SEA07CA230Accident · No injuriesData collectionFinal reportCessna 195 · San Diego, CAThe pilot's inadequate compensation for a wind gust that ballooned the airplane during the landing flare, which resulted in a hard landing. A contributing factor was the wind gust.NTSB SEA07CA232Accident · No injuriesData collectionFinal reportCirrus Design SR22 · San Diego, CAThe pilot's improper recovery from a bounced landing, which resulted in porpoising and collapse of the nose landing gear.NTSB SEA07CA225Accident · No injuriesData collectionFinal reportCessna 182P · Bremerton, WAThe pilot's failure to maintain airspeed during the landing flare. A factor was the encounter of the stall and subsequent hard landing.NTSB LAX07CA247Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Chino, CAThe private pilot's failure to maintain the proper airspeed and main rotor rpm, which resulted in a high rate of descent and subsequent hard landing. Also causal was the certificated flight instructor's delayed remedial action.NTSB LAX07CA246Accident · No injuriesData collectionFinal reportFound Aircraft Canada FBA-2C1 · Challis, IDthe pilot's inadequate bounced landing recovery technique, which resulted in a hard landing.NTSB CHI07CA245Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe student pilot's improper flare, which resulted in a hard landing. An additional cause was the pilot's inadequate recovery from a bounced landing. Factors in the accident include the pilot's failure to maintain directional control during the landing roll…NTSB NYC07CA185Accident · No injuriesData collectionFinal reportBeech 65-A90 · Wallkill, NYThe pilot's improper flare, which resulted in a hard landing.NTSB SEA07CA216Accident · No injuriesData collectionFinal reportCessna 182P · Baker City, ORThe pilot's failure to maintain airspeed and misjudged flare during landing.NTSB SEA07CA211Accident · No injuriesData collectionFinal reportArtic S-1B2 · McCall, IDThe pilot's failure to maintain airspeed during the landing flare resulting in a hard landing and subsequent failure to maintain directional control during the landing roll. The soft terrain condition adjacent to the runway was a factor.NTSB LAX07CA229Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta II · Boise, IDThe student pilot's failure to maintain rotor rpm resulting in an excessive descent rate and a hard landing. Factors in the accident were the student's failure to relinquish the controls, and the CFI's inadequate supervision.NTSB CHI07CA242Accident · No injuriesData collectionFinal reportMarcellus Starduster SA-300 · Columbia, ILThe pilot's improper flare, which resulted in a hard landing and subsequent left main landing gear collapse.NTSB LAX07CA226Accident · No injuriesData collectionFinal reportBeech C23 · Taylor, AZthe student pilot's misjudged landing flare and inadequate recovery from a bounced landing that resulted in a hard landing and a loss of directional control.NTSB SEA07CA207Accident · No injuriesData collectionFinal reportCessna 172S · Pahokee, FLThe student pilot's improper flare during the landing which resulted in a hard landing. The student pilot's failure to relinquish control of the aircraft, the flight instructors inadequate supervision and not being able to recover control of the aircraft from…NTSB LAX07CA228Accident · No injuriesData collectionFinal reportDta Sari Combo FC 912 · San Luis Obispo, CAThe student pilot's improper flare, which resulted in a hard landing. Also causal was the instructor's inadequate supervision.NTSB SEA07CA205Accident · No injuriesData collectionFinal reportRobinson R22 · Bend, ORAn excessive descent rate during a simulated power-off autorotation, and the pilot's failure to initiate corrective action in time to keep the helicopter from impacting the terrain.NTSB CHI07LA317Accident · Serious injuriesLimited investigationFinal reportAerostar International S81A · Custer, SDThe high wind during landing. Contributing to the accident was the encounter with adverse weather during the flight.NTSB ATL07CA105Accident · No injuriesData collectionFinal reportCessna 172S · Beverly, MAThe pilot's improper flare, which resulted in a hard landing and nose gear collapse. A contributing factor was the wind gust.NTSB DEN07CA121Accident · No injuriesData collectionFinal reportCessna 180 · Marble, COThe pilot misjudging his altitude and his failure to maintain control of the airplane, resulting in a hard landing. Factors contributing to the accident were the excessive descent rate, and the pilot's improper recovery from a bounced landing.NTSB DEN07CA117Accident · No injuriesData collectionFinal reportCessna 182R · Montpelier, VTThe pilot's improper flare and subsequent hard landing.NTSB NYC07CA161Accident · No injuriesData collectionFinal reportCessna 182Q · New Haven, CTThe pilot's improper flare which resulted in a hard landing. A factor to the accident was the wind gusts.NTSB LAX07CA223Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Truckee, CAThe pilot's inadequate compensation for a wind gust during landing flare, which resulted in a hard landing.NTSB CHI07CA192Accident · No injuriesData collectionFinal reportCessna 150M · Muncie, INThe pilot's failure to maintain sufficient airspeed, resulting in a stall/mush during an attempted aborted landing. A factor in the accident was the premature flare and the pilot's inadequate recovery from a bounced landing.NTSB DEN07CA120Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Peyton, COThe pilot's improper flare and failure to maintain control and subsequent hard landing. Contributing factors in this accident were the gusty winds, hot temperature, and high density altitude.NTSB LAX07CA202Accident · No injuriesData collectionFinal reportCessna 172S · Spanish Fork, UTThe pilot's misjudged landing flare resulting in a porpoise and hard touchdown.NTSB SEA07CA182Accident · No injuriesData collectionFinal reportCessna 172S · Long Beach, CAThe pilot's improper recovery from a bounced landing which resulted in an inadvertent stall and a hard landing. The crosswind was a factor.NTSB ATL07CA096Accident · Minor injuriesData collectionFinal reportBurk RV-6A · Laurel, MDThe pilot's improper landing flare resulting in an inadvertent stall and hard landing, which resulted in the airplane sliding off the runway and nosing over.NTSB SEA07CA171Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Park City, UTThe pilot's failure to maintain rotor RPM during hover taxi. A contributing factor was the high density altitude weather condition.NTSB ATL07CA093Accident · No injuriesData collectionFinal reportCessna 172S · Batavia, NYThe student pilot's failure to flare the airplane during landing resulting in a hard landing.NTSB DFW07CA140Accident · No injuriesData collectionFinal reportCessna 172G · Katy, TXThe student pilot's improper flare and his failure to recover from a bounced landing.NTSB NYC07CA131Accident · No injuriesData collectionFinal reportCessna 172S · Raleigh-Durham, NCThe pilot's improper recovery from a bounced landing.NTSB ATL07LA086Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Columbia, SCThe pilot's improper landing flare, resulting in a hard landing.NTSB SEA07CA139Accident · No injuriesData collectionFinal reportHughes 369D · Torrance, CAThe pilot's loss of helicopter control while maneuvering at low altitude, which resulted in a hard landing. The wind gusts were a contributing factor.NTSB LAX07CA178Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Mammoth Lakes, CAthe pilot's failure to ensure that the runway was clear of other aircraft before takeoff.NTSB MIA07LA102Accident · 1 fatalLimited investigationFinal reportBell 47G · Hayden, ALThe student pilot's failure to maintain aircraft control during hover, following a bounced landing.NTSB LAX07CA177Accident · Minor injuriesData collectionFinal reportMD Helicopters 500-E · Yerington, NVThe failure of the student and instructor to maintain an adequate main rotor rpm, and the instructor’s inadequate in-flight supervision while conducting a low-level simulated emergency procedure, which resulted in a hard landing.NTSB MIA07CA101Accident · No injuriesData collectionFinal reportMooney M20R · Carthage, NCThe delay by the pilot-in-command to recover from a bounced landing resulting in a hard landing and subsequent collapse of the nose and left main landing gears.NTSB LAX07CA162Accident · No injuriesData collectionFinal reportCessna R172E · Dayton, NVThe pilot's misjudged flare, which resulted in a hard landing.NTSB CHI07CA153Accident · No injuriesData collectionFinal reportCessna 182S · Harvard, ILThe pilot's misjudged flare and improper recovery from a bounced landing, which caused the nose gear to collapse and subsequent damage to the propellor and underside of the airplane.NTSB NYC07CA116Accident · No injuriesData collectionFinal reportCessna 172S · Asheville, NCThe pilot's improper landing flare which resulted in a hard landing. A factor in the accident was the visual illusion experienced by the pilot from landing on a long, wide runway.NTSB CHI07CA132Accident · No injuriesData collectionFinal reportCessna 172P · Kenosha, WIThe pilot's improper recovery from a bounced landing, which resulted in a flat nose wheel tire and a buckled firewall. A factor was the porpoising that was encountered during the flare.NTSB LAX07CA171Accident · No injuriesData collectionFinal reportCessna 172S · Payson, AZThe pilot's inadequate in-flight planning/decision, excessive airspeed on final approach, and failure to execute a go-around resulting in a misjudged flare and hard landing.NTSB NYC07CA112Accident · No injuriesData collectionFinal reportCessna 172SP · Daytona Beach, FLThe pilot's improper flare at night, which resulted in a hard landing. A factor in the accident was the pilot's lack of recent night experience.NTSB NYC07CA108Accident · No injuriesData collectionFinal reportPiper PA28R-201 · Leesburg, FLThe flight instructor's failure to take remedial action, and the private pilot's failure to maintain proper airspeed, which resulted in a hard landing.NTSB SEA07CA120Accident · No injuriesData collectionFinal reportCessna 172R · Livermore, CAThe pilot's improper flare during landing.NTSB NYC07LA106Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Brunswick, GAThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the attempted takeoff above the airplane's maximum gross weight, and an undetermined partial power loss, as reported by the pilot.NTSB CHI07CA123Accident · Minor injuriesData collectionFinal reportCessna 150J · Amery, WIThe pilot's failure to maintain control of the airplane during the aborted landing attempt which resulted in the airplane impacting trees. A misjudged flare, subsequent bounced landing, and gusty wind conditions were contributing factors.NTSB LAX07CA139Accident · No injuriesData collectionFinal reportCessna T206H · Grand Canyon, AZThe pilot's misjudged landing flare, which resulted in a bounced landing and a porpoise.NTSB LAX07CA138Accident · No injuriesData collectionFinal reportTolsma Tony G Avid Magnum · Jackpot, NVThe pilot's inadequate weather evaluation, inadequate compensation for the wind conditions, and decision to land with a gusty, quartering tailwind. Also causal was the pilot's misjudged landing flare and inadequate recovery from a bounced landing, resulting…