NTSB investigations, WI
105 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 7 |
| 1984 | 9 |
| 1985 | 2 |
| 1986 | 6 |
| 1987 | 5 |
| 1988 | 4 |
| 1989 | 4 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 4 |
| 1998 | 7 |
| 1999 | 4 |
| 2000 | 1 |
| 2001 | 7 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 5 |
| 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\" = 220)
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" = 220) 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 CHI06CA246Accident · No injuriesData collectionFinal reportAviat A-1B · Minocqua, WIThe inadvertent collision with power lines. A factor associated with the accident was the water which blended in with the power lines resulting in the pilot's inability to see them prior to contact.NTSB CHI06CA171Accident · Serious injuriesData collectionFinal reportCroke Zenith CH 701 · Brussels, WIThe pilot not maintaining clearance from the trees during final approach. The trees located along the final approach course were a factor in the accident.NTSB CHI06CA172Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Minong, WIRestriction of the elevator control system due to the camera placed in the seat back pocket and the inadvertent stall/mush condition encountered during the go-around. The trees impacted after the stall were a contributing factor.NTSB CHI06LA163Accident · 1 fatalLimited investigationFinal reportVarga 2150A · Columbus, WIThe pilot's failure to maintain adequate clearance from the trees during the attempted low altitude pass along the river. Contributing factors were the intentional low altitude flight maneuver, the pilot's improper decision to attempt that maneuver, and his…NTSB CHI06CA166Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Walworth, WIThe pilot's delay in initiating a go-around and the resulting failure to maintain clearance to the vehicle on the adjacent roadway. The short length of the runway selected by the pilot and the vehicle were contributing factors.NTSB CHI05FA274Accident · 3 fatalField investigationFinal reportRobinson R44 · Drummond, WIClearance not obtained/maintained by the pilot during an unknown phase of flight. Contributing factors were the improper use of procedures by the pilot, the inadequate surveillance of the operation by company/management, and the wire.NTSB CHI05LA130Accident · Minor injuriesLimited investigationFinal reportPilatus PC-6 · Sturtevant, WIFailure of the jump plane pilot to maintain clearance from the parachutist descent area/drop zone until assured that all jumpers had landed, and the parachutist's failure to maintain an adequate visual lookout for the jump plane during all phases of the jump.…NTSB CHI05LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Waunakee, WIThe pilot's inadequate preflight planning and the delay in aborting the landing which resulted in the subsequent insufficient airspeed. Factors associated with the accident were the night light conditions, the fence, and the pole which the airplane contacted.NTSB CHI04LA243Accident · 1 fatalLimited investigationFinal reportBoeing A75 · Wisconsin Rapid, WIThe pilot's improper in-flight decision when he decided to fly at a low altitude over the river and failed to maintain clearance from the power lines. A factor was the wires.NTSB CHI04FA214Accident · 2 fatalField investigationFinal reportEurocopter France EC130 B4 · Prairie du Sac, WIThe pilot's intentional low-level flight toward the lake and his failure to maintain clearance from the static wire on power transmission lines. Contributing factors were the separation of the Fenestron (tail rotor) assembly from the tail boom as a result of…NTSB CHI04LA079Accident · No injuriesLimited investigationFinal reportRobinson R44 · Burlington, WIThe pilot's inadequate visual lookout and his failure to obtain/maintain clearance from the transmission wire during the takeoff. Factors contributing to the accident were the transmission wire and the pole.NTSB CHI03LA173Accident · Serious injuriesLimited investigationFinal reportAerostar S-55A · Monroe, WIThe pilot's failure to maintain clearance from the transmission wires during landing and his decision to jump from the balloon. A factor to the accident was the power transmission lines.NTSB CHI03FA018Accident · 2 fatalField investigationFinal reportPiper PA-24 · Fond du Lac, WIThe pilot failed to maintain obstacle clearance from the power lines while on a night VFR approach. Factors to the accident included the dark night and the power lines.NTSB CHI02LA290Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Chetek, WIThe pilot's failure to maintain directional control of the airplane, and his failure to maintain clearance from the utility pole. A factor was the utility pole.NTSB CHI02LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA22-135 · Lyons, WIFailure of the pilot to maintain a sufficient rate-of-climb and to obtain a safe altitude/clearance from the tree line at end of the runway. Contributing factors were the uphill runway gradient and the trees.NTSB CHI02LA146Accident · No injuriesLimited investigationFinal reportCessna 182J · Galesville, WIThe pilot failed to maintain clearance with the wires while on final approach. Factors associated with the accident were the low altitude, the downdraft, and the wires which the airplane contacted.NTSB CHI02FA049Accident · 1 fatalField investigationFinal reportRobinson R44 · Waukesha, WIThe pilot's continued flight into adverse weather and not maintaining altitude/clearance from the static line during cruise flight. Factors were the static wire, the darkness of night, the low ceiling, and the vehicle.NTSB CHI01LA288Accident · No injuriesLimited investigationFinal reportCessna 188 · Almond, WIthe pilot failed to maintain clearance from the corn crop. Additional factors were the inoperative spray pump, the corn crop, and the pilot's diverted attention.NTSB CHI01LA243Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Wheeler, WIThe pilot not maintaining altitude/clearance from the power transmission line. A factor to the accident was the power transmission line.NTSB CHI01FA218Accident · 1 fatalField investigationFinal reportCessna 310R · Oak Creek, WIThe pilot not maintaining clearance from objects during an ILS approach in low night IFR conditions and his descent below decision height. Factors were the dark night, mist, low ceiling, and the trees west of the approach.NTSB CHI01LA200Accident · No injuriesLimited investigationFinal reportCessna 175 · Tomahawk, WIThe inadequate preflight preparation that did not include calculating the density altitude and the pilot not maintaining clearance from the second row of trees on initial climb. Factors include those trees and the high density altitude present at the time of…NTSB CHI01LA171Accident · No injuriesLimited investigationFinal reportLarson Murphy Rebel · Stratford, WIThe pilot's failure to abort the takeoff from the farm field. Factors were the tall grass, the rising terrain, the fence, and the inadequate planning/decision by the pilot.NTSB CHI01FA089Accident · 4 fatalField investigationFinal reportPiper PA-28R-201 · Webb Lake, WIthe pilot not maintaining altitude/clearance from the trees during takeoff. Factors were the trees, transmission wire, and the dark night.NTSB CHI00FA284Accident · 2 fatalField investigationFinal reportBeech K35 · Manitowish Watr, WIthe pilot not maintaining altitude/clearance from the trees during an approach on a dark, low overcast night, the pilot's improper use of an IFR procedure without clearance, and the pilot's improper in-flight decision to attempt an IFR approach without…NTSB CHI00LA021Accident · No injuriesLimited investigationFinal reportCessna 172N · Crandon, WIthe deer that ran out onto the runway and collided with the airplane. A factor associated with the accident was the night lighting conditions.NTSB CHI99LA248Accident · No injuriesLimited investigationFinal reportRobinson R22 · Spring Green, WIthe pilots failure to maintain clearance with the wire. A factor was the wire.NTSB CHI99FA222Accident · 1 fatalField investigationFinal reportCessna 182E · Menominee Falls, WIthe pilots failure to maintain adequate clearance. A factor was the static wire.NTSB CHI99LA085Accident · No injuriesLimited investigationFinal reportBeech 1900D · Milwaukee, WIthe in-flight collision with a bird.NTSB CHI99FA042Accident · 2 fatalField investigationFinal reportCessna 172F · Coleman, WIpilot's failure to maintain clearance from the trees and his intentional flight into IMC conditions. Factors contributing to this accident were the pilot's lack of instrument certification, his becoming lost in the poor weather, his inadequate preparation for…NTSB CHI98LA314Accident · No injuriesLimited investigationFinal reportValentin Taifun 17E · Lake Geneva, WIthe pilot's failure to maintain directional control and obtain proper climb rate during initial climb after takeoff. A factor was trees.NTSB CHI98FA344Accident · 2 fatalField investigationFinal reportCessna A185F · Phillips, WIThe pilot's failure to maintain adequate altitude/clearance with trees. Contributing factors were fog, rain showers, and the trees.NTSB CHI98FA288Accident · 1 fatalField investigationFinal reportHispano Aviacion A10B-37 · Oshkosh, WIthe pilot's failure to maintain adequate altitude which resulted in in-flight collision with trees and subsequent compressor stall for undetermined reasons.NTSB CHI98FA287Accident · 1 fatalField investigationFinal reportNavion A · Coloma, WIFailure of the pilot to maintain proper altitude, and his failure to maintain adequate visual lookout to see and avoid obstructions. The transmission wire was a contributing factor.NTSB CHI98LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · Eagle River, WIthe pilot failed to compensate for the wind conditions, improperly executed a go-around when he raised the flaps, and failed to maintain obstacle clearance with the trees.NTSB CHI98FA123Accident · 1 fatalField investigationFinal reportCessna 180J · Ashland, WIthe pilot failing to maintain separation from the trees. Factors contributing to this accident were the trees and the pilot being too low in altitude.NTSB CHI98LA061Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Sturtevant, WIThe pilot's misjudgment of altitude/distance and her failure to maintain adequate visual lookout. Also causal was the pilot's failure to maintain adequate obstacle clearance. A contributing factor was the pilot experiencing a visual illusion.NTSB CHI97LA263Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Burlington, WIthe deer which contacted the airplane.NTSB CHI97LA251Accident · Serious injuriesLimited investigationFinal reportLarsen T-BIRD II · Oshkosh, WIthe pilot's failure to maintain flying speed and loss of control resulting in a stall. Factors were the tree and the fence.NTSB CHI97LA230Accident · Minor injuriesLimited investigationFinal reportJenkins RV-6 · Middleton, WIthe pilot was too low on final approach and hit the high vegetation.NTSB CHI97LA005Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Neenah, WIthe local terrain conditions around the airport. A factor was the inadequate runway safety area.NTSB CHI96LA288Accident · No injuriesLimited investigationFinal reportBeech 23 · Wilmot, WIimproper planning/decision by the flight instructor (CFI) by failing to ensure that the airplane would be able to clear brush and trees near the departure end of the runway.NTSB CHI96LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Camp Lake, WIFailure of the pilot to maintain clearance from trees that were located beside the runway.NTSB CHI95LA324Accident · No injuriesLimited investigationFinal reportCessna 177 · Camp Lake, WIthe pilot's inadequate compensation for wind conditions, and failure to maintain altitude/clearance from the power line, while on short final approach. The downdraft was a related factor.NTSB CHI95LA141Accident · Minor injuriesLimited investigationFinal reportSorrel SNS-4 · Menomonee Falls, WIthe pilot's failure to maintain clearance with transmission wires. A factor in the accident was the transmission wires.NTSB CHI95LA033Accident · No injuriesLimited investigationFinal reportCessna 150 · Tomahawk, WIthe collision with deer during landing - flare/touchdown.NTSB CHI94LA317Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Princeton, WIthe pilot's premature liftoff.NTSB CHI94LA179Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lodi, WIthe pilot's failure to maintain direction control which resulted from a inadequate compensation for the crosswind conditions. Factors related to the accident were the pilot's diverted attention, the crosswind, the trees which were contacted.NTSB CHI94LA158Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Montello, WIthe pilot's inadequate compensation for the wind conditions. A factor related to the accident was the crosswind.NTSB CHI94FA010Accident · 2 fatalField investigationFinal reportCessna R182 · Herbster, WIFailure of the pilot to maintain clearance from trees.