NTSB investigations, KS
8 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 2 |
| 1986 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2002 | 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\" = 300)
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" = 300) 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 CHI02LA098Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Russell, KSThe pilot failed to maintain control of the airplane during the back-taxi. Additional factors were the tailwind and the wind gust.NTSB CHI98LA325Accident · No injuriesLimited investigationFinal reportCessna 120 · Benton, KSthe pilot's inadvertant excessive use of the toe brakes during the landing roll.NTSB CHI95LA059Accident · No injuriesLimited investigationFinal reportAmerican Champion Citabria 7-GCBC · Ulysses, KSthe pilots improper use of brakes during practice landings, and his lack of total experience in tail wheel equipped airplanes.NTSB CHI91LA187Accident · No injuriesLimited investigationFinal reportGrumman American AA1C · Lansing, KSThe pilot became lost/disoriented and attempted a precautionary landing. Factors related to the accident were a low level of fuel and soft terrain (wheat field crop).NTSB MKC87LA010Accident · No injuriesLimited investigationFinal reportCessna 185 · Oakley, KSThe plt stated his landing apch was too fast and the acft touched down long. He then applied brakes and the acft nosed down resulting in the propeller striking the rwy. The acft then proceeded to flip over onto it's back. The plt stated he should not have…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 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 MKC83LA011Accident · No injuriesLimited investigationFinal reportCessna 172PII · Hutchinson, KSPilot made three go-arounds because of gusty winds. While taxiing to tiedown downwind the wind blew the aircraft over. Winds gusting to 25 KTS.