NTSB investigations, KS
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 MKC89LA042Accident · No injuriesLimited investigationFinal reportBeech 58 · Elkhart, KSWhile attempting to land in strong crosswind conditions, the plt lost directional control. The acft veered off the runway and was substantially damaged. The winds were gusting over 40 knots, with occasional gusts of 60 knots.NTSB MKC89LA041Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Linwood, KSPoor in-flight planning and decision, inadequate visual lookout, and clearance not attained by the pilot in command.NTSB MKC89FA038Accident · No injuriesField investigationFinal reportCessna 650 · Hutchinson, KSPurpose of flight was to prepare the left-seat pilot for a type rating, and this was his first landing since completing ground school. There was another student in the jump seat, and two more in the back of the airplane. The airplane was landing on runway 31;…NTSB MKC89LA034Accident · No injuriesLimited investigationFinal reportCessna 182 · Garnett, KSHaving just made a parachutist's drop, during a sky diving operation, the private pilot spiraled down from altitude to land, but had to extend his pattern to allow a departing acft to leave. During a long final approach, the engine failed and an emergency…NTSB MKC89LA018Accident · Serious injuriesLimited investigationFinal reportRockwell S2R · Sublette, KSWhile conducting an aerial application operation, the aircraft struck some cross-country power lines. The acft nosed down and struck the terrain, causing substantial damage to the acft and serious injuries to the pilot. The pilot was unable to recall the…NTSB MKC89FA014Accident · Serious injuriesField investigationFinal reportTaylorcraft BC-12D · Lenexa, KSThe PIC had been drinking alcoholic beverages before the flt and had taken the prescription anti-depresion drug pamelor. In combination, the adverse side-effects of the drug are magnified. The PIC decided to fly instead of drive to visit a friend working the…NTSB MKC89LA010Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Andover, KSWhile turning base to final for landing on a private grass strip, after a personal cross country flight, the aircraft stalled and fell uncontrolled to the terrain. A post accident investigation failed to reveal any malfunction of the control systems or…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 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 MKC88LA180Accident · No injuriesLimited investigationFinal reportEllis Quickie Q2 · Winfield, KSWitnesses said that after takeoff, the plt made one low level pass, then returned for landing. The plt rprtd that he intended to make a go-around, but that he may have pushed the elevator control forward instead of the throttle. Subsequently, the acft was…NTSB MKC88FA173Accident · Minor injuriesField investigationFinal reportAero Commander 500B · Hays, KSOperation attempted with known deficiencies in equipment, and failure of the pilot to maintain directional control. A contributing factor was: the pilot's use of an improper starting procedure & the fence.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 MKC88DCQ04Accident · Serious injuriesFinal reportTeratorn Tierra II · Plevna, KSThe pilot stated that on takeoff climb, approximately 100 feet AGL, the a/c broke to the right and hit the ground. The pilot suspected right aileron control problems. Inspection of a/c revealed no mechanical problems. The wind was light and variable at 10 KTS.NTSB MKC88LA140Accident · No injuriesLimited investigationFinal reportMooney M20C · Olathe, KSShortly after takeoff, the pilot said the engine failed. He said he pumped the throttle and the engine restarted about the same time the acft returned to the runway. The engine restart propelled the aft back into the air. The plt felt he had sufficient power…NTSB MKC88LA135Accident · No injuriesLimited investigationFinal reportMooney M20-F · Lawrence, KSThe pilot said the engine quit due to fuel exhaustion during a personal cross country flight. He said he tried to glide to his final destination airport, but made an emergency ldg in a farm field about 2 miles short of the airport.NTSB MKC88LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Topeka, KSWhile taxiing in from a personal solo training flight, the student pilot taxied into a chain link fence while attempting to park the acft. The right wing spar sustained substantial damage.NTSB MKC88FA119Accident · 4 fatalField investigationFinal reportCessna 320 · Atwood, KSThe PIC had deptd the denver metro area carrying pax to vacation in Indiana. No flt plan was filed and there was no record of a preflt wx brief. The flt progrsd without any known difficulty until reaching the colorodo/kansas border. The PIC rqstd and rcvd wx…NTSB MKC88LA118Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Olathe, KSAfter a long cross country flight, the pilot said he encountered heavy rain and thunderstorms near his destination. He reported that he was able to continue the flight under VFR, but when landing on the wet runway braking was ineffective. The airplane…NTSB MKC88LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Trousdale, KSDuring a cross country personal flight, the PIC noticed an excessively high oil temperature. He said he enriched the fuel mixture, and when that failed to cool the engine, he reversed his course back to his departure apt. Shortly after his reversal of course,…NTSB MKC88LA110Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Dighton, KSDuring an aerial application operation, the plt said that as he initiated liftoff, the acft turned to the left and he felt he had no rudder control. He hit a fence on the apt boundary, continued, dumped his chemical load, hit a tree, and landed in a field…NTSB MKC88LA105Accident · No injuriesLimited investigationFinal reportBeech 35C · Manhattan, KSArriving at the original destination apt, the PIC decided on an alternate, nearby airport, due to confusion regarding runway conditions at the original destination apt. Flying to his alternate, he erroneously lined up at a military airport located about 10…NTSB MKC88DCQ03Accident · Serious injuriesFinal reportAeronca 11AC · Ada, KSThe a/c contacted powerlines about 25 feet AGL, contacted a tree, broke another powerline, and then crashed into a pickup truck. No evidence of preimpact mechanical problems were found with either airframe or powerplant. A toxicological test of the pilot…NTSB MKC88LA097Accident · No injuriesLimited investigationFinal reportCessna 310K · Kansas City, KSDuring a lndg roll subsequent to landing, the nose landing gear collapsed. A post-impact insptn of the gear indicated that a bolt (which retains the retract arm to the bellcrank) had sheared. The bolt was also discovered to have been installed in the wrong…NTSB MKC88LA090Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T1A2 · Horton, KSThe PIC was executing touch and go lndgs when he reportedly experienced a shift in wind conditions. The acft impacted the ground short of the rwy. He said that the wings suddenly lost lift resulting in a high descent rate. The PIC reported no mechanical flt…NTSB MKC88LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Concordia, KSWhile attempting a crosswind landing, PIC decided to make a go-around. During the go-around the acft stalled, struck the terrain and cartwheeled.NTSB MKC88DCQ02Accident · 1 fatalFinal reportPiper PA-25-150 · Chase, KSWitnesses stated they saw the acft spraying a hayfield. They observed the acft strike a powerline as it was making a turn. The pilot stated that his wing clipped the powerline and that the acft went into a flat spin from which he couldn't recover.NTSB MKC88LA064Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Manter, KSWhile conducting a team aerial application operation, the trailing aircraft struck the terrain with the right wing tip, rotated in a flat attitude about 2 turns, and was destroyed by fire. The pilot said, while in a downwind procedure turnaround, into the…NTSB MKC88LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Manhattan, KSWhile practicing short field ldgs at night, the pilot stated he felt he stalled on final about 15 to 20 feet above the runway. The aircraft bounced three times, striking each wing on the first two touchdowns and collapsing the nose gear assembly on the last…NTSB MKC88LA048Accident · No injuriesLimited investigationFinal reportCessna T-188C · Goodland, KSWhile flying a certificated experimental ag acft, for purpose of compliance with FAR regulations, the employee of the federal aviation administration lost control during landing rollout. The wind conditions, relative to the runway, were about a 80 degree…NTSB MKC88LA047Accident · No injuriesLimited investigationFinal reportCessna 152 · Ottawa, KSThe student pilot was on a solo cross country flight. During the landing, the aircraft began to porpoise. The pilot performed remedial action, however, the aircraft had already sustained substantial damage.NTSB MKC88LA044Accident · No injuriesLimited investigationFinal reportCessna 206 · Wichita, KSDuring a night ldg with strong gusty x-winds, the PIC lost control during the roll out and careened off the runway substantialy damaging the acft. The PIC stated the windshield was partially coated with ice making forward visibility difficult.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 MKC88DCQ01Accident · 1 fatalFinal reportFlagg Star Lite · Ft. Scott, KSThe failure of the main spars at the attachment points inside the fuselage.NTSB MKC88LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hays, KSDuring a personal cross country IFR flt, PIC encountered forecast icing conditions. He then made a 180 degree turn to an alternate airfield. He said the acft accumulated substantial icing on propeller, wings and windshield. He said full pwr was necessary to…NTSB MKC88LA024Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Coffeyville, KSWhile trying to start the acft with a low battery, PIC exited the acft and pulled the propeller one quarter of a turn to get it past the compression cycle. Engine started with pax aboard and proceeded to taxi. PIC was unable to stop the acft, and pax, after…NTSB MKC88FA018Accident · 1 fatalField investigationFinal reportCessna 310Q · Augusta, KSThe airplane departed to the south and made a left turn. Approximately 1/4 of a mile east of the airport, the airplane impacted straight down with gear down and flaps at 15 degrees. No preimpact problems were found with airframe or powerplants. No indication…NTSB MKC88LA016Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Leavenworth, KSWhile practicing landings and takeoffs, the PIC inadvertently put the gear switch in the retract cycle while rolling out. The gear began its retraction cycle with the acft still on the rwy, damaging the retraction system. The plt elected to tkof, but once…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 MKC88FA003Accident · Serious injuriesField investigationFinal reportStinson 108-2 · Wakeeney, KSThe owner & his son, who were both plts, initiated a midfield takeoff from their pvt dirt airstrip which was on soft uneven terrain. The son rprtd that near the end of the strip, power was 'cut.' The acft contd about 200' beyond the dep end of the strip &…NTSB MKC88LA001Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Wamego, KSDuring a night ldg the plt aligned the acft with the white tops of a fence that was parallel to the runway. Not all of the rwy lights were illuminated. Both wings and the lower fuselage were substantially damaged during the lndg on the fence.NTSB MKC87LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · El Dorado, KSAfter departing midfield and attaining approximately 100 feet of altitude, plt experienced a complete power failure. Plt attempted to reland on intersecting runway by executing an approximate 270 degree turn. Acft struck the terrain before completing the…NTSB MKC87FA169Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Kanorado, KSThe fss stated they had personally briefed the student pilot on the wx en route for this night flight and told him VFR was not recommended. At the first stop, he called the co-owner of the airplane and told her he had been flying around storms. At the next…NTSB MKC87LA162Accident · No injuriesLimited investigationFinal reportMaxfield Pitts S-1S · Meade, KSShortly after takeoff, while depg to the se, the eng seized. All of the surrounding terrain consisted of plowed fields, so the plt tried to glide back to the arpt; however, he had insufficient speed & alt to get aligned with the rwy. Drg the lndg, the acft…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 MKC87LA156Accident · No injuriesLimited investigationFinal reportCessna 150M · Atchison, KSThe solo student pilot was practicing touch and go landings. The pilot stated he had successfully performed 2 landings. On the third landing the aircraft touched down to the left of the runway's centerline, veered right and off the runway. Investigation…NTSB MKC87LA149Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Benton, KSWhile practicing soft field take offs, student plt with CFI over rotated acft causing premature flt before attaining vxse airspeed. CFI attempted to correct the situation, but acft settled in uncontrolled descent beyond the airport boundary. Acft struck the…NTSB MKC87LA145Accident · Minor injuriesLimited investigationFinal reportHiller 12E · Ulysess, KSDuring a helicopter aerial application operation, acft suffered a main rotor system hub failure. PIC was unable to control the acft and an uncontrolled descent resulted. Acft struck the terrain and was substantially damaged and the PIC suffered minor…NTSB MKC87DCQ03Accident · 1 fatalFinal reportPiper PA-36 · Nickerson, KSAfter a swath run to the east, the acft was observed to pull up & begin turning back to the west. The witness then saw a big cloud of smoke. She did not see spray coming from the acft drg the last swath run, although her vision was limitedby foliage & bldgs.…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…