Skip to content

NTSB investigations: Cessna 182P, NY

21 cases on aircraft the registry lists as Cessna 182P. 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

19722026

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 ('2075816')) 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 ('2075816'))
  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 ('2075816'))
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 ERA24LA368Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Shelter Island, NYThe pilot’s failure to attain a proper touchdown point while landing, which resulted in a runway overrun.Aug 22, 2024 · N7529N · Substantial damage NTSB ERA21LA004Accident · 1 fatalClass 3 · LimitedFinal reportCessna 182 · Beechhurst, NYThe pilot’s selection of a landing area that provided inadequate distance from obstacles and his subsequent decision to abort the landing with inadequate takeoff distance available, which resulted in a high-speed collision with a concrete bulkhead.…Oct 4, 2020 · N6506M · Substantial damage NTSB NYC01LA148Accident · 1 fatalLimited investigationFinal reportCessna 182P · Oswego, NYThe pilot's inadequate altitude clearance above water while conducting low level flight maneuvers. A factor related to the accident was the pilot's impairment of judgment due to alcohol consumption.Jun 16, 2001 · N58594 · Destroyed NTSB NYC01LA065Accident · No injuriesLimited investigationFinal reportCessna 182P · Angola, NYThe pilot's misjudged clearance over an obstacle.Jan 12, 2001 · N52359 · Destroyed NTSB NYC97LA094Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Red Hook, NYThe pilot's improper compensation for the wind conditions and his failure to initiate a go-around.May 16, 1997 · N7322S · Substantial damage NTSB BFO93LA086Accident · No injuriesLimited investigationFinal reportCessna 182P · Bath, NYThe pilot did not attain the proper touchdown point and did not go around while there was still sufficient speed to do so. The wet runway grass was a related factor.May 15, 1993 · N21137 · Substantial damage NTSB NYC87FA192Accident · 4 fatalField investigationFinal reportCessna 182P · Ellenville, NYThe acft collided with rising terrain in a mountainous area of minnewaska state park while climbing to cruise on a VFR flight. The crash site was about 1,430 feet higher in elevation than the departure airport. The weather at the departure airport was 1000…Jun 26, 1987 · N722DD · Destroyed NTSB NYC86LA122Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Otselic, NYThe Cessna 182P was cruising at 2500 ft when it experienced an engine failure. The pilot made a landing in a plowed field across the furrows. The nose wheel broke off on landing and the aircraft flipped over. The pilot received minor injuries while the…May 8, 1986 · N7313Q · Substantial damage NTSB NYC83LA097Accident · No injuriesLimited investigationFinal reportCessna 182 · Rochester, NYThe acft went off the runway in strong gusty winds and nosed down in mud. The pilot stated that he bounced on landing and came down about 35 degrees to the centerline. He judged it too risky to try to realign so he continued to land off the runway. The acft…Apr 14, 1983 · N21059 · Substantial damage NTSB NYC82DA167Accident · No injuriesFinal reportCessna 182P · Hunter, NYThe brakes were ineffective during landing & the acft ran off the side of the rwy & came to rest inverted in bushes against a small hill. The brake linings were changed 204 flt hours prior to the accident. Inspection verified that the brakes were considerably…Jul 25, 1982 · N8493M · Substantial damage NTSB NYC81FFA04Accident · No injuriesClosedCessna 182 · Monticello, NYOct 31, 1980 · N58776 · Substantial damage NTSB NYC79FFJ01Accident · Minor injuriesClosedCessna 182 · Jamestown, NYOct 2, 1978 · N8128M · Substantial damage NTSB NYC77FHM15Accident · Minor injuriesClosedCessna 182 · Spring Valley, NYApr 14, 1977 · N52337 · Destroyed NTSB NYC77FFA16Accident · No injuriesClosedCessna 182P · Frankford, NYMar 20, 1977 · N5932J · Substantial damage NTSB NYC76FFA50Accident · Minor injuriesClosedCessna 182 · Old Forge, NYAug 29, 1976 · N21137 · Substantial damage NTSB NYC75FFJ20Accident · Minor injuriesClosedCessna 182P · Lancaster, NYFeb 1, 1975 · N21020 · Substantial damage NTSB NYC75AN061Accident · 1 fatalClosedCessna 182P · Niagara Falls, NYNov 13, 1974 · N21168 · Destroyed NTSB NYC75FHM09Accident · No injuriesClosedCessna 182 · Spring Valley, NYSep 17, 1974 · N21408 · Substantial damage NTSB NYC74AN041Accident · 3 fatalClosedCessna 182P · Dix Hills, NYNov 6, 1973 · N21208 · 2 aircraft · Destroyed NTSB NYC73FFA19Accident · No injuriesClosedCessna 182P · Essex, NYOct 18, 1972 · N9353G · Substantial damage NTSB NYC72FFA43Accident · No injuriesClosedCessna 182 · Glens Falls, NYMay 24, 1972 · N7384Q · Substantial damage