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 IAD97LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MAInadequate compensation for wind conditions by the pilot. A related factor was the crosswind.NTSB CHI97LA246Accident · No injuriesLimited investigationFinal reportYoung RV-4 · Sparta, WIthe pilot's inadequate compensation for wind conditions, and his improper recovery from a bounced landing, which resulted in an improper flare and hard landing. The gusty wind was a related factor.NTSB DCA97MA055Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-11 · Newark, NJThe captain's overcontrol of the airplane during the landing and his failure to execute a go-around from a destabilized flare. Contributing to the accident was the captain's concern with touching down early to ensure adequate stopping distance.NTSB CHI97LA232Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Auburn, INan improper flare by either this pilot or the pilot of a previous flight, which resulted in a hard landing and overload damage to the right main landing gear. The pilot's continued operation with a known deficiency may have been a related factor.NTSB LAX97LA258Accident · Serious injuriesLimited investigationFinal reportCentrair ASW20F · Minden, NVthe pilot's improper planning/decision and subsequent encounter with gusty winds and strong downdrafts, which precluded reaching the airport and induced an unrecoverable high sink rate during an off-airport landing.NTSB LAX97LA255Accident · No injuriesLimited investigationFinal reportCessna T210L · Corona, CAthe pilot's improper landing flare. Contributing to the accident was the failure of the pilot to correct a landing induced porpoise, and go-around.NTSB FTW97LA271Accident · No injuriesLimited investigationFinal reportCessna 152 · Sherman, TXThe pilot's delayed landing flare and his improper bounced landing recovery technique.NTSB LAX97LA249Accident · No injuriesLimited investigationFinal reportCessna 182G · Fresno, CAthe pilot's improper flare, which resulted in a hard landing and damage to the airplane.NTSB NYC97LA145Accident · Minor injuriesLimited investigationFinal reportSlingsby T65A · Bethel, PAThe pilot's improper flare. A factor in the accident was the pilot's fatigue.NTSB FTW97LA266Accident · No injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Huntsville, TXInadvertent stall due to the student pilot's failure to maintain airspeed and a proper descent rate. A factor was the inadequate supervision by the flight instructor.NTSB NYC97LA137Accident · Serious injuriesLimited investigationFinal reportAerostar-Raven S-60-A · Clyde, OHAn abrupt touchdown to avoid power lines which resulted in a hard landing. Contributing to the accident was the pilot's failure to properly brief the passengers for the landing.NTSB IAD97LA100Accident · No injuriesLimited investigationFinal reportCessna 182H · Pedrictown, NJThe pilot's improper flare.NTSB CHI97LA206Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Mackinac Island, MIthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing. Turbulence on short final was a related factor.NTSB MIA97LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing and collapse of the nose landing gear.NTSB FTW97LA234Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sugar Land, TXthe pilot's improper landing flare and improper recovery from a bounced landing.NTSB CHI97LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Lansing, ILthe pilot's inadequate compensation for wind conditions, and his failure to maintain sufficient airspeed to flare during the landing. The crosswind was a related factor.NTSB ANC97LA105Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 MK-I · Juneau, AKThe pilot's misjudged touchdown which resulted in dragging the right wingtip and rupturing the fuel tank. A factor associated with the accident is the rough water conditions.NTSB CHI97LA182Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Willard, MOremedial action delayed by the flight instructor. A factor in this accident was the instructor's lack of recent experience in this type airplane.NTSB ANC97LA086Accident · No injuriesLimited investigationFinal reportCessna 185F · Sitka, AKfailure of the pilot(s) to properly flare the airplane during a simulated forced landing. The excessive rate of descent on final approach was a related factor.NTSB MIA97LA183Accident · No injuriesLimited investigationFinal reportBeech B19 · New Smyrna Bch, FLthe private pilot's improper flare, which resulted in a hard landing and subsequent collapse of the left main landing gear and the nose gear.NTSB FTW97LA226Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · San Antonio, TXThe flight instructor's inadequate supervision during the practice autorotation and his failure to maintain rotor RPM.NTSB NYC97LA113Accident · No injuriesLimited investigationFinal reportCessna 182N · Frederick, MDThe private pilot's improper flare, and the certificated flight instructor's delayed decision to add power, which resulted in the subsequent hard landing.NTSB ANC97LA083Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKthe flight instructor's delay in taking remedial action to correct an approach for a simulated emergency landing. A factor relating to the accident was: the student pilot's excessive descent rate during the approach.NTSB FTW97LA214Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Santa Teresa, NMthe pilot-in-command's (PIC's) inadequate supervision of the flight by allowing the pilot-rated passenger to attempt a go-around (aborted landing) without maitaining minimum control speed (VMC), which resulted in loss of aircraft control. Factors relating to…NTSB SEA97LA121Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Pocatello, IDinadequate remedial action of the pilot-in-command (CFI). Related factors include: the dual student's failure to maintain the proper airspeed and descent rate.NTSB CHI97LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Crystal, MNthe student pilot's misjudged flare and improper recovery from a bounced landing. A factor was the lack of recent flight time.NTSB NYC97FA098Accident · No injuriesField investigationFinal reportBoeing 767-300 · Newark, NJThe improper landing flare by the co-pilot and the inadequate supervision of the flight by the pilot-in-command. Other related factors were the gusty crosswind, windshear, and the lack of familiarity with the airplane by both pilots.NTSB CHI97LA165Accident · No injuriesLimited investigationFinal reportCessna 182RG · Kansas City, MOthe pilot's improper flare, which resulted in a hard landing. A factor relating to the accident was the excessive airspeed.NTSB MIA97LA170Accident · No injuriesLimited investigationFinal reportCessna 150F · Venice, FLfailure of the pilot to maintain sufficient airspeed on final approach and during the landing to properly flare the airplane.NTSB CHI97LA129Accident · No injuriesLimited investigationFinal reportBeech B33-35 · Mishawaka, INImproper flare. A factor associated with the accident was the gusty, crosswind condition.NTSB FTW97LA188Accident · No injuriesLimited investigationFinal reportAeromot AMT-200 · Longmont, COthe dual student pilot's improper landing flare and the flight instructor's inadequate supervision of the flight.NTSB FTW97LA195Accident · No injuriesLimited investigationFinal reportCessna 182K · Little Rock, ARthe pilot's improper flare and improper recovery from a bounced landing.NTSB NYC97LA082Accident · No injuriesLimited investigationFinal reportBeech F33A · Mattituck, NYthe pilot's inadequate compensation for the wind conditions and improper flare, which resulted in a hard landing.NTSB ANC97LA063Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKthe flight instructor's inadequate preflight by failing to ensure his seat was properly latched, and his resultant failure (or inability) to recover from the student pilot's bounced landing. A factor associated with the accident was: the student pilot's…NTSB CHI97LA118Accident · No injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAfailure of the student pilot to maintain directional control, inadequate supervision by the flight instructor (CFI), and subsequent failure of the pilot(s) to properly flare the helicopter during a hover autorotation.NTSB FTW97LA164Accident · No injuriesLimited investigationFinal reportCessna 150F · Norman, OKImproper flare.NTSB IAD97LA068Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wellsville, NYthe student pilot's improper flare, improper recovery from a bounced landing, and loss of directional control, during the landing.NTSB CHI97LA111Accident · No injuriesLimited investigationFinal reportCessna 177 · Rantoul, ILthe student pilot's improper flare and improper recovery from a bounced landing.NTSB NYC97LA078Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Belmar, NJThe student pilot's improper decision to taxi off the runway into sand after the nose gear collapsed. A factor in the accident was the student pilot's improper flare.NTSB NYC97LA077Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincoln Park, NJthe student pilot's improper recovery from a bounced landing which resulted in a hard landing, collapsed nose gear, loss of directional control, and subsequent nose over.NTSB FTW97TA162Accident · No injuriesFinal reportHughes OH-6A · Marfa, TXthe pilot's improper touchdown, and the designated examiner's inadequate supervision. The light condition at dusk was a related factor.NTSB LAX97LA159Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX8-88 · San Diego, CAThe pilot's decision to increase sink rate to avoid flying into an obstacle with insufficient altitude remaining to reduce the sink rate prior to impact with the ground.NTSB MIA97LA131Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Stuart, FLThe pilot's failure to maintain directional control during a crosswind landing. Factors were the crosswind and his improper level off.NTSB MIA97LA116Accident · No injuriesLimited investigationFinal reportRosen ONE Design · Lakeland, FLThe pilot's improper recovery from a bounced landing.NTSB LAX97LA144Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Knights Landing, CAthe pilot's failure to maintain minimum control airspeed during the approach. Contributing to the accident was the pilot's failure to maintain directional control after landing.NTSB MIA97LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · Tampa, FLthe pilot's improper compensation for wind conditions and failure to properly flare the airplane for landing. Factors relating to the accident were: the gusty/quartering wind conditions, and the pilot's improper use of flaps for landing.NTSB MIA97LA114Accident · No injuriesLimited investigationFinal reportCessna 150G · St. Petersburg, FLthe student pilot's improper level off.NTSB ANC97LA070Accident · No injuriesLimited investigationFinal reportPiper J-3 · Soldotna, AKThe pilot's inadequate compensation for the gusty wind conditions, and his improper recovery from a bounced landing. A factor associated with the accident was the gusty wind.NTSB MIA97LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Pompano Beach, FLthe pilot's improper flare and improper recovery from a bounced landing, which resulted in overload failure of the nose gear.NTSB MIA97LA102Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Bessemer, ALthe student pilot's misjudged landing flare and the CFI's inadequate supervision by not taking timely remedial action.