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 CHI88DEP11Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Plover, WIThe aircraft collided with a farm machinery shed during an aerial application maneuver. The pilot stated that there was no powerplant or control malfunction. The temperature at the accident site was 87 degrees (f), with a calculated density altitude of 2944…NTSB CHI88LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Dodgeville, WIDuring an attempted landing in gusty wind, the pilot failed to maintain directional control, got blown off to the left side of the runway and experienced a tail strike. The pilot attempted to abort the landing, but was unable to climb out of ground effect,…NTSB CHI88DEP10Accident · No injuriesFinal reportPiper PA-25-235 · Beaver Dam, WIWhile in cruise flight the aircraft experienced a total loss of power due to fuel exhaustion. The pilot stated that there were no good landing areas available, so he elected to make the emergency landing in a marsh. The aircraft landed hard and sustained…NTSB CHI88DEP09Accident · Minor injuriesFinal reportEaa Acro II · Fond Du Lac, WIThe plt rprtd that after reaching cruise alt, the eng began to run rough & subsequently lost power. He made an emerg landing in a dry cultivated field. Drg the landing, the gear collapsed & the acft was substantially damaged. The fuel tank was equipped with a…NTSB CHI88LA193Accident · No injuriesLimited investigationFinal reportCessna 172 · Milwaukee, WINTSB CHI88LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WINTSB CHI88FAMS2Accident · Serious injuriesMissing aircraftFinal reportMooney M20K · Racine, WIEngine failure due to fuel starvation.NTSB CHI88DEP08Accident · No injuriesFinal reportMonnett Sonerai II · Wisc Rapids, WIThe plt rprtd that drg takeoff, the eng lost power as the acft was climbing thru about 200' AGL. An emerg lndg was made in the best available area, which was a golf course on rolling terrain. Drg the lndg roll, the plt applied brakes, but was unable to stop…NTSB CHI88FA179Accident · 1 fatalField investigationFinal reportPiper PA-30 · Oshkosh, WINTSB CHI88FA178Accident · No injuriesField investigationFinal reportSonerai IIL · Oshkosh, WINTSB CHI88FA177Accident · No injuriesField investigationFinal reportQuickie Q-2 · Oshkosh, WIThe plt was on a flt to Oshkosh to an eaa convention. When he arrived, traffic was hvy & special traffic procedures were in effect. Info to attendees (before the convention) advertised that the north/south rwys would be used primarily for display acft & the…NTSB CHI88LA174Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Neillsville, WINTSB CHI88DEP07Accident · No injuriesFinal reportCessna 182B · Burlington, WIDrg a normal dscnt, in preparation to land, the eng lost all power. The plt made an emerg landing, but drg the landing roll-out, the nosewheel enctrd soft, uneven terrain & the acft nosed over. No fuel was found in the fuel tanks or carburetor float bowl, but…NTSB CHI88DEP06Accident · No injuriesFinal reportHuntley Challenger II · Platteville, WIAfter climbing about 100' after takeoff, a partial power loss occurred & the plt initiated a left turn to rtrn to the arpt. Unable to reach the arpt, an emerg lndg was made in a corn field & the acft was damaged. No airframe failure was found & the eng ran…NTSB CHI88DEP05Accident · No injuriesFinal reportGriffin Pitts S-1S · Rio, WIWhen the pilot of the amateur built biplane initiated a go-around from a VFR approach, he found that he had no response to throttle application. He then executed an intentional forced landing in an adjacent field. During this landing the aircraft collapsed a…NTSB CHI88LA148Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Menomonee Falls, WINTSB CHI88LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Grafton, WIWhile landing at a 1,900' sod airstrip with a 10 knot crosswind, the aircraft swerved to the left, ran off the runway and struck some small trees and shrubs. The pilot lacked total experience in low wing aircraft and lacked familiarity with that particular…NTSB CHI88LA142Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Kenosha, WIThe pilot was picking up the aircraft after being serviced when approximately 20 minutes after taking off the engine quit. The pilot was forced to make an emergency landing in a field. During the landing sequence the aircraft contacted some trees at the edge…NTSB CHI88LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Portage, WIDuring taxi from landing the pilot failed to maintain adequate visual lookout and taxied onto a runway in front of an aircraft on its landing roll. The pilot stated that as he approached the other runway his visibility was restricted by a stand of trees, and…NTSB CHI88LA125Accident · Minor injuriesLimited investigationFinal reportCessna TU206B · Ellsworth, WIDuring cruise flight the pilot experienced an engine failure which he believed to be caused by fuel exhaustion, and executed a forced landing in unsuitable terrain. Post accident inspection revealed that the left fuel tank contained 23 gallons of fuel at the…NTSB CHI88IA129Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Madison, WIFailure of the right outboard flap position signalling cable due to chaffing initiated by improper installation/rigging by a manufacturer's vendor.NTSB CHI88FA120Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Wautoma, WIPerformance of an aerobatic maneuver with insufficient altitude for recovery.NTSB CHI88LA116Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · La Crosse, WINTSB CHI88FA102Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Merrimac, WIThe pilot had just taken off from a private strip and immediately entered a high angle of bank turn to the left at low altitude. A witness, who was an experienced aerobatic pilot, estimated the angle of bank to approach 90 degrees. The nose was seen to pitch…NTSB CHI88LA083Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, WIThe pilot was landing on the 40 foot wide rnwy in a 10-12 knot x-wind. He stated he had little rnwy reference in the dark night due to a very faded rnwy centerline. The acft ran off the hard surface into the mud, ran into a depression in the soil and nosed…NTSB CHI88DEP04Accident · No injuriesFinal reportCessna 172L · West Bend, WIAfter 30 minutes of local flight, on a dark night, the pilot increased the throttle setting after selecting approach flaps. There was no response from the engine. A forced landing was initiated and the aircraft collided with trees and terrain. A subsequent…NTSB CHI88LA070Accident · No injuriesLimited investigationFinal reportCessna 172A · Crivitz, WIThe aircraft did not accelerate as anticipated by the pilot, who was attempting to takeoff from a wet sod strip. The pilot elected to abort the takeoff, however was unable to stop on the remaining runway, exited the departure end, struck a snow bank and nosed…NTSB CHI88LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Wis. Rapids, WIAirplane drifted left into a snowbank while rolling out from a landing on a snow and ice covered runway. Landing winds as reported by the pilot were from 60 degrees to the right of the nose at 5 to 8 knots.NTSB CHI88FA056Accident · 1 fatalField investigationFinal reportCessna 150M · Norwalk, WIThe pilot made several calls to the fss and obtained weather briefings for reported and forecast IFR conditions along his proposed route of flight. After departure from sparta, Wisconsin in weather described by witnesses to be below VMC, the aircraft impacted…NTSB CHI88LA051Accident · No injuriesLimited investigationFinal reportCessna 172N · Fond Du Lac, WINTSB CHI88DEP03Accident · Minor injuriesFinal reportPiper PA-38-112 · Sheboygan, WIThe aircraft experienced a loss of control during the takeoff portion of a touch and go. The aircraft departed the runway and struck a snowbank collapsing the nose gear. The aircraft was substantially damaged.NTSB CHI88LA055Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Barron, WIThe pilot misjudged altitude and distance and touched down short of the runway and struck a snowbank. Pax stated that the pilot cut pwr about 200 ft from the runway; the aircraft began to sink fast. The pilot applied power too late to prevent the undershoot.…NTSB CHI88LA043Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Stanley, WINTSB CHI88LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Mt. Pleasant, WIThe stu plt climbed to 1600 ft MSL aft tkof. Shortly aft level off, the engine stopped. He attempted an air start without success. During the forced lndg the nose wheel dug in and the acft nosed over in the soft soil. During a post crash interview, the stu…NTSB CHI88DEP02Accident · Serious injuriesFinal reportBeech V35B · Waukesha, WIShortly after liftoff in IMC, the acft descended to the ground. The plt had been cleared for a rt turn but the controller noticed the acft turning left at about 50 ft AGL. The plt later could not stop the drifting to the left. The lndg gear was raised and the…NTSB CHI88MA026Accident · 8 fatalMajor investigationFinal reportBeech 200 · Jefferson, WIWhile cruising abv frzg lvl at 12,000', the flt was clrd to dscnd & maint 9000'. Abt 1-1/2 min ltr, the flt declared a mayday (emergency). Radio & radar ctc were lost & the acft crashed in a nr vertical dscnt. Radar data showed that after starting a dscnt,…NTSB CHI88LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Manitowoc, WIThe pilot and his two pax were on takeoff roll at the local, uncontrolled arpt. The pilot stated that just prior to rotation a deer ran onto the runway and the right wing struck the deer. The pilot aborted the takeoff without incident.NTSB CHI88LA019Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Cumberland, WIAt 0112 CST, the plt telephoned the fss & requested a wx outlook for a 0600 CST departure. The wx briefer adzd the wx to the south was deteriorating & that the destn would be IFR by about the planned departure time. Also, the briefer suggested the plt could…NTSB CHI88LA004Accident · No injuriesLimited investigationFinal reportCessna 150H · Elroy, WIUpon attempting his tenth touch and go the student pilot noticed, prior to touchdown, that the aircraft was to the right of the runway. In an attempt to realign himself with the runway the pilot stated he 'lowered' the left wing. The left wing then struck the…NTSB CHI88LA002Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Verona, WIDuring a VFR landing abort full power was applied and flaps selected to the full up position. The aircraft began to settle and a turn to the left was initiated. The left wing dropped abruptly, the nose pitched down and a left hand rotation began. This…NTSB CHI88IA003Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Milwaukee, WIAircraft landed without further incident after exhaust centerbody fell away from the #1 engine during initial climb. The centerbody landed on private property with no property damage. A service bulletin issued by the manufacturer to inspect the centerbody and…NTSB CHI88DEP01Accident · Minor injuriesFinal reportGrumman G-44 · Delevan, WIOn initial takeoff roll the aircraft experienced a loss of control in a strong crosswind, departed the runway to the left, struck a tree line and over turned.NTSB CHI87LA222Accident · No injuriesLimited investigationFinal reportCessna 150H · Sparta, WIThe plt was taking off on his pvt strip in a prevailing 12 kt x-wind that was vrbl & blowing fm a 'lull' to 18 KTS. He said the strip was located near an l-shaped ridge which attenuated the general wind flow. Also, he said the 1900' sod strip sloped downhill…NTSB CHI87LA214Accident · No injuriesLimited investigationFinal reportBeech E55 · Green Bay, WIThe plt intended to land long on rwy 36L since he parked the acft near the north end of the field. He stated that he flew over the rwy at an alt of aprx 30 ft until near the intx with rwy 6/24, then he retarded the throttles & adjusted the trim for landing.…NTSB CHI87LA211Accident · No injuriesLimited investigationFinal reportCessna 172K · Jefferson, WIThe aircraft was en route on a personal cross country flight when it experienced an engine failure and was forced to make an emergency landing in an alfalfa field. The aircraft landed long and collided with a telephone pole and fence at the end of the field.…NTSB CHI87LA200Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Appleton, WIThe plt rprtd that after the acft was at cruise flt, there was a rapid loss of hydraulic pressure. He returned to the dep arpt, but was unable to get the left main gear to lock down. Subsequently, the left main gear collapsed when the acft was landed. An…NTSB CHI87LA206Accident · No injuriesLimited investigationFinal reportCessna 152 · Phillips, WIDuring the takeoff phase of a touch and go landing the student pilot lost directional control of the aircraft. The aircraft exited the runway to the left, struck a ditch and overturned. The student's instructor, who was a witness to the accident states that…NTSB CHI87FA197Accident · 2 fatalField investigationFinal reportAeronca 7AC · Kenosha, WIThe aircraft was on final approach for landing during a dual instructional flight. The aircraft was observed to pitch up, then enter a nose down, right wing low attitude which it maintained until it impacted the ground. Witnesses, including another CFI who…NTSB MKC87FA161Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Solon Springs, WIThe surviving pax rprtd that drg initial climb after takeoff, the eng suddenly stopped & did not respond to atmts of a restart. The plt turned back toward the arpt, but was unable to reach the rwy. The acft impacted large trees in a wooded area, then crashed…NTSB CHI87FA191Accident · No injuriesField investigationFinal reportBeech B90 · Milwaukee, WIOn departure the crew identified an in flight fire. An immediate shutdown of electrical, environmental and pressurization systems was initiated and a return was made to the airport with a successful landing. The fire was discovered to have occurred in the…