NTSB investigations, 2012

78 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\") = 2012
    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 WPR12CA266Accident · No injuriesData collectionFinal reportCessna 182H · Meadow Creek, MTThe pilot's misjudged approach and improper landing flare, which resulted in a hard landing.Jun 16, 2012 · N2424X · Substantial damageNTSB ERA12CA404Accident · No injuriesData collectionFinal reportCessna 172K · Tupelo, MSThe pilot's improper recovery from a bounced landing.Jun 15, 2012 · N78794 · Substantial damageNTSB ERA12CA415Accident · No injuriesData collectionFinal reportFairchild 24R-40 · Smyrna, TNThe pilot's inadequate landing flare, which resulted in a hard landing.Jun 8, 2012 · N232E · Substantial damageNTSB CEN12CA392Accident · No injuriesData collectionFinal reportCessna P210N · Detroit, MIThe pilot's improper landing flare and inadequate recovery from a bounced landing.Jun 8, 2012 · N7588K · Substantial damageNTSB CEN12CA363Accident · No injuriesData collectionFinal reportHoac-Austria HK 36R Super Dimona · New Douglas, ILThe pilot’s improper landing flare and inadequate recovery from a bounced landing.Jun 6, 2012 · N400HK · Substantial damageNTSB ERA12CA375Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe flight instructor’s inadequate supervision and delayed remedial action during a simulated engine-out procedure, which resulted in a hard landing.May 31, 2012 · N1803R · Substantial damageNTSB WPR12CA206Accident · No injuriesData collectionFinal reportHunter A-20 Vista Cruiser · Molalla, ORThe pilot's failure to maintain clearance from a rock during an off-airport landing.May 14, 2012 · N9027M · Substantial damageNTSB WPR12CA194Accident · No injuriesData collectionFinal reportCessna 207A · Grangeville, IDThe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a loss of airplane control.May 8, 2012 · N207YH · Substantial damageNTSB WPR12CA204Accident · No injuriesData collectionFinal reportCessna 172P · Spokane, WAThe student pilot's improper landing flare and inadequate recovery from a bounced landing.May 7, 2012 · N54036 · Substantial damageNTSB ERA12CA322Accident · No injuriesData collectionFinal reportCessna 182N · Newport, VTThe pilot’s failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall and hard landing.May 6, 2012 · N9217G · Substantial damageNTSB CEN12CA281Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Houston, TXThe pilot’s improper recovery from a bounced landing.May 5, 2012 · N919LA · Substantial damageNTSB CEN12CA277Accident · No injuriesData collectionFinal reportCessna 152 · San Antonio, TXThe student pilot's misjudgment of the landing flare, which resulted in a hard/bounced landing and subsequent impact with the runway.May 1, 2012 · N94500 · Substantial damageNTSB WPR12LA174Accident · No injuriesLimited investigationFinal reportWillerton Vans RV6A · Sequim, WAThe pilot's inadequate landing flare, which resulted in a hard landing.Apr 10, 2012 · N6000Z · Substantial damageNTSB CEN12CA233Accident · No injuriesData collectionFinal reportCessna 210H · Marienthal, KSThe pilot's inadequate compensation for the wind during landing.Apr 7, 2012 · N5981F · Substantial damageNTSB ERA12LA259Accident · No injuriesLimited investigationFinal reportCessna 172P · Brooksville, FLThe pilot's improper landing flare, which resulted in a hard landing.Mar 24, 2012 · N99087 · Substantial damageNTSB ERA12CA242Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · New Smyrna, FLThe pilot's improper flare, which resulted in a hard landing. Contributing to the accident was the flight instructor's inadequate remedial action.Mar 18, 2012 · N15764 · Substantial damageNTSB ERA12CA228Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Charleston, SCThe pilot's improper landing flare, which resulted in a hard landing.Mar 15, 2012 · N832KF · Substantial damageNTSB CEN12CA194Accident · No injuriesData collectionFinal reportCessna 177B · New Orleans, LAThe pilot’s improper flare, which resulted in a hard landing.Mar 15, 2012 · N30770 · Substantial damageNTSB CEN12LA187Accident · 1 fatalLimited investigationFinal reportBrice Ron Glastar Sportsman 2+ · Kimberling, MOThe pilot’s inadequate flare, which resulted in the airplane impacting into the water.Mar 13, 2012 · N627RM · Substantial damageNTSB ERA12CA209Accident · No injuriesData collectionFinal reportCessna 172S · Lafayette, TNThe pilot’s inadequate compensation for gusting crosswind conditions during landing, which resulted in a hard landing.Mar 4, 2012 · N53460 · Substantial damageNTSB WPR12TA120Accident · No injuriesFinal reportEurocopter AS 350 B3 · Napa, CAThe flight instructor’s improper use of the collective control during a practice hovering autorotation, which resulted in a hard landing.Mar 1, 2012 · N341HP · Substantial damageNTSB ERA12CA199Accident · No injuriesData collectionFinal reportBell OH-58A · Eufaula, ALThe pilot's inadequate compensation for the gusting wind, which resulted in an excessive descent rate and hard landing.Mar 1, 2012 · N38FA · Substantial damageNTSB WPR12CA118Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Poway, CAThe pilot's inadequate compensation for wind conditions during landing, which resulted in a hard landing.Feb 25, 2012 · N118MB · Substantial damageNTSB WPR12CA134Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Dillingham, HIThe student pilot’s inadequate recovery from a bounced landing.Feb 20, 2012 · N103SH · Substantial damageNTSB ERA12CA178Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's improper flare and recovery from a bounced landing.Feb 10, 2012 · N67973 · Substantial damageNTSB WPR12CA103Accident · No injuriesData collectionFinal reportRockwell International S-2R · Yellow Pine, IDThe pilot did not reduce the airplane’s descent rate prior to the landing flare/touchdown, which resulted in a hard landing.Feb 5, 2012 · N4894X · Substantial damageNTSB WPR12LA090Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Dinsmore, CAThe flight instructor's delayed remedial action, inadequate recovery from a bounced landing, and failure to attain/maintain adequate airspeed during an attempted go-around.Feb 3, 2012 · N3879S · Substantial damageNTSB CEN12LA141Accident · No injuriesLimited investigationFinal reportBell 206B · Irving, TXA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.Jan 22, 2012 · N555NB · Substantial damage