NTSB investigations, KS
42 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 1 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 CHI05CA150Accident · No injuriesData collectionFinal reportCessna 172P · St. Francis, KSThe pilot's failure to compensate for the crosswind conditions during landing and the unsuccessful go-around. A factor was the crosswind.NTSB CHI04FA157Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Great Bend, KSThe pilot's inadequate preflight planning due to his failure to obtain a weather briefing prior to takeoff. Additional causes were the pilot's inadvertent flight into adverse weather and his failure to maintain clearance with the terrain during his attempt to…NTSB CHI04FA066Accident · 3 fatalField investigationFinal reportBeech B90 · Dodge City, KSThe pilot failed to maintain clearance with terrain due to pilot fatigue (lack of sleep).NTSB CHI03LA116Accident · No injuriesLimited investigationFinal reportWalker Lancair IV · Wamego, KSThe pilot not maintaining altitude/clearance from the runway while maneuvering on final approach. A factor to the accident was the pilot's misjudgment of his altitude while on final approach.NTSB CHI03LA064Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Halstead, KSFailure by the flight crew to execute an aborted takeoff when acceleration degraded and the improper soft field takeoff procedure as flown by the private pilot. Contributing factors were inadequate supervision by the flight instructor and the tailwind…NTSB CHI02LA206Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401B · Pratt, KSThe pilot's failure to maintain terrain clearance. A factor was low altitude flight.NTSB CHI01LA137Accident · 1 fatalLimited investigationFinal reportBellanca 14-13-3 · Scott City, KSThe low level roll maneuver the pilot performed on final to runway 17 and his not maintaining clearance from terrain during the maneuver.NTSB CHI00LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Liberal, KSthe pilot not maintaining proper glidepath on the ILS approach, the pilot's improper decision to continue the approach below the glidepath, and the pilot's failure to perform a missed approach. Factors relating to the accident were the low ceiling and…NTSB CHI99LA158Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman PT-27 · Grainfield, KSThe pilot's improper in-flight decision and failure to maintain adequate clearance with the ground.NTSB CHI98LA051Accident · No injuriesLimited investigationFinal reportBeech E55 · Gardner, KSthe inadvertant landing gear retraction, which occurred due to undetermined reason(s).NTSB CHI98FA022Accident · 3 fatalField investigationFinal reportMooney M20K · Emporia, KSThe pilot's failure to maintain an altitude above the minimum descent altitude for the approach. Factors contributing to this accident were the low ceiling, rain, and fog.NTSB CHI97LA008Accident · No injuriesLimited investigationFinal reportHughes 369E · Hesston, KSthe pilot selected unsuitable terrain for landing. The factors involved were: an inoperative landing light, dusk light conditions, and the terrain condition.NTSB CHI96LA319Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Pittsburg, KSthe pilot diverted his attention and failed to maintain sufficient altitude and clearance with the terrain. Factors relating to the accident were: darkness, and the pilot performing low altitude flight at night.NTSB CHI96LA031Accident · No injuriesLimited investigationFinal reportBeech 35 · Belleville, KSthe pilot misjudging his approach to the runway. Factors relating to the accident were: the weather conditions, a sick passenger that diverted the pilot's attention, the snow covered terrain, and the pilot's decision not to execute the missed approach…NTSB CHI95LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Kingman, KSthe pilot's failure to obtain sufficient airspeed before liftoff, and his delay in aborting the takeoff. A factor relating to the accident was: the pilot's lack of recent flying experience.NTSB CHI95LA122Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Meade, KSthe pilot taking off the airplane at a low liftoff speed (Vlo). A factor associated with the accident was a stall/mush encountered by the pilot.NTSB CHI94LA233Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Tribune, KSthe pilot's failure to maintain clearance above the corn crop during the swath run.NTSB CHI94LA193Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Levant, KSThe pilot's inadequate evaluation of weather conditions associated with known thunderstorm activity. Factors were the thunderstorm and downdrafts.NTSB CHI94LA106Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Sublette, KSthe commercial pilot's failure to maintain clearance from terrain. Related factors are sun glare and rising terrain.NTSB CHI93LA169Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Garden City, KSThe pilot-in-command's not maintaining proper altitude.NTSB CHI93LA114Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Park, KSThe pilot-in-command's physical incapacitation for reason or reasons undetermined.NTSB CHI93FA036Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Ft. Riley, KSThe non-current student pilot's failure to maintain adequate clearance from terrain while operating at night, in instrument meteorological conditions.NTSB CHI92DCQ04Accident · Minor injuriesFinal reportWSK PZL Mielec M18 · Norton, KSFailure of the pilot in command to level off while performing aerial application.NTSB CHI91LA242Accident · Minor injuriesLimited investigationFinal reportAmerican AA1 · Spearville, KSThe pilot's selection of unsuitable terrain on which to perform a precautionary landing. Factors related to the accident were poor in flight/planning decision which resulted in the pilot becoming lost/disoriented.NTSB MKC90DCQ02Accident · 1 fatalFinal reportBell UH-1B · Ulysses, KSThe pilot failed to maintain proper rotor RPM, while maneuvering over a high obstruction (power line) at the end of a swath run, which resulted in an inadvertent descent & collision with the terrain. The high obstruction was considered to be a related factor.NTSB MKC89LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Clayton, KSThe failure of the pilot to compensate for the unfavorable wind conditions.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 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 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 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 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 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 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 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 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 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 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 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 MKC82FCQ11Accident · Serious injuriesFinal reportCessna 188B · Scott City, KSThe aircraft crashed during an aerial application operation; however, the pilot could not remember the details of the accident. He believed that the propeller may have started to turn excessively fast, but this was not verified. After contacting the ground,…NTSB MKC82DA108Accident · No injuriesFinal reportCallair A-9B · Ulysses, KSThe pilot was on a spray flight over an area of sand hills. While dropping flags to help determine the wind on the surface, he encountered unfavorable wind conditions and a sudden loss of lift. He applied full power, but was unable to recover from the mushing…NTSB MKC82FCQ10Accident · Serious injuriesFinal reportBeech A35 · Bird City, KSThe pilot entered traffic to land on runway 26 at a private airport with no UNICOM and no usable windsock. He stated that on final approach, the aircraft encountered a gust of wind and rolled to the right. He was unable to recover. The right wing hit the…NTSB MKC82DA049Accident · No injuriesFinal reportCessna 172 · Jetmore, KSThe aircraft was flown out to an oil well site to air drop a valve. The pilot stated that after dropping the valve he turned around in his seat to see where the valve hit and he ran the aircraft into the ground.