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 ANC91LA138Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Cube Cove, AKThe encounter with windshear.NTSB ANC91LA159Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Dry Bay, AKThe pilot failed to maintain adequate airspeed and stalled the airplane. Contributing to the accident was the unsuitable terrain on which the pilot chose to land.NTSB LAX91LA373Accident · No injuriesLimited investigationFinal reportCessna 152 · Montague, CAThe pilot's improper flare and improper go-around procedure. Contributing to the accident was the lack of total pilot experience.NTSB LAX91LA372Accident · No injuriesLimited investigationFinal reportCessna 182 · Columbia, CAThe pilot of the aircraft experienced a bounced landing on his initial landing attempt. He executed a go-around and landed without incident on the second attempt. Substantial damage to the firewall was discovered afterwards. The pilot believes the bounced…NTSB FTW91LA154Accident · No injuriesLimited investigationFinal reportBell L4 Experimental · Arlington, TXThe pilot's failure to maintain adequate rotor RPM during the planned autorotation and his improper touchdown.NTSB MIA91LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Marianna, FLThe student pilot's failure to maintain proper airspeed during landing and failure to execute a go-around in a timely manner.NTSB FTW91LA148Accident · No injuriesLimited investigationFinal reportBeech B19 · Poteau, OKThe improper flare technique utilitzed by the pilot under instruction. A factor was the failure of the check pilot to intervene.NTSB FTW91LA150Accident · No injuriesLimited investigationFinal reportHughes 269A-1 · No. Little Rock, ARThe pilot's failure to maintain main rotor RPM, his delayed flare, and the improper touchdown.NTSB NYC91LA214Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Montauk, NYThe pilot made a hard landing, resulting in the main landing gear collapsing. Contributing to the accident was the pilot's interpretation of the wind conditions, misjudgment of the flare causing the airplane to balloon and stall.NTSB ANC91LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gulkana, AKThe pilot's failure to maintain adequate airspeed, resulting in a stall, hard landing and collapse of the main landing gear.NTSB CHI91LA253Accident · No injuriesLimited investigationFinal reportCessna 180 · Eveleth, MNThe pilot's failure to maintain the proper descent rate and adequate airspeed during the approach. A factor related to the accident is the lack of recent total experience.NTSB FTW91LA135Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Mesquite, TXThe flight instructor's inadequate supervision of the student. Factors were the dual student's misjudgement of altitude and premature flare of the airplane.NTSB FTW91LA133Accident · No injuriesLimited investigationFinal reportCessna 150 · Searcy, ARThe pilots misjudgment of altitude and lack of a timely flare.NTSB CHI91LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Winona, MNImproper flare performed by the pilot. A factor related to the accident was lack of total experience by the pilot.NTSB NYC91LA137Accident · No injuriesLimited investigationFinal reportBeech C-23 · Chesapeake, OHThe pilot's failure to maintain an adequate airspeed that would preclude a stall. Contributing to the accident was the opened door.NTSB MIA91LA229Accident · No injuriesLimited investigationFinal reportBell 206B · Vero Beach, FLThe pilot-in-command's failure to maintain the proper descent rate resulting in a hard landing.NTSB LAX91LA295Accident · No injuriesLimited investigationFinal reportPiper PA 22 · Duncan, AZThe pilot's failure to maintain a proper airspeed during the approach and an inadvertent entry into a stall/mush which resulted in a hard landing.NTSB NYC91LA170Accident · No injuriesLimited investigationFinal reportCessna 152 · Rutland, VTThe student pilot improper recovery from a bounced landing which resulted in the collapsing of the nose gear. A factor related to the accident was the student pilot's lack of total flight experience.NTSB FTW91LA116Accident · No injuriesLimited investigationFinal reportCessna 172P · Lakeview, AR(1) The pilot's failure to properly flare the airplane for landing and (2) his subsequent improper recovery from a bounced landing.NTSB SEA91LA151Accident · No injuriesLimited investigationFinal reportBeech C33A · Brookings, ORThe pilot's improper flare for touchdown, and her improper recovery from a bounced landing.NTSB DEN91LA094Accident · No injuriesLimited investigationFinal reportCessna 172P · Watkins, COThe pilot's failure to maintain directional control of the aircraft. A factor was the pilot misjudging his flare.NTSB FTW91LA112Accident · No injuriesLimited investigationFinal reportBell 206L-1 · S. Tim 171dThe high rate of descent and delayed flare.NTSB LAX91LA278Accident · No injuriesLimited investigationFinal reportCessna 182Q · Watsonville, CAThe pilot's improper flare and improper recovery from a bounced landing. Factors related to the accident were: gusty winds, the pilot's inadequate compensation for wind conditions, and the pilot's lack of experience in this make and model of aircraft.NTSB NYC91LA155Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Doylestown, PAThe flight instructor allowed the student to continue a simulated engine failure to a hard landing, resulting in a bounced landing and loss of directional control and a collision with the VASI.NTSB BFO91LA057Accident · No injuriesLimited investigationFinal reportCessna 182 · Baltimore, MDThe pilot's improper flare and improper recovery from a bounced landing.NTSB SEA91LA149Accident · No injuriesLimited investigationFinal reportCessna 210 · Salt Lake City, UTThe pilot's poor inflight planning and decisions in that he failed to anticipate wake turbulence from the departing helicopter.NTSB ATL91LA114Accident · No injuriesLimited investigationFinal reportCessna 182R · Dothan, ALLack of supervision by the flight instructor who allowed a dual student to make a hard landing.NTSB SEA91LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Corvallis, ORThe student pilot's overconfidence in his personal ability and inadquate remedial action. Contributing to the accident was his decision to attempt a solo autoroation.NTSB LAX91LA264Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Phoenix, AZThe failure of the student to maintain the proper rotor RPM while performing a practice autorotation, and, the failure of the flight instructor to properly supervise the conduct of the flight and to take timely corrective action.NTSB SEA91LA138Accident · Minor injuriesLimited investigationFinal reportCessna C175 · East Glacier, MTThe pilot's failure to maintain sufficient airspeed. Contributing to the accident was: the gusty wind conditions and the pilot's lack of experience in this type of operation.NTSB DEN91LA085Accident · No injuriesLimited investigationFinal reportCessna 172J · Rifle, COThe student pilot improperly flared the aircraft during landing.NTSB DEN91LA084Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lafayette, COThe pic's abrupt touchdown. Factors were: approach reference speed not maintained, proper descent rate not maintained by the PIC and inattention by the designated examiner.NTSB FTW91LA097Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · New Orleans, LAThe pilot's improper recovery from a bounced landing. A factor was: the pilot's lack of total experience in model.NTSB DEN91LA081Accident · No injuriesLimited investigationFinal reportCessna 182P · Santa Fe, NMThe pilot misjudged the flare during landing.NTSB CHI91DEX03Accident · No injuriesFinal reportCessna 320F · Washington, INExceeding the aircraft's proper descent rate by the pilot in command. Factors related to the accident were inoperative runway edge lights, proper alignment not attained, improperly planned approach, and inadequate facility maintenance.NTSB LAX91LA246Accident · No injuriesLimited investigationFinal reportCessna 182 · Lincoln, CAThat the pilot-in-command improperly flared the airplane by misjudging the altitude and improper recovery from the bounced landing.NTSB MIA91LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Pensacola, FLThe pilot-in-command's improper flare and recovery from a bounced landing resulting in a hard landing and collapse of the nose landing gear.NTSB SEA91FA124Accident · No injuriesField investigationFinal reportBell 206BII · Brewster, WAThe pilot-in-command's selection of unsuitable terrain for the emergency simulation.NTSB LAX91LA244Accident · No injuriesLimited investigationFinal reportCessna 172M · Willits, CAThat the pilot misjudged the flare and failed to properly recover from a bounced landing. Contributing to this accident was entering into an inadvertent porpoise.NTSB CHI91LA174Accident · Serious injuriesLimited investigationFinal reportCameron N120 · Overland Park, KSThe pilot's failure to maintain a proper descent rate during an approach for landing.NTSB ATL91LA147Accident · No injuriesLimited investigationFinal reportCessna 150J · Greensboro, NCThe pilot's improper flare during the landing. Factors in the accident were the dark night and lack of runway edge lights.NTSB LAX91LA210Accident · No injuriesLimited investigationFinal reportCessna 152 · Banning, CAThe failure of the pilot to utilize the proper technique to recover the airplane from a bounced landing.NTSB CHI91LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIRecovery from a bounced landing was improper by the pilot. Factors related to the accident were lack of recent experience by the pilot.NTSB CHI91LA149Accident · No injuriesLimited investigationFinal reportCessna 172 · Neosho, WIThe pilot's failure to properly flare the airplane and an improper recovery from a bounced landing.NTSB LAX91LA194Accident · No injuriesLimited investigationFinal reportLancair 320 · Fall River Mill, CAFailure of the pilot-in-command to compensate for wind conditions and to recover from a bounced landing which resulted in an on ground loss of control. Contributing to the accident was the wind conditions and turbulence at the airport at the time of the…NTSB NYC91LA124Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124A · Oxford, CTThe failure of the pilot to maintain the proper landing descent rate and the resultant right main landing gear assembly collapse.NTSB LAX91LA187Accident · No injuriesLimited investigationFinal reportBeech F33A · Goodyear, AZThe pilot's failure to ensure that the airplane's landing gear was extended by the passenger who he was allowing fly the airplane. A contributing factor related to the pilot's inadequate supervision of the passenger.NTSB NYC91LA118Accident · No injuriesLimited investigationFinal reportCessna P210 · Olean, NYImproper flare by the pilot, which resulted in a hard landing. Factors related to the accident were: the pilot's lack of recent experience and the unfavorable wind condition.NTSB LAX91LA162Accident · No injuriesLimited investigationFinal reportHughes 369D · Yerington, NVThe pilot's excessive airspeed and rate of descent on final approach to land, and subsequent loss of rotor RPM while attempting to flare. The ditch was a related factor.NTSB ATL91LA082Accident · No injuriesLimited investigationFinal reportCessna 172P · Hatteras, NCThe pilot's improper landing flare, subsequent inadvertent porpoise, and his failure to execute a bounced landing recovery.