NTSB investigations, KS
13 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 2 |
| 1993 | 2 |
| 1994 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 2000 | 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\" = 320)
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" = 320) 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 CHI04LA086Accident · No injuriesLimited investigationFinal reportBeech 1900D · Manhattan, KSThe captain's improper decision due to his attempt to taxi back onto the runway after coming to a stop in the grass, and the resulting collapse of nose landing gear. Contributing factors were the inoperative nose wheel steering, the pilot's inability to…NTSB CHI00LA147Accident · No injuriesLimited investigationFinal reportCessna A188B · Sublette, KSthe failure of the pilot to attain aircraft control. Factors to the accident were the uneven terrain, the failure of the pilot to maintain directional control on the ground, and the crop.NTSB CHI97LA237Accident · No injuriesLimited investigationFinal reportCessna 182F · Haviland, KSthe pilot's improper planning/decision and failure to obtain and/or maintain proper runway alignment during a night landing. Factors relating to the accident were: the airplane's inoperative landing lights, the airport's inoperative runway edge lights, and…NTSB CHI97LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Minneapolis, KSthe pilot's selection of unsuitable terrain on which to land the airplane. A factor relating with the accident was: the large rock, which the airplane contacted.NTSB CHI96LA190Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Oskaloosa, KSfailure of the pilot to maintain proper alignment with the roadway during the takeoff roll. A factor relating to the accident was: the selection of an unsuitable area for takeoff.NTSB CHI94LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Concordia, KSthe flight instructor's inadequate remedial action when the student pilot failed to maintain adequate directional control of the airplane during the landing roll. A related factor is the drifted snow.NTSB CHI94LA029Accident · No injuriesLimited investigationFinal reportCessna 182N · Onaga, KSthe pilot-in-command's poor pre-flight planning and failure to maintain runway alignment. Factors were the dark light conditions and the lack of runway lights.NTSB CHI93LA310Accident · No injuriesLimited investigationFinal reportCessna 177RG · Emporia, KSThe pilot's selection of unsuitable terrain.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 MKC86LA047Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Lawrence, KSThe plt stated he mistook an ice and snow covered area for a taxiway and turned off past the actual taxiway. The acft struck a snowbank which collapsed the nosegear. The blue taxiway light was out. This light marks the edge of taxiway. The taxiway was free of…NTSB MKC84LA253Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Plains, KSThe acft collided with a tall crop during an attempted takeoff from a dirt road. The acft had failed to become airborne on another road after about 2600 ft of run and the attempt was aborted. This takeoff run was about 2800 ft according to the plt. The plt…NTSB MKC83LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Benton, KSThe acft collided with a ditch during an aborted takeoff. The pilot said the takeoff was on rwy 34 which is 2600 ft longthe density alt was 4000 ft. the acft accelerated to 60 KTS but still was not lifting off. As the acft approached the departure end of the…NTSB MKC82DA126Accident · No injuriesFinal reportPiper PA-28-181 · Lawrence, KSThe student pilot was on his third solo cross country flight. A NOTAM was in effect showing part of runway 19 at Lawrence municipal was closed. The pilot said he saw the markings but was distracted by a crosswind. He landed on the closed portion of the runway…