NTSB investigations, 2014, NY
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 2014
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") = 2014 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 ERA15LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA 22-150 · Tompkins, NYA total loss of engine power for reasons that could not be determined during postaccident examinations and testing.NTSB DCA15FA004Accident · No injuriesField investigationFinal reportEmbraer EMB 145LR · Jamaica, NYThe A340 captain's failure to maintain adequate clearance between his wing and the tail of the EMB-145.NTSB ERA14FA459Accident · 2 fatalField investigationFinal reportCessna 172M · Lancaster, NYThe other airplane pilot’s failure to maintain an adequate visual lookout for known traffic in the fly-in event traffic pattern, which resulted in a midair collision.NTSB ERA14CA453Accident · Minor injuriesData collectionFinal reportSchleicher ASK 21 · Wurtsboro, NYA loss of lift during the landing approach, which resulted in impact with terrain.NTSB ERA14CA449Accident · No injuriesData collectionFinal reportCessna 182A · Bethany Center, NYThe pilot's failure to maintain a directional control of the airplane during gusting wind conditions.NTSB ERA14FA428Accident · 2 fatalField investigationFinal reportCessna 172 · Selkirk, NYA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA14CA426Accident · Serious injuriesData collectionFinal reportSchleicher ASW 19B · Avoca, NYThe pilot's decision to attempt a return to his departure airport which resulted in the glider's encounter with atmospheric conditions where the lift was not sufficient to maintain flight and an off-airport landing.NTSB ERA14LA423Accident · 1 fatalLimited investigationFinal reportMcmurray David C Searey · Webb, NYThe pilot’s failure to maintain control of the amphibious airplane while practicing touch-and-go takeoffs and landings on a reservoir.NTSB ERA14LA418Accident · Serious injuriesLimited investigationFinal reportLorenz Stephen Kitfox Series 5 · Greene, NYThe pilot’s failure to attain adequate airspeed during the initial climb, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s lack of experience in the…NTSB ERA14LA390Accident · No injuriesLimited investigationFinal reportCessna R182 · Farmingdale, NYThe failure of the aluminum nipple fuel supply line fitting, which resulted in an engine compartment fire.NTSB ERA14LA388Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Buffalo, NYA total loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine test run revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA14CA379Accident · No injuriesData collectionFinal reportAviat Pitts S2B · Lakeville, NYThe pilot's decision to favor the right side of the relatively narrow turf runway while landing, resulting in inadvertent contact with tall grass and a berm.NTSB ERA14FA372Accident · 2 fatalField investigationFinal reportCessna 182F · Gansevoort, NYThe pilot’s failure to maintain directional control during initial climb following a banner pick-up, resulting in collision with a tree.NTSB ERA14CA366Accident · Minor injuriesData collectionFinal reportCessna 150M · Waterloo, NYThe pilot's failure to maintain adequate clearance from obstructions while on approach to the runway.NTSB ERA14FA345Accident · 3 fatalField investigationFinal reportMooney M20F · North Elba, NYThe pilot’s failure to maintain adequate airspeed for the airplane’s configuration and flight profile, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall/spin.NTSB ERA14LA330Accident · 1 fatalLimited investigationFinal reportZubair S Khan Raven · Mattituck, NYThe pilot's failure to ensure that the airplane was loaded within its calculated center of gravity limits, which resulted in longitudinal instability and a subsequent unrecoverable stall.NTSB ERA14LA329Accident · 1 fatalLimited investigationFinal reportFlight Design CT-SW 2006 · Gasport, NYThe pilot's failure to maintain adequate airspeed following a left turn during takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB ERA14FA327Accident · 1 fatalField investigationFinal reportCessna 140 · Parma, NYThe pilot's decision to land with a quartering tailwind and his failure to maintain directional control during the landing roll. Contributing to the severity of the pilot's injuries was the failure of the aluminum center safety belt bracket.NTSB ERA14FA292Accident · 1 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · East Patchogue, NYThe noninstrument-rated pilot's encounter with instrument meteorological conditions and his decision to continue visual flight rules flight in instrument conditions, which resulted in a loss of control due to spatial disorientation.NTSB ERA14CA310Accident · No injuriesData collectionFinal reportJackson Fred M Clipper · Altamont, NYThe pilot's failure to apply carburetor heat prior to descending in atmospheric conditions conducive to serious icing at all power settings, which resulted in a total loss of engine power.NTSB ERA14FA288Accident · 1 fatalField investigationFinal reportPiper PA-46-500TP · White Plains, NYThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation (somatogravic illusion). Contributing to the accident was the pilot's self-induced pressure to depart and his decision to depart in low-ceiling and…NTSB ERA14CA274Accident · No injuriesData collectionFinal reportSchweizer SGS 1 34 · Middletown, NYThe pilot's failure to maintain directional control during a bounced landing.NTSB ERA14LA261Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Cooperstown, NYThe pilot’s delayed use of carburetor heat during the approach to landing, which resulted in the formation of carburetor ice, a partial loss of engine power, and the airplane’s subsequent inability to sustain flight.NTSB ERA14CA238Accident · Serious injuriesData collectionFinal reportNorth American AT6 - C · Roxbury, NYThe pilot's failure to maintain adequate obstacle clearance, which resulted in the inflight collision with a power line.NTSB ERA14LA223Accident · No injuriesLimited investigationFinal reportMesserschmitt-Bolkow-Blohm BK 117 · Hamburg, NYWear in the left cabin door assembly parts, which resulted in the door partially opening in flight, dislodging from the lower door track assembly, and then separating from the helicopter.NTSB ERA14LA181Accident · No injuriesLimited investigationFinal reportVans RV-12 · Bayport, NYThe failure of both pilots to see and avoid each other, which resulted in a collision.NTSB ENG14IA011Incident · No injuriesIncident investigationFinal reportRaytheon 400A · Rochester, NYThe probable cause of the uncontained No. 2 engine failure on the Raytheon Beechjet 400A was a herring gull birdstrike that resulted in fan blade contact with the inlet case and rub induced excitation of a previously unidentified natural frequency (resonance)…NTSB ERA14LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bronx, NYThe total loss of engine power due to fuel starvation for reasons that could not be determined during postaccident engine examination or testing.