NTSB investigations: Continental C90 series, KS
18 cases on aircraft whose registry engine model is Continental C90 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.
Cases per year
| 1964 | 3 |
|---|---|
| 1965 | 3 |
| 1967 | 2 |
| 1968 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1980 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 2006 | 1 |
| 2013 | 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\" = '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 ('17009'))
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 ('17009'))
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 CEN19LA046Accident · No injuriesLimited investigationFinal reportCessna 120 · Beaumont, KSThe right brake being locked during the landing roll on the turf runway for reasons that could not be determined during postaccident examinations, which resulted in a noseover.NTSB CEN13CA411Accident · No injuriesData collectionFinal reportLuscombe 8 · Rose Hill, KSThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.NTSB DEN07CA019Accident · No injuriesData collectionFinal reportLuscombe 8F · Wellsville, KSA loss of engine power due to the ingestion of the number 2 intake valve into its cylinder. Contributing factors included the pilot allowing the airspeed and altitude to drop, making a safe landing not possible.NTSB CHI94LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Benton, KSThe failure of the student pilot to maintain directional control and proper runway alignment during the landing roll. The proximity of the ditch to the runway was a related factor.NTSB CHI92LA273Accident · Minor injuriesLimited investigationFinal reportAlon 415-A2 · Sabetha, KSThe pilot's failure to use carburetor heat.NTSB MKC81DCQ03Accident · No injuriesClosedCassutt 3M · Liberal, KSNTSB MKC80DCQ28Accident · No injuriesClosedVarieze 01 · Dodge City, KSNTSB MKC74FCG14Accident · Minor injuriesClosedLuscombe T8-F · Lenexa, KSNTSB MKC73DCQ15Accident · No injuriesClosedCessna 140 · Abilene, KSNTSB MKC68D0551Accident · No injuriesClosedCessna 140 · Arkansas Cty, KSNTSB MKC68D0291Accident · No injuriesClosedCessna 140 · Junction Cty, KSNTSB MKC68D0223Accident · Minor injuriesClosedCessna 140 · Clay Center, KSNTSB MKC66F0232Accident · Serious injuriesClosedChampion 7FC · Bonner Sprgs, KSNTSB MKC66D0240Accident · No injuriesClosedCessna 140 · Castleton, KSNTSB MKC65F0024Accident · No injuriesClosedCessna 140 · Sublette, KSNTSB UNK64X3125Accident · No injuriesClosedAir Product F1 · Winona, KSNTSB UNK64X2371Accident · No injuriesClosedCessna 140 · Santanta, KSNTSB UNK64X0179Accident · No injuriesClosedLuscombe 8F · Pierceville, KS