NTSB investigations: Cessna 172M, AL

15 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

NTSB investigations: Cessna 172M, AL per year, 1973–2026: 15 cases
1973	1
1975	1
1977	1
1978	1
1980	1
1981	2
1982	1
1985	1
1988	1
1993	2
1999	1
2002	1
2024	1

Where

Open the map

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" = 'AL' 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\" = 'AL' 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" = 'AL' 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 ERA24LA114Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172M · Brookwood, ALThe pilot’s failure to see and avoid powerlines while maneuvering at low altitude.Feb 16, 2024 · N9160H · Substantial damage NTSB ATL02LA154Accident · No injuriesLimited investigationFinal reportCessna 172M · Enterprise, ALThe pilot's delayed flare on landing that resulted in a hard landing.Aug 9, 2002 · N73461 · Substantial damage NTSB ATL99LA090Accident · No injuriesLimited investigationFinal reportCessna 172M · Double Springs, ALThe pilot's failure to maintain directional control of the aircraft during landing. A factor was the pilot's lack of experience.May 16, 1999 · N20417 · Substantial damage NTSB ATL93FA136Accident · Serious injuriesField investigationFinal reportCessna 172M · Harvest, ALThe pilot's poorly planned approach and the failure of the pilot to execute a go-around.Jul 28, 1993 · N13738 · Substantial damage NTSB ATL93LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Tuskegee, ALThe pilot's failure to establish a final approach course to the runway surface during a night landing. A factor was the inoperative aircraft landing light.Jun 2, 1993 · N64206 · Substantial damage NTSB ATL88LA201Accident · No injuriesLimited investigationFinal reportCessna 172M · Meridianville, ALThe plt reported that he attempted to make a touch and go ldg at the departure arpt before heading out on the first leg of a cross-country flt. The airplane encountered a gust of wind at touchdown and veered off the side of the rwy. The airplane subsequently…Jun 26, 1988 · N5075R · Substantial damage NTSB ATL86LA045Accident · No injuriesLimited investigationFinal reportCessna C-172M · Andalusia, ALThe acft battery power was depleted. The plt hand propped the engine with his wife at the controls. The engine started with the throttle advanced and acft taxied into trees and over an embankment. The wife was not a rated pilot.Dec 20, 1985 · N509R · Substantial damage NTSB ATL82FA153Accident · 1 fatalField investigationFinal reportCessna 172M · Alabaster, ALAt 0755, the plt contacted birmingham approach control & reported 35 mi south at 2,000 ft. he was advised of the bhm wx & that it was IFR at the arpt. The pilot stated he would like to land at another arpt & was given his approximate position to three arpts.…Jun 4, 1982 · N5443H · Destroyed NTSB ATL82FKJ04Accident · No injuriesClosedCessna 172M · Selma, ALNov 8, 1981 · N82DJ · Destroyed NTSB ATL81DKJ17Accident · Minor injuriesClosedCessna 172 · Maysville, ALApr 9, 1981 · N12667 · Destroyed NTSB MIA80DKJ30Accident · No injuriesClosedCessna 172 · Clayton, ALApr 22, 1980 · N6624H · Substantial damage NTSB MIA78FKJ75Accident · No injuriesClosedCessna 172 · Orrville, ALAug 16, 1978 · N1479V · Substantial damage NTSB MIA78FKJ81Accident · No injuriesClosedCessna 172 · Grove Hill, ALSep 3, 1977 · N64260 · Minor damage NTSB MIA76DKJ04Accident · No injuriesClosedCessna 172 · Elmore, ALJun 14, 1975 · N12527 · Substantial damage NTSB MIA74DKJ07Accident · No injuriesClosedCessna 172 · Andalusa, ALJul 28, 1973 · N20234 · Substantial damage