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 NYC93LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Cortland, NYThe student pilot's improper recovery from a bounced landing, resulting in a hard landing and collapse of the nose gear. A factor was the student pilot's inexperience.NTSB CHI93LA338Accident · No injuriesLimited investigationFinal reportBeech 19 · Elkhart, INinadequate remedial action by the flight instructor. Factors related to the accident were the excessive descent rate and the overload failure of the landing gear.NTSB SEA93LA184Accident · No injuriesLimited investigationFinal reportCessna 206B · Challis, IDInadequate compensation for wind conditions. The downdraft was a factor.NTSB SEA93LA185Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Garfield, WAThe pilot's improper flare and recovery from a bounced landing. Factors include approach airspeed not maintained, a lack of total experience, and a ditch near the runway.NTSB CHI93LA331Accident · No injuriesLimited investigationFinal reportBeech 23 · Milwaukee, WIthe student pilot's improper recovery from a bounced landing.NTSB LAX93LA332Accident · No injuriesLimited investigationFinal reportCessna 152 · Glendale, AZThe student pilot's improper flare and recovery from the ensuing bounced landing.NTSB CHI93LA321Accident · No injuriesLimited investigationFinal reportR.D. Bell/Pietenpol Aircamper · Pontiac, MIThe pilot in command not maintaining a proper descent rate during the final approach and landing flare phase of flight.NTSB CHI93LA320Accident · Minor injuriesLimited investigationFinal reportBell 47-G5 · Schaumburg, ILthe pilot's improper autorotation techniques.NTSB NYC93LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Fryeburg, METhe student pilot's improper recovery from a bounced landing resulting in the collapse of the nose gear and the subsequent nose over. A factor was an improper flare.NTSB CHI93LA308Accident · No injuriesLimited investigationFinal reportBeech 19A · Ludington, MIthe pilot's misjudged landing flare.NTSB ATL93LA140Accident · No injuriesLimited investigationFinal reportCessna 172M · Manteo, NCInadequate compensation for wind conditions by the pilot. Factors related to the accident were: the adverse wind and the pilot's failure to obtain a weather briefing (inadequate weather evaluation).NTSB DEN93LA098Accident · No injuriesLimited investigationFinal reportBoeing 757-222 · Denver, COThe first officer's improper recovery from a bounced landing. Factors were: the first officer's delayed initiation of the flare, and the captain's improper supervision of the flight.NTSB NYC93LA143Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Milford, NHUnfavorable winds during landing which resulted in a hard landing and one passenger sustaining a broken angle.NTSB CHI93LA301Accident · 1 fatalLimited investigationFinal reportCessna 180 · Naubinway, MIThe pilot's improper flare for landing. Factors associated with the accident are the low clouds and fog, the rough water at the landing site, and the pilot's continued flight into known adverse weather.NTSB CHI93LA307Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Excelsior Spgs, MOthe private pilot's failure to maintain adequate aircraft control during landing.NTSB MIA93LA166Accident · No injuriesLimited investigationFinal reportCessna 414 · Lake City, FLThe failure of the pilot-in-commmand to properly flare before touchdown and the pilot's decision to land with excessive airspeed. A contributing factor was the aprehension/anxiety of the pilot during the precautionary landing.NTSB LAX93LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · San Carlos, CAThe cfi's inadequate supervision of the flight, the improper recovery from the bounced landing by the crew, and the lack of total experience in giving dual instruction by the CFI. Factors which contributed to this accident were: the dual student's improper…NTSB DEN93LA087Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Wray, COThe pilot's inadequate compensation for the wind conditions and improper recovery from a bounced landing. The gusty crosswind was a factor.NTSB DEN93LA086Accident · Serious injuriesLimited investigationFinal reportBalloon Works 7B-15 · Colorado Sprgs, COThe passenger's failure to assume the proper landing position as instructed by the pilot in command. A factor was: the high wind.NTSB CHI93LA277Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Flushing, MIThe pilot's inadequate preflight planning for determining the proper takeoff profile. A factor in the accident was the high density altitude.NTSB CHI93LA317Accident · No injuriesLimited investigationFinal reportCessna 182M · Ironwood, MIThe pilot's improper flare for landing.NTSB MIA93LA159Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX8-105 · Jacksonville, FLThe improper procedures by the pilot-in-command.NTSB CHI93LA265Accident · No injuriesLimited investigationFinal reportBeech C24R · Chesterfield, MOthe pilot's improper recovery from a bounced landing.NTSB CHI93LA258Accident · No injuriesLimited investigationFinal reportMaule M4 · Tomahawk, WIthe pilot's improper recovery from a bounced landing.NTSB ANC93LA118Accident · No injuriesLimited investigationFinal reportLake LA4 · Turner Lake, AKPilot-in-command misjudged the landing flare on a glassy water landing. A factor in the accident was the glassy water condition.NTSB FTW93LA210Accident · No injuriesLimited investigationFinal reportCessna 172M · Lamesa, TXThe pilot's improper flare, improper recovery from a bounced landing and the inadvertent stall. A factor was the gusty wind.NTSB BFO93LA114Accident · No injuriesLimited investigationFinal reportBeech A36 · Falmouth, MAThe pilot's inadequate compensation for wind conditions and improper recovery from a bounced landing. The gusty wind condition was a related factor.NTSB NYC93LA134Accident · No injuriesLimited investigationFinal reportCessna 150E · Oxford, METhe pilot's improper landing flare which resulted in a hard landing. A factor was the pilot's lack of experience.NTSB ATL93LA114Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Smyrna, TNThe improper flare and the improper go around procedures used by the pilotNTSB CHI93LA210Accident · No injuriesLimited investigationFinal reportBeech B19 · Janesville, WIThe pilot's improper landing flare.NTSB NYC93LA109Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Glen Mills, PAAn improperly planned approach in which the flare was not attained, and which resulted in a hard landing.NTSB NYC93LA105Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Provincetown, MAThe pilot's failure to recover from a bounced landing and to maintain aircraft control which resulted in the airplane nosing over. Improper landing flare is a contributing factor.NTSB MIA93LA139Accident · No injuriesLimited investigationFinal reportBeech 23 · Tampa, FLThe pilot-in-command's improper landing flare, which resulted in the aircraft bouncing and entering a porpoise maneuver. Contributing to the accident was his failure to recover from the bounced landing and perform a go-around.NTSB CHI93LA190Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Indianapolis, INa misjudged flare and subsequent hard landing by the student pilot. A factor in the accident was the student pilot's failure to perform a go-around.NTSB ANC93LA071Accident · No injuriesLimited investigationFinal reportCessna 185 · Bulchitna Lake, AKThe failure of the landing gear leg due to a fatigue fracture caused by corrosion.NTSB SEA93LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Cheyenne, WYThe pilot's improper flare and improper recovery from a bounced landing. Factors include strong crosswinds, downdrafts, and an excessive descent rate.NTSB CHI93LA189Accident · No injuriesLimited investigationFinal reportCessna 150M · Jeffersonville, INThe flight instructor's delayed remedial action and failure to assure recovery from a bounced landing. A factor related to the accident was: improper flare by the student pilot.NTSB DEN93LA061Accident · No injuriesLimited investigationFinal reportCessna 172N · Buena Vista, COA downdraft and the pilot's failure to maintain directional control of the airplane. Factors were: a crosswind and the inadvertent selection of additional flaps.NTSB SEA93LA116Accident · Serious injuriesLimited investigationFinal reportRambow Monnett Moni · Ritzville, WAThe improper landing flare.NTSB SEA93LA111Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Walla Walla, WAThe premature landing flare by the pilot which resulted in a hard landing and the pilot's failure to maintain airspeed above stall speed during the balked landing.NTSB BFO93LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape May, NJThe pilot's failure to properly flare during landing, and his failure to properly recover from a bounced landing.NTSB DEN93LA059Accident · No injuriesLimited investigationFinal reportCessna 305A · Fort Collins, COAn excessive rate of descent resulting in a hard landing.NTSB CHI93LA172Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · West Chicago, ILThe pilot-in-command's inadequate compensation for the wind conditions he encountered during the landing approach and touchdown and not maintaining a proper descent rateNTSB CHI93LA163Accident · No injuriesLimited investigationFinal reportCessna 150J · Rice Lake, WIThe student pilot's failure to maintain directional control of the airplane.NTSB BFO93LA066Accident · No injuriesLimited investigationFinal reportQuickie 200 · N. Kingstown, RIImproper flare by the pilot.NTSB LAX93IA198Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-11 · Los Angeles, CAThe pilot's improper flare and improper recovery from a bounced landing.NTSB BFO93LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Turner Falls, MAThe pilot's improper flare and improper recovery from a bounced landing.NTSB LAX93LA193Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Monica, CAThat the pilot misjudged the flare and failed to properly recover from the ensuing bounced landing. The pilot's failure to attain the proper touchdown point was a factor.NTSB LAX93LA209Accident · No injuriesLimited investigationFinal reportBell 47-G2 · AntarcticaThe pilot's poorly planned approach.NTSB NYC93LA093Accident · Minor injuriesLimited investigationFinal reportRobinson R22B · Murraysville, PAFailure of the pilot to maintain rotor RPM, which resulted in a hard landing and rollover. A factor related to the accident was the pilot's lack of total helicopter experience.