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 CHI98FA048Accident · 1 fatalField investigationFinal reportCessna 172E · Topeka, KSthe pilot's improper use of carburetor heat. Contributing factors were carburetor icing conditions, dark night conditions, and the transmission wire.NTSB CHI98LA041Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Burlington, KSan undetermined event resulting in the door seal inflation pump catching fire, the pilot's failure to close the cockpit air vents allowing heat and flames from the airplane's nose section to melt electrical wiring behind the instrument panel, and the pilot…NTSB CHI98LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Ulysses, KSthe pilot's continued flight into adverse weather conditions, his failure to activate the pitot heat system, and his failure to maintain clearance from the terrain. Factors associated with this accident were: the pilot did not obtain a preflight weather…NTSB CHI98LA027Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Augusta, KSfailure of the aircraft owner to reinstall the quick release hinge pins/safety pins, and failure of the pilot to notice the missing pins during the aircraft preflight, which resulted in separation of the main entry door during flight.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 CHI98FA022Accident · 3 fatalField investigationFinal reportMooney M20K · Emporia, KSThe pilot's failure to maintain an altitude above the minimum descent altitude for the approach. Factors contributing to this accident were the low ceiling, rain, and fog.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 CHI97LA286Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Shields, KSa loss of engine power from undetermined reasons.NTSB CHI97LA281Accident · No injuriesLimited investigationFinal reportCessna 150M · Benton, KSthe flight instructor's (CFI') improper in-flight planning/decision, which led to fuel exhaustion and loss of engine power before the airplane was safely landed.NTSB CHI97LA260Accident · No injuriesLimited investigationFinal reportCessna 182 · Derby, KSthe Airworthiness Directive and propeller overhaul not being complied with. Factors to the accident were the propeller blade retention failure and rough/uneven terrain condition.NTSB CHI97LA240Accident · No injuriesLimited investigationFinal reportCessna A188B · Satanta, KSthe pilot's decision to perform a precautionary landing in a corn field due to an undetermined event in the cockpit. Factors relating to the accident were: the pilot's inadvertent actuation of the 'smoker' switch, his unfamiliarity with the 'smoke' equipment…NTSB CHI97LA228Accident · No injuriesLimited investigationFinal reportCessna 188B · Halstead, KSthe pilot failed to maintain adequate clearance from the transmission wires. Factors included the malfunctioning of the wire cutter and pilot fatigue.NTSB CHI97LA237Accident · No injuriesLimited investigationFinal reportCessna 182F · Haviland, KSthe pilot's improper planning/decision and failure to obtain and/or maintain proper runway alignment during a night landing. Factors relating to the accident were: the airplane's inoperative landing lights, the airport's inoperative runway edge lights, and…NTSB CHI97LA217Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Hill City, KSthe sustained partial loss of engine power due to low compression on one cylinder and the rough, uneven terrain.NTSB CHI97LA193Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Satanta, KSThe pilot did not maintain aircraft control and the reason for the loss of engine power was undetermined.NTSB CHI97LA177Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Satanta, KSthe pilot not maintaining aircraft control shortly after it had touched down during its liftoff. A factor in this accident was the premature liftoff during takeoff by the pilot.NTSB CHI97LA175Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Wamego, KSinaccurate preflight planning which resulted in an inadequate fuel supply for the flight and ultimately fuel exhaustion. Factors associated with the accident were the powerlines and the parachutists over the runway.NTSB CHI97LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Council Grove, KSthe pilot's selection of an unsuitable area for landing and the fence post. Factors relating to this accident were the pilot's inability to see the fence post due to the high vegetation, and the soft dirt.NTSB CHI97LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Prairie View, KSan undetermined event, which resulted in loss of engine power. Factors relating to the accident were: an automobile, which prevented the pilot from landing on a road; and a dirt bank (terrace) in the emergency landing area.NTSB CHI97LA110Accident · Serious injuriesLimited investigationFinal reportGulfstream 500B · Mission, KSthe pilot's inadequate preflight planning which resulted in fuel exhaustion.NTSB CHI97LA105Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Elk Falls, KSfracture of the fuel selector assembly which resulted in fuel starvation.NTSB CHI97LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Olathe, KSthe pilot's improper inflight planning/decision and exceeding the airplane recommended crosswind component. Factors associated with this accident were the weather conditions of a high wind, gusts, and a crosswind.NTSB CHI97LA128Accident · No injuriesLimited investigationFinal reportRochette Rans S-12 XL · Hays, KSthe pilot improperly flared the airplane and the pilot's lack of experience in the type of airplane.NTSB CHI97LA091Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Leavenworth, KSfatigue failure and separation of the number 2 cylinder. A factor was the rough terrain.NTSB CHI97LA061Accident · No injuriesLimited investigationFinal reportCessna 182K · El Dorado, KSthe pilot's failure to maintain directional control of the airplane. A factor relating to the accident was: the ditch, which the airplane contacted.NTSB CHI97LA055Accident · No injuriesLimited investigationFinal reportBeech D95A · Olathe, KSthe pilot improperly selecting the 'off' position on the left engine fuel selector valve, his failure to verify the fuel selector valve's proper position prior to landing, and his inability to obtain best rate-of-climb single-engine speed.NTSB CHI97LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Garnett, KSthe pilot's improper in-flight planning/decision, including a delay in proceeding to an alternate airport after encountering fog during a night approach, which resulted in loss of engine power due to fuel exhaustion.NTSB CHI97LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Minneapolis, KSthe pilot's selection of unsuitable terrain on which to land the airplane. A factor relating with the accident was: the large rock, which the airplane contacted.NTSB CHI97LA008Accident · No injuriesLimited investigationFinal reportHughes 369E · Hesston, KSthe pilot selected unsuitable terrain for landing. The factors involved were: an inoperative landing light, dusk light conditions, and the terrain condition.NTSB CHI96LA349Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Stilwell, KSthe pilot's not maintaining adequate clearance from a tree, and his allowing an abrupt touchdown. Factors relating to the accident were: dusk and the proximity of tree(s).NTSB CHI96LA319Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Pittsburg, KSthe pilot diverted his attention and failed to maintain sufficient altitude and clearance with the terrain. Factors relating to the accident were: darkness, and the pilot performing low altitude flight at night.NTSB CHI96LA296Accident · No injuriesLimited investigationFinal reportCessna 150 · Olathe, KSimproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB CHI96LA261Accident · No injuriesLimited investigationFinal reportCessna 188B · Cimarron, KSthe pilot's failure to make a timely decision to abort the takeoff or dump the payload.NTSB CHI96LA258Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Liberal, KSthe pilot did not maintain aircraft control. A factor was a low altitude flight maneuver was performed.NTSB CHI96LA265Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Macksville, KSfailure of the pilot to allow the airplane to achieve sufficient airspeed for takeoff, and the resultant loss of aircraft control. Factors relating to the accident were: the rough runway, and the mound of dirt at the end of the runway.NTSB CHI96LA282Accident · No injuriesLimited investigationFinal reportCessna 188-230 · Santanta, KSa loss of power due to a broken number four cylinder exhaust valve push rod and a bent number four cylinder intake valve push rod. The wet, soft cornfield was a factor.NTSB CHI96LA251Accident · No injuriesLimited investigationFinal reportMaule M5-210TC · Olathe, KSthe pilot's improper recovery from a bounced landing. Factors associated with the accident were the uncontrolled porpoise encountered and the pilot's lack of recent experience in tailwheel airplanes.NTSB CHI96LA248Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Rose Hill, KSthe worn carburetor, and inadequate inspection of the aircraft by other maintenance personnel.NTSB CHI96LA247Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dighton, KSloss of engine power for undetermined reason(s). The crop and soft terrain in the emergency landing area were related factors.NTSB CHI96LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ness City, KSthe failure of a counterweight bolt in the propeller for reasons undetermined. Factors were the wet landing area and the encounter with unsuitable terrain during the forced landing.NTSB CHI96LA208Accident · No injuriesLimited investigationFinal reportAerotechnik L-13 · Wichita, KSthe pilot's inadequate in-flight planning. Factors were the insufficient altitude and the dead battery.NTSB CHI96LA218Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Waterville, KSthe pilot's inadequate preflight procedure. Factors were fuel exhaustion, a leak in the fuel filtering system, and high vegetation.NTSB CHI96LA192Accident · No injuriesLimited investigationFinal reportCarrison-Seiman Schukert D-1 · Gardner, KSan aileron control malfunction of undetermined origin. A factor was the pilot's inability to control the airplane.NTSB CHI96LA190Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Oskaloosa, KSfailure of the pilot to maintain proper alignment with the roadway during the takeoff roll. A factor relating to the accident was: the selection of an unsuitable area for takeoff.NTSB CHI96LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · Wichita, KSthe pilot's failure to maintain directional control of the airplane during landing. A factor associated with the accident was the gusty crosswind condition.NTSB CHI96FA171Accident · No injuriesField investigationFinal reportCessna 401 · Great Bend, KSthe failure of the exhaust header. Additional factors include the visual restrictions which prevented a detailed examination of the exhaust system, and the inadequate inspection procedures required in AD 75-23-08 R5.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 CHI96LA148Accident · No injuriesLimited investigationFinal reportFairchild M-62C · Garden City, KSfailure of the left main landing gear strut due to corrosoion.NTSB CHI96LA144Accident · No injuriesLimited investigationFinal reportBeech B55B · Manhattan, KSthe pilot's failure to properly extend the landing gear. A factor was his failure to follow checklist procedures.NTSB CHI96LA123Accident · No injuriesLimited investigationFinal reportCessna 206 · Ulysses, KSFailure of the pilot to maintain control of the airplane, while taxiing. Factors relating to the accident were: the high, gusty, crosswind condition; and loose gravel on the roadway.