NTSB investigations, WI
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\" = 'WI' 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" = 'WI' 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 CHI89FA154Accident · Minor injuriesField investigationFinal reportRyan PT-22 · Oshkosh, WIThe experimental aircraft association's (eaa's) inadequate procedure for providing control and separation of aircraft, its inadequate surveillance of the operation, and inadequate coordination by ground personnel. Related factors were: the ground personnel's…NTSB CHI89FA153Accident · No injuriesField investigationFinal reportCessna 182Q · Oshkosh, WIThe pilot of Cessna N95914 misjudging the distance necessary to avoid collisions with a the standing Piper N5937W.NTSB CHI89LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Watertown, WIImproper planning/decision by the pilot and his misjudgement of distance and speed during the landing, which resulted in failure to attain a proper touchdown point. Contributing factors were: the weather conditions, the pilot's continued flight into…NTSB CHI89FA151Accident · Minor injuriesField investigationFinal reportCessna A152 · Oshkosh, WIThe pilot's poor judgement, and poor evaluation of the weather due to self induced pressure and overconfidence in his personal ability. Contributing factor was the experimental aircraft association's inadequate supervision of the operation.NTSB CHI89FA150Accident · No injuriesField investigationFinal reportProspector FK-1 · Chilton, WIThe pilot's poor in flight planning in that he diverted his attention and continued the flight beyond the original period planned. Before takeoff the pilot was aware of his fuel endurance.NTSB CHI89DEP08Accident · No injuriesFinal reportJames Eggleston Varieze · Cottage Grove, WIThe pilot misjudged altitude and distance to the runway and failed to attain the proper touchdown point for a landing. Factors related to the accident were: adverse weather conditions and uneven terrain short of the runway.NTSB CHI89DEP09Accident · No injuriesFinal reportCabrinha/Free Spirit 412 · Waukesha, WIThe plt became lost/disoriented and allowed fuel exhaustion to occur before accomplishing remedial action. Factors related to the accident were: the adverse environmental conditions and the road sign and vehicles in the emergency landing area.NTSB CHI89LA147Accident · 1 fatalLimited investigationFinal reportPiper PA-38-112 · River Falls, WIImproper remedial action by the pilot following an abrupt maneuver. The pilot's lack of total aviation experience was a factor in the accident.NTSB CHI89LA164Accident · No injuriesLimited investigationFinal reportPiper PA38-112 · Milwaukee, WIStudent pilot's misjudged aircraft handling during the landing flare/touchdown, and the cfi's inadequate supervision of the operation. These resulted in an abrupt touchdown, a subsequent loss of directional control, and the aircraft's collision with the VASI…NTSB CHI89LA141Accident · No injuriesLimited investigationFinal reportCessna R172K · Wisconsin Dells, WIFailure of the pilot to insure the oil filler cap was properly secured when he serviced the aircraft before takeoff, and subsequent loss of oil and oil exhaustion. The tree was considered to be a contributing factor.NTSB CHI89DEP07Accident · Minor injuriesFinal reportHiller UH-12E · Blackriverfalls, WIPilot-in-command's failure to jettison the external load followed by his misjudgement of distance to avoid collision with the external load.NTSB CHI89LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Chippewa Falls, WIThe pilot's failure to maintain directional control while attempting to land in crosswind conditions. During the ensuing aborted landing, the pilot failed to ensure adequate obstacle clearance and the aircraft's left wing struck the wind sock pole.NTSB CHI89LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Iola, WIThe improper preflight planning by the pilot in command resulting in the airplane fuel quantity being near the unusable quantity which resulted in total loss of engine power due to fuel starvation while maneuvering. Contributing to the accident was the pilots…NTSB CHI89DEP06Accident · Minor injuriesFinal reportAeronca 15AC · Fort Atkinson, WIWater contamination of the fuel and the pilot's inadequate preflight. Factors related to the accident were: lack of suitable terrain for a forced landing & trees.NTSB CHI89LA125Accident · No injuriesLimited investigationFinal reportAerofab Lake LA 4-200 · Oshkosh, WIThe pilot's encounter with unsuitable terrain (rough water) and his inability to maintain directional control.NTSB CHI89DEP12Accident · Serious injuriesFinal reportSchuning/Teratorn Terra II · New Berlin, WIFailure of the pilot to maintain adequate airspeed during the go-around, which resulted in an inadvertent stall.NTSB CHI89FA113Accident · 1 fatalField investigationFinal reportCessna 150L · Wisc Rapids, WIThe pilot's failure to assure that the flaps were in the up position during takeoff. A factor related to the accident was the pilot's lack of familiarity with aircraft.NTSB CHI89LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Crandon, WIImproper inflight planning/decision by the pilot which resulted in loss of control & subsequent wingtip collision with the ground during the landing. The crosswind and turbulence were contributing factors.NTSB CHI89LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Necedah, WIPilot-in-command's improper use of the fuel selector.NTSB CHI89DEP05Accident · Minor injuriesFinal reportPiper PA-25-235 · Suring, WIImproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of fuel. Factors related to th accident were: the lack of suitable terrain and trees in the emergency landing area.NTSB CHI89DEP04Accident · No injuriesFinal reportHiller UH-12E · Waterford, WIThe pilot's inability to maintain control during an autorotational landing attempt following the failure of the main rotor drive train torsional coupling.NTSB CHI89LA091Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Ojibwa, WIImproper planning/decision by the pilot and his delay in aborting the takeoff. Contributing factors were: the wet/upward sloping condition of the airstrip, unfavorable wind, high obstructions (tall trees/obstacles at the end of the runway), and high…NTSB CHI89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Waunakee, WISlippage of a bearing, which resulted in blockage of the lubrication system, and subsequent failure of a connecting rod.NTSB CHI89DEP03Accident · No injuriesFinal reportTesmer Glassair SH-2 · Watertown, WILack fuel flow to the engine (fuel starvation) due to an undetermined fuel system problem.NTSB CHI89LA075Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Watertown, WIThe pilot's improper use of brakes and throttle. A contributing factor was the parked aircraft which was nearby.NTSB CHI89TL#02Accident · No injuriesClass 3Final reportBellanca Bgcbc · Shell Lake, WINTSB CHI89FA071Accident · Serious injuriesField investigationFinal reportSikorsky S-58T · Milwaukee, WIDisconnect of the tailrotor drive shaft coupling.NTSB CHI89LA066Accident · No injuriesLimited investigationFinal reportCessna 170B · Freedom, WIThe pilot's failure to maintain directional control during the attempted takeoff on unsuitable terrain. The pilot's lack of recent flight experience was a contributing factor.NTSB CHI89DEP02Accident · No injuriesFinal reportCessna 172M · West Bend, WIPartial failure of the throttle cable. Unsuitable (soft) terrain and transmission wires in the landing area were considered to be factors.NTSB CHI89LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · Superior, WIFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were the icy and snow covered runway conditions and the snowbank.NTSB CHI89LA053Accident · No injuriesLimited investigationFinal reportAeronca 7KCAB · Pine Creek, WIThe pilot's selection of unsuitable terrain which resulted in the failure to achieve a proper climb rate which resulted in the collision with trees. Contributing to the accident was the uphill, snow covered terrain.NTSB CHI89LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Stevens Point, WIFailure of the pilot to maintain directional control which resulted in an inadvertent ground swerve.NTSB CHI89LA051Accident · No injuriesLimited investigationFinal reportCessna 182A · Baldwin, WIFailure of the pilot to go around when he landed long with too much speed for the conditions. Factors related to the accident were: the pilot's excessive airspeed, his failure to attain the proper touchdown point, the crosswind, snowy/icy runway conditions,…NTSB CHI89FA049Accident · 3 fatalField investigationFinal reportCessna 172RG · Mosinee, WISpatial disorientation of the pilot as a result of initiating the flight into known adverse weather. Factors related to the accident were: dark night, snow, and low ceilings.NTSB CHI89DEP01Accident · 1 fatalFinal reportCessna T337G · Green Bay, WIThe pilot's loss of aircraft control, due to the loss of cockpit/instrument panel lighting for an undetermined reason, the inoperative penlight, and subsequent spatial disorientation of the pilot. Factors related to the accident were: darkness and the adverse…NTSB CHI89LA044Accident · No injuriesLimited investigationFinal reportCessna 150J · Osceola, WIInadequate preflight by the student pilot, inadequate supervision (to assure a proper preflight) by the instructor pilot (CFI), and water contamination of the fuel. The terrain was considered to be a contributing factor.NTSB CHI89IA034Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42 · Mosinee, WIStall induced by the accretion of moderate to severe clear icing.NTSB CHI89IA023Incident · No injuriesIncident investigationFinal reportBritish Aerospace JS-3101 · Milwaukee, WILoss of lubrication to the outer wheel bearing, and the subsequent disintegration of the bearing. Contributing to the incident was the failure by maintenance personnel to properly inspect and grease the bearing.NTSB CHI89LA016Accident · No injuriesLimited investigationFinal reportBeech F35 · Milwaukee, WIWhile executing a VOR approach and circling to land, the aircraft collided with trees and a fence, then impacted on a roadway short of the runway. The pilot had obtained a full weather briefing prior to his departure. The weather briefing included SIGMET golf…NTSB CHI88FA248Accident · 2 fatalField investigationFinal reportCessna 210L · Monroe, WINTSB CHI88LA245Accident · No injuriesLimited investigationFinal reportCessna 150F · Baraboo, WIWhile landing on a sod strip with an 11 knot quartering tailwind, the aircraft drifted to the left of the runway and encountered uneven terrain. The pilot reported that he failed to maintain directional control and was unable to avoid a ditch with standing…NTSB CHI88DEP13Accident · 1 fatalFinal reportHeibel AIR Command 532 · Cottage Grove, WIWhile in cruise flight this amateur built gyrocopter experienced a main rotor strike to the rudder and propeller. The student pilot who had a total of eight hours flight time, all in this aircraft, was conducting a solo flight in this dual control gyrocopter.…NTSB CHI88LA238Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Kenosha, WIWhile on a VFR approach to the airport, at night, the pilot misidentified the street lights in a mobile home park as the runway lights and descended into wires. Afterward the pilot was able to continue to the intended runway and made a successful landing.…NTSB CHI88DEP12Accident · 1 fatalFinal reportPiper PA-36-300 · Pulaski, WIThe aircraft descended at a high rate of speed, 75 degrees nosedown, into the terrain. His widow stated that the pilot had left home at approximately 2100 CST on the accident night, in an inebriated condition. After a discussion about his drinking, he…NTSB CHI88LA232Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Watertown, WIThe pilot in command's improper selection of the fuel tank, and his subsequent failure to maintain control of the aircraft.NTSB CHI88LA224Accident · Serious injuriesLimited investigationFinal reportCessna 182RG · Dodgeville, WIWhile attempting to land on a runway with wind gusts and a quartering tailwind, the pilot failed to adequately judge and compensate for the wind conditions. The aircraft landed long, and the pilot was unable to bring the aircraft to a stop before the end of…NTSB CHI88LA215Accident · No injuriesLimited investigationFinal reportCessna 170 · Boyceville, WIShortly after lift-off, the aircraft encountered a gust of wind and the pilot failed to compensate adequately for the wind conditions. The pilot experienced a loss of aircraft control and decided to reject the takeoff and execute a landing. The aircraft…NTSB CHI88DER09Accident · Serious injuriesFinal reportSmith Miniplane · Superior, WIWhile in normal cruise the aircraft experienced a total loss of engine power. The pilot executed an emergency descent to a forced landing. The aircraft encountered unsuitable terrain which resulted in a hard landing and substantial damage to the aircraft. The…NTSB CHI88LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140E · Glidden, WIWhile attempting to takeoff from a 2,175' grass strip, with the aircraft loaded near maximum gross weight, the pilot approached the end of the runway without having attained liftoff airspeed. The pilot lifted the aircraft off the ground prematurely and was…NTSB CHI88LA212Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Crandon, WIDuring cruise flight in deteriorating meteorological conditions, the pilot experienced a total loss of engine power. The pilot performed emergency procedures, was unable to restart the engine, and executed a forced landing in a clover field. The aircraft…