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 DEN99LA025Accident · Serious injuriesLimited investigationFinal reportCessna 182RG · Glenwood Spring, COThe pilot's failure to maintain directional control. A contributing factor is his inadequate recovery from a bounced landing.NTSB MIA99LA062Accident · No injuriesLimited investigationFinal reportBeech C-45G · Charlotte AmaliThe inadequate flare by the pilot-in-command resulting in a hard landing on the nose landing gear causing it to collapse.NTSB CHI99LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-R200 · Eden Prairie, MNthe pilot misjudged the flare and did not maintain directional control during touchdown. A factor was the VASI lights.NTSB CHI99LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Evansville, INThe pilot's improper flare and improper recovery from a bounced landing.NTSB CHI99LA035Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Alliance, NEWas the late flare and stall by the student pilot and improper remedial actions by the student pilot.NTSB LAX99LA042Accident · No injuriesLimited investigationFinal reportMartin Stoddard Hamilton II · Georgetown, CAThe pilot's improper flare. Also causal was the flight instructor's inadequate supervision.NTSB MIA99LA035Accident · No injuriesLimited investigationFinal reportCessna 182C · St. Petersburg, FLthe pilot misjudged the flare, resulting in a hard land and subsequent damage to the airplane.NTSB ATL99LA018Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hickory, NCThe pilot's failure to properly recover from a bounced landing.NTSB CHI99LA030Accident · No injuriesLimited investigationFinal reportCessna 172C · Falls City, NEthe flight instructor (on the ground)'s conducting inadequate initial training of the student pilot. Factors were the student pilot's misjudging the flare and his lack of total experience in the type of operation.NTSB ATL99LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · Winnsboro, SCThe pilot's improper landing flare that resulted in overload damage to the nose wheel assembly.NTSB CHI99LA025Accident · No injuriesLimited investigationFinal reportCessna 150M · Warrensburg, MOthe student pilot's inadequate flare and his failure to maintain directional control of the airplane. Factors associated with the accident were, the student's lack of total experience and the dirt bank which was contacted.NTSB MIA99LA021Accident · No injuriesLimited investigationFinal reportCessna 150F · Winter Haven, FLThe student pilot's improper landing flare resulting in a hard landing and ground loop.NTSB NYC99LA018Accident · No injuriesLimited investigationFinal reportAero Commander AC-100 · Bridgeton, NJThe pilot's failure to properly flare the airplane at touchdown.NTSB NYC99LA016Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Oneonta, NYThe pilot's improper flare which resulted in a hard landing. A factor in the accident was the crosswind condition.NTSB NYC99LA017Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103-TWINA · Saratoga Spring, NYThe pilot's failure to maintain control of the glider while landing.NTSB IAD99LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Clinton, MDThe student pilot's improper flare and improper recovery from a bounced landing.NTSB DEN99LA010Accident · Serious injuriesLimited investigationFinal reportAerostar RXS8 · Albuquerque, NMThe high wind condition and the pilot's subsequent intentional hard touchdown. A factor was the small landing area that was available to the pilot.NTSB DEN99LA006Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Alberquerque, NMThe passenger's failure to follow procedures/directives for a hard landing. A factor was the congested/confined landing area with power lines on both ends.NTSB DEN99LA023Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Albuquerque, NMThe passenger not following high wind landing procedures/directives which were given to her by the pilot. A factor was the unforecasted high wind condition.NTSB CHI99LA002Accident · No injuriesLimited investigationFinal reportCessna C-336 · Sheboygan, WIThe pilot's improper flare and improper recovery from a bounced landing.NTSB DEN99LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Albuquerque, NMThe premature flaring of the airplane, resulting in an inadvertent stall.NTSB MIA99LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Venice, FLThe pilot's improper flare and improper recovery from a bounced landing.NTSB FTW98LA417Accident · No injuriesLimited investigationFinal reportCessna 172N · Gallup, NMThe pilot's inadequate landing flare. Factors were his misjudgement of altitude and his excessive airspeed.NTSB LAX98LA307Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Merced, CAThe pilot's improper flare and his failure to adequately compensate for the existing crosswind conditions and maintain airplane control during landing.NTSB IAD98LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Oxford, CTThe pilot's improper flare and inadequate recovery from a bounced landing. A factor was the pilot's lack of experience.NTSB IAD98LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe pilot's improper flare and improper recovery from a bounced landing.NTSB LAX98LA304Accident · No injuriesLimited investigationFinal reportBoeing 369E · Mesa, AZA hard landing caused by the pilot's improper flare during a simulated autorotatative landing. A factor in the accident was the soft wet sod landing area.NTSB LAX98LA301Accident · No injuriesLimited investigationFinal reportCessna 172F · Long Beach, CAThe pilot's misjudging the flare point and failure to maintain an adequate airspeed margin, which resulted in a stall/mush and hard landing. A contributing factor was the dark night conditions.NTSB FTW98LA403Accident · No injuriesLimited investigationFinal reportCessna 150M · Yukon, OKThe pilot's improper landing flare which resulted in a hard landing and her improper recovery procedures for a bounced landing.NTSB NYC98LA190Accident · No injuriesLimited investigationFinal reportCessna 172 · Stow, MAThe pilot's improper recovery from a bounced landing. Contributing factors were the pilot's lack of a single engine experience/certification. Also a factor was the flying club's inadequate oversight of pilot qualifications.NTSB LAX98LA298Accident · No injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39 · Mesa, AZThe pilot's improper flare and his failure to follow the proper procedures for the aircraft and to maintain control of the aircraft.NTSB LAX98LA291Accident · Minor injuriesLimited investigationFinal reportCessna T210R · Buckeye, AZthe pilot's delayed response in recovering from a bounced landing combined with his delayed decision to abort the landing. The pilot's inadequate compensation for tailwind conditions and inadvertently raising the flaps to 10 degrees were factors in this…NTSB ANC98LA150Accident · No injuriesLimited investigationFinal reportCessna 207A · Hughes, AKThe pilot's inadequate compensation for the wind conditions, and an inadvertent stall. A factor in the accident was the presence of a tail wind.NTSB LAX98LA294Accident · No injuriesLimited investigationFinal reportCessna 172L · Bakersfield, CAThe pilot's misjudged landing flare that led to an improper bounced landing recovery and subsequent uncontrolled porpoise.NTSB MIA98LA236Accident · No injuriesLimited investigationFinal reportHall Revolution Mini 500 · Hattiesburg, MSThe failure of the pilot to maintain main rotor rpm during a forward hover and the cyclic grip separating during the resultant bounced landing resulting in the pilot losing cyclic control and the main rotor contacting the tail boom. A factor in the accident…NTSB MIA98LA257Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Opa Locka, FLThe pilot's improper remedial action in recovering from a bounced landing resulting in a stall, and his incorrect recovery from a pilot induced oscillation (PIO) condition. A factor was the pilot's failure to execute a timely go-around maneuver.NTSB CHI98LA327Accident · No injuriesLimited investigationFinal reportCessna 310B · Breezy Point, MNthe pilot's improper flare of the airplane, and his not maintaining control of the airplane.NTSB IAD98LA098Accident · No injuriesLimited investigationFinal reportCessna 150L · Cumberland, MDThe pilot in command's improper recovery from a bounced landing.NTSB LAX98LA274Accident · No injuriesLimited investigationFinal reportRobinson R22B · Ramona, CAThe failure of the pilot to maintain rotor rpm while practicing autorotations and subsequent hard landing and roll over.NTSB CHI98LA340Accident · No injuriesLimited investigationFinal reportCessna 172N · Traverse City, MIthe inadvertent stall/mush. Factors contributing to this accident were the pilot's improper compensation for the wind conditions, and his excessively high flare.NTSB ATL98LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Paris, TNThe pilot's improper landing flare that resulted in an overload failure of the left main landing gear.NTSB FTW98LA369Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Blanding, UTThe pilot's inadequate landing flare, causing components of the nose wheel landing gear to fracture.NTSB FTW98LA348Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COThe pilot's improper remedial action after making a hard landing and porpoising. A factor was his lack of total experience.NTSB FTW98LA346Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKThe student pilot's delayed landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB LAX98LA248Accident · No injuriesLimited investigationFinal reportBeech C23 · Avalon, CAThe failure of the pilot to maintain an adequate airspeed during the landing, which resulted in a stall/mush and hard landing.NTSB SEA98LA149Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Ashland, ORThe pilot's improper landing flare, which resulted in a hard landing.NTSB FTW98LA330Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Lubbock, TXThe pilot's failure to perform an adequate flare, and his improper touchdown technique. Factors were the pilot's improper evaluation of the weather conditions, and the high density altitude and crosswind weather condition.NTSB CHI98LA284Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Salina, KSthe pilot failed to flare the airplane properly and the airplane landed hard.NTSB NYC98LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Nantucket, MAThe student pilot's failure to perform a go-around. A factor in the accident was the tailwind.NTSB IAD98LA093Accident · No injuriesLimited investigationFinal reportCessna 182 · Edgartown, MAwas the pilot's improper flare prior to touchdown.