NTSB investigations: Cessna 172M, SC
13 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 | 1 |
|---|---|
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1994 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2009 | 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\" = 'SC' 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" = 'SC' 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 ERA09LA272Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Chesterfield, SCThe partial loss of engine power due to a broken exhaust valve. Contributing to the accident was the operator's exceedance of the engine manufacturer's recommended time before overhaul.NTSB MIA02LA064Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Marion, SCThe loss of engine power during takeoff/initial climb due to undetermined reasons, resulting in a landing on unsuitable terrain.NTSB MIA01LA161Accident · No injuriesLimited investigationFinal reportCessna 172M · Bennettsville, SCThe pilot's improper correction for wind conditions and his failure to maintain control of the airplane resulting in the airplane sliding off an embankment during taxi from landing.NTSB ATL94LA091Accident · No injuriesLimited investigationFinal reportCessna 172M · Barnwell, SCThe pilot's failure to flare properly which resulted in a hard landing.NTSB ATL89LA021Accident · No injuriesLimited investigationFinal reportCessna 172M · Hilton Head Is., SCThe plt reported that the airplane lost power shortly after takeoff. A forced ldg was subsequently made in a swamp near the arpt. The airplane nosed over during rollout. Post-crash exam of the airplane revealed that the throttle cable outer casing had become…NTSB ATL87LA113Accident · No injuriesLimited investigationFinal reportCessna 172 M · Ridgeland, SCThe plt was practicing t/o & ldgs. During the 2nd ldg, the plt reptd retarding throttle to idle and eng dying during roll-out. A restart was accomplished and another t/o comp. Again during ldg. Eng stopped during roll out. This time, the restart attempt was…NTSB ATL87LA054Accident · No injuriesLimited investigationFinal reportCessna 172M · Hartsville, SCThe student plt made two go-arounds before starting his third landing attempt with a variable wind. After touchdown the acft veered to the right and departed the rwy. The plt applied power in an attempt to take-off but the nose wheel hit a hole and the acft…NTSB ATL86LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · Pelion, SCThe private plt and student plt returned to the acft after pausing from landing practice for a soft drink. An engine start was attempted and a back fire occurred that started and induction fire. The intensity of the fire grew and the occupant exited the acft…NTSB ATL86LA017Accident · No injuriesLimited investigationFinal reportCessna 172 M · Moncks Corner, SCThe plt reported that the acft engine experienced a loss of power while being vectored for the initial ILS approach to charleston, SC (chs). Attempts by the plt to regain pwr failed and a forced landing was made in a swampy field a few miles north of chs. The…NTSB ATL80FLG19Accident · Minor injuriesClosedCessna 172M · Manning, SCNTSB MIA79DLG23Accident · No injuriesClosedCessna 172 · Laurens, SCNTSB MIA78FLG05Accident · Minor injuriesClosedCessna 172M · Camden, SCNTSB MIA75DLG24Accident · No injuriesClosedCessna 172 · Hilton Head, SC