NTSB investigations, 2011, NY

15 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2011, NY per year, 2008–2026: 221 cases
20088
200912
201019
201115
201214
201314
201418
201521
201614
201714
201817
201911
20205
20218
20224
20238
202414
20254
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 year(c.\"eventDate\") = 2011
    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\" = '470' 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 ERA12FA093Accident · 1 fatalField investigationFinal reportWing John R Wittman Tailwind · Fulton, NYThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of engine power due to the formation of carburetor ice.Dec 1, 2011 · N865JT · Substantial damageNTSB ERA12MA005Accident · 2 fatalMajor investigationFinal reportBell 206B · New York, NYThe pilot's failure to anticipate and correct for conditions (high gross weight, low indicated airspeed, and a right downwind turn) conducive to loss of tail rotor effectiveness (LTE), which resulted in LTE and an uncontrolled spin. Contributing to the…Oct 4, 2011 · N63Q · Substantial damageNTSB ERA11CA506Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Montgomery, NYA total loss of engine power due to fuel starvation as a result of the pilots’ inadequate fuel management.Sep 27, 2011 · N6800W · Substantial damageNTSB ERA11LA434Accident · Minor injuriesLimited investigationFinal reportNord Stampe SV4C · Rhinebeck, NYA total loss of engine power for undetermined reasons.Jul 31, 2011 · N51SV · Substantial damageNTSB ERA11CA425Accident · Serious injuriesData collectionFinal reportPiper PA-24-250 · Sidney, NYThe pilot's inadequate fuel planning and management, which resulted in fuel starvation and a total loss of engine power during final approach.Jul 27, 2011 · N7365P · Substantial damageNTSB ERA11LA403Accident · Serious injuriesLimited investigationFinal reportMurphy Elite · Batavia, NYThe pilot's failure to maintain control of the airplane during takeoff.Jul 16, 2011 · N113SM · Substantial damageNTSB ERA11FA369Accident · 2 fatalField investigationFinal reportCessna 172M · Poughkeepsie, NYThe pilot’s loss of airplane control due to impairment or incapacitation as a result of coronary artery disease in combination with atrial fibrillation. Contributing to the accident was the pilot's failure to report his paroxysmal atrial fibrillation to the…Jun 28, 2011 · N61579 · Substantial damageNTSB ERA11CA331Accident · Serious injuriesData collectionFinal reportCessna 172 · Ghent, NYThe pilot's delayed decision to abort the landing and execute a go-around.Jun 8, 2011 · N8895B · Substantial damageNTSB ERA11CA309Accident · Minor injuriesData collectionFinal reportBeech A23 · Greene, NYThe pilot's decision to continue a visual approach with low visibility and in heavy rain and his subsequent failure to maintain clearance from trees.May 21, 2011 · N3548R · Substantial damageNTSB ERA11LA306Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Wurtsboro, NYThe pilot’s performance of aerobatic maneuvers at low altitude and his failure to maintain airspeed, which resulted in an aerodynamic stall.May 20, 2011 · N877CT · Substantial damageNTSB ERA11FA291Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · New Hampton, NYThe PA24 pilot’s failure to maintain adequate clearance from the PA28, resulting in an in-flight collision. Contributing to the accident was the PA24 pilot's decision to overtake the PA28.May 9, 2011 · N5275L · 2 aircraft · Substantial damageNTSB ERA11CA271Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Millbrook, NYThe student pilot’s failure to maintain directional control during landing and the pilot’s inadequate remedial action, which resulted in a runway excursion.Apr 30, 2011 · N984D · Substantial damageNTSB ERA11CA217Accident · No injuriesData collectionFinal reportCessna 150F · Hannawana Falls, NYThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Mar 26, 2011 · N8830G · Substantial damageNTSB ERA11LA204Accident · No injuriesLimited investigationFinal reportRobinson R22 · Goshen, NYThe pilot’s failure to adhere to published preflight checklist limitations and procedures, resulting in excessive slack and subsequent failure of the power transmission belts and a total loss of rotor system drive.Mar 22, 2011 · N259TW · Substantial damageNTSB ERA11FA165Accident · 1 fatalField investigationFinal reportBritish BAC 167 Strikemaster · Kingston, NYThe pilot’s failure to maintain airplane control while maneuvering. Contributing to the accident was the pilot's lack of experience in the accident airplane.Feb 26, 2011 · N167SM · Substantial damage