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 MKC84LA182Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Overland Park, KSPrior to a sight-seeing flt, the plt orbained a wx briefing & released test balloons to check the wind spd & drctn. The prevailing wind was in a southerly direction at about 8 KTS. The plt of N4070W initiated his departure from a school yard after another…NTSB MKC84LA173Accident · No injuriesLimited investigationFinal reportCessna 152 · Benton, KSWhile performing practice engine out procedures the student plt positioned the acft for a simulated landing to a wheat field. At practice alt the eng was shut down to simulate eng out flt characteristics. The eng was re-started & left in idle position. At…NTSB MKC84LA170Accident · No injuriesLimited investigationFinal reportStolp Starduster Starduster II · Lawrence, KSDuring takeoff roll from a grass covered runway the plt aborted the takeoff. The acft nosed over as the plt attempted to bring it to a stop. The plt stated that the acft did not appear to be accelerating as it should & so he aborted the takeoff. He said that…NTSB MKC84FA164Accident · Serious injuriesField investigationFinal reportPiper PA-25-235 · Satanta, KSAfter making a swath run, the plt initiated a turn-around in a downwind direction. During the turn, a wing dropped & the acft entered a descent & struck the ground, nose 1st. It then bounced & traveled another 53 ft before stopping & bursting into flames. The…NTSB MKC84LA161Accident · No injuriesLimited investigationFinal reportCessna 172P · Wichita, KSThe acft nosed over while taxiing onto the rwy in high winds. The plt had received the ATIS weather that reported arpt surface winds from 190 degrees at 26 KTS gusting to 41 KTS. The plt taxied to the rwy and was turning to line up when the wind picked up one…NTSB MKC84LA158Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Ellinwood, KSWhile the plt was spraying a field of soybeans, the right main gear of the acft hit an irrigation sys that he had been crossing. The right main gear was torn off, but the acft continued to fly. During the landing on a sod arpt, the prop dug in & the acft…NTSB MKC84LA134Accident · No injuriesLimited investigationFinal reportBeech BE23 · Richmond, KSWhile in cruise on a ferry flight the engine lost power and would only develop partial power. The power degraded to the point that insuficient power was available to maintain flight. The pilot landed in a field and substantial damage occured. Post accident…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 MKC84LA118Accident · No injuriesLimited investigationFinal reportCessna 402 · Gardner, KSWhile landing on rwy 26 the left gear struck an open upheaval of dirt & asphalt, collasping the left main gear. A go-around was executed, & the plt landed on runway 35 with the right main gear and nose gear retracted.NTSB MKC84LA117Accident · No injuriesLimited investigationFinal reportCessna 401 · Wichita, KSThe plt reported that 3-4 secs after he made a smooth landing, the right main landing gear collapsed. The acft then went off the side of the rwy & struck a sign. Post-accident inspection indicated that the right gear had been down & locked before the gear had…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 MKC84FA115Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Garden City, KSThe plt departed kendallville, IN, at about 1800 EST & made a refueling stop at topeka, KS. At topeka, he obtained a wx briefing for a flt to pueblo, CO, his intended destination, & was advised of marginal VFR to IFR conditions on his proposed route. He then…NTSB MKC84LA107Accident · No injuriesLimited investigationFinal reportCessna 340 · Olathe, KSThe acft skidded off the rwy into slush covered terrain alongside the rwy, dragging the left gear in the mud. As the acft continued its fwd roll the main gear struck the edge of a taxiway & collapsed backwards. The rwy was covered with slush at the time of…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 MKC84LA095Accident · No injuriesLimited investigationFinal reportCessna 182Q · Pleasanton, KSThe plt stated that he taxied through mud and snow enroute to the rwy. He said when he applied rt rudder and brake the acft failed to respond. The left wing hit a pole.NTSB MKC84LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415C · N. Stillwell, KSAfter an eng power loss during takeoff climb, the plt landed the acft on the remaining runway. The hard landing resultedin a nose gear collapse. Post accident investigation revealed that the acft had only flown once in 7 months. The old automotive fuel had…NTSB MKC84LA085Accident · No injuriesLimited investigationFinal reportCessna 150L · Ft Riley, KSThe student plt stated he landed hard, bounced and impacted the rwy again, collapsing the nose gear.NTSB MKC84LA080Accident · No injuriesLimited investigationFinal reportCessna 150M · Norton, KSThe solo student landed in a light crosswind on a rwy with patches of snow and ice. The acft slid sideways after bouncing and collided with a snowbank.NTSB MKC84LA073Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lawrence, KSThe dual student allowed the acft to porpoise & yaw and lost control of the acft as it veered into a ditch. The CFI on board tried to correct the situation with rudder and throttle but was unsucessful in the attempt.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 MKC84FA071Accident · 2 fatalField investigationFinal reportCessna 150M · Lincoln, KSThe non-instrument rated plt departed the russell control zone at night in IFR conditions by obtaining a special VFR clearance. After he reported clear of the control zone, there was no further radio contact with ATC facilities. At 0235 CST, the acft was…NTSB MKC84LA070Accident · No injuriesLimited investigationFinal reportCessna 182 · Derby, KSDuring an apch from the south in gusty wind conditions, the acft crossed over wires & shrubbery with 20 deg of flaps. The plt reported that before reaching the rwy, the'lost air & descended straight down.' The acft touched down in mud, short of the rwy. The…NTSB MKC84FA069Accident · Minor injuriesField investigationFinal reportBellanca 17-30 · Kansas City, KSThe acft caught fire shortly after takeoff, the plt declared an emergency and the acft was cleared to 'take any runway or any taxiway.' The plt landed in an open field on the airport. The acft was destroyed by fire. Investigation revealed that the main source…NTSB MKC84LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Augusta, KSThe acft ran off the rwy during landing and collided with a pile of debris, collapsing the landing gear.NTSB MKC84FA046Accident · Serious injuriesField investigationFinal reportCessna 182G · Olathe, KSThe plt was struck on the leg by the acft propeller as he pulled the propeller through during preflight. The eng had been preheated in an enclosed hanger due to the frigid temperatures. The plt stated he primed the engine and put the keyin the ignition prior…NTSB MKC84LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Manhattan, KSThe plt stated that during her arrival at Manhattan, KS, the rwy had patches of snow & was surrounded by snow covered terrain. Just prior to landing, she became aware of a snowbank at the apch end of the rwy. She took evasive action, but the right main gear…NTSB MKC84LA043Accident · No injuriesLimited investigationFinal reportGates Learjet 25 · Kansas City, KSDuring takeoff on a snow covered rwy at night the aircraft ran off the left side of the runway & was damaged. At that time, the rwy was covered with a thin layer of dry snow over the top of hard packed snow. A 50 ft strip had previously been plowed along the…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 MKC84IA040Incident · No injuriesIncident investigationFinal reportDouglas DC-9-15 · Wichita, KSA catastrophic (uncontainted) failure of the left engine occurred at the beginning of the takeoff roll. The takeoff was aborted & fire erupted on the taxi back to the gate. Investigation revealed a broken turbine long shaft.NTSB MKC84LA037Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Garnett, KSWhile enroute pilot was running the acft using the right main fuel tank. He switched to the left to balance the load and the engine quit about 10 seconds after being switched. The pilot could not restart the engine and a forced landing was made in a field.…NTSB MKC84FA033Accident · 1 fatalField investigationFinal reportBeech TC-45J · Kansas City, KSThe acft was a Beech TC-45J that had been modified into a hamilton turboliner under STC SA-1821-WE. During arrival, the plt reported that he encountered moderate icing at 4000 ft. he made a localizer-only apch to rwy 35. An ATC specialist stated that they saw…NTSB MKC84LA026Accident · No injuriesLimited investigationFinal reportCessna 180A · Topeka, KSThe acft veered off the rwy into the grass and collapsed the main landing gear during takeoff. The pilots seat slid aft as the acft accelerated and the pilot lost control of the acft. The acft veered off the left side of the runway into the grass. The pilot…NTSB MKC84LA023Accident · No injuriesLimited investigationFinal reportBeech A-36 · Satanta, KSThe pilot said he was approaching to land and was low on approach. As the aircraft crossed the end of the runway, the left main gear touched down, striking what was described as a curb about 1 foot from the edge of the runway, substantially damaging the left…NTSB MKC84FA014Accident · 5 fatalField investigationFinal reportCessna 210M · Greensburg, KSAt 1619 CST, the non-instrument rated plt called the dodge city fss & requested the current dodge city wx. He was given the current & forcasted wx. He took off at 1825 & at 1846, he called the la junta radio & requested an update on the dodge city wx as well…NTSB MKC84LA012Accident · No injuriesLimited investigationFinal reportCessna 150F · Garnett, KSThe acft collided with trees during final approach to land on a local night flight. The weather was VMC with a 12 mile visibility reported. The pilot reported that during final approach for a full stop landing the acft struck the tops of some trees which…NTSB MKC84LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Augusta, KSThe acft collided with a truck while taxiing out for takeoff. The plt said that when he saw the truck coming from the opposite direction along the side of the rwy he slowed down and steered to the opposite side of the taxiway. The driver of the truck made no…NTSB MKC84LA008Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Lawrence, KSThe plt reported that prior to flt, the fuel gages indicated both tanks were full; however, he did not visually verify the quantity of fuel. During flt, in the vicinity of emporia, KS, the eng lost power while using fuel from the left tank. The plt changed…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 MKC83FA225Accident · No injuriesField investigationFinal reportBeech 60 · Wichita, KSShortly after takeoff, the left eng began to progressively lose power & was shut down. The aircrew notified Beech tower of the problem & reported they would like to return & land. The acft was observed on final apch to rwy 18 with the gear extended & the left…NTSB MKC83LA224Accident · No injuriesLimited investigationFinal reportBeech A36 · Oberlin, KSThe plt stated he was flying near his relatives' house when he switched fuel tanks and the eng began running rough. The plt suspected the magnetos since they had recently been serviced. The plt switched fuel tanks again with the boost pumpson and the engine…NTSB MKC83LA226Accident · No injuriesLimited investigationFinal reportEipper Quicksilver · Wichita, KSThe instructor plt (CFI) & student were on a dual instructional flt, using a registered, 2 place, ultralight acft with a single control stick. According to the CFI, the student was making a takeoff toward the southwest when the acft encountered a gust of wind…NTSB MKC83LA219Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Benton, KSThe pilot was using rwy 34 with the winds 190 degrees at 14 KTS gusting 20 KTS. The acft lifted off to about 10 ft and mushed back to the ground. The acft crossed a ditch and a rood and contacted a 2nd ditch which knocked off its right main landing gear.NTSB MKC83LA220Accident · No injuriesLimited investigationFinal reportCessna 172N · Morland, KSWhile landing on a country road, the acft landing gear encounter a sand pit on the road. The plt reported that the plane ground looped on the sand, ran into a ditch & hit a tree.NTSB MKC83LA217Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lawrence, KSThe pilot stated that he was taking off for his fourth touch and go landing when the acft weathervaned and he lost control of the acft. The nose wheel struck a concrete drainage ditch.NTSB MKC83FU007Accident · Serious injuriesFinal reportAirmass Sunburst · Goddard, KSThe plt landed in a vacant field, aprx 1500 ft long, surrounded by a row of trees. Before initiating a takeoff, he made a ground reconnaissance of the area. The field was covered with grass aprx 6 to 9 inches tall & was oriented on a north-south direction.…NTSB MKC83LA204Accident · No injuriesLimited investigationFinal reportGrumman American AA-B · Bucklin, KSThe plt took off with a near full load of fuel. An adult passenger was in the right seat & a child was seated in the baggage compartment, which was not an approved seat. The density altitude at the arpt was aprx 4100 ft. the plt indicated that he rotated for…NTSB MKC83LA203Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · Junction City, KSDuring arrival, the plt noticed an isolated thunderstorm just to the west of the arpt. While on the approach, he noticed the wind sock indicating a southeast wind with little velocity. The plt stated that when he was on a short final approach, the wind…NTSB MKC83FA201Accident · Serious injuriesField investigationFinal reportGrieme Skybolt · Atchison, KSThe acrt crashed 200 ft short of the rwy when the engine failed to respond on a short final approach. The acft came to rest 100 ft below the rwy level. The landing gear was broken backward. The nose of the acrt was against a dirt bank. There was less than 1…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…