NTSB investigations, NY
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 ERA24FA262Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA31 · Loudonville, NYOn June 17, 2024, at 0816 eastern daylight time, a Piper PA-31-310, Canadian registration C-GKSI, was destroyed when it was involved in an accident in Loudonville, New York. The airline transport pilot was fatally injured and one person on the ground…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 ERA24LA194Accident · No injuriesClass 4 · LimitedFinal reportMooney M20E · Hornell, NYA cabin fire as a result of a damaged lithium-ion battery pack.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 DCA23LA465Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-8 · Lake Erie Beach, NYMalfunctioning brakes on a service cart.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 ERA23LA351Accident · Serious injuriesClass 3 · LimitedFinal reportNanchang China CJ-6A · Merrickville, NYA total loss of engine power while enroute for reasons that could not be determined.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 ERA23LA285Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA40 · Yorktown Heights, NYA fatigue failure of the turbocharger housing, which resulted in a partial loss of engine power.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 ERA23FA249Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Plymouth, NYA total loss of engine power for reasons that could not be determined.NTSB CEN23FA204Accident · 2 fatalClass 3 · FieldFinal reportLuce Buttercup · Lyndonville, NYAn in-flight breakup due to structural overload of the airplane for undetermined reasons.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 ERA23LA156Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Shoreham, NYA total loss of engine power for unknown reasons.NTSB ERA23FA137Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Lindenhurst, NYAn in-flight fire due to a compromised oil pressure line fitting, which resulted in a collision with terrain during a subsequent emergency landing.NTSB DCA23LA191Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer ERJ 190-100 IGW · New York, NYElectrical sparking caused by a faulty connection between the aircraft and ground power unit resulting in a serious injury to a ground service agent.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 ERA23FA113Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · North Castle, NYThe pre-ignition/detonation damage to the No. 4 piston for reasons that could not be determined, which allowed the crankcase to become pressurized and resulted in oil exhaustion and subsequent catastrophic internal engine failure.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.NTSB ERA23LA084Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Gilgo-Oak Beach-Captree, NYThe flight instructor’s inadequate remedial action while supervising the student pilot’s practice autorotation in gusting wind conditions, which resulted in a dynamic rollover.NTSB ERA23LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 310J · Fulton, NYThe pilots failure to slow the airplane down prior to turning off the runway, which resulted in damage to the airplane’s fuselage structure in the vicinity of the nose landing gear.NTSB ERA23LA050Accident · Minor injuriesClass 4 · LimitedFinal reportBeech B-60 · Farmingdale, NYThe pilot’s improper preflight inspection of the airplane’s fuel system, resulting in him commencing the flight with an inadequate fuel supply.NTSB ERA23LA012Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MX-7-160 · Northville, NYThe pilot's decision to depart from an area of wet sand, which resulted in a nose over during the attempted takeoff.NTSB ERA23FA007Accident · 1 fatalClass 3 · FieldFinal reportSeamax M-22 · East Hampton, NYAn inflight separation of the right wing as a result of the manufacturer’s application of a bolt and nut in the upper wing strut attachment point that was inconsistent with the nut design intent and usage limitations.NTSB ERA22LA430Accident · Serious injuriesClass 4 · LimitedFinal reportTaylorcraft BC12 · Buffalo, NYThe pilot’s failure to maintain aircraft control during initial climb after a go-around, which resulted in an aerodynamic stall and spin at low altitude.NTSB DCA22LA198Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus 220 · New York, NYAn encounter with convective turbulence.NTSB ERA22LA388Accident · Minor injuriesClass 4 · LimitedFinal reportSchleicher K7 · Mayville, NYThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in an off-airport landing.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 ERA22LA369Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jamestown, NYA partial loss of engine power for reasons that could not be definitively determined.NTSB ERA22LA363Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150H · Ellenville, NYBoth pilots’ decision to perform the takeoff near maximum gross weight with 10° of flaps, contrary to the owner’s manual procedure, which resulted in the airplane’s degraded climb performance approaching high terrain.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.