NTSB investigations, 2011, FL

10 cases where the defining event was Hard landing.

Cases per year

20082026
NTSB investigations, 2011, FL per year, 2008–2026: 129 cases
200813
20093
201014
201110
20128
20135
201411
20156
20161
20176
20184
201910
20204
20216
20227
20235
20245
20253
20268

Latest cases

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\") = 2011
    AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    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 ERA12CA076Accident · No injuriesData collectionFinal reportCessna A150M · Ormond Beach, FLThe pilot's inadequate recovery from a bounced landing, which resulted in a loss of airplane control.Nov 17, 2011 · N9890J · Substantial damageNTSB ERA12CA046Accident · No injuriesData collectionFinal reportCessna 182L · Gainesville, FLThe pilot did not maintain a proper descent rate during the approach, which resulted in a hard landing.Oct 12, 2011 · N42547 · Substantial damageNTSB ERA11LA519Accident · No injuriesLimited investigationFinal reportHeinlein George GH125 · Okeechobee, FLThe non-certificated pilot's improper flare on an earlier flight, which resulted in a hard landing, fracture of the right main landing gear bolt, and subsequent collapse of the right main landing gear.Sep 19, 2011 · N79GH · Substantial damageNTSB ERA11CA490Accident · No injuriesData collectionFinal reportCessna 172R · Naples, FLThe student pilot's improper flare, which resulted in a hard landing and subsequent loss of directional control.Sep 14, 2011 · N10632 · Substantial damageNTSB ERA11CA284Accident · No injuriesData collectionFinal reportCessna 172P · Stuart, FLThe student pilot's improper landing flare, which resulted in a hard landing.May 3, 2011 · N88EP · Substantial damageNTSB ERA11CA283Accident · No injuriesData collectionFinal reportCessna 172P · Fort Pierce, FLThe student pilot's improper flare, which resulted in a hard landing.May 3, 2011 · N5460K · Substantial damageNTSB ERA11CA255Accident · No injuriesData collectionFinal reportBeech F33A · Ocala, FLThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the pilot's distracted attention due to the electrical system failure.Apr 21, 2011 · N334J · Substantial damageNTSB ERA11CA254Accident · No injuriesData collectionFinal reportFlight Design Ctls · Jacksonville, FLThe student pilot's improper flare, which resulted in a hard landing.Apr 14, 2011 · N178CT · Substantial damageNTSB ERA11CA166Accident · Minor injuriesData collectionFinal reportEnstrom F-28C · Fort Pierce, FLThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Feb 26, 2011 · N5689B · Substantial damageNTSB ERA11CA147Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe pilot's inadequate flare that resulted in a hard landing.Feb 15, 2011 · N378FA · Substantial damage