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 CHI90LA262Accident · Serious injuriesLimited investigationFinal reportNational Balloon AX-7 · Altoona, IAThe passenger's inadvertent contact with a propane tank during a bounced landing which resulted in serious injury to the passenger.NTSB MIA90LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Plymouth, FLThe failure of the pilot to arrest the high rate of descent prior to touchdown.NTSB LAX90FA316Accident · 1 fatalField investigationFinal reportEnstrom F28C · Santa Paula, CAThe excessive approach speed to the pinnacle landing point and the pilot's delayed landing flare. Factors in the accident were: lack of total experience in this type of operation.NTSB NYC90LA211Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Peters Twp, PAThe pilot in commands failure to maintain airspeed on final approach resulting in an inadvertent stall and hard landing.NTSB ATL90LA165Accident · No injuriesLimited investigationFinal reportGrumman AA1 · Gainesville, GAThe student pilot's failure to properly flare.NTSB LAX90LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Ana, CAThe improper technique used by the student pilot to recover from a bounced landing attempt.NTSB CHI90LA245Accident · No injuriesLimited investigationFinal reportCessna 172 · Farmington, MORemedial action was not attained by the CFI. Contributing to the accident was inadequate airspeed and porpoise encountered by the dual student pilot.NTSB ANC90LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Goose Bay, AKThe pilot-in-command's improper flare on touchdown.NTSB SEA90FA165Accident · 4 fatalField investigationFinal reportPiper PA-30-160 · Kalispell, MTFailure of the pilot to flare the aircraft for landing and to maintain its control during the attempted go-around (aborted landing). Factors related to the accident were: darkness, a number of runway edge lights that were either inoperative or hidden by…NTSB CHI90LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Roseville, ILMisjudged flare for landing, an improper recovery from a bounced landing, and his failure to maintain directional control.NTSB ATL90LA164Accident · No injuriesLimited investigationFinal reportCessna 182N · Knightdale, NCThe failure of the pilot to execute timely go around procedures. The pilot's lack of experience in this make and model of airplane were factors in the accident.NTSB CHI90LA229Accident · No injuriesLimited investigationFinal reportCessna U206A · Fishers, INPilot-in-command's failure to accomplish a recovery from a bounced landing which resulted in a porpoise and collapse of the nose gear.NTSB CHI90LA215Accident · No injuriesLimited investigationFinal reportCessna 152 · Cahokia, ILImproper flare and improper recovery from a bounced landing.NTSB CHI90DEE09Accident · No injuriesFinal reportBennert Sidewinder · Lansing, ILThe pilot's failure to compensate for winds conditions on landing approach.NTSB NYC90DNE04Accident · Minor injuriesFinal reportRotorway RW 152 · Southwick, MAA hard landing due to improper use of the rotorcraft flight controls, and the decision to put fuel in only one side.NTSB NYC90LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mt Pocono, PAA hard landing after the pilot perceived an engine problem. Contributing to the accident was the failure of the pilot to control his airspeed and flare during the emergency landing.NTSB MIA90LA164Accident · No injuriesLimited investigationFinal reportCessna 150M · Venice, FLFailure of the student pilot to flare for landing and his loss of control after a bounced landing.NTSB BFO90LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Tangier Island, VAThe pilot's improper recovery from a bounced landing and premature raising of the flaps.NTSB CHI90LA205Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Hudson, IAImproper touchdown performed by the pilot in command.NTSB CHI90LA200Accident · No injuriesLimited investigationFinal reportBeech A36TC · Oshkosh, WIThe pilot's failure to recognize the deteriorating airspeed and imminent stall during the landing flare, which resulted in a hard landing.NTSB NYC90LA173Accident · No injuriesLimited investigationFinal reportCessna 182G · Cincinnati, OHThe pilot did not properly compensate for the gusty wind conditions, resulting in the airplane landing hard and porpoising.NTSB LAX90LA261Accident · No injuriesLimited investigationFinal reportCessna 180B · Red Bluff, CAAn improper landing flare and improper recovery from the bounced landing.NTSB DEN90LA165Accident · No injuriesLimited investigationFinal reportBeech B-24-R · Cheyenne Wells, COThe pilot's improper recovery from a bounced landing. A factor was the pilot's failure to compensate for the existing cross wind.NTSB FTW90LA145Accident · No injuriesLimited investigationFinal reportCessna 177RG · Arlington, TXThe pilot misjudged airplane attitude during the landing flare.NTSB NYC90LA149Accident · No injuriesLimited investigationFinal reportBeech C23 · Allaire, NJThe pilot's improper flare for the landing.NTSB FTW90LA122Accident · Serious injuriesLimited investigationFinal reportPiccard P-80 · Peaster, TXAn excessive rate of descent during the approach.NTSB LAX90LA224Accident · No injuriesLimited investigationFinal reportCessna 140 · Chico, CAThe pilot improperly leveled off, failed to correct the ensuing porpoise, took improper remedial action, and improperly used the rudder and normal brakes.NTSB LAX90LA343Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B · Moorpark, CAThe pilot's failure to arrest descent for landing.NTSB LAX90LA221Accident · Serious injuriesLimited investigationFinal reportGrumman G21A · Long Beach, CAThe pilot's failure to retract the landing gear resulting in an inadvertent wheels-down landing in water. In addition, a loss of elevator control was encountered due to a stress corrosion failure of an elevator control cable turnbuckle as a result of…NTSB NYC90FA130Accident · 1 fatalField investigationFinal reportConsolidated Aeronautics LA-4-200 · Danbury, CTThe inadvertent stall. A factor was the pilot's misjudgement of the landing flare.NTSB MIA90LA140Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Boca Raton, FLThe pilots failure to flare the airplane for landing resulting in the hard landing.NTSB NYC90LA126Accident · Serious injuriesLimited investigationFinal reportBarnes Firefly 8B · Cazenovia, NYThe passengers failure to comply with the pilots instructions after a hard landing was made.NTSB CHI90LA151Accident · No injuriesLimited investigationFinal reportCessna T210N · Wheeling, ILPilot-in-command's failure to obtain a proper flare attitude in the aircraft prior to touchdown.NTSB CHI90LA152Accident · No injuriesLimited investigationFinal reportBeech T-34A · Champaign, ILThe pilot's inadequate compensation for wind conditions, and his failure to adequately flare the aircraft for landing. The adverse wind was a related factor.NTSB FTW90LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe student pilot misjudged the flare to land.NTSB ANC90LA083Accident · No injuriesLimited investigationFinal reportHelio H-250 · Six Mile Lake, AKThe pilot's improper flare, which resulted in a hard landing. The pilot's lack of experience in the make and model of aircraft was a related factor.NTSB LAX90LA194Accident · No injuriesLimited investigationFinal reportCessna 152 · Atwater, CAThe pilot flared the airplane too high and improperly recovered from the bounced landing. Contributing to this accident was the pilot's improper use of the normal brakes and the soft terrain.NTSB MIA90LA136Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Bunnell, FLThe dual students failure to flare properly during a simulated forced landing. Contributing to the accident was the failure of the flight instructor to properly monitor the student during the simulated forced landing.NTSB CHI90LA178Accident · No injuriesLimited investigationFinal reportCessna 182 · Rich Hill, MOInadequate landing flare by the pilot.NTSB NYC90LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Granville, NYThe improper recovery from a bounced landing which resulted in loss of control and collision with a ditch.NTSB CHI90LA124Accident · No injuriesLimited investigationFinal reportBeech A36 · Anderson, INThe pilot failed to adequately compensate for the wind conditions. The gusty crosswind was a factor.NTSB LAX90LA177Accident · No injuriesLimited investigationFinal reportCessna 172N · Cottonwood, AZPremature raising of the flaps during the go-around maneuver.NTSB CHI90LA122Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainfield, ILThe student's improper flare, improper recovery from a bounced landing, and failure to maintain directional control. The crosswind was a related factor.NTSB ATL90LA103Accident · No injuriesLimited investigationFinal reportCessna 182 · Griffin, GAImproper flare by the pilot.NTSB ATL90LA101Accident · No injuriesLimited investigationFinal reportCessna 177B · Spartanburg, SCThe pilot's improper flare and improper recovery from a bounced landing.NTSB NYC90LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · New Castle, PAInadequate supervision of the student pilot by the flight instructor which resulted in a hard landing. Factors related to the accident was the improper use of the flight controls by a student pilot.NTSB FTW90DRD06Accident · Serious injuriesFinal reportStolt Acroduster II · Alexandria, LAThe pilot misjudged the landing flare.NTSB DEN90LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Ogallala, NEThe misjudged landing flare. A factor was the pilot's lack of experience.NTSB LAX90LA139Accident · No injuriesLimited investigationFinal reportCessna 182L · Concord, CAThe pilot in command to properly judge the timing of the landing flare.NTSB ANC90FA047Accident · No injuriesField investigationFinal reportde Havilland DHC-6 · Chevak, AKImproper flare by the pilot (PIC) during the landing/flare. The weather condition with fog was a related factor.