Skip to content

NTSB investigations: Cessna 172P, WI

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19812026

Where

Latest cases

Query with SQL

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" = 'WI' 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

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\" = 'WI' 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" = 'WI' 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

Run 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 CHI07CA132Accident · No injuriesData collectionFinal reportCessna 172P · Kenosha, WIThe pilot's improper recovery from a bounced landing, which resulted in a flat nose wheel tire and a buckled firewall. A factor was the porpoising that was encountered during the flare.May 8, 2007 · N97464 · Substantial damage NTSB CHI05FA194Accident · 1 fatalField investigationFinal reportCessna 172P · Jackson, WIThe pilot not maintaining aircraft control for undetermined reasons while maneuvering.Jul 20, 2005 · N65875 · Destroyed NTSB CHI04CA136Accident · No injuriesData collectionFinal reportCessna 172P · Milwaukee, WIThe CFI failed to maintain adequate airspeed during the go-around which resulted in an inadvertent stall.Jun 4, 2004 · N50923 · Substantial damage NTSB CHI03FA151Accident · 2 fatalField investigationFinal reportCessna 172P · Sheboygan, WIThe pilot failed to maintain control of the airplane after encountering instrument meteorological conditions during takeoff. Factors associated with the accident were the low ceiling, fog and lack of instrument rating.Jun 8, 2003 · N63319 · Destroyed NTSB CHI02LA280Accident · No injuriesLimited investigationFinal reportCessna 172P · Sturtevant, WIThe proper touchdown point not attained and the approach speed not obtained/maintained by the pilot.Sep 16, 2002 · N54091 · Substantial damage NTSB CHI02LA255Accident · No injuriesLimited investigationFinal reportCessna 172P · Buffalo City, WIThe malfunction of the seat positioning system for undetermined reasons, which resulted in the loss of directional control. A factor to the accident was the descending embankment.Aug 19, 2002 · N381J · Substantial damage NTSB CHI01LA072Accident · No injuriesLimited investigationFinal reportCessna 172P · Prairie Du Sac, WIthe improper trim setting and the pilot failed to maintain control of the airplane. A factor was the snowbank.Jan 21, 2001 · N53118 · Substantial damage NTSB CHI95LA290Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Port Washington, WIthe failure of the #2 cylinder due to fatigue cracking. A factor was the soft terrain.Aug 20, 1995 · N55404 · Substantial damage NTSB CHI93LA205Accident · No injuriesLimited investigationFinal reportCessna 172P · Hartford, WIThe failure of the number four cylinder and unsuitable terrain.Jun 14, 1993 · N55404 · Substantial damage NTSB CHI92LA173Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Ladysmith, WIFailure of the pilot to attain a proper touchdown point and the attempted abort of the precautionary landing attempt.Jun 13, 1992 · N52142 · Destroyed NTSB CHI91LA054Accident · No injuriesLimited investigationFinal reportCessna 172P · New Holstein, WIThe pilot's decision to continue the landing approach, landing on an ice covered runway and the inadequate compensation for the croswind.Jan 1, 1991 · N55409 · Substantial damage NTSB CHI91DEP02Accident · Serious injuriesFinal reportCessna 172P · Hayward, WIThe pilot-in-command's intentional flight into known adverse weather.Nov 9, 1990 · N64406 · Destroyed NTSB CHI89FA174Accident · Serious injuriesField investigationFinal reportCessna 172P · Superior, WIThe failure of the pilot to maintain directional control.Aug 17, 1989 · N98584 · Substantial damage NTSB CHI88LA193Accident · No injuriesLimited investigationFinal reportCessna 172 · Milwaukee, WIAug 7, 1988 · N65711 · Substantial damage NTSB CHI86FER07Accident · No injuriesFinal reportCessna 172P · Webster, WIShortly after lift-off, the plt noted a loss of power as the acft was climbing, about 40 ft above the rwy. He rprtd the eng 'appeared to run a little above idle.' He landed the acft on the remaining rwy, but it contd off the departure end & nosed over. No…May 17, 1986 · N99583 · Substantial damage NTSB CHI86LA002Accident · No injuriesLimited investigationFinal reportCessna 172 · Crivitz, WIThe plt lost directional control of the acft during the landing roll in x-wind conditions. As the acft veered to the left side of the rwy it struck a rwy light. The arpt owner stated the acft touched down in a crabbed position and the local winds were from…Oct 2, 1985 · N52142 · Substantial damage NTSB CHI82DA277Accident · Minor injuriesFinal reportCessna 172P · Bruce, WIThe pilot departed an alfalfa field that was eight inches high and heavily saturated with dew. A witness stated that upon takeoff the nose of the aircraft was abruptly raised, the aircraft rose about 50 feet, the left wing dropped, the aircraft descended, and…Jul 28, 1982 · N53056 · Substantial damage NTSB CHI82DA251Accident · Serious injuriesFinal reportCessna 172P · Washington Island, WIDuring arrival, the pilot made an approach to runway 14 for a night landing. After flaring to land, the aircraft was observed to float. The pilot stated that he had come in high, and during a go-around, the aircraft did not seem to climb properly, then…Jul 17, 1982 · N64947 · Destroyed NTSB CHI81DEP12Accident · No injuriesClosedCessna 172P · New Glarus, WIMar 14, 1981 · N51984 · Substantial damage