Skip to content

NTSB investigations: Continental 0-300 series, KS

64 cases on aircraft whose registry engine model is Continental 0-300 series. 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

NTSB investigations: Continental 0-300 series, KS per year, 1964–2026: 64 cases
1964	7
1965	3
1966	5
1967	9
1968	3
1969	2
1970	3
1971	2
1972	2
1973	3
1974	2
1975	1
1976	4
1978	4
1979	1
1981	1
1986	1
1988	1
1990	1
1991	1
1994	1
2004	1
2006	1
2007	1
2015	1
2020	1
2023	2

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.engine_model_code IN ('17022')) 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.engine_model_code IN ('17022'))
  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.engine_model_code IN ('17022'))
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 CEN24LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna 172C · Wichita, KSThe pilot’s inadequate preflight inspection and fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.Oct 20, 2023 · N1413Y · Substantial damage 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 GAA15CA136Accident · No injuriesData collectionFinal reportCessna 172H · Cottonwood Falls, KSThe pilot's failure to attain adequate airspeed to climb the airplane out of ground effect, which resulted in an aerodynamic stall and a collision with terrain.Jun 6, 2015 · N2536L · Substantial damage NTSB DEN07CA076Accident · No injuriesData collectionFinal reportCessna 172E · Pleasanton, KSThe pilot's failure to maintain control of the airplane during a go-around. Contributing factors were the gusts and crosswinds.Mar 16, 2007 · N5759T · Substantial damage NTSB DEN06CA032Accident · Minor injuriesData collectionFinal reportCessna 170B · Ulysses, KSthe pilot's failure to maintain directional control during the landing, resulting in a ground loop.Jan 7, 2006 · N2912D · Substantial damage NTSB CHI04CA121Accident · No injuriesData collectionFinal reportCessna 172C · Fort Leavenwort, KSThe inadequate flare by the pilot.May 15, 2004 · N1806Y · Substantial damage NTSB CHI94LA153Accident · No injuriesLimited investigationFinal reportMaule M-4 · Salina, KSFailure of the pilot to maintain directional control, which resulted in an inadvertent ground loop/swerve. Factors related to the accident were: the crosswind, and the pilot's lack of experience in the make and model of aircraft.May 9, 1994 · N12016 · 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 CHI91LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Emporia, KSGusty crosswinds, excessive flap setting, and lack of total experience in type of operation.Oct 4, 1990 · N3226L · 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 MKC86LA178Accident · 1 fatalLimited investigationFinal reportCessna 172 · Emporia, KSThe acft was found stopped in an open field having penetrated the southern boundary of the Emporia airport property. The acft eng was still running when rescuers approached the location. Forced entry was made into the acft to shut the eng down and rescue the…Aug 26, 1986 · N3791R · Minor damage NTSB MKC81DCG25Accident · No injuriesClosedCessna 172H · St Marys, KSMar 23, 1981 · N8239L · 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 MKC78FCG30Accident · No injuriesClosedCessna 170B · Overbrook, KSMay 15, 1978 · N4411B · Substantial damage NTSB MKC78FA029Accident · 2 fatalClosedCessna 172 · Leawood, KSMar 19, 1978 · N6892A · Destroyed NTSB MKC78DCQ17Accident · No injuriesClosedCessna 172A · Syracuse, KSMar 13, 1978 · N7649T · Substantial damage NTSB MKC77DCQ06Accident · Minor injuriesClosedCessna 172 · Fort Scott, KSNov 16, 1976 · N6640A · Substantial damage NTSB MKC76DCQ45Accident · No injuriesClosedCessna 172F · Belmont, KSApr 18, 1976 · N8646U · Substantial damage NTSB MKC76DCQ33Accident · No injuriesClosedCessna 172 · Maize, KSFeb 19, 1976 · N1415Y · Substantial damage NTSB MKC76DCQ28Accident · No injuriesClosedCessna 172 · Marion, KSJan 29, 1976 · N7570X · Substantial damage NTSB MKC75FCG51Accident · Minor injuriesClosedCessna 172 · Leawood, KSJun 20, 1975 · N5586R · Substantial damage NTSB MKC75DCQ26Accident · No injuriesClosedCessna 172 · Conway, KSDec 12, 1974 · N8857B · Substantial damage NTSB MKC74DCG34Accident · No injuriesClosedCessna 172 · Horton, KSMay 4, 1974 · N1638F · Substantial damage NTSB MKC74DCG17Accident · No injuriesClosedCessna 172 · Leawood, KSDec 26, 1973 · N8713B · Substantial damage NTSB MKC74DCQ14Accident · No injuriesClosedCessna 172 · Inman, KSSep 10, 1973 · N3734F · Substantial damage NTSB MKC73DCG38Accident · No injuriesClosedCessna 172 · Leavenworth, KSApr 19, 1973 · N7733T · Substantial damage NTSB MKC72FCG51Accident · Minor injuriesClosedCessna 172H · Gardner, KSMay 4, 1972 · N3864R · Destroyed NTSB MKC72DCQ49Accident · No injuriesClosedCessna 172 · Norton, KSApr 13, 1972 · N5339R · Substantial damage NTSB MKC72DCG21Accident · Minor injuriesClosedCessna 172 · Topeka, KSSep 12, 1971 · N1345Y · Substantial damage NTSB MKC71FCG66Accident · No injuriesClosedCessna 172D · Olathe, KSMay 17, 1971 · N2526U · Substantial damage NTSB MKC71DCQ06Accident · No injuriesClosedCessna 172E · Lincoln, KSJul 25, 1970 · N5560T · Substantial damage NTSB MKC71DCQ04Accident · No injuriesClosedCessna 172 · Clay Center, KSJul 18, 1970 · N2990U · Substantial damage NTSB MKC70DCQ13Accident · No injuriesClosedCessna 172 · Arkansas Cty, KSMar 25, 1970 · N8646U · Substantial damage NTSB MKC69D0458Accident · No injuriesClosedCessna 172H · Manhattan, KSMay 21, 1969 · N2663L · Substantial damage NTSB MKC69F0306Accident · Serious injuriesClosedCessna 172E · Wamego, KSJan 2, 1969 · N3788S · Substantial damage NTSB MKC69D0013Accident · No injuriesClosedCessna 172B · Osborne, KSJun 10, 1968 · N7712X · 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 MKC68D0370Accident · No injuriesClosedCessna 172G · St.Francis, KSDec 7, 1967 · N3735L · Substantial damage NTSB MKC68D0201Accident · No injuriesClosedCessna 172C · Clyde, KSAug 13, 1967 · N9151B · Substantial damage NTSB MKC68D0247Accident · No injuriesClosedCessna 172G · Eudora, KSAug 6, 1967 · N3682L · Substantial damage NTSB MKC68F0097Accident · Minor injuriesClosedCessna 172 · Augusta, KSJun 14, 1967 · N3919L · Destroyed 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 MKC67F0605Accident · Minor injuriesClosedCessna 172 · Topeka, KSApr 30, 1967 · N2457L · Substantial damage NTSB MKC67D0474Accident · No injuriesClosedCessna 172 · Severance, KSMar 4, 1967 · N1343Y · Substantial damage NTSB MKC67D0329Accident · No injuriesClosedCessna 172 · Topeka, KSOct 29, 1966 · N5947A · Substantial damage