NTSB investigations, KS
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 MKC86LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Wathena, KSThe plt stated that according to the acft manual, he had enough fuel to fly to his destination in the usa. As such, he felt that no refueling was necessary when he landed at his designated airport-of-entry to clear customs. The acft ran out of fuel two miles…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 MKC86LA130Accident · No injuriesLimited investigationFinal reportCessna 180 · Olathe, KSA witness stated that the he observed the acft in a normal approach for landing but that it appeared slow. The witness observed the left wing drop just before the acft was to touchdown to the rwy. Tire scuff marks were seen by the witness on the rwy near…NTSB MKC86LA124Accident · No injuriesLimited investigationFinal reportCessna A188 · Blaine, KSThe plt stated that a calf, weighing aprx 500 lbs, ran in fnt of the acft, just as it was apchg lift-off. Subsequently, the acft went out of control & skidded, collapsing the main landing gear. Until just prior to impact, the calf was hidden from the plt's…NTSB MKC86LA119Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Olathe, KSDuring a takeoff roll fm johnson county executive airport, the PIC stated that the left landing gear collapsed and the aircraft impacted the rwy and veered off into soft terrain. Inspection revealed that when electrical power was initiated and the gear switch…NTSB MKC86LA114Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Winona, KSThe pilot stated that he borrowed the airplane from his father to practice takeoffs and landings at his father's private, crop dusting airstrip. There were no chemicals onboard, according to the pilot. He further stated that on a go-around maneuver, and as he…NTSB MKC86FA113Accident · No injuriesField investigationFinal reportSwearingen SA226 · Hutchinson, KSThe capt rprtd that during arrival, the apch seemed normal until he flared to land on rwy 17. At that time, he heard a loud 'pop' as the landing gear contacted the rwy surface. Subsequently, the left main gear collapsed & the acft veered off the rwy. An exam…NTSB MKC86LA111Accident · No injuriesLimited investigationFinal reportJackman Pitts S-1S · Montezuma, KSThe pilot stated that as the aircraft touched down on the runway the left wing struck crops in a wheatfield which arrested the forward motion of the wing. According to th e pilot, the aircraft veered out of control into the wheatfield, cartwheeled twice, and…NTSB MKC86LA110Accident · No injuriesLimited investigationFinal reportMyers EAA BI-PLANE · Winfield, KSThe pilot stated he was landing his taildragger to the north with winds from the north at 12 to 15 knots. He said he was making a three point landing and just before touchdown, the airplane changed directions and after touchdown, it went off the side of the…NTSB MKC86LA106Accident · No injuriesLimited investigationFinal reportCessna 188 · Lawrence, KSThe pilot stated that the right main tire rolled over sharp rocks and was subsequently destroyed during the takeoff roll. The pilot further stated that he apparently over corrected and drifted left, digging into a soft spot on the runway, and nosed over.NTSB MKC86LA104Accident · No injuriesLimited investigationFinal reportCessna 175 · Louisburg, KSDuring a fly-by over a pvt airstrip owned by the plt, the acft contacted power lines bordering the south end of the airstrip which the plt stated he forgot about. The plt reported he failed to pull up during the over fly and flew under the power lines. The…NTSB MKC86FA083Accident · 1 fatalField investigationFinal reportGlasair 2 · Cheney, KSThe acft approached Cheney lake, west of wichita, Kansas at low altitude from the southeast. Several witnesses fishing from the bank saw the acft pass near the Cheney lake marina heading toward the lake. The acft then entered a spin and crashed into the lake…NTSB MKC86FA082Accident · Serious injuriesField investigationFinal reportHiller UH-12B · Fall River, KSThe helicopter flew through the tops of trees next to a plowed field and impacted almost straight down in the plowed field and nosed over to the inverted position. The pilot stated that he had intended to land in the field and allowed the airspeed and main…NTSB MKC86LA079Accident · No injuriesLimited investigationFinal reportCessna 172 · Ness City, KSThe pilot was landing to the north with a wind from the west-northwest at 15 knots, gusting to 20 knots. The pilot stated that he had full aileron into the wind and despite this action, the wing raised up by a strong gust and airplane flipped over to the…NTSB MKC86LA072Accident · No injuriesLimited investigationFinal reportJim Elliott VP-2 · Scott City, KSThe plt was making his first flt in the acft which is powered by a volkswagon, 1,834 cc eng. The acft became airborne from a hard surface rwy and climbed to about 100 ft AGL. The plt said the controls felt mushy and when he attempted to climb the airspeed…NTSB MKC86LA070Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Mulvane, KSThe PIC of the acft landed his Cessna 182 to the north on a farm pasture he owns which doubles as a landing strip. The PIC stated he approached too high and too fast, landing about midway of the field. A fence which borders the field was fast approaching with…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 MKC86LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150B · Gove, KSAfter takeoff fm the private airstrip near Gove, Kansas, the aircraft was witnessed to descend towards the ground until impact. The witness to the accident, who is a plt and the owner of the airstrip, stated that after the acft clrd the airstrip environment…NTSB MKC86LA047Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Lawrence, KSThe plt stated he mistook an ice and snow covered area for a taxiway and turned off past the actual taxiway. The acft struck a snowbank which collapsed the nosegear. The blue taxiway light was out. This light marks the edge of taxiway. The taxiway was free of…NTSB MKC86LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Olathe, KSThe pilot stated that he was given landing instuctions for runway 17 to include winds from 220 degrees at 15 knots, gusting to 20 to 25 knots. He said that he touched down on the main wheels and a wind gust lifted the airplane and it drifted to the left. He…NTSB MKC86LA034Accident · No injuriesLimited investigationFinal reportCessna 402B · Gardner, KSLanding on an ice covered rwy, the cross-wind was stronger than rptd. The acft drifted left despite control input to correct. The nose gear collapsed before the plt could initiate a go-around. The rptd wind was 340 degrees at 8 knots. The plt stated it was…NTSB MKC86LA032Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Topeka, KSN4NP diverted from the original destination forbes field Topeka,Kansas to billard field,b NM away, due to weather. Billard ATCT advised the flight during initial contact, before N4NP reached the ILS fof, of the runway braking action. The pilot said braking…NTSB MKC86FA027Accident · 4 fatalField investigationFinal reportCessna 210K · Baxter Springs, KSAfter lndg at neosho, MO, the plt called the joplin fss at 1132 CST & reqd wx info for a flt to hays, KS. The specialistadvised that his wx computer was out of svc & suggested the plt contact another facility or call back in about 20 min. The plt indicated he…NTSB MKC86FA026Accident · 4 fatalField investigationFinal reportCessna P210N · Wichita, KSThe acdt occurred during an IFR, non-precision approach to the uncontrolled jabara airport. When the flt was one mile from the faf, ATC told the flt that in the event of a missedapproach N3864P should enter controlled airspace heading 360 deg. The controller…NTSB MKC86LA021Accident · No injuriesLimited investigationFinal reportMooney M20K · Spring Hill, KSThe pilot of this aircraft was returning from a business flight when the engine failed. During the forced landing, the aircraft rolled through a fence and then impacted a pole with one wing. The pilot stated that one connecting rod came through the side of…NTSB MKC86LA014Accident · No injuriesLimited investigationFinal reportPitts S1C · Goodland, KSThe acft rolled forward unrestrained after the plt hand started the eng. A tie down tied to the tailwheel pulled free from the ground tie down eye used to restrain the acft during the hand start procedure. The acft rolled forward striking several objects. The…NTSB MKC86LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gardner, KSThe pilot stated that he was landing on runway 8 with a right crosswind and had the right wing down for wind correction. The right wheel impacted a lip on the approach end of the runway, 6 inches below the level of the runway. The right gear collapsed, the…NTSB MKC86FA008Accident · 2 fatalField investigationFinal reportPiper PA-24 · Salina, KSAfter departing the airport under very poor IFR weather conditions, the plt rpt autopilot problems of an unspecified nature. This was followed by reports of instrument troubles. Radar controllers gave the plt a no-gyro turn to the left. After the instructions…NTSB MKC86LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Salina, KSThe pilot did not top off the fuel tanks before departing lincoln, NE for pratt, KS. Enroute winds necessitated a fuel stop at Salina, KS. These same winds flipped over the airplane as it was turning off the runway to taxi in.NTSB MKC85LA216Accident · No injuriesLimited investigationFinal reportCessna 172M · Emporia, KSTwo plts were on board. The lt seat plt was making the landing when a gust of wind caused the acft to become misaligned with the rwy. The rt seat plt took control of the acft and attempted a go-around. The rt seat plt said he aimed for a clear spot btw trees…NTSB MKC85LA215Accident · No injuriesLimited investigationFinal reportCessna 421B · Olathe, KSDuring the takeoff roll on an IFR flt, the right eng lost pwr and the plt aborted the takeoff. The acft ran off the end of the rwy, across two ditches, one road, through a fence and struck a post in a fld. During post accident tests, the right eng would run…NTSB MKC85LA214Accident · No injuriesLimited investigationFinal reportCessna 152 · Olathe, KSThe student plt lost directional control of the acft while practicing touch & go landings. Winds in the local area were reported by fss as being from 110 degs at 12 KTS, gusting to 17 KTS. The plt lost control of the acft during a landing roll, ran off the…NTSB MKC85LA207Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Ashland, KSThe helicopter lost power and made a hard forced landing in a backyard. There were no leaks in the fuel system but the fuel tank was found to be empty. The owner states that even though the fuel tank was found to be empty after the accident, the fuel quantity…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 MKC85LA193Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Meade, KSThe plt reported that when he attempted to climb at the end of a swath run the acft began to mush. The acft was over tall corn and despite the use of full power it would not climb. The acft flew about one mile in the semi-stalled condition and then began to…NTSB MKC85LA195Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Wichita, KSThe plt stated he touched down with what appeared to be a soft landing but the acft started to porpoise. A go-around was performed and another landing accomplished without incident, however, the acft was substantially damaged during the first landing.NTSB MKC85LA184Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT301 · Oakley, KSN8541S collided with a fence and crashed while attempting a forced landing. The plt reports that it took longer than expected to dispense his chemical load and he was critically low on fuel when he departed the working area for the arpt. He got to within 2…NTSB MKC85LA183Accident · No injuriesLimited investigationFinal reportCessna A188B · Menlo, KSPlt reports that the eng gradually lost power during a swath turn around. A landing on a nearby road appeared possible but the eng quit and the acft crashed in a corn field. Post accident examination by an FAA inspector failed to reveal any evidence to…NTSB MKC85LA185Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Shawnee, KSThe commercial Balloon plt was giving a ride to three paying passengers. Plt stated that during the landing apch higher than normal winds were present so he briefed the passengers to lean against the side of the basket. He stated that he pulled the deflation…NTSB MKC85LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Hays, KSThe student plt, who was taking his pvt plt chk ride with an faa-designated examiner, reduced power prematurly on final approach for landing at Hays. The acft dropped, striking the ground in a level attitude, which jammed the nose gear upwards, distorting and…NTSB MKC85FA177Accident · Serious injuriesField investigationFinal reportCessna A188B · Dodge City, KSThe plt was was making east & west runs over a milo field as he was dispensing parathion. He reported that he had been working under high voltage power lines each time he flew past the west edge of the field. He stated that on the last pass, the acft…NTSB MKC85LA173Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Norcatur, KSThe acft had been spraying for 40 minutes at 2500 ft MSL with a density alt of aprx 4600 ft when it stalled during a turnaround. It then impacted an electric pwr pole followed by the terrain.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 MKC85LA155Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Salina, KSThe plt stated that he was receiving a multi-engine flight check from a designated flt examiner. They were still rolling after a landing when the examiner requested a go-around. The plt said that after advancing the throttles, he reached for the flap switch &…NTSB MKC85LA153Accident · No injuriesLimited investigationFinal reportCessna 172M · Olathe, KSPlt stated that she used left aileron and right rudder for x-wind correction and did not release the rudder pressure on touchdown. The acft went off side of rwy, crossed a taxiway, went down an embankment and through a fence into a plowed field where it nosed…NTSB MKC85FCQ05Accident · Serious injuriesFinal reportCessna 150M · Manhattan, KSThe acft contacted the terrain aprx 175 yds short of rwy 21 and aprx 50 ft right of the centerline. A witness reported the acft appeared slow on final apch and it was rolling slightly from side to side. The nose of the acft then suddenly dropped and the acft…NTSB MKC85LA148Accident · No injuriesLimited investigationFinal reportCessna 172B · Valley Center, KSThe pilot had been flying with his young son as passenger during daylight hours. He went solo to get current at night. After two full stop landings, he thought the yoke felt heavy for the trim setting he usually used but he started a takeoff anyway. Halfway…NTSB MKC85FCQ04Accident · Serious injuriesFinal reportRyan Navion · Blue Rapids, KSThe acft eng lost power after a 30 minute flt and a forced landing resulted in an off.-arpt acc. Witnesses at the acc site did not find any fuel in the tanks or evidence of spillage of fuel. An inspection of the eng did not reveal any discrepancies. A…NTSB MKC85LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · El Dorado, KSThe acft had just undergone annual inspection. Pilot failed to remove control lock before test flight. On takeoff roll, pilot was not able to move controls, went off end of 1800 ft runway, through a fence and impacted a dirt pile.