NTSB investigations: Cessna 172P
34 cases on aircraft the registry lists as Cessna 172P, where the first occurrence was “In flight collision with terrain/water”. 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
| 1982 | 4 |
|---|---|
| 1983 | 2 |
| 1985 | 2 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 4 |
| 1994 | 1 |
| 1995 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072436')
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\" = 230))
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 ('2072436')
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" = 230))
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 CHI05CA150Accident · No injuriesData collectionFinal reportCessna 172P · St. Francis, KSThe pilot's failure to compensate for the crosswind conditions during landing and the unsuccessful go-around. A factor was the crosswind.NTSB LAX04CA282Accident · No injuriesData collectionFinal reportCessna 172P · Big Bear City, CAthe instructor's inadequate compensation for wind conditions and delayed decision to perform a go-around. Contributing factors were wind gusts, windshear, and an excessive descent rate.NTSB DEN04TA088Accident · Serious injuriesFinal reportCessna C172P · Las Cruces, NMthe pilot's failure to maintain clearance from terrain and the improper go-around procedure. Contributing factors include the pilot's diverted attention, improper in-flight planning and decision making, pilot fatigue, the night conditions and the mesquite…NTSB LAX04LA053Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fountain Hills, AZThe flight instructor's delayed remedial action and inadequate altitude during a go-around following a simulated forced landing, which resulted in an in-flight collision with terrain.NTSB LAX03FA090Accident · Serious injuriesField investigationFinal reportCessna 172P · Santa Susana, CAThe flight instructor's inadequate in-flight decision to cross mountainous terrain at a inadequate altitude to guarantee terrain clearance.NTSB DEN00LA121Accident · No injuriesLimited investigationFinal reportCessna 172P · Price, UTThe pilot's failure to maintain directional control of the aircraft during landing roll. Factors were strong and gusty winds.NTSB CHI00LA032Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Greenfield, INThe student pilot not maintaining aircraft control. A contributing factor was the student's aural perception.NTSB DEN99FA142Accident · 1 fatalField investigationFinal reportCessna 172P · Grants, NMThe pilot's failure to fly the aircraft at an altitude sufficient to clear surrounding terrain. Factors were: The pilot's in-flight planning and decision making in proceeding into known adverse weather. Low ceiling, rain, lack of total pilot experience, and…NTSB LAX95LA133Accident · No injuriesLimited investigationFinal reportCessna 172P · Redlands, CAthe pilot's use of an excessive approach speed and glidepath angle and his improper bounced landing recovery technique.NTSB FTW95FA050Accident · 2 fatalField investigationFinal reportCessna 172P · Deming, NMThe pilot's failure to maintain sufficient altitude and clearance in moutainous terrain. Factors were rising terrain and gusty, high wind conditions.NTSB SEA94FA014Accident · 2 fatalField investigationFinal reportCessna 172P · Kelso, WAThe pilot's failure to follow the published missed approach procedure. Factors in the accident were: the weather and mountainous terrain.NTSB DEN93LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMImproper planning and decision making by the pilot in command in descending into a valley at an altitude providing no escape route in mountainous terrain.NTSB SEA93FA125Accident · 3 fatalField investigationFinal reportCessna 172P · Enumclaw, WAInadvertent VFR flight into IMC. Factors to the accident were: fog and rain.NTSB LAX93FA096Accident · 1 fatalField investigationFinal reportCessna 172P · Sun City, CAThe pilot's decision to initiate VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the pilot's failure to obtain a weather briefing, the adverse weather, and the mountainous terrain.NTSB LAX92FA241Accident · 3 fatalField investigationFinal reportCessna 172P · Big Sur, CAPilot incapacition.NTSB LAX92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Williams, AZThe pilot's failure to maintain visual lookout.NTSB ANC91FA132Accident · 3 fatalField investigationFinal reportCessna 172 · Eklutna Lake, AKThe pilot's failure to maintain terrain clearance. Contributing to the accident was the high terrain.NTSB NYC91FA001Accident · 3 fatalField investigationFinal reportCessna 172P · Gorham, NHImproper planning/decision by the pilot, and his failure to maintain proper altitude while flying over mountainous terrain. Factors related to the accident were: darkness, mountainous terrain, and pilot fatigue.NTSB NYC90LA069Accident · No injuriesLimited investigationFinal reportCessna 172P · Sunapee Lake, NHFailure of the pilot to maintain adequate altitude above the lake, which resulted in unplanned contact with its frozen surface.NTSB NYC90LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Bingham, METhe pilot's inadequate preflight planning to assure that the airplane was capable of outclimbing the surrounding terrain under the existing wind and airplane weight conditions, resulting in an intentional stall into the terrain. Contributing factor(s) was:…NTSB MKC89LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Pine Bluff, ARImproper in-flight planning/decision by the pilot by continuing the approach when the runway lights did not activate. Contributing factors were: dark night and soft terrain.NTSB NYC88LA247Accident · Minor injuriesLimited investigationFinal reportCessna 172P · New York, NYWhile on a night personal pleasure flt along the hudson river between New York and new jersey, at 300 feet AGL, the plt turned the acft toward an unlighted shore area and lost visual cues. The plt inadvertently flew the acft into the water. The acft sunk and…NTSB ANC88LA073Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kenai, AKThe pilot stated that he was in a 180 degree turn when he encountered IMC conditions. The flight path had placed the pilot in a valley with cloud shrouded hills to the sides. The aircraft struck the side of a hill at 1780 MSL.NTSB SEA88LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Orofino, IDPlt stated that due to encircling tstms, elected a precautionary landing at 1800-foot usfs (forrest service) emrrgency strip. Touchdown was long and go-around resulted in a stall/mush into the trees.NTSB NYC87LA261Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Fitchburg, MADrg arrival, the plt was clrd for an ndb-a apch to Fitchburg muni arpt. The NDB was located on the arpt & the arpt elev was 350'. The min dscnt alt (mda) was 1140' MSL. The apch procedure was to go outbnd fm the NDB on a 137 deg bearing, make a procedure…NTSB LAX87LA353Accident · 1 fatalLimited investigationFinal reportCessna 172P · Independence, CAThe acft was rprtd missing after it departed san jose, CA, at about 1852 PDT on 6/9/87. A search was initiated, but the plane was not found until the wreckage was discovered by a hiker on 6/30/90. The acdnt occurred near kearsarge pass at an elev of 12,000…NTSB DEN85FA118Accident · 2 fatalField investigationFinal reportCessna 172 P · Santa Fe, NMTwo persons, neither rated as plts, took the acft without the knowledge or consent of the operator or arpt officials. They took off at night, & after a short time, returned to the arpt to land. During an attempted landing, the acft touched down hard, bounced…NTSB FTW85LA120Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Comanche, TXThe non-instrument rated plt flew the acft into rising terrain in a wings level attitude during a period of low ceilingson a dark night. The plt stated he was descending to stay clear of the overcast and never saw the ground. Plt had a total of 80 hrs flt…NTSB LAX83FA377Accident · 4 fatalField investigationFinal reportCessna 172 · San Simeon, CAThe acft collided with the terrain while on a pleasure flight for the purpose of sightseeing. The wreckage was found in a box canyon at 3500 ft MSL. Examination of the accident site revealed that the acft impacted on a heading of approx 085 degrees. The…NTSB SEA83FA087Accident · 3 fatalField investigationFinal reportCessna 172P · 2nm E. Of Blyn, WAThe plts had received a wx briefing from seattle fss earlier in the day for a flt from seattle to port angeles. Due to the time span between arrival & departure at port angeles, the wx briefing was not valid for the return flt. The acft impacted the west…NTSB DEN83FTI02Accident · 2 fatalFinal reportCessna 172P · Dillon, MIThe pilot and three passengers departed Dillon, mt at about 0740 MDT to scout for elk in preparation for hunting the next day. According to a passenger, they flew directly to a mountain area about 30 miles away where they spotted some elk. He said that while…NTSB NYC83LA006Accident · No injuriesLimited investigationFinal reportCessna 172P · Mt. Pleasant, PAReportedly, the pilot made his landing approach too high and too fast. After rolling an undetermined distance, he elected to go-around. According to the passenger, the pilot had started a climb when he banked the aircraft and retracted the flaps. Reportedly,…NTSB ATL83FKW01Accident · 2 fatalFinal reportCessna 172P · Gallatin, TNCessna 172P, N5313K crashed into a densely wooded area during the initial portion of cross-country flight. The pilot and his wife were killed but an infant son survived. Weather was not a factor.NTSB ATL82FA164Accident · Serious injuriesField investigationFinal reportCessna 172P · Asheville, NCThe flt reportedly involved mountain flying techniques. The student observed that the acft was not climbing normally & the CFI suggested they slow to 70K. The student started a turn toward a wide valley but the CFI urged him to continue toward the mtns which…