NTSB investigations, NY
106 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 5 |
| 1984 | 8 |
| 1985 | 6 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 4 |
| 1989 | 5 |
| 1990 | 4 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 4 |
| 1994 | 5 |
| 1995 | 4 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 5 |
| 2001 | 6 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 5 |
| 2005 | 3 |
| 2006 | 3 |
| 2007 | 4 |
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 c.\"eventStateOrRegion\" = 'NY' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220)
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 c."eventStateOrRegion" = 'NY' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220) 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 NYC08FA041Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · New Windsor, NYThe pilot's failure to maintain the proper glidepath during an instrument-landing-system approach in fog. Contributing to the accident were pilot fatigue and air traffic control's failure to issue a minimum safe altitude warning.NTSB NYC07CA179Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Montauk, NYThe pilot's delayed decision to abort the landing, which resulted in an impact with a tree.NTSB MIA07CA125Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26E · Big Flats, NYThe pilot's misjudged distance/altitude during approach resulting in collision with trees and the ground.NTSB NYC07CA067Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Millbrook, NYThe pilot's failure to maintain a proper glidepath to the runway.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 NYC06CA009Accident · No injuriesData collectionFinal reportSikorsky S-76B · New York City, NYThe pilot flying's failure to maintain adequate aft hover clearance from a fence, and the pilot in command's delayed remedial action. A factor was the dark night lighting conditions.NTSB NYC06CA006Accident · Minor injuriesData collectionFinal reportMooney M20K · Ithaca, NYThe pilot's failure to comply with the published instrument approach procedure, which resulted in an in-flight collision with trees.NTSB NYC05FA099Accident · Serious injuriesField investigationFinal reportBell 206L · New York, NYThe pilot's inadequate preflight planning, which resulted in an attempted takeoff with an overweight helicopter, and subsequent impact with a pier and water. Factors were a high ambient temperature and unfavorable winds.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 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 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 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 NYC03FA190Accident · No injuriesField investigationFinal reportFokker F.28 Mk 0100 · Flushing, NYAn in-flight collision with birds.NTSB NYC03LA142Accident · No injuriesLimited investigationFinal reportBeech 24 · Rome, NYThe pilot's failure to maintain directional control during a go-around which resulted in the airplane impacting trees. A factor in the accident was the shifting wind.NTSB NYC03LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Aurora, NYThe pilot's failure to obtain the proper climb rate.NTSB NYC03LA004Accident · No injuriesLimited investigationFinal reportde Havilland DHC-8-102 · Albany, NYAn in-flight collision with birds. A factor was the night conditions.NTSB NYC02FA197Accident · 1 fatalField investigationFinal reportCessna 310L · Virgil, NYThe pilot's decision to continue the flight into IMC after canceling his IFR clearance, and his failure to maintain terrain clearance while maneuvering. Factors in the accident were rain, low ceilings, and night.NTSB NYC02FA173Accident · 1 fatalField investigationFinal reportPiper PA-22-108 · Mayville, NYThe student pilot's failure to maintain adequate altitude during the landing approach and the private pilot's inadequate supervision, which resulted in a collision with a marked utility pole. A factor in this accident was the student pilot's lack of…NTSB NYC02LA083Accident · No injuriesLimited investigationFinal reportBell 206-L3 · New York, NYThe pilot's improper flare while landing, which resulted in a collision with a concrete curb.NTSB DCA01MA063Accident · 65 fatalMajor investigationFinal reportBoeing 767-200ER · New York City, NYThe Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided…NTSB DCA01MA060Accident · 92 fatalMajor investigationFinal reportBoeing 767-200ER · New York City, NYThe Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided…NTSB NYC01FA214Accident · 2 fatalField investigationFinal reportLearjet 25 · Ithaca, NYThe pilot's failure to maintain a proper climb rate while taking off at night, which was a result of spatial disorientation. Factors in the accident were the low visibility and cloud conditions, and the dark night.NTSB IAD01FA086Accident · 2 fatalField investigationFinal reportAeronca S-65-CA · Esperance, NYThe pilot's inadequate decision and his failure to maintain obstacle clearance. Contributing factors are a transmission wire and the pilot's intentional low pass.NTSB IAD01LA087Accident · Serious injuriesLimited investigationFinal reportCharles Lancair 320 · Charleston, NYThe pilot's failure to maintain control of the airplane while maneuvering, which resulted in a collision with trees.NTSB NYC01LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Schuyler, NYThe pilot's delayed go-around, which resulted in an in-flight collision with trees. A factor in this accident was the crosswind conditions.NTSB IAD00LA084Accident · No injuriesLimited investigationFinal reportCessna 150G · Conesus, NYthe pilot's inadequate preflight performance planning.NTSB IAD00LA074Accident · Serious injuriesLimited investigationFinal reportUnknown Bensen Gyrocopter · Macedon, NYpilot's failure to maintain control of the gyrocopter. Factors in the accident were the pilot's lack of total flight experience and familiarity with the gyrocopter.NTSB NYC00LA224Accident · Minor injuriesLimited investigationFinal reportCessna 150 · East Moriches, NYThe pilot's failure to maintain a climb during climbout. A factor in the accident was the pilot's failure to reconfigure the flaps for the aborted landing.NTSB NYC00LA197Accident · Serious injuriesLimited investigationFinal reportFairchild M-62C · Carthage, NYthe pilot's improper decision to depart with obstacles ahead which exceeded the climb capability of the airplane. Factors were the grass runway, and trees at the departure end of the runway.NTSB IAD00LA051Accident · No injuriesLimited investigationFinal reportSlingsby 41-2 · Dansville, NYThe pilot's failure to retract the speed brakes which resulted in not obtaining the proper touch down point. A factor to the accident was the pilot's lack of experience in the make and model glider.NTSB IAD00LA013Accident · Serious injuriesLimited investigationFinal reportRogers RAF 2000 · Franklin, NYwas the pilot's failure to abort the takeoff due to inadequate rotor rpm.NTSB NYC99GA234Accident · Serious injuriesFinal reportBell 206L-1 · Randolph, NYThe pilot's failure to maintain visual separation from the wires. A factor was sunglare.NTSB IAD99LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Granville, NYThe pilot's not maintaining a proper glidepath during the visual approach to the runway.NTSB NYC99FA098Accident · 1 fatalField investigationFinal reportCessna 150G · Watertown, NYThe pilot-in-command misjudged altitude, which resulted in an in-flight collision with utility wires at the approach end of the airstrip. A factor was the pilot's failure to wear his corrective lenses.NTSB NYC99LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Mattituck, NYThe pilot's failure to maintain the airplane's directional control during a go-around.NTSB IAD98LA096Accident · No injuriesLimited investigationFinal reportCessna 172G · Williamson, NYDirectional control not maintained by one of the pilot's on board the airplane.NTSB NYC98LA147Accident · No injuriesLimited investigationFinal reportCessna 140 · Gansevoort, NYThe pilot's decision to continue the landing attempt too far down the runway.NTSB NYC98LA110Accident · 1 fatalLimited investigationFinal reportCessna 337B · Montgomery, NYthe pilot's improper decision to initiate a takeoff with the rear engine inoperative, which resulted in an airplane that could not climb sufficiently to clear obstacles (trees).NTSB IAD97LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Gardiner, NYThe pilot's failure to initiate a go-around. A related factor is the pilot's misjudgment of speed and altitude.NTSB IAD97LA083Accident · 1 fatalLimited investigationFinal reportErcoupe G · Dalton, NYthe pilot's delay in aborting the landing after allowing the airplane to touchdown long. His failure to attain a proper touchdown point was a related factor.NTSB NYC97LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Walton, NYThe pilot's improper inflight decision to establish an approach without confirming the landing area, and his delayed go-around, which resulted in the inflight collision with trees.NTSB IAD97LA031Accident · 2 fatalLimited investigationFinal reportMooney M20F · Wellsville, NYDescent below the published minimum descent altitude followed by collision with the surrounding terrain.NTSB NYC97MA005Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-88 · Flushing, NYThe Safety Board's full report is available at www.ntsb.gov/publictn/publictn.htm. NTSB Report AAR-97/03. the inability of the captain, because of his use of monovision contact lenses, to overcome his misperception of the airplane's position relative to the…NTSB NYC96LA102Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Olean, NYthe pilot's improper IFR procedure by not maintaining the minimum descent altitude (MDA) during the ILS localizer approach. Factors relating to the accident were: low ceiling, fog, and weather below minimums for landing.NTSB NYC96LA072Accident · No injuriesLimited investigationFinal reportCessna 182L · Weedsport, NYthe pilot's decision to takeoff on a closed snow-covered runway, and his inadequate compensation for a crosswind. A factor in the accident was the pilot's lack of recent flying experience.NTSB NYC96LA006Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Honeoye Falls, NYthe pilot's failure to establish a climb in that he failed to raise the flaps and failed to assure full power was applied during the go-around.NTSB NYC95LA225Accident · 2 fatalLimited investigationFinal reportSnyded Pitts S1E · Somers, NYThe pilot's inadequate visual lookout, which resulted his failure to see-and-avoid the power line.