NTSB investigations: Cessna 172M, MD
17 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.
Cases per year
| 1975 | 2 |
|---|---|
| 1977 | 1 |
| 1980 | 1 |
| 1985 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 2000 | 1 |
| 2004 | 1 |
| 2012 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2024 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'MD' 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" = 'MD' 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" DESCRun 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 ERA24LA204Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Westminster, MDThe pilot’s failure to attain a proper touchdown point during a simulated loss of engine power approach, which resulted in a hard landing short of the runway. Also causal was the flight instructor’s delayed remedial action during the approach and subsequent…NTSB ERA22LA263Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Westminster, MDThe student pilot’s loss of control during a go-around and the delayed remedial action initiated by the flight instructor, which resulted in a runway excursion and collision with trees.NTSB ERA20CA227Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Churchville, MDThe student pilot's improper landing flare and improper recovery from a bounced landing in gusty wind conditions, which resulted in a hard landing.NTSB GAA19CA468Accident · No injuriesData collectionFinal reportCessna 172 · Gaithersburg, MDThe other pilot's failure to maintain clearance from the airplane while taxiing.NTSB GAA17CA205Accident · No injuriesData collectionFinal reportCessna 172 · Baltimore, MDThe student pilot’s failure to maintain clearance from other airplanes in the run-up area.NTSB ERA12CA416Accident · No injuriesData collectionFinal reportCessna 172M · Churchville, MDThe tractor operator's failure to confirm the landing airplane's position before entering an active runway, which resulted in a ground collision.NTSB NYC04CA064Accident · No injuriesData collectionFinal reportCessna 172M · Cumberland, MDThe pilot's inadequate compensation for the crosswind while landing. A factor was the crosswind.NTSB NYC01LA025Accident · No injuriesLimited investigationFinal reportCessna 172M · Camp Springs, MDThe pilot's improper in-flight decision to operate close behind a large airplane at the same altitude, which resulted in a wake turbulence encounter.NTSB NYC99LA021Accident · No injuriesLimited investigationFinal reportCessna 172M · Cumberland, MDThe pilot's decision to land, instead of performing a go-around.NTSB NYC98LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · Westminster, MDthe pilot's misjudgment of distance and speed during the approach/landing, and his delay in initiating a go-around. The quartering tailwind was a related factor.NTSB NYC98LA026Accident · No injuriesLimited investigationFinal reportCessna 172M · Salisbury, MDThe student pilot's improper flare which resulted in a hard landing.NTSB BFO95FA045Accident · 3 fatalField investigationFinal reportCessna 172M · Eldersburg, MDThe pilot's failure to maintain proper airspeed. Factors in the accident were the pilot's failure to remove carburetor heat during the go-around and the presence of a tailwind.NTSB BFO85LA055Accident · No injuriesLimited investigationFinal reportCessna 172M · Hagerstown, MDThe recently certificated instructor was performing touch and go landings with a paraplegic student, who used a hand control for rudder operation. On the third landings the acft veered to the right and the CFI took control of the acft. The student pilot…NTSB ATL80FIG13Accident · No injuriesClosedCessna 172M · Westminster, MDNTSB IAD77FA043Accident · 1 fatalClosedCessna 172 · Cavetown, MDNTSB IAD76FIG01Accident · Minor injuriesClosedCessna 172 · Pasadena, MDNTSB IAD75AIG16Accident · No injuriesClosedCessna 172 · Easton, MD