NTSB investigations, KS
17 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2004 | 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\" = 310)
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" = 310) 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 CHI04CA092Accident · No injuriesData collectionFinal reportCessna 150J · Gardner, KSThe pilot's inadequate visual lookout and failure to maintain clearance from the post. A factor was the post.NTSB CHI02LA162Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Beaumont, KSThe pilot's inadequate preflight planning and his failure to abort the takeoff when he realized the aircraft was not accelerating as expected. The wet and muddy turf runway was a contributing factor.NTSB CHI00LA099Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Ft. Leavenworth, KSthe pilot of N51933 did not see and maintain clearance from N9570E. A factor associated with the accident was the pilot of N51933's restricted forward visibility during the landing due to the tailwheel configuration. An additional factor was the pilot of…NTSB CHI97LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Council Grove, KSthe pilot's selection of an unsuitable area for landing and the fence post. Factors relating to this accident were the pilot's inability to see the fence post due to the high vegetation, and the soft dirt.NTSB CHI95LA338Accident · No injuriesLimited investigationFinal reportHelio U-10D · Wellsville, KSThe pilot's improper weather evaluation. A factor was the pilot's inadequate compensation for the wind conditions.NTSB CHI94LA344Accident · No injuriesLimited investigationFinal reportPrest Eagle II · Wellsville, KSthe pilot-in-command's inadequate visual lookout.NTSB MKC88LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Topeka, KSWhile taxiing in from a personal solo training flight, the student pilot taxied into a chain link fence while attempting to park the acft. The right wing spar sustained substantial damage.NTSB MKC86LA124Accident · No injuriesLimited investigationFinal reportCessna A188 · Blaine, KSThe plt stated that a calf, weighing aprx 500 lbs, ran in fnt of the acft, just as it was apchg lift-off. Subsequently, the acft went out of control & skidded, collapsing the main landing gear. Until just prior to impact, the calf was hidden from the plt's…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 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 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 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 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 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 MKC83LA126Accident · No injuriesLimited investigationFinal reportCessna 182K · Plainville, KSThe acft collided with a post during a precautionary landing on a road. The plt had been flying on this flt for 2 and a half hours when he noticed the oil pressure go to zero. He landed on a highway and during the landing roll the right wing hit a signpost…NTSB MKC83LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140B · Emporia, KSThe instructor pilot (ip) and a student were practicing stop-and-go landings in a Cessna 152, N89585, at an uncontrolled airport. The ip reported that they were monitoring the UNICOM frequency and had announced their intentions before each stop-and-go. The ip…NTSB MKC82DA172Accident · No injuriesFinal reportErcoupe 415C · Andover, KSPilot reported he was taxiing and turned to avoid animals. Aircraft then collided with a tree. He had given two other versions verbally of how the damage occurred.