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 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 MKC87LA110Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Carbondale, KSThe PIC was moving his acft fm one airstrip to another in the LCL area. Wind cond's fm a nearby fss, recorded winds fm the southeast at 18 KTS, gusting to 25 KTS. The PIC rptd departing the sod airstrip to the southwest, and shortly aft establishing a climb,…NTSB MKC87LA104Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Wamego, KSThe PIC had been airborne in the LCL area to let parachute jumpers jump fm his acft. To lose alt quickly the PIC performed a prolonged slip. On the final app the eng quit and alt was insufficient to reach the rwy for lndg. The off arpt lndg was unsuccessful.…NTSB MKC87FA103Accident · 2 fatalField investigationFinal reportChampion 7EC · Delia, KSWitnesses stated that the aircraft was performing high speed, low level passes over the homes of some friends and relatives when, suddenly, it started a steep climb over a tree line. The aircraft appeared to slow down at the top of the climb; then it leveled…NTSB MKC87DCQ02Accident · Serious injuriesFinal reportCessna 188 · Harper, KSThe pilot was preparing to spray a wheatfield. During the second 1/3 of procedural turnaround, the aircraft struck powerlines, then the ground. The aircraft was destroyed by post-impact fire.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 MKC87LA100Accident · No injuriesLimited investigationFinal reportCessna 188 · Ottawa, KSThe acft was returning from an aerial application flt when the fuel line to the fuel filter disconnected. During the forced landing, the acft ran into a fence. The eng had been installed 100 flt hrs prior to the accident.NTSB MKC87LA088Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Lincoln, KSThe plt was spraying 2/4/D when one spray nozzle stuck open. Rather than kill alfalfa and trees during the turnarounds, the plt elected to land on a dirt road and repair the nozzle. He misjudged the width of the road and on touchdown, the right wing touched…NTSB MKC87FA083Accident · Serious injuriesField investigationFinal reportAeronca 11AC · Stillwell, KSThe pilot stated that this flight was to be a photographic, pleasure trip involving two aircraft. After several aerial photos were taken of each other's aircraft, both airplanes landed at the accident airport. The PIC and his passenger then took-off while the…NTSB MKC87LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Kipp, KSThe engine crankshaft broke into two pieces during an ag flight and during the forced landing in a wet, soft field, the airplane nosed forward to the inverted position.NTSB MKC87LA079Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Brewster, KSThe PIC rptd verring left and off the side of the sod strip where he was attempting a lndg. The PIC stated that the lndg gear began sinking into soft grnd off the side and the acft slowed rapidly. After slowing the nose wheel collapsed rearward flipping the…NTSB MKC87LA075Accident · No injuriesLimited investigationFinal reportBeech 35A · Liberal, KSThe PIC rptd experiencing turbulence on takeoff from Liberal airport. Winds were prevailing from the southeat at 15 knots as he departed the airstrip using runway 19. At rotation, the PIC reported that the left wing got too high and he lost control. The PIC…NTSB MKC87LA074Accident · No injuriesLimited investigationFinal reportCessna A185F · Topeka, KSThe tower stated the aircraft made a hard bounce and when it touched down again, the right gear collapsed. The airplane landed on runway 3 with winds from 350 degrees at 17 knots, gusts to 32 knots. Runway 3 was the best runway to use at the time.NTSB MKC87LA073Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Halstead, KSThe PIC rptd lndg long on a 2600 ft sod rwy. During the lndg roll, the PIC rptd encountering a tailwind. The closest fss at wichita, 20 mi fm the accident arpt, rptd no significant wind chg during this period, the PIC, knowing that he had landed long and…NTSB MKC87LA072Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dodge City, KSThe pilot stated that the aircraft was operating normally when he established himself on final approach for rwy 32. Winds were from the northeast at 25 KTS, the pilot further stated, so he abandoned the approach and was in the process of circling the field…NTSB MKC87LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Tribune, KSThe pilot stated that he was spotting stray cattle after a snow blizzard moved through the region. Two hours into the flight, the pilot further stated, he reduced engine power for approximately 10 seconds--without carburetor heat. The engine then sputtered…NTSB MKC87FA064Accident · No injuriesField investigationFinal reportCessna T337C · Garden City, KSBoth of the acft engs had just been overhauled. The plt decided to make a maint test flt & elected to leave the lndg gear in the down & locked psn. Takeoff & initial climb were normal until about 300 to 400 ft AGL. At that time the rear eng lost power. The…NTSB MKC87LA055Accident · No injuriesLimited investigationFinal reportCessna 150 · Newton, KSThe stu was practicing simulated engine failures at his cfi's direction. As the stu simulated corrective action in the cockpit to restore pwr, he inadvertently turned the fuel selector off, and did not tell the CFI. Normally the CFI terminated the simulated…NTSB MKC87LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Coffeyville, KSThe student pilot flew from tulsa, ok to Coffeyville, KS to take his private pilot flight test. Student did not check weather or NOTAMS and relied on information from the flight instructor and was not aware of the NOTAM that there was a 50-foot wide strip…NTSB MKC87FA035Accident · Serious injuriesField investigationFinal reportCessna 414A · Olathe, KSThe plt stated that this was not a charter flt and, as such, he decided to attempt the LOC 17 apch to Olathe even though the area was forecasting zero-zero conditions. According to the plt, the last thing he remembers during the flt is bracketing the LOC and…NTSB MKC87LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Olathe, KSDuring landing airplane ballooned due to wind gust. After touchdown. Airplane veered left and duirng pilot's correction, the left main landing gear leg broke off. Metallurgical evaluation revealed a previous fatigue failure in the fracture surface.NTSB MKC87FA027Accident · 1 fatalField investigationFinal reportCessna 177RG · Colby, KSThe non-instrument rated pilot filed an IFR flight plan after being briefed. There was freezing drizzle to the west that was moving toward the departure area. The airplane took off into a low ceiling with near freezing temperature. Pilot attempted to climb to…NTSB MKC87LA023Accident · No injuriesLimited investigationFinal reportCessna 150J · Colby, KSThe pilot stated that he departed his private airstrip, low on fuel, intending to refuel at the next stop where he was to conduct a business transaction. Unable to secure fuel there, and showing one quarter of a tank on each fuel gauge, he departed for Colby…NTSB MKC87FA020Accident · 1 fatalField investigationFinal reportCessna 182A · Bluff City, KSThe plt stated that he was cruising at 2,500 ft MSL en route southbound to enid, Oklahoma, when he encountered fog but flew for 15 to 20 minutes before executing a 180DEG northerly turn back to hutchinson, KS. According to the plt, he was in the clouds trying…NTSB MKC87FA015Accident · 1 fatalField investigationFinal reportCessna 310Q · Liberal, KSThe acft impacted the terrain just off the departure end of rwy 17 at Liberal, KS, while on a return flt to Texas. Dark night conditons prevailed and no horizon visual cue were available shortly after takeoff. Reliance on flt attitude instruments would have…NTSB MKC87LA016Accident · No injuriesLimited investigationFinal reportCessna 150F · Louisburg, KSThe instructor stated that he had observed the student visually check the fuel supply bu that he did not personally inspect the tanks, assuming they were full. According to the pilot, his only confirmation of full tanks was the students repeated statements…NTSB MKC87LA010Accident · No injuriesLimited investigationFinal reportCessna 185 · Oakley, KSThe plt stated his landing apch was too fast and the acft touched down long. He then applied brakes and the acft nosed down resulting in the propeller striking the rwy. The acft then proceeded to flip over onto it's back. The plt stated he should not have…NTSB MKC87DCQ01Accident · 1 fatalFinal reportJames Olivier Quickie · Harper, KSA witness stated that he observed the aircraft in slow level flight at a low altitude. The a/c then pulled up in a steep right turn, then it descended to the ground. Examination of the wreckage found no pre-impact problems with engine or controls.NTSB MKC87LA001Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Tribune, KSThe PIC rptd eng failure while in cruise flt. The student PIC suspected carb icing as the cause of the eng failure. No mechanical pblm was discovered during the eng inspection. The icing probability charts indicated that carburetor icing was likely in the…NTSB MKC87FA002Accident · 2 fatalField investigationFinal reportCessna 150 · Fort Scott, KSThe purpose of the flt was to observe and photograph the effects of a flood which had inundated a part of the city of Fort Scott. The acft was observed flying low and slow over the city. Witnesses said the acft was flying from west to east and made a turn…NTSB MKC86FA197Accident · No injuriesField investigationFinal reportRockwell NA-265-80 · Liberal, KSThe right main landing gear downlock pin retracted just before or during touchdown. The airplane touched down 21 feet short of the runway. It traveled that 21 feet, traveled the full length of the 6999-foot runway, then traveled another one-fourth of a mile…NTSB MKC86LA194Accident · No injuriesLimited investigationFinal reportCessna 172M · Arkansas City, KSThe plt was landing on his private sod strip which had tall grass along the edges. During the landing roll, he attempted to pick up some papers that had fallen on the cockpit floor. When he looked back up, the acft had drifted to the left. The left wing…NTSB MKC86LA190Accident · No injuriesLimited investigationFinal reportBeech A36 · Horton, KSDrg arrival, the plt noted an 'x' on rwy 35, so he tansitioned to a downwind for rwy 33. At that time, the windsock showed a direct left x-wind for the 1860 ft turf rwy which had a fence across the apch end. The acft touched down about 400 to 500 ft down the…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 MKC86FA181Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Elkhart, KSThe student plt intended to fly from his home arpt to a nearby arpt where he was receiving flt instruction. No record of a wx briefing was found. Local authorities said there were low clouds and fog in the area at the time of the accident. No one saw the acft…NTSB MKC86LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-150C · Junction City, KSThe c.f.I. Stated that this flight was to be an aircraft checkout of another instructor. After some air work they proceeded to a nearby airport to practice takeoffs and landings. While on final approach for a practice short field landing the aircraft…NTSB MKC86LA178Accident · 1 fatalLimited investigationFinal reportCessna 172 · Emporia, KSThe acft was found stopped in an open field having penetrated the southern boundary of the Emporia airport property. The acft eng was still running when rescuers approached the location. Forced entry was made into the acft to shut the eng down and rescue the…NTSB MKC86LA175Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Wilson, KSThe pilot stated that before the flight the spark plugs were cleaned and inspected and the engine was serviced with eleven quarts of oil. Three hours into the flight instrument meteorological conditions (IMC) with rain was encountered and shortly thereafter…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 MKC86LA169Accident · No injuriesLimited investigationFinal reportDavid Gordon Whitman Tailwind · Valley Center, KSThe acft rolled forward unrestrained after the PIC had started the eng. The acft was not moored before the PIC attempted the hand start. The acft rolled a short distance where it impacted the edge of a building and sustained substantial damage. Multiple…NTSB MKC86LA167Accident · No injuriesLimited investigationFinal reportAero Commander 500-B · Emporia, KSThe pilot stated that he was cruising at 6,000 feet in IMC with light to moderate rain and turbulence when he heard a bang followed by the left engine losing power. The engine was shut down, the propeller feathered and ATC was notified. ATC cleared, and the…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 MKC86LA165Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hugoton, KSThe PIC stated that the eng quit on takeoff abt 100 feet abv the gnd and 200 yds past the departure end of the rwy. The PIC stated that he had no warning prior to the engine quitting. The acft dscnd to the gnd, impacted hard and subsequently flipped over…NTSB MKC86LA164Accident · No injuriesLimited investigationFinal reportCessna 188B · Hugoton, KSThe PIC stated that he was flying low and slow in an attempt to observe an acft that had just crashed in an open fld off the departure end of the rwy at Hugoton. The acft was then observed to roll left and descend and impact the gnd about 1/4 mile beyond…NTSB MKC86LA157Accident · No injuriesLimited investigationFinal reportRandolph R.Clark KR-2 · Russell, KSThe pilot had just completed some adjustments to the carburetor and was making a high-speed taxi test when he became airborne. He applied more power to avoid stalling and immediately thereafter, the engine started running rough. He then decided to make a…NTSB MKC86LA153Accident · Minor injuriesLimited investigationFinal reportStevenson Glasair · Oakley, KSThe PIC stated that he had not visually checked the acft's 4 gallon header tank prior to attempting takeoff. During the takeoff the eng would not produce full power. The takeoff was aborted and the PIC inspected the eng for a mechanical pblm. After the…NTSB MKC86LA150Accident · No injuriesLimited investigationFinal reportStainbrook Avid Flyer · Salina, KSThe PIC had been practicing touch and go landings at a private air strip. At 50 feet AGL the PIC stated the engine quit and he descended into the ground off the rwy. Post accident inspection of the eng revealed that the propeller reduction gearing had broken…NTSB MKC86LA149Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Arkansas City, KSThe certified flight instructor stated that his intentions for this flight were to simulate an engine power loss during the early stages of the takeoff roll and have the student perform a rejected takeoff procedure. According to the c.f.I., at approximately…NTSB MKC86LA148Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Olathe, KSThe PIC had mistakenly attempted a landing at another airport 8 miles west of his intended destination. The PIC realized his mistake and diverted to his final destination. The PIC landed at the correct airport, but veered sharply to the right on landing on…NTSB MKC86LA143Accident · No injuriesLimited investigationFinal reportBeech C23 · Cheney, KSThe pilot stated that the aircraft was barely airborne as it reached the end of the airstrip, on the takeoff roll. At this point he encountered crosswind conditions and the aircraft mush/stalled and impacted the ground. Post-accident computations reveal that…