NTSB investigations: Cessna 172S, 2008
31 cases on aircraft the registry lists as Cessna 172S. 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
| 1967 | 2 |
|---|---|
| 1970 | 1 |
| 1972 | 1 |
| 1979 | 3 |
| 1987 | 1 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 20 |
| 2002 | 22 |
| 2003 | 29 |
| 2004 | 27 |
| 2005 | 28 |
| 2006 | 25 |
| 2007 | 26 |
| 2008 | 31 |
| 2009 | 22 |
| 2010 | 27 |
| 2011 | 20 |
| 2012 | 29 |
| 2013 | 24 |
| 2014 | 18 |
| 2015 | 18 |
| 2016 | 29 |
| 2017 | 24 |
| 2018 | 22 |
| 2019 | 23 |
| 2020 | 18 |
| 2021 | 22 |
| 2022 | 9 |
| 2023 | 13 |
| 2024 | 14 |
| 2025 | 18 |
| 2026 | 14 |
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 year(c.\"eventDate\") = 2008
AND 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'))
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 year(c."eventDate") = 2008
AND 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'))
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 ANC09CA016Accident · No injuriesData collectionFinal reportCessna 172S · Girdwood, AKThe flight instructor's lack of action to correct a high and fast landing approach which resulted in a long landing, and subsequent collision with a snow berm at the end of the runway. Contributing to the accident was the student pilot's improper approach.NTSB ERA09FA092Accident · 1 fatalField investigationFinal reportCessna 172S · Goodland, FLThe pilot's failure to maintain aircraft control due to spatial disorientation. Contributing to the accident was the night light 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 ERA09CA063Accident · No injuriesData collectionFinal reportCessna 172 · Bedford, MAThe student pilot's inadequate compensation for winds during landing.NTSB ERA09CA041Accident · Serious injuriesData collectionFinal reportCessna 172 · Frederick, MDThe passenger’s failure to avoid the rotating propeller after exiting the airplane. Contributing to the accident was the pilot’s failure to include deplaning procedures as part of the passenger safety briefing.NTSB ERA09CA035Accident · No injuriesData collectionFinal reportCessna 172 · Asheville, NCThe student pilot’s improper recovery from a bounced landing.NTSB WPR09CA273Accident · No injuriesData collectionFinal reportCessna 172S · Compton, CAThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB LAX08FA301Accident · Serious injuriesField investigationFinal reportCessna 172S · Fullerton, CAThe pilot's failure to follow the takeoff checklist and verify the proper flap setting before takeoff.NTSB MIA08CA179Accident · No injuriesData collectionFinal reportCessna 172SP · South Harpswell, METhe pilot's failure to maintain control of the airplane while landing in gusty winds.NTSB NYC08CA282Accident · No injuriesData collectionFinal reportCessna 172 · Charlottesville, VAThe pilot's improper flare while landing. Contributing to the accident was the gusty wind condition.NTSB MIA08CA165Accident · No injuriesData collectionFinal reportCessna 172S · Monroeville, ALThe pilot's inadequate compensation for winds during landing. Contributing to the accident was a wind gust.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…NTSB LAX08LA283Accident · No injuriesLimited investigationFinal reportCessna 172 · Honolulu, HIThe flight's encounter with the jet wash from a parked commercial airplane while taxiing for takeoff.NTSB NYC08CA257Accident · Minor injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe flight instructor's inadequate remedial action following the student pilot's improper recovery from a bounced landing.NTSB OPS08IA010Incident · No injuriesIncident investigationFinal reportCessna 172 · Teterboro, NJProbable Cause The probable cause of this incident was the TEB ground controller's failure to direct N316AS to hold short of runway 24 when issuing taxi instructions to the aircraft as required FAA Order 7110.65, paragraph 3-7-2 (2a); Taxi and Ground Movement…NTSB NYC08CA230Accident · No injuriesData collectionFinal reportCessna 172 SP · Stevensville, MDThe flight instructor's delayed decision to go around.NTSB LAX08LA191Accident · 2 fatalLimited investigationFinal reportCessna 172S · Oceanside, CAFailure of the pilot to regain airplane control during an intentional stall/spin maneuver.NTSB MIA08CA124Accident · No injuriesData collectionFinal reportCessna 172S · Orangeburg, SCThe pilot's failure to obtain the proper touchdown point on landing.NTSB NYC08CA214Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe student pilot's improper flare.NTSB LAX08LA179Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Beaver, UTThe pilot's failure to attain and maintain an adequate airspeed during the initial climb as a result of his inadequate preflight planning and improper use of the mixture control. Contributing to the accident were the tailwind and high density altitude.NTSB MIA08CA111Accident · No injuriesData collectionFinal reportCessna 172S · Kissimmee, FLThe pilot's improper landing flare.NTSB NYC08CA187Accident · No injuriesData collectionFinal reportCessna 172SP · Homestead, FLThe student pilot's improper flare. Contributing to the accident was the flight instructor's inadequate remedial action.NTSB MIA08CA092Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe student pilot's improper recovery from a bounced landing.NTSB LAX08CA102Accident · No injuriesData collectionFinal reportCessna 172S · Gualala, CAThe pilot's decision not to use all of the available runway, his premature rotation and failure to obtain and maintain an adequate airspeed to continue the takeoff that resulted in a stall/mush, an aborted takeoff, a runway overrun, and a collision with…NTSB LAX08CA124Accident · No injuriesData collectionFinal reportCessna 172S · San Luis Obispo, CAThe pilot's inadequate landing flare, resulting in a hard landing. Contributing to the accident was the gusty wind condition.NTSB NYC08FA133Accident · 4 fatalField investigationFinal reportCessna 172 · Indiantown, FLThe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude. Contributing to the accident was the overweight condition of the airplane and the inoperative stall warning horn.NTSB NYC08CA118Accident · No injuriesData collectionFinal reportCessna 172SP · Lincoln Park, NJThe certificated flight instructor's delayed decision to go-around.NTSB MIA08CA056Accident · No injuriesData collectionFinal reportCessna 172S · Orlando, FLThe student pilot's inadequate recovery from a bounced landing.NTSB SEA08CA077Accident · No injuriesData collectionFinal reportCessna 172SP · Mesa, AZan in-flight collision with a bird.NTSB DFW08CA070Accident · No injuriesData collectionFinal reportCessna 172S · Jenks, OKThe owner of the parking surface's failure to ensure that the parking surface was clear of hazards to taxiing airplanes and the pilot's failure to ensure a safe taxi route in unfamiliar surroundings.NTSB MIA08CA068Accident · No injuriesData collectionFinal reportCessna 172S · Westiminster, MDThe student pilot's improper flare.