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 CHI02LA162Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Beaumont, KSThe pilot's inadequate preflight planning and his failure to abort the takeoff when he realized the aircraft was not accelerating as expected. The wet and muddy turf runway was a contributing factor.NTSB CHI02IA151Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Wichita, KSThe flightcrew's failure to verify the engine instrument indications and powerplant controls while on autopilot with the autothrottles engaged, and their failure to recognize the drop in airspeed which led to an aerodynamic stall associated with the reduction…NTSB CHI02LA147Accident · No injuriesLimited investigationFinal reportWaco ASO · Goodland, KSFailure of the tailwheel assembly after touchdown that resulted in loss of airplane directional control, which the pilot could not correct. A contributing factor was the improper assembly of the tailwheel.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 CHI02FA112Accident · 1 fatalField investigationFinal reportPiper 601P · Moscow, KSThe pilot's intentional operation of the airplane with a known engine boost problem resulting in the improper use of brakes to maintain directional control during takeoff, the brake system fire, and the loss of control for undetermined reasons during the…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 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 CHI02LA072Accident · No injuriesLimited investigationFinal reportBeech 23 · Salina, KSthe student pilot's improper flare and the CFI failed to take remedial action.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 CHI02LA056Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Olathe, KSThe pilot's failure to maintain directional control during landing resulting in the overload of the nose gear fork. The overload failure of the nose landing gear fork, the embankment, and the remedial action not possible were contributing factors.NTSB CHI02LA047Accident · No injuriesLimited investigationFinal reportDassault Falcon 100 · Lawrence, KSThe copilot's failure to maintain aircraft control during the landing. Factors relating to this accident were the copilot's improper in-flight decision not to execute a go-around, the copilot not performing a go-around, the inadequate crew coordination prior…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 CHI02LA002Accident · No injuriesLimited investigationFinal reportWorner 1000 STU · Liberal, KSThe pilot's inadvertent flight into adverse weather conditions during cruise flight and the unsuitable landing area encountered during the uncontrolled descent. Factors relating to this accident were the high wind, the pilot's unsuccessful attempt to…NTSB CHI01LA307Accident · No injuriesLimited investigationFinal reportCessna 182RG · Manhattan, KSthe instructor pilot allowing an excessive descent rate to develop and not correcting the excessive descent rate.NTSB CHI01FA291Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Crestline, KSThe airplane's departure from level flight and subsequent impact with the terrain as a result of a maneuver initiated by the pilot, and the pilot's failure to maintain clearance from the terrain. The reason for the pilot's actions were not determined.NTSB CHI01LA195Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Ellinwood, KSThe pilot failed to see and avoid the guy wire during an aerial application flight. A factor associated with the accident was the guy wire.NTSB CHI01LA196Accident · No injuriesLimited investigationFinal reportCessna 150L · Randolph, KSThe unsuitable terrain encountered by the pilot during the forced landing. Factors to the accident were the loss of engine power for undetermined reasons and the rough/uneven terrain condition.NTSB CHI01MA163Accident · Serious injuriesMajor investigationFinal reportLearjet 25D · Salina, KSThe PIC's delayed remedial action during the elevator system oscillation, resulting in the failure of the aft elevator sector clevis due to reverse bending fatigue caused by vibration, and subsequent loss of elevator control. Factors contributing to the…NTSB CHI01LA137Accident · 1 fatalLimited investigationFinal reportBellanca 14-13-3 · Scott City, KSThe low level roll maneuver the pilot performed on final to runway 17 and his not maintaining clearance from terrain during the maneuver.NTSB CHI01FA130Accident · 2 fatalField investigationFinal reportCessna 172N · Wichita, KSthe student pilot not maintaining clearance from the tower support wire during the practice emergency landing maneuver and the instructor pilot's inadequate supervision of the student pilot. Factors relating to the accident were the static wire and the low…NTSB CHI01LA101Accident · No injuriesLimited investigationFinal reportCessna P206 · Derby, KSThe misjudged in-flight planning the pilot had for the forced landing. Factors were the induction air ducting separation, the pilot not coordinating his emergency procedure with airfield traffic, and the trees.NTSB CHI01FA067Accident · 2 fatalField investigationFinal reportCessna 182B · Piedmont, KSThe pilot's failure to maintain obstacle clearance. Contributing factors were low altitude maneuvering and the transmission wire.NTSB CHI01LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Manhattan, KSthe inadequate soft field takeoff procedure by the pilot and his failure to abort the takeoff. Factors were the high grass on the runway, the pilots disregard for the runway conditions, his lack of total experience in the aircraft, the trees, and the pilots…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 CHI00LA304Accident · No injuriesLimited investigationFinal reportCessna 182S · Wichita, KSthe pilot's failure to maintain aircraft control during the landing. Factors relating to this accident were the pilot's improper recovery from the bounced landing and his failure to go-around.NTSB CHI00LA289Accident · No injuriesLimited investigationFinal reportCessna A188B · Nickerson, KSaltidude/clearance not obtained/maintained by the pilot. Factors to the accident were the hay bale, the inadequate preflight planning/preparation by the pilot, the high-density altitude, and the high weight of the aircraft at the time of the accident.NTSB CHI00LA273Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Parsons, KSthe pilot not maintaining clearance from the fence post and not attaining the proper touchdown point. A factor was the fence post.NTSB CHI00LA243Accident · 1 fatalLimited investigationFinal reportPiper PA-36-285 · Osborne, KSThe unsuitable terrain for landing encountered by the pilot during the forced landing. Factors were the failure of the number four piston and cylinder, the soft terrain, and the main landing gear overload and subsequent collapse.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 CHI00LA191Accident · No injuriesLimited investigationFinal reportCessna A188B · Washington, KSthe failure of the number-two connecting rod bearing and the unsuitable terrain for landing encountered by the pilot during the forced landing. A factor to the accident was the rough/uneven field.NTSB CHI00LA187Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Topeka, KSthe restricted fuel line, and the pilot not attaining proper runway alignment during the forced landing. Factors were the low altitude at which the engine failure occurred, and the landing gear overload.NTSB CHI00LA173Accident · Minor injuriesLimited investigationFinal reportMcclish Funk B85C · Gardner, KSan improper modification to the engine which allowed a bearing to be misaligned, thus restricted the flow of oil through the engine. A factor associated with the accident was the wet field in which the forced landing was made.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 CHI00LA149Accident · No injuriesLimited investigationFinal reportPiper PA-36-200 · Oakley, KSthe directional control not maintained by the pilot. The thunderstorm, quartering tailwind/crosswind and the weather evaluation by the pilot were contributing factors.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 CHI00LA137Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Ionia, KSthe partial engine failure for undetermined reasons and the unsuitable terrain for landing encountered by the pilot. A factor to the accident was the hilly terrain condition.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 CHI00LA096Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec PZL-M-18 · Bucklin, KSthe right main gear brake was binding for an undetermined reason which resulted in the pilot's inability to maintain directional control of the airplane.NTSB CHI00LA099Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Ft. Leavenworth, KSthe pilot of N51933 did not see and maintain clearance from N9570E. A factor associated with the accident was the pilot of N51933's restricted forward visibility during the landing due to the tailwheel configuration. An additional factor was the pilot of…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 CHI00LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Olathe, KSthe pilots improper use of powerplant controls. A factor in the accident was the plowed farm field.NTSB CHI00LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Liberal, KSthe pilot not maintaining proper glidepath on the ILS approach, the pilot's improper decision to continue the approach below the glidepath, and the pilot's failure to perform a missed approach. Factors relating to the accident were the low ceiling and…NTSB CHI00LA044Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Salina, KSThe pilot's failure to follow the published practice autorotation procedures, the improper use of throttle, and the inadequate flare.NTSB CHI00LA019Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Benton, KSthe pilot's failure to maintain aircraft control, and the physiological impairment of the pilot due to a brain anomaly. The pilots improper decision to operate the airplane with a known medical deficiency, and the ditch were contributing factors.NTSB CHI00LA004Accident · 2 fatalLimited investigationFinal reportDraper Rans S-10 · Benton, KSthe pilot inadvertently stalled the airplane. Factors relating to the accident was the undetermined loss of power and the pilot's lack of recent experience in the airplane.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 CHI99LA287Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Garden City, KSThe pilot's misjudging his pull-up maneuver resulting in contact with the wire. A contributing factor was the wire.NTSB CHI99LA297Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Oberlin, KSEngine failure due to an undertorqued carburetor fulcrum screw. Contributing factors were the muddy terrain and the low altitude of the aerial operation.NTSB CHI99LA257Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Jetmore, KSThe pilot's use of improper procedures by not following the helicopter manufacturer's recommended engine RPM reduction procedures during autorotations. A factor was the pilot not attaining the proper rotor RPM during the autorotation practice.