NTSB investigations, NY
27 cases where the sequence of events included Collision during takeoff/land.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 4 |
| 2010 | 1 |
| 2011 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2022 | 3 |
| 2024 | 3 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '490' 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.
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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '490' 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA24LA382Accident · No injuriesClass 4 · LimitedFinal reportAerostar International RX-7 · Amsterdam, NYThe pilot’s failure to maintain adequate clearance from powerlines during final approach for landing.NTSB ERA24LA350Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Shirley, NYThe pilot’s excessive speed during the final approach, which resulted in a collision with a fence during the subsequent aborted landing.NTSB ERA24LA116Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Farmingdale, NYThe student pilot’s lack of fuel management during the flight and the flight instructor’s inadequate monitoring of his student’s fuel management, resulting in fuel starvation and a forced landing to a highway.NTSB ERA22LA373Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Gardiner, NYThe pilot’s failure to go-around in a timely manner which resulted in a collision with a fence.NTSB ERA22LA370Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Shirley, NYThe flight instructor’s failure to ensure clearance from an electrical junction box during takeoff, which resulted in a collision.NTSB ERA22LA135Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · White Plains, NYThe pilot’s failure to maintain stabilized lateral control during landing in gusty conditions which resulted in a dynamic rollover when the skids contacted the platform unevenly.NTSB ERA20CA214Accident · No injuriesClass 4 · Data collectionFinal reportWaco YMF F5C · Ghent, NYA loss of directional control on takeoff, which resulted in a runway excursion and collision with trees.NTSB ERA20CA110Accident · Minor injuriesData collectionFinal reportPiper PA28 · Cortland, NYThe student pilot's failure to maintain the runway heading during takeoff, which resulted in impact with a snowbank and a subsequent nose-over.NTSB GAA20CA008Accident · No injuriesData collectionFinal reportPiper PA18 · Big Flats, NYThe pilot's improper flight planning and his subsequent failure to maintain clearance from wires during takeoff.NTSB GAA17CA576Accident · Minor injuriesData collectionFinal reportHunter George RV 6 · Montgomery, NYThe pilot’s loss of directional control during the takeoff roll, which resulted in impact with visual approach slope indicator lights.NTSB ERA16FA257Accident · 3 fatalField investigationFinal reportPiper PA 28R-201 · Esperance, NYThe pilot's inadequate preflight weight and balance and performance planning, which resulted in the airplane being over gross weight. Also causal were the pilot's decision not to use the entire runway for takeoff, his premature liftoff, and his failure to…NTSB GAA16CA163Accident · No injuriesData collectionFinal reportEnstrom F280 · Sodus, NYThe pilot's improper collective application at touchdown during a practice run-on landing, which resulted in the main rotor system impacting the tailboom and the forward portion of the fuselage impacting terrain during remedial action by the flight…NTSB ERA15LA286Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Poughkeepsie, NYA leaking fuel discharge fitting, which resulted in a partial loss of engine power and an off-airport, gear-up landing.NTSB ERA14CA379Accident · No injuriesData collectionFinal reportAviat Pitts S2B · Lakeville, NYThe pilot's decision to favor the right side of the relatively narrow turf runway while landing, resulting in inadvertent contact with tall grass and a berm.NTSB ERA11CA404Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Adams, NYThe pilot's loss of directional control during landing.NTSB ERA11CA323Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Wurstboro, NYThe flying pilot's failure to maintain aircraft control and the flight instructor's inadequate supervision while landing with a gusting wind. Contributing to the accident was the lack of communication between the flight instructor and pilot under evaluation…NTSB ERA10LA389Accident · 1 fatalLimited investigationFinal reportCessna A185F · Newfane, NYThe pilot's failure to maintain aircraft control due to his diverted attention, which resulted in a collision with trees during the initial climb after takeoff. Contributing to the accident was the passenger's attempt to secure the jump door after it opened…NTSB ERA10LA014Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Mount Morris, NYThe pilot’s improper decision to take off from unsuitable terrain with a quartering tailwind.NTSB ERA09FA345Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Scotia, NYThe flight instructor's failure to ensure that the airplane was properly configured for a short field takeoff, and his decision to not abort the takeoff.NTSB ERA09CA332Accident · No injuriesData collectionFinal reportTeratorn Tierra · Cutchogue, NYThe pilot's decision to attempt takeoff from unsuitable terrain.NTSB ERA09CA270Accident · No injuriesData collectionFinal reportCessna 150G · Kingston, NYThe pilot's failure to maintain clearance from trees during approach.NTSB ERA09LA020Accident · No injuriesLimited investigationFinal reportSikorsky S-76C · New York, NYThe failure of the flightcrew to stabilize the helicopter over its confined landing area during a hovering left-pedal turn, resulting in tail rotor blade contact with a perimeter fence component and a subsequent loss of directional control. Contributing to…NTSB MIA08CA172Accident · No injuriesData collectionFinal reportSchweizer 2-33A · Wurtsboro, NYThe failure of the dual student to relinquish flight control of the glider.NTSB NYC08LA271Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Lockport, NYA partial loss of engine power, as reported by the pilot, for undetermined reasons. Contributing to the accident was the pilot's inadequate preflight planning and the overweight condition of the airplane.NTSB MIA08LA131Accident · 1 fatalLimited investigationFinal reportAMS Flight APIS-M · Modena, NYThe pilot's improper use of wing spoilers on final approach and his misjudged distance/altitude resulting in the glider colliding with trees short of the runway.NTSB NYC08LA168Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Dansville, NYThe pilot's failure to attain the proper glide path and the flight instructor's delayed remedial action. Contributing to the accident was the encountered headwind.NTSB NYC08IA145Incident · No injuriesIncident investigationFinal reportAerospatiale AS355F1 · New York, NYThe pilot's inadequate visual lookout and subsequent failure to maintain clearance from the other helicopter due to his focus on the engine instruments during the initial departure. Contributing to the accident was insufficient helipad spacing.