Skip to content

NTSB investigations: Cessna 172N, KS

29 cases on aircraft the registry lists as Cessna 172N. 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

19662026

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" = 'KS' 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 ('2072434')) 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\" = 'KS' 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 ('2072434'))
  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" = 'KS' 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 ('2072434'))
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 GAA15CA274Accident · No injuriesData collectionFinal reportCessna 172N · Herington, KSThe pilot's failure to maintain pitch control during the landing roll, which resulted in a porpoise.Sep 16, 2015 · N909HC · Substantial damage NTSB CEN12CA315Accident · Minor injuriesData collectionFinal reportCessna 172N · Wichita, KSThe student pilot’s failure to maintain airplane control during landing and the flight instructor’s delayed remedial action, which resulted in a collision with terrain.May 25, 2012 · N73743 · Substantial damage NTSB CEN09LA182Accident · No injuriesLimited investigationFinal reportCessna 172N · Johnson County Exec Airport, KSFailure of the pilot of the Cessna 172S to ensure the taxiway was clear prior to initiating the turn. Contributing to the accident was the failure of the pilot of the Cessna 172N to obtain taxi clearance prior to entering the movement area.Feb 25, 2009 · N734WD · 2 aircraft · Substantial damage NTSB CEN09CA229Accident · No injuriesData collectionFinal reportCessna 172 · Manhattan, KSThe pilot's improper recovery from a bounced landing.Feb 22, 2009 · N733FR · Substantial damage NTSB DEN07CA043Accident · No injuriesData collectionFinal reportCessna 172N · Cottonwood Fall, KSthe pilot's failure to maintain clearance from the fence. Contributing to the accident was the pilot's inability to properly identify the runway environment, and the improper in-flight decision to initiate a go-around.Dec 24, 2006 · N4811G · Substantial damage NTSB CHI03FA071Accident · 1 fatalField investigationFinal reportCessna 172N · Wellington, KSSpatial disorientation experienced by the pilot and his subsequent failure to maintain control of the aircraft. Contributing factors were the pilot's failure to obtain an updated preflight weather briefing prior to the return flight, his attempted flight into…Feb 15, 2003 · N5898E · Destroyed NTSB CHI01FA130Accident · 2 fatalField investigationFinal reportCessna 172N · Wichita, KSthe student pilot not maintaining clearance from the tower support wire during the practice emergency landing maneuver and the instructor pilot's inadequate supervision of the student pilot. Factors relating to the accident were the static wire and the low…May 6, 2001 · N733RK · Destroyed NTSB CHI91LA023Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Scott, KSThe mixture control was set incorrectly resulting in fuel starvation, and the check list was not followed by the cfi/pic.Nov 3, 1990 · N739VN · Substantial damage NTSB MKC87LA073Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Halstead, KSThe PIC rptd lndg long on a 2600 ft sod rwy. During the lndg roll, the PIC rptd encountering a tailwind. The closest fss at wichita, 20 mi fm the accident arpt, rptd no significant wind chg during this period, the PIC, knowing that he had landed long and…Apr 1, 1987 · N733PX · Substantial damage NTSB MKC86LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Salina, KSThe pilot did not top off the fuel tanks before departing lincoln, NE for pratt, KS. Enroute winds necessitated a fuel stop at Salina, KS. These same winds flipped over the airplane as it was turning off the runway to taxi in.Oct 7, 1985 · N1587E · Substantial damage NTSB MKC84LA244Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Osage City, KSThe pilot stated that during an aborted takeoff, due to an engine power loss, he was not able to stop before running off the end of the 2600 foot long runway. He said that when he felt that the airplane was ready to fly he glanced down at instrument panel and…Aug 9, 1984 · N444ZH · Substantial damage NTSB MKC84LA212Accident · No injuriesLimited investigationFinal reportCessna 172 · Beuamont, KSThe plt was taking off to the north on a sod rwy with a light, northeast wind. The rwy was outlined with old automobile tires. The plt elected to use the left side of the rwy, since it appeared to be smoother. After lift-off, the acft drifted left & the left…Jul 11, 1984 · N21AT · Substantial damage NTSB MKC83LA220Accident · No injuriesLimited investigationFinal reportCessna 172N · Morland, KSWhile landing on a country road, the acft landing gear encounter a sand pit on the road. The plt reported that the plane ground looped on the sand, ran into a ditch & hit a tree.Sep 17, 1983 · N739HK · Substantial damage NTSB MKC83FA024Accident · 1 fatalField investigationFinal reportCessna 172 · Wamego, KSA witness observed the acft flying low along the Kansas river for about 2 mi just before the accident. He stated that the acft was flying below the tops of trees bordering the river. The two lower strands of a power line, which crosses the river, were found…Nov 20, 1982 · N3599E · Destroyed NTSB MKC82FCQ12Accident · Serious injuriesFinal reportCessna 172 · Medicine Lodge, KSThe acft stalled while the plt was buzzing his grandfather's fishing cabin on a lake.Jul 14, 1982 · N75802 · Destroyed NTSB MKC82DA049Accident · No injuriesFinal reportCessna 172 · Jetmore, KSThe aircraft was flown out to an oil well site to air drop a valve. The pilot stated that after dropping the valve he turned around in his seat to see where the valve hit and he ran the aircraft into the ground.Mar 22, 1982 · N4915F · Substantial damage NTSB MKC82FA023Accident · 1 fatalField investigationFinal reportCessna 172N · 5m E. Greensbur, KSThe plt received a wx briefing for a flt to dodge city,KS. The fss specialist asked the plt if he was proposing his flight under IFR since his destination was reporting IMC. The plt replied that he was. A ground witness at haviland,KS located about 5 miles…Jan 29, 1982 · N1589E · Destroyed NTSB MKC81FA036Accident · 2 fatalClosedCessna 172 · Carbondale, KSMay 22, 1981 · N4509E · Destroyed NTSB MKC80DCQ32Accident · No injuriesClosedCessna 172 · Wichita, KSSep 1, 1980 · N6592D · Substantial damage NTSB MKC80DCQ20Accident · No injuriesClosedCessna 172 · Coldwater, KSJun 16, 1980 · N1297F · Substantial damage NTSB MKC79DCQ46Accident · No injuriesClosedCessna 172 · Wichita, KSSep 16, 1979 · N2234E · Substantial damage NTSB MKC79DCQ43Accident · No injuriesClosedCessna 172N · Wichita, KSAug 21, 1979 · N738AT · Substantial damage NTSB MKC79DCG43Accident · No injuriesClosedCessna 172 · Lawrence, KSMay 16, 1979 · N566Q · Substantial damage NTSB MKC79FA023Accident · Serious injuriesClosedCessna 172 · Liberal, KSMar 22, 1979 · N2029E · 2 aircraft · Destroyed NTSB MKC78DCQ11Accident · No injuriesClosedCessna 172 · Phillipsburg, KSDec 27, 1977 · N75556 · Substantial damage NTSB MKC78DCQ09Accident · No injuriesClosedCessna 172N · Wichita, KSDec 17, 1977 · N738KL · Substantial damage NTSB MKC78DCG03Accident · No injuriesClosedCessna 172 · Lawrence, KSOct 8, 1977 · N737DC · Substantial damage NTSB MKC77DCQ59Accident · No injuriesClosedCessna 172 · Kiowa, KSSep 22, 1977 · N733XB · Substantial damage NTSB MKC66D0394Accident · No injuriesClosedCessna 337 · Arkansas City, KSJan 3, 1966 · N6258F · Substantial damage