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 CHI96FA120Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Lincoln, KSthe pilot became spatially disoriented and failed to maintain control of the airplane. The factors involved were the pilot encountered VFR flight into IMC, pressure induced by conditions/events, low ceilings, and the dark light conditions.NTSB CHI96LA112Accident · No injuriesLimited investigationFinal reportCessna 150 · Howard, KSthe student pilot's failure to obtain timely assistance after encountering adverse weather during a cross-country flight which led to fuel exhaustion.NTSB CHI96LA111Accident · No injuriesLimited investigationFinal reportCessna 140 · Ulysses, KSFailure of the pilot to maintain directional control of the airplane during the takeoff roll, and his improper use of brakes and elevator control, while aborting the takeoff. A factor relating to the accident was the gusty wind condition.NTSB CHI96FA099Accident · Serious injuriesField investigationFinal reportMcDonnell Douglas 369E · Manhattan, KSImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: pressure to meet a work schedule.NTSB CHI96LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pittsburg, KSan inadequate annual inspection by maintenance personnel, a deteriorated muffler, and pilot incapacitation due to carbon monoxide.NTSB CHI96LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Larned, KSFailure of the pilot to use adequate procedures for hand priming (hand propping) the engine.NTSB CHI96FA049Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Parker, KSthe pilot's impairment of judgment and performance due to a drug (cocaine); his improper in-flight decision to continue flight over an overcast condition and then to descend into instrument meteorological conditions (IMC); his failure to maintain control of…NTSB CHI96LA046Accident · No injuriesLimited investigationFinal reportRobert Eckley Rotorway · Salina, KSthe pilot's improper maintenance of the helicopter. Factors in the accident were the pilot's lack of proper certification for the operation of the helicopter and his lack of recent experience in type of aircraft.NTSB CHI96LA044Accident · Minor injuriesLimited investigationFinal reportHerring Sport FAN · Newton, KSa loss of engine power for undetermined reasons. A factor related to the accident was the presence of traffic requiring the pilot to perform an evasive maneuver.NTSB CHI96LA043Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Stark, KSthe pilot's failure to follow emergency procedures. A factor was the weather condition.NTSB CHI96FA034Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Stafford, KSthe pilot misjudged his distance and altitude and flew into transmission wires. A factor was the pilot's lack of recent night flying experience.NTSB CHI96LA031Accident · No injuriesLimited investigationFinal reportBeech 35 · Belleville, KSthe pilot misjudging his approach to the runway. Factors relating to the accident were: the weather conditions, a sick passenger that diverted the pilot's attention, the snow covered terrain, and the pilot's decision not to execute the missed approach…NTSB CHI96LA025Accident · No injuriesLimited investigationFinal reportBeech A90 · Wichita, KSfailure of the pilot to follow procedures/directives regarding the entrance door, which resulted the door coming open in flight.NTSB CHI96LA024Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Liberal, KSthe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control and an inadvertent ground swerve.NTSB CHI96LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Wakeeney, KSFailure of the pilot to maintain sufficient altitude and airspeed on final approach to reach the proper touchdown point for landing. A factor relating to the accident was: the pilot's selection of the wrong runway for landing.NTSB CHI95LA338Accident · No injuriesLimited investigationFinal reportHelio U-10D · Wellsville, KSThe pilot's improper weather evaluation. A factor was the pilot's inadequate compensation for the wind conditions.NTSB CHI95LA336Accident · No injuriesLimited investigationFinal reportCessna T210M · Dodge City, KSthe pilot's improper use of the auxiliary fuel boost pump during descent which led to fuel flooding and loss of combustion.NTSB CHI95LA322Accident · Minor injuriesLimited investigationFinal reportBenham F8L Falco · Augusta, KSa sudden shift in wind direction which resulted in diminished airspeed during takeoff.NTSB CHI95LA302Accident · 1 fatalLimited investigationFinal reportMorrow Starduster I · Ottawa, KSthe pilot's delayed remedial action during the inverted spin maneuver. A factor associated with the accident was the pilot's lack of recent experience in the type operation.NTSB CHI95LA296Accident · No injuriesLimited investigationFinal reportBradley DQ2 · Newton, KSthe pilot's improper recovery from a bounced landing. A factor was the aircraft's inadequate handling capability.NTSB CHI95LA299Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Tribune, KSthe pilot's use of excessive braking during the landing roll. A factor associated with the accident was the pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CHI95LA289Accident · No injuriesLimited investigationFinal reportBeech B-60 · Salina, KSthe pilot's inattentiveness to the severity of the weather conditions, and his failure to maintain airspeed. Factors in the accident were: the icing conditions, airframe ice accumulation, and the design stress limits of the airplane being exceeded by the…NTSB CHI95LA279Accident · No injuriesLimited investigationFinal reportCessna 188B · Canton, KSfailure of the pilot to obtain the proper flying speed or to abort the takeoff, while there was sufficient runway remaining, which resulted in an inadvertent stall.NTSB CHI95LA274Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Meade, KSa fatigue failure of the propeller blade, and inadequate maintenance inspection performed by the propeller shop.NTSB CHI95LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Kingman, KSthe pilot's failure to obtain sufficient airspeed before liftoff, and his delay in aborting the takeoff. A factor relating to the accident was: the pilot's lack of recent flying experience.NTSB CHI95LA251Accident · Minor injuriesLimited investigationFinal reportAviat Pitts S2B · Junction City, KSThe pilot's failure to abort the landing despite excessive speed and insufficient runway length remaining. Contributing factors were the pilot's lack of experience in the make and model aircraft, and the crosswind.NTSB CHI95LA223Accident · No injuriesLimited investigationFinal reportCessna 182C · Derby, KSthe pilot's improper use of the powerplant controls, which resulted in a rough running engine and partial loss of engine power.NTSB CHI95LA214Accident · Minor injuriesLimited investigationFinal reportAvid Flyer · Auburn, KSthe pilot operating the airplane with known deficiencies. Factors included lack of recent flight experience, inadequate maintenance, and low airspeed.NTSB CHI95LA202Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Blue Rapids, KSthe leaking drain in the main fuel sump. Factors to the accident were the incorrect fuel indication, the ravine, fuel exhaustion, and the low rotor RPM.NTSB CHI95LA198Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Hoxie, KSthe loss of engine power due to the loose nut on the adjustment screw and the jammed exhaust valve on the number three cylinder. A factor in the accident was the ditch.NTSB CHI95LA137Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Dodge City, KSfatigue and subsequent catastrophic failure of the connecting rod originating from the decarburized area on the shank of the rod. Factors were the low cloud weather condition and the ditch.NTSB CHI95LA130Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Winfield, KSThe total failure of the rotor drive system clutch assembly due to excessive wear of the clutch assembly. A factor in this accident was the soft ground in the emergency landing area.NTSB CHI95FA128Accident · 3 fatalField investigationFinal reportCessna T337G · Coffeyville, KSthe pilot's failure to abort the takeoff during an excessive takeoff roll. Factors were the loss of power on the number two engine which occurred for an undetermined reason, the pilot's disregard of the takeoff checklist, and the 25 degree flap setting.NTSB CHI95LA122Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Meade, KSthe pilot taking off the airplane at a low liftoff speed (Vlo). A factor associated with the accident was a stall/mush encountered by the pilot.NTSB CHI95DCQ01Accident · 1 fatalFinal reportPitts S-2B · Ottawa, KSThe pilot not performing proper stall/spin recovery procedures.NTSB CHI95LA111Accident · Minor injuriesLimited investigationFinal reportBaker Long EZE · Salina, KSfailure of the engine driven fuel pump. Factors associated with the accident were fuel starvation, insufficient altitude and soft terrain.NTSB CHI95LA106Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Meade, KSthe pilot's not obtaining/maintaining clearance with the utility pole. A factor was the utility pole.NTSB CHI95LA112Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1B · Norton, KSthe reason for the loss of engine power was undetermined. The rough, uneven terrain encountered during the forced landing was a factor.NTSB CHI95LA091Accident · No injuriesLimited investigationFinal reportBeech 23 · Hutchinson, KSinadequate preflight planning by the pilot. Contributing factors to this accident were the pilot selecting the wrong runway for takeoff and the tailwind condition.NTSB CHI95LA059Accident · No injuriesLimited investigationFinal reportAmerican Champion Citabria 7-GCBC · Ulysses, KSthe pilots improper use of brakes during practice landings, and his lack of total experience in tail wheel equipped airplanes.NTSB CHI95LA057Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Scott City, KSthe pilot's failure to attain compensation for wind conditions. A factor was the crosswind condition.NTSB CHI95LA029Accident · No injuriesLimited investigationFinal reportHughes 269C · Garden City, KSinadvertant engagement of the rotor drive system, while the helicopter had been left unattended by the pilot.NTSB CHI95LA022Accident · No injuriesLimited investigationFinal reportCessna 210A · Manhattan, KStotal loss of engine power for reason(s) undetermined. A factor was the dark night.NTSB CHI94LA339Accident · No injuriesLimited investigationFinal reportCessna 150 · Lansing, KSthe pilot's failure to maintain directional control during an aborted takeoff. A factor related to the accident was the delay in aborting the takeoffNTSB CHI94LA344Accident · No injuriesLimited investigationFinal reportPrest Eagle II · Wellsville, KSthe pilot-in-command's inadequate visual lookout.NTSB CHI94LA315Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Hanston, KSThe failure of the number two connecting rod. Factors in the accident were the fouled windshield utility wires, the road sign, and the telephone pole.NTSB CHI94LA311Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Cassoday, KSthe attempted low level flight/maneuver with inadequate visual lookout by the pilot-in-command.NTSB CHI94LA303Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gardner, KSundetermined. A factor associated with the accident is a fence at the off-airport landing site.NTSB CHI94LA291Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sublette, KSimproper preflight planning by the pilot. Factors associated with the accident were the delayed jettisoning of the airplane's hopper load and the inability of the airplane to climb.NTSB CHI94LA254Accident · Serious injuriesLimited investigationFinal reportBeech 33 · Wichita, KSthe pilot's inadequate management of the fuel which resulted in fuel starvation.