NTSB investigations: Cessna 140, KS
30 cases on aircraft the registry lists as Cessna 140. 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 | 4 |
|---|---|
| 1965 | 2 |
| 1966 | 2 |
| 1967 | 4 |
| 1968 | 1 |
| 1971 | 1 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 3 |
| 1975 | 1 |
| 1977 | 1 |
| 1980 | 1 |
| 1983 | 1 |
| 1988 | 2 |
| 1996 | 1 |
| 2006 | 1 |
| 2010 | 1 |
| 2019 | 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.aircraft_model_code IN ('2071602', '2071603'))
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 ('2071602', '2071603'))
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 CEN19LA111Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Newton, KSThe loss of engine power after the No. 1 connecting rod end separated as a result of oil starvation, which led to the forced landing and nose-over.NTSB CEN10LA281Accident · No injuriesLimited investigationFinal reportCessna 140 · Atchison, KSThe loss of engine power for undetermined reasons.NTSB DEN06CA106Accident · No injuriesData collectionFinal reportCessna 140 · Cunningham, KSthe pilot's failure to maintain directional control during the aborted takeoff. A contributing factor was the mud.NTSB CHI96LA111Accident · No injuriesLimited investigationFinal reportCessna 140 · Ulysses, KSFailure of the pilot to maintain directional control of the airplane during the takeoff roll, and his improper use of brakes and elevator control, while aborting the takeoff. A factor relating to the accident was the gusty wind condition.NTSB MKC89LA009Accident · No injuriesLimited investigationFinal reportCessna 140 · Lawrence, KSThe plt elected to terminate a local flt due to windy, turbulent conditions aloft. He initiated a landing in a slight crosswind that he rprtd was gusting to 20 knots. Drg the landing, he lost control & the acft touched down hard in a nose low attitude.…NTSB MKC89LA002Accident · No injuriesLimited investigationFinal reportCessna 140 · Quinter, KSThe pilot was flying at reduced power without the use of carburetor heat. The aircraft engine began to run rough. The pilot added carburetor heat and full throttle which resulted in the engine backfiring. The pilot elected to execute a precautionary landing.…NTSB MKC83FA165Accident · Serious injuriesField investigationFinal reportCessna 140 · Pratt, KSThe acft stalled and crashed in a plowed field during an aerial application flt while dispensing wasp eggs on a corn field. The eggs were carried in plastic tubes in a styrofoam ice chest behind the seat and were transferred by the plt as needed to the…NTSB MKC80DCQ27Accident · No injuriesClosedCessna 140 · El Dorado, KSNTSB MKC77DCQ28Accident · No injuriesClosedCessna 140 · Kirwin, KSNTSB MKC76FCG22Accident · No injuriesClosedCessna 140 · Mission, KSNTSB MKC75FCQ16Accident · Serious injuriesClosedCessna 140 · Moline, KSNTSB MKC75DCQ11Accident · No injuriesClosedCessna 140 · Argonia, KSNTSB MKC74DCG45Accident · Minor injuriesClosedCessna 140 · Paola, KSNTSB MKC74DCQ09Accident · No injuriesClosedCessna 140 · Goodland, KSNTSB MKC73DCQ15Accident · No injuriesClosedCessna 140 · Abilene, KSNTSB MKC72DCG69Accident · No injuriesClosedCessna 140 · Topeka, KSNTSB MKC72FCQ29Accident · No injuriesClosedCessna 140 · Mcdonald, KSNTSB MKC68D0551Accident · No injuriesClosedCessna 140 · Arkansas Cty, KSNTSB MKC68D0291Accident · No injuriesClosedCessna 140 · Junction Cty, KSNTSB MKC68D0223Accident · Minor injuriesClosedCessna 140 · Clay Center, KSNTSB MKC67D0614Accident · No injuriesClosedCessna 140 · Bonner Sprgs, KSNTSB MKC67F0580Accident · Minor injuriesClosedCessna 140 · Lakin, KSNTSB MKC66F0473Accident · Minor injuriesClosedCessna 140 · Miltonvale, KSNTSB MKC66D0491Accident · Minor injuriesClosedCessna 140 · Coffeyvill, KSNTSB MKC66D0281Accident · Minor injuriesClosedCessna 140 · Holton, KSNTSB MKC66D0240Accident · No injuriesClosedCessna 140 · Castleton, KSNTSB UNK65X1074Accident · No injuriesClosedCessna 140 · Bonner Springs, KSNTSB UNK64X3942Accident · No injuriesClosedCessna 140 · Bloom, KSNTSB UNK64X2371Accident · No injuriesClosedCessna 140 · Santanta, KSNTSB UNK64X0546Accident · No injuriesClosedCessna 140 · Topeka, KS