NTSB investigations, 2016

66 cases where the defining event 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 year(c.\"eventDate\") = 2016
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '092')
  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.

NTSB CEN16LA183Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US Z-150 · Edmond, OKThe pilot’s failure to control the balloon’s descent rate during the landing approach, which resulted in a hard landing.May 13, 2016 · N6952D · Substantial damageNTSB GAA16CA236Accident · No injuriesData collectionFinal reportPiper PA 28R · Lee's Summit, MOThe pilot's improper pitch control after the landing flare, resulting in an aerodynamic stall, hard landing, and consequent substantial left wing damage.May 12, 2016 · N228NC · Substantial damageNTSB GAA16CA226Accident · No injuriesData collectionFinal reportCessna TR182 · Bloomington, INThe pilot's failure to maintain the airplane's descent rate resulting in a hard landing, and subsequent substantial damage to the firewall.May 7, 2016 · N9281R · Substantial damageNTSB GAA16CA222Accident · No injuriesData collectionFinal reportPiper PA32RT · Gainesville, GAThe pilot's failure to maintain an appropriate descent rate during the landing flare in gusty crosswind conditions, which resulted in a hard landing, left main landing gear collapse, and runway excursion.May 5, 2016 · N4450S · Substantial damageNTSB GAA16CA208Accident · No injuriesData collectionFinal reportCessna 172 · Durant, OKThe pilot candidate's incorrect action performance by pulling the throttle off early and the subsequent failure to maintain the descent rate, resulting in a hard landing.Apr 27, 2016 · N35387 · Substantial damageNTSB ERA16LA181Accident · No injuriesLimited investigationFinal reportMaule M 7-235B · Littleton, NCThe pilot's improper landing flare, which resulted in a hard landing and subsequent damage to the left float.Apr 24, 2016 · N367FS · Substantial damageNTSB DCA16WA244Incident · No injuriesForeign investigationBoeing 737 · Apia, AntarcticaThe government of American Samoa has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 23, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of American Samoa's investigation under the…Apr 23, 2016 · VH-YIW · Minor damageNTSB GAA16CA202Accident · No injuriesData collectionFinal reportCessna 172 · Camarillo, CAThe student pilot's incorrect pitch control input, resulting in a porpoise during landing and substantial damage to the airplane's firewall.Apr 20, 2016 · N6616D · Substantial damageNTSB CEN16WA152Accident · Minor injuriesForeign investigationPiper PA32R · Hampshire, United KingdomOn April 12, 2016, at 1300 coordinated universal time, a Piper PA-32R-301T airplane, G-MAIE, experienced a hard landing at the Daedalus Airfield (EGHF), Hampshire, United Kingdom. The pilot was not seriously injured, and the airplane sustained damage to the…Apr 12, 2016 · G-MAIE · Substantial damageNTSB GAA16CA189Accident · No injuriesData collectionFinal reportTL Ultralight Sro TL-3000 Sirius · South St. Paul, MNThe pilot's failure to maintain a proper landing flare in gusty wind conditions, which resulted in a hard landing and substantial damage to the firewall.Apr 8, 2016 · N726T · Substantial damageNTSB GAA16CA158Accident · No injuriesData collectionFinal reportCessna 172 · Frederick, MDThe student pilot's improper pitch control during the landing flare, which resulted in a hard bounced landing.Mar 23, 2016 · N65329 · Substantial damageNTSB GAA16LA172Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY8B · Rock Hill, SCThe pilot’s inadequate compensation for wind, which resulted in the balloon landing hard and a passenger sustaining a serious injury.Mar 12, 2016 · N3180S · No damageNTSB WPR16LA073Accident · Minor injuriesLimited investigationFinal reportCessna T206H · Billings, MTThe pilot’s failure to attain a proper flare during landing in gusting wind conditions and low-level wind shear, which resulted in a hard landing and a subsequent loss of directional control.Feb 8, 2016 · N562H · Substantial damageNTSB GAA16CA530Accident · No injuriesData collectionFinal reportRobinson R22 · Taylor, TXThe flight instructor's improper collective input during a simulated engine failure autorotation with a power recovery, which resulted in a hard, bounced landing and the main rotor blade striking the tailboom.Feb 5, 2016 · N1777V · Substantial damageNTSB GAA16CA104Accident · No injuriesData collectionFinal reportCessna 172 · Dothan, ALThe pilot-rated student's hard landing, which resulted in fuselage damage.Jan 12, 2016 · N417ER · Substantial damageNTSB CEN16LA098Accident · No injuriesLimited investigationFinal reportCessna 441 · Fargo, NDThe pilot’s failure to cycle the surface deice boots during the instrument approach in icing conditions, which led to ice accumulation on the leading edges of the wings and empennage, and resulted in an aerodynamic stall and subsequent hard landing.Jan 8, 2016 · N779CC · Substantial damage