Skip to content

NTSB investigations: Cessna 172G, NY

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

19662026

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 ('2072420')) 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 ('2072420'))
  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 ('2072420'))
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 ERA25LA121Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Syracuse, NYThe truck driver’s to see and avoid the airplane, which resulted in a collision.Feb 15, 2025 · N1178F · Substantial damage NTSB GAA16CA044Accident · No injuriesData collectionFinal reportCessna 172G · Newfane, NYAn evasive maneuver during landing to avoid deer on the runway, which resulted in a runway overrun and collision with trees.Nov 9, 2015 · N3679L · Substantial damage NTSB ERA15FA203Accident · 1 fatalField investigationFinal reportCessna 172 · Penn Yan, NYThe student pilot's failure to maintain airplane control during the initial climb. Contributing to the accident was the student's inappropriate configuration of the airplane's wing flaps for the initial climb.May 3, 2015 · N3969L · Substantial damage NTSB IAD00LA057Accident · Serious injuriesLimited investigationFinal reportCessna 172G · North Elba, NYthe pilot's inaccurate fuel consumption calculations and exhaustion of his fuel supply.Jul 8, 2000 · N4198L · Substantial damage NTSB IAD98LA096Accident · No injuriesLimited investigationFinal reportCessna 172G · Williamson, NYDirectional control not maintained by one of the pilot's on board the airplane.Aug 15, 1998 · N1308F · Substantial damage NTSB NYC84LA243Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Forrestport, NYThe acft stalled into trees near the edge of a lake and tumbled into the water after the engine quit due to fuel exhaustion at 2000 ft AGL aprx 2 miles from the lake. The plt said he should have used a dip-stick to measure the fuel in the tanks before takeoff…Jul 15, 1984 · N3736L · Substantial damage NTSB NYC81FFJ01Accident · No injuriesClosedCessna 172 · Hamburg, NYOct 18, 1980 · N3646S · Substantial damage NTSB NYC79DFA36Accident · No injuriesClosedCessna 172 · Shinhopple, NYSep 2, 1979 · N5980R · Substantial damage NTSB NYC77DFA20Accident · No injuriesClosedCessna 172 · Ticonderoga, NYApr 29, 1977 · N3648L · Substantial damage NTSB NYC76FFA52Accident · No injuriesClosedCessna 172G · Marcy, NYSep 23, 1976 · N1117F · Substantial damage NTSB NYC73FHJ21Accident · Minor injuriesClosedCessna 172 · Edgewater Park, NYJun 8, 1973 · N3813L · Substantial damage NTSB NYC72FFA37Accident · No injuriesClosedCessna 172G · New Brennan, NYMay 4, 1972 · N1331F · Substantial damage NTSB NYC71FFJ03Accident · No injuriesClosedCessna 172G · Gorham, NYAug 7, 1970 · N3813L · Substantial damage NTSB NYC70DFA05Accident · No injuriesClosedCessna 172 · New Bremen, NYJan 4, 1970 · N1341F · Substantial damage NTSB NYC70F0210Accident · No injuriesClosedCessna 172 · Huntington, NYNov 16, 1969 · N1191F · Substantial damage NTSB NYC70A0033Accident · 2 fatalClosedCessna 172G · Germantown, NYSep 14, 1969 · N4601L · Destroyed NTSB NYC70F0011Accident · No injuriesClosedCessna 172G · Montauk, NYJun 8, 1969 · N3985L · Substantial damage NTSB NYC69F0429Accident · No injuriesClosedCessna 172 · Farmingdale, NYApr 20, 1969 · N4429L · Destroyed NTSB NYC69D0333Accident · No injuriesClosedCessna 172 · Johnstown, NYFeb 8, 1969 · N5939R · Substantial damage NTSB NYC69F0129Accident · Minor injuriesClosedCessna 172 · Wappinger Fall, NYSep 8, 1968 · N4103L · Substantial damage NTSB NYC68D0048Accident · No injuriesClosedCessna 172 · Monticello, NYJul 1, 1967 · N6017R · Substantial damage NTSB NYC67D0581Accident · No injuriesClosedCessna 172G · Flushing, NYApr 4, 1967 · N4168L · Substantial damage NTSB NYC67F0517Accident · Minor injuriesClosedCessna 172G · Montauk, NYFeb 26, 1967 · N1335F · Destroyed NTSB NYC67D0115Accident · No injuriesClosedCessna 172 · Walden, NYJul 16, 1966 · N3813L · Substantial damage NTSB NYC67F0112Accident · No injuriesClosedCessna 172 · East Hampton, NYJul 4, 1966 · N4429L · Substantial damage