Skip to content

NTSB investigations: Cessna 172, NY

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

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 ('2072402')) 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 ('2072402'))
  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 ('2072402'))
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 GAA17CA018Accident · Minor injuriesData collectionFinal reportCessna 172 · Argyle, NYThe pilot’s failure to maintain a stable descent rate and his improper landing flare, which resulted in a hard landing.Oct 8, 2016 · N3943F · Substantial damage NTSB ERA11CA331Accident · Serious injuriesData collectionFinal reportCessna 172 · Ghent, NYThe pilot's delayed decision to abort the landing and execute a go-around.Jun 8, 2011 · N8895B · Substantial damage NTSB NYC07CA069Accident · No injuriesData collectionFinal reportCessna 172 · Utica, NYThe pilot's failure to maintain directional control of the airplane, during an aborted takeoff, which resulted in a collision with a snowbank.Feb 25, 2007 · N7141A · Substantial damage NTSB IAD99LA067Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Honeoye Falls, NYthe pilot's loss of directional control after landing. A factor in the accident were ruts in the turf runway that were hidden from view.Sep 19, 1999 · N6941A · Substantial damage NTSB NYC89LA120Accident · No injuriesLimited investigationFinal reportCessna 172 · So. Bethlehem, NYThe pilots misjudgement of landing distance which resulted in the failure to touchdown at a proper touchdown point. The pilot also failed to perform a go-around.Apr 17, 1989 · N6105E · Substantial damage NTSB NYC83LA199Accident · No injuriesLimited investigationFinal reportCessna 172 · Easton, NYThe plt reported that during landing the brakes locked & the acft then hit two bumps in the rwy & ballooned. The acft then skidded off the end of the rwy, collided with a plowed furrow & flipped inverted.Aug 2, 1983 · N3943F · Substantial damage NTSB CHI81FA013Accident · 1 fatalClosedCessna 172M · Ithaca, NYDec 29, 1980 · N5161R · Destroyed NTSB NYC80DFA22Accident · Serious injuriesClosedCessna 172 · Saranac Inn, NYAug 1, 1980 · N6935A · Destroyed NTSB NYC80FA015Accident · 1 fatalClosedCessna 172 · Washingtnville, NYDec 16, 1979 · N6647A · Destroyed NTSB NYC79FHM09Accident · No injuriesClosedCessna 172 · Spring Valley, NYFeb 6, 1979 · N6965A · Substantial damage NTSB NYC78DFJ42Accident · No injuriesClosedCessna 172 · Wellsville, NYSep 26, 1978 · N5968A · Substantial damage NTSB NYC78FFJ36Accident · Minor injuriesClosedCessna 172 · W.Bloomfield, NYAug 27, 1978 · N6447B · Substantial damage NTSB NYC77FFJ18Accident · Serious injuriesClosedCessna 172 · Barker, NYApr 30, 1977 · N2325U · Substantial damage NTSB NYC75FFA25Accident · No injuriesClosedCessna 172 · Malone, NYDec 28, 1974 · N35531 · Substantial damage NTSB NYC75FHJ27Incident · No injuriesClosedCessna 172 · Ronkonkoma, NYApr 24, 1974 · N503E · Minor damage NTSB NYC74DFA20Accident · No injuriesClosedCessna 172 · Hamilton, NYFeb 9, 1974 · N8921B · Substantial damage NTSB NYC74AN028Accident · No injuriesClosedCessna 172 · Ronkonkoma, NYSep 21, 1973 · N6115E · Substantial damage NTSB NYC72DFA46Accident · Minor injuriesClosedCessna 172 · Malone, NYJun 7, 1972 · N8420U · Substantial damage NTSB NYC70FFA18Accident · No injuriesClosedCessna 172 · Schroon Lake, NYApr 25, 1970 · N6234E · Substantial damage NTSB NYC70FHJ01Accident · Minor injuriesClosedCessna 172 · Farmingdale, NYJan 20, 1970 · N6696A · Substantial damage NTSB NYC70F0059Accident · Minor injuriesClosedCessna 172C · White Plains, NYJul 5, 1969 · N1859Y · Substantial damage NTSB NYC69D0191Accident · No injuriesClosedCessna 172 · Oriskany, NYSep 30, 1968 · N7064T · Destroyed NTSB NYC69F0043Accident · No injuriesClosedCessna 172 · Holtsville, NYJun 29, 1968 · N7928B · Substantial damage NTSB NYC68D0224Accident · No injuriesClosedCessna 172 · Mahopac, NYSep 30, 1967 · N6114E · Substantial damage NTSB NYC67D0672Accident · No injuriesClosedCessna 172 · Hammondsport, NYApr 29, 1967 · N6187E · Substantial damage NTSB NYC66D0705Accident · No injuriesClosedCessna 172 · Penn Yan, NYMay 27, 1966 · N6197E · Substantial damage NTSB NYC66D0532Accident · No injuriesClosedCessna 172 · Warwick, NYFeb 6, 1966 · N8508B · Substantial damage NTSB NYC66F0053Accident · Minor injuriesClosedCessna 172 · Pavilion, NYJul 5, 1965 · N6263E · Substantial damage NTSB NYC65D0119Accident · No injuriesClosedCessna 172 · Middletown, NYMar 28, 1965 · N7402A · Substantial damage NTSB NYC65D0120Accident · No injuriesClosedCessna 172 · Woodstock, NYMar 20, 1965 · N6141E · Substantial damage NTSB UNK65X1241Accident · No injuriesClosedCessna 172 · Elmira, NYJan 6, 1965 · N9111B · Substantial damage NTSB UNK65X0616Accident · No injuriesClosedCessna 172 · Blossvale, NYNov 8, 1964 · N7157A · Substantial damage NTSB UNK64X2759Accident · No injuriesClosedCessna 170B · Mahopac, NYJul 11, 1964 · N8804B · Substantial damage NTSB UNK64X1910Accident · No injuriesClosedCessna 172 · Armonk, NYMay 23, 1964 · N4250F · Substantial damage