NTSB investigations, 2025, NY
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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\") = 2025
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") = 2025 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 ERA26LA076Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · East Farmingdale, NYA loss of brake effectiveness during taxi, which resulted in a collision with another airplane.NTSB ERA26FA027Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20E · Ballston Spa, NYOn October 31, 2025, about 1035 eastern daylight time, a Mooney M20E, N79338, was destroyed when it was involved in an accident near Ballston Spa, New York. The pilot was fatally injured, and the flight instructor was seriously injured. The airplane was…NTSB DCA26FA001Accident · Minor injuriesClass 3 · FieldPreliminary reportBombardier CL-600-2D24 · New York, NYOn October 1, 2025, about 2156 eastern daylight time (EDT), Endeavor Air dba Delta Connection flight 5155, a Mitsubishi Heavy Industries (MHI) RJ CL-600-2D24 (CRJ-900), N902XJ, collided with Endeavor Air dba Delta Connection flight 5047, a MHI RJ CL-600-2D24…NTSB ERA25FA367Accident · 1 fatalClass 3 · FieldPreliminary reportToop Thomas A Glasair Super II FT · Wallkill, NYOn September 27, 2025, at 1418 eastern daylight time, an experimental, amateur-built Glasair Super II FT, N45BT, was destroyed when it was involved in an accident near Wallkill, New York. The pilot sustained fatal injuries. The airplane was operated as a…NTSB ERA25LA363Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · White Plains, NYThe pilot’s failure to maintain proper glidepath during a night visual approach, which resulted in a collision with the runway lighting system. Contributing to the outcome was the pilot’s momentary disorientation due to glare from the runway approach lighting…NTSB ERA25LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Farmingdale, NYThe Cessna 150 pilot’s decision to taxi in front of an oncoming Cessna 172, which resulted in a ground collision. Contributing to the accident was the Cessna 150 pilot’s momentary distraction, which delayed his recognition of the impending collision.NTSB ERA25LA328Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Montauk, NYThe pilot’s failure to verify the wind direction and maintain an appropriate approach speed, which resulted in a long landing and subsequent runway excursion.NTSB WPR25FA233Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 152 · Hornell, NYOn August 1, 2025, about 1859 eastern daylight time, a Cessna 152, N6125B was destroyed when it was involved in an accident near Hornell, New York. The student pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB ERA25FA283Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J5C · Rochester, NYOn August 1, 2025, about 1330 eastern daylight time, a Piper J5C, NC 28151, was substantially damaged when it was involved in an accident near Rochester, New York. The passenger was fatally injured, and the pilot was seriously injured. The airplane was…NTSB ERA25LA282Accident · Minor injuriesClass 4 · LimitedFinal reportPaul Dennis Berg Exec 162F · Holley, NYThe pilot’s failure to maintain clearance with the ground while hovering, which resulted in a dynamic rollover.NTSB ERA25LA276Accident · No injuriesClass 4 · LimitedFinal reportHoward DGA-15P · Farmingdale, NYThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind.NTSB ERA25LA267Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Inlet, NYThe pilot’s failure to maintain control of the helicopter during the landing.NTSB ERA25LA262Accident · No injuriesClass 4 · LimitedFinal reportRaytheon G58 · East Hampton, NYThe pilot’s failure to extend the landing gear before landing due to his distraction.NTSB WPR25MA128Accident · 6 fatalClass 3 · MajorPreliminary reportMitsubishi MU-2B-40 · Copake, NYOn April 12, 2025, about 1203 eastern daylight time, a Mitsubishi MU-2B-40, N635TA, was destroyed when it was involved in an accident near Copake, New York. The pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB ERA25LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 172C · Argyle, NYThe mechanic’s incorrect installation of the oil temperature gauge probe in the oil filter adapter and failure to test run the engine for oil leaks after the installation, which resulted in a total loss of oil and the pilot’s decision to perform a…NTSB ERA25LA121Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Syracuse, NYThe truck driver’s to see and avoid the airplane, which resulted in a collision.