NTSB investigations, KS
20 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1990 | 2 |
| 1996 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 2 |
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\" = 352)
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" = 352) 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 DEN07LA149Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Newton, KSThe failure of the exhaust gasket on the number 6 cylinder for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN07LA083Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Topeka, KSThe use of unapproved bolts to mount the crankshaft and gear together, causing fatigue and failure of those mounting bolts, resulting in the subsequent loss of engine power. Factors contributing to the accident were the separation of the crankshaft gear, and…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 CHI05LA178Accident · No injuriesLimited investigationFinal reportCessna 210E · La Gygne, KSThe failure of the throttle control cable which resulted from wear followed by fatigue cracking. A factor associated with the accident was the corn crop which the airplane contacted during the forced landing.NTSB CHI01LA101Accident · No injuriesLimited investigationFinal reportCessna P206 · Derby, KSThe misjudged in-flight planning the pilot had for the forced landing. Factors were the induction air ducting separation, the pilot not coordinating his emergency procedure with airfield traffic, and the trees.NTSB CHI98LA264Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Hoxie, KSthe total failure of the engine's left magneto.NTSB CHI96LA261Accident · No injuriesLimited investigationFinal reportCessna 188B · Cimarron, KSthe pilot's failure to make a timely decision to abort the takeoff or dump the payload.NTSB MKC90LA128Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ulysses, KSFailure of the powerplant cylinder and stall/mush encountered by the pilot in command.NTSB MKC90LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Herington, KSFailure of the #2 exhaust valve, and improper flare by the pilot during the forced landing.NTSB MKC89LA045Accident · No injuriesLimited investigationFinal reportCessna 175 · Lawrence, KSThe plt said that shortly after takeoff, the engine began to misfire and lose power. He elected to abort the takeoff, but was unable to stop on the remaining portion of the runway. He ran off the end, into a farm field, where the acft nosed down and was…NTSB MKC87LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ottawa, KSDuring a night flight the aircraft's engine lost partial power. The pilot elected to make a precautionary landing in a farm field. During landing the aircraft's right wing struck a fence. An engine teardown revealed a failed exhaust valve on the number 3…NTSB MKC87LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Meade, KSAfter takeoff, the engine started losing power. During the turn toward a landing area, the airplane stalled, hit the ground to the right of the runway and flipped forward to the inverted position. A partial tear down inspection revealed that the intake valve…NTSB MKC86LA131Accident · No injuriesLimited investigationFinal reportCharles S.Hatchette Quickie Q2 · Goodland, KSThe pilot experienced a gradual loss of engine power during cruise and made a forced landing to a field. During the landing roll, the plane hit a hole and nosed over. Examination found that a fuel vent line had melted closed in the vicinity of the exhaust…NTSB MKC85FA168Accident · 1 fatalField investigationFinal reportSchubert Cassutt Sport · Admire, KSAt 0847 CDT, July 27, 1985 N1115G radioed a nearby fss. The station that was called was closed but another fss heard thecall. During the transmission the plt reported that he had an eng problem, was pumping oil overboard and could not see outside because the…NTSB MKC84LA190Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Atwood, KSDuring a swath run, the eng began losing power. The plt pulled up & looked for a place to land, then dumped his chemical load. Eng RPM continued decreasing so he elected to land in a field that was being summer fallowed. During the landing, the acft nosed…NTSB MKC84LA134Accident · No injuriesLimited investigationFinal reportBeech BE23 · Richmond, KSWhile in cruise on a ferry flight the engine lost power and would only develop partial power. The power degraded to the point that insuficient power was available to maintain flight. The pilot landed in a field and substantial damage occured. Post accident…NTSB MKC84IA040Incident · No injuriesIncident investigationFinal reportDouglas DC-9-15 · Wichita, KSA catastrophic (uncontainted) failure of the left engine occurred at the beginning of the takeoff roll. The takeoff was aborted & fire erupted on the taxi back to the gate. Investigation revealed a broken turbine long shaft.NTSB MKC82DA145Accident · No injuriesFinal reportCessna 150J · Conway Springs, KSThe aircraft engine lost power during landing and the aircraft hit trees 100 yards short of the runway. Post-accident examination disclosed low compression on 3 cylinders and none on number four cylinder. The engine had been low on RPM since the beginning of…NTSB MKC82FA095Accident · No injuriesField investigationFinal reportBeech 65-90 · Wichita, KSThe plt detected a loss of eng torque at about rotation airspeed about 1700 ft down the rwy & the takeoff was aborted. The acft slid into a ditch off the end of the rwy collapsing the main gear. A functional check of the right eng fuel pump, P/N4V146R002,…NTSB MKC82FCQ09Accident · 2 fatalFinal reportLuscombe 8A · Fredonia, KSThe aircraft crashed after taking off on a test flight. A witness reported that the aircraft was in a steep angle of climb, and the nose pitched down as the pilot was making a left turn. The witness reported that the pilot had been adjusting the magnetos…