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 CHI98LA310Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Leland, ILControl interference between the pilot-in-command and the student. An excessive descent rate and inadequate flare by the student during landing are contributing factors. The inadequate supervision by the pilot-in-command is an additional factor.NTSB CHI98LA261Accident · No injuriesLimited investigationFinal reportCessna 182A · Springbrook, WIThe pilot's improper attitude and excessive sink rate during landing. The terrain condition was a contributing factor in the accident.NTSB FTW98LA314Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COThe pilot's improper landing flare which resulted in a hard landing.NTSB FTW98LA297Accident · No injuriesLimited investigationFinal reportPeebles/Lancair 360 LC-20 · Price, UTThe pilot's excessive descent rate on final approach and his delayed use of power to arrest the excessive descent rate.NTSB CHI98LA268Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Indianapolis, INthe delayed in-flight decision of the pilot in command to take control of the aircraft and the proper airspeed not obtained/maintained by the pilot in command which resulted in a stall. A factor to the accident was the runway light.NTSB ATL98LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Vero Beach, FLThe pilot's improper flare which resulted in a hard landing.NTSB SEA98LA129Accident · No injuriesLimited investigationFinal reportCessna 150 · Oregon City, ORThe pilot's improper flare.NTSB ATL98LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Homestead, FLThe pilot's improper flare that resulted in a hard landing and porpoise, and his improper recovery from the bounced landing.NTSB FTW98LA282Accident · No injuriesLimited investigationFinal reportBeech B19 · Frisco, TXThe student pilot's improper landing flare which resulted in a hard larding. Factors were the inadequate supervision of the flight by the flight instructor and the high winds.NTSB LAX98LA205Accident · No injuriesLimited investigationFinal reportOfford KR-2 · San Diego, CAThe pilot's failure to attain/maintain adequate airspeed during an attempted go-around.NTSB FTW98LA284Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus CM · Taos, NMThe pilot's improper flare. Contributing to the accident was the sudden wind shift which rendered the aircraft uncontrollable when the aircraft was on final approach to land.NTSB CHI98LA194Accident · Serious injuriesLimited investigationFinal reportLeone Smith Mini Plane · Northport, MIthe pilot's not maintaining airspeed, and his lack of total experience in this type of aircraft.NTSB MIA98LA170Accident · No injuriesLimited investigationFinal reportBell 47G · Bunnell, FLThe pilot-in-command(CFI) failure to maintain control of the aircraft.NTSB ANC98LA053Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Minchumina, AKThe pilot's failure to maintain directional control while landing. A factor associated with this accident was the pilot's inadequate recovery from a bounced landing.NTSB ATL98LA079Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Cordele, GAThe pilot's improper descent rate that led to a hard landing and porpoise, and his improper recovery from the ensuing bounced landing, resulting in the eventual separation of the empennage. A factor was the updraft.NTSB LAX98LA176Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Fresno, CAThe dual's student improper flare that led to the right main landing gear collapsing. A related factor in the accident was the instructor pilot's inadequate supervision.NTSB FTW98LA235Accident · No injuriesLimited investigationFinal reportBell 206BIII · Hurst, TXThe pilot's delayed recovery from a simulated autorotative landing.NTSB FTW98LA279Accident · No injuriesLimited investigationFinal reportSchweizer 269C · San Angelo, TXThe improper touchdown executed by the flight instructor, which resulted in the tail rotor impacting the ground.NTSB ANC98LA051Accident · No injuriesLimited investigationFinal reportCessna 182A · Palmer, AKThe pilot's failure to abort the landing. A factor associated with the accident is the presence of a variable wind condition.NTSB LAX98LA160Accident · No injuriesLimited investigationFinal reportRobinson R22B · San Jose, CAThe student pilot's failure to maintain adequate rotor rpm, and the flight instructor's inadequate supervision of the flight.NTSB IAD98LA069Accident · No injuriesLimited investigationFinal reportCessna 182L · Marlborough, MAThe pilot's improper flare. A related factor was the crosswind.NTSB CHI98LA163Accident · No injuriesLimited investigationFinal reportButler Tool RAF 2000 · Rensselaer, INthe pilot excessively flared the gyroplane during the landing.NTSB CHI98LA166Accident · No injuriesLimited investigationFinal reportEnstrom F28 · West Chicago, ILthe student pilot attempting a tailwind landing and improper compensation for the wind resulting in too high of a sink rate and the hard landing.NTSB IAD98LA058Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Winchester, VAImproper flare. A related factor was the pilot's diverted attention.NTSB ATL98LA075Accident · No injuriesLimited investigationFinal reportCessna 310Q · Lafayette, GAThe pilot's improper flare during landing. Factors were the pilot's lack of familiarity with the airplane and the crosswind condition.NTSB FTW98LA207Accident · No injuriesLimited investigationFinal reportSchrack Starduster TOO · Hilltop Lakes, TXThe pilot's failure to obtain/maintain the proper descent rate which resulted in a hard landing.NTSB FTW98LA226Accident · No injuriesLimited investigationFinal reportCessna 210A · Weatherford, TXThe restricted movement of the elevator control system by a bolt.NTSB MIA98LA145Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fruitland Park, FLthe pilot's failure to attain the proper rate of descent at touchdown.NTSB FTW98LA240Accident · No injuriesLimited investigationFinal reportCessna 172P · La Porte, TXThe pilot's premature landing flare and improper recovery procedures from a bounced landing. A factor was the gusty winds.NTSB CHI98LA133Accident · No injuriesLimited investigationFinal reportMaule MXT-7-108A · Orland, INthe pilot's misjudged landing flare and improper recovery from a bounced landing.NTSB MIA98LA132Accident · No injuriesLimited investigationFinal reportCessna 150M · Gainesboro, TNThe student pilot's improper flare during landing.NTSB IAD98LA045Accident · No injuriesLimited investigationFinal reportCessna 172N · Stevensville, MDthe pilot's improper flare, improper recover from a bounced landing, and failure to maintain directional control.NTSB ANC98LA037Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28F · Haines, AKThe pilot flaring too low during an improper practice autorotation.NTSB SEA98LA063Accident · 1 fatalLimited investigationFinal reportHughes 269A · Emmett, IDThe instructor pilot's failure to maintain the proper rate of descent on landing. Factors were a sudden wind shift, the instructor pilot's lack of recent experience, and terrain drop-off.NTSB SEA98LA061Accident · No injuriesLimited investigationFinal reportCessna 180 · Redmond, ORThe passenger-pilot's excessive rate of descent during touchdown. Factors include the pilot-in-command's inadequate recovery from a hard/bounced landing, the passenger-pilot's failure to execute a go-around after taking control of the aircraft, and gusty…NTSB MIA98LA127Accident · No injuriesLimited investigationFinal reportSchweizer 269-C · Ormond Beach, FLThe CFI's inadequate supervision and poor communication which led the rated student pilot to roll the throttle off, and the CFI's subsequent failure to apply forward cyclic to increase airspeed which resulted in the subsequent hard landing and roll over.NTSB LAX98LA201Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Barbara, CAThe pilot's misjudging the landing flare and subsequent hard landing.NTSB CHI98LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INthe student pilot's failure to adequately compensate for the gusty wind conditions during landing. A factor was the gusty wind conditions.NTSB FTW98LA166Accident · No injuriesLimited investigationFinal reportCessna 172F · Fort Collins, COthe pilot's improper in flight planning/decision in electing to land with a known 30 knot tailwind. Factors were high winds and a tailwind.NTSB NYC98LA086Accident · No injuriesLimited investigationFinal reportGlobe Swift · Milton, DEimproper flare by the pilot, which resulted in a hard landing.NTSB NYC98LA085Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Elk Garden, VAthe pilot's improper weather evaluation. The gusty wind condition was a related factor.NTSB SEA98LA049Accident · No injuriesLimited investigationFinal reportCessna 177A · Laurel, MTThe pilot's excessive descent rate on final, and improper recovery from a bounced landing.NTSB LAX98LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA34-200 · Van Nuys, CAThe pilot's misjudged landing flare which led to an uncontrolled porpoise and eventual collapse of the landing gear.NTSB FTW98LA147Accident · No injuriesLimited investigationFinal reportCessna 150L · Conway, ARThe pilot's improper landing flare which resulted in a hard landing and her improper recovery procedures for a bounced landing.NTSB MIA98LA095Accident · No injuriesLimited investigationFinal reportCessna 172P · Destin, FLthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB IAD98LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrenton, VAThe student pilot's improper flare which resulted in a hard landing.NTSB ATL98LA048Accident · No injuriesLimited investigationFinal reportCessna 210 · Hazel Green, ALthe pilot's improper flare, which resulted in a hard landing and the nose gear collapsing.NTSB ATL98LA044Accident · No injuriesLimited investigationFinal reportCharles Holmes Kitfox XL · Homestead, FLThe student pilot's improper touchdown flare during landing.NTSB LAX98LA093Accident · No injuriesLimited investigationFinal reportBoeing MD600N · Mesa, AZthe attempt by flight test engineers to verify a height/velocity data point that was subsequently shown to be outside the aircraft's performance capabilities.NTSB FTW98LA106Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Taos, NMthe pilot's improper flare and improper recovery from a bounced landing.