NTSB investigations, WI
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 CHI83LA173Accident · Minor injuriesLimited investigationFinal reportGrumman G-44 · Fond Du Lac, WIThe pilot became preoccupied with a minor electrical problem and did not raise the landing gear before making a landing on water. Upon water contact, the landing gear effected enough drag to nose the aircraft over.NTSB CHI83LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Rice Lake, WIThe acft hit a ditch and nosed over during a forced landing after the engine quit. The plt was on a cross country and had landed enroute 3 times without refueling. With the assistance of eau claire fss he overflew Rice Lake arpt but could not find it. The…NTSB CHI83FA166Accident · 1 fatalField investigationFinal reportPiper PA24-260 · Middleton, WIDuring arrival at night, the plt was cleared for a vor-b apch to the morey arpt, an uncontrolled facility at an elevation of 928 ft MSL. Rwy 13/31 at the arpt had low intensity rwy lights which could be activated by keying the radio on 123.5 mhz. The circling…NTSB CHI83LA150Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee 28-5ACF · Neilsville, WIThe aircraft was crash landed in an open field after it had a power loss on #1 engine during cruise flight. The aircraft was on a geodetic survey flight which called for flight at 500 feet AGL. The pilot elected to land because the aircraft could not maintain…NTSB CHI83LA147Accident · No injuriesLimited investigationFinal reportCessna 150 · Oshkosh, WIThe student plt was on a supervised, solo, x-country flt from mosinee, WI, to Oshkosh, WI, green bay, WI, then return to mosinee. The first leg of the flight was flown with no problem. Before takeoff at oshkosk, the student was taxiing southbound with a left…NTSB CHI83FA139Accident · No injuriesField investigationFinal reportBeech 58 · Miwaulkee, WIThe plt reported that he noted a fairly loud sound as the landing gear locked in the up position. Later, he was unable to extend the gear with either the normal or emergency systems. The circuit breaker would pop each time he tried the normal system. The…NTSB CHI83LA131Accident · No injuriesLimited investigationFinal reportMooney M20C · Solon Springs, WIThe pilot reported that when he departed Solon Springs, WI at 2100 CST, the weather was windy, but the sky was clear. He landed at minneapolis, MN to pick up a passenger, then departed on a return flight to Solon. While returning, he encountered snow. The…NTSB CHI83FA123Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Beloit, WIReportedly, the plt had not flown for 2 or 3 months before his flts on 2/27/83. On that day, he took off & made 5 touch-and-go landings, then stopped for a cup of coffee. The plt then departed again on a 2nd flt. Aprx 1/2 hr later, smoke was observed from the…NTSB CHI83LA109Accident · No injuriesLimited investigationFinal reportCessna 150 · Calumetville, WITais Cessna 150 collided with snow covered terrain while practicing the results of 'ground effect'. The weather was VMC and no flight plan was filed. The pilot was not injured in the accident. The flight originated at fond du lac WI at 1200 CST on feb. 12,…NTSB CHI83FA108Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Reedsburg, WIThe acft impacted a quonset-type bldg while apparently on an unusual type approach for landing. One witness observed theacft make a low south to north pass over the rwy & then pull up into a loop that culminated in the quonset impact. Another witness observed…NTSB CHI83LA107Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Mauston, WIThe acft collided with a frozen lake during a low pass while sight seeing. The pilot stated that he dropped down to 250 feet AGL to see if anyone was fishing and hit a downdraft. The acft descended and made contact with the snow and ice covered lake. The…NTSB CHI83IA103Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110 · Milwaukee, WIThe acft experienced extreme oscillations about the pitch axis with the control column moving fore & aft from 1 to 3 inches. The oscillations varied directly with airspeed. No out of limit conditions were found until after a second occurrence when the…NTSB CHI83FA090Accident · 2 fatalField investigationFinal reportPiper PA-22-20 · Siren, WIWitnesses heard a sound of an acft eng, but because of low clouds & fog they could not see the acft. They heard the sound of the eng, a loud roar, the breaking of trees, & thena 'bang.' They then found the acft which had penetrated a wooded area at a 70 deg…NTSB CHI83FA086Accident · Minor injuriesField investigationFinal reportPiper PA-32-300 · Monroe, WIWhile cruising at 4,000 ft MSL the eng quit. During a forced landing on rolling farm terrain both main landing gear separated. The acft then slid through a barbed wire fence & caught fire. Metallurgical examination revealed a fatigue failure of the idle set…NTSB CHI83LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172 RG · Green Bay, WIThe acft collided with the ground during an ILS approach. The weather was IMC at the time and an IFR flt plan was filed. The pilot was instrument rated and had received a weather briefing which forecast icing and freezing drizzle. The pilot told the weather…NTSB CHI83FA069Accident · 2 fatalField investigationFinal reportNorth American T-6G · Genoa City, WIPrior to the accident the acft flew over the arpt at tree-top level with the gear retracted. The acft then landed. After spending about 15 min on the ground the plts took off to the west. The gear was retracted immediately after takeoff & the acft remained…NTSB CHI83LA074Accident · No injuriesLimited investigationFinal reportCessna 140 · Springbrook, WIThe acft collided with a four ft snowbank at the rwy threshold during landing. This was a dual instructional flt with the student in the right seat. The CFI had made no landings in this make and model of acft in the previous 90 days. The pilot stated that due…NTSB CHI83LA067Accident · No injuriesLimited investigationFinal reportCessna T210N · Cassville, WIThe pilot stated that he refueled at mobile but did not visually check the fuel tanks. The pilot thought he had 15 gallons of fuel remaining at the time the engine loss power. Fuel tanks were switched from left to right and held on "hi" boost (auxiliary boost…NTSB CHI83LA055Accident · No injuriesLimited investigationFinal reportCessna 175 · Neenah, WIPilot took off in short ground run. Crosswind blew aircraft to east side of runway. No climb established. Aircraft flew into trees alongside runway. Alignment with runway not maintained.NTSB CHI83FA049Accident · 2 fatalField investigationFinal reportAeronca 11CC · Spencer, WIThe acft was observed in a steep left turn at low altitude then impacting the ground straight down. Both propeller blades were bent back with no evidence of twisting. Approximately 1/2 inch of ice was found in the fuel line gascolator.NTSB CHI83LA045Accident · No injuriesLimited investigationFinal reportPitts S1S · Wonewoc, WIThe pilot stated that when he turned on final and slipped the aircraft to lose altitude. While reducing the power to idle the gear tangled in high grass (weeds), causing the aircraft to lose additional altitude. He stated the aircraft tumbled forward,…NTSB CHI83LA040Accident · Serious injuriesLimited investigationFinal reportPiper 601P · Sheboygan, WIThe plt noticed haze in lights at destination but had excellent ground contact throughout the approach. At threshold he entered dense ground fog & lost all visual contact. The acft crashed during the go-around.NTSB CHI83LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Black River Fal, WIAfter flying in the local area about 1 hr, the pilot landed at the airport. While taxiing back to the hangar, he elected to make another short flight. The aircraft was taxied back to the runway and a takeoff was made. No engine runup or carburetor heat check…NTSB CHI83LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Stevens Point, WIThe aircraft porpoised during landing. The pilot stated that he bounced off the main gear then the nose gear. He then applied power but the aircraft continued to bounce. After he shut down power to the engine the aircraft continued to bounce finally coming to…NTSB CHI83FA016Accident · 1 fatalField investigationFinal reportLuscombe 8A · Delavan, WIThe airport manager stated that the aircraft had been flying for about 45 min when it returned to the airport. He reported that the pilot made a low pass over the runway, as if he was checking the wind for landing. He saw the pilot start to climb and enter a…NTSB CHI82DA369Accident · No injuriesFinal reportPiper PA-25-180 · Baldwin, WIThe pilot attempted to takeoff from a 1200 ft alfalfa field with a load of seed but was unable to obtain flying speed. By the time he realized the situation, there was not enough room to stop. He reported that he released the back pressure until he was near…NTSB CHI82DA359Accident · Serious injuriesFinal reportScorpion Too · Sheboygan Falls, WIThe pilot made a turn after takeoff and the aircraft vibrated and crashed. No malfunction was found.NTSB CHI82FA357Accident · 2 fatalField investigationFinal reportFlitecraft Senior Aero · Footville, WIThe home built aircraft was on a familiarization flight for the pilot in the right seat. One witness stated he saw the aircraft (at about 2000 ft AGL) enter a nose high (straight up) attitude followed by a nose low (straight down) attitude. A spin then…NTSB CHI82FA342Accident · 1 fatalField investigationFinal reportBeech H35 · Beaver Dam, WIAt about 1530 CDT, the aircraft departed madison, WI on a flight to the dodge county airport at juneau, WI. According to a fixed base operator at juneau, the pilot had made arrangements to fly the aircraft there on that date for an annual inspection. At 1544,…NTSB CHI82DA340Accident · No injuriesFinal reportCessna 150H · Genoa City, WIReturning from a cross-country flight the pilot overshot the touchdown point. During the go-around, the engine quit and the aircraft hit a tree. The pilot stated that he did not evaluate his fuel consumption properly.NTSB CHI82IA331Incident · No injuriesIncident investigationFinal reportSwearingen SA-226TC · Appleton, WIThe right main gear "in transit" light remained on after gear retraction on a training flight. Various methods of remedial action did not cure the problem. A landing on runway 21 was executed with the nose and left main gear in the down position. The right…NTSB CHI82FA329Accident · 1 fatalField investigationFinal reportCessna 310Q · Near Woodruff, WIAt approximately 2050, the acft was cleared for a NDB approach to lakeland arpt. At 2100, the acft crashed into a heavily wooded area 8.5 mi nw of the arpt.NTSB CHI82DA328Accident · Minor injuriesFinal reportCessna 172 · Kenosha, WIN8186X crashed 300 feet short of Kenosha airport, runway 06. The pilot stated the elevator control failed to respond during the approach. However, an on-site investigation failed to reveal any mechanical failure or malfunction.NTSB CHI82FA304Accident · Serious injuriesField investigationFinal reportHiller UH12L4 · Wisconsin Dells, WIDuring climb, at about 200 ft AGL, the m/r lost RPM. During autorotation the eng RPM increased beyond the red line when the plt added power. The helicopter made a hard landing in a residential area. Inspection of the mercury clutch revealed that the exterior…NTSB CHI82DA309Accident · No injuriesFinal reportCessna 152 · Boyceville, WISolo student pilot on 2nd takeoff after a delay aborted the takeoff. During abort he lost control and ground- looped into a pile of logs. The aircraft then nosed over.NTSB CHI82DA295Accident · No injuriesFinal reportBoeing Stearman A75-300N1 · Whitehall, WIThe pilot received a weather briefing before takeoff, and reportedly, was advised that VFR flight was not recommended. During the flight, the ceiling and visibility began to decrease. The pilot decided to make a precautionary landing in a field. He stated…NTSB CHI82DA294Accident · No injuriesFinal reportBreezy RLU1 · Milwaukee, WIThe pilot stated that he got a weather briefing before departing oshkosh, WI. While en route, he encountered fog and rain. The pilot attempted to continue to find timmerman or rainbow airport. The engine lost power due to fuel exhaustion. While landing on a…NTSB CHI82FA290Accident · 3 fatalField investigationFinal reportStarduster II · Oshkosh, WIBoth acft were operating in the fly-by (no radio) pattern during the annual eaa convention. According to participant records both plts had received fly-by pattern briefings. Both acft were observed to be in the southern most portion of the upwind leg of the…NTSB CHI82IA284Incident · No injuriesIncident investigationFinal reportCessna 182P · Oshkosh, WIThe pilot entered traffic pattern downwind as number 3 for landing. Traffic pattern spacing required a three mile final approach over lake winnebago. The pilot stated that there were two slower aircraft preceeding him and that spacing between aircraft was…NTSB CHI82DA287Accident · No injuriesFinal reportBeech A23A · Grantsburg, WIThe pilot could not start the aircraft with the mixture in the normal (rich) position. The mixture was set to lean and the engine started. During takeoff, the engine lost power and the pilot landed off the end of the runway. This was the first flight since an…NTSB CHI82DA281Accident · No injuriesFinal reportEnstrom 280C · Spring Green, WIThe aircraft was on a photographic flight for the purpose of taking pictures of a piece of farm equipment. The first pass was made at about 50 ft AGL, heading into the wind. A turn was then made downwind, back toward the farm equipment. At about that time,…NTSB CHI82DA278Accident · No injuriesFinal reportPiper PA-23 · Ladysmith, WIA ferry permit was issued to fly the aircraft to the rusk county airport for an annual inspection. The previous annual inspection had been on 8/20/80. During the arrival at the destination, the approach was high, so the pilot elected to go around. At about…NTSB CHI82DA277Accident · Minor injuriesFinal reportCessna 172P · Bruce, WIThe pilot departed an alfalfa field that was eight inches high and heavily saturated with dew. A witness stated that upon takeoff the nose of the aircraft was abruptly raised, the aircraft rose about 50 feet, the left wing dropped, the aircraft descended, and…NTSB CHI82FA267Accident · No injuriesField investigationFinal reportRobinson R22 · Milwaukee, WIAs the student plt was practicing a hovering maneuver, the acft started moving to the left & losing altitude slowly. The CFI was adding collective pitch when the left skid contacted the ground & the acft rolled over. The left skid, m/r blades & tailboom…NTSB CHI82FA255Accident · 2 fatalField investigationFinal reportAeronca 7AC · Pine Valley Tow, WIThe acft was observed flying at a low altitude to a point 1/4 mi NE of the town over a wooded area & began a turn to the left. During the turn the bank continued to increase & then the nose dropped & the acft descended steeply into the trees. The police…NTSB CHI82DA253Accident · No injuriesFinal reportCessna A185F · Lake Delton, WIThe float equipped aircraft was being operated on its first flight of the day. After takeoff, the pilot noted a deterioration of power as he was climbing through about 400 ft AGL. He was unable to restore the power and could not maintain level flight. During…NTSB CHI82DA251Accident · Serious injuriesFinal reportCessna 172P · Washington Island, WIDuring arrival, the pilot made an approach to runway 14 for a night landing. After flaring to land, the aircraft was observed to float. The pilot stated that he had come in high, and during a go-around, the aircraft did not seem to climb properly, then…NTSB CHI82DA244Accident · No injuriesFinal reportFairchild 24R-46A · Franklin, WIThe pilot took off and remained in the traffic pattern to land on runway 27. He estimated that the wind was from 300 degrees at 10 knots. He reported that on final approach, he got too low; then about 200 ft short of the runway, his head wind was blocked by…NTSB CHI82DA241Accident · Serious injuriesFinal reportCessna 188B · Stevens Point, WIThe pilot stated that when he was pulling up from a swath run, he noticed a left spray nozzle was leaking. At the same time, he noticed a person on the porch of a house that he was flying over. As he looked to see if the house and person would be avoided, the…NTSB CHI82DA238Accident · No injuriesFinal reportPiper PA-28-200R · Black River Fal, WIThe pilot stated that during flight, he encountered an engine problem and started to land on a road, but then the engine began to run better, so he continued to his destination. After landing, he discovered that a portion of the vertical stabilizer (about 18…