NTSB investigations, NY
25 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 5 |
| 1984 | 2 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 2 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 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\" = 390)
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" = 390) 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 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 IAD05LA109Accident · No injuriesLimited investigationFinal reportBeech BE-35-C33A · East Hampton, NYThe pilot's failure to attain the proper touchdown point during landing, which resulted in the airplane touching down short of the landing surface.NTSB NYC03LA050Accident · No injuriesLimited investigationFinal reportCessna 182R · Warwick, NYThe pilot's inadequate compensation for winds, and his failure to maintain the proper descent rate. A factor in the accident was the gusty wind conditions.NTSB NYC96FA024Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Ashville, NYthe pilot's misjudgment of altitude and distance to the runway during an approach to land. Factors relating to the accident were: the night and adverse weather conditions.NTSB NYC95LA057Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Warwick, NYthe pilot allowed the airplane to get too low on the approach, during a simulated engine out landing, which resulted in impacting high bushes, and landing short of the runway.NTSB NYC95FA001Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Montgomery, NYwas the failure of the pilot to maintain adequate terrain clearance on final approach which resulted in a tree strike. Factors were the night conditions and the failure of the pilot to use the recommended runway.NTSB NYC94LA173Accident · No injuriesLimited investigationFinal reportSchleicher ASW15B · Dansville, NYThe pilot allowed the speed of the glider to get to low on final approach which resulted in a rapid descent, subsequent undershoot of the runway, and impact with a tree. A factor in this accident was a downdraft condition.NTSB NYC94LA087Accident · No injuriesLimited investigationFinal reportLutz Acro Sport II · Hornell, NYThe pilot's failure to maintain a proper glidepath. A factor in this accident was the pilot's lack of total experience in this type of airplane.NTSB BFO93LA095Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-233A · Johnson City, NYImproper planning/decision by the flight crew. Factors related to the accident were: the downdraft on final approach, the terrain conditions (cliff & obstructions) near the approach end of the runway, and the lack of relative experience for each of the pilots.NTSB BFO92LA075Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Johnstown, NYThe pilot misjudged altitude and distance which resulted in a landing undershood. Contributing to the accident was night conditions.NTSB NYC89LA152Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-26 · Elmira, NYAn inadvertent encounter with a downdraft.NTSB DCA88IA060Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · Jamaica, NYNone submittedNTSB NYC87FA085Accident · No injuriesField investigationFinal reportBeech 99 · Oneonta, NYThe flight was uneventful until its arrival at Oneonta municipal airport. The aircraft landed 10 feet short of runway 24IN one foot of snow. The left main landing gear collapsed, the propeller struck the runway and the aircraft veered off the left side of the…NTSB NYC87LA040Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Stormville, NYThe plt reported that during the landing apch, aprx 1/2 mile from touchdown, the acft descended below the visual glidepath. Recovery was attempted with the application of power, however, the acft mushed into a field short of the rwy. The acft rolled, struck a…NTSB NYC86FA111Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Spring Valley, NYThe pax stated that he & the plt were at a bar where they had about three beers rpior to this flight. During the flight the pilot did several stalls and some aerobatic maneuvers. The pax was unnerved and told the plt that he wanted to return to the arpt.…NTSB NYC84LA286Accident · No injuriesLimited investigationFinal reportCessna 172 · Islip, NYCommunications with twr indicate plt intended to touch down as close to the end of the runway as possible. Acft touched down 20 yds short of hard surface in gravel. Rwy NOTAM stated 18 in depression at threshhold edge.NTSB NYC84LA099Accident · No injuriesLimited investigationFinal reportCessna 402B · Penn Yan, NYThe acft entered a high sink rate during the final approach and collided with the ground. The plt managed to get the acft onto the rwy but the right main landing gear collapsed during the landing roll. A culvert is located near the approach end of rwy 28.NTSB NYC84LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Syracuse, NYThe acft collided with approach lights during a landing approach. The plt executed a go-around and landed without further incident. The acft was damaged in the collision. An accident report was not filed by the plt.NTSB NYC83LA237Accident · No injuriesLimited investigationFinal reportCessna 150H · Boonville, NYDuring an approach, the plt lowered 40 deg of flaps for a spot landing. As he approached the rwy, he banked left & added power to avoid hitting a tree. However, contact was made & he initiated a go-around. As the acft clipped some trees to the left, the nose…NTSB NYC83LA196Accident · No injuriesLimited investigationFinal reportCessna 182 · Northville, NYThe acft landed short of the rwy during a practice short field landing. There were 4 persons aboard the acft. None were injured. During the landing the wings, propeller, engine mounts and landing gear were damaged.NTSB NYC83LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Millbrook, NYThe plt reported that on final apch, the acft began an unexpected descent below the intended glide path. Reportedly, full power was applied to reduce the dwscent, but the acft touched down aprx 20 ft short of the rwy on an upgrade. The acft bounced in the…NTSB NYC83LA151Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Montauk, NYThe acft landed short of the runway and collided with an embankment breaking the nose gear. The pilot stated the final approach was flown low and about 70 mph. At about 10-20 ft above the ground the acft started to sink and the pilotsaid he applied back…NTSB NYC83LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Watertown, NYThe pilot reported that he made two touch-and-go landings at the Watertown, new york intl airport. He then returned to his private airstrip in the local area. While executing a night approach to the private strip he got too low. The pilot stated that he added…NTSB NYC83LA011Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33AK · Mecklenburg, NYDuring approach the pilot misjudged the wind velocity and failed to allow for strong downdrafts. The glider lost altitude 4-500 feet short of the field over a wooden area and came to rest in a nosed over position in the trees.NTSB NYC82DFJ19Accident · No injuriesFinal reportSchweizer 2-33A · Elmira, NYThe plt stated he was too high on base & started slipping to lose excessive altitude. He lost too much altitude & speed,striking the ground short of the rwy.