Fatal NTSB investigations, NY

6 cases where the sequence of events included Abrupt maneuver.

Cases per year

20172026
Fatal NTSB investigations, NY per year, 2017–2026: 6 cases
20171
20212
20221
20231
20261

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 c.\"eventStateOrRegion\" = 'NY' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '270' 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 ERA26FA269Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 182 · Piseco, NYOn July 12, 2026, about 1909 eastern daylight time, a Cessna 182J, N43TB, was destroyed when it was involved in an accident near Piseco, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…Jul 12, 2026 · N43TB · DestroyedNTSB ERA24FA001Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Lake Placid, NYA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s inadequate preflight weight and balance planning and his aggressive low altitude maneuvering, which resulted in an aerodynamic stall and loss of control.Oct 1, 2023 · N545PZ · Substantial damageNTSB ERA22FA207Accident · 2 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 429 · Elba, NYThe pilots’ inappropriate flight control inputs while in vortex ring state, which resulted in main rotor blade contact with the tail boom and a subsequent in-flight breakup. Also causal was the flight instructor’s inadequate monitoring of the flight.Apr 26, 2022 · N507TJ · Substantial damageNTSB ERA22FA010Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Cornwall, NYThe non-instrument-rated pilot’s continued flight into deteriorating weather conditions, which resulted in a loss of control due to spatial disorientation.Oct 10, 2021 · N637HP · DestroyedNTSB ERA21FA317Accident · 2 fatalClass 3 · FieldFinal reportRotorway Exec 162F · Argyle, NYThe pilot’s abrupt control inputs, which resulted in a low G condition, main rotor mast bumping, and the subsequent severing of the tail boom by a main rotor blade.Aug 7, 2021 · N162KJ · DestroyedNTSB ERA17FA115Accident · 2 fatalField investigationFinal reportRyan Navion · Westhampton Beach, NYThe flight instructor's exceedance of the critical angle of attack during a go-around, which resulted in an aerodynamic stall/spin. Contributing to the accident was the flight instructor's failure to familiarize himself with the flight characteristics of the…Feb 26, 2017 · N4529K · Destroyed