Skip to content

NTSB investigations: Cessna 172K, NY

22 cases on aircraft the registry lists as Cessna 172K. 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

19672026

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 ('2072430')) 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 ('2072430'))
  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 ('2072430'))
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 ERA14FA428Accident · 2 fatalField investigationFinal reportCessna 172 · Selkirk, NYA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Sep 8, 2014 · N79438 · Substantial damage NTSB NYC99FA107Accident · 1 fatalField investigationFinal reportCessna 172K · Shirley, NYThe pilot's loss of control of the airplane due to intoxication. A factor was the pilot's self-induced pressure to conduct the flight.May 8, 1999 · N7068G · Destroyed NTSB NYC98LA145Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Chateaugay, NYBinding in the control yoke for undetermined reasons.Jul 18, 1998 · N155AA · Destroyed NTSB NYC87LA096Accident · No injuriesLimited investigationFinal reportCessna 172 · Poughkeepsie, NYDuring landing roll out, the pilot lost directional control as the aircraft veered to the right side of the runway and collided with a snowbank.Feb 21, 1987 · N7509G · Substantial damage NTSB NYC85LA115Accident · Serious injuriesLimited investigationFinal reportCessna C172 · Poestenkill, NYCessna 172TD encountered strong gusty crosswind while taking from rensselaer airpark and directional control was lost. The aircraft verred off the left side off the run-way and collid with the terrain. Full right rudder was applied to correct the deviation.…May 4, 1985 · N172TD · Substantial damage NTSB NYC78DFJ08Accident · No injuriesClosedCessna 172K · Owego, NYDec 3, 1977 · N7351G · Substantial damage NTSB NYC77FA059Accident · 1 fatalClosedCessna 172K · Flushing, NYMay 22, 1977 · N217NY · Destroyed NTSB NYC77DFJ06Accident · No injuriesClosedCessna 172 · Binghamton, NYNov 18, 1976 · N84043 · Substantial damage NTSB NYC77FFJ02Accident · No injuriesClosedCessna 172K · Varna, NYOct 31, 1976 · N79878 · Substantial damage NTSB NYC77FHJ02Accident · No injuriesClosedCessna 172K · Farmingdale, NYSep 24, 1976 · N79578 · Substantial damage NTSB NYC76FHM30Accident · No injuriesClosedCessna 172K · Warwick, NYJun 9, 1976 · N79435 · Substantial damage NTSB NYC75FFA05Accident · Minor injuriesClosedCessna 172K · Downsville, NYAug 1, 1974 · N79925 · Destroyed NTSB NYC74IN096Incident · No injuriesClosedBeech 23 · Westhmpton Bch, NYMay 18, 1974 · N2350Q · 2 aircraft · Minor damage NTSB NYC74DHJ15Accident · No injuriesClosedCessna 150 · Deerpark, NYSep 9, 1973 · N60616 · 2 aircraft · Substantial damage NTSB NYC74DFA07Accident · No injuriesClosedCessna 172 · Cobleskill, NYSep 3, 1973 · N46709 · Substantial damage NTSB NYC72FFA32Accident · Minor injuriesClosedCessna 172K · Rexford, NYJan 20, 1972 · N7067G · Substantial damage NTSB NYC72FHM07Accident · Serious injuriesClosedCessna 172K · Slate Hill, NYAug 29, 1971 · N78836 · Substantial damage NTSB NYC72FHM02Accident · No injuriesClosedCessna 172 · Kingston, NYAug 7, 1971 · N78436 · Substantial damage NTSB NYC71DHJ13Accident · No injuriesClosedCessna 172 · Flushing, NYNov 22, 1970 · N1191M · Substantial damage NTSB NYC70FHJ11Accident · Minor injuriesClosedCessna 172 · Deer Park, NYJun 21, 1970 · N46657 · Substantial damage NTSB NYC70D0213Accident · No injuriesClosedCessna 172K · Marcellus, NYNov 16, 1969 · N46639 · Substantial damage NTSB NYC67A0145Accident · Minor injuriesClosedCessna 172H · Jamaica, NYApr 19, 1967 · N800TS · Substantial damage