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 CHI93LA007Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Wichita, KSInadequate preflight planning/preparation by the pilot, the pilot's over confidence in his personal ability, and airplane performance data not followed by the pilot.NTSB CHI92LA289Accident · No injuriesLimited investigationFinal reportLearjet LR-60 · Hutchinson, KSInadequate flight test methods by the manufacturer and the FAA which did not permit safe operating clearances.NTSB CHI92LA273Accident · Minor injuriesLimited investigationFinal reportAlon 415-A2 · Sabetha, KSThe pilot's failure to use carburetor heat.NTSB CHI92FA266Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Ness City, KSThe pilot-in-command's (CFI) failure to maintain control of the airplane.NTSB CHI92DCQ06Accident · Serious injuriesFinal reportPiper PA-25-235 · Scott City, KSThe failure of the pilot in command to maintain sufficent airspeed for flight resulting in an inadvertent stall.NTSB CHI92DCG03Accident · Minor injuriesFinal reportDaniel M. Dent BD-5 B · Ft. Levenworth, KSA complete loss of engine power following an electrical short to ground in the aircraft's 'ignition kill' electric circuit.NTSB CHI92DCQ05Accident · Serious injuriesFinal reportVirgil Larson Varieze,LONG EZ · Chanute, KSA delamination and inflight separation of a propeller blade during cruise flight.NTSB CHI92DCQ04Accident · Minor injuriesFinal reportWSK PZL Mielec M18 · Norton, KSFailure of the pilot in command to level off while performing aerial application.NTSB CHI92DCQ03Accident · No injuriesFinal reportCessna A188B · Meade, KSThe pilot's improper preflight planning/preparation and his exceeding the aircraft's takeoff capability.NTSB CHI92LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Wichita, KSA loss of directional control and remedial action not performed by the pilot. Factors related to this accident were a swerve encountered by the pilot and the pilot's lack of overall experience.NTSB CHI92LA180Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Catherine, KSThe pilot's inadequate preflight planning. Factors associated with this accident were unsuitable terrain selected by the pilot and airplane clearance over the fence not attained by the pilot.NTSB CHI92LA178Accident · No injuriesLimited investigationFinal reportCessna 150L · Colby, KSA jammed exhaust valve in the number one cylinder of the engine assembly.NTSB CHI92LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Osage City, KSThe pilot's failure to maintain directional control. Factors in the accident were the rough/uneven runway surface and the inadequate maintenance of the runway surface.NTSB CHI92LA149Accident · No injuriesLimited investigationFinal reportCessna 150 · Olathe, KSThe student pilot's improper recovery from a bounced landing, and the instructor's inadequate remedial action(s).NTSB CHI92LA148Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Olathe, KSThe in flight separation of the propeller tip. An associated factor is the rough and uneven terrain.NTSB CHI92DCQ02Accident · Serious injuriesFinal reportLarry E. Medlin Challenger II SPEC. · Maize, KSFailure of the pilot to maintain an airspeed above stalling speed while turning from base leg to final approach. Factors in the accident are the pilot's lack of total and recent aviation experience.NTSB CHI92DCQ01Accident · No injuriesFinal reportGeorge Adrian Rands/ Coyote · Agusta, KSFailure of the pilot to maintain a proper descent rate, and an airspeed above stalling speed during a VFR final approach.NTSB CHI92LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hanover, KSThe pilot's failure to abort the takeoff earlier in the takeoff roll, and the inadvertent stall/mush after lift-off. A factor was the soft terrain.NTSB CHI92LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Manhattan, KSThe pilot's failure to refuel the airplane. A factor related to the accident was the rough terrain on which the landing was made.NTSB CHI92FA028Accident · 1 fatalField investigationFinal reportPiper PA28-236 · Valley Center, KSThe pilot's spatial disorientation, his loss of aircraft control, and his exceeding the aircraft's design limits. Factors in the accident were the pilot's disregard for directives and procedures, and his continued flight into known adverse weather.NTSB CHI92FA027Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Coffeyville, KSThe pilot's failure to maintain sufficient airspeed (above stall speed) during the emergency procedure. Related factors are the pilot's poor planning/decision, inattentiveness, and the weather (low ceiling, gusty tailwinds).NTSB CHI92FA023Accident · 1 fatalField investigationFinal reportCessna 150K · Kiowa, KSThe pilot-in-command's failure to properly utilize the carburetor heat to avoid loss of engine power due to carburetor icing. Factors contributing to the accident were the pilot-in-command's inattention and the encounter of unsuitable terrain during an…NTSB CHI92FA022Accident · 2 fatalField investigationFinal reportRockwell AC 690B · Milton, KSIncapacitation of the pilot in command, followed by the loss of control and an inflight breakup with a unqualified person on the controls.NTSB CHI91LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Atchison, KSDelayed remedial action by the pilot in command. Factors related to the accident are a misjudged approach by the pilot in command, and complacency on the part of the FAA inspector.NTSB CHI91DCQ09Accident · No injuriesFinal reportHispano Aviacion HA200 · Liberal, KSA disconnected ignition harness resulting in an inflight fire during maneuvering flight.NTSB CHI91LA290Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, KSThe pilot's failure to assure an adequate fuel supply was on board the airplane which resulted in fuel exhaustion. A factor related to the accident was inaccurate preflight planning.NTSB CHI91LA282Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Emporia, KSThe pilot's VFR flight into instrument meteorological conditions (IMC), and his delay in taking remedial action. The weather (fog) was a related factor.NTSB CHI91LA242Accident · Minor injuriesLimited investigationFinal reportAmerican AA1 · Spearville, KSThe pilot's selection of unsuitable terrain on which to perform a precautionary landing. Factors related to the accident were poor in flight/planning decision which resulted in the pilot becoming lost/disoriented.NTSB CHI91FA235Accident · 2 fatalField investigationFinal reportAero Commander 500B · Silica, KSThe failure of both pilots to maintain adequate separation during formation flight. Related factors are overconfidence in personal ability and poor planning/decision.NTSB CHI91LA243Accident · No injuriesLimited investigationFinal reportCessna 172 · Oberlin, KSThe student pilot's failure to maintain directional control during landing. Factors in the accident were the pilot's discontinuing his crosswind compensation and his lack of experience in the type of operation.NTSB CHI91LA232Accident · Serious injuriesLimited investigationFinal reportCessna 305 · Hutchinson, KSFuel consumption calculations misjudged by the pilot resulting in fuel exhaustion. Factors related to the accident were compensation for wind conditions were inadequate and presence of trees during the emergency landing attempt.NTSB CHI91LA227Accident · No injuriesLimited investigationFinal reportAero Commander 500B · Hutchinson, KSThe landing gear handle was placed in the gear up postion prematurely resulting in a gear retraction during takeoff. Factors related to the accident were proper procedures were not followed by the pilot.NTSB CHI91DCQ07Accident · No injuriesFinal reportGrumman G-164A · Sharon Springs, KSAircraft takeoff performance exceeded and disregard of performance data by the pilot. A factor associated with the accident is high density altitude.NTSB CHI91DCQ08Accident · No injuriesFinal reportSebly Amateur Built ACRO-SPORT II · Columbus, KSA loss of engine power for undetermined reasons. A factor associated with the accident is soft terrain in the forced landing area.NTSB CHI91LA200Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Olathe, KSDirectional control was not maintained by the pilot. A factor related to the accident is crosswind.NTSB CHI91DCQ06Accident · No injuriesFinal reportPiper PA-36-300 · Oakley, KSA loss of engine power for an undetermined reason(s).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 CHI91LA174Accident · Serious injuriesLimited investigationFinal reportCameron N120 · Overland Park, KSThe pilot's failure to maintain a proper descent rate during an approach for landing.NTSB CHI91LA147Accident · No injuriesLimited investigationFinal reportBeech 58P · Wichita, KSA go around was not performed resulting in the proper touchdown not being attained by the pilot.NTSB CHI91DCQ05Accident · No injuriesFinal reportCessna A188B · Mingo, KSFailure of the pilot to maintain a visual lookout while performing aerial application. A factor associated with the accident is soft terrain in the selected landing area.NTSB CHI91LA130Accident · No injuriesLimited investigationFinal reportBeech 58 · Wichita, KSRemedial action was delayed by the instructor pilot. A factor related to the accident was an excessive rate of descent.NTSB CHI91LA113Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Augusta, KSAn improper autorotation was performed by the dual student and remedial action was delayed by the CFI. Factors related to the accident were: inadequate airspeed and rotor RPM.NTSB CHI91LA112Accident · No injuriesLimited investigationFinal reportCessna 172 · Wichita, KSDirectional control was not maintained by the dual student and remedial action was delayed by the CFI. Factors related to the accident were a gusty crosswind and a drainage ditch.NTSB CHI91DCQ04Accident · 1 fatalFinal reportCessna A-188 · Harper, KSThe pilot inadvertently stalling the airplane.NTSB CHI91LA094Accident · No injuriesLimited investigationFinal reportCessna R172K · Herington, KSLoss of engine power due to failure of a connecting rod bolt. A factor related to the accident was: the soft, unsuitable terrain.NTSB CHI91LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrence, KSFailure of the student pilot to maintain directional control of the aircraft, which resulted in a ground swerve.NTSB CHI91DCQ03Accident · Serious injuriesFinal reportRans S-11 Pursuit · Hays, KSAn engine failure caused by a seized piston. A factor associated with the accident is the failure of the pilot to maintain a proper descent rate during his forced landing.NTSB CHI91FA053Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Gardner, KSA loss of engine power for undetermined reasons. Darkness was a related factor.NTSB CHI91DCQ02Accident · No injuriesFinal reportPiper PA-23-250 · Brownell, KSFuel exhaustion, due to the pilot's failure to ensure that the aircraft had been refueled.NTSB CHI91FA033Accident · 2 fatalField investigationFinal reportCessna 150K · Valley Center, KSContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft after becoming spatially disoriented. Factors related to the accident were: darkness, adverse weather conditions, and the…