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 CHI98LA009Accident · No injuriesLimited investigationFinal reportBrown AIR Shark III · Green Bay, WIthe pilot's improper flare, which resulted in a hard landing, subsequent failure of the left main landing gear, and his inability to maintain directional control. Factors related to the accident were: the runway light, and soft terrain.NTSB CHI97LA282Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Portage, WIthe pilot's inadequate preflight preparation, and subsequent fuel exhaustion. Factors relating to this accident were: the guard rail, the highway, and the ditch.NTSB CHI97LA263Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Burlington, WIthe deer which contacted the airplane.NTSB CHI97FA248Accident · 1 fatalField investigationFinal reportValley Adventurers Adventurer 333 · Fond Du Lac, WIThe kit manufacturer's use of inadequate material in construction of the airplane, his inadequate application of quality controls resulting in the debonding of the horizontal stabilizer. Factors were the total loss of the horizontal stabilizer, the elevator,…NTSB CHI97FA252Accident · 2 fatalField investigationFinal reportBeech 76 · New Richmond, WIThe certified flight instructor's inadequate supervision and delayed remedial action and the flight crew's lack of aircraft control. A factor was loss of control while maneuvering downwind by one of the pilot's.NTSB CHI97FA245Accident · 2 fatalField investigationFinal reportPeck Osprey 2 · Poygen, WIA loss of control in flight for undetermined reasons.NTSB CHI97LA251Accident · Serious injuriesLimited investigationFinal reportLarsen T-BIRD II · Oshkosh, WIthe pilot's failure to maintain flying speed and loss of control resulting in a stall. Factors were the tree and the fence.NTSB CHI97LA243Accident · No injuriesLimited investigationFinal reportCessna 182P · Oshkosh, WIwake turbulence from another airplane encountered at an altitude which precluded regaining control of the airplane by the pilot.NTSB CHI97LA244Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Fond Du Lac, WIthe pilot's improper use of the throttle control friction lock, and his inadequate remedial action. Related factors were his lack of experience in type of aircraft, the pilot's habit interference, and the presence of parked (standing) aircraft.NTSB CHI97LA239Accident · 1 fatalLimited investigationFinal reportBriegleb BG-12A · Superior, WIthe separation of the wing from the glider for undetermined reasons.NTSB CHI97LA246Accident · No injuriesLimited investigationFinal reportYoung RV-4 · Sparta, WIthe pilot's inadequate compensation for wind conditions, and his improper recovery from a bounced landing, which resulted in an improper flare and hard landing. The gusty wind was a related factor.NTSB CHI97LA242Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Lone Rock, WIa locked right brake which resulted in the pilot's inability to maintain direction control of the airplane during the landing roll.NTSB CHI97LA230Accident · Minor injuriesLimited investigationFinal reportJenkins RV-6 · Middleton, WIthe pilot was too low on final approach and hit the high vegetation.NTSB CHI97LA225Accident · No injuriesLimited investigationFinal reportSorrell SNS-7 · Tomahawk, WIThe pilot encountered a tailplane stall. The factors involved were the pilot conducted a low altitude flight maneuver and encountered engine torque effect.NTSB CHI97LA224Accident · Serious injuriesLimited investigationFinal reportBeech B-23 · Watertown, WIa loss of engine power due to undetermined reason(s).NTSB CHI97LA216Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-8 · Menominee Falls, WIthe slippage of the glider launch equipment (winch). Factors were the pilot's encounter with a stall/spin and the lack of possibility for remedial action to avoid impact with the terrain.NTSB CHI97LA215Accident · No injuriesLimited investigationFinal reportCessna 182 · Chippewa Falls, WIthe pilot's misjudgment of the fuel supply, and subsequent fuel exhaustion.NTSB CHI97LA141Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, WIthe pilot's inadequate compensation for wind conditions which resulted in a loss of directional control of the airplane. Factors associated with the accident were the gusty, crosswind conditions and the VASI lights.NTSB CHI97LA131Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Sheboygan, WIthe pilot's failure to maintain control of the airplane during the landing roll. A factor associated with the accident was the sudden change in wind conditions.NTSB CHI97LA112Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Wautoma, WIthe pilot's improper use of the throttle. Factors were a crosswind and soft terrain.NTSB CHI97LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Oshkosh, WIthe pilot's inadequate compensation for the wind conditions, and his failure to maintain proper runway alignment, which resulted in a subsequent nose over. The gusty crosswind condition was a related factor.NTSB CHI97LA088Accident · No injuriesLimited investigationFinal reportCessna 150J · La Valle, WIthe pilot's inadequate pre-flight planning/preparation which led to fuel exhaustion. A factor was the snow covered terrain.NTSB CHI97LA087Accident · No injuriesLimited investigationFinal reportCessna T210 · Janesville, WIthe pilot inadvertently retracting the landing gear during the takeoff roll.NTSB CHI97FA084Accident · 4 fatalField investigationFinal reportDouglas DC-3C/BT-67R · Newton, WIfailure of the Beech A36 pilot to maintain clearance from the modified Douglas DC-3, while positioning the A36 for photography of the DC-3.NTSB CHI97LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mosinee, WIThe formation of carburetor ice and the instructor pilot's failure to recognize conditions leading to carburetor icing and to take appropriate preventative action. Factors relating to this accident were the late application of carburetor heat, the icing…NTSB CHI97TA070Accident · No injuriesFinal reportCessna 172 · Oconto, WIthe failure of the pilot to maintain proper runway alignment and thus clearance with the snow drifts during takeoff. A factor was the distance the snow drifts extended past the runway edge.NTSB CHI97FA047Accident · Minor injuriesField investigationFinal reportBeech C90 · Rhinelander, WIthe pilot-in-command's inadequate weather evaluation and continued flight into forecast severe icing conditions which exceeded the capabilty of the airplane's anti-ice/deice system. The icing conditions were a factor.NTSB CHI97LA011Accident · Serious injuriesLimited investigationFinal reportAero Commander 685 · Eden, WIa partial loss of engine power due to improper adjustment of the fuel pump by an unqualified person (pilot-in-command) and the pilot's inadequate preflight planning which resulted in his selection of unsuitable terrain for the attempted takeoff. The pilot's…NTSB CHI97LA015Accident · No injuriesLimited investigationFinal reportCessna 180 · New Richmond, WIthe dual student's failure to recover from the bounced landing and the instructor pilot's failure to correct the situation in time.NTSB CHI97LA005Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Neenah, WIthe local terrain conditions around the airport. A factor was the inadequate runway safety area.NTSB CHI96LA354Accident · No injuriesLimited investigationFinal reportCessna 172L · Delavan, WIthe pilot's failure to assure the airplane was properly secured prior to hand-propping the engine.NTSB CHI96LA346Accident · No injuriesLimited investigationFinal reportBeech B23 · Viroqua, WIthe pilot's inadequate aircraft preflight which led to fuel exhaustion. A factor was the rough uneven terrain.NTSB CHI96LA335Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Janesville, WIfuel exhaustion as a result of an inadequate preflight by the pilot in command.NTSB CHI96FA327Accident · 1 fatalField investigationFinal reportBeech 23 · Tomahawk, WIthe student pilot's impairment of judgment and performance due to alcohol which led to his initiation of VFR flight into instrument meteorological conditions and loss of control. Factors were: the dark night and the weather conditions.NTSB CHI96IA320Incident · No injuriesIncident investigationFinal reportCessna 525 · Milwaukee, WIan uncontained failure of a high pressure turbine disk blade retention post due to fatigue. A factor relating to the incident was: inadequate design of the high pressure turbine disk. Fretting on the leading side of the lobe near the fracture origin may have…NTSB CHI96LA337Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Wausau, WIthe pilot's selection of an unsuitable landing area, and his misjudgment of distance and speed, while attempting to minimize the effect of crossing an uneven area on the runway. The uneven runway condition was a related factor.NTSB CHI96LA293Accident · No injuriesLimited investigationFinal reportAero Commander 600 · Rhinelander, WIa total loss of engine power for undetermined reasons.NTSB CHI96LA286Accident · Serious injuriesLimited investigationFinal reportSchuler T Bird II · Fond Du Lac, WIloss of engine power because of improperly insulated ignition wiring. Factors relating to the accident were improper maintenance; and high obstructions in the emergency landing area, which the pilot had to avoid, resulting in a collision with terrain.NTSB CHI96LA288Accident · No injuriesLimited investigationFinal reportBeech 23 · Wilmot, WIimproper planning/decision by the flight instructor (CFI) by failing to ensure that the airplane would be able to clear brush and trees near the departure end of the runway.NTSB CHI96FA278Accident · 1 fatalField investigationFinal reportLancair 320 · Fond Du Lac, WIthe fatigue in the propeller flange with soft material and oversized lightening holes. A factor was the pilot's inability to maintain control of the aircraft due to the exceeded weight and balance which led to a stall/spin.NTSB CHI96LA271Accident · No injuriesLimited investigationFinal reportCessna 150 · Wisconsin Rapid, WIfuel exhaustion, due to the pilot's improper planning/decision and inadequate fuel management.NTSB CHI96LA268Accident · No injuriesLimited investigationFinal reportUltravia Aero Int'l Pelican · Winneconne, WIfailure of the pilot to maintain directional control of the airplane during the takeoff roll, which resulted in a ground swerve. The location of the tree was a related factor.NTSB CHI96LA267Accident · No injuriesLimited investigationFinal reportYakovlev YAK-3UA · Fond Du Lac, WIthe pilot's inaccurate fuel consumption calculations, and his inadequate in-flight planning and decision making. The pilot's failure to declare an emergency fuel condition (inadequate communication) was a related factor.NTSB CHI96LA263Accident · Minor injuriesLimited investigationFinal reportRockwell S-2D · Bancroft, WIthe pilot's inadequate compensation for wind conditions and failure to maintain directional control, which resulted in a ground swerve, encounter with soft/sandy terrain, and a subsequent noseover. Factors relating to the accident were: the pilot's selection…NTSB CHI96LA262Accident · Minor injuriesLimited investigationFinal reportPiper PA-J3C · Camp Lake, WIseizure of the number 2 piston. Inadequate maintenance was a related factor.NTSB CHI96LA253Accident · No injuriesLimited investigationFinal reportYasecko LONG-EZE · Waukesha, WIFailure of the throttle cable.NTSB CHI96LA252Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · East Troy, WIcorrosion and fracture of the rudder control horn.NTSB CHI96LA236Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 Dromader · Waupaca, WIinadequate maintenance of the throttle cable by maintenance personnel.NTSB CHI96LA225Accident · Serious injuriesLimited investigationFinal reportSisk BD-5 · Lake Geneva, WIfailure of the pilot to abort the takeoff, while there was sufficient runway remaining. The high temperature and calm wind were related factors.NTSB CHI96LA222Accident · 1 fatalLimited investigationFinal reportPiper J3C-90 · Racine, WIwas improper remdial action by the pilot after encountering a stall when the elevator back pressure was not removed and the ailerons were positioned for a right bank by that increasing the airplane's left yaw/roll action. Factors in this accident were a stall…