Skip to content

NTSB investigations: Cessna 172M, MA

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

19752026

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 ('2072418')) 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 ('2072418'))
  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 ('2072418'))
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 GAA16CA515Accident · Serious injuriesData collectionFinal reportCessna 172 · Pittsfield, MAThe student pilot’s failure to maintain an appropriate descent rate and runway alignment during the landing flare, which resulted in the airplane touching down left of the runway and impacting a ditch.Sep 25, 2016 · N73101 · Substantial damage NTSB ERA14CA352Accident · No injuriesData collectionFinal reportCessna 172M · Chatham, MAThe pilot's failure to maintain directional control during takeoff, resulting in a runway excursion and collision with trees.Jul 22, 2014 · N1066R · Substantial damage NTSB ERA11CA371Accident · No injuriesData collectionFinal reportCessna 172M · North Adams, MAThe pilot's inadequate visual lookout and subsequent failure to maintain clearance from a light pole while taxiing.Jun 19, 2011 · N12477 · Substantial damage NTSB ERA10FA414Accident · 2 fatalField investigationFinal reportCessna 172 · Orange, MAThe pilots did not maintain control of the airplane during a flight in dark night conditions due to spatial disorientation.Aug 11, 2010 · N21363 · Substantial damage NTSB ATL07FA125Accident · 2 fatalField investigationFinal reportCessna 172M · Mansfield, MAThe pilot's improper use of wing flaps during takeoff, which resulted in reduced climb performance and a subsequent stall. Contributing to the accident was the exceedance of the airplane's maximum gross weight.Sep 8, 2007 · N19952 · Substantial damage NTSB NYC98LA055Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Mansfield, MAThe pilot's failure to remove snow and ice from the aircraft prior to takeoff resulting in degraded climb performance and a subsequent stall/mush condition.Dec 28, 1997 · N9604H · Destroyed NTSB NYC98LA039Accident · 1 fatalLimited investigationFinal reportCessna 172M · New Salem, MAThe pilot's failure to maintain adequate altitude/clearance above the water due to his impairment by drugs. A factor in this accident was the glassy water condition.Dec 9, 1997 · N12219 · Substantial damage NTSB NYC96LA068Accident · No injuriesLimited investigationFinal reportCessna 172M · Bedford, MAthe flight instructor's inadequate supervision of the flight, the pilot's improper compensation for the wind conditions, and the high wind. The instructor's inadequate evaluation of the weather was a contributing factor.Mar 4, 1996 · N61992 · Substantial damage NTSB NYC95LA200Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Hopedale, MAthe student pilot's improper flare and improper recovery from a bounced landing, which resulted in a loss of control and collision with a fence and a building.Aug 20, 1995 · N8885V · Destroyed NTSB NYC91LA236Accident · No injuriesLimited investigationFinal reportCessna 172M · Norwood, MAPremature retraction of the wing flaps during a go-around which resulted in an inadvertent stall with insufficient altitude for recovery. Factors related to the accident were: the pilot's lack of total experience in make and model, and lack of recent…Sep 12, 1991 · N71393 · Substantial damage NTSB NYC87LA072Accident · No injuriesLimited investigationFinal reportCessna 172 · Lawrence, MADuring a simulated engine out, the aircraft collided with power lines, while climbing out after descending over a possible landing area. The aircraft was able to continue flight and land at bedford, Massachusetts without further incident.Feb 1, 1987 · N80116 · Substantial damage NTSB NYC84LA197Accident · No injuriesLimited investigationFinal reportCessna C172 · Mansfield, MAStudent plt on first solo landed hard due to late flare. The acft touched down on the nose gear resulting in substantialdamage. A go-around was accomplished followed by an uneventful landing.May 15, 1984 · N9654Q · Substantial damage NTSB NYC84LA122Accident · No injuriesLimited investigationFinal reportCessna 172M · Fitchburg, MADuring a touch-&-go landing, the student plt lost directional control. The acft landed slightly sideways on the right main gear & the right wing tip hit the ground. The right wing, prop, eng mount & nose gear were damaged.Mar 25, 1984 · N1474U · Substantial damage NTSB NYC82DA194Accident · No injuriesFinal reportCessna 172M · Marlboro, MAThe solo student was practicing landings, flared the aircraft too high, then stalled and made a hard landing. The nose gear collapsed and the aircraft nosed over.Aug 12, 1982 · N5451H · Substantial damage NTSB NYC82DA025Accident · No injuriesFinal reportCessna 172M · Haverhill, MAThe pilot landed on a wet and muddy strip beside a hard topped runway. After traveling about 100 ft down the strip, the wheels began to sink. As the plane almost came toa stop, the nose wheel sank into the mud and the plane slowly nosed over.Mar 21, 1982 · N3644T · Substantial damage NTSB NYC82FNA10Accident · Minor injuriesFinal reportCessna 172 · Taunton, MAThe student pilot took off at night on an unsupervised pleasure flight. His passenger did not hold any type of pilot certificate. After takeoff, the pilot encountered fog. He used the nbd for orientation and was able to return to the airport. He reported…Jan 24, 1982 · N80420 · Substantial damage NTSB NYC82FNA01Accident · Minor injuriesClosedCessna 172 · North Reading, MAOct 4, 1981 · N73176 · Substantial damage NTSB NYC81FNA03Accident · No injuriesClosedCessna 172 · Mansfield, MANov 27, 1980 · N12706 · Substantial damage NTSB NYC80FNE18Accident · Serious injuriesClosedCessna 172M · Worcester, MAJun 14, 1980 · N64238 · Destroyed NTSB NYC79DNA15Accident · No injuriesClosedCessna 172 · Marlboro, MAApr 11, 1979 · N5451H · Substantial damage NTSB NYC79FNA11Accident · Minor injuriesClosedCessna 172 · Lawrence, MAJan 17, 1979 · N8958V · Substantial damage NTSB NYC79FNA10Accident · No injuriesClosedCessna 172 · Boston, MADec 25, 1978 · N12083 · Substantial damage NTSB NYC79FNA06Accident · No injuriesClosedCessna 172M · Shirley, MADec 5, 1978 · N80916 · Substantial damage NTSB NYC78FNE33Accident · Minor injuriesClosedCessna 172 · Fitchburg, MASep 6, 1978 · N1734V · Substantial damage NTSB NYC77FNA11Accident · No injuriesClosedCessna 172M · Plymouth, MAFeb 6, 1977 · N9654Q · Substantial damage NTSB NYC76FNA52Accident · No injuriesClosedCessna 172 · Middleboro, MASep 12, 1976 · N80420 · Substantial damage NTSB NYC76FNA31Accident · Minor injuriesClosedCessna 172 · Tewksbury, MAMar 21, 1976 · N12401 · Destroyed NTSB NYC75FNE04Accident · No injuriesClosedCessna 172M · Worthington, MAAug 17, 1975 · N12801 · Substantial damage