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 CHI08CA233Accident · Minor injuriesData collectionFinal reportErcoupe 415-C · Cedarburg, WIThe pilot not maintaining altitude/clearance from the tree during takeoff. Contributing to the accident were the windshear and the tree.NTSB CHI08FA224Accident · 2 fatalField investigationFinal reportMoser Georg Lancair Legacy FG · Oshkosh, WIThe pilot's failure to maintain adequate airspeed during approach, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CHI08FA222Accident · Minor injuriesField investigationFinal reportPiper PA-22 · Oshkosh, WIThe pilot's failure to maintain adequate airspeed while taking off in gusting winds, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CHI08LA214Accident · Minor injuriesLimited investigationFinal reportBolenbaugh Phillip William Rans S-6ES · Oshkosh, WIThe pilot's improper landing flare, which resulted in a hard landing and subsequent collapse of the nose landing gear.NTSB CHI08LA216Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Watertown, WIThe pilot's failure to maintain adequate airspeed during the go-around, resulting in an aerodynamic stall. Contributing to the accident was the pilot's delayed recovery from the bounced landing.NTSB CHI08LA211Accident · 1 fatalLimited investigationFinal reportBell 47G-4A · Mayville, WIThe pilot's failure to maintain clearance with the rotating rotor blades after he exited the helicopter after landing.NTSB CHI08CA207Accident · Minor injuriesData collectionFinal reportTuth RV-3 · Oshkosh, WIThe compensation for wind conditions disregarded by the pilot and the inadequate in-flight planning/decision making by the plot during approach to the destination airport. A contributing factor was the quartering tailwind.NTSB CHI08CA203Accident · No injuriesData collectionFinal reportEnstrom F28F · Amberg, WIThe unsuitable terrain encountered by the pilot during a forced landing following a loss of engine power due to a cylinder head separation. Contributing to the accident was the tree.NTSB CHI08CA226Accident · Minor injuriesData collectionFinal reportAmerican AA-1A · Grantsburg, WIA loss of engine power for an undetermined reason.NTSB CHI08LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Sparta, WIThe pilot's inadequate preflight planning and the pilot's delay in aborting the takeoff. Contributing to the accident was the airplane's overgross weight condition.NTSB CHI08CA192Accident · Minor injuriesData collectionFinal reportBell 47G-3B · Port Edwards, WIThe pilot failed to maintain control of the helicopter when he inadvertently flared the helicopter and the rotor rpm decayed as a result of sustaining bee stings during an aerial application flight. Contributing to the accidnet included the bees and the low…NTSB CHI08CA202Accident · No injuriesData collectionFinal reportAB Sportine Aviacija Genesis 2 · Beloit, WIThe inadequate visual lookout by the driver of the golf cart and the air/ground communications not available to the golf cart driver during movement onto an active runway while the glider was landing.NTSB CHI08CA188Accident · No injuriesData collectionFinal reportCessna 177A · Rhinelander, WIThe loss of engine power for an undetermined reason. A factor was the berm encountered during the forced landing.NTSB CHI08LA190Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Baldwin, WIUndetermined.NTSB CHI08CA173Accident · Minor injuriesData collectionFinal reportBeech A23A · Sheboygan, WIThe pilot's improper fuel management that led to fuel starvation and the loss of engine power. Contributing to the accident was the drainage ditch.NTSB CHI08FA172Accident · No injuriesField investigationFinal reportEnstrom Helicopter 480B · Marinette, WIThe pilot inadvertently operating the helicopter at a gross weight greater than its maximum allowable operating weight, and flying the helicopter at an airspeed greater than the never-to-exceed speed for the helicopter’s gross weight condition, resulting in…NTSB CHI08CA145Accident · No injuriesData collectionFinal reportCessna 150 · New Berlin, WIThe loss of engine power due to the pilot's failure to use the carburetor heat during the flight. Contributing factors included the carburetor icing conditions and the trees.NTSB CHI08CA130Accident · No injuriesData collectionFinal reportCessna 150 · Pulaski, WIThe student pilot's failure to take remedial action in response to a porpoise/pilot-induced oscillation during landing. Factors were the porpoise, the pilot's lack of experience, and the separation of the nose landing gear.NTSB CHI08FA135Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Stevens Point, WIThe partial loss of engine power for undetermined reasons.NTSB CHI08FA128Accident · 3 fatalField investigationFinal reportEurocopter Deutschland EC 135 T2+ · La Crosse, WIThe pilot’s failure to maintain clearance from trees along the top of a ridgeline due to inadequate preflight planning, insufficient altitude, and the lack of a helicopter terrain awareness and warning system. Member Sumwalt did not approve this brief and…NTSB CHI08CA127Accident · Minor injuriesData collectionFinal reportCessna 140 · Burlington, WIA loss of engine power for undetermined reasons. Contributing to the accident was the low altitude at the time of the loss of engine power.NTSB CHI08LA124Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · New Lisbon, WIThe pilot's failure to maintain adequate altitude during a course reversal at the completion of an agricultural spray run.NTSB CHI08LA123Accident · 1 fatalLimited investigationFinal reportDickenson Bathtub · Broadhead, WIThe pilot's failure to maintain adequate airspeed during approach, which resulted in an aerodynamic stall.NTSB CHI08CA114Accident · Minor injuriesData collectionFinal reportBardouche Quad City Ultralight · Pulaski, WIThe loss of engine power during cruise due to the separation of the spark plug because of the loose threads. Contributing to the accident was trees.NTSB CHI08LA096Accident · No injuriesLimited investigationFinal reportCessna 172R · Monroe, WIThe pilot's decision to land on the wrong runway for the existing wind conditions and his improper recovery from a bounced landing.NTSB CHI08CA084Accident · No injuriesData collectionFinal reportCessna 150G · Viroqua, WIThe pilot not maintaining directional control during the landing and the ground loop the pilot encountered. A factor was the crosswind.NTSB CHI08CA076Accident · No injuriesData collectionFinal reportAmerican AA-1A · Grantsburg, WIThe seizure of the left brake due to a buildup of ice between the rotor and brake pad. Contributing to the accident was the snow and slush covered runway, and the snowbank.NTSB CHI08CA073Accident · Serious injuriesData collectionFinal reportSquier Pauper II · Stockbridge, WIThe pilot's spatial disorientation while maneuvering after takeoff and his subsequent failure to maintain clearance from the terrain. Contributing factors were the snow-covered lake and overcast clouds, which resulted in the pilot's spatial disorientation due…NTSB CHI08FA054Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Warrens, WIThe decision by the pilot to fly into known adverse weather, and the pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing factors include the clouds and the night conditions.NTSB CHI08CA047Accident · No injuriesData collectionFinal reportCessna Skyhawk 172 · Wausau, WIThe pilot failed to maintain directional control during the landing roll. Factors that contributed to the accident included the snow on the runway and the snowbank.NTSB CHI08CA019Accident · No injuriesData collectionFinal reportBell 47G-2A · Wautoma, WIThe pilot's failure to maintain control of the helicopter resulting from a distraction in the cockpit. A contributing factor was the distraction due to the dog in the cockpit.NTSB CHI08CA007Accident · Serious injuriesData collectionFinal reportKrueger Quickie · Antigo, WIThe inadequate preflight planning and preparation by the pilot, the proper climb rate not obtained/maintained by the pilot, and the airspeed not obtained/maintained by the pilot. Contributing factors were the lack of total experience in the type of aircraft…NTSB CHI07CA295Accident · Serious injuriesData collectionFinal reportEkornaas, Fred SkyRanger II Kit · Bristol, WIThe pilot's improper recovery from a bounced landing and his failure to maintain directional control during the attempted go-around. An additional cause was the inadvertent stall as the pilot maneuvered to avoid the hangar. Contributing factors were the…NTSB CHI07CA284Accident · No injuriesData collectionFinal reportCessna 182P · Eau Claire, WIThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor associated with the accident was the ditch.NTSB CHI07LA280Accident · Serious injuriesLimited investigationFinal reportMcFaul, Daniel D. Quicksilver GT500 · New London, WIThe pilot not maintaining airspeed during the unintentional takeoff and the pilot's inadvertent stall.NTSB CHI07LA260Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · West Bend, WIThe pilot's decision to depart in adverse weather conditions, and his failure to maintain clearance from the terrain. Contributing to the accident included the pilot's lack of an instrument rating, his lack of recent night experience, the night conditions and…NTSB CHI07LA238Accident · 1 fatalLimited investigationFinal reportSwanson Aventura II · Lakewood, WIThe pilot's excessive pull up, his not maintaining airspeed, and the inadvertent stall resulting in the loss of control. A factor contributing to the accident was the trees.NTSB CHI07FA243Accident · 1 fatalField investigationFinal reportBeck P-51A · Oshkosh, WIThe P-51A pilot's inadequate visual lookout and his failure to maintain clearance from the P-51D. Contributing factors to the accident included the restricted forward visibility of the P-51A, the air race team representative's inadequate flight brief, the…NTSB CHI07CA231Accident · No injuriesData collectionFinal reportBeech A36 · Sturtevant, WIThe pilot's improper decision to land with a tailwind, which resulted in an overrun during landing rollout. Factors contributing to the accident include the dirt pile and the tailwind.NTSB CHI07CA228Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Oshkosh, WIThe pilot's failure to maintain adequate airspeed during landing which resulted in an inadvertent stall and subsequent impact with the ground.NTSB CHI07LA219Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Fond Du Lac, WIThe loss of engine power due to the failure of the engine's master connecting rod which resulted in the forced landing. The road sign was a factor.NTSB CHI07LA204Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Edgerton, WIThe reported non-mechanical loss of engine power for undetermined reasons during cruise and the excessive airspeed the pilot maintained during the approach for the forced landing. Factors were the loss of electrical power during cruise and the high vegetation…NTSB CHI07LA249Accident · No injuriesLimited investigationFinal reportCessna C-177 · Webster, WIThe loss of engine power for an undetermined reason, and the pilot's misjudged flare during the subsequent forced landing.NTSB CHI07LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Rio Creek, WIThe pilot's improper aircraft weight and balance, and his failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb.NTSB CHI07LA168Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Lakewood, WIThe amphibian nose wheel strut assembly separated due to an overload fracture as a result of the manufacturer's inadequate design.NTSB CHI07MA160Accident · 6 fatalClass 1 · MajorFinal reportCessna 550 · Milwaukee, WIThe National Transportation Safety Board determines that the probable cause of this accident was the pilots’ mismanagement of an abnormal flight control situation through improper actions, including failing to control airspeed and to prioritize control of the…NTSB CHI07LA159Accident · No injuriesLimited investigationFinal reportCessna 340A · Middleton, WIFailure of the right main landing gear extension and retraction linkage, which allowed the gear assembly to collapse during landing rollout. An additional cause was the improper adjustment procedure(s) by undetermined mechanic(s). The runway lights struck…NTSB CHI07CA158Accident · No injuriesData collectionFinal reportCessna 182S · Cedarburg, WIThe improper landing flare which resulted in the airplane porpoising during the landing and the subsequent overload of the nose gear.NTSB CHI07CA132Accident · No injuriesData collectionFinal reportCessna 172P · Kenosha, WIThe pilot's improper recovery from a bounced landing, which resulted in a flat nose wheel tire and a buckled firewall. A factor was the porpoising that was encountered during the flare.NTSB CHI07LA135Accident · No injuriesLimited investigationFinal reportCessna 414A · Sturgeon Bay, WIWorn brakes which resulted in an overrun during landing. A fence was a factor.