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 NYC94LA169Accident · No injuriesLimited investigationFinal reportDonald E. Kovol Quickie 2 · Akron, OHThe failure of the pilot to maintain airspeed which resulted in an inadequate flare and a hard landing. A factor was the pilot's lack of experience in the airplane.NTSB CHI94LA312Accident · No injuriesLimited investigationFinal reportCessna 172 · Milwaukee, WIthe pilot's improper flare during touchdown. A factor in the accident was the rupture of the nose landing gear tire.NTSB MIA94LA205Accident · No injuriesLimited investigationFinal reportCessna 172N · Orlando, FLThe pilot-in-command's improper landing flare/touchdown, resulting in a hard landing, and subsequent separation of the nose gear.NTSB FTW94LA291Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Hurst, TXThe certificated flight instructor's inadequate supervision. A factor was the pilot's failure to maintain proper landing alignment.NTSB CHI94LA309Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Storm Lake, IAthe pilot's excessive rate of descent to landing. Factors in the accident were the gusts and downdraft.NTSB ATL94LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · W. Columbia, SCThe student pilot's failure to properly flare the aircraft, resulting in a hard landing.NTSB MIA94LA201Accident · No injuriesLimited investigationFinal reportMankovich Parakeet · Fernandina Bch, FLThe improper flare by the pilot-in-command resulting in the hard landing, and the pilot's failure to perform a recovery from the bounced landing. Contributing to the accident was the pilot's lack of total time in this type airplane.NTSB LAX94LA337Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Sedona, AZa tip over of the balloon and basket during a high wind landing due to the pilot's inability to compensate for the increased wind speed conditions during the final stages of the flight and landing.NTSB CHI94MA290Accident · No injuriesMajor investigationFinal reportMcDonnell Douglas MD-11F · Chicago, ILThe first officer's improper flare and improper use of flight controls during the landing flare/touchdown.NTSB ANC94LA139Accident · No injuriesLimited investigationFinal reportCessna 182B · Ketchikan, AKThe failure of the pilot to maintain directional control of the airplane during a hard landing. The pilot's improper recovery from a bounced landing and a downdraft were factors in the accident.NTSB CHI94LA287Accident · No injuriesLimited investigationFinal reportHughes 369HS · Custer, SDthe pilot's selection of unsuitable terrain on which to perform an autorotation. A factor in this accident was the hidden obstruction.NTSB LAX94LA321Accident · No injuriesLimited investigationFinal reportCessna 172P · Scottsdale, AZthe pilot's misjudging the flare altitude and failing to maintain adequate airspeed resulting in an inadvertent stall and hard landing. The pilot's lack of total time in the airplane is a factor in this accident.NTSB LAX94LA311Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA316B · Stateline, NVthe failure of the pilot to maintain the proper rate of descent during the vertical descent into the landing zone, which resulted in a hard landing. Factors in the accident were high density altitude and dark night light conditions.NTSB CHI94LA267Accident · No injuriesLimited investigationFinal reportDe Havilland Tiger Moth DH-82A · Interlochen, MIthe failure of the pilot to obtain the proper climb rate, and inadequate compensation for wind conditions.NTSB CHI94LA261Accident · No injuriesLimited investigationFinal reportCessna 172 · Aberdeen, SDthe pilot's failure to maintain directional control during landing. A related factor is the dark night conditions.NTSB LAX94LA305Accident · No injuriesLimited investigationFinal reportCessna 172N · Cameron Park, CAthe pilot's improper use of the elevator control during the landing flare.NTSB MIA94LA186Accident · No injuriesLimited investigationFinal reportCessna 152 · Palatka, FLThe student pilot's improper landing flare and failure to properly recover from a bounced landing.NTSB CHI94LA250Accident · No injuriesLimited investigationFinal reportCessna 421C · Oshkosh, WIthe pilot-in-command's misjudging the flare and his failure to maintain airspeed.NTSB NYC94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Lumberton, NJThe pilot's (1) improper recovery from a bounced landing and (2) failure to maintain directional control during an aborted landing. A factor is the pilot's improper landing flare.NTSB SEA94LA191Accident · Serious injuriesLimited investigationFinal reportAvian Magnum 9 · Pasco, WAA physical impairment that reduced the passenger's ability to hold on to the basket during the hard landing. Factors include an excessive rate of descent at touchdown.NTSB ATL94LA151Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Columbus, GAThe dual student's failure to properly flare the aircraft during the landing. Factors were the dusk light conditions, and the flight instructor's inadequate supervision of the dual student.NTSB SEA94LA184Accident · No injuriesLimited investigationFinal reportBlack RV-4 · Twisp, WAProper descent rate was not maintained during approach.NTSB CHI94LA231Accident · No injuriesLimited investigationFinal reportCessna 150 · Alton, ILthe student pilot's improper recovery from a bounced landing. A factor associated with the accident is the student pilot's misjudged landing flare.NTSB LAX94LA291Accident · No injuriesLimited investigationFinal reportCessna 152 · Livermore, CAthe student's misjudged landing flare and improper bounced landing recovery.NTSB SEA94LA166Accident · No injuriesLimited investigationFinal reportHughes 369HS · West Jordan, UTThe pilot not maintaining a proper descent rate and his delayed remedial action.NTSB ANC94LA073Accident · No injuriesLimited investigationFinal reportMaule M-5 · Anchorage, AKThe pilot's improper landing technique which resulted in a hard landing, tire failure, and eventual loss of directional control.NTSB CHI94LA213Accident · No injuriesLimited investigationFinal reportBeech 19 · Ionia, MIthe pilot's improper use of the throttle control. A factor related to the accident was the improper flare.NTSB BFO94LA122Accident · No injuriesLimited investigationFinal reportBeech C23 · Easton, MDThe flight instructor's inadequate supervision, resulting in a hard landing and a subsequent collapse of the nose gear. Also causal to the accident, was the student pilot's improper raising of the wing flaps during the landing flare.NTSB CHI94LA284Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX7-77 · West Chicago, ILthe pilot's failure to maintain proper descent rate.NTSB ATL94LA146Accident · No injuriesLimited investigationFinal reportSwearingen SA-26AT · Greenville, SCThe pilot's failure to properly flare the aircraft during landing, resulting in a hard landing.NTSB BFO94LA115Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Orrington, METhe pilot misjudged his altitude and airspeed which resulted in a hard landing. Related factors were the soft, and upslope field.NTSB MIA94LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe pilot's improper flare and improper recovery from a bounced landing. .NTSB CHI94LA194Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Peoria, ILthe pilot's misjudged landing flare. A factor associated with the accident is the pilot allowing the airplane to descend at an excessive rate.NTSB MIA94LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Lauderdale, FLThe pilot's improper flare and failure to maintain directional control during the aborted landing.NTSB FTW94LA196Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Wellington, COThe pilot's improper spoiler extension and flare.NTSB FTW94LA193Accident · No injuriesLimited investigationFinal reportBell 47H-1 · Tulsa, OKThe pilot's failure to maintain rotor RPM, his delayed landing flare, and the improper touchdown.NTSB ATL94GA111Accident · No injuriesFinal reportGrumman G-164A · Savannah, GAThe pilot's improper landing flare which resulted in a hard landing. A factor was the operators failure to provide a formal emergency dump procedure.NTSB MIA94LA151Accident · No injuriesLimited investigationFinal reportCessna 150H · Sugarloaf Key, FLThe improper flare and improper recovery from a bounced landing by the pilot-in-command.NTSB CHI94LA186Accident · No injuriesLimited investigationFinal reportHawker Siddeley DH-125-3A · Waukegan, ILwas the pilot-in-command disregarding the location of the flight manifest container in the cockpit. Factor's associated with the accident were a jammed control column and inadequate procedures for the use and storage of the flight manifest container on the…NTSB CHI94LA184Accident · No injuriesLimited investigationFinal reportCessna 150M · Concordia, KSthe pilot-in-command's misjudging of the altitude of the airplane and his diversion of attention during the landing. A factor was the improper use of the throttle by the pilot-in-command.NTSB SEA94LA144Accident · No injuriesLimited investigationFinal reportCessna 182P · Salt Lake City, UTAn improper flare by the pilot, who was landing the aircraft, at the time it was damaged.NTSB NYC94LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Toronto, OHthe pilot's improper flare, which resulted in the nose gear collapsing and the subsequent nose over of the airplane.NTSB MIA94LA157Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Bunnell, FLThe pilot-in-command's improper use of flight controls (cyclic/collective) resulting in a hard landing.NTSB FTW94LA207Accident · No injuriesLimited investigationFinal reportCessna 182L · Mineola, TXThe pilot's delayed landing flare and his improper bounced landing technique.NTSB FTW94LA172Accident · Serious injuriesLimited investigationFinal reportCameron V-77 · Durango, COThe pilot did not attain a proper level off during landing. A downdraft which was encountered was a factor.NTSB CHI94LA165Accident · No injuriesLimited investigationFinal reportBurkhart Grob BG 103 · Ionia, MIa hard landing as a result of the early disconnect of the glider launch/tow equipment.NTSB CHI94LA164Accident · No injuriesLimited investigationFinal reportBeech B23 · Faribault, MNa hard landing as a result of the flight instructor's delayed remedial action. A factor associated with the accident is the student pilot's improper flair.NTSB NYC94LA084Accident · No injuriesLimited investigationFinal reportCessna 421A · Richlands, VAThe hard landing, as a result of the pilot's misjudged rate of descent. A factor related to the accident was the pilot's limited experience in this make and model airplane.NTSB NYC94LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellington, CTThe student pilot's improper recovery from a bounced landing which resulted in a loss of directional control. A factor was the student pilot's imroper landing flare, which resulted in a hard landing.NTSB BFO94LA080Accident · No injuriesLimited investigationFinal reportCessna 150L · Farmingdale, NJThe student pilot's improper flare and the flight instructor's inadequate supervision.