NTSB investigations, KS
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 MKC85LA144Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hays, KSThe plt started the eng & was preparing to taxi from the parking area when he reached back to retrieve a flashlight from his flt case. At that time, the acft began slowly rolling forward. When the plt returned his attention to the front, he applied brakes.…NTSB MKC85LA138Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Manhattan, KSThe plt said he put the landing gear selector switch to the down position and thought that he observed a green, down andlocked indicator light; however, the acft landed with the gear retracted. Examination of the acft after the accident revealed that the…NTSB MKC85FA134Accident · 1 fatalField investigationFinal reportRyan Navion A · Kingman, KSAfter departing a pvt strip the acft was observed to perform some low altitude aerobatic maneuvers. The maneuvers consisted of two snap rolls at about 100 feet off the ground. The acft was observed descending steeply on the second roll maneuver until striking…NTSB MKC85LA132Accident · No injuriesLimited investigationFinal reportBeech C23 · Pratt, KSStudent pilot was on his second cross-country flight to this airport. He stated that after touchdown, he reached to raise the flaps and the airplane started to drift. He overcorrected and went off left side of the runway and nosed over when he went through a…NTSB MKC85FCQ03Accident · 1 fatalFinal reportCessna 172RG · Wichita, KSThe acft collided with a cushman scooter during taxi. A witness stated that when the scooter driver 'looked up' I saw the acft taxiing, he made a hard rt turn which threw him off. The scooter driver and scooter were struck separately by the acft. The scooter…NTSB MKC85LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Concordia, KSThe student plt was making a night flt. He received wind information from an arpt 48 miles from the destination but used an indication from lighted wind indicator. Plt made a go around because the ground speed was fast. During the next attempt, he landed, ran…NTSB MKC85FA120Accident · 2 fatalField investigationFinal reportCessna 152 · Albert, KSWhile maneuvering to reverse directions the acft stalled descending and impacting the ground in a steep dive. The plt was on the final leg of his cross-country flt.NTSB MKC85LA118Accident · No injuriesLimited investigationFinal reportEagle DW1-0062 · Mcpherson, KSDuring a go-around attempt the plt who was landing at the harrison airport encountered turbulent wind condition. The plt stated the acft stalled and dropped into a field off the side of the rwy. Strong wind conditions were forecast fro the area of landing.NTSB MKC85LA112Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Goddard, KSOn a final leg of a x-country flt, the eng of the acft began to faulter finally quitting a few minutes later. The subsequent forced landing resulted in the acft nosing over. An inspection of the acft revealed a residual amt of fuel in the wing fuel tanks.…NTSB FTW85FA230Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Junction City, KSArmy UH-1V and N7053R, a Piper PA-28, collided in mid air at 700 feet AGL. Both acft were in lvl flt. UH-1V was operating on a medical evacuation flt with a crew of four, one patient and two attendants. The UH-1V executed a successful autorotation with…NTSB MKC85LA106Accident · Minor injuriesLimited investigationFinal reportBeech B35 · Harper, KSPlt stated rt wing dropped when acft was 4 to 5 ft AGL after liftoff. When plt corrected for low right wing, the acft over-corrected to the left. Acft was then completely uncontrollable and it veered left off the runway heading and mushedto the ground. After…NTSB MKC85LA103Accident · No injuriesLimited investigationFinal reportAirship Industries Skyship · Columbus, KSIn cruise flt nearing Columbus, Kansas the plt at the controls of the Airship experienced a pitching up of the Airship's nose. The elevator control did not respond to the plt input to counter the nose up pitch. Also noted was a loss of pressure from the rear…NTSB MKC85LA092Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Kingman, KSDuring a landing attempt, the acft was high and fast and subsequently touched down long. The plt attempted a go around with 40 degrees of flaps. The acft stalled and contacted the terrain one fourth mile past the end of the rwy, right wing first.NTSB MKC85LA091Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Grenola, KSWhile maneuvering during a swath to a field, the engine quit. The plt was operating his acft for aprx 1/2 hr prior to the loss of pwr. The plt states he visually checked the fuel level. An inspection of the acft engine revealed no mechanical failure or…NTSB MKC85FA089Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Wakeeney, KSOn a x-country flt from dodge city, KS, to hill city, KS, the plt encountered IFR wx conditions around Wakeeney, KS. The IFR conditions were not forecast for his area of flt. A 2000 CST observation at hill city, KS, was indicating IFR conditions existing aprx…NTSB MKC85FCQ02Accident · Serious injuriesFinal reportBeech 35-B33 · Lakin, KSThe acft attained aprx 200 ft of alt after takeoff before the eng was heard changing sound before the popping & backfiring began, according to witnesses. After all eng sounds ceased the acft descended rapidly to a grassy area of the arpt & landed with the…NTSB MKC85LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Herington, KSAcft tookoff from a 1900 ft long, sod, farm strip. Plt said acft became airborne at mid-field but felt mushy and would not climb. Acft collided with fence and bush at end of strip and sustained substantial damage. Acft remained airborne and continued to…NTSB MKC85LA079Accident · No injuriesLimited investigationFinal reportCessna 188 · Osage City, KSThe plt was practicing landing at the airport when during the landing roll on the third attempt at landing the acft swerved off the rwy. The acft ground looped after departing the rwy and sustained substantial damage. The plt rptd the brakes grabbed…NTSB MKC85FCQ01Accident · Serious injuriesFinal reportBeech 95-B55 · Hutchinson, KSDuring arrival, the plt began an ILS apch to rwy 13 at the Hutchinson muni arpt. He reported that he had turned off the 16 mi arc, had intercepted the localizer & had begun his descent to the min published alt to cross over the outermarker (final apch fix).…NTSB MKC85LA053Accident · No injuriesLimited investigationFinal reportCessna A152 · Olathe, KSThe acft collided with a snow bank on the left side of the rwy following a loss of directional control during a touch and go landing. The plt stated control of the acft was lost when he attempted to reconfigure the acft for the takeoff portion of the touch…NTSB MKC85LA052Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Ottawa, KSRight main gear struck an object during takeoff ground run. Plt aborted the takeoff. Acft veered to the right and impacted a snowbank which paralled the side of the rwy. The arpt operator reported that there was snow knocked onto the rwy 5O to 100 ft prior to…NTSB MKC85LA050Accident · No injuriesLimited investigationFinal reportCessna 150L · Beloit, KSThe student pilot stated he was practicing touch and go landings on rwy 35. After touchdown, the airplane veered left, hit a snowbank off the side of the runway & flipped forward to the inverted position. Winds were from 300 degrees at 5 knots, gusting to 10…NTSB MKC85LA054Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wa Keeney, KSAcft touched down left of centerline. Left main gear contacted slush on the rwy and the acft swerved into a 2 to 3 ft snowbank alongside the rwy. Plt stated, 'the rwy was plenty clear and the accident would not have happened if the plane had been kept on the…NTSB MKC85LA047Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Vermillion, KSOn takeoff roll acft traveled through soft snow resulting in a loss of forward speed. Plt was able to continue lift off but acft settled into a plowed field just past the end of the rwy and subsequently nosed over.NTSB DCA85AA009Accident · 3 fatalFinal reportLockheed 188A · Kansas City, KSDuring arrival to the Kansas City downtown arpt, the flt was vectored for a VOR rwy 3 apch, then was cleared for the apch & to circle & land on rwy 36. On final apch, the acft was hi & was not in a position to land, so the flt was cleared to circle left for…NTSB MKC85LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Olathe, KSPilot said acft swerved to right during landing roll. Acft ran off right side of rwy into snow covered area resulting indamage to wing & gear. No evidence of aircraft malfunction was found after the accident.NTSB MKC85LA055Accident · No injuriesLimited investigationFinal reportBeech 300 · Hutchinson, KSOn late final, the plt under instruction reduced pwr sharply to correct a slightly high approach, advancing the propeller controls to full increase. The combination of power reduction and increased profile drag on the propellers was excessive for the desired…NTSB MKC85FA030Accident · 1 fatalField investigationFinal reportCessna 150 · Colby, KSOn a heading of 065 deg the acft impacted in a slightly rising open field in a wings level 15 deg nose down attitude. Investigators found the acft in a landing configuration with the wing flaps fully extended and the throttle secured by the throttle friction…NTSB MKC85LA019Accident · No injuriesLimited investigationFinal reportCessna R172E · Junction City, KSPilot was experiencing communications difficulties, diverted from destination to nearby uncontrolled arpt due to traffic considerations. Plt was unable to contact UNICOM and elected to circle for traffic and wind evaluation. Best runway for wind direction was…NTSB MKC85FA012Accident · 3 fatalField investigationFinal reportMooney M20E · Carbondale, KSThe flt was en route from little rock, AR, to topeka, ka. Ten miles south of topeka's frobes field the plt requested wx info and was told that a current observation was being taken & he would be advised. Contact between the tower and the flt could not be…NTSB MKC85LA011Accident · No injuriesLimited investigationFinal reportCessna 310J · Chanute, KSDuring the landing roll the left main landing gear collapsed. Examination of the acft after the accident revealed several mechanical discrepancies. The only gear related problem noted was the landing gear limit switches were out of adjustment but it could not…NTSB MKC85FA008Accident · 2 fatalField investigationFinal reportCessna 182F · Hiattville, KSThe acft crashed during a night x-country flt. Ground witnesses who saw the flash from the ground impact stated that there was a thunderstorm in the area at the time of the accident. They also stated that they had difficulty in locating the wreckage due to…NTSB MKC85FA007Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Beeler, KSAt 1805 CDT the pilot received a wx brief for the first leg of what was intended to be a round trip flight. No wx briefing was obtained for the return trip. Despite VMC at the nearest observation facility, witnesses reported haze and low clouds at the time of…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 MKC84LA258Accident · No injuriesLimited investigationFinal reportPiper PA-36-400 · Hill City, KSThe plt cleared some power lines and descended to spray a sunflower field. The acft descended until it contacted the flowers with the landing gear. The tall flowers destroyed the leading edges of the acft wings and the landing gear. The drag slowed the acft…NTSB MKC84LA251Accident · No injuriesLimited investigationFinal reportCessna A188A · Goodland, KSThe acft descended to the corn field for the 1st swath run after reloading. The acft did not level off properly but keptdescending until it was in contact with the crop. The additional drag caused the acft to stall into the ground. The plt said the acft had…NTSB MKC84LA252Accident · No injuriesLimited investigationFinal reportCessna 152 · Olathe, KSThe student plt elected to practice touch-&-go landings. On her 1st landing of that flt, the acft bounced & began to porpoise. She started to apply power for a go-around on the 3rd bounce, but the nose came down hard & the nose gear collapsed.NTSB MKC84LA253Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Plains, KSThe acft collided with a tall crop during an attempted takeoff from a dirt road. The acft had failed to become airborne on another road after about 2600 ft of run and the attempt was aborted. This takeoff run was about 2800 ft according to the plt. The plt…NTSB MKC84FA245Accident · Serious injuriesField investigationFinal reportCessna 188 · Bloom, KSThe acft struck two guy wires during a spraying operation when the plt failed to clear the wires. Operators heard the impact which occurred about 160 AGL & toppled the 310 ft tower. The acft wings were separated from the fuselage which continued to the west…NTSB MKC84LA244Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Osage City, KSThe pilot stated that during an aborted takeoff, due to an engine power loss, he was not able to stop before running off the end of the 2600 foot long runway. He said that when he felt that the airplane was ready to fly he glanced down at instrument panel and…NTSB MKC84LA243Accident · Minor injuriesLimited investigationFinal reportTate SNS-7 · Larned, KSPlt stated that shortly after takeoff a loss of pwr occurred. Plt pulled up to fly over pwr lines rather than hit a fence under the lines. The acft cleared the wires then stalled into a field. The plt stated the engine was running roughduring the previous flt…NTSB MKC84LA238Accident · No injuriesLimited investigationFinal reportCessna 401 · Hutchinson, KSWhile taxiing for takeoff the plt turned from the taxiway onto the rwy & the left main gear collapsed. Post crash examination of the left gear revealed that the ldg gear wing rib support bracket failed allowing the gear to collapse. A Cessna service letter…NTSB MKC84LA231Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Garden City, KSThe plt stated that after the acft was fueled he failed to visually check the fuel tanks and just assumed both tanks were full. He stated the left fuel gage had been inoperative above 1/2 tank of fuel. During a spray run, when the right tank reached 1/4, he…NTSB MKC84LA227Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Troy, KSShortly after takeoff the acft collided with wires and crashed. The plt had tried to fly under the wires because the acft would not climb over them. Investigation revealed that the acft was overloaded and out of balance by having 2 minorpassengers in the…NTSB MKC84LA212Accident · No injuriesLimited investigationFinal reportCessna 172 · Beuamont, KSThe plt was taking off to the north on a sod rwy with a light, northeast wind. The rwy was outlined with old automobile tires. The plt elected to use the left side of the rwy, since it appeared to be smoother. After lift-off, the acft drifted left & the left…NTSB MKC84LA206Accident · Minor injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Bennington, KSThe student plt stated that after lifting to a hover on her first solo flt, she made two 180 degree hovering turns. She said that the helicopter entered a violent lateral vibration and descended to the ground. Examination of the wreckage did not disclose any…NTSB MKC84LA203Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Topeka, KSDuring flt, the plt decided to divert to Topeka, KS. While landing on rwy 13, the acft veered to the right. Subsequently, it went off the side of the rwy, encountered soft, muddy terrain & nosed over. The wind was from 210 degs at 14 gusting 22 KTS.NTSB MKC84LA192Accident · No injuriesLimited investigationFinal reportRotec Rally Sport · Wichita, KSPilot stated that after takeoff and climb to the downwind leg of the traffic pattern, he reduced engine pwr and reversed course. The pilot continued to state that the eng started losing pwr and subsequently failed. A forced landing was made in a newly…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…