NTSB investigations, KS
17 cases where the first occurrence was “Overrun”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1985 | 3 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1998 | 1 |
| 2003 | 1 |
| 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\" = 340)
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" = 340) 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 CHI05CA141Accident · No injuriesData collectionFinal reportQuicksilver Sport 2S · Maize, KSThe pilot's inadequate preflight planning that failed to ensure adequate takeoff performance, and his delay in aborting the takeoff.NTSB CHI03LA169Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Atchison, KSThe pilot's inadequate inflight decision, which resulted in a landing with a tailwind and an overrun of the runway. Factors contributing to the accident were the tailwind encountered on landing rollout, the variable, gusty winds encountered while in the…NTSB CHI98LA254Accident · No injuriesLimited investigationFinal reportCessna 172P · Abilene, KSThe student pilot's failure to plan his approach so as to be able to stop the airplane on the runway, and the instructor pilot's delay in taking control of the airplane, so as to correct the student's mistake. A factor contributing to this accident was the…NTSB CHI95LA322Accident · Minor injuriesLimited investigationFinal reportBenham F8L Falco · Augusta, KSa sudden shift in wind direction which resulted in diminished airspeed during takeoff.NTSB CHI95LA251Accident · Minor injuriesLimited investigationFinal reportAviat Pitts S2B · Junction City, KSThe pilot's failure to abort the landing despite excessive speed and insufficient runway length remaining. Contributing factors were the pilot's lack of experience in the make and model aircraft, and the crosswind.NTSB CHI94LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Olathe, KSthe pilot-in-command (CFI's) improper compensation for wind conditions and his poor in flight decision making. Factors were a tailwind and a vehicle on the runway.NTSB CHI93LA157Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT301A · Solomon, KSThe pilot's selection of unsuitable terrain on which to takeoff and his delay in aborting the takeoff.NTSB CHI91LA147Accident · No injuriesLimited investigationFinal reportBeech 58P · Wichita, KSA go around was not performed resulting in the proper touchdown not being attained by the pilot.NTSB MKC88LA118Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Olathe, KSAfter a long cross country flight, the pilot said he encountered heavy rain and thunderstorms near his destination. He reported that he was able to continue the flight under VFR, but when landing on the wet runway braking was ineffective. The airplane…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 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 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 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.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 MKC83LA180Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hunter, KSThe plt reported that during arrival at the private strip, his apch was a bit hi & slightly fast. While landing, the acft floated in ground effect. Subsequently, it overran the rwy & impacted a wire fence & dirt bank.NTSB MKC83LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Sedan, KSThe student pilot was on the return leg of a round robin cross country when the encountered clouds and diverted to cushing, OK. Later, when he departed from cushing, he forgot to reset his directional gyro to correspond with the magnetic compass. When his…NTSB MKC82DA123Accident · No injuriesFinal reportPiper PA-28-140 · Conway Springs, KSThe pilot reported that the wind was from the southwest at 3 KTS, but 16 miles away at wichita, KS, it was from 310 degrees at 9 KTS. He selected runway 17, a sod, 2140 ft, private strip. He said that during the takeoff roll, the aircraft became light on the…