NTSB investigations, WI
54 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 7 |
| 1984 | 1 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 5 |
| 1991 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 3 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 5 |
| 2006 | 1 |
| 2007 | 2 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 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 CHI07CA087Accident · No injuriesData collectionFinal reportCessna 150 · LaCrosse, WIThe dual student's failure to maintain the proper glidepath and clearance from terrain and the flight instructor's delayed remedial action. A factor was the flight instructor's fatigue.NTSB CHI06FA218Accident · Serious injuriesField investigationFinal reportCirrus Design SR22 · Boyceville, WIThe pilot's failure to maintain adequate airspeed and the certified flight instructor's delayed remedial action and inadequate supervision of the flight training, which resulted in an inadvertent stall during a base to final turn to the landing runway. An…NTSB CHI05CA275Accident · No injuriesData collectionFinal reportCessna T206H · Sturgeon Bay, WIThe unexpected wave that the airplane encountered during the landing flare.NTSB CHI05LA237Accident · 1 fatalLimited investigationFinal reportKircher RV-8 · Menomonie, WIThe pilot's decision to perform an aerobatic roll during takeoff, the low altitude, and his failure to maintain clearance from the crops and terrain.NTSB CHI05CA206Accident · No injuriesData collectionFinal reportLuscombe 8F · Sturtevant, WIThe pilot not obtaining/maintaining airplane control during the aborted takeoff. A factor was the berm.NTSB CHI05FA197Accident · 1 fatalField investigationFinal reportNorth American F-51D · Malone, WIThe pilot not maintaining aircraft control and clearance from terrain for undetermined reasons during a low level maneuver.NTSB CHI05LA091Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Wautoma, WIThe inadvertent stall and low airspeed by the pilot-in-command while maneuvering. Additional causes were the low altitude when the stall occurred and excessive takeoff weight by the pilot-in-command.NTSB CHI04CA250Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Crivitz, WIThe proper touchdown point not attained by the pilot during landing. The road and tailwind were contributing factors.NTSB CHI04FA223Accident · 1 fatalField investigationFinal reportCessna 172L · Webster, WIThe high velocity impact with terrain for undetermined reasons.NTSB CHI04CA189Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Merrill, WIThe dual student's failure to maintain directional control during the initial climb after takeoff and the flight instructor's delayed remedial action. A contributing factor was that all available runway was not used for takeoff due to the touch-and-go…NTSB CHI04FA045Accident · 2 fatalField investigationFinal reportMooney 20E · Webster, WIThe pilot's inadequate decision to conduct a low altitude flight maneuver without sufficient altitude to maintain clearance from the terrain. Low altitude flight and ostentatious display are contributing factors.NTSB CHI03LA272Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Brandon, WIThe pilot failed to maintain clearance from the corn crop during an aerial application maneuver. Additional factors were the terrain induced turbulence and the corn crop.NTSB CHI03LA093Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Sturtevant, WIThe student pilot's abrupt liftoff resulting in his failure to maintain adequate airspeed followed by a stall. Also causal was the instructor's inadequate supervision.NTSB CHI02LA158Accident · No injuriesLimited investigationFinal reportBeech B35 · Lakewood, WIThe pilot's failure to maintain control of the aircraft during takeoff when he encountered a stall after failing to maintain airspeed.NTSB CHI02LA134Accident · Serious injuriesLimited investigationFinal reportAeronca 7FC · Neenah, WIThe pilot not maintaining control of the airplane during the landing approach, and his failure to maintain clearance from terrain.NTSB CHI01FA085Accident · 1 fatalField investigationFinal reportCessna 152 · Horicon, WIthe inadvertent stall/spin. Additional factors included the aerobatic manuevers, low altitude, and the procedures not followed.NTSB CHI01LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Sturtevant, WIThe unsuitable terrain for landing selected by the student pilot, the inadequate initial training by the flight instructor, and the flight instructor's decision to send the student pilot on a solo flight in known adverse weather conditions. Factors to the…NTSB CHI00FA057Accident · 1 fatalField investigationFinal reportBeech D-95A Travelair · Dunbar, WIthe pilot failed to maintain a proper glidepath and obstacle clearance during an instrument approach. Additional factors to the accident included the dark night, icing conditions, flight into known adverse weather, and conditions conducive to pilot fatigue.NTSB CHI99LA007Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Superior, WIthe pilot not maintaining clearance with the terrain, and his improper decision to enter maneuvers too close to the terrain. Factors contributing to this accident were the aerobatic maneuvers, the trees and the berm.NTSB CHI98LA339Accident · No injuriesLimited investigationFinal reportEnstrom 480 · Green Bay, WIthe pilot's failure to maintain adequate rotor rpm during a practice autorotation.NTSB CHI98LA083Accident · Minor injuriesLimited investigationFinal reportNerstrom-Tailwind W-8 · Lodi, WIthe pilot's failure to maintain a proper altitude due to the whiteout conditions. Factors associated with the accident were the low pass performed by the pilot and the visual illusion created by the whiteout conditions.NTSB CHI96LA180Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIthe flight instructor's inadequate supervision. A factor relating to the accident was: the student pilot's improper flare.NTSB CHI95LA133Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Elk Creek, WIthe pilot's failure to maintain clearance with the trees. Factors in the accident include the trees, the tailwind condition, and the pilot's lack of proper certification.NTSB CHI94FA048Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Antigo, WIthe failure of the pilot in command to maintain proper altitude.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 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 CHI90FAMS3Accident · 2 fatalMissing aircraftFinal reportCessna 172M · Kewaunee, WIUndetermined.NTSB CHI90LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · Franklin, WIInadequate compensation for wind conditions by the pilot, and his failure to maintain runway alignment during the attempted go-around (aborted landing). The wind conditions and soft terrain were related factors.NTSB CHI90FA065Accident · 1 fatalField investigationFinal reportCessna 402B · Appleton, WIThe pilot's decision to continue flight into known adverse weather conditions resulting in a windshear encounter with insufficient altitude for recovery. The existing adverse weather conditions were factors.NTSB CHI90LA041Accident · No injuriesLimited investigationFinal reportCessna 172N II · Middleton, WIThe pilot's improper use of flaps to provide lift on short final approach instead of applying power and the failure to maintain aircraft control.NTSB CHI90FA028Accident · 3 fatalField investigationFinal reportBeech A36 · Shell Lake, WIThe pilot-in-command's failure to perform a missed approach, his descending below the minimum descent altitude, and his failure to maintain proper altitude to avoid impact with the terrain. Contributing to the accident was the pilot-in-command's lack of total…NTSB CHI88DEP12Accident · 1 fatalFinal reportPiper PA-36-300 · Pulaski, WIThe aircraft descended at a high rate of speed, 75 degrees nosedown, into the terrain. His widow stated that the pilot had left home at approximately 2100 CST on the accident night, in an inebriated condition. After a discussion about his drinking, he…NTSB CHI88FA120Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Wautoma, WIPerformance of an aerobatic maneuver with insufficient altitude for recovery.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 CHI87LA073Accident · No injuriesLimited investigationFinal reportCessna 182M · East Troy, WIThe aircraft was cruising at approximately 2000 feet AGL when the engine began running rough. The plt stated that he added carburetor heat and leaned the mixture, but the engine continued to run rough. The plt elected to make a precautionary landing in an…NTSB CHI86LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Middleton, WIThe CFI and student had been practicing touch-and-go's and had just made a full stop landing. The CFI reported that during a subsequent soft field takeoff, accelleration seemed a little slow, and after lift-off, the aircraft seemed to stop accelerating…NTSB CHI86FA092Accident · Serious injuriesField investigationFinal reportBeech G18S · Janesville, WIThe aircraft impacted the ground about 1,000 ft to the left of the runway. The pilot stated that he did not have visual contact with the ground & remembers attempting to make a missed approach. Conditions were IMC.NTSB CHI86LA078Accident · No injuriesLimited investigationFinal reportMooney M20-K · Madison, WIA gear up landing was performed by the pilot. He stated that he was distracted by an airliner ahead of him in the pattern and did not consult his before landing checklist. He also stated that he had not flown much in the last three months.NTSB CHI85LA298Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pepin, WIThe aircraft traveled three quarters down a 2300 foot sod runway and the pilot attempted to takeoff with 55 KIAS. The aircraft mushed into trees off the end of the runway when the pilot couldn't obtain flying speed. The pilot reported full engine RPM was…NTSB CHI85LA161Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Stevens Point, WIDuring a low level flt over a river, the plt initiated a turn to reverse direction at 300 ft AGL. The acft contacted the water during the descending turn and nosed over.NTSB CHI85LA126Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Markesan, WIAlthough the pilot believed he had enough visibility to land at this unlighted airfield at dusk, he, in fact, aligned the aircraft up approximately 20 feet to the right of the runway. He landed in a shallow snowbank that paralleled the entire length of the…NTSB CHI85FA020Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Bruce, WIThe acft crashed into a heavily wooded area during a x-country personal flight. Witnesses observed the acft circle the lighted football field at atlanta, WI, at an altitude low enough that they feared the acft would hit trees in the vicinity. At this time the…NTSB CHI84FAMS1Accident · 1 fatalMissing aircraftFinal reportMooney M20C · Near Green Bay, WIAfter a taking off at 2029 CST, the plt climbed to 7000 ft & flew on a southerly heading toward the oshkosh VOR. At 2030, the plt indicated that he had a radio problem, but he remained in radio contact with ATC until a freq change at 2039, then no further…NTSB CHI83FA371Accident · 1 fatalField investigationFinal reportSiai-Marchetti F.260C · Oshkosh, WIThe foreign registered plt had a statement of aerobatic competency by an FAA inspector which contained a min alt limitation of 300 ft AGL. While performing at an air show, he had planned to pull up in a half loop, make a half roll on top, enter a 2 turn spin…NTSB CHI83LA245Accident · No injuriesLimited investigationFinal reportAeronca 7ECA · Wentworth, WIThe CFI stated that he gave the student a simulated emergency landing. When the acft was about 10-20 ft above the ground a gust of wind caught the acft. The acft dropped suddenly and hit the ground. The landing gear folded and the fuselage and wing tips were…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 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 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…