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 MIA96LA121Accident · No injuriesLimited investigationFinal reportCessna 310D · Palmetto, GAFailure of the pilot-in-command to maintain the proper descent rate resulting in a hard landing and collapse of the right main landing gear.NTSB LAX96LA172Accident · No injuriesLimited investigationFinal reportBell 206B III · San Diego, CAthe student's failure to maintain adequate main rotor rpm and airspeed during a practice autorotation, and the instructor's inadequate supervision of the flight.NTSB CHI96LA131Accident · No injuriesLimited investigationFinal reportBeech A23A · Saginaw, MIthe student pilot's improper flare and improper recovery from a bounced landing.NTSB LAX96LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Sedona, AZthe pilot misjudged the flare.NTSB SEA96LA077Accident · No injuriesLimited investigationFinal reportCessna 172P · Friday Harbor, WAthe pilot's misjudgment of the aircraft's altitude above the runway and failure to flare for landing. Darkness (bright night) was a related factor.NTSB MIA96TA112Accident · No injuriesFinal reportCessna 210 · Lakeland, FLthe pilot's improper flare on landing, and his improper use of flight controls on landing rollout.NTSB IAD96LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Taplin, WVthe pilot's improper level off and recovery from a bounced landing.NTSB MIA96LA105Accident · No injuriesLimited investigationFinal reportCessna 172N · New Smyrna Bch, FLThe student pilot's improper flare and improper recovery from a bounced landing, which resulted in an inadvertent porpoise, and subsequent overload failure of the nose gear.NTSB ATL96LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Baxley, GAthe pilot's improper flare, which resulted in a hard landing, a collapsed nose gear, and a subsequent nose over.NTSB LAX96LA136Accident · No injuriesLimited investigationFinal reportCessna 182Q · Avalon, CAthe pilot's improper flare and improper recovery from a bounced landing. Factors relating to the accident were: a visual illusion due to rising terrain at the approach end of the runway, and the pilot's misjudgment of distance and speed during the approach to…NTSB LAX96LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Las Vegas, NVthe student pilot's improper flare and improper recover from a bounced landing, which resulted in a hard landing and collapse of the nose gear. A factor relating to the accident was: the flight instructor's inadequate instruction concerning recovery from…NTSB MIA96LA093Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Panama City Bch, FLimproper compensation for wind conditions by the second pilot, his inadequate remedial action after the airplane lifted off during a wind gust, and inadequate supervision by the first pilot (PIC). A factor relating to the accident was: the gusty wind…NTSB NYC96LA069Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · South Wales, NYthe pilot's improper flare and failure to maintain directional control during landing.NTSB FTW96LA133Accident · No injuriesLimited investigationFinal reportCessna T210N · Englewood, COthe pilot's inadequate compensation for wind conditions and failure to maintain control of the aircraft during the landing. The adverse wind condition was a related factor.NTSB CHI96LA097Accident · No injuriesLimited investigationFinal reportCessna 172P · West Chicago, ILthe student pilot's misjudging the flare. A factor was the gusts.NTSB MIA96FA082Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Morganton, NCthe pilot's delay in initiating a go-around (aborted landing), which resulted in his failure to obtain/maintain sufficient altitude or clearance from trees beyond the end of the runway. Factors relating to the accident were: the pilot's failure to ensure…NTSB LAX96LA190Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Tucson, AZthe interruption to the pilot's planned landing approach due to obstructions in the original touchdown spot, which led to the pilot misjudging the landing flare.NTSB CHI96LA089Accident · No injuriesLimited investigationFinal reportCessna 210 · Shelbyville, ILthe pilot's misjudged flare and improper recovery from a bounced landing. Factors relating to the accident were: the pilot's improper use of procedure by wearing unapproved correcting lenses, and his resultant decreased depth perception.NTSB FTW96LA114Accident · No injuriesLimited investigationFinal reportMooney M20M · Alpine, TXThe pilot's failure to maintain airspeed during a misjudged landing flare resulting in a hard landing.NTSB NYC96LA058Accident · Minor injuriesLimited investigationFinal reportBeech 1900D · Bradford, PAthe pilot misjudged the flare during landing. Factors in the accident were: an improper recovery from a bounced landing, and the first officers lack of experience in this type operation.NTSB FTW96LA111Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas MD-88 · Denver, COFailure of the pilot to maintain sufficient airspeed to properly flare the airplane during the landing.NTSB FTW96LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Norman, OKthe student pilot's improper level-off during landing.NTSB SEA96LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Ogden, UTThe pilot's improper flare and inadequate recovery from a bounced landing. His improper approach was a related factor.NTSB MIA96LA062Accident · No injuriesLimited investigationFinal reportCessna 310C · Irvington, ALThe pilot's failure to maintain adequate airspeed during the landing flare, which resulted in a hard landing.NTSB CHI96LA076Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chesterfield, MOthe pilot misjudged the flare and performed an improper recovery from a bounced landing. A factor was the inadequate ground instruction concerning recovery from a bounced landing.NTSB FTW96LA097Accident · No injuriesLimited investigationFinal reportCessna 152 · Spring, TXThe pilot's improper flare, improper recovery from a bounced landing, and failure to maintain directional control during the landing. The soft terrain was a related factor.NTSB MIA96LA061Accident · No injuriesLimited investigationFinal reportBell 206B · Pompano Beach, FLImproper flare by the rated student pilot, and inadequate supervision by the flight instructor.NTSB CHI96LA070Accident · No injuriesLimited investigationFinal reportCessna 310R · Minocqua, WIthe pilot's failure to maintain adequate airspeed during the landing. The weather and ice accumulation on the airplane were factors.NTSB CHI96LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Wheeling, ILthe pilot's misjudgment of the landing flare.NTSB LAX96LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Winslow, AZthe student pilot's use of an excessive airspeed during the landing approach, which resulted in a hard landing, a porpoise, and a collapse of the nose landing gear.NTSB NYC96LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Meriden, CTThe pilot's improper flare and improper recovery from a bounced landing. The unfavorable wind condition was a related factor.NTSB FTW96LA059Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX9-140 · Gallup, NMthe high winds and the pilot's failure to maintain aircraft control.NTSB FTW96LA057Accident · Serious injuriesLimited investigationFinal reportBeech D18S · Loveland, COThe second pilot's failure to compensate for wind conditions and his improper recovery from a bounced landing, and the pilot-in-command's inadequate supervision of the flight. Factors were the second pilot's lack of landing experience in the airplane…NTSB MIA96LA030Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, FLThe student pilot's improper level-off and elevator control input.NTSB FTW96LA067Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Houston, TXFailure by the pilot to maintain control of the balloon during landing. A factor was unfavorable wind.NTSB FTW96LA055Accident · Serious injuriesLimited investigationFinal reportAerostar RX8 · Rio Rancho, NMThe pilot's improper planning/decision. A factor relating to the accident was: the high wind condition.NTSB CHI96LA042Accident · No injuriesLimited investigationFinal reportCessna T337G · Pontiac, MIthe pilot's improper level-off and improper recovery from a bounced landing.NTSB CHI96LA043Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Stark, KSthe pilot's failure to follow emergency procedures. A factor was the weather condition.NTSB CHI96LA028Accident · No injuriesLimited investigationFinal reportCessna 421 · Romeo, MIthe failure of the pilot to maintain sufficient airspeed during landing, causing the inadvertent stall. A factor was the icing conditions.NTSB NYC96LA026Accident · No injuriesLimited investigationFinal reportFairchild Merlin Iiia · Butler, PAfailure of the pilot to perform a missed approach, when the airplane was not properly aligned with the landing runway; and his failure to properly flare the airplane, which resulted in a hard landing.NTSB LAX96LA033Accident · No injuriesLimited investigationFinal reportRussell KR-2 · Adelanto, CAthe pilot's misjudgement of the height above touchdown and his premature flare, which resulted in a hard landing.NTSB MIA96LA015Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Morganton, NCThe pilot-in-command's excessive rate of descent on short final.NTSB FTW96LA029Accident · No injuriesLimited investigationFinal reportCessna 150L · Norman, OKThe student pilot's improper recovery from a bounced landing and the flight instructor's inadequate supervision of the flight. Factors were the gusty wind conditions and the student pilot's failure to obtain and maintain proper compensation for the wind…NTSB LAX96LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Auburn, CAthe pilot's failure to maintain directional control following a hard landing. His physical impairment was a factor.NTSB BFO96LA019Accident · No injuriesLimited investigationFinal reportCessna T210L · College Park, MDthe pilot's improper recovery from a bounced landing and his failure to initiate a go-around. Related factors were the crosswind and the pilot's concern about being late for meetings he had scheduled.NTSB FTW96LA013Accident · Serious injuriesLimited investigationFinal reportAerostar RX 8 · Albuquerque, NMThe pilot's improper in-flight planning/decision. The variable wind condition was a related factor.NTSB BFO96LA005Accident · 1 fatalLimited investigationFinal reportTravel Air R · Youngstown, OHthe pilot's improper flare during the landing, which resulted in a hard landing, fuselage damage, loss of aircraft control, and a nose over. A factor relating to the accident was: the pilot's lack of experience in the make and model of airplane.NTSB LAX96LA006Accident · No injuriesLimited investigationFinal reportCessna 172N · Tucson, AZthe pilot's inadequate compensation for the existing tailwind conditions, improper flare, and failure to maintain directional control.NTSB SEA95LA228Accident · No injuriesLimited investigationFinal reportCessna 182R · Spokane, WAfailure of the pilot to properly flare the airplane during the landing. Factors relating to the accident were: the pilot's improper approach to land, exceeding the proper touchdown point for landing, failure to go-around, while there was sufficient runway…NTSB FTW95LA405Accident · Minor injuriesLimited investigationFinal reportLet Blanik L-13 · Como, COThe pilot allowing the glider to develop an excessive descent rate. A factor was the premature and automatic disengagement of the winch-tow system.