NTSB investigations, NY
435 cases where NTSB found Personnel issues.
Cases per year
| 2008 | 24 |
|---|---|
| 2009 | 28 |
| 2010 | 40 |
| 2011 | 33 |
| 2012 | 29 |
| 2013 | 24 |
| 2014 | 22 |
| 2015 | 29 |
| 2016 | 26 |
| 2017 | 21 |
| 2018 | 29 |
| 2019 | 17 |
| 2020 | 23 |
| 2021 | 20 |
| 2022 | 20 |
| 2023 | 19 |
| 2024 | 21 |
| 2025 | 7 |
| 2026 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02')) 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 ERA26LA276Accident · Minor injuriesClass 4 · LimitedFinal reportChristen Industries Pitts S-2 · Porter Center, NYThe pilot’s failure to maintain directional control during the landing roll.NTSB DCA26LA282Accident · No injuriesClass 4 · LimitedFinal reportAirbus A321-211 · New York, NYThe first officer’s excessive aft sidestick input following a bounced landing, and the line check pilot’s delayed remedial action, which resulted in an increase in the airplane’s pitch attitude and a subsequent tailstrike.NTSB ERA26LA209Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Harrison, NYThe student pilot’s excessive pitch up attitude during takeoff, which resulted in an aerodynamic stall and loss of control.NTSB ERA25LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Farmingdale, NYThe Cessna 150 pilot’s decision to taxi in front of an oncoming Cessna 172, which resulted in a ground collision. Contributing to the accident was the Cessna 150 pilot’s momentary distraction, which delayed his recognition of the impending collision.NTSB ERA25LA328Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Montauk, NYThe pilot’s failure to verify the wind direction and maintain an appropriate approach speed, which resulted in a long landing and subsequent runway excursion.NTSB ERA25LA282Accident · Minor injuriesClass 4 · LimitedFinal reportPaul Dennis Berg Exec 162F · Holley, NYThe pilot’s failure to maintain clearance with the ground while hovering, which resulted in a dynamic rollover.NTSB ERA25LA267Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Inlet, NYThe pilot’s failure to maintain control of the helicopter during the landing.NTSB ERA25LA262Accident · No injuriesClass 4 · LimitedFinal reportRaytheon G58 · East Hampton, NYThe pilot’s failure to extend the landing gear before landing due to his distraction.NTSB ERA25LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 172C · Argyle, NYThe mechanic’s incorrect installation of the oil temperature gauge probe in the oil filter adapter and failure to test run the engine for oil leaks after the installation, which resulted in a total loss of oil and the pilot’s decision to perform a…NTSB ERA25LA121Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Syracuse, NYThe truck driver’s to see and avoid the airplane, which resulted in a collision.NTSB ERA24LA401Accident · No injuriesClass 4 · LimitedFinal reportRemos Gemini Remos G-3/600 · Atwell, NYThe pilot’s failure to maintain aircraft control on takeoff.NTSB ERA24LA387Accident · Minor injuriesClass 3 · LimitedFinal reportAgustawestland Philadelphia AW119MKII · Canandaigua, NYThe pilot’s excessive descent rate during the final approach for landing and his delayed recovery attempt, resulting in a hard landing.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 ERA24LA372Accident · No injuriesClass 4 · LimitedFinal reportTextron 208B · New York, NYThe pilot’s improper decision to rush his departure, which resulted in a rough water encounter and collision with the wake of a passing ferry boat.NTSB ERA24LA368Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Shelter Island, NYThe pilot’s failure to attain a proper touchdown point while landing, which resulted in a runway overrun.NTSB ERA24LA353Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Mohawk, NYThe pilot’s failure to maintain directional control during the landing roll in wet conditions, which resulted in a runway excursion and collision with a fence.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 ERA24LA332Accident · No injuriesClass 4 · LimitedFinal reportBucker Jungmann C.A.S.A. 1.131 · Red Hook, NYThe Great Lakes pilot's failure to maintain adequate clearance from the Bucker Jungmann while maneuvering during an air show, which resulted in a midair collision, the inability of the Bucker Jungmann to maintain altitude, and its subsequent forced landing.NTSB ERA24LA324Accident · No injuriesClass 4 · LimitedFinal reportLake LA4 · Catskill, NYThe pilot’s failure to maintain control of the airplane during a takeoff from water in gusting wind conditions.NTSB ERA24FA318Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Ronkonkoma, NYA loss of engine power during initial climb for undetermined reasons. Contributing to the outcome was the pilot's failure to maintain control of the airplane following the loss of engine power and his decision to perform an intersection takeoff which, reduced…NTSB ERA24FA309Accident · 1 fatalClass 3 · FieldFinal reportCessna 208 · Youngstown, NYThe pilot’s loss of control in flight which resulted in the airplane impacting the ground at a high rate of speed and descent.NTSB ERA24LA317Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Montauk, NYThe pilot’s failure to maintain an appropriate glide path during the landing approach in terrain induced turbulence, resulting in a hard landing and subsequent runway excursion.NTSB ERA24FA283Accident · 5 fatalClass 3 · FieldFinal reportPiper PA46 · Trout Creek, NYThe pilot’s loss of airplane control in flight due to spatial disorientation during a climb to cruise altitude in instrument meteorological conditions and turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was…NTSB ERA24LA268Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Painted Post, NYThe pilot’s failure to maintain directional control of the airplane during an aborted landing, which resulted in runway excursion and collision with a ditch.NTSB ERA24LA238Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Geneseo, NYThe pilot’s failure to maintain directional control during the takeoff roll resulting in a runway excursion, and subsequent nose over.NTSB ERA24LA224Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Lagrangeville, NYThe pilot’s failure to maintain control of the airplane during the landing and subsequent go-around attempt. Also causal was the flight instructor’s delayed remedial action.NTSB ERA24LA196Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Endicott, NYThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a runway excursion, and subsequent collision with trees.NTSB DCA24FA164IncidentClass 2 · FieldFinal reportAirbus A330 · Queens, NYNonstandard crossing phraseology and ineffective coordination between local controller 1 (LC1) and local controller 2 (LC2) which resulted in degraded shared situation awareness, and a runway incursion.NTSB ERA24LA175Accident · Minor injuriesClass 4 · LimitedFinal reportHaring Robert C Zenith CH601XLB · East Amherst, NYThe pilot’s failure to maintain directional control and his decision to continue the takeoff from the soft turf runway.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 DCA24LA097Accident · Serious injuriesClass 3 · LimitedFinal reportBoeing 777-222ER · Kelsey, NYThe airplane’s encounter with an unanticipated localized region of moderate-to-severe turbulence while in instrument meteorological conditions (IMC) associated with strong upper-level wind shear and convective cells. Contributing to the severity of the…NTSB ERA24LA042Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Ogdensburg, NYThe loss of control of the helicopter during taxi, which resulted in rollover.NTSB ERA24LA029Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Elmira, NYThe pilot’s failure to attain a proper glidepath for a landing on the intended runway, which resulted in an off-airport landing and impact with soft terrain.NTSB ERA24LA028Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Ronkonkoma, NYThe student pilot’s abrupt control input and the flight instructor’s inadequate remedial action, which resulted in a dynamic rollover.NTSB 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.NTSB ERA23LA374Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Cortland, NYThe pilot's failure to maintain directional control while landing in a gusting crosswind, which resulted in a noseover. Contributing was the pilot’s lack of familiarity with the airplane.NTSB ERA23LA343Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-17 · Millbrook, NYThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB ERA23LA354Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Fishers Island, NYThe loss of engine power for reasons that could not be determined. Contributing was the pilot’s misjudgment of airspeed and altitude during the forced landing.NTSB CEN23LA293Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · Canandaigua, NYThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing, the passenger’s leg hitting the gas tank, and serious injury.NTSB CEN23LA252Accident · No injuriesClass 4 · LimitedFinal reportStarduster II · Norwich, NYThe pilot’s loss of directional control during landing rollout due to interference from the pilot’s foot/shoe with the airplane structure that resulted in a runway excursion and impact with terrain.NTSB ERA23FA266Accident · 1 fatalClass 3 · FieldFinal reportWonder Michael S Harmon Rocket · Porter, NYThe pilot’s failure to maintain control of the airplane while initiating a low-altitude aerobatic maneuver, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s high-risk behavior.NTSB ERA23FA258Accident · 2 fatalClass 3 · FieldFinal reportCirrus SR22 · Jamestown, NYThe pilots’ failure to maintain airplane control following an anomalous engine indication during the initial climb, which resulted in a loss of control and parachute deployment at an altitude too low for the system to operate effectively. Contributing to the…NTSB ERA23LA229Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · South Bethlehem, NYThe pilot’s improper decision to attempt an intersection takeoff in a tailwind when the full runway in the opposite, headwind direction was available.NTSB ERA23LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · White Plains, NYThe pilot's failure to maintain directional control during the landing rollout in gusting wind, which resulted in a runway excursion and subsequent nose over.NTSB ERA23LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 150H · Mattituck, NYThe pilot’s failure to maintain control of the airplane during the landing, which resulted in a hard landing and runway excursion.NTSB ERA23LA157Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-2A-1 · Livonia, NYThe pilot’s delayed action to arrest the high descent rate during a practice autorotation in tailwind conditions which ultimately resulted in loss of control.NTSB ERA23LA126Accident · No injuriesClass 3 · LimitedFinal reportGates Learjet 55 · Rochester, NYThe pilots’ failure to attain a proper landing flare and touchdown point, which resulted in a hard landing short of the runway.NTSB ERA23LA140Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Lake Katrine, NYThe pilot’s failure to maintain an appropriate pitch attitude and descent rate during landing, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB DCA23LA125Incident · No injuriesClass 1 · LimitedFinal reportBoeing 737-900ER · Queens, NYThe American Airlines flight 106 (AAL106) crew’s surface navigation error due to distractions caused by their performance of concurrent operational tasks during taxi, which resulted in a loss of situational awareness. Contributing to the incident was the air…NTSB DCA23LA114Accident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2D24 · New York, NYITA Airways flight crew's incorrect evaluation of the clearance between their airplane and another airplane stopped on an adjoining taxiway.