NTSB investigations, KS
35 cases where the sequence of events included Nose over/nose down.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 3 |
| 2011 | 4 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 4 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 3 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 2 |
| 2026 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '096' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '096' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN26LA104Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Augusta, KSThe student pilot’s failure to maintain control during the takeoff.NTSB CEN24LA262Accident · No injuriesClass 4 · LimitedFinal reportSkystar Kitfox · Hackney, KSThe pilot’s failure to maintain directional control during the landing roll in a gusting wind condition.NTSB CEN24LA166Accident · No injuriesClass 4 · LimitedFinal reportRans S-6ES · Emporia, KSThe pilot’s failure to maintain control during the landing flare.NTSB CEN24LA002Accident · No injuriesClass 3 · LimitedFinal reportCessna 182R · Olathe, KSThe pilot’s mismanagement of the available fuel which resulted in a total loss of engine power due to fuel starvation.NTSB CEN23LA222Accident · No injuriesClass 4 · LimitedFinal reportPitts S-2S · Garden Plain, KSThe pilot’s inability to maintain directional control during landing roll due to a flat tire.NTSB CEN22LA367Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Benton, KSThe loss of engine power for undetermined reasons.NTSB CEN22LA079Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Ellinwood, KSThe pilot's improper brake application during the landing roll, which resulted in a nose-over.NTSB CEN20LA029Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8A · Baldwin City, KSThe pilot's failure to maintain directional control during takeoff, and the flight instructor's delayed remedial action, which resulted in a runway excursion and nose over.NTSB GAA19CA300Accident · Minor injuriesData collectionFinal reportVans RV6 · Rose Hill, KSThe pilot's unintentional engagement of the brakes before landing, which resulted in a nose-over.NTSB CEN19LA111Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Newton, KSThe loss of engine power after the No. 1 connecting rod end separated as a result of oil starvation, which led to the forced landing and nose-over.NTSB CEN19LA046Accident · No injuriesLimited investigationFinal reportCessna 120 · Beaumont, KSThe right brake being locked during the landing roll on the turf runway for reasons that could not be determined during postaccident examinations, which resulted in a noseover.NTSB GAA17CA531Accident · No injuriesData collectionFinal reportCessna 210 · Kinsley, KSThe pilot's decision to continue an unstabilized approach for landing in tailwind conditions, which resulted in a runway overrun and a nose-over.NTSB GAA17CA273Accident · No injuriesData collectionFinal reportAdrian George W Europa Classic · Wellington, KSThe pilot’s improper landing flare and exceedance of the airplane’s critical angle of attack during landing, which resulted in an aerodynamic stall.NTSB GAA17CA234Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Stafford, KSThe pilot's failure to maintain directional control during the takeoff roll.NTSB GAA17CA059Accident · Minor injuriesData collectionFinal reportHaring Clay RV6 · Eureka, KSThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA16CA379Accident · Minor injuriesData collectionFinal reportJesse Saint/Troy Townsend/Etha CH-801 · Beaumont, KSThe pilot's incorrect pitch control during the landing flare in gusty crosswind conditions, which resulted in a hard bounced landing and a nose over.NTSB GAA16CA200Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164 · Madison, KSThe pilot's incorrect brake application during the landing roll, which resulted in a nose over.NTSB GAA15CA226Accident · No injuriesData collectionFinal reportStick & Rag Flying Club CB 1 · Kingman, KSThe separation of the left wheel from the landing gear assembly during the landing touchdown, which precipitated a loss of directional control, runway excursion, and nose over.NTSB CEN15LA330Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Emmett, KSThe engine failure due to several loose, damaged cylinder stud nuts and hold-down bolts. Contributing to the accident was maintenance personnel’s failure to detect that the cylinder nuts and hold-down bolts were not properly secured during the engine’s most…NTSB CEN15CA201Accident · Minor injuriesData collectionFinal reportFiebich Paul Dean Airbike RX40 · Derby, KSThe pilot's inadequate compensation for wind conditions during the landing, which resulted in a hard landing and separation of the left main landing gear.NTSB CEN15FA163Accident · 1 fatalField investigationFinal reportAhrens Gerd H RV 6 · Pratt, KSA hard landing, which resulted in the pilot’s loss of directional control and the airplane’s subsequent nose-over.NTSB CEN14LA436Accident · No injuriesLimited investigationFinal reportCessna 170B · Augusta, KSThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CEN13CA453Accident · No injuriesData collectionFinal reportLuscombe 8A · Ellinwood, KSThe pilot failed to maintain directional control during takeoff.NTSB CEN13CA423Accident · No injuriesData collectionFinal reportBeech C23 · Augusta, KSThe pilot did not obtain adequate airspeed and clearance from obstructions during a grass field takeoff.NTSB CEN12CA499Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Hutchinson, KSThe pilot’s loss of directional control during the landing roll.NTSB CEN12CA233Accident · No injuriesData collectionFinal reportCessna 210H · Marienthal, KSThe pilot's inadequate compensation for the wind during landing.NTSB CEN12LA135Accident · No injuriesLimited investigationFinal reportCessna 150M · El Dorado, KSThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN12CA117Accident · No injuriesData collectionFinal reportLuscombe 8E · Atchison, KSThe pilot's inadequate directional control during the landing roll.NTSB CEN12CA003Accident · Serious injuriesData collectionFinal reportSadler Terry Rans S-7 Courier · Riley, KSA total loss of engine power during takeoff due to fuel starvation as a result of the pilot’s inadequate preflight inspection and failure to ensure that the fuel shutoff valve was turned on before departure.NTSB CEN11LA356Accident · Minor injuriesLimited investigationFinal reportBell 206 · Walton, KSA loss of engine power for undetermined reasons because postaccident examination of the airframe and engine revealed no anomalies.NTSB CEN11CA256Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Wichita, KSThe pilot's failure to maintain directional control during the landing roll.NTSB CEN09CA552Accident · No injuriesData collectionFinal reportCessna 150F · Abilene, KSThe pilot's inadequate crosswind landing technique, resulting in an excessive side load on the left landing gear that led to an overload failure of its axle.NTSB CEN09CA229Accident · No injuriesData collectionFinal reportCessna 172 · Manhattan, KSThe pilot's improper recovery from a bounced landing.NTSB CEN09CA158Accident · Minor injuriesData collectionFinal reportCessna 170 · Cottonwood Falls, KSThe decision of the pilot to attempt operations outside the forward center of gravity limit. Contributing to the accident was the pilot's selection of an inadequate runway for the conditions.NTSB DEN08CA063Accident · No injuriesData collectionFinal reportPiper PA-22 · Nickerson, KSthe pilot's failure to maintain directional control during the landing roll resulting in a departure from the runway environment. Contributing to the accident was the soft runway surface.