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 MIA02LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, NCThe improper flare by the pilot-in-command resulting in a hard landing and subsequent collapse of the nose landing gear due to overload.NTSB DEN02LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Colo Springs, COthe pilot's inadequate landing flare, which resulted in a hard landing. A contributing factor was the pilot's excessive airspeed on final approach.NTSB FTW02LA011Accident · Serious injuriesLimited investigationFinal reportCameron 105 · Albuquerque, NMTher pilot's delay to compensate for changing weather conditions in-flight. Contributing factors were the high winds and an inaccurate weather forcast.NTSB ANC02LA003Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Port Alsworth, AKThe pilot's excessive descent rate and subsequent hard landing during the landing flare/touchdown. A factor in the accident was glassy water conditions.NTSB FTW02TA007Accident · No injuriesFinal reportCessna A185F · Houma, LAthe pilot's high flare, which resulted in a hard landing.NTSB NYC01LA231Accident · No injuriesLimited investigationFinal reportLet 33 · Bardstown, KYThe pilot's improper flare, which resulted in a nose-first, hard touchdown.NTSB CHI01LA326Accident · No injuriesLimited investigationFinal reportCessna 208 · Aurora, MNThe pilot not maintaining the proper descent rate during the landing. Factors were the flap's popped circuit breaker, the pilot not verifying the flap's position, the glassy water, and the dock.NTSB ANC01LA146Accident · Minor injuriesLimited investigationFinal reportDouglas DC-6B · Nuiqsut, AKThe flightcrew's continued use of an unstabilized GPS approach. Factors associated with the accident were low ceilings, and the inadequate coordination between the crew.NTSB ATL01LA113Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Punta Gorda, FLThe pilot's improper flare which resulted in a hard landing and subsequent collapse of the landing gear..NTSB MIA01LA230Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLthe student pilot's improper landing flare/touchdown while attempting to make a soft field landing during a supervised solo flight which resulted in substantial damage to the aircraftNTSB DEN01LA158Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Colo. Springs, COthe passenger's failure to follow instructions given to brace for a high wind landing, and the pilot's failure to adequately monitor the passenger's actions. A contributing factor was the thermal lift.NTSB CHI01LA307Accident · No injuriesLimited investigationFinal reportCessna 182RG · Manhattan, KSthe instructor pilot allowing an excessive descent rate to develop and not correcting the excessive descent rate.NTSB LAX01LA292Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Mesa, AZThe pilot's improper autorotation in that he failed to attain the proper descent rate resulting in a hard landing and subsequent airframe damage. A factor was the high temperature.NTSB ATL01LA096Accident · No injuriesLimited investigationFinal reportCessna R172K · Valdosta, GAThe flight instructor's improper flare of the airplane, which resulted in a hard landing. Factors were the dual student's failure to relinquish control of the airplane and the dual student's interference on the flight controls.NTSB IAD01LA105Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, METhe student pilot's improper flare, which resulted in a hard landing.NTSB MIA01LA227Accident · No injuriesLimited investigationFinal reportCessna 172S · Gadsden, ALthe pilot misjudged the flare, resulting in a hard landing, and impact with the runway.NTSB FTW01LA186Accident · No injuriesLimited investigationFinal reportCessna 421B · New Braunfels, TXthe pilot's inadequate flare of the airplane resulting in a hard landing. A contributing factor was the crosswind.NTSB CHI01LA280Accident · No injuriesLimited investigationFinal reportCessna 182A · Grosse Ile, MIBoth the CFI and the student pilot on board improperly flared the airplane and the CFI's failure to perform remedial action during the landing.NTSB FTW01LA215Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Terrell, TXthe flying pilot's failure to maintain control of the airplane during the landing flare which resulted in a hard landing. A contributing factor was the wind shear weather condition.NTSB FTW01LA201Accident · No injuriesLimited investigationFinal reportCessna 182L · Porter, TXthe pilot's improper recovery from a bounced landing.NTSB NYC01LA204Accident · No injuriesLimited investigationFinal reportRobinson R22 · Islip, NYThe flight instructor's delayed remedial action during a practice autorotation. Factors included the flight instructor's overconfidence in the pilot receiving instruction, and that pilot's improper recovery from a practice autorotation.NTSB IAD01IA093Incident · No injuriesIncident investigationFinal reportMorrison Rans S-12 · Midland, VAThe pilot's failure to obtain/maintain the proper descent rate which resulted in a hard landing and separation of the landing gear. A factor in the incident was the pilot's improper decision to participate in an unauthorized activity with his airplane.NTSB DEN01LA140Accident · No injuriesLimited investigationFinal reportMaule MT-7-235 · Las Cruces, NMThe pilot's failure to properly recover from a bounced landing. Contributing factors include his misjudgment of the flare and his lack of total experience in make and model.NTSB ATL01LA101Accident · No injuriesLimited investigationFinal reportCessna 172 · Mobile, ALThe pilot's improper landing flare that resulted in a hard landing. A factor was the pilot induced porpoise.NTSB LAX01LA266Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Flagstaff, AZThe pilot's improper recovery from a bounced landing and his failure to maintain directional control, resulting in a ground loop.NTSB MIA01LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe student pilot's improper recovery from a bounced landing resulting in a hard landing on the nose landing gear, collapse of the nose landing, the airplane sliding off the runway, and the airplane being destroyed by a postcrash fire.NTSB LAX01LA267Accident · No injuriesLimited investigationFinal reportCessna 172S · Scottsdale, AZThe pilot's misjudged landing flare, which lead to a hard landing, inadvertent porpoise, and his improper recovery from a bounced landing.NTSB ANC01LA098Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bethel, AKThe pilot's inadequate recovery from a bounced landing. A factor associated with the accident was a crosswind.NTSB LAX01LA264Accident · No injuriesLimited investigationFinal reportWilliams RV-6A · Hawthorne, CAThe pilot's failure to maintain control of his airplane during the landing flare.NTSB SEA01LA159Accident · No injuriesLimited investigationFinal reportCessna TU-206F · Minden, NVThe pilot's inadequate recovery from a bounced landing, and his improper remedial action after it became clear that he was not successfully salvaging the landing attempt. Factors include an improperly serviced nose gear strut.NTSB NYC01LA186Accident · No injuriesLimited investigationFinal reportMooney M20J · Mitchellville, MDThe flight instructor's failure to maintain control of the airplane during an aborted landing, and her delay in remedial action. A factor related to the accident was the excessive trim setting.NTSB NYC01LA185Accident · No injuriesLimited investigationFinal reportCessna 172 · Dayton, OHThe pilot excessive flare, which resulted in a hard landing.NTSB LAX01LA255Accident · No injuriesLimited investigationFinal reportHughes 269C · Tracy, CAThe pilot's misjudgement of the landing flare during an autorotation demonstration. Factors were shifting winds and an excessive descent rate.NTSB ATL01LA089Accident · No injuriesLimited investigationFinal reportCessna 172R · Ormond Beach, FLThe student pilots improper flare, and improper recovery from a bounced landing. A factor was the student pilot's lack of total experience.NTSB LAX01LA249Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Minden, NVThe student pilot's early deployment of full spoilers, resulting in an excessive sink rate and subsequent hard landing. A factor was the instructor's lack of time to take remedial action.NTSB IAD01LA080Accident · Serious injuriesLimited investigationFinal reportAerostar International RXS-8 · Flemington, NJpilot's continued flight into known adverse weather conditions, which resulted in a hard landing. A factor was the downdrafts.NTSB FTW01LA165Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Bridgeport, TXthe non-certificated pilot's improper flare which resulted in a hard landing.NTSB CHI01LA205Accident · No injuriesLimited investigationFinal reportCessna 172S · Lake in the Hil, ILThe student pilot misjudging the flare during that landing. Factors were the wrong runway selected by the student pilot, the tailwinds encountered during that landing and the flight instructor's inadequate supervision during that landing.NTSB CHI01LA208Accident · No injuriesLimited investigationFinal reportCessna 210 · Saint Charles, MOthe inadequate flare by the pilot.NTSB CHI01LA308Accident · No injuriesLimited investigationFinal reportCessna 182K · Mattoon, ILThe pilot improperly flared the airplane which resulted in a hard landing.NTSB LAX01LA235Accident · No injuriesLimited investigationFinal reportCessna 175 · Monterey, CAThe pilot's improper recovery from a bounced landing.NTSB LAX01LA232Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Hayward, CAthe student's excessive rate of descent during a practice autorotation, and, the inadequate use of the rotorcraft flight controls by both pilots during the attempted recovery, which resulted in a hard landing. The flight instructor's inadequate supervision…NTSB LAX01LA219Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Paso Robles, CAthe pilot's failure to maintain rotor rpm during a practice autorotational landing, which resulted in a hard landing.NTSB FTW01LA154Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Celina, TXthe unsuitable landing area selected by the pilot-in-command which resulted in a hard landing. A contributing factor was the uneven/rough terrain.NTSB LAX01LA217Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Auburn, CAFailure of the student pilot to maintain a proper airspeed during landing, which lead to a hard landing and porpoise down the runway leading to the collapse of the nose landing gear.NTSB MIA01FA169Accident · Minor injuriesField investigationFinal reportBell 206-L4 · Daytona Beach, FLThe failure of the pilot to maintain directional control following a hard landing resulting from a failure to maintain rotor rpm.NTSB FTW01LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Lapace, LAthe student pilot flared the airplane high, which resulted in a hard landing.NTSB CHI01LA172Accident · Serious injuriesLimited investigationFinal reportShanklin RV-6A · Poseyville, INthe premature flare by the pilot.NTSB ANC01LA069Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKThe pilot's inadequate bounced landing recovery, and his failure to correct for torque/P-factor during an aborted landing.NTSB FTW01LA145Accident · No injuriesLimited investigationFinal reportCessna 172S · Baton Rouge, LAthe student pilot's improper recovery from a bounced landing.