Skip to content

NTSB investigations: Cessna 172P, NY

23 cases on aircraft the registry lists as Cessna 172P. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19732026

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072436')) 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072436'))
  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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072436'))
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 ERA12CA098Accident · No injuriesData collectionFinal reportCessna 172P · Schenectady, NYThe pilot’s inadequate recovery from a bounced landing, which resulted in a loss of control.Dec 1, 2011 · N83PD · Substantial damage NTSB ERA10CA241Accident · No injuriesData collectionFinal reportCessna 172P · Wurtsboro, NYThe student pilot's improper flare and recovery from a bounced landing.Apr 24, 2010 · N51231 · 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 NYC05LA123Accident · No injuriesLimited investigationFinal reportCessna 172P · Islip, NYThe pilot's failure to maintain clearance from a parked vehicle while taxiing.May 17, 2005 · N9344L · Substantial damage NTSB NYC00FA106Accident · 2 fatalField investigationFinal reportCessna 172P · Ballston Spa, NYa loss of control for undetermined reason(s).Mar 30, 2000 · N98574 · Destroyed NTSB NYC99LA196Accident · No injuriesLimited investigationFinal reportCessna 172P · Montgomery, NYthe failure of the student pilot to maintain directional control during the touchdown and landing roll.Aug 11, 1999 · N65742 · Substantial damage NTSB NYC95FA080Accident · 1 fatalField investigationFinal reportCessna 172P · Naples, NYThe pilot's continued VFR flight into instrument meteorological conditions. Factors contributing to the accident were: the night conditions, fog, low ceiling, and hilly terrain.Mar 30, 1995 · N96746 · Destroyed NTSB BFO94LA116Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Massena, NYThe pilot's improper compensation for wind conditions.Jun 26, 1994 · N5435K · Substantial damage NTSB BFO92LA073Accident · No injuriesLimited investigationFinal reportCessna 172P · Poughkeepsie, NYThe pilot failed to maintain directional control.May 21, 1992 · N97154 · Substantial damage NTSB NYC91LA113Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Pleasant Valley, NYThe failure of the pilot of N5232K to maintain visual contact and separation with N9763U.Apr 14, 1991 · N9763U · 2 aircraft · Destroyed 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 NYC88LA247Accident · Minor injuriesLimited investigationFinal reportCessna 172P · New York, NYWhile on a night personal pleasure flt along the hudson river between New York and new jersey, at 300 feet AGL, the plt turned the acft toward an unlighted shore area and lost visual cues. The plt inadvertently flew the acft into the water. The acft sunk and…Sep 30, 1988 · N98305 · Destroyed NTSB NYC88LA079Accident · 1 fatalLimited investigationFinal reportCessna 172P · East Hampton, NYThe flight departed East Hampton airport for a pleasure flt. Shortly thereafter, the pilot called on frequency 122.7 stating that he had struck some birds and could not maintain control of the aircraft. There as no further transmission as to his location, and…Feb 11, 1988 · N52535 · Destroyed NTSB NYC87LA230Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Binghamton, NYWhile taking off from a touch-&-go landing, the student plt lost control of the acft at an alt of about 100 ft. subsequently, the acft spun to the left & collided with the ground, left wing first, then cartwheeled & came to rest in an upright position. No…Aug 12, 1987 · N98494 · Destroyed NTSB NYC87LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Livingston, NYDuring landing roll, the aircraft encountered patchy ice on the runway surface causing the aircraft to skid out of control and impact a snowbank.Feb 7, 1987 · N62429 · Substantial damage NTSB NYC86LA180Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kingston, NYThe student plt was on his 1st solo flt. After a go-around, his next apch was good until the acft encountered a gust of wind just before touchdown. Subsequently, the acft landed hard (hit on rear section), veered off the rwy & nosed over.Jul 14, 1986 · N54946 · Destroyed NTSB NYC85LA017Accident · No injuriesLimited investigationFinal reportCessna 172P · Andes, NYAccording to the plt, he encountered deteriorating visibility due to haze & he elected to land in an unimproved field. The 1st approach was aborted; however, the acft touched down on the 2nd approach. After touching down, the plt realized the field was too…Nov 1, 1984 · N64182 · Destroyed NTSB NYC84LA311Accident · No injuriesLimited investigationFinal reportCessna 172P · White Plaines, NYThe solo student plt stated that she was up set by a request from the tower to do a 360 deg turn on downwind and another acft in the pattern transmitting that the turn would put the 2 acft on a collision course. The turn was not completed and the plt…Sep 13, 1984 · N65719 · Substantial damage NTSB NYC84LA193Accident · No injuriesLimited investigationFinal reportCessna C172 · West Seneca, NYInexperienced FBO personnel changed rwy resulting in downwind landings. PIC accepted change though aware of wind. Acft drifted left during flare, touchdown and initial roll. The acft continued off the left side of the rwy and continued into an area of mud…Jun 2, 1984 · N97137 · Substantial damage NTSB NYC84LA003Accident · No injuriesLimited investigationFinal reportCessna C-172 · Spring Valley, NYThe student pilot, on a solo instructional flt landed hard and bounced off the rwy. The student plt was not injured but the acft received damage to the main and nose gear, the propeller, firewall, wing root and the engine cowling.Oct 6, 1983 · N96103 · Substantial damage NTSB NYC83LA212Accident · No injuriesLimited investigationFinal reportCessna 172P · Westville, NYDuring arrival, the plt landed in light rain on a wet sod rwy with light & variable wind conditions. He reported that he touched down on the 1st third of the rwy, but witnesses said that the acft landed past the midfield point. Subsequently, the plt was…Aug 11, 1983 · N63196 · Substantial damage NTSB NYC83LA008Accident · No injuriesLimited investigationFinal reportCessna 172P · Grahamsville, NYThe pilot and two passengers departed on a local sightseeing flight with full fuel tanks. About one hour after takeoff, the pilot flew over the passengers' house to take pictures. While a passenger was photographing the house, the pilot's attention was…Oct 10, 1982 · N54177 · Substantial damage NTSB NYC73FFA25Accident · No injuriesClosedCessna 320B · Utica, NYFeb 2, 1973 · N9818L · Substantial damage