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 CHI99LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Salina, KSthe inadequate preflight inspection by the pilot. Factors to the accident were fuel exhaustion and the operation of the aircraft with known deficiencies in equipment by the pilot.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 CHI99LA212Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lyons, KSThe pilot's inadequate fuel management leading to fuel exhaustion.NTSB CHI99LA198Accident · No injuriesLimited investigationFinal reportMahler BD-4 · Baldwin City, KSThe pilot not maintaining directional control with the runway centerline during takeoff. A factor was the high vegetation off the left side of the runway.NTSB CHI99FA202Accident · 1 fatalField investigationFinal reportRans S-10 Sakota · La Crosse, KSdirectional control not maintained by the pilot.NTSB CHI99LA195Accident · No injuriesLimited investigationFinal reportCessna 150G · Fort Scott, KSThe pilot's failure to maintain directional control during the landing roll. A factor to the accident was the soft terrain condition.NTSB CHI99FA190Accident · 1 fatalField investigationFinal reportCessna 182J · Satanta, KSthe preflight planning/preparation and the missed approach not performed by the pilot. The obstruction clearance not maintained by the pilot was an additional cause. Contributing factors were the low ceiling and the fog.NTSB CHI99LA183Accident · No injuriesLimited investigationFinal reportGrumman American G-164B · Goodland, KSthe fracture of the rocker arm bolt. Contributing factors were the pilot's low altitude and the crops.NTSB CHI99LA180Accident · No injuriesLimited investigationFinal reportCessna 182D · Zurich, KSthe pilot's inadequate preflight planning/preparation. A factor was fuel exhaustion.NTSB CHI99FA177Accident · 2 fatalField investigationFinal reportCessna 340A · Phillipsburg, KSthe pilot not maintaining flying speed. Factors to the accident were the fuel transfer problem of unknown origin.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 CHI99LA169Accident · 1 fatalLimited investigationFinal reportHornbeck Glassair · Johnson City, KSThe pilot's intentional low altitude performance of aerobatics.NTSB CHI99FA165Accident · 1 fatalField investigationFinal reportAir Tractor AT-400 · Elkhart, KSThe pilot's inadequate in-flight planning/decision and his inadvertent flight into instrument meteorological conditions which resulted in spatial disorientation and subsequent loss of aircraft control. Contributing to the accident was the poor weather…NTSB CHI99LA158Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman PT-27 · Grainfield, KSThe pilot's improper in-flight decision and failure to maintain adequate clearance with the ground.NTSB CHI99FA164Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Great Bend, KSthe chafed through turbocharger oil supply hose, the failure of maintenance personnel to install a clamp on the turbocharger oil supply hose, and the inability of the pilot to maintain aircraft control.NTSB CHI99LA168Accident · No injuriesLimited investigationFinal reportCessna 172P · Wichita, KSthe student pilot's improper recovery from a bounced landing.NTSB CHI99LA152Accident · No injuriesLimited investigationFinal reportCessna A188B · Lincoln, KSthe altitude/clearance not obtained by the pilot and the unsuitable takeoff area selected by the pilot. Factors to the accident were the high, soft, and wet grass runway.NTSB CHI99LA138Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Bonner Springs, KSthe pilot's failure to obtain sufficient altitude during the aborted landing to clear obstacles at the end of the field. Factors associated with the accident were poor preflight planning/preparation, the tailwind, the telephone pole, and the trees.NTSB CHI99LA127Accident · No injuriesLimited investigationFinal reportReindl Quickie 2 · Olathe, KSThe loss of engine power for undetermined reasons. A factor associated with the accident is the lack of suitable terrain for a forced landing.NTSB CHI99LA126Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Atchison, KSThe loss of engine power for unknown reasons.NTSB CHI99LA111Accident · 1 fatalLimited investigationFinal reportCessna A188B · Atwood, KSThe pilot's failure to maintain clearance from obstacles.NTSB CHI99IA100Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10 · Salina, KSThe ARTCC personnel failed to maintain radio communications with both airplanes and failed to maintain IFR separation standards. Factors relating to the incident were the FAA does not require cargo airplanes to be equipped with TCAS and neither airplane was…NTSB CHI99FA094Accident · 2 fatalField investigationFinal reportCessna 172C · Grenola, KSloss of control in flight due to incapacitation.NTSB CHI99LA061Accident · No injuriesLimited investigationFinal reportBeech BE-V35B · Olathe, KSThe pilot's continued flight into adverse weather that resulted in structural icing and subsequently an aerodynamic stall on landing flare. A factor was the pilot's inadequate weather evaluation .NTSB CHI99FA029Accident · 1 fatalField investigationFinal reportCessna 182F · Wichita, KSThe pilot's inadequate preflight inspection and contaminated fuel supply.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 CHI98LA342Accident · No injuriesLimited investigationFinal reportMBB BK-117 · Topeka, KSthe pilot's failure to assure the engine cowling was secured during the aircraft preflight which resulted in the cowling separating from the helicopter and damaging the main rotor and tail rotor system. Factors associated with the accident were the cowling…NTSB CHI98LA325Accident · No injuriesLimited investigationFinal reportCessna 120 · Benton, KSthe pilot's inadvertant excessive use of the toe brakes during the landing roll.NTSB CHI98LA294Accident · Minor injuriesLimited investigationFinal reportPiper 20 · Andover, KSa loss of engine power for undetermined reasons. A factor associated with the accident were the trees which the airplane contacted and the low altitude at which the loss of power occurred.NTSB CHI98LA293Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Salina, KSinadequate maintenance which failed to detect corrosion in the fuel injector system and the fuel pump. Factors related to the accident were the low altitude and airspeed at which the loss of engine power occurred.NTSB CHI98LA284Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Salina, KSthe pilot failed to flare the airplane properly and the airplane landed hard.NTSB CHI98LA264Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Hoxie, KSthe total failure of the engine's left magneto.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 CHI98LA254Accident · No injuriesLimited investigationFinal reportCessna 172P · Abilene, KSThe student pilot's failure to plan his approach so as to be able to stop the airplane on the runway, and the instructor pilot's delay in taking control of the airplane, so as to correct the student's mistake. A factor contributing to this accident was the…NTSB CHI98LA185Accident · No injuriesLimited investigationFinal reportCessna 150M · Newton, KSthe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Related factors were the pilot became disoriented and a dark night.NTSB FTW98LA243Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2B7 · Wichita, KSThe severe turbulence encountered as a result of the flightcrew's inadvertent flight into a rapidly developing thunderstorm.NTSB CHI98LA173Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Augusta, KSthe pilot's inadequate evaluation of the current local weather conditions and his failure to maintain a climb after takeoff. Factors related to the accident were the fog, the powerlines, and spatial disorientation.NTSB CHI98LA160Accident · Serious injuriesLimited investigationFinal reportPitts S-2A · Benton, KSthe pilot did not flare the airplane properly during the forced landing. A factor was the engine failure for undetermined reasons.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 CHI98LA138Accident · No injuriesLimited investigationFinal reportCessna 150H · Benton, KSthe pilot's failure to assure an adequate fuel supply to complete the flight by refueling the airplane en route resulting in fuel exhaustion. A factor was the hedgerow which was contacted during the landing and the dark night conditions.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 CHI98LA116Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Sabetha, KSThe loss of engine power for undetermined reasons.NTSB CHI98LA112Accident · No injuriesLimited investigationFinal reportCessna 310J · Hutchinson, KSthe flight instructor's inadequate supervision by failing to ensure that the right throttle had been retarded before re-advancing the right mixture control, which resulted in a loss of directional control, an encounter with soft terrain, and damage to the…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 CHI98LA064Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Wichita, KSthe pilot-in-command misjudged the fuel supply and selected an empty fuel tank which resulted in fuel exhaustion. A factor associated with the accident was the rough terrain encountered when the airplane touched down short of the runway.NTSB CHI98LA059Accident · 2 fatalLimited investigationFinal reportBellanca 17-30 · Independence, KSthe pilot's intentional flight into adverse weather. Contributing factors were low ceilings, fog, and the guy wire.NTSB CHI98LA051Accident · No injuriesLimited investigationFinal reportBeech E55 · Gardner, KSthe inadvertant landing gear retraction, which occurred due to undetermined reason(s).