Skip to content

NTSB investigations: Cessna 172N, MA

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

19782026

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" = 'MA' 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 ('2072434')) 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\" = 'MA' 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 ('2072434'))
  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" = 'MA' 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 ('2072434'))
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 ERA26FA084Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Provincetown, MAOn January 4, 2026, at 1504 eastern standard time, a Cessna 172N, N9360E, was substantially damaged when it was involved in an accident near Provincetown, Massachusetts. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of…Jan 4, 2026 · N9360E · Substantial damage NTSB ERA13CA210Accident · No injuriesData collectionFinal reportCessna 172N · Stow, MAThe pilot’s failure to maintain directional control while landing in gusty wind conditions.Apr 20, 2013 · N739CK · Substantial damage NTSB ERA11LA489Accident · No injuriesLimited investigationFinal reportCessna 172N · Plymouth, MAThe pilot's inadequate flare and improper recovery from a bounced landing.Aug 31, 2011 · N739RU · Substantial damage NTSB ERA10CA289Accident · No injuriesData collectionFinal reportCessna 172N · Sterling, MAThe pilot’s decision to not continue with the go-around, which resulted in a collision with trees. Contributing to the accident was the pilot’s distraction due to the passenger’s panicked condition.May 31, 2010 · N6371D · Substantial damage NTSB ERA09LA399Accident · No injuriesLimited investigationFinal reportCessna 172N · Rochester, MAAn engine vibration as reported by the pilot, for undetermined reasons.Jul 12, 2009 · N4773G · Substantial damage NTSB NYC06LA124Accident · Minor injuriesLimited investigationFinal reportCessna C-172N · Vineyard Haven, MAThe pilot's improper preflight planning and improper fuel consumption calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.May 28, 2006 · N738HE · Substantial damage NTSB NYC05LA106Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Edgartown, MAThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall and subsequent impact with terrain. [This report was modified on June 10, 2008]Jun 23, 2005 · N5118D · Substantial damage NTSB NYC04CA134Accident · Serious injuriesData collectionFinal reportCessna 172M · Worcester, MAThe pilot's improper recovery from a bounced landing, and his inadequate compensation for wind conditions. A factor in the accident was the gusting wind.May 29, 2004 · N73704 · Substantial damage NTSB NYC00LA109Accident · No injuriesLimited investigationFinal reportCessna 172 · North Adams, MAThe pilot's failure to obtain the proper touchdown point. A factor was a tailwind.Apr 6, 2000 · N738CG · Substantial damage NTSB IAD00LA006Accident · No injuriesLimited investigationFinal reportCessna 172N · Hopedale, MAwas the student pilot's improper flare that resulted in a bounced landing and the flight instructor's delay in taking remedial action.Nov 15, 1999 · N738NL · Substantial damage NTSB NYC94LA132Accident · No injuriesLimited investigationFinal reportCessna 172N · Chatham, MAThe pilot's failure to see and avoid the birds. The presence of the birds at the airport was a contributing factor.Jul 21, 1994 · N76090 · Substantial damage NTSB NYC90LA017Accident · Minor injuriesLimited investigationFinal reportCessna T172N · Townsend, MAThe pilot's failure to use carburetor heat during weather conditions favorable to carburetor icing. A contributing factor was the lack of suitable terrain.Oct 25, 1989 · N6309F · Substantial damage NTSB NYC88FA236Accident · 2 fatalField investigationFinal reportCessna 172N · Adams, MAPilot's inadequate preflight planning and improper inflight decisions, he continued VFR into IFR conditions. The air route traffic control center service was improper.Sep 17, 1988 · N6586J · Destroyed NTSB NYC88LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Southbridge, MADuring takeoff from Southbridge airport, the aircraft encountered a crosswind. The aircraft started drifting to the right even though full left aileron and full power were being applied. The pilot cut the power to abort the takeoff, and the aircraft impacted…Mar 1, 1988 · N75762 · Substantial damage NTSB NYC85LA242Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Ware, MAThe student plt and CFI were practicing full stop night landings when the accident occurred. While on final apch for thefourth landing, the acft collided with trees 1.7 NM short of the rwy.Sep 18, 1985 · N738SA · Destroyed NTSB NYC84LA279Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Nantucket, MAPlt entered the pattern for landing and was advised of a cross-wind situation. Plt was unfamiliar with the airport and requested a full pattern circuit to observe conditions. On lndg flare with full flaps and left cross-wind correction input, a gust carried…Aug 17, 1984 · N739ZU · Destroyed NTSB NYC84FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172N · Nantucket, MAThe acft disappeared after departing on the return leg of a x-country. The plt had called the operator at the home base and reported that IMC weather existed for the return. The plt was informed that the acft was not needed and he did not need to hurry back.…Jul 19, 1984 · N4950G · Destroyed NTSB NYC83LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Tewksbury, MAThe acft had just completed a go-around and was trying a 2nd time. The acft floated and bounced until a go-around was started about 100 ft before the departure end of the rwy. The pilot stalled over a fence and miniature golf course. The acft was about 100…Sep 4, 1983 · N737UG · Substantial damage NTSB NYC83LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Haverhill, MAThe acft overran the departure end of the 2100 ft rwy 32 during landing. The wind was from 320 degrees at 10 KTS. The pilot stated he made one go-around because he was high. He reported that the 2nd approach was flown at 65 mph with the touchdown accomplished…Jul 17, 1983 · N75563 · Substantial damage NTSB NYC81DNA23Accident · No injuriesClosedCessna 172N · Marthas Vinyrd, MAAug 1, 1981 · N5700E · Substantial damage NTSB NYC81FA034Accident · No injuriesClosedVolmer 1 · Norfolk, MADec 13, 1980 · N31037 · 2 aircraft · Substantial damage NTSB NYC81FNE04Accident · 1 fatalClosedCessna C-172N · Sterling, MANov 22, 1980 · N3043E · Destroyed NTSB NYC80FNA18Accident · No injuriesClosedCessna 172 · Halifax, MAAug 3, 1980 · N1489E · Substantial damage NTSB NYC79FNA29Accident · No injuriesClosedCessna 172N · Newburyport, MAAug 26, 1979 · N734QZ · Substantial damage NTSB NYC78FNA39Accident · No injuriesClosedCessna 172N · Wareham, MAJul 29, 1978 · N734QH · Substantial damage