NTSB investigations, WI
40 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 4 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 2 |
| 1993 | 1 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 2 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2006 | 2 |
| 2007 | 1 |
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\" = 310)
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" = 310) 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 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 CHI07LA021Accident · No injuriesLimited investigationFinal reportBoeing 717-200 · Milwaukee, WIThe failure of ground personnel to verify the clearance between the airplanes prior to signaling the crew tha the crew of the other airplane that they were cleared to taxi.NTSB CHI06FA206Accident · 1 fatalField investigationFinal reportGrumman TBM-3 · Oshkosh, WIThe Avenger pilot's visual lookout was inadequate and he failed to maintain clearance from the RV-6. Contributing factors were the Avenger's restricted visibility and the RV-6.NTSB CHI03FA234Accident · No injuriesField investigationFinal reportBeech M35 · Oshkosh, WIThe pilot's inadequate in-flight planning/decision and his failure to execute a go-around. Contributing factors were the pilot's failure to attain alignment with the runway centerline, the runway light and the airport sign.NTSB CHI03LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Neenah, WIThe pilot failed to maintain clearance from the post. Factors included the post and the sun glare.NTSB CHI02CA279Accident · Serious injuriesData collectionFinal reportCessna 120 · Brookfield, WIThe inadequate visual outlook by the pilot during taxi.NTSB CHI01LA301Accident · No injuriesLimited investigationFinal reportCessna 150L · Madison, WIThe deer which struck the empennage of the airplane during the landing flare.NTSB CHI01LA174Accident · No injuriesLimited investigationFinal reportSmith Aerostar 600 · Wonewoc, WIThe deer on the runway as the airplane was landing.NTSB CHI01LA035Accident · No injuriesLimited investigationFinal reportCessna 177RG · Wautoma, WIthe deer that traveled onto the runway and contacted the airplane. Factors associated with the accident were the night light conditions and the light snow that was falling.NTSB CHI99LA302Accident · No injuriesLimited investigationFinal reportCessna 150K · Kenosha, WIThe pilot's attention being diverted into the cockpit and not maintaining visual separation with the fuel truck. A factor in the accident was the fuel truck.NTSB CHI99LA220Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Sylvania, WIthe misjudged planned approach and the evasive maneuver attempted by the pilot-in-command. A factor was the presence of trees.NTSB CHI99FA208Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-32 · Milwaukee, WIThe vehicle driver's inadvertent application of the accelerator pedal while backing towards the aircraft.NTSB CHI98LA026Accident · No injuriesLimited investigationFinal reportLearjet 35A · Sheboygan, WIa deer that ran in front of the airplane during the takeoff phase. A factor in this accident was the lack of an airport perimeter fence to prevent deer from getting onto the runway.NTSB CHI97TA070Accident · No injuriesFinal reportCessna 172 · Oconto, WIthe failure of the pilot to maintain proper runway alignment and thus clearance with the snow drifts during takeoff. A factor was the distance the snow drifts extended past the runway edge.NTSB CHI96LA354Accident · No injuriesLimited investigationFinal reportCessna 172L · Delavan, WIthe pilot's failure to assure the airplane was properly secured prior to hand-propping the engine.NTSB CHI96LA225Accident · Serious injuriesLimited investigationFinal reportSisk BD-5 · Lake Geneva, WIfailure of the pilot to abort the takeoff, while there was sufficient runway remaining. The high temperature and calm wind were related factors.NTSB CHI96LA078Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Mount Horeb, WIfailure of the pilot to see-and-avoid the pedestrian. Factors relating to the accident were: the pilot's inadequate preflight preparation, his landing on a closed airstrip, and the snow covered terrain.NTSB CHI95LA329Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Hudson, WIthe pilot's improper decision to attempt a touch-and-go on a short airstrip.NTSB CHI95LA238Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Oshkosh, WIthe pilot's failure to maintain clearance.NTSB CHI95LA194Accident · No injuriesLimited investigationFinal reportPiper J-5A · Wausau, WIthe pilot's misjudgment of the clearance between the airplane and the fuel pumps.NTSB CHI93LA294Accident · No injuriesLimited investigationFinal reportNorth American F-51 · Fond Du Lac, WIthe pilot-in-command of the F-51's diverted attention and failure to maintain a visual outlook.NTSB CHI91LA019Accident · No injuriesLimited investigationFinal reportCessna 150 · La Crosse, WIInadequate visual outlook by the PIC.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 CHI89FA154Accident · Minor injuriesField investigationFinal reportRyan PT-22 · Oshkosh, WIThe experimental aircraft association's (eaa's) inadequate procedure for providing control and separation of aircraft, its inadequate surveillance of the operation, and inadequate coordination by ground personnel. Related factors were: the ground personnel's…NTSB CHI89FA153Accident · No injuriesField investigationFinal reportCessna 182Q · Oshkosh, WIThe pilot of Cessna N95914 misjudging the distance necessary to avoid collisions with a the standing Piper N5937W.NTSB CHI88FA179Accident · 1 fatalField investigationFinal reportPiper PA-30 · Oshkosh, WINTSB 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 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 CHI87FA140Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Middleton, WIThe pilot had communicated with other pilots concerning the difficulties he was having with the winds. He had already attempted approaches to two other runways but had failed to complete a landing. He asked the pilot of a recent arrival for the wind…NTSB CHI86FER18Accident · No injuriesFinal reportShanks/Becker Acro Sport · New Richmond, WIAccording to the pilot during landing rollout his left wing encountered three to four foot high grass growing up to the edge of the turf runway. The aircraft then veered off into a ditch. The runway involved is 2100 feet long and 75 feet wide.NTSB CHI86FA199Accident · No injuriesField investigationFinal reportCessna 177 · Oshkosh, WIA spl tfc management program was in effect for an annual eaa fly-in, & a waiver to FAA handbook 7110.65D was in effect which allowed for reduced sepn btn acft opng at wittman fld. As 2 acft were lndg, the plt of the 1st acft (Cessna 177, N17204) was told to…NTSB CHI86FEP05Accident · No injuriesFinal reportBeech C-23 · Milwaukee, WIDuring taxi for takeoff the plt inadvertently taxied onto an access road and struck and unlit sign. The taxiway had been resurfaced and no taxi guide lines had been repainted.NTSB CHI86LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Lake Geneva, WIAfter touchdown & about 600 ft from the approach end of runway 23 the aircraft collided with a moped crossing the runway. The 11 yr old operator of the moped was seriously injured.NTSB CHI86LA005Accident · No injuriesLimited investigationFinal reportTodd Pitts · Hartford, WIN2032 had taken off, remained in the traffic pattern, & landed. N14JK had taken off, obtained a radio check at altitude,descended and entered the traffic pattern. Immediately afterlanding N14JK ran into N2032. N14JK reportedly made two radio calls in the…NTSB CHI85LA230Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Blair, WIThe plt attempted to land the acft in a farm field but was unable to stop before reaching the end of the field. The acft ran through a fence & a ditch before coming to rest. The plt stated that he overshot the rwy, landed long, & was unable to stop the acft…NTSB CHI85LA215Accident · No injuriesLimited investigationFinal reportCessna 152 · Marshfield, WIThe pilot made a precautionary landing in a field. After checking the acft fuel tanks he attempted to takeoff on a gravel road. During the ground run the acft collided with trees & skidded into a field.NTSB CHI85LA081Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wisconsin Rapid, WIThe plt stated that during takeoff into winds form 290 deg at 10 KTS gusting to 15 KTS, the acft began to slide to the left on the icy rwy. When the acft hit a snow bank along the rwy, the nose gear collapsed.NTSB CHI83LA400Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Blair, WIThe acft collided with a fence during an aborted takeoff. The student was on a solo training flt when the accident occurred. This was the first takeoff of the flt. The field was soft and the pilot decided to abort the takeoff during the ground roll. He was…NTSB CHI83LA216Accident · No injuriesLimited investigationFinal reportCessna 150 · Janesville, WIN13364 had stopped short of the runway for a run-up check prior to takeoff. The pilot of N8576J continued his taxi while he was checking the field elevation and setting his altimeter he taxied into the empennage of N13364.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…