NTSB investigations, 2019, 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\") = 2019
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") = 2019 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 ERA20LA082Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20J · Farmingdale, NYThe pilot’s improper preflight inspection, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA20CA110Accident · Minor injuriesData collectionFinal reportPiper PA28 · Cortland, NYThe student pilot's failure to maintain the runway heading during takeoff, which resulted in impact with a snowbank and a subsequent nose-over.NTSB GAA20CA048Accident · Minor injuriesData collectionFinal reportBeech A36 · Le Roy, NYThe pilot's improper pitch control during takeoff in high, gusting wind conditions, which resulted in a runway overrun and the nose landing gear collapsing.NTSB GAA20CA008Accident · No injuriesData collectionFinal reportPiper PA18 · Big Flats, NYThe pilot's improper flight planning and his subsequent failure to maintain clearance from wires during takeoff.NTSB ERA19FA249Accident · 2 fatalClass 3 · FieldFinal reportCessna T303 · Lagrangeville, NYA partial loss of engine power in both engines during initial climb for reasons that could not be determined based on the available information.NTSB GAA19CA484Accident · Serious injuriesData collectionFinal reportCameron A 210 · Hume, NYThe pilot's failure to maintain a proper descent rate during landing, which resulted in a hard landing and a serious passenger injury.NTSB GAA19CA469Accident · No injuriesData collectionFinal reportSchempp Hirth Ventus 2A · Wurtsboro, NYThe pilot's failure to properly secure the glider’s canopy before flight, which resulted in it opening in flight and the pilot's inability to maintain an appropriate final approach path and altitude, which resulted in impact with a shipping container.NTSB ERA19LA231Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA46 · Poughkeepsie, NYA total loss of engine power due to fuel exhaustion as the result of a higher-than-expected fuel quantity reduction. Contributing was the pilot’s continued flight away from his selected precautionary landing site after identification of a fuel emergency,…NTSB GAA19CA380Accident · No injuriesData collectionFinal reportHoward Steven C Super · Norwich, NYThe pilot's improper landing flare, which resulted in a hard landing.NTSB GAA19CA405Accident · No injuriesData collectionFinal reportEurocopter EC135 · Cobleskill, NYThe pilot's failure to maintain situational awareness during takeoff from a confined area, which resulted in the helicopter rotors striking tree branches.NTSB ERA19FA196Accident · 1 fatalClass 3 · FieldFinal reportTrella T-21 · Endicott, NYA partial loss of engine power for reasons that could not be determined, and the pilot's subsequent exceedance of the airplane's critical angle of attack during an attempted return to the runway, which resulted in an aerodynamic stall/spin at an altitude that…NTSB ERA19FA191Accident · 1 fatalClass 3 · FieldFinal reportAgusta A109 · New York, NYThe non-instrument-rated pilot’s decision to initiate the flight into marginal visual flight rules and instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.NTSB ERA19FA189Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Southold, NYA total loss of engine power due to a main bearing shift and the pilot’s subsequent failure to maintain a proper glide path to the selected forced landing site. Contributing to the accident was the pilot’s decision to operate the airplane with known…NTSB ERA19LA171Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · New York, NYThe pilot's failure to compensate for adverse wind on final approach, which resulted in a loss of tail rotor effectiveness and aircraft control.NTSB GAA19CA293Accident · No injuriesData collectionFinal reportPiper PA 20 · Canandaigua, NYThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB ERA19LA150Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · New York, NYThe pilot's decision to initiate a flight into low instrument flight rules conditions, which resulted in six missed approaches at two airports and a total loss of engine power due to fuel exhaustion. Contributing to the accident was the external pressure the…NTSB ERA19LA151Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Fulton, NYA total loss of engine power due to carburetor icing. Contributing was the pilot’s failure to leave the carburetor heat on fully after his initial application of carburetor heat.NTSB DCA19LA134Accident · No injuriesClass 3 · LimitedFinal reportAirbus A321 · New York, NYThe captain’s excessive left rudder pedal input during the takeoff ground roll, which caused a large heading deviation and a left roll upon rotation that resulted in the left wingtip striking the ground.NTSB ERA19LA145Accident · Minor injuriesClass 3 · LimitedFinal reportBell 222 · Montgomery, NYA partial loss of engine power, as reported by the pilot, during takeoff for reasons that could not be determined based on available information.