Skip to content

NTSB investigations, NY

78 cases where the first occurrence was “Hard landing”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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" = 200) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 200)
  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" = 200)
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 NYC07CA216Accident · No injuriesData collectionFinal reportPiper PA28-161 · William-Sodus, NYThe pilot's improper flare at touchdown, which resulted in a hard landing.Sep 4, 2007 · N444CF · Substantial damage NTSB NYC07CA185Accident · No injuriesData collectionFinal reportBeech 65-A90 · Wallkill, NYThe pilot's improper flare, which resulted in a hard landing.Jul 27, 2007 · N435A · Substantial damage NTSB ATL07CA093Accident · No injuriesData collectionFinal reportCessna 172S · Batavia, NYThe student pilot's failure to flare the airplane during landing resulting in a hard landing.Jun 15, 2007 · N2228L · Substantial damage 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.Jul 29, 2006 · N97650 · Substantial damage NTSB NYC06CA030Accident · Minor injuriesData collectionFinal reportCessna 208 · Southampton, NYThe flight instructor's improper flare and his inadequate remedial action, which resulted in a hard landing.Nov 15, 2005 · N117SA · Substantial damage NTSB NYC06CA031Accident · No injuriesData collectionFinal reportBeech F33A · Montgomery, NYThe pilot's misjudgment of the landing flare, which resulted in a hard landing short of the runway. Factors included the night lighting conditions, the time-out and reestablishment of the high intensity runway lighting, and the pilot's failure to go around.Nov 12, 2005 · N1813W · Substantial damage NTSB IAD05CA120Accident · No injuriesData collectionFinal reportCessna 172S · White Plains, NYThe pilot's improper recovery from a bounced landing.Aug 6, 2005 · N297ME · Substantial damage NTSB NYC04LA051Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C-1 · Byron, NYThe pilot's improper use of the collective, and failure to maintain main rotor rpm, which resulted in low main rotor rpm and a hard landing.Dec 27, 2003 · N358SS · Substantial damage NTSB NYC04LA017Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Ithaca, NYThe pilot's excessive descent rate during the execution of a high wind landing. A factor was the high winds.Oct 25, 2003 · N3597H · Minor damage NTSB NYC02LA161Accident · No injuriesLimited investigationFinal reportCessna 172RG · Rochester, NYThe pilot's improper flare and recovery from a bounced landing. A factor in the accident was the slow response time of the airspeed indicator.Aug 12, 2002 · N888RG · Substantial damage NTSB IAD02LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Fulton, NYThe pilot's improper flare, which resulted in a misaligned, hard landing.Jul 4, 2002 · N6338F · Substantial damage NTSB NYC01LA204Accident · No injuriesLimited investigationFinal reportRobinson R22 · Islip, NYThe flight instructor's delayed remedial action during a practice autorotation. Factors included the flight instructor's overconfidence in the pilot receiving instruction, and that pilot's improper recovery from a practice autorotation.Aug 5, 2001 · N4066G · Substantial damage NTSB NYC01LA035Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Babylon, NYThe student pilot's inadequate use of the collective, and the instructor pilot's inadequate remedial action.Nov 13, 2000 · N25862 · Substantial damage NTSB NYC01LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Poughkeepsie, NYThe student pilot's improper recovery from a bounced landing.Oct 14, 2000 · N1297F · Substantial damage NTSB NYC00LA188Accident · No injuriesLimited investigationFinal reportCessna 182S · White Plains, NYThe student pilot's failure to recover from a bounced landing and her failure to perform a go-around.Jul 8, 2000 · N729AD · Substantial damage NTSB NYC99LA217Accident · No injuriesLimited investigationFinal reportHughes 269C · Utica, NYThe pilot's failure to maintain control of the helicopter while maneuvering, which resulted in a hard landing. A factor in this accident was the pilot's lack of total experience in helicopters.Sep 1, 1999 · N58397 · Substantial damage NTSB NYC99LA190Accident · Minor injuriesLimited investigationFinal reportRobinson R-22A · Shirley, NYThe pilot's failure to maintain rotor RPM, which resulted in a hard landing.Aug 5, 1999 · N8561K · Substantial damage NTSB NYC99LA177Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-300-600ER · Jamaica, NYimproper use of the flight controls by the captain trainee, and inadequate supervision by the check airman.Jul 15, 1999 · N80057 · Substantial damage NTSB NYC99LA090Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Port Jefferson, NYthe lack of supervision by the flight instructor which resulted in a low rotor condition and subsequent hard landing.Apr 15, 1999 · N151RM · Substantial damage NTSB NYC99LA016Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Oneonta, NYThe pilot's improper flare which resulted in a hard landing. A factor in the accident was the crosswind condition.Oct 25, 1998 · N55697 · Substantial damage NTSB NYC99LA017Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103-TWINA · Saratoga Spring, NYThe pilot's failure to maintain control of the glider while landing.Oct 24, 1998 · N4446T · Substantial damage NTSB NYC97LA188Accident · No injuriesLimited investigationFinal reportJackman Pitts S-1S · Hammondsport, NYthe pilot's improper flare.Sep 27, 1997 · N4241Z · Substantial damage NTSB NYC97LA082Accident · No injuriesLimited investigationFinal reportBeech F33A · Mattituck, NYthe pilot's inadequate compensation for the wind conditions and improper flare, which resulted in a hard landing.Apr 30, 1997 · N6733Y · Substantial damage NTSB IAD97LA068Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wellsville, NYthe student pilot's improper flare, improper recovery from a bounced landing, and loss of directional control, during the landing.Apr 20, 1997 · N2477K · Substantial damage NTSB NYC96LA153Accident · Serious injuriesLimited investigationFinal reportKolb Mark III · Gowanda, NYfailure of the pilot to properly flare the airplane during the landing.Jul 18, 1996 · N695WM · Minor damage NTSB NYC96LA127Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Fulton, NYthe student pilot's improper flare and the flight instructor's inadequate supervision.Jun 12, 1996 · N5981X · Substantial damage NTSB NYC96LA069Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · South Wales, NYthe pilot's improper flare and failure to maintain directional control during landing.Mar 1, 1996 · N7807S · Substantial damage NTSB NYC95LA193Accident · No injuriesLimited investigationFinal reportCessna 172 · Fulton, NYthe pilot misjudged the flare, resulting in a hard landing and subsequent collapse of the nose gear.Aug 14, 1995 · N6338F · Substantial damage NTSB NYC95LA165Accident · No injuriesLimited investigationFinal reportCessna 310Q · Buffalo, NYThe pilot misjudged the flare, resulting in a hard landing and subsequent collapse of the right main landing gear. Pilot fatigue was a related factor.Jul 19, 1995 · N310JM · Substantial damage NTSB NYC94LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Buffalo, NYThe pilot's improper recovery from a bounced landing. A factor is the pilot's improper landing flare.Sep 22, 1994 · N3024M · Substantial damage NTSB NYC93LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Cortland, NYThe student pilot's improper recovery from a bounced landing, resulting in a hard landing and collapse of the nose gear. A factor was the student pilot's inexperience.Aug 28, 1993 · N63626 · Substantial damage NTSB BFO92LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Spencerport, NYThe pilot's inadequate flare which resulted in a hard landing.Jul 26, 1992 · N4389X · Substantial damage NTSB NYC92LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Durhamville, NYThe pilot's improper recovery from a bounced landing which resulted in collapsing of the nose gear. Factor related to the accident was the pilot misjudged the flare/touchdown.Jun 26, 1992 · N69005 · Substantial damage NTSB NYC92IA086Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385 · Flushing, NYThe captain's improper aircraft control which resulted in an excessive nosewheel rate of sink and subsequent overload failure of the nose gear tires.Apr 23, 1992 · N721DA · Minor damage NTSB NYC91LA214Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Montauk, NYThe pilot made a hard landing, resulting in the main landing gear collapsing. Contributing to the accident was the pilot's interpretation of the wind conditions, misjudgment of the flare causing the airplane to balloon and stall.Aug 17, 1991 · N4368W · Substantial damage NTSB NYC91LA118Accident · No injuriesLimited investigationFinal reportCessna P210 · Olean, NYImproper flare by the pilot, which resulted in a hard landing. Factors related to the accident were: the pilot's lack of recent experience and the unfavorable wind condition.Apr 18, 1991 · N90TL · Substantial damage NTSB NYC91LA116Accident · No injuriesLimited investigationFinal reportPiper 180 · Andes, NYThe failure of the pilot to maintain directional control during a landing with unfavorable winds.Apr 6, 1991 · N9006J · Substantial damage NTSB NYC91DFA01Accident · No injuriesFinal reportLowe/Law Glasair SH-3 · Kingston, NYA hard landing that collapsed the left main gear due to overload failure of the trunion.Nov 21, 1990 · N330 · Substantial damage NTSB NYC90LA126Accident · Serious injuriesLimited investigationFinal reportBarnes Firefly 8B · Cazenovia, NYThe passengers failure to comply with the pilots instructions after a hard landing was made.Jun 10, 1990 · N3702M · No damage NTSB NYC90LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Granville, NYThe improper recovery from a bounced landing which resulted in loss of control and collision with a ditch.May 14, 1990 · N80104 · Substantial damage NTSB NYC89LA200Accident · No injuriesLimited investigationFinal reportCessna 182F · Albany, NYThe pilot's improper flare during landing.Aug 25, 1989 · N92323 · Substantial damage NTSB NYC89LA203Accident · No injuriesLimited investigationFinal reportCessna 172P · Newburgh, NYThe dual student's misjudgement of the airplane's altitude and speed during the flare for landing, and the improper use of power during the flare. In addition, the CFI failed to adequately supervise the dual student's action.Aug 2, 1989 · N1983F · Substantial damage NTSB NYC89LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Plattsburgh, NYThe pilot's improper flare, improper recovery from a bounced landing, and failure to maintain directional control.Jul 3, 1989 · N48683 · Substantial damage NTSB NYC89LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Oneida, NYLoss of directional control during landing due to wind change. The aircraft landed hard on the runway due to improper flare by the pilot and a delayed response to the ballooning of the acft.Jul 2, 1989 · N4953B · Substantial damage NTSB NYC89DFJ01Accident · Minor injuriesFinal reportDavis DA-2A · Skaneateles, NYThe pilot's hard landing which resulted in nose gear collapse.Jun 6, 1989 · N26Q · Substantial damage NTSB NYC89LA070Accident · No injuriesLimited investigationFinal reportCessna 150L · Shirley, NYA poorly planned final approach, an improper landing flare, and failure of the pilot to correct a bounced landing.Jan 14, 1989 · N6888G · Substantial damage NTSB NYC88LA172Accident · No injuriesLimited investigationFinal reportCessna 150 · Massena, NYThe student pilot on a crosscountry flight to Massena, new york stated that during the landing approach he felt that he was too low and when he tried to correct, the aircraft bounced. On the second touchdown the nose gear collapsed and the aircraft slid off…Jul 18, 1988 · N704HT · Substantial damage NTSB NYC88FA143Accident · Minor injuriesField investigationFinal reportBell 206B · Farmingdale, NYThe Bell 206B was being flown on a helicopter rating ride with the PIC in the right seat and an FAA inspector in the left seat. The oral was satisfactory and the flight check progressed to autorotations. The first one was long, the second short. On the third…May 12, 1988 · N39071 · Substantial damage NTSB NYC88LA040Accident · No injuriesLimited investigationFinal reportCessna 210 · Schenectady, NYDuring landing, the left main gear collapsed. A metallurgical examination revealed that the left main gear saddle assembly was fractured into three pieces through the area near the forward edge of the landing gear strut. When examined further, the faces and…Nov 14, 1987 · N9568T · Substantial damage NTSB NYC88LA036Accident · No injuriesLimited investigationFinal reportBeech 36 · Utica, NYThe flight was enroute from bridgeport, Connecticut to old forge, new york when adverse weather conditions were encountered. A request for lower altitude to escape weather was no improvement and a request to land at oneida was made. During radar vectors…Nov 12, 1987 · N9230Q · Substantial damage