NTSB investigations: Cessna 172S
19 cases on aircraft the registry lists as Cessna 172S, where the first occurrence was “Loss of control - in flight”. 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
| 1987 | 1 |
|---|---|
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 4 |
| 2005 | 4 |
| 2006 | 2 |
| 2007 | 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 LAX08FA023Accident · 1 fatalField investigationFinal reportCessna 172S · Palm Springs, CAThe flight instructor's failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb, and his impairment from alcohol.NTSB DFW07LA207Accident · No injuriesLimited investigationFinal reportCessna 172S · Tyler, TXThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the encounter with wake turbulence.NTSB ANC06CA114Accident · No injuriesData collectionFinal reportCessna 172 · Palatka, FLThe student's failure to maintain adequate airspeed to preclude a stall while maneuvering over the runway, and the instructor's inadequate supervision of the student pilot, which resulted in a collision with the runway. A factor in the accident was an…NTSB CHI06CA183Accident · No injuriesData collectionFinal reportCessna 172S · Baltimore, OHThe pilot's failure to attain sufficient airspeed during the takeoff which resulted in the inadvertent stall and collision with the ground.NTSB DEN06FA023Accident · 1 fatalField investigationFinal reportCessna 172S · Pinon, NMthe pilot's failure to maintain control of the airplane for undetermined reasons.NTSB DEN05CA145Accident · No injuriesData collectionFinal reportCessna 172S · Cedar City, UTthe student pilot's failure to maintain aircraft control during the landing. Factors contributing to the accident were the improper flare and improper recovery from a bounced landing.NTSB MIA05FA140Accident · 4 fatalField investigationFinal reportCessna 172S · Key West, FLThe failure of the pilot-in-command to maintain directional control of the airplane during the dark, night flight over water, resulting in the uncontrolled descent and in-flight collision with the water. A contributing factor in the accident was the pilot's…NTSB IAD05FA067Accident · 4 fatalField investigationFinal reportCessna 172S · Brooklyn, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and subsequent impact with terrain.NTSB DEN05FA044Accident · 1 fatalField investigationFinal reportCessna 172S · Roswell, NMthe pilot not maintaining control of the aircraft resulting in an uncontrolled descent and collision on a highway. Factors contributing to the accident were the dark night and the pilot experiencing spatial disorientation.NTSB NYC04CA206Accident · No injuriesData collectionFinal reportCessna 172S · Mount Gilead, OHThe pilot's inadequate compensation for wind conditions which resulted in a collision with the runway. A factor was the crosswind.NTSB ATL04LA164Accident · 1 fatalLimited investigationFinal reportCessna 172S · Waterloo, ALThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in a stall and subsequent uncontrolled descent and collision into water.NTSB MIA04CA077Accident · No injuriesData collectionFinal reportCessna 172S · Key West, FLThe pilot's failure to maintain directional control while landing in gusty wind conditions which resulted in the airplane departing the runway and impacting a sign, incurring damage.NTSB CHI03LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Lakeville, MNThe pilot's inadequate removal of ice and snow during the airplane preflight, and the subsequent loss of control due to the airplane being covered with ice.NTSB FTW02LA224Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Marietta, OKThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB LAX02LA192Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Goldfield, NVThe pilot's failure to maintain control of the airplane during a high density altitude takeoff. Contributing factors were the pilot's lack of experience in the type of operation and a wind gust.NTSB SEA01IA113Incident · No injuriesIncident investigationFinal reportCessna 172S · Monroe, ORA degradation of aircraft control for undetermined reasons.NTSB CHI01FA136Accident · No injuriesField investigationFinal reportCessna 172S · Springfield, MOthe excessive touchdown airspeed by the pilot.NTSB NYC01LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hodgenville, KYThe pilot's failure to maintain runway alignment during landing. A factor in the accident was the pilot's lack of experience in conducting soft field landings.NTSB NYC87FA120Accident · 4 fatalField investigationFinal reportCessna 172P · Berwick, METhe acft was observed doing stalls. A witness said that prior to the crash he saw the nose lower and the right wing drop. The aircraft then entered into a spiral. It was observed descending into trees in a spiral. The plt was found in the right front seat.…