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 CHI91LA234Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Sheboygan, WIThe pilot's failure to maintain aircraft control. Factors are the pilot's lack of total expereince, his inadequate recovery from the bounced landing and the crosswind condition.NTSB CHI91DEP11Accident · Serious injuriesFinal reportEnglish Pietenpol Aircamper · Brodhead, WIErosion of an exhaust valve.NTSB CHI91LA229Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Lake Geneva, WIAircraft control was not maintained by the pilot. Factors related to the accident were a quartering tailwind.NTSB CHI91IA223Incident · No injuriesIncident investigationFinal reportBeech B200 · Greenbay, WIInadequate airframe design, which resulted in the in-flight separation of the left engine's outboard aft upper cowl door.NTSB CHI91LA217Accident · No injuriesLimited investigationFinal reportPiper PA22/20 · Stevens Point, WIThe improper installation of the flight control system rudder control rod (rudder cable bellcrank torque tube) by maintenance personnel. A factor contributing to this accident was the inoperative tailwheel steering.NTSB CHI91LA215Accident · No injuriesLimited investigationFinal reportCessna 182A · Menomonee Falls, WIThe fatigue induced propeller blade failure. A related factor was the operator's delayed propeller overhaul.NTSB CHI91DEP09Accident · 1 fatalFinal reportBowers Flybaby 1A · Stoughton, WIThe inadequate design by the manufacturer to provide for adequate protection from moisture accumulation in the form of drain holes. Contributing factors were the deterioration (wood rot) of the wing spar attach and the lack of inspection access.NTSB CHI91DEP10Accident · No injuriesFinal reportAllan R. Goldman Dragonfly · Kenosha, WIInadequate aircraft design and insufficient information regarding wing versus canard angle for an amateur built aircraft.NTSB CHI91DEP08Accident · 1 fatalFinal reportJack Thomas Pitts S-IT · Kenosha, WIImproper maintenance, by person or persons unknown, to the elevator control system which allowed a bolt attaching the elevator control rod to the pitch bellcrank to become disconnected during flight.NTSB CHI91DEP07Accident · No injuriesFinal reportCessna 182M · Wissota, WIThe pilot in command's misjudgment of the proper touchdown point during an emergency landing and the pilot in command's failure to refuel the airplane.NTSB CHI91DEP06Accident · No injuriesFinal reportAvid Flyer Avid Flyer · Endeavor, WIThe pilot in command's inability to effectively eliminate carburetor ice to avoid an emergency landing.NTSB CHI91LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Pulaski, WIThe pilot's failure to select a proper touchdown point. A factor in the accident was inadequate runway maintenance by airport personnel.NTSB CHI91LA177Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Depere, WIThe pilot's failure to correct a mushed stall during liftoff. A factor in the accident was the pilot's failure to compensate for wind conditions.NTSB CHI91DEP05Accident · No injuriesFinal reportPiper PA-25-235 · Neenah, WIThe pilot in command's failure to attain sufficient airspeed to achieve flight, and his failure to abort the takeoff.NTSB CHI91LA157Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Eau Claire, WIThe inadequate finishing procedures used by the manufacturer and the failure to comply with the manufacturer's bulletin.NTSB CHI91LA150Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Hillsbord, WIDirectional control was not maintained by the pilot. A factor related to the accident was a drainage ditch.NTSB CHI91LA149Accident · No injuriesLimited investigationFinal reportCessna 172 · Neosho, WIThe pilot's failure to properly flare the airplane and an improper recovery from a bounced landing.NTSB CHI91LA141Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Evansville, WIThe pilot's selection of unsuitable terrain for landing, not maintaining directional control and attempting a go-around without sufficient airspeed. A factor was the rutted runway surface.NTSB CHI91DER03Accident · 1 fatalFinal reportVarieze 001 · Superior, WIThe pilot's poor planning and decision making which resulted in a loss of engine power due to fuel exhaustion.NTSB CHI91DEP04Accident · Minor injuriesFinal reportBrault Glasair SH2F · Green Bay, WIThe pilot in command's failure to refuel the aircraft prior to departure. A factor contributing to the accident was the unporting of the fuel pick up line in fuel tank during abrupt or negative 'g' maneuvers.NTSB CHI91FA126Accident · 2 fatalField investigationFinal reportBeech F.33A · Chippewa Falls, WIThe first pilot's continued flight in known adverse weather. Factors in the accident were the first pilot's poor weather evaluation, the second pilot's complacency and the first pilot's self induced pressure to complete a checkout in model.NTSB CHI91LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Oskosh, WIRefueling not performed resulting in loss of engine power due to fuel exhaustion. Factors related to the accident were misjudged fuel consumption calculations and non suitable terrain.NTSB CHI91LA102Accident · 1 fatalLimited investigationFinal reportAeronca 15AC · St.Croix Falls, WIFailure to conduct a passenger safety briefing, and inadequate supervision, by the pilot in command. A factor related to the accident is the passenger's inattentiveness.NTSB CHI91LA096Accident · No injuriesLimited investigationFinal reportCessna 152 · Osseo, WIFuel exhaustion which occurred when the pilot became lost/disoriented. Factors related to the accident were: the pilot's lack of total experience, the terrain condition, and a fence.NTSB CHI91LA095Accident · Serious injuriesLimited investigationFinal reportBeech G35 · Teedsburg, WIFailure of the pilot to obtain or maintain adequate airspeed for a go-around (aborted landing), which resulted in an inadvertent stall/mush. The failure to attain proper runway alignment for landing was a related factor.NTSB CHI91LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Marshfield, WIImproper in-flight planning/decision by the pilot and his failure to maintain airspeed, which resulted in an inadvertent stall/mush onto snow covered terrain beside the runway. The adverse weather conditions and snow covered terrain were related factors.NTSB CHI91FA088Accident · 7 fatalField investigationFinal reportPiper PA-28-140 · Osceola, WIFailure of the pilots in both aircraft to seeing-and-avoid the other airplane.NTSB CHI91LA076Accident · No injuriesLimited investigationFinal reportCessna 320 · Middleton, WIThe main landing gear collapsed during landing rollout due to extreme cold temperatures. A factor related to the accident was a snowbank adjacent to the runway.NTSB CHI91LA080Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIThe pilot's failure to maintain directional control.NTSB CHI91DEP03Accident · 1 fatalFinal reportAir Command 503 · Tomahawk, WIThe pilot-in-command's abrupt movement of the flight controls which resulted in loss of rotor RPM and eventual departure from controlled flight. A factor contributing was ice accumulation on the pilot's face resulting in pilot incapacitation (visual…NTSB CHI91LA072Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Springbrook, WIThe pilot's attempt to takeoff with a strong gusty tailwind.NTSB CHI91LA060Accident · No injuriesLimited investigationFinal reportCessna 150D · Ft. Atkinson, WIThe pilot's failure to refuel. A factor was unsuitable terrain for landing.NTSB CHI91LA054Accident · No injuriesLimited investigationFinal reportCessna 172P · New Holstein, WIThe pilot's decision to continue the landing approach, landing on an ice covered runway and the inadequate compensation for the croswind.NTSB CHI91LA047Accident · 2 fatalLimited investigationFinal reportCessna 175 · Boscobel, WIThe pilot's continued VFR flight into instrument meteorological conditions (IMC) and his failure to remain clear of the trees. Factors related to the accident were: the adverse weather conditions and the pilot's lack of instrument experience.NTSB CHI91LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Portage, WIDelayed go-around and stall encountered. Contributing factors were a snow bank, proper alignment not attained, and raising the flaps not performed by the PIC.NTSB CHI91DEP02Accident · Serious injuriesFinal reportCessna 172P · Hayward, WIThe pilot-in-command's intentional flight into known adverse weather.NTSB CHI91DEP01Accident · No injuriesFinal reportDean Bartel Avid Flyer Stol · New London, WIThe pilot's failure to obtain a proper touchdown point and his delay in initiating a go-around.NTSB CHI91LA019Accident · No injuriesLimited investigationFinal reportCessna 150 · La Crosse, WIInadequate visual outlook by the PIC.NTSB CHI91LA020Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180D · Crivitz, WIImproper planning/decision by the pilot, and his failure to abort the takeoff (while there was sufficient runway remaining).NTSB CHI91LA017Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Portage, WIThe PIC became lost and disorientated and performed a premature precautionary landing.NTSB CHI90LA274Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob 109A · Waukesha, WIThe pilot's failure to maintain adequate clearance and visual lookout for the moving tractor.NTSB CHI90DEP11Accident · Minor injuriesFinal reportVarga Kachina 2150A · Neenah, WIThe pilot's misjudgement of the fuel supply, and his failure to refuel the aircraft. Contributing to the accident was the unsuitable, soft terrain encountered.NTSB CHI90LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIFuel exhaustion. Contributing factor was the unsuitable terrain.NTSB CHI90DEP10Accident · No injuriesFinal reportBrose Cirrus VK-30 · Baraboo, WIThe pilot's inadequate preflight and misjudgement of the amount of fuel on board, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. The inoperative fuel totalizer was a related factor.NTSB CHI90MA244Accident · 5 fatalMajor investigationFinal reportBell 206B · Elkhorn, WIImproper planning/decision by the pilot, and his failure to attain adequate altitude before flying over rising terrain at night. Factors related to the accident were: darkness, fog, haze, rising terrain, and the lack of visual cues that were available to the…NTSB CHI90FA236Accident · 7 fatalField investigationFinal reportPiper PA-32R-300 · Watertown, WIInitiation of VFR flight into adverse weather and instrument meteorologial conditions. Factors which contributed to the accident were the adverse weather conditions and the pilot's self-induced pressure to maintain currency.NTSB CHI90DEP09Accident · Serious injuriesFinal reportCessna 182 · Columbus, WIThe skydiver's panic and failure to depart the aircraft as instructed. Contributing was the skydiver's lack of total experience in this type of operation.NTSB CHI90FAMS3Accident · 2 fatalMissing aircraftFinal reportCessna 172M · Kewaunee, WIUndetermined.NTSB CHI90DER06Accident · 1 fatalFinal reportMooney M20C · Webster, WIThe pilot's failure to maintain control of the airplane. Factors related to the accident were: the dark night, the pilot's alcohol impairment, and his night flying restriction.NTSB CHI90DEP08Accident · Minor injuriesFinal reportChristen Industries Eagle II · Milwaukee, WIThe pilot-in-command's failure to maintain aircraft control, his misjudgment of proper glidepath and his not performing a timely go-around.