NTSB investigations, NY
51 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 3 |
| 1985 | 2 |
| 1986 | 6 |
| 1987 | 5 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 4 |
| 1999 | 1 |
| 2000 | 2 |
| 2003 | 4 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 1 |
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\" = 310)
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" = 310) 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 NYC07CA115Accident · No injuriesData collectionFinal reportAeronca 7AC · Lagrangeville, NYThe pilot's failure to identify a partially buried rock in the landing surface of an unimproved grass runway, which resulted in an inadvertent collision during the landing roll.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 NYC06LA042Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Dunkirk, NYThe Piper Malibu pilot's failure to use the correct radio frequency for traffic advisories, and his selection of the wrong, inactive runway, which resulted in an on-ground collision with another airplane while landing.NTSB NYC06LA011Accident · No injuriesLimited investigationFinal reportBeech 1900D · Ogdensburg, NYA collision with a coyote during the takeoff roll, which resulted in a nosegear collapse and subsequent impact with the runway. A factor was the nighttime condition.NTSB NYC05LA123Accident · No injuriesLimited investigationFinal reportCessna 172P · Islip, NYThe pilot's failure to maintain clearance from a parked vehicle while taxiing.NTSB NYC03LA208Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135 · Flushing, NYThe inadequate visual lookout by the driver of a ground vehicle, and by ground support personnel, which resulted in a subsequent collision between the airplane and ground vehicle. A factor related to the accident was the failure of the pilot-in-command and…NTSB NYC03LA145Accident · No injuriesLimited investigationFinal reportMooney M20J · De Lancey, NYThe pilot's delayed decision to perform an aborted takeoff, which did not allow for sufficient room to stop. A factor was the grass runway.NTSB IAD03LA047Accident · No injuriesLimited investigationFinal reportCessna 170B · Randolph, NYThe pilot's failure to attain/maintain proper runway alignment. A factor in the accident was the sun glare.NTSB NYC03FA039Accident · Serious injuriesField investigationFinal reportBoeing 757-251 · Flushing, NYMaintenance personnel failure to maintain aircraft control as a result of excessive throttle input.NTSB NYC01FA062Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-51 · Jamaica, NYThe low cycle fatigue fracturing of the approach lighting cover securing bolts.NTSB NYC00LA267Accident · No injuriesLimited investigationFinal reportBoeing 737-49R · Flushing, NYThe tug operator's inadequate visual lookout. A factor in this accident was the night light condition.NTSB NYC00LA040Accident · No injuriesLimited investigationFinal reportBoeing 727-232 · Flushing, NYwas the use of a defective tow bar, due to the lack of an adequate inspection by contract personnel, the airlines lack of an adequate preventative maintenance program for the tow bars, and the lack of oversight by the airline on the contract personnel who…NTSB NYC99LA029Accident · Minor injuriesLimited investigationFinal reportBoeing 747-400 · Jamaica, NYThe first officer misjudged the clearance between the right wing and the crane. Factors included the subcontractor's unauthorized placement of the crane in the taxiway safety area and insufficient oversight of the subcontractor's operations.NTSB NYC99LA030Accident · No injuriesLimited investigationFinal reportKing Kitfox IV · Gasport, NYA collision with a deer while landing.NTSB NYC98LA064Accident · No injuriesLimited investigationFinal reportCessna 182 · East Moriches, NYthe pilot's improper planning/decision, and failure to attain rotation the airplane for lift-off, which led to an aborted takeoff and collision with a fence. The proximity of the fence was a related factor.NTSB IAD98LA023Accident · No injuriesLimited investigationFinal reportBeech 1900D · Saranac Lake, NYThe inadequate snow removal from the runway by airport personnel which left a snow bank extending onto the runway.NTSB NYC97FA062Accident · No injuriesField investigationFinal reportGrumman American G-1159 · Flushing, NYthe tower controller's inadequate service by clearing the airplane to land on the same runway, where he had previously cleared a maintenance vehicle to perform maintenance to the runway centerline lights. Factors related to the accident were: darkness,…NTSB NYC96LA144Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Pleasant Valley, NYfailure of the pilot to maintain obstacle clearance from trees during a precautionary landing. His becoming lost was a related factor.NTSB NYC96LA031Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Lacona, NYthe pilot's inadequate preflight/planning, and his failure to remain clear of obstacles, including a tree trunk.NTSB NYC94LA184Accident · Serious injuriesLimited investigationFinal reportCessna 180B · East Moriches, NYThe failure of the pedestrian to stay clear of the active runway. A factor was night conditions.NTSB BFO94LA064Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Poughkeepsie, NYThe student pilot's failure to maintain control of the airplane immediately after engine start, and his delay in reducing power and applying the brakes.NTSB NYC94LA055Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · South Bethlehem, NYThe failure of the pilot to maintain proper alignment with the runway and the inadequate snow removal.NTSB NYC93FA137Accident · No injuriesField investigationFinal reportBoeing 747-368 · Jamaica, NYMissjudged clearance by the captain of the B-747, hz-ais, as he attempted to maneuver around the ATR-42, N242AT. A factor related to the accident was the diverted attention of the captain of the B-747.NTSB NYC93LA040Accident · 1 fatalLimited investigationFinal reportBoeing 737-300LR · Flushing, NYA lack of adequate clearance between the walker and tug which resulted in the walker being struck by the tug when he fell for unknown reason(s). A factor related to the accident was the lack of a policy to stay clear of the tug, towbar, and nosewheel of the…NTSB NYC90LA148Accident · No injuriesLimited investigationFinal reportCessna 150 · Montour Falls, NYThe pilot in command's decision to attempt takeoff at night from an inimproved field which resulted in collision with a vehicle.NTSB NYC90LA132Accident · No injuriesLimited investigationFinal reportBoeing 747-230 · Jamaica, NYThe Boeing 747 captain misjudged clearance between his aircraft and the fokker f.28. A factor related to the accident was: self-induced pressure of the Boeing 747 captain.NTSB NYC89FA111Accident · Minor injuriesField investigationFinal reportMitsubishi MU-2B-35 · Syracuse, NYFailure of the crew of brockway flight 993 to see-and-avoid the other aircraft due to the first officer's inadequate visual lookout & the captain's inadequate supervision. Factors related to the accident were: the weather condition, and the ground…NTSB NYC89FA106Accident · No injuriesField investigationFinal reportSikorsky S-76A · Manhattan, NYThe pilot of the other helicopter misjudged clearance between his and the other helicopter. Factors related to the accident were: inadequate layout (markings) of the heliport parking area, insufficient standard/requirement for numerical indication of maximum…NTSB NYC88LA205Accident · Minor injuriesLimited investigationFinal reportCocks Starduster SA-300 · Stormville, NYThe pilot of a starduster SA-300 was on a local flight when he landed at an uncontrolled airport which had been notamed closed and had an x on the approach end of the runway. The pilot said a vehicle obscured the approach end during the approach and then left…NTSB NYC88LA097Accident · No injuriesLimited investigationFinal reportBeech 1900 · Albany, NYThe Beech 1900 was taxiing out at night under the control of a ground taxi director and two wing walkers when its tail made contact with the tail of parked and unoccupied B-737. Both pilots said they did not see a stop signal from the taxi director. The wing…NTSB NYC88LA060Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Flushing, NYAs the plts were taxiing at dusk to takeoff, the acft was struck by a food svc van at a vehicle svc road. The acdnt occurred as rain was falling & the ramp area was wet with standing water. The van driver said he had just maneuvered his vehicle to the left to…NTSB NYC87MA236Accident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-8-63 · Newburgh, NYThe wx was deteriorating as airborne express flt 124 & rosenbalm flt 074 were on successive arrivals for an ILS rwy 9 apch. Flt 124 was clrd for the apch & lndd. After lndg, the LCL ctlr (l/c) instructed flt 124 to back taxi on the rwy & rprt when clr of the…NTSB NYC87LA229Accident · No injuriesLimited investigationFinal reportLake LA-4 · Lake George, NYWhile taking off from a Lake, the amphibious aircraft struck an object. The plane settled back into the water breaking the windshield on the passenger's side. The cockpit began filling with water and the acft sank in about 45 feet of water.NTSB NYC87LA231Accident · No injuriesLimited investigationFinal reportCessna 172 · Islip, NYAfter landing on an instructional flight, Cessna 172, N9425D, experienced brake failure due to a broken hydraulic fluid line. N9425D rolled into another Cessna. Both aircraft received sustantial damage.NTSB NYC87IA106Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Jamaica, NYAs EA32 taxied from a stopped position on taxiway na between the outer and inner to the eastern ramp, a U.S. Postal tractor with an empty box traveling NE failed to yield to the aircraft and they collided on the service road and taxiway na.NTSB NYC87DFA03Accident · No injuriesFinal reportCessna 150M · Guilderland Cnt, NYThe student pilot, on a solo 30 NM x-country training flt, became lost while using VOR navigation. A precautionary landing was made in an industrial park. The acft collided with a stack of slate during the landing roll.NTSB NYC87LA037Accident · No injuriesLimited investigationFinal reportPiper J3 · Montgomery, NYWhile taxiing in the middle of the taxiway the propeller of N58380 contacted the wing of N7416T. N58380 then rotated and it's wing contacted the wing of N7416T. N7416T was stopped alongside the taxiway when the accident occurred.NTSB NYC87DFA01Accident · No injuriesFinal reportCessna 150M · Oriskany, NYThe student & instructor plt (CFI) were making a night, touch-&-go landing, when the acft struck a deer on the rwy. They were unable to see the deer in time to avoid a collision.NTSB NYC87FA020Accident · 2 fatalField investigationFinal reportCessna 182E · Fishers Island, NYA Cessna 182 taking off on rwy 25 collided with a Piper PA-28-181 which was landing on rwy 12. The collision occured in the intersection of the two runways. The two occupants of the Cessna were seriously injured and the two occupants of the Piper were fatally…NTSB NYC86LA074Accident · No injuriesLimited investigationFinal reportUniversal Aircraft Industries GC-1B · Farmingdale, NYA Piper acft was standing in the runup area that is adjacent to taxiway A5. The plt of the globe acft taxied into the runup area and because the sun was in his eyes and the Piper was in his blind spot he ran into the Piper.NTSB NYC86LA070Accident · No injuriesLimited investigationFinal reportPiper PA-42-720 · Rochester, NYPiper aircraft collided with a parked Cessna aircraft while maneuvering into a parking space at Rochester-monroe airport after landing. The ramp was reported to be ice covered and sanded.NTSB NYC86IA019Incident · No injuriesIncident investigationFinal reportFokker F-28 · Flushing, NYThe F-28 acft was holding on taxiway bb. The B-767 acft was taxiing behind the F-28 on taxiway e which is perpendicular to taxiway bb. The r wing of the B-767 struck the rudder of the F-28.NTSB NYC85FFA03Accident · Minor injuriesFinal reportCessna 172L · Parishville, NYThe pilot was attempting a landing in a Cessna 172L on a 1250 ft grass runway. He misjudged his touch down point and landed approximately 1/2 way down the runway. The aircraft was unable to stop on the remaining runway and ran off the departure end of the…NTSB NYC83IA182Incident · No injuriesIncident investigationFinal reportCessna 172XP · Mechanicville, NYAfter starting the engine and taxiing forward the pilot stated he pushed the trottle by mistake and the acft moved rapidy forward and struck a parked acft.NTSB NYC83FA074Accident · Minor injuriesField investigationFinal reportSwearingen SA226TC · Albany, NYThe plt reported that during arrival, he followed the ILS glide slope to touchdown about 1000 ft down the rwy. He reported the landing was smooth, and when the acft was aprx 100 ft from the intersection of rwys 1/19 and 10/28, he saw a ridge of snow and ice…NTSB NYC83FHJ01Accident · Minor injuriesFinal reportHarrison Volmer VJ-22 Amphibian · Schinnecock Bay, NYWhile gaining speed on step to make water takeoff the hull of the aircraft collided with something not seen in the waterand began to sink. The aircraft filled with water and sank until it rested on the bottom with only the prop tip showing the weather was VFR…NTSB NYC83LA044Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Little Ferry, NYStudent pilot step-taxiing from landing collided with a submerged object in the river and damaged the float. The river was at low tide.NTSB NYC82DA192Accident · No injuriesFinal reportde Havilland DH-114 · Sidney, NYWhile taxiing on the ramp the plt experienced a brake failure & the acft collided with several parked acft. The brake system is air operated & a small threaded rod with a small locking screw disconnected from the brake valve.NTSB NYC82DA164Accident · Minor injuriesFinal reportCessna 172N · Jamaica, NYAn airport operations agent, in a port authority automobile monitored ground control conversation with the pilot and offered to assist N9426E in locating the active runway. When approaching the lost aircraft's position the vehicle driver experienced sun glare…NTSB NYC82FHJ04Accident · Minor injuriesFinal reportBell 206L · New York, NYThe accident involved two Bell 206L helicopters that were parked beside one another, but headed in opposite directions. When the pilot of N49575 arrived, the other helicopter, N16696, was operating with the rotors at about 60% RPM (flight idle) while…