NTSB investigations, KS
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 CHI94FA253Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Wellington, KSthe pilot's failure to maintain aircraft control during the emergency descent, resulting in a stall-spin. Factors were fuel exhaustion resulting from improper fuel calculations by the pilot.NTSB CHI94LA233Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Tribune, KSthe pilot's failure to maintain clearance above the corn crop during the swath run.NTSB CHI94DCQ02Accident · Minor injuriesFinal reportWSK PZL Mielec M-18 Dromader · Colby, KSfuel starvation resulting from the fuel shutoff valve closing as a result of improper adjustment.NTSB CHI94FA222Accident · 4 fatalField investigationFinal reportBeech A36 · Wichita, KSthe pilot's attempt to take off into known adverse weather and the subsequent stall. Factors were the thunderstorm, the tailwind, and the excessive airplane gross weight and aft center of gravity.NTSB CHI94LA220Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Garden City, KSfuel exhaustion for reason or reasons undetermined. A factor was the rough/uneven terrain.NTSB CHI94LA193Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Levant, KSThe pilot's inadequate evaluation of weather conditions associated with known thunderstorm activity. Factors were the thunderstorm and downdrafts.NTSB CHI94LA184Accident · No injuriesLimited investigationFinal reportCessna 150M · Concordia, KSthe pilot-in-command's misjudging of the altitude of the airplane and his diversion of attention during the landing. A factor was the improper use of the throttle by the pilot-in-command.NTSB CHI94LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Olathe, KSthe pilot-in-command (CFI's) improper compensation for wind conditions and his poor in flight decision making. Factors were a tailwind and a vehicle on the runway.NTSB CHI94LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Anthony, KSthe pilot's failure to obtain sufficient airspeed prior to liftoff. A factor in the accident was the pilot's lack of total experience in type of airplane.NTSB CHI94LA153Accident · No injuriesLimited investigationFinal reportMaule M-4 · Salina, KSFailure of the pilot to maintain directional control, which resulted in an inadvertent ground loop/swerve. Factors related to the accident were: the crosswind, and the pilot's lack of experience in the make and model of aircraft.NTSB CHI94LA152Accident · Minor injuriesLimited investigationFinal reportGrumman American TR-2 · Wichita, KSwas the pilot-in-command not performing an aborted landing after the first porpoise event and bounce into the air. Factors associated with this accident were an excessive airspeed and porpoising encountered by the pilot-in-command.NTSB CHI94LA132Accident · Serious injuriesLimited investigationFinal reportAerostar RX-7 · Augusta, KSThe improper touchdown performed by the balloon pilot.NTSB CHI94DCQ01Accident · 1 fatalFinal reportRobert O. ELY STARDUSTER-II SA300 · Baxter Springs, KSthe pilot's failure to maintain altitude during an aerobatic maneuver on takeoff. A factor related to the accident was the pilot performing an aerobatic maneuver.NTSB CHI94LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-300 · Beloit, KSthe pilot's failure to maintain sufficient airspeed during the initial takeoff climb.NTSB CHI94LA106Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Sublette, KSthe commercial pilot's failure to maintain clearance from terrain. Related factors are sun glare and rising terrain.NTSB CHI94FA097Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Inman, KSAn unintentional spin which occurred during the maneuvering phase of a biennial flight review. A factor related to the accident was: the airplane's lateral-directional characteristics at or near the stall speed.NTSB CHI94LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lindsborg, KSwas the pilot-in-command's failure to refuel the airplane during the flight. Factors were fuel exhaustion, the sign, and the pilot-in-command's lack of total experience in type of airplane.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 CHI94LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Wichita, KSThe pilot's failure to attain the proper touchdown point and delay in aborting the landing. The pilot's inadequate training was a factor.NTSB CHI94LA073Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Olathe, KSthe pilot's failure to follow procedures and directives regarding the positioning of the fuel tank selector to the fullest tank for the landing portion of flight.NTSB CHI94LA069Accident · Serious injuriesLimited investigationFinal reportPlummer Supercat · Stafford, KSThe pilot's failure to refuel the airplane prior to fuel exhaustion, and his failure to maintain airspeed resulting in an aerodynamic stall. His inadequate training was a factor in the accident.NTSB CHI94FA050Accident · 3 fatalField investigationFinal reportMitsubishi MU-300 · Goodland, KSThe pilot-in-command's inadvertent stall of the airplane. A factor associated with the accident is the pilot-in-command's poor IFR procedures.NTSB CHI94LA042Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Pratt, KSThe pilot-in-command's failure to maintain clearance from obstacles. Factors contributing to the accident are the pilot's misjudged fuel consumption calculations and the weather (high winds).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 CHI94LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Benton, KSThe failure of the student pilot to maintain directional control and proper runway alignment during the landing roll. The proximity of the ditch to the runway was a related factor.NTSB CHI93LA323Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Ellis, KSthe pilot's inadequate preflight planning and preparation. Factors in the accident are the pilot's premature liftoff, his failure to keep the airplane properly aligned during the initial climb, and the high density altitude.NTSB CHI93LA313Accident · No injuriesLimited investigationFinal reportCessna 150M · Blue Rapids, KSthe loss of engine power for an undetermined reason.NTSB CHI93LA310Accident · No injuriesLimited investigationFinal reportCessna 177RG · Emporia, KSThe pilot's selection of unsuitable terrain.NTSB CHI93LA304Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Coffeyville, KSUndetermined.NTSB CHI93DCQ02Accident · No injuriesFinal reportCessna 188 · Buhler, KSthe loss of engine power due to a fractured accessory (camshaft) drive gear.NTSB CHI93MA276Accident · 3 fatalMajor investigationFinal reportCanadair CL-600-2B19 · Byers, KSThe captain's failure to adhere to the agreed upon flight test plan for ending the test maneuver at the onset of prestall stick shaker, and the flightcrew's failure to assure that all required switches were properly positioned for anti-spin chute deployment.…NTSB CHI93FA267Accident · 4 fatalField investigationFinal reportCessna 310C · Norton, KSThe pilot's failure to maintain aircraft control due to alcohol impairment. Factors which contributed to the accident were: the pilot's intentional flight into adverse weather, fog, and the dark night.NTSB CHI93LA260Accident · 2 fatalLimited investigationFinal reportChampion 7KCAB · Hill City, KSthe loss of engine power for an undetermined reason and the pilot's decision to continue flying the airplane with known deficiencies. Factors in the accident are the lack of suitable terrain available for a forced landing, the airplane's low altitude, and the…NTSB CHI93LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Bloom, KSimproper refueling by a person or persons unknown. A factor was deteriorated fuel.NTSB CHI93DCG01Accident · 2 fatalFinal reportEmory W. Greer, JR. VARI-EZE · Olathe, KSthe pilot's failure to secure a fuel cap during the preflight inspection of the airplane, and the pilot's failure to maintain aircraft control during the emergency landing. Factors associated with the accident are the unsecured fuel cap and the foreign object…NTSB CHI93LA186Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Derby, KSThe pilot in command's misjudged approach to landing.NTSB CHI93DCQ01Accident · 1 fatalFinal reportGrumman G-164A · Liberal, KSthe pilot's failure to maintain clearance with the powerlines. A factor related to the accident were the powerlines which were contacted during the aerial application operation.NTSB CHI93LA157Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT301A · Solomon, KSThe pilot's selection of unsuitable terrain on which to takeoff and his delay in aborting the takeoff.NTSB CHI93LA169Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Garden City, KSThe pilot-in-command's not maintaining proper altitude.NTSB CHI93LA141Accident · No injuriesLimited investigationFinal reportBeech V-35B · Bennington, KSThe pilot-in-command's failure to maintain directional control of the aircraft.NTSB CHI93FA135Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Kinsley, KSThe pilot initiated VFR flight into instrument meteorological conditions which resulted in a loss of aircraft control due to spatial disorientation. The adverse weather conditions were factors which contributed to the accident.NTSB CHI93LA138Accident · No injuriesLimited investigationFinal reportCessna 172N · Towanda, KSThe pilot failed to adequately compensate for a gusty crosswind condition.NTSB CHI93LA114Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Park, KSThe pilot-in-command's physical incapacitation for reason or reasons undetermined.NTSB CHI93FA075Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Wichita, KSAn improper use of the flight controls by the pilot-in-command.NTSB CHI93LA070Accident · Serious injuriesLimited investigationFinal reportAero Commander 500-B · Susank, KSThe pilot's continued flight into adverse weather and the owner's representation that the airplane met the requirements for flight into icing conditions. The weather and airframe ice were factors in the accident.NTSB CHI93LA066Accident · Minor injuriesLimited investigationFinal reportCessna 310R-II · Marysville, KSThe pilot's failure to maintain sufficient airspeed. Factors contributing to the accident were the icing conditions encountered, and the windshield & airframe ice.NTSB CHI93LA044Accident · No injuriesLimited investigationFinal reportCessna 150M · Newton, KSThe pilot's improper use of rudder control and subsequent failure to maintain directional control.NTSB CHI93LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Kechi, KSMaintenance not performed (gasket deteriorated), other maintenance personnel.NTSB CHI93FA036Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Ft. Riley, KSThe non-current student pilot's failure to maintain adequate clearance from terrain while operating at night, in instrument meteorological conditions.NTSB CHI93LA015Accident · No injuriesLimited investigationFinal reportBeech K35 · Scott City, KSFailure of the alternator and the pilot's inadvertent descent.