Skip to content

NTSB investigations: Cessna 172M, ME

26 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

19732026

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" = 'ME' 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\" = 'ME' 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" = 'ME' 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 ERA22LA303Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172M · South Portland, METhe student pilot’s improper landing flare, which resulted in a hard landing. Also causal was the flight instructor’s inadequate remedial action.Jul 8, 2022 · N9946Q · Substantial damage NTSB ERA21LA074Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Dexter, METhe pilot’s loss of directional control while landing, which resulted in an encounter with snow and subsequent nose over.Dec 11, 2020 · N19801 · Substantial damage NTSB ERA11FA493Accident · 1 fatalField investigationFinal reportCessna 172M · Greenville, METhe pilot's failure to maintain adequate airspeed while manuevering at low altitude, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.Sep 17, 2011 · N9932V · Substantial damage NTSB ERA09CA010Accident · No injuriesData collectionFinal reportCessna 172 · Naples, METhe pilot's failure to maintain directional control of the airplane during takeoff. Contributing to the accident was the wet condition of the grass runway.Oct 3, 2008 · N20921 · Substantial damage NTSB ANC08LA007Accident · No injuriesLimited investigationFinal reportCessna 172M · Rangeley, METhe pilot's failure to maintain aircraft control during the landing flare/touchdown. A factor contributing to the accident was the pilot's diverted attention.Oct 18, 2007 · N92737 · Substantial damage NTSB MIA07CA095Accident · Minor injuriesData collectionFinal reportCessna 172-M · Oxford, METhe student pilot's failure to maintain a climb during a go-around resulting in collision with an embankment.May 8, 2007 · N80132 · Substantial damage NTSB NYC05CA003Accident · No injuriesData collectionFinal reportCessna 172M · Eliot, METhe pilot's inadequate in-flight planning decision, which resulted a loss of engine power due to fuel exhaustion.Oct 9, 2004 · N80657 · Substantial damage NTSB IAD04LA036Accident · 1 fatalLimited investigationFinal reportCessna 172M · Brownville Junc, METhe pilot's continued visual flight into instrument meteorological conditions, which resulted in the airplane's controlled flight into rising terrain. Factors included the instrument meteorological conditions and the rising terrain.Aug 12, 2004 · N12959 · Substantial damage NTSB NYC95FA210Accident · 3 fatalField investigationFinal reportCessna 172M · Portland, MEan engine malfunction for an undetermined reason, and the pilot's failure to maintain airspeed during a forced landing which resulted in an accelerated stall. A factor was the pilot's lack of recent experience.Sep 1, 1995 · N6564H · Destroyed NTSB NYC92LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Dexter, MEA failure of the top torque link bolt on the nose landing gear which resulted in a landing with a flat strut and misaligned wheel.Jun 9, 1992 · N19801 · Substantial damage NTSB NYC92LA069Accident · No injuriesLimited investigationFinal reportCessna 150 · Sanford, METhe failure of the pilot of N64147 to maintain adequate spacing and visual lookout from N6544G while taxiing, resulting in a ground collision.Feb 15, 1992 · N6544G · 2 aircraft · Substantial damage NTSB NYC91FA188Accident · Serious injuriesField investigationFinal reportCessna 172M · Phillips, MEAn inadvertent stall and loss of control due to the pilot's improper use of the wing flaps for takeoff. Factors related to the accident were: the pilot's misunderstanding of airplane performance, and the pilot's decision to takeoff uphill.Jul 24, 1991 · N85HC · Destroyed NTSB NYC91FA034Accident · 2 fatalField investigationFinal reportCessna 172M · Perham, METhe pilot initiating flight into known icing conditions which resulted in an accumulation of airframe ice and a failure to maintain airspeed. The contributing factor was the existing icing conditions.Nov 23, 1990 · N9086H · Destroyed NTSB NYC87DNC02Accident · No injuriesFinal reportCessna 172M · Van Buren, MEWhile climbing from 1000 ft. the pilot of a C-172 expericed an engine failure at 1500 ft and made an emergency landing striking small trees and brush. Subsequent inspection of the engine revealed that the crankshaft dowel pin was sheared and the crankshaft…Oct 13, 1986 · N5255R · Substantial damage NTSB NYC80FNC33Accident · No injuriesClosedCessna 172 · Turner, MEJul 8, 1980 · N9931Q · Substantial damage NTSB NYC79DA096Accident · No injuriesClosedCessna 172 · Greenville, MESep 10, 1979 · N12736 · Substantial damage NTSB NYC78FNC51Accident · Serious injuriesClosedCessna 172M · Old Town, MESep 17, 1978 · N9604H · No damage NTSB NYC78FGM46Accident · No injuriesClosedCessna 172 · Greenville, MEAug 18, 1978 · N9921Q · Substantial damage NTSB NYC78DNC11Accident · No injuriesClosedCessna 172M · Harbor, MEDec 19, 1977 · N13144 · Substantial damage NTSB NYC77DNC18Accident · No injuriesClosedCessna 172 · Abbott Village, MEJan 6, 1977 · N12734 · Substantial damage NTSB NYC77FNC01Accident · No injuriesClosedCessna 172M · Greenville, MEOct 7, 1976 · N13339 · Substantial damage NTSB NYC76DNC64Accident · Minor injuriesClosedCessna 172 · Andover, MEAug 15, 1976 · N13325 · Destroyed NTSB NYC76FNC04Accident · 1 fatalClosedCessna 172M · Dexter, MEAug 1, 1975 · N13272 · Substantial damage NTSB NYC75AN058Accident · 3 fatalClosedCessna 172 · Bridgewater, MENov 6, 1974 · N19927 · Destroyed NTSB NYC74AN068Accident · 1 fatalClosedCessna 172M · Otis, MEFeb 7, 1974 · N3527Q · Destroyed NTSB NYC74FNC31Accident · Serious injuriesClosedCessna 172M · Rangeley, MENov 19, 1973 · N92899 · Destroyed