NTSB investigations, KS
53 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 7 |
| 1984 | 7 |
| 1985 | 1 |
| 1986 | 5 |
| 1987 | 2 |
| 1988 | 3 |
| 1990 | 2 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 4 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 4 |
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\" = 130)
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" = 130) 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 DEN08LA038Accident · No injuriesLimited investigationFinal reportRotorway Exec 162-F · New Century, KSWhile on approach the tail rotor spar failed due to metal fatigue .NTSB DEN08IA030Incident · No injuriesIncident investigationFinal reportBeech C90A · Emporia, KSThe improper installation of the right elevator trim tab attachment hardware by maintenance personnel which resulted in excessive wear, fatigue, and the failure of the push-pull tube.NTSB DEN07LA160Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lawrence, KSTotal failure of the landing gear retraction/extension assembly. Contributing factors in this accident were worn parts in the landing gear retraction/extension assembly, and mechanical binding of the extension assembly.NTSB DEN07LA044Accident · Serious injuriesLimited investigationFinal reportMarino Exec 162F-1995 · Baldwin City, KSthe failure of the tail rotor drive belt for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06CA054Accident · No injuriesData collectionFinal reportCessna 170B · Benton, KSthe pilot's failure to maintain directional control of the airplane resulting in a ground loop. Contributing factors include the inadequate preflight inspection, the pilot's failure to properly latch the cowling, and the pilot's diverted attention to the open…NTSB DEN06LA039Accident · 1 fatalLimited investigationFinal reportSpane RV-4 · Wichita, KSThe pilot's inadequate preparation prior to takeoff, and his failure to maintain control of the airplane resulting in a stall and subsequent crash. Factors contributing to the accident were the unsecured canopy latch, the pilot's diverted attention, and the…NTSB CHI06TA033Accident · No injuriesFinal reportSchweizer 269C · Manhattan, KSThe binding of the main rotor blade's tachometer cable during cruise flight resulting in an observed split tachometer indication/aural alarm and perceived mechanical emergency and the unsuitable terrain the pilot encountered during the emergency landing. A…NTSB CHI05CA003Accident · No injuriesData collectionFinal reportSinclair Zenith 701 · Augusta, KSThe manufacturer's inadequate design/production of the landing gear axle leading to its separation and the airplanes subsequent nose over during the landing roll.. A factor was the axle's separation from its spring.NTSB CHI04CA090Accident · No injuriesData collectionFinal reportSchleicher ASW-20 · Yoder, KSThe pilot's failure to secure the elevator Louis L'Hotellier connector with a safety pin or wire as directed in several airworthiness directives and his inadequate preflight inspection of the sailplane, both of which resulted in the in-flight loss of elevator…NTSB CHI03LA159Accident · No injuriesLimited investigationFinal reportCessna T210N · Tribune, KSThe in-flight separation of the turbocharger exhaust band clamp resulting in an in-flight fire and uncommanded landing gear extension. Also causal was the improper maintenance by unknown personnel.NTSB CHI01MA163Accident · Serious injuriesMajor investigationFinal reportLearjet 25D · Salina, KSThe PIC's delayed remedial action during the elevator system oscillation, resulting in the failure of the aft elevator sector clevis due to reverse bending fatigue caused by vibration, and subsequent loss of elevator control. Factors contributing to the…NTSB CHI99FA177Accident · 2 fatalField investigationFinal reportCessna 340A · Phillipsburg, KSthe pilot not maintaining flying speed. Factors to the accident were the fuel transfer problem of unknown origin.NTSB CHI98LA342Accident · No injuriesLimited investigationFinal reportMBB BK-117 · Topeka, KSthe pilot's failure to assure the engine cowling was secured during the aircraft preflight which resulted in the cowling separating from the helicopter and damaging the main rotor and tail rotor system. Factors associated with the accident were the cowling…NTSB CHI98LA027Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Augusta, KSfailure of the aircraft owner to reinstall the quick release hinge pins/safety pins, and failure of the pilot to notice the missing pins during the aircraft preflight, which resulted in separation of the main entry door during flight.NTSB CHI96LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ness City, KSthe failure of a counterweight bolt in the propeller for reasons undetermined. Factors were the wet landing area and the encounter with unsuitable terrain during the forced landing.NTSB CHI96LA208Accident · No injuriesLimited investigationFinal reportAerotechnik L-13 · Wichita, KSthe pilot's inadequate in-flight planning. Factors were the insufficient altitude and the dead battery.NTSB CHI96LA192Accident · No injuriesLimited investigationFinal reportCarrison-Seiman Schukert D-1 · Gardner, KSan aileron control malfunction of undetermined origin. A factor was the pilot's inability to control the airplane.NTSB CHI96FA171Accident · No injuriesField investigationFinal reportCessna 401 · Great Bend, KSthe failure of the exhaust header. Additional factors include the visual restrictions which prevented a detailed examination of the exhaust system, and the inadequate inspection procedures required in AD 75-23-08 R5.NTSB CHI95LA274Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Meade, KSa fatigue failure of the propeller blade, and inadequate maintenance inspection performed by the propeller shop.NTSB CHI95LA130Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Winfield, KSThe total failure of the rotor drive system clutch assembly due to excessive wear of the clutch assembly. A factor in this accident was the soft ground in the emergency landing area.NTSB CHI95LA029Accident · No injuriesLimited investigationFinal reportHughes 269C · Garden City, KSinadvertant engagement of the rotor drive system, while the helicopter had been left unattended by the pilot.NTSB CHI93DCG01Accident · 2 fatalFinal reportEmory W. Greer, JR. VARI-EZE · Olathe, KSthe pilot's failure to secure a fuel cap during the preflight inspection of the airplane, and the pilot's failure to maintain aircraft control during the emergency landing. Factors associated with the accident are the unsecured fuel cap and the foreign object…NTSB CHI93LA015Accident · No injuriesLimited investigationFinal reportBeech K35 · Scott City, KSFailure of the alternator and the pilot's inadvertent descent.NTSB CHI92DCQ05Accident · Serious injuriesFinal reportVirgil Larson Varieze,LONG EZ · Chanute, KSA delamination and inflight separation of a propeller blade during cruise flight.NTSB CHI92LA148Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Olathe, KSThe in flight separation of the propeller tip. An associated factor is the rough and uneven terrain.NTSB MKC90LA102Accident · No injuriesLimited investigationFinal reportLightcap PITTS-S-1D · Larned, KSFailure of the main landing gear attachment strut, due to fatigue.NTSB MKC90LA069Accident · No injuriesLimited investigationFinal reportCessna 175 · Derby, KSFailure of the nose gear yoke.NTSB MKC89LA001Accident · No injuriesLimited investigationFinal reportSchweizer TG3A · Yoder, KSAn abrupt maneuver resulting in a stall/spin and subsequent aircraft control not being maintained by the pilot in command.NTSB MKC88LA167Accident · Serious injuriesLimited investigationFinal reportSwearingen SA-226 · Emporia, KSWhile cruising at 17,000 ft, the 1st officer's rgt window panel failed & blew outward. A cabin decompression occurred & the copilot was seriously injured. The captain immediately descended to 10,000 ft & continued to their destination where an otherwise…NTSB MKC88DCQ01Accident · 1 fatalFinal reportFlagg Star Lite · Ft. Scott, KSThe failure of the main spars at the attachment points inside the fuselage.NTSB MKC87LA158Accident · No injuriesLimited investigationFinal reportBeech 58 · Arkansas City, KSDuring ldg roll, following a personal flight, the acft had a failure of the left main gear tire. The PIC said the acft began violently shaking and wobbling followed by collapse of the left main lndg gear. The acft swerved off the runway and incurred…NTSB MKC87LA139Accident · No injuriesLimited investigationFinal reportCessna 188B · Satanta, KSDuring the takeoff ground run on an aerial application operation, the right main gear leg separated approximately 10 inches above the axle. Acft became uncontrollable and struck the terrain. Post acc examination disclosed no defects which may have assisted…NTSB MKC86LA187Accident · No injuriesLimited investigationFinal reportCessna P337 · Wichita, KSAfter a touch-&-go landing, the flt crew noted a problem with the landing gear. A check of the hydraulic sys revealed a lack of fluid in the reservoir; the plts were unable to either retract or extend the gear. Subsequently, they landed the acft with the nose…NTSB MKC86LA174Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau Bergfalke II-55 · Hutchinson, KSThe pilot stated that he performed what he thought was a thorough pre-flight inspection, including the installation of the horizontal tail, before he pushed the aircraft onto the runway and hooked the tow line. Immediately after liftoff, the pilot further…NTSB MKC86FA166Accident · 1 fatalField investigationFinal reportAttebery-Stainbrook Varieze · Osawatomie, KSWitnesses stated that the aircraft appeared to be operating normally and flying at cruise altitude when, suddenly the left (port) wing separated from the fuselage. Sounds of engine power ceased immediately following the in-flight breakup and the aircraft…NTSB MKC86LA064Accident · No injuriesLimited investigationFinal reportCessna 170A · Gardner, KSThe ip and student had been practicing landings at another airport and was landing at this airport for fuel. There was a crosswind at the airport and the ip made the approach and landing. A witness stated that the touchdown was three point in the Cessna 170A…NTSB MKC86FCQ01Accident · Serious injuriesFinal reportKuhn Sonerai II · Sedgwick, KSThe plt noticed eng oil on the cockpit canopy during the local flt and decided to make a precautionary landing. The landing was made in a wheat field where the acft contacted a fence. The nose gear then collapsed and the acft nosed over. Post accident…NTSB MKC85LA201Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Weskan, KSThe plt rptd a high eng oil temperature & low oil pressure while maneuvering over a siesmic operation site in west Kansas. The acft was substantially damaged when it contacted a ditch during a forced landing. Post accident inspection failed to disclose any…NTSB MKC84FA262Accident · Serious injuriesField investigationFinal reportShindler-Smiley THE Blue MAX · Lawrence, KSWhile in cruise flt, plt noted rising oil temp and decreasing oil press, and elected to make a precuationary landing in open alfalfa field. During landing flare, acft stalled, right wing dropped then left wing dropped to ground contact. Engine exam disclosed…NTSB MKC84LA261Accident · No injuriesLimited investigationFinal reportCessna U206F · Satanta, KSThe pilot selected 10 degrees of flap for takeoff with the aircraft loaded to near limits for existing conditions. The aircraft became airborne in ground effect and would not accelerate to flying speed, necessitating a forced landing in a soybean field.…NTSB MKC84LA138Accident · No injuriesLimited investigationFinal reportSoneria II · Kansas City, KSThe plt of the home built acft was practicing touch-&-go landings. While climbing out after the 5th landing, the plt's canopy unlatched & opened. The plt attempted to close the canopy & nosed the acft down to maintain a safe airspeed. While trying to close…NTSB MKC84LA113Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Osage City, KSDuring an aborted takeoff, executed due to an inoperative airspeed indicator, the acft swerved off the left side of the rwy across a ditch, damaging the left wing & main landing gear. A clogged pilot tube was the cause of the airspeed indication of zero mph.…NTSB MKC84LA102Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Ulysses, KSThe plt made an autorotative precautionary landing after feeling vibrations in the anti-torque pedals. The acft was turned into the wind but landed hard in a field. The plt upon exiting the acft found the anti-torque rotor and gearbox missing. They were found…NTSB MKC84LA098Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Olathe, KSAt FL240, a fire broke out in the rgt eng compartment. The plt indicated that the eng turbo-charger was malfunctioning. The plt shut down the eng & asked for radar vectors to johnson county executive arpt. The fire went out at 21,000 ft & the acft landed…NTSB MKC84LA072Accident · No injuriesLimited investigationFinal reportCessna 150H · Conway Springs, KSWhen the oil access cover opened in flt, the plt made a precautionary landing on a road. During the landing roll the pltlooked down to push in the carburetor heat control and the right wing hit a pole. The acft nosed over.NTSB MKC84LA041Accident · No injuriesLimited investigationFinal reportCessna 310 · Olathe, KSThe plt was returning to Kansas city, MO with no cargo on board after delivering cancelled checks to tulsa, OK. While en route, the plt noticed a slight drop in oil pressure. About 75 mi from his destination, he noticed that the oil gage indicated below the…NTSB MKC84LA003Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Derby, KSThe plt was pacticing landings & stopped after each touchdown. After aprx the 5th landing, the brakes failed to operate & the acft continued off the end of the rwy. Before stopping, the nose gear went in a ditch & collapsed, and the acft nosed over. The plt…NTSB MKC83LA187Accident · No injuriesLimited investigationFinal reportHughes 269C · Dodge City, KSAfter dispensing a load of chemicals, the plt was returning to land when he felt a vibration in the tail boom. This was followed by a loud noise & the helicopter began turning. The plt lowered the collective & the power. Subsequently, the helicopter landed…NTSB MKC83FU003Accident · 1 fatalFinal reportAirmass Sunburst · Pittsburg, KSThe plt had completed a private plt ground school course & had flown aprx 4.6 hrs in a Cessna 172 before flying his home built ultralight vehicle. During a test flt, he was making a go-around from a touch-and-go landing when the vehicle crashed. A witness…NTSB MKC83FA090Accident · 1 fatalField investigationFinal reportBreezy 01 · Kechi, KSThe home built acft had been in storage with the wings removed. The wings had been recently re-installed by the owner and this was the first flight after the re-installation. During a takeoff from an open field, witnesses observed the aircraft lift-off, climb…