NTSB investigations, 2018, NY
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 per year
| 1962 | 8 |
|---|---|
| 1963 | 2 |
| 1964 | 162 |
| 1965 | 197 |
| 1966 | 215 |
| 1967 | 226 |
| 1968 | 181 |
| 1969 | 172 |
| 1970 | 170 |
| 1971 | 164 |
| 1972 | 161 |
| 1973 | 124 |
| 1974 | 167 |
| 1975 | 121 |
| 1976 | 146 |
| 1977 | 152 |
| 1978 | 131 |
| 1979 | 119 |
| 1980 | 101 |
| 1981 | 100 |
| 1982 | 91 |
| 1983 | 95 |
| 1984 | 76 |
| 1985 | 84 |
| 1986 | 71 |
| 1987 | 70 |
| 1988 | 68 |
| 1989 | 64 |
| 1990 | 63 |
| 1991 | 58 |
| 1992 | 36 |
| 1993 | 49 |
| 1994 | 52 |
| 1995 | 58 |
| 1996 | 48 |
| 1997 | 36 |
| 1998 | 42 |
| 1999 | 41 |
| 2000 | 45 |
| 2001 | 42 |
| 2002 | 32 |
| 2003 | 46 |
| 2004 | 32 |
| 2005 | 43 |
| 2006 | 24 |
| 2007 | 43 |
| 2008 | 30 |
| 2009 | 32 |
| 2010 | 49 |
| 2011 | 37 |
| 2012 | 37 |
| 2013 | 28 |
| 2014 | 28 |
| 2015 | 34 |
| 2016 | 33 |
| 2017 | 28 |
| 2018 | 37 |
| 2019 | 19 |
| 2020 | 25 |
| 2021 | 24 |
| 2022 | 27 |
| 2023 | 28 |
| 2024 | 30 |
| 2025 | 16 |
| 2026 | 14 |
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 year(c.\"eventDate\") = 2018
AND 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 year(c."eventDate") = 2018 AND 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 GAA19CA103Accident · No injuriesData collectionFinal reportRobinson R44 · Strykersville, NYThe structural failure of the home-built landing platform during landing, which resulted in the helicopter rolling over.NTSB DCA19CA035Accident · Minor injuriesClass 4 · Data collectionFinal reportBombardier CL 600 2B19 · New York, NYthe captain initiating a cross bleed start while under tow.NTSB GAA19CA058Accident · Minor injuriesData collectionFinal reportCessna 172 · Piseco, NYThe pilot’s loss of directional control during landing, which resulted in impact with a snow pile and necessitated a go-around, during which the airplane impacted trees.NTSB ERA19FA039Accident · 1 fatalField investigationFinal reportCessna 310 · Walton, NYAn in-flight fire of undetermined origin. Contributing to the accident were the severe icing conditions encountered during the final minutes of the flight, which led to a loss of airplane control.NTSB ERA19FA035Accident · 2 fatalField investigationFinal reportAerospatiale AS 355F2 · Beekmantown, NYThe pilot's failure to keep the helicopter clear of a utility pole while hovering with a tailwind, which resulted in a dynamic rollover into active power lines.NTSB GAA19CA050Accident · No injuriesData collectionFinal reportPiper PA28 · East Moriches, NYThe pilot’s delayed initiation of a go-around and his subsequent use of the improper go-around procedure, which resulted in a landing area overshoot.NTSB DCA19CA207Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Albany, NYan encounter with convective turbulence that resulted in a serious injury to a flight attendant.NTSB ERA19LA012Accident · 3 fatalLimited investigationFinal reportPiper PA34 · Westhampton Beach, NYThe instructor's decision to conduct and continue a visual flight rules flight into instrument meteorological conditions with a known flight instrument anomaly, which resulted in spatial disorientation, causing a loss of airplane control and subsequent…NTSB GAA18CA570Accident · No injuriesData collectionFinal reportAviat A1 · Raquette Lake, NYThe pilot’s failure to maintain lateral control after landing on water in gusting wind conditions.NTSB ERA18LA253Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Montauk, NYThe pilot's failure to properly secure his seat before initiating the takeoff, which resulted in the seat sliding back as the airplane accelerated during takeoff, his inability to reach the pedals, and the subsequent loss of directional control and impact…NTSB GAA18CA568Accident · No injuriesData collectionFinal reportCessna U206 · Millbrook, NYThe failure of the other pilot to yield to traffic established on the taxiway, which resulted in a ground collision.NTSB DCA18LA285Accident · Serious injuriesClass 3 · LimitedFinal reportBoeing 757 · New York, NYThe flight crew’s failure to adequately monitor the airplane’s airspeed, which led to the captain’s aggressive control inputs to increase airspeed; these aggressive inputs resulted in injuries to three cabin crewmembers.NTSB GAA18CA515Accident · No injuriesData collectionFinal reportDell Lawrence Kitfox · Hunter, NYThe pilot’s inadequate in-flight fuel management, which necessitated an off-airport precautionary landing, and his failure to maintain airplane control during the landing roll on rough terrain.NTSB GAA18CA502Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Dansville, NYThe pilot’s failure to maintain clearance from crops during an agricultural application flight.NTSB GAA18CA561Accident · No injuriesData collectionFinal reportApollo Fox · Chateaugay, NYThe pilot’s failure to maintain clearance from trees during a go-around.NTSB GAA18CA423Accident · No injuriesData collectionFinal reportDaniels Alan L Kitfox Series 7 · Lowville, NYThe pilot’s failure to maintain a proper airspeed during the approach to land, which resulted in an aerodynamic stall.NTSB ERA18LA191Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Geneseo, NYThe pilot's failure to properly set the elevator trim before takeoff, which resulted in an exceedance of the airplane's critical angle of attack during takeoff and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s failure to follow…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.