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 DEN89FA192Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Bullfrog, UTImproper flare by the pilot, his failure to maintain runway alignment, and the improper remedial action which resulted in a loss of control. The high density altitude and objects (runway light and smudge pot) were considered to be contributing factors.NTSB LAX89LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Monica, CAThe student pilot's improper flare and recovery from a bounced landing.NTSB NYC89LA192Accident · No injuriesLimited investigationFinal reportCessna R172K · Griswold, CTImproper flare by the pilot, and his failure to attain adequated airspeed for an aborted landing (go-around), which resulted in a loss of aircraft control.NTSB BFO89LA067Accident · No injuriesLimited investigationFinal reportTravel Air B-4000 · Midland, VAThe pilot's improper compensation for wind conditions and improper flare during the landing. Contributing factors were:the wind conditions and the pilot's lack of experience in this make and model of aircraft.NTSB ATL89FA189Accident · No injuriesField investigationFinal reportConvair 640 (340D) · Atlanta, GAPilot in command failed to place the airplane at a position from which a stabilized approach to landing could be made. His procedure for the recovery from the bounced landing was inadequate and the nose gear structural strength was exceeded during following…NTSB NYC89LA203Accident · No injuriesLimited investigationFinal reportCessna 172P · Newburgh, NYThe dual student's misjudgement of the airplane's altitude and speed during the flare for landing, and the improper use of power during the flare. In addition, the CFI failed to adequately supervise the dual student's action.NTSB SEA89LA145Accident · No injuriesLimited investigationFinal reportCessna 177 · Fall City, WAThe pilot misjudged his landing flare and then did not properly recover from the resulting bounce.NTSB LAX89LA253Accident · No injuriesLimited investigationFinal reportBell 206B · Rialto, CAFailure to install two of the four required nuts which retain the high speed coupling input drive shaft to the transmission.NTSB SEA89LA142Accident · No injuriesLimited investigationFinal reportCessna 172E · Yerington, NVThe pilot's failure to maintain adequate airspeed during a landing go-around in high density altitude conditions.NTSB BFO89LA066Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Williamsburg, VAThe pilot's failure to maintain aircraft control by improperly flaring the airplane during the landing approach.NTSB SEA89LA152Accident · No injuriesLimited investigationFinal reportCessna 172M · Carson City, NVThe student pilot's improper compensation for wind conditions, and improper recovery from a bounced landing. Factors related to the accident were: the adverse wind condition and the student's lack of total flying experience.NTSB NYC89LA178Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt Pleasant, PAAn improper flare by the pilot that resulted in a hard landing.NTSB MKC89LA171Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Liberty, MOControl interference by the dual student as the instructor tried to recover from the student's bounced landing, and failure to maintain proper runway alignment. Contributing factors were: improper flare by the student, the crosswind, the student's…NTSB MIA89LA207Accident · No injuriesLimited investigationFinal reportCessna 172N · Gainesville, FLThe student's improper flare for landing. The crosswind (quartering headwind) and the student's lack of experience in this aircraft were considered to be contributing factors.NTSB LAX89DUG06Accident · No injuriesFinal reportBoeing A75N1 · Chino, CAThe pilot losing directional control after a hard landing, which resulted in a nose over.NTSB CHI89LA164Accident · No injuriesLimited investigationFinal reportPiper PA38-112 · Milwaukee, WIStudent pilot's misjudged aircraft handling during the landing flare/touchdown, and the cfi's inadequate supervision of the operation. These resulted in an abrupt touchdown, a subsequent loss of directional control, and the aircraft's collision with the VASI…NTSB NYC89LA173Accident · Serious injuriesLimited investigationFinal reportSchweizer 1-23 · Eighty Four, PAPoor handling of the glider durig landing. The pilot over corrected and caused the nose to strike the runway surface. Directional control was lost, resulting in a groundloop.NTSB ATL89IA180Incident · No injuriesIncident investigationFinal reportMooney M20C · Marietta, GAThe pilot's failure to properly flare the airplane.NTSB ATL89DMG04Accident · No injuriesFinal reportWittman, S.J. W-8 · Washington, NCPilot inadvertently stalled the airplane.NTSB CHI89LA139Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Grayslake, ILThe pilot's improper flare and recovery from a bounced landing, and his failure to go around (when there was sufficient speed and runway remaining). A contributing factor was his lack of recent experience in type of aircraft.NTSB MKC89LA160Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Camdenton, MOAircraft control was not maintained by the pilot in command.NTSB CHI89LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Grosse Ile, MIThe student pilot's not correcting the porpoise on the first landing. A factor in the accident is the lack of experience of the student pilot.NTSB MIA89LA197Accident · No injuriesLimited investigationFinal reportCessna 150 · Deland, FLImproper flare by the pilot and his improper recovery from a bounced landing.NTSB MIA89LA193Accident · No injuriesLimited investigationFinal reportCessna 208B · Fort Myers, FLImproper flare by the pilot for landing and improper remedial action. A contributing factor was the lack of airspeed on final approach.NTSB LAX89FA238Accident · No injuriesField investigationFinal reportEnstrom F28F · Oakland, CAFailure of the pilot to properly maintain rotor RPM throughout the autorotation.NTSB MKC89LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Crystal, MNAircraft control was not maintained by the pilot in command, due to an improper landing flare which resulted in several bounces. The landing gear failed in overload during the bounced landing.NTSB ATL89LA176Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Holly Hill, SCPilot misjudged his landing approach path and crossed the runway threshold too high to safely complete the landing. He also flared the airplane at too high an altitude resulting in a stall to a hard touchdown on the nose wheel exceeding the structural…NTSB ANC89LA117Accident · No injuriesLimited investigationFinal reportCessna 206 · Eureka, AKThe pilot failed to maintain control of the airplane during a hard landing a subsequent go-around attempt.NTSB NYC89LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Plattsburgh, NYThe pilot's improper flare, improper recovery from a bounced landing, and failure to maintain directional control.NTSB MKC89LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Charles, MOAircraft control was not maintained by the pilot in command due to improper use of the flight controls in flaring the aircraft for landing and counteracting the effects of the cross-wind on the drifting aircraft.NTSB MIA89LA183Accident · No injuriesLimited investigationFinal reportCessna 421B · Fort Lauderdale, FLImproper flare by the pilot. The light condition (dark night) was considered to be a contributing factor.NTSB NYC89LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Oneida, NYLoss of directional control during landing due to wind change. The aircraft landed hard on the runway due to improper flare by the pilot and a delayed response to the ballooning of the acft.NTSB DEN89LA153Accident · No injuriesLimited investigationFinal reportStitts SA7D · Evanston, WYImproper compensation by the pilot for wind conditions. Contributing factors were: high density altitude, unfavorable wind, and downdraft.NTSB FTW89LA122Accident · No injuriesLimited investigationFinal reportCessna 206 · Del Rio, TXPilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise.NTSB BFO89LA052Accident · Minor injuriesLimited investigationFinal reportMooney M-20F · Mchenry, MDThe pilot landed hard and collapsed the landing gear when he failed to arrest his descent rate during landing. Afterwardas he tried to make a go-around the pilot did not obtain adequate flying speed, the aircraft stalled and collided with the ground.NTSB MKC89LA145Accident · 1 fatalLimited investigationFinal reportCessna U206 · Eveleth, MNThe pilot's improper flare during the water landing. The pilot's lack of recent experience in seaplane operations and the lack of experience in the accident aircraft contributed to the accident.NTSB DEN89LA145Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Rio Rancho, NMA hard landing due to the pilots failure to accurately evaluate the weather conditions along with a delay in making a precautionary landing. Factors contributing to the accident were high winds and wind shear along with rough/uneven terrain.NTSB ATL89LA170Accident · No injuriesLimited investigationFinal reportCessna R172E · Birmingham, ALImproper flare by the pilot, which resulted in a hard landing. The fact that the pilot was asked twice to expedite the landing created pressure on the pilot and was considered to be a factor.NTSB ANC89LA089Accident · No injuriesLimited investigationFinal reportCessna 150-L · Alexander River, AKThe failure of the pilot to land at the proper touchdown point and the resulting hard landing. Damage to the airplane precluded a go-around and resulted in the intentional swerve into a River to avoid injuries to people on the ground.NTSB NYC89DFJ01Accident · Minor injuriesFinal reportDavis DA-2A · Skaneateles, NYThe pilot's hard landing which resulted in nose gear collapse.NTSB MIA89LA169Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLThe pilot's late flare which resulted in a hard landing that exceeded the design stress limits of the airplane.NTSB BFO89LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Dover Afb, DEThe pilot's improper flare, improper recovery from a bounced landing, and his delay in initiating a go-around, which resulted in an uncontrolled porpoise, loss of directional control, and an uncontrolled ground swerve. His lack of experience, a crosswind, and…NTSB NYC89LA143Accident · No injuriesLimited investigationFinal reportBeech 60 · Philadelphia, PAImproper flare by the pilot during the landing, and his failure to maintain directional control of the aircraft.NTSB NYC89LA138Accident · No injuriesLimited investigationFinal reportHughes 269A · Swanton, VTThe pilot failed to maintain directional control.NTSB MIA89IA153Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Guantanamo, PRFailure of the pilot in command to properly compensate for a crosswind condition, and failure to utilize the proper crosswind landing technique.NTSB BFO89LA034Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Indian Head, MDPilot failed to maintained directional control during recovery from a hard landing.NTSB CHI89LA093Accident · No injuriesLimited investigationFinal reportCessna 140 · Linden, MIThe pilot's poor judgement, poor aircraft handling, and the resultant hard touchdown.NTSB ATL89LA147Accident · No injuriesLimited investigationFinal reportCessna 172N · Fuquay, NCFailure of the student pilot to maintain directional control of the aircraft during the landing, which resulted in an inadvertent ground swerve. Contributing factors were: improper flare by the student during the landing, which resulted in a hard landing, and…NTSB ATL89LA145Accident · No injuriesLimited investigationFinal reportHughes 269A · Ozark, ALThe pilot's excessive use of the cyclic control and the misjudged flare during a practice touchdown autorotation.NTSB ANC89LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Kalskag, AKThe pilot's failure to maintain directional control of the airplane following a bounced landing.