NTSB investigations, 2015, NY

6 cases where the sequence of events included Hard landing.

Cases per year

20082026
NTSB investigations, 2015, NY per year, 2008–2026: 47 cases
20082
20093
20106
20124
20134
20141
20156
20161
20171
20185
20192
20201
20212
20221
20234
20242
20262

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\") = 2015
    AND c.\"eventStateOrRegion\" = 'NY' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 ERA16LA052Accident · No injuriesLimited investigationFinal reportBeech 95 B55 · Albany, NYThe pilot’s failure to maintain a proper flare while landing in gusting crosswind conditions, which resulted in a hard landing, overstress fracture of the nose landing gear trunnion, and a subsequent nose landing gear collapse.Nov 22, 2015 · N600VP · Substantial damageNTSB ERA15CA267Accident · No injuriesData collectionFinal reportBrandt Leroy E Challenger II · Batavia, NYThe pilot's improper flare, which resulted in a hard landing and subsequent loss of directional control.Jul 11, 2015 · N434LB · Substantial damageNTSB GAA15CA176Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar SL · Montgomery, NYThe pilot's improper pitch control which resulted in a hard landing. A factor contributing to the accident was the pilot's improper recovery from a bounced landing.Jul 5, 2015 · N163PH · Substantial damageNTSB ERA15CA226Accident · Serious injuriesData collectionFinal reportAerostar International S-60A · LaGrangeville, NYThe pilot's decision to conduct a landing to a field in high wind conditions, which resulted in a hard landing and subsequent injury to a passenger.May 23, 2015 · N6517X · No damageNTSB GAA15CA044Accident · No injuriesData collectionFinal reportCessna 150M · Slate Hill, NYThe pilot's failure to maintain an adequate descent rate, resulting in a hard landing.Apr 18, 2015 · N9299U · Substantial damageNTSB ERA15CA126Accident · No injuriesData collectionFinal reportCessna 152 · Shirley, NYThe student pilot's initiation of the flare while too high above the runway, resulting in an aerodynamic stall, hard landing, and loss of directional control.Feb 7, 2015 · N5416B · Substantial damage