NTSB investigations, NY
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 GAA18CA420Accident · No injuriesData collectionFinal reportCirrus SR22 · Hudson, NYCollision with a deer during landing.NTSB GAA18CA417Accident · No injuriesData collectionFinal reportTravel Air 2000 · Shelter Island, NYThe pilot's failure to maintain clearance from a tree during taxi.NTSB GAA18CA416Accident · No injuriesData collectionFinal reportAeroprakt A-22 Valor · Malone, NYThe pilot’s improper crosswind correction during the landing flare in gusting wind conditions, which resulted in a hard landing.NTSB ERA18LA157Accident · 4 fatalLimited investigationFinal reportPiper PA 31 · Amagansett, NYThe pilot's decision to fly under a thunderstorm and a subsequent encounter with turbulence and restricted visibility in heavy rain, which resulted in a loss of control.NTSB WPR18FA155Accident · 1 fatalField investigationFinal reportNorth American SNJ 2 · Melville, NYThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall, spin, and subsequent impact with terrain.NTSB ERA18LA155Accident · No injuriesClass 3 · LimitedFinal reportDevries WM H Kitfox Sport · Taghkanic, NYA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA18CA291Accident · Minor injuriesData collectionFinal reportPiper PA28 · Farmingdale, NYThe pilot’s exceedance of the airplane’s critical angle of attack during short final, which resulted in an aerodynamic stall and hard landing.NTSB GAA18CA268Accident · No injuriesData collectionFinal reportPiper PA 15 · Fulton, NYThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA267Accident · No injuriesData collectionFinal reportCessna 172 · Fulton, NYThe student pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB ERA18FA141Accident · 1 fatalField investigationFinal reportAeronca 7AC · Middletown, NYThe pilot's exceedance of the airplane's critical angle of attack during climbout, which resulted in an aerodynamic stall from which the pilot could not recover.NTSB DCA18CA165Accident · No injuriesData collectionFinal reportBombardier CL600 2D24 · Queens, NYthe failure of the captain of Delta 212 to ensure adequate clearance while taxiing behind Endeavor 3413.NTSB ERA18LA135Accident · Serious injuriesClass 3 · LimitedFinal reportHeard Alan E Mosquito XE · Albion, NYThe pilot's inadvertent, improper configuration of the engine fuel system, which resulted in an excessively lean air-to-fuel ratio and resulted in a loss of engine power; and the pilot's subsequent failure to maintain main rotor rpm following the loss of…NTSB GAA18CA222Accident · No injuriesData collectionFinal reportPiper PA 25-235 · Saratoga Springs, NYThe glider pilot’s failure to maintain pitch during a CG aerotow, which resulted in the loss of control of the tow airplane.NTSB ERA18LA124Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Lowville, NYThe pilot's diverted attention, which resulted in his inadequate monitoring of the airplane's attitude and a loss of control in flight.NTSB GAA18CA229Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Farmingdale, NYThe student pilot’s rapid lowering of the collective, which resulted in a hard landing.NTSB GAA18CA158Accident · Minor injuriesData collectionFinal reportJohnson Gerald CR-1 · Altamont, NYThe pilot’s failure to maintain the runway heading during the approach in gusting crosswind conditions.NTSB ERA18MA099Accident · 5 fatalClass 1 · MajorFinal reportAmerican Eurocopter AS350B2 · New York, NYLiberty Helicopters Inc.'s use of a NYONair-provided passenger harness/tether system, which caught on and activated the floor-mounted engine fuel shutoff lever and resulted in the in-flight loss of engine power and the subsequent ditching. Contributing to…NTSB ERA18LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Babylon, NYThe partial loss of engine power after a simulated engine failure for reasons that could not be determined because a postaccident examination and an engine test run did not reveal any anomalies that would have precluded normal operation.NTSB ERA18TA076Accident · No injuriesFinal reportVertical Aviation Technologies 260L Hummingbird · Harrisville, NYThe failure of an electric fuel pump, which resulted in fuel starvation and a total loss of engine power during cruise flight.NTSB GAA18CA100Accident · No injuriesData collectionFinal reportCessna 170 · Auburn, NYThe pilot’s improper wind correction inputs while taxiing with a quartering tailwind.NTSB DCA18LA024AccidentClass 3 · LimitedFinal reportBoeing 777 · Jamaica, NYThe air traffic controller's improper instruction to the Egypt Air airplane flight crew to pass in an area where passing is prohibited, which led to a ground collision.NTSB GAA18CA032Accident · No injuriesData collectionFinal reportPiper PA28 · West Seneca, NYThe airplane's collision with a deer during the landing roll.NTSB GAA18CA015Accident · Minor injuriesData collectionFinal reportThomas G Parkhurst Kitfox IV · Sidney, NYThe pilot's exceedance of the airplane’s critical angle of attack following a loss of ground reference during landing in glaring sun conditions, which resulted in an aerodynamic stall/spin.NTSB GAA17CA560Accident · Minor injuriesData collectionFinal reportPiper J5A · Geneseo, NYThe pilot's failure to properly secure the airplane before a hand propeller start, which resulted in the airplane moving forward and colliding with maintenance equipment.NTSB GAA17CA554Accident · Minor injuriesData collectionFinal reportThomas J Murray Kitfox Super Sport · Old Forge, NYThe separation of the wheel assembly during landing due to the pilot’s use of improper retaining nuts when he installed the tundra tires.NTSB DCA17IA202Incident · No injuriesIncident investigationFinal reportDJI Phantom · Hoffman Island, NYthe failure of the sUAS pilot to see and avoid the helicopter due to his intentional flight beyond visual line of sight. Contributing to the incident was the sUAS pilot's incomplete knowledge of the regulations and safe operating practices.NTSB ERA17LA338Accident · No injuriesLimited investigationFinal reportParks Richard A Starduster SA 100 · Southfields, NYA loose oil line that allowed oil to drip on the exhaust system, which resulted in smoke during cruise flight and a subsequent precautionary landing.NTSB GAA17CA567Accident · No injuriesData collectionFinal reportChancey Gerry M RV-12 · Dunkirk, NYThe pilot's failure to maintain lateral/bank control during takeoff in crosswind conditions.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 ERA17LA298Accident · Minor injuriesLimited investigationFinal reportCessna 305 · Wurtsboro, NYA fatigue fracture of the left main landing gear axle.NTSB ERA17LA292Accident · Minor injuriesClass 3 · LimitedFinal reportHostein K/Hostein S Pietenpol · Albion, NYLoss of directional control due to a restriction of rudder movement.NTSB DCA17CA181Accident · No injuriesData collectionFinal reportBoeing 737 832 · Queens, NYthe Delta B737 captain's failure to maintain proper clearance between his airplane and the stopped American B757.NTSB DCA17LA173Accident · Serious injuriesLimited investigationFinal reportAirbus 330 · East Hampton, NYan inadvertent encounter with convective turbulence.NTSB GAA17CA480Accident · No injuriesData collectionFinal reportThomas J Hankamp VAN'S Aircraft RV4 · Poughkeepsie, NYThe pilot’s failure to maintain directional control during takeoff.NTSB GAA17CA574Accident · No injuriesData collectionFinal reportCessna 208 · New York, NYThe airplane’s encounter with boat wake and multiple swells during a water takeoff.NTSB ERA17LA247Accident · No injuriesLimited investigationFinal reportAeroprakt A 20 Vista Cruiser · Shirley, NYThe pilot's inadvertent activation of the engine's choke control during a downdraft encounter, which resulted in a total loss of engine power.NTSB ERA17FA226Accident · 1 fatalField investigationFinal reportLuscombe 8 · Remsen, NYThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall at an altitude too low for him to recover.NTSB ERA17LA203Accident · No injuriesLimited investigationFinal reportCessna 172 · Suffolk, NYA loss of preload to the crankshaft gear attachment bolt due to improper installation, which resulted in the fatigue failure of the crankshaft gear alignment dowel and led to the rotation of the crankshaft gear and a subsequent total loss of engine power.NTSB CEN17IA233Incident · No injuriesIncident investigationFinal reportSchroder David Lancair IV P · Fulton, NYThe loss of oil pressure and subsequent engine overspeed/surge during a zero g-force maneuver, which resulted in the separation of a crankshaft counterweight and loss of engine power.NTSB ERA17LA188Accident · Minor injuriesLimited investigationFinal reportMaule M7 · Colton, NYThe pilots' initiation of an uncoordinated right turn with the fuel selector positioned to the right main fuel tank, which had a low quantity of fuel in it and resulted in a total loss of engine power due to the unporting of the fuel and subsequent fuel…NTSB GAA17CA307Accident · No injuriesData collectionFinal reportCessna U206 · Diamond Point, NYThe pilot’s failure to maintain directional control during the takeoff roll with gusting wind conditions.NTSB ERA17FA172Accident · 1 fatalField investigationFinal reportPiper PA31 · Colton, NYThe pilot's incapacitation for unknown reasons, which resulted in an overflight of his destination, a subsequent loss of engine power due to fuel starvation, and collision with terrain.NTSB GAA17CA249Accident · No injuriesData collectionFinal reportCessna 177 · Marathon, NYThe pilot’s failure to maintain altitude and airspeed while maneuvering at a low altitude.NTSB ERA17LA166Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Ovid, NYThe mechanic's failure to inspect and clean the carburetor fuel inlet screen during the airplane’s annual inspection, which allowed undetected debris and dirt to obstruct the fuel supply and resulted in fuel starvation and the subsequent total loss of engine…NTSB GAA17CA219Accident · Minor injuriesData collectionFinal reportCessna 172 · Millbrook, NYThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during landing with a crosswind, which resulted in an aerodynamic stall and an off-runway landing.NTSB ERA17LA134Accident · No injuriesClass 3 · LimitedFinal reportBeech 95B55 · Islip, NYThe pilot's failure to lower the landing gear before touchdown, which resulted in the gear-up landing.NTSB ERA17LA120Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150J · Argyle, NYA total loss of engine power for undetermined reasons, which resulted in a forced landing and subsequent impact with trees.NTSB 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…NTSB ERA17LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Shoreham, NYA fatigue crack of the crankshaft at the No. 4 main bearing journal.NTSB GAA17CA061Accident · No injuriesData collectionFinal reportBeech 95B55 · Plattsburgh, NYThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle-of-attack during a single-engine approach, which resulted in an aerodynamic stall at an altitude too low for the flight instructor to recover.