NTSB investigations: Cessna 182A, NY

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

19642026

NTSB investigations: Cessna 182A, NY per year, 1964–2026: 13 cases
1964	1
1965	2
1967	1
1969	1
1970	1
1974	1
1983	1
1989	1
1993	1
2006	1
2014	1
2017	1

Where

Open the map

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 ('2072704')) 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 ('2072704'))
  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 ('2072704'))
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 ERA17LA166Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Ovid, NYThe mechanic's failure to inspect and clean the carburetor fuel inlet screen during the airplane’s annual inspection, which allowed undetected debris and dirt to obstruct the fuel supply and resulted in fuel starvation and the subsequent total loss of engine…Apr 23, 2017 · N9907B · Substantial damage NTSB ERA14CA449Accident · No injuriesData collectionFinal reportCessna 182A · Bethany Center, NYThe pilot's failure to maintain a directional control of the airplane during gusting wind conditions.Sep 20, 2014 · N3785D · Substantial damage NTSB NYC06CA119Accident · Serious injuriesData collectionFinal reportCessna 182A · Plattsburgh, NYThe pilot's failure to utilize carburetor heat, which resulted in the formation of carburetor ice and subsequent engine failure. Factors included the carburetor icing conditions and trees in the forced landing area.Jul 15, 2006 · N2186G · Substantial damage NTSB NYC93FA154Accident · 1 fatalField investigationFinal reportCessna 182A · East Moriches, NYEngine failure due to a fatigue failure of the no.3 piston. The fatigue failure was a result of inadequate manufacturing. In addition, the pilot made an improper decision during the forced landing in attempting to stretch his approach in order to reach the…Aug 14, 1993 · N5010D · Destroyed NTSB NYC89LA165Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Lancaster, NYWater contamination of the fuel, and an inadequate preflight by the pilot-in-command.Jul 14, 1989 · N6171B · Substantial damage 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.Jul 7, 1983 · N3703D · Substantial damage NTSB NYC74FFA33Accident · No injuriesClosedCessna 182A · Malone, NYJun 2, 1974 · N5051D · Substantial damage NTSB NYC70DFA08Accident · No injuriesClosedCessna 182 · Albany, NYFeb 12, 1970 · N3703D · Substantial damage NTSB NYC70F0197Accident · Minor injuriesClosedCessna 182A · White Plains, NYOct 26, 1969 · N1010J · Substantial damage NTSB NYC68F0172Accident · Serious injuriesClosedCessna 182 · East Jewett, NYJul 29, 1967 · N5156D · Substantial damage NTSB NYC65F0154Accident · No injuriesClosedCessna 182 · East Amherst, NYApr 3, 1965 · N3703D · Substantial damage NTSB NYC65F0136Accident · No injuriesClosedCessna 182 · Rochester, NYMar 27, 1965 · N5003D · Substantial damage NTSB UNK64X2551Accident · No injuriesClosedCessna 182 · Southhold Li, NYJun 28, 1964 · N9975B · Substantial damage