NTSB investigations: Cessna 172P, NC
19 cases on aircraft the registry lists as Cessna 172P. 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 | 2 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 3 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2015 | 1 |
| 2018 | 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.\"eventStateOrRegion\" = 'NC' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072436'))
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."eventStateOrRegion" = 'NC' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072436'))
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 GAA19CA087Accident · No injuriesData collectionFinal reportCessna 172 · Monroe, NCThe student pilot's improper landing flare, which resulted in a hard, bounced landing and nose landing gear collapse.NTSB ERA15FA351Accident · 1 fatalField investigationFinal reportCessna 172 · Riegelwood, NCThe noncertificated pilot’s failure to maintain adequate clearance from terrain for reasons that could not be determined based on the available evidence.NTSB ATL06CA047Accident · No injuriesData collectionFinal reportCessna 172 P · Wilmington, NCThe student pilot's improper landing flare which resulted in a hard landing.NTSB ATL03LA060Accident · No injuriesLimited investigationFinal reportCessna 172P · Concord, NCThe pilot's improper flare during touchdown and failure to properly recover from a bounced landing, which resulted in a loss of control and inflight collision with the runway. A factor was the pilot did not understand the porpoise condition during landing.NTSB ATL02LA168Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Mocksville, NCThe pilot's failure to maintain airspeed during the takeoff and initial climb which resulted in an inadvertent stall and the subsequent collision with trees.NTSB ATL98LA132Accident · No injuriesLimited investigationFinal reportCessna 172P · Farmville, NCThe pilot's failure to maintain directional control of the aircraft and his improper use of the brakes, which led to the aircraft departing the left side of the runway. Contributing factors were the wet runway and the vehicle.NTSB ATL96LA086Accident · No injuriesLimited investigationFinal reportCessna 172 · Winston-Salem, NCThe pilot's improper use of the elevator in response to a bounced landing.NTSB ATL94LA125Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Kitty Hawk, NCThe pilot's improper compensation for the wind conditions, his improper recovery from a bounced landing, and the inadvertent stall. Factors were the wind conditions and the trees that bounded the runway.NTSB ATL92FA053Accident · 2 fatalField investigationFinal reportCessna 172P · N Topsail Beach, NCThe failure of the pilot to obtain and/or maintain adequate airspeed during takeoff, which resulted in an inadvertent stall and collision with the ground. Factors were: the failure of the pilot to follow procedures/directives, his operation of the aircraft…NTSB ATL92LA028Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Ramseur, NCThe pilot's improper compensation for the wind conditions. The gusty crosswind was a factor in the accident.NTSB ATL91LA139Accident · No injuriesLimited investigationFinal reportCessna 172P · Sylva, NCThe pilot's improper in-flight planning, and his failure to maintain a proper altitude while maneuvering in the canyon. Factor(s) in this accident were: the mountainous, box canyon conditions, the high density altitude, and the downdraft conditions at the…NTSB ATL91LA082Accident · No injuriesLimited investigationFinal reportCessna 172P · Hatteras, NCThe pilot's improper landing flare, subsequent inadvertent porpoise, and his failure to execute a bounced landing recovery.NTSB ATL89DMG02Accident · Minor injuriesFinal reportCessna 172P · Mooresville, NCFailure of the pilot to maintain airspeed on final approach to land, which resulted in an inadvertent stall. Factors related to the accident were: carburetor icing conditions, night conditions, and the pilot's decision to land at an unlighted runway.NTSB ATL87LA176Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Marion, NCThe acft overran the rwy end while the student plt was attempting a no-flap ldg. The acft impacted a berm at the end of the rwy and subsequently came to rest in a creek. The student plt reported that the acft had initially touched down about mid-field on the…NTSB ATL86LA180Accident · No injuriesLimited investigationFinal reportCessna 172P · Salisbury, NCThe plt reported that the engine lost power and quit shortly after T/0 at about 500-700 ft AGL. He checked the mixture, carb heat and mags but was unable to restart the engine. A 180 turn was made back to the arpt. The plt stated that he let the airspeed…NTSB ATL85LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Southern Pines, NCThe acft stalled during a practice go-around attempt at a private airstrip. The plt stated that he applied full throttel after descending to about 20 ft above the rwy during the practice go-around. He stated that he then tried to push the carb heat control…NTSB ATL83FA182Accident · Serious injuriesField investigationFinal reportCessna 172P · Gastonia, NCThe acft stalled into the ground just short of the rwy and collapsed the nose gear. The pilot was flying from the right seat so his female passenger could use the more adjustable left seat. The pilot stated that at 70 KTS on final approach for a landing the…NTSB ATL83FKM01Accident · 1 fatalFinal reportCessna 172P · Near Maider, NCThe pilot crashed into trees 6 miles east of maiden, NC in deteriorating weather. Witnesses described the weather as rainy and foggy in the area of crash. Some heard the aircraft flying low before colliding with trees. The pilot was off course for statesville…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…