NTSB investigations, 2006, 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\") = 2006
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") = 2006 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 NYC07FA047Accident · 1 fatalField investigationFinal reportCessna 310Q · Montgomery, NYImproper maintenance performed on the airplane by maintenance personnel, and the failure of the mechanic with an inspection authorization (IA) to verify the maintenance work performed, which resulted in a reverse elevator trim system, and subsequent loss of…NTSB NYC07CA049Accident · Minor injuriesData collectionFinal reportCessna 172C · Middletown, NYThe pilot misjudging distance/altitude during the turn from base to final, which resulted in an undershoot and subsequent collision with trees. A factor was the haze.NTSB NYC07CA028Accident · Minor injuriesData collectionFinal reportPiper PA-11 · Van Hornsville, NYThe pilot's failure to maintain clearance from trees during landing.NTSB NYC07CA024Accident · No injuriesData collectionFinal reportUtva 66 V-51 · Hilton, NYThe pilot's inadequate visual lookout, which resulted in a collision with a dock during takeoff.NTSB DCA07MA003Accident · 2 fatalClass 1 · MajorFinal reportCirrus Design SR-20 · Manhattan, NYC, NYThe pilots' inadequate planning, judgment, and airmanship in the performance of a 180º turn maneuver inside of a limited turning space.NTSB NYC06LA222Accident · No injuriesLimited investigationFinal reportAirbus Industrie A319-112 · New York, NYThe Airbus first officer's misjudged clearance from the EMB-170. Also causal was the ground controller's decision to issue a taxi clearance for the Airbus to pass behind the EMB-170. A factor to the accident was the light condition.NTSB NYC06CA217Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · White Lake, NYThe flight instructor's failure to ensure the landing gear was retracted prior to attempting a water landing.NTSB NYC06FA205Accident · 1 fatalField investigationFinal reportScheibe SF-28A · Canandaigua, NYThe private pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and impact with trees. Factors were the FAA inspector's delayed remedial action, and his lack of experience in the make and model motorglider.NTSB NYC06CA189Accident · No injuriesData collectionFinal reportCessna 172P · Poughkeepsie, NYThe student pilot's improper flare and failure to recover from a bounced landing, which resulted in a hard landing.NTSB NYC06CA174Accident · Minor injuriesData collectionFinal reportCessna 210G · Clayton, NYThe pilot's improper fuel tank selection, which resulted in fuel starvation, and subsequent loss of engine power.NTSB NYC06CA119Accident · Serious injuriesData collectionFinal reportCessna 182A · Plattsburgh, NYThe pilot's failure to utilize carburetor heat, which resulted in the formation of carburetor ice and subsequent engine failure. Factors included the carburetor icing conditions and trees in the forced landing area.NTSB NYC06CA164Accident · Serious injuriesData collectionFinal reportBaker, Timithy Falco F8L · Montgomery, NYThe pilot's inadequate pre-flight inspection, which resulted in a loss of engine power due to fuel contamination.NTSB NYC06CA159Accident · No injuriesData collectionFinal reportCessna 172S · White Plains, NYThe pilot's misjudged speed/distance which resulted in an overrun.NTSB NYC06CA148Accident · Serious injuriesData collectionFinal reportTaylorcraft DC-65 · Parma, NYAn uncontrolled descent into trees and terrain after takeoff for undetermined reasons.NTSB NYC06CA172Accident · No injuriesData collectionFinal reportRotorway 162-F · Brookhaven, NYThe student pilot inadvertently allowing the skids to contact the ground resulting in dynamic rollover.NTSB NYC06LA144Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC12-D · Mayville, NYThe flight instructor's improper decision to attempt a simulated engine failure at a low altitude and her failure to maintain clearance from trees and wires, while maneuvering. Also causal was the flight instructor's impairment from prescription medication.NTSB CHI06LA161Accident · No injuriesLimited investigationFinal reportBoeing 737-300 · New York, NYThe foreign object damage to the horizontal stabilizer during taxi as a result of improper airport maintenance by contract maintenance personnel. The aluminum plate was a factor.NTSB NYC06LA136Accident · 1 fatalLimited investigationFinal reportHowe/Wilmer Lancair 360 · Montgomery, NYA loss of control during approach for undetermined reasons.NTSB NYC06LA121Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350BA · Goshen, NYImproper maintenance of the hydraulic pump/coupling, which resulted in a failure of the hydraulic flight control system. Factors included the substandard materials of the hydraulic pump drive shaft and coupling, and the pilot's failure to maintain an adequate…NTSB NYC06LA122Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Mattituck, NYA loss of engine power due to undetermined reasons.NTSB NYC06CA118Accident · Minor injuriesData collectionFinal reportEspinal Velocity Jet 900 · Millbrook, NYThe pilot/owner's inadequate preflight which resulted in a partial loss of engine power due to a clogged fuel vent.NTSB NYC06LA106Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Kings Park, NYLoss of engine power due to the failure of the number 3 connecting rod bearing. A contributing factor was the lack of suitable terrain for the emrgency landing.NTSB NYC06CA068Accident · No injuriesData collectionFinal reportCessna 180J · Essex, NYThe pilot's failure to abort the takeoff in a timely manner. Factors included a partial loss of engine power for undetermined reasons and an undefined go, no-go point.NTSB NYC06LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Yonkers, NYA loss of engine power for undetermined reasons, which resulted in a ditching.