NTSB investigations, 2002, NY
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 | 13 |
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\") = 2002
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") = 2002 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 NYC03LA033Accident · No injuriesLimited investigationFinal reportMBB BK 117 A-4 · Albany, NYThe inadvertent encounter with a downdraft during engine start, which flexed the main rotor blades and subsequently damaged the tail boom assembly. A factor related to the accident was the failure of the operator to comply with a service bulletin.NTSB NYC03FA024Accident · 1 fatalField investigationFinal reportSocata TB-20 · Massena, NYThe pilot's failure to maintain airspeed, which resulted in a stall. Factors in this accident were the icing conditions, deteriorated airplane performance due to ice accumulation, and control interference by the passenger as reported by the pilot.NTSB NYC03FA020Accident · 1 fatalField investigationFinal reportCessna 210L · Rochester, NYA loss of engine power for undetermined reasons. A factor in this accident was the night light condition which precluded the pilot's ability to adequately view suitable forced landing areas.NTSB NYC03LA016Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Flushing, NYAn inadvertent trauma to the passenger's foot during an emergency evacuation.NTSB IAD03LA012Accident · 1 fatalLimited investigationFinal reportWestland Helicopters Gazelle AH-MK1 · East Hampton, NYThe pilot's failure to maintain adequate altitude, which resulted in an in-flight collision with water. Factors included the pilot's decision to fly over water on a moonless night, his lack of experience in that environment, and the dark night lighting…NTSB NYC03LA004Accident · No injuriesLimited investigationFinal reportde Havilland DHC-8-102 · Albany, NYAn in-flight collision with birds. A factor was the night conditions.NTSB NYC02FA197Accident · 1 fatalField investigationFinal reportCessna 310L · Virgil, NYThe pilot's decision to continue the flight into IMC after canceling his IFR clearance, and his failure to maintain terrain clearance while maneuvering. Factors in the accident were rain, low ceilings, and night.NTSB NYC02LA188Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Canadaigua, NYThe pilot's inadequate preflight inspection of the airplane, which resulted in a loss of engine power due to fuel contamination.NTSB NYC02LA190Accident · No injuriesLimited investigationFinal reportCessna 421 · Ithaca, NYThe pilot's failure to maintain directional control during the landing roll. A factor in the accident was the wet runway.NTSB NYC02FA173Accident · 1 fatalField investigationFinal reportPiper PA-22-108 · Mayville, NYThe student pilot's failure to maintain adequate altitude during the landing approach and the private pilot's inadequate supervision, which resulted in a collision with a marked utility pole. A factor in this accident was the student pilot's lack of…NTSB NYC02LA161Accident · No injuriesLimited investigationFinal reportCessna 172RG · Rochester, NYThe pilot's improper flare and recovery from a bounced landing. A factor in the accident was the slow response time of the airspeed indicator.NTSB NYC02FA160Accident · Serious injuriesField investigationFinal reportBoeing 747-256 · Jamaica, NYAn accessory gearbox fire of the number 2 engine, due to hot air bypassing a damaged compressor air seal stack, which resulted in an emergency evacuation.NTSB IAD02IA076Incident · No injuriesIncident investigationFinal reportFairchild Dornier DO-328-300 · New York, NYThe partial loss of flight display information for undetermined reasons.NTSB NYC02LA147Accident · Minor injuriesLimited investigationFinal reportBell 206B · Newfield, NYThe pilot's failure to verify the amount of fuel onboard prior to departure, which resulted in a power loss due to fuel exhaustion, and subsequent hard landing. A factor was the lack of a suitable landing area under the helicopter when the power loss occurred.NTSB NYC02LA130Accident · Serious injuriesLimited investigationFinal reportWheeler Volksplane VP-2 · Collins, NYThe separation of an ignition lead to the distributor cap, which resulted in a total loss of engine power. Factors in the accident were trees and power lines.NTSB IAD02LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Fulton, NYThe pilot's improper flare, which resulted in a misaligned, hard landing.NTSB NYC02LA129Accident · 1 fatalLimited investigationFinal reportPank KitFox · Sprakers, NYThe pilot's failure to maintain aircraft control. A factor in the accident was the pilot's lack of experience in category of aircraft.NTSB NYC02LA124Accident · No injuriesLimited investigationFinal reportHunter A-28 Victor · Shelter Island, NYThe pilot's failure to maintain directional control during the takeoff, which resulted in a collision with trees.NTSB NYC02TA104Accident · Minor injuriesFinal reportHughes OH-6A · Angola, NYThe loss of engine power for undetermined reasons.NTSB NYC02LA103Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Roxbury, NYThe airplane encountering an unanticipated downdraft that exceeded the climb performance of the airplane.NTSB NYC02IA100Incident · No injuriesIncident investigationFinal reportDornier 328-300 · Albany, NYRudder oscillations of an undetermined origin.NTSB IAD02LA049Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Westhampton Bch, NYLoss of engine power for undetermined reasons.NTSB NYC02LA092Accident · No injuriesLimited investigationFinal reportBlanik L-13 · Saratoga Spring, NYThe glider encountering an unanticipated downdraft, which resulted in insufficient altitude to reach a suitable landing area.NTSB NYC02LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Middleville, NYThe pilot's failure to maintain proper alignment with the runway after being struck by a gust of wind. Factors were the gusty winds and the berm struck by the airplane.NTSB NYC02FA089Accident · 2 fatalField investigationFinal reportCirrus SR-22 · Parish, NYThe pilots' failure to maintain airspeed, which resulted in an inadvertent stall/spin. The continued spin to the ground was a result of the pilots' failure to deploy the onboard parachute recovery system, for undetermined reasons.NTSB NYC02LA086Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Islip, NYThe flight instructors failure to maintain aircraft control during a wind gust. A factor in the accident was a sudden gust of wind.NTSB NYC02LA083Accident · No injuriesLimited investigationFinal reportBell 206-L3 · New York, NYThe pilot's improper flare while landing, which resulted in a collision with a concrete curb.NTSB NYC02FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Gardiner, NYThe pilot-in-command's failure to maintain sufficient altitude while maneuvering in a mountainous area, which resulted in a collision with terrain. Factors in the accident were, mountainous terrain, clouds, and the pilot's decision to continue the flight in…NTSB NYC02LA078Accident · No injuriesLimited investigationFinal reportCessna 150M · Salisbury Ctr, NYThe pilot's delayed decision to ask for help which led to a power loss due to fuel starvation.NTSB NYC02IA076Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Jefferson, NYAn in-flight encounter with lightning, which severed two of the four elevator cables.NTSB NYC02LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Argyle, NYThe pilot's improper in-flight decision to land on a contaminated runway. A factor was the contaminated runway.NTSB IAD02LA030Accident · Minor injuriesLimited investigationFinal reportKorsch Classic IV · East Moriches, NYThe pilot's improper recovery from a bounced landing, which resulted in a loss of directional control. A contributing factor was the pilot's lack of experience in aircraft type.