NTSB investigations: Cessna 172P
30 cases on aircraft the registry lists as Cessna 172P, where the first occurrence was “In flight encounter with weather”. 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
| 1983 | 1 |
|---|---|
| 1984 | 5 |
| 1987 | 3 |
| 1989 | 4 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 3 |
| 1995 | 2 |
| 1996 | 1 |
| 1998 | 3 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 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\" = 240))
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" = 240))
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 SEA05FA013Accident · 1 fatalField investigationFinal reportCessna 172P · Olympia, WAThe pilot's failure to maintain clearance from terrain while maneuvering in known adverse weather conditions. Clouds, rain, high wind, dark night, trees, mountainous terrain and the pilot's inadequate in-flight planning/decision were factors.NTSB DEN03LA072Accident · No injuriesLimited investigationFinal reportCessna 172P · Colo. Springs, COthe student pilot's failure to obtain and maintain adequate altitude during the go-around. Factors contributing to the accident were the encountered windshear, the student pilot's premature raising of the flaps, the instructor pilot's inadequate supervision,…NTSB SEA03FA013Accident · 2 fatalField investigationFinal reportCessna 172P · Malaga, WAThe pilot's attempted VFR flight into IMC resulting in the aircraft colliding with trees and up sloping terrain. Contributing factors were clouds, trees, and uphill terrain. The pilot’s performance and judgment were likely impaired by the effects of…NTSB DEN00LA041Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntsville, UTThe snow shower, and the lack of suitable terrain for the precautionary landing.NTSB FTW98LA220Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Monument Valley, UTThe pilot's failure to maintain directional control of the aircraft during landing. Factors were gusty, crosswind conditions, the pilot's lack of experience in type of operation and geographic area, mountainous terrain, and high density altitude.NTSB FTW98LA188Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Longmont, COThe pilot inadvertently stalling the aircraft during the landing touchdown. Factors were a crosswind and the pilot's lack of total flight experience.NTSB IAD98FA032Accident · 2 fatalField investigationFinal reportCessna 172P · Langley Afb, VAThe pilot's inadvertent VFR flight into IMC conditions, and the subsequent loss of aircraft control due to spatial disorientation. A factor in the accident was the low ceiling.NTSB MIA97LA051Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Atlanta, GAfailure of the pilot to initiate an immediate climb (go-around or missed approach) after encountering fog, while on final approach to land. Darkness and fog at the end of the runway were related factors.NTSB CHI95LA235Accident · No injuriesLimited investigationFinal reportCessna 172 · Springfield, MOimproper in-flight planning/decision by the pilot, and his continued flight into adverse weather conditions, which resulted in an uncontrolled altitude deviation and collision with terrain. Factors relating to the accident were: the adverse weather conditions.NTSB NYC95FA080Accident · 1 fatalField investigationFinal reportCessna 172P · Naples, NYThe pilot's continued VFR flight into instrument meteorological conditions. Factors contributing to the accident were: the night conditions, fog, low ceiling, and hilly terrain.NTSB LAX94LA023Accident · No injuriesLimited investigationFinal reportCessna 172 · Murrieta, CAThe unexpected windsheer that was encountered on final approach. The surrounding mountain/hilly terrain was a factor in this accident.NTSB MIA93LA111Accident · No injuriesLimited investigationFinal reportCessna 172P · Orlando, FLThe pilot-in-command's failure to compensate for wind drift while landing, resulting in the aircraft going off the side of the runway and colliding with a pond.NTSB LAX93FA160Accident · 4 fatalField investigationFinal reportCessna 172P · Livermore, CAThe pilot's decision to attempt VFR flight into instrument meteorological conditions. Factors that contributed to this accident were: the pilot's lack of recent instrument experience, the rain and high wind conditions in the area.NTSB SEA93LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Lind, WAThe aircraft encountered rough terrain during the landing roll after the pilot elected to perform a precautionary landing in an open field, due to deteriorating weather.NTSB CHI92LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Marquette, MIFlight into known adverse weather conditions by the pilot, which resulted in airframe (wing) icing and the inability to maintain altitude. The adverse weather conditions and darkness were related factors.NTSB CHI91DTG01Accident · 1 fatalFinal reportCessna 172P · Bismarck, NDSpatial disorientation. Factors related to the accident are failure to obtain a preflight weather brief, vrf flight into IMC conditions and lack of total experience.NTSB CHI91DEP02Accident · Serious injuriesFinal reportCessna 172P · Hayward, WIThe pilot-in-command's intentional flight into known adverse weather.NTSB NYC89FA206Accident · 4 fatalField investigationFinal reportCessna 172P · Northfield, NHThe pilot initiated flight into known adverse weather which resulted in a loss of control. Contributing factor(s) was: the pilot's overconfidence and the existing weather conditions.NTSB CHI89LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Logansport, INPoor judgement of the pilot due to physical impairment from consumption of alcohol, his inadvertent flight into known adverse weather, and his inadequate control of the aircraft during a precautionary landing. Contributing factors were: the weather conditions…NTSB FTW89FA090Accident · 2 fatalField investigationFinal reportCessna 172P · Burnet, TXContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: the adverse weather conditions and the pilot's lack of…NTSB LAX89LA102Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Santa Ynez, CAThe failure of the pilot to obtain an adequate preflight weather briefing or to obtain inflight weather advisory information, and the failure of the pilot to maintain flying speed while descending in a downdraft.NTSB BFO87FA062Accident · 2 fatalField investigationFinal reportCessna 172P · Cabin, WVThe plt was on a VFR flight at 4500 ft MSL over a mountainous area when he encountered lowering clouds. The plt descended to stay below the clouds; however, he inadvertently entered the clouds. Afterwards he tried to turn around and as he did so, according to…NTSB MKC87IA066Incident · No injuriesIncident investigationFinal reportCessna 172 · Neosho, MOThe acft had just been purchased & was being ferried from st louis, MO to san carlos, CA. The plt rprtd he was flying from springfield to tulsa, when he encountered unforecast wx & elected to divert to Neosho or return to springfield. He began a left turn…NTSB LAX87FA102Accident · 2 fatalField investigationFinal reportCessna 172P · Cuyama, CAThe plt rcvd a preflt briefing before a morning dep fm monterey. At that time, the forecast was for 3000' to 5000' broken clouds with widely scattered rain showers by 1600 & with a gen outlook of VFR. The plt flew to santa barbara to attend a meeting & depd…NTSB FTW85LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Pampa, TXPreflight weather briefing showed closest reporting station to destination below dest apch minimum of I mile visibility but fcst to improve to 1/2 mi by arrival. Area freezing level fcst at 3-4000 ft. flt to dest at 6000 ft was on top of clouds and…NTSB NYC85LA017Accident · No injuriesLimited investigationFinal reportCessna 172P · Andes, NYAccording to the plt, he encountered deteriorating visibility due to haze & he elected to land in an unimproved field. The 1st approach was aborted; however, the acft touched down on the 2nd approach. After touching down, the plt realized the field was too…NTSB CHI84FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 172P · St. Joseph, MIPieces of wreckage and the body of the plt were recovered from lake Michigan aprx 4 mi sw of st Joseph. Wx at the dep arpt was VFR but deteriorated along the route of flt over the lake due to fog becoming IMC. A caution statement printed on the chicago…NTSB FTW84LA168Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Houston, TXThe non-instrument rated plt departed dallas, TX, and was on a VFR flight plan to Houston gulf port arpt. Unable to landthere due to wx, the plt requested ATC vectors to Houston intercontinental (iah). Iah ATC gave the plt vectors for an ILS apch to rwy 08.…NTSB DEN84LA059Accident · No injuriesLimited investigationFinal reportCessna 172P · Broomfield, COThe acft collided with the ground after the pilot flew into a fog bank on final for runway 29R. The pilot was non-instrument rated and had not received a weather briefing or filed a flt plan. The acft was only airborne for a aboutan hour. The weather was 200…NTSB DEN83FA116Accident · 2 fatalField investigationFinal reportCessna 172P · Lander, WYAt noon on 5/21/83, the plt departed riverton, WY on a flt to ogden, ut to transport a minister back to riverton for a wedding. After arriving at ogden, he obtained a wx briefing for the return flt. He was warned of possible thunderstormactivity, turbulence,…