NTSB investigations, KS
132 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 11 |
| 1984 | 3 |
| 1985 | 12 |
| 1986 | 6 |
| 1987 | 5 |
| 1988 | 5 |
| 1989 | 1 |
| 1990 | 7 |
| 1991 | 4 |
| 1992 | 7 |
| 1993 | 5 |
| 1994 | 5 |
| 1995 | 5 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 7 |
| 1999 | 6 |
| 2000 | 5 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 4 |
| 2007 | 8 |
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\" = 250)
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" = 250) 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 DEN08LA013Accident · No injuriesLimited investigationFinal reportLearjet 35A · Goodland, KSThe pilot's failure to maintain aircraft control during the landing.NTSB DEN07LA152Accident · Serious injuriesLimited investigationFinal reportSlingsby Swallow Type T.45 · Hutchinson, KSThe pilot's failure to maintain aircraft control during a low altitude release resulting in an inadvertent stall/spin. Contributing factors were the pilot's decision to turn back to the airport at low altitude and the wind gust.NTSB DEN07LA142Accident · Serious injuriesLimited investigationFinal reportBell 206-L4 · Mullinville, KSThe pilot's failure to maintain main rotor rpm resulting in an uncontrolled descent, collision with transmission wires, and a hard landing. A contributing factor was the tranmission wires.NTSB DEN07LA137Accident · No injuriesLimited investigationFinal reportMooney M20R · Wichita, KSthe pilot's improper flare and recovery from a bounced landing. Contributing factors are the lack of experience of the pilot and the delayed remedial action of the airline transport pilot rated passenger.NTSB DEN07CA097Accident · Minor injuriesData collectionFinal reportStevenson RV-6 · Oakley, KSThe pilot's failure to maintain airspeed during final approach resulting in a inadvertent stall and impact with terrain.NTSB DEN07CA096Accident · No injuriesData collectionFinal reportCessna 172P · Manhattan, KSThe flight instructor's failure to maintain control of the airplane during the landing. A contributing factor was the inadvertent encounter with the military helicopter's rotor wash.NTSB DEN07CA076Accident · No injuriesData collectionFinal reportCessna 172E · Pleasanton, KSThe pilot's failure to maintain control of the airplane during a go-around. Contributing factors were the gusts and crosswinds.NTSB DEN07FA059Accident · 1 fatalField investigationFinal reportBeech H-18 · Great Bend, KSThe pilot's failure to maintain aircraft control during the missed approach which resulted in an inadvertent stall and impact with terrain. A contributing factor was the icing conditions.NTSB DEN07LA040Accident · No injuriesLimited investigationFinal reportBeech A-36 · Great Bend, KSThe pilot's spatial disorientation and subsequent loss of aircraft control while changing radio frequencies and abruptly applying control forces in excess of the design limits of the airframe.NTSB DEN07CA001Accident · Minor injuriesData collectionFinal reportBrantly Helicopter B-2 · Arkansas City, KSthe pilot's failure to maintain aircraft control during takeoff. A contributing factor was the low rotor RPM.NTSB DEN06LA118Accident · 1 fatalLimited investigationFinal reportScheibe Flugzeugbau SF-24A Motorspatz · Wichita, KSThe pilot's failure to maintain aircraft control. Factors were the low airspeed and the inadvertent stall and spin.NTSB DEN06LA061Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Smith Center, KSthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/mush, and subsequent impact with the field and fence. A factor contributing to the accident was the pilot's inadequate flight planning and preparation.NTSB DEN06CA021Accident · Minor injuriesData collectionFinal reportCessna 182E · Lansing, KSthe pilot's inability to maintain aircraft control during the forced landing which resulted in a collision with terrain. A contributing factor was the pilot becoming ill during cruise flight.NTSB CHI05LA171Accident · Serious injuriesLimited investigationFinal reportYonchak Skybolt · El Dorado, KSThe pilot's failure to maintain airspeed while maneuvering in the traffic pattern which resulted in an inadvertent stall. A factor was the low altitude.NTSB CHI05LA015Accident · 1 fatalLimited investigationFinal reportStrissel Pitts S1S · Liberal, KSThe pilot's failure to maintain control of the airplane while performing aerobatic flight maneuvers resulting in an in-flight collision with terrain.NTSB CHI04CA209Accident · Minor injuriesData collectionFinal reportCessna 172M · Sublette, KSThe student pilot's inadequate compensation for the crosswind condition, and her failure to maintain aircraft control during landing. Factors contributing to the accident included the student pilot's unsuccessful recovery from the bounced landings and the…NTSB CHI04CA115Accident · No injuriesData collectionFinal reportVilleneuve RV-3 · Mayetta, KSThe pilot failed to maintain airspeed and aircraft control during final approach, which resulted in a stall/mush flight condition. A factor to the accident was the crosswind and the trees.NTSB CHI04FA025Accident · 1 fatalField investigationFinal reportCommander 114TC · Hutchinson, KSThe pilot's diverted attention during the missed approach which resulted in aircraft control not being maintained. Factors to the accident included the pilot not being current for instrument operations and the low cloud ceiling at night.NTSB CHI03FA251Accident · 1 fatalField investigationFinal reportCessna 182G · Topeka, KSThe pilot's failure to maintain adequate airspeed resulting in a stall during takeoff. Contributing factors were the low altitude he was at during the takeoff, and the trees.NTSB CHI03LA186Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Douglass, KSThe pilot's failure to attain adequate airspeed and his premature liftoff, which resulted in a stall. A factor to the accident was the tree.NTSB CHI03FA003Accident · 1 fatalField investigationFinal reportPiper PA-18A · Garden City, KSThe inadequate preflight planning/preparation and visual flight rules flight into instrument meteorological conditions by the pilot. The clouds, mist, and night conditions were contributing factors.NTSB CHI02LA143Accident · Minor injuriesLimited investigationFinal reportRose 75% Scale Fokker D8 · Derby, KSInadequate preflight planning and inadequate compensation for the wind conditions which resulted in a failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind and the trees which the airplane contacted…NTSB CHI02FA074Accident · 2 fatalField investigationFinal reportCessna 441 · Winfield, KSThe pilot's spatial disorientation resulting in a loss of control and collision with the ground. Additional factors included the pilot operating the airplane with known deficiencies and the instrument flight conditions.NTSB CHI02FA059Accident · 2 fatalField investigationFinal reportBorgman Smyth Sidewinder · Independence, KSThe pilot's failure to maintain control of the airplane and the subsequent inadvertant stall during the base to final turn. A factor associated with the accident was that an unqualified person was piloting the airplane.NTSB CHI02FA034Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Spearville, KSthe pilot's failure to maintain aircraft control and his inadvertent flight into known adverse weather conditions. Factors relating to this accident were the pilot's limited ability to see at night, spatial disorientation, the dark night, and the fog.NTSB CHI01MA006Accident · 2 fatalClass 1 · MajorFinal reportCanadair CL600-2B16 · Wichita, KSthe pilot’s excessive takeoff rotation, during an aft center of gravity (c.g.) takeoff, a rearward migration of fuel during acceleration and takeoff and consequent shift in the airplane’s aft c.g. to aft of the aft c.g. limit, which caused the airplane to…NTSB CHI00FA234Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Beloit, KSthe inadvertent stall. Factors relating to the accident were the pilot's low altitude, his abrupt pull up, the power lines, and his lack of recent flying experience.NTSB CHI00GA160Accident · 2 fatalFinal reportSchweizer 269C · Topeka, KSthe pilot's failure to maintain translational lift while maneuvering, and the loss of tail rotor effectiveness. Factors relating to this accident were the tailwind, low airspeed, low rotor rpm, and the pilot's lack of overall experience in helicopters.NTSB CHI00LA121Accident · No injuriesLimited investigationFinal reportHughes 500C · Salina, KSthe loss of tail rotor effectiveness and the autorotation performed by the pilot. The unfavorable wind was a contributing factor.NTSB CHI00FA090Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Dighton, KSthe inadvertent stall. Factors relating to this accident were the pilot's inadvertent flight into known adverse weather conditions, the icing conditions, and improper in-flight planning by the pilot.NTSB CHI99FA346Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Fort Scott, KSthe failure of the pilot to maintain control of the aircraft. Factors were the pilot's lack of total experience, his lack of familiarity with the airplane, and the stall/spin encountered.NTSB CHI99LA344Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Atlanta, KSthe pilots failure to maintain control of the aircraft. Factors were the aerobatic maneuvers performed by the pilot and the low altitude.NTSB CHI99LA250Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Udall, KSthe failure of maintenance personnel to properly safety the aileron control cable during installation, the disconnected aileron control cable, and the unavailability of aileron control to the pilot.NTSB CHI99FA202Accident · 1 fatalField investigationFinal reportRans S-10 Sakota · La Crosse, KSdirectional control not maintained by the pilot.NTSB CHI99LA172Accident · Minor injuriesLimited investigationFinal reportde Havilland Tiger Moth DH82A · Maize, KSthe pilot's inability to maintain a climb after takeoff as a result of wind shear. Factors associated with the accident were the variable, gusty wind conditions, and the tree which was contacted.NTSB CHI99FA094Accident · 2 fatalField investigationFinal reportCessna 172C · Grenola, KSloss of control in flight due to incapacitation.NTSB CHI99FA023Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-60 · Rock, KSthe pilot failed to maintain control of the aircraft and made an improper evaluation of the weather. Additional factors were flying a test flight at night with the icing conditions in the clouds.NTSB CHI99LA019Accident · No injuriesLimited investigationFinal reportCessna 310R · Wichita, KSthe pilot's inadequate compensation for the wind conditions and the inadequate recovery from the bounced landing which resulted in a loss of control and the ground loop. Factors associated with the accident were the pilot's misjudging the winds conditions and…NTSB CHI98MA260Accident · 2 fatalMajor investigationFinal reportNorth American NA-265-80 · Florence, KSthe pilot's overconfidence in his personal ability, his improper in-flight decision to attempt aerobatics, and his loss of control of the airplane.NTSB CHI98LA224Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Liberal, KSthe inadvertent stall, the pilot's inadequate preflight planning, which led to performing a takeoff with insufficient distance to clear the utility pole. A factor which contributed to this accident was the utility pole.NTSB CHI98LA211Accident · Minor injuriesLimited investigationFinal reportHartzler Nieuport 11 · Gardner, KSthe pilot's inadequate weather evaluation and the aircraft stall. A factor to the accident was the gusting wind.NTSB CHI98LA161Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Manhattan, KSthe pilot did not attain proper flying speed. Factors included the high density altitude and crosswind condition.NTSB CHI98LA135Accident · No injuriesLimited investigationFinal reportCessna C-182 · Emporia, KSThe pilot's failure to maintain control of the airplane. Factors contributing to this accident were the strong crosswind and the wind gusts.NTSB CHI98LA071Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Valley Center, KSthe pilot's excessive pull up after lift-off and failure to maintain adequate airspeed during the initial climb, which resulted in a stall and collision with wooded terrain.NTSB CHI98LA024Accident · No injuriesLimited investigationFinal reportBeech 23 · Salina, KSthe student pilot's excessive pull-up and the flight instructor's inadequate supervision during a simulated engine failure after takeoff, resulting in a stall/mush onto the runway.NTSB CHI97LA302Accident · Serious injuriesLimited investigationFinal reportRans S-11 Pursuit · Hays, KSfailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall and collision with the terrain. The pilot's lack of experience in the make and model of airplane was a related factor.NTSB CHI96LA164Accident · No injuriesLimited investigationFinal reportSchlitter Rans S6ES Coyote II · Hays, KSfailure of the pilot to maintain control of the airplane, when it settled back to the runway after lift-off. A factor relating to the accident was: premature raising of the flaps after lift-off.NTSB CHI96LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pittsburg, KSan inadequate annual inspection by maintenance personnel, a deteriorated muffler, and pilot incapacitation due to carbon monoxide.NTSB CHI95LA302Accident · 1 fatalLimited investigationFinal reportMorrow Starduster I · Ottawa, KSthe pilot's delayed remedial action during the inverted spin maneuver. A factor associated with the accident was the pilot's lack of recent experience in the type operation.NTSB CHI95LA289Accident · No injuriesLimited investigationFinal reportBeech B-60 · Salina, KSthe pilot's inattentiveness to the severity of the weather conditions, and his failure to maintain airspeed. Factors in the accident were: the icing conditions, airframe ice accumulation, and the design stress limits of the airplane being exceeded by the…