NTSB investigations: Cessna 172S
11 cases on aircraft the registry lists as Cessna 172S, where the sequence of events included Controlled flight into terr/obj (CFIT). 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
| 2008 | 2 |
|---|---|
| 2012 | 2 |
| 2014 | 2 |
| 2017 | 2 |
| 2023 | 1 |
| 2026 | 2 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072439', '2072442')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '120' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072439', '2072442')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '120' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 WPR26FA232Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Willard, UTOn June 23, 2026, at about 2247 mountain daylight time, a Cessna 172S, N387AF, was destroyed when it was involved in an accident near Willard, Utah. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB ERA26LA143Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Carthage, NCThe pilot’s failure to maintain clearance from trees while on final approach for landing. Contributing to the accident were the flight instructor’s inadequate remedial actions.NTSB WPR23FA172Accident · 1 fatalClass 3 · FieldFinal reportCessna 172S · Los Angeles, CAThe pilot’s failure to maintain clearance with the hilly terrain resulting from his loss of situational awareness due to the deteriorating weather conditions as he descended to approach his destination airport.NTSB GAA18CA074Accident · No injuriesData collectionFinal reportCessna 172 · Bowie, MDThe pilot’s failure to maintain situational awareness during the approach to land. Contributing to the accident was the pilot’s distraction by the instrument panel during the approach.NTSB WPR17FA063Accident · 1 fatalField investigationFinal reportCessna 172 · Ramona, CAThe flight instructor's failure to ensure that adequate clearance from terrain was maintained after performance of a simulated engine failure maneuver, which resulted in controlled flight into terrain.NTSB ERA15FA046Accident · 1 fatalField investigationFinal reportCessna 172 · Hinton, VAThe flight instructor’s decision to conduct a night training flight in mountainous terrain without conducting or allowing the student to conduct appropriate preflight planning and his lack of situational awareness of the surrounding terrain altitude, which…NTSB ERA14CA124Accident · No injuriesData collectionFinal reportCessna 172S · Mansfield, MAThe student pilot's failure to maintain an adequate approach glide path, which resulted in a collision with a snow bank.NTSB ERA12FA572Accident · 1 fatalField investigationFinal reportCessna 172S · Land O'Lakes, FLThe pilot’s decision to continue the cross-country flight while fatigued, which resulted in him falling asleep during the initial descent for landing.NTSB WPR12FA105Accident · 3 fatalField investigationFinal reportCessna 172S · North Bend, WAThe pilot's physical impairment due to alcohol, which adversely affected his ability to operate the airplane and to maintain clearance from mountainous terrain while operating in dark night conditions.NTSB ERA09LA064Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Groton, CTThe student pilot’s failure to maintain a proper descent profile to avoid trees during the night visual approach and the flight instructor’s inadequate oversight.NTSB LAX08FA261Accident · 1 fatalField investigationFinal reportCessna 172S · Incline Village, NVThe pilot's decision to initiate a flight for which he was neither approved nor qualified and his failure to maintain terrain clearance during the flight. Contributing to the accident were the dark night, the mountainous terrain, and the pilot's medical…