Skip to content

NTSB investigations: Cessna 172, KS

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

19642026

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 ('2072402')) 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 ('2072402'))
  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 ('2072402'))
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 CEN23LA366Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Derby, KSThe pilot’s loss of directional control during takeoff roll due the passenger’s interference with the rudder pedals, which resulted in a runway excursion.Aug 11, 2023 · N6205E · Substantial damage NTSB CEN21LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Geuda Springs, KSThe pilot’s failure to determine the airplane’s takeoff performance from an off-airport field which resulted in an aborted takeoff and impact with a fence and terrain. Contributing to the accident was the delayed aborted takeoff.Oct 24, 2020 · N5910A · Substantial damage NTSB CHI93LA138Accident · No injuriesLimited investigationFinal reportCessna 172N · Towanda, KSThe pilot failed to adequately compensate for a gusty crosswind condition.Apr 10, 1993 · N6346E · Substantial damage NTSB CHI91LA243Accident · No injuriesLimited investigationFinal reportCessna 172 · Oberlin, KSThe student pilot's failure to maintain directional control during landing. Factors in the accident were the pilot's discontinuing his crosswind compensation and his lack of experience in the type of operation.Jul 30, 1991 · N7113A · Substantial damage NTSB MKC88LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Concordia, KSWhile attempting a crosswind landing, PIC decided to make a go-around. During the go-around the acft stalled, struck the terrain and cartwheeled.May 12, 1988 · N8240B · Substantial damage NTSB MKC81FCQ29Accident · Serious injuriesClosedCessna 172 · Cullison, KSApr 18, 1981 · N8379B · Destroyed NTSB MKC80DCG48Accident · No injuriesClosedCessna 172 · Holton, KSSep 29, 1980 · N7424A · Substantial damage NTSB MKC79DCQ40Accident · No injuriesClosedCessna 172 · Sharon Springs, KSJul 27, 1979 · N7129T · Substantial damage NTSB MKC79DCQ07Accident · No injuriesClosedCessna 172 · Sedgwick, KSDec 27, 1978 · N6161E · Substantial damage NTSB MKC78FA029Accident · 2 fatalClosedCessna 172 · Leawood, KSMar 19, 1978 · N6892A · Destroyed NTSB MKC77DCQ06Accident · Minor injuriesClosedCessna 172 · Fort Scott, KSNov 16, 1976 · N6640A · Substantial damage NTSB MKC75DCQ26Accident · No injuriesClosedCessna 172 · Conway, KSDec 12, 1974 · N8857B · Substantial damage NTSB MKC74DCG17Accident · No injuriesClosedCessna 172 · Leawood, KSDec 26, 1973 · N8713B · Substantial damage NTSB MKC71AK033Accident · 3 fatalClosedCessna 172 · Garden City, KSDec 15, 1970 · N6064A · Destroyed NTSB MKC69F0221Accident · Serious injuriesClosedCessna 172 · Wakeeney, KSOct 15, 1968 · N6064A · Substantial damage NTSB MKC68F0482Accident · Serious injuriesClosedCessna 172 · Dodge City, KSMar 17, 1968 · N8364B · Substantial damage NTSB MKC68D0483Accident · No injuriesClosedCessna 172 · Chanute, KSMar 14, 1968 · N4078F · Substantial damage NTSB MKC68D0389Accident · No injuriesClosedCessna 172 · Ames, KSDec 20, 1967 · N7048T · Substantial damage NTSB MKC68D0201Accident · No injuriesClosedCessna 172C · Clyde, KSAug 13, 1967 · N9151B · Substantial damage NTSB MKC68D0070Accident · No injuriesClosedCessna 172 · Kinsley, KSMay 18, 1967 · N5639A · Substantial damage NTSB MKC68D0032Accident · No injuriesClosedCessna 172H · Dighton, KSMay 18, 1967 · N7129T · Substantial damage NTSB MKC67D0431Accident · No injuriesClosedCessna 172 · Onaga, KSFeb 11, 1967 · N8331B · Substantial damage NTSB MKC67D0329Accident · No injuriesClosedCessna 172 · Topeka, KSOct 29, 1966 · N5947A · Substantial damage NTSB MKC66F0167Accident · No injuriesClosedCessna 172 · Wichita, KSAug 15, 1965 · N5945A · Substantial damage NTSB UNK65X0985Accident · Minor injuriesClosedCessna 172 · Larned, KSDec 12, 1964 · N8812B · Destroyed NTSB UNK64X3316Accident · No injuriesClosedCessna 172 · Hill City, KSAug 10, 1964 · N8812B · Substantial damage NTSB UNK64X1755Accident · No injuriesClosedCessna 172 · El Dorado, KSMay 13, 1964 · N6938A · Substantial damage