NTSB investigations, 2004, 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 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\") = 2004
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") = 2004 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 NYC05CA037Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Johnstown, NYThe pilot's inadequate in-flight planning/decision which resulted in airframe ice with subsequent degradation of aircraft performance, and inadequate airspeed during the landing flare.NTSB IAD05LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150C · East Moriches, NYSeveral mechanical deficiencies which either independently or collectively resulted in a subsequent loss of engine power. A factor in the accident was the obstruction in the forced landing area.NTSB NYC05LA022Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Duanesburg, NYThe pilot's improper decision to attempt a takeoff without allowing the engine to adequately warm-up; which resulted in a partial loss of power during takeoff and subsequent forced landing.NTSB IAD05CA015Accident · No injuriesData collectionFinal reportSocata TB 21-TC · Binghamton, NYThe pilot's improper IFR procedure by his flight below the decision altitude, and his failure to maintain obstacle clearance.NTSB IAD05LA031Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Galloo Island, NYA partial loss of engine power for undetermined reasons. A factor was the pilot's improper decision to operate the helicopter outside the height velocity curve.NTSB NYC05CA018Accident · No injuriesData collectionFinal reportKinner Sportster · Millbrook, NYThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. A factor was the crosswind.NTSB NYC05FA001Accident · 2 fatalField investigationFinal reportCessna 172N · Germantown, NYThe pilot's inadequate in-flight planning/decision which led to VFR flight into IMC and his loss of aircraft control. Factors were night and cloud conditions.NTSB IAD04LA048Accident · Minor injuriesLimited investigationFinal reportBoeing A75N (PT17) · Bayport, NYThe failure of a magneto, which resulted in a loss of engine power. Factors in the accident were the pilot's decision to take off downwind, which resulted in reduced airplane performance, and the tail wind.NTSB IAD04LA046Accident · 1 fatalLimited investigationFinal reportScott Rans S-12 · Seneca, NYThe student pilot's failure to maintain airspeed above stall speed, which resulted in an inadvertant stall/spin. A factor in the accident was the pilot's lack of pilot certification.NTSB NYC04CA205Accident · No injuriesData collectionFinal reportPiper PA32-300 · Montauk, NYThe pilot's failure to maintain altitude\clearance while landing. A factor in this accident was the gusty wind conditions.NTSB IAD04LA044Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Penn Yan, NYthe pilot's loss of directional control during landing which resulted in excessive side-loads and failure of the right main landing gear wheel.NTSB NYC04LA201Accident · No injuriesLimited investigationFinal reportPZL 101 · Chazy, NYThe total loss of engine power due to the fractured crankshaft.NTSB NYC04FA197Accident · 2 fatalField investigationFinal reportRobinson R-22 · Northport, NYAn improper maneuver by the flightcrew while attempting to avoid a kite, which resulted in mast bumping, the separation of the main rotor system, and a subsequent uncontrolled descent into water.NTSB IAD04LA050Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-135KL · Clyde, NYAn unexpected encounter with clear air turbulence.NTSB IAD04FA040Accident · 1 fatalField investigationFinal reportPiper PA-31P · Clarkson, NYThe pilot's mismanagement of the fuel by his failure to select the proper fuel tank which resulted in starvation and subsequent loss of engine power in both engines.NTSB NYC04LA192Accident · No injuriesLimited investigationFinal reportWaco QCF · Rhinebeck, NYA partial loss of engine power due to a magneto failure.NTSB NYC04LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Cooperstown, NYThe pilot's failure to maintain adequate airspeed and her premature rotation which resulted in an inadvertent stall/mush and subsequent impact with the ground.NTSB NYC04LA178Accident · 1 fatalLimited investigationFinal reportGarrett Stephens Akro · Westport, NYThe pilot's loss of aircraft control while maneuvering, due to incapacitation, which resulted in a collision with terrain.NTSB IAD04FA031Accident · 1 fatalField investigationFinal reportCessna 172C · Edinburgh, NYThe pilot's occluded left main coronary artery, which resulted in a massive heart attack and sudden death in flight.NTSB IAD04FA030Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Ticonderoga, NYReason for occurrence undetermined.NTSB NYC04LA156Accident · No injuriesLimited investigationFinal reportCessna 182Q · Brighton Beach, NYA partial loss of engine power during cruise flight for undetermined reasons.NTSB NYC04CA155Accident · No injuriesData collectionFinal reportBellanca 7ECA · North Creek, NYThe pilot's failure to maintain directional control during the landing roll. A factor in this accident was the pilot's lack of experience in tail-wheeled airplanes.NTSB NYC04FA144Accident · 1 fatalField investigationFinal reportCessna P210N · Dunkirk, NYThe pilot's loss of aircraft control and the subsequent overstress and separation of the wing during an encounter with convection induced turbulence.NTSB NYC04LA130Accident · Minor injuriesLimited investigationFinal reportHigh Craft Buccaneer · Glasco, NYThe pilot's failure to maintain airspeed during landing, which resulted in an inadvertent stall and subsequent impact with the water. A factor was the pilot's lack of experience in the airplane and his diverted attention.NTSB NYC04LA120Accident · No injuriesLimited investigationFinal reportCessna 170B · Shirley, NYThe pilot's inadequate pre-flight inspection, which resulted in his failure to remove the engine inlet covers and subsequent loss of engine power.NTSB NYC04FA117Accident · Serious injuriesField investigationFinal reportEurocopter AS-350BA · Brooklyn, NYThe pilot's failure to maintain control of the helicopter after a loss of hydraulic system pressure due to a failure of the hydraulic pump belt. Factors in this accident were the pilot's misidentification of a hydraulic failure, the pilot's subsequent failure…NTSB NYC04CA108Accident · Serious injuriesData collectionFinal reportAndrews Zenith Tri-Z · Kennedy, NYThe pilot's improper fuel tank selector position which resulted in a loss of engine power due to fuel starvation.NTSB NYC04FA100Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Harrietstown, NYThe pilot's failure to follow instrument flight rules procedures resulting in a collision with a tree. Factors related to the accident were the dark night conditions, low visibility, and low cloud ceiling.NTSB NYC04CA096Accident · No injuriesData collectionFinal reportHughes 269B · Farmingdale, NYThe pilot's failure to maintain aircraft control while hover-taxiing. A factor in this accident was the high wind condition.NTSB NYC04LA088Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Utica, NYThe copilot's failure to maintain airspeed, and the captain's delayed remedial action, which resulted in an inadvertent stall and the subsequent hard landing.NTSB NYC04CA080Accident · No injuriesData collectionFinal reportBellanca 7ECA · Hornell, NYAn inadvertent encounter with soft snow during takeoff.NTSB NYC04CA068Accident · No injuriesData collectionFinal reportCessna 172E · Batavia, NYThe pilot's failure to maintain directional control while landing. Factors were a tailwind and icy runway.