NTSB investigations, KS
12 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 3 |
| 1991 | 1 |
| 1995 | 2 |
| 2000 | 1 |
| 2002 | 1 |
| 2007 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 354)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 354) 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 DEN08LA041Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Phillipsburg, KSTotal loss of engine power due to contamination of the carburetor, total blockage of the fuel inlet screen, and partial blockage of the fuel lines and fittings. Contributing to the accident were the dark night light conditions and the trees.NTSB CHI02LA223Accident · No injuriesLimited investigationFinal reportCessna A188B · Nickerson, KSFuel starvation due to the fuel contamination, the blocked fuel strainer, and the refueling truck's contaminated fuel. A factor was the berm.NTSB CHI00LA137Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Ionia, KSthe partial engine failure for undetermined reasons and the unsuitable terrain for landing encountered by the pilot. A factor to the accident was the hilly terrain condition.NTSB CHI95LA336Accident · No injuriesLimited investigationFinal reportCessna T210M · Dodge City, KSthe pilot's improper use of the auxiliary fuel boost pump during descent which led to fuel flooding and loss of combustion.NTSB CHI95LA223Accident · No injuriesLimited investigationFinal reportCessna 182C · Derby, KSthe pilot's improper use of the powerplant controls, which resulted in a rough running engine and partial loss of engine power.NTSB CHI91LA290Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, KSThe pilot's failure to assure an adequate fuel supply was on board the airplane which resulted in fuel exhaustion. A factor related to the accident was inaccurate preflight planning.NTSB MKC89LA047Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Derby, KSDrg an eng run-up before a simulated instrument flt, the crew noticed the carb heat control would only move about 1/2 of its normal travel. The plts discussed the malfunction & ran the eng for another 1 to 2 min until the oil temp gauge indcd a temp rise. Drg…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 MKC88FA042Accident · 1 fatalField investigationFinal reportGulfstream 500B · Pierceville, KSThe acft dptd garden city under extremely poor wx cond's. more than half way to dodge city, the PIC rptd eng pblms to Kansas city (ARTCC). Vectors were provided to the dodge city arpt, but the PIC did not maintain assigned hdgs. The acft headed back towards…NTSB MKC88LA010Accident · No injuriesLimited investigationFinal reportCessna 182 · Atwood, KSThe PIC said that he did an engine runup and allowed the engine to run about 6 additional minutes before commencing the takeoff. The PIC said that upon reaching 100 feet altitude in the takeoff sequence, he observed a decline in engine revolutions per minute…NTSB MKC86LA157Accident · No injuriesLimited investigationFinal reportRandolph R.Clark KR-2 · Russell, KSThe pilot had just completed some adjustments to the carburetor and was making a high-speed taxi test when he became airborne. He applied more power to avoid stalling and immediately thereafter, the engine started running rough. He then decided to make a…NTSB MKC83LA224Accident · No injuriesLimited investigationFinal reportBeech A36 · Oberlin, KSThe plt stated he was flying near his relatives' house when he switched fuel tanks and the eng began running rough. The plt suspected the magnetos since they had recently been serviced. The plt switched fuel tanks again with the boost pumpson and the engine…