NTSB investigations, WI
20 cases where NTSB found Tree(s).
Cases per year
| 2008 | 6 |
|---|---|
| 2010 | 1 |
| 2012 | 1 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 2 |
| 2020 | 1 |
| 2023 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022020'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03022020')) 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 CEN23LA272Accident · Serious injuriesClass 4 · LimitedFinal reportSix Chuter SR7 XL · Chetek, WIThe pilot’s failure to maintain aircraft control during initial climb which resulted in an impact with a pole, trees, and terrain.NTSB CEN20LA329Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Burlington, WIA partial loss of engine power due to the formation of carburetor ice while on the ground, which resulted in reduced climb capability and impact with trees during the initial climb.NTSB CEN19LA045Accident · Serious injuriesLimited investigationFinal reportBrandt Sonex · Lodi, WIThe pilot's failure to maintain proper alignment with the runway during final approach, which resulted in impact with a tree.NTSB GAA18CA490Accident · Serious injuriesData collectionFinal reportCessna 172 · DePere, WIThe pilot’s failure to maintain lateral control and his subsequent failure to maintain the runway heading during an attempted go-around, which resulted in impact with trees.NTSB CEN18LA038Accident · Serious injuriesLimited investigationFinal reportPiper / Laudeman J3C 65 · Palmyra, WIThe pilot’s inadvertent pulling of the fuel shutoff valve, which resulted in a total loss of engine power and a subsequent forced landing into trees. Contributing to the pilot’s inadvertent pulling of the fuel shutoff valve were habit patterns he had…NTSB GAA17CA412Accident · No injuriesData collectionFinal reportMooney M20C · Washington Island, WIThe pilot's failure to maintain a proper approach path, which resulted in impact with trees.NTSB CEN17LA090Accident · No injuriesLimited investigationFinal reportCessna 172B · Prairie Du Sac, WIThe pilot's decision to taxi the airplane from the roadway and his subsequent failure to maintain clearance from signs and a fence after a successful emergency landing following a total loss of engine power.NTSB GAA17CA070Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Stone Lake, WIThe pilot’s failure to maintain lateral control while in a hover and the helicopter’s subsequent impact with a tree.NTSB GAA15CA177Accident · Minor injuriesData collectionFinal reportCentrair 101A · Hartford, WIThe glider pilot's failure to connect the elevator to the elevator control rod during the assembly process, resulting in a loss of control, and a collision with terrain during takeoff.NTSB CEN15LA217Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Neillsville, WIA partial loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN14CA496Accident · No injuriesData collectionFinal reportCessna 172M · Oxford, WIThe pilot did not compensate for the decrease in the crosswind when he descended below the tree line during the landing.NTSB CEN14CA257Accident · Minor injuriesData collectionFinal reportPiper PA 28R-200 · La Pointe, WIThe pilot's failure to maintain control of the airplane during the landing.NTSB CEN12CA596Accident · No injuriesData collectionFinal reportArvold Jordon R CH 750 · Colfax, WIThe pilot did not maintain control of the airplane while landing with a gusty crosswind.NTSB CEN10CA451Accident · No injuriesData collectionFinal reportPiper PA-12 · Wild Rose, WIThe pilot's loss of directional control during the takeoff roll.NTSB CHI08CA287Accident · Minor injuriesData collectionFinal reportCessna 172M · Three Lakes, WIThe pilot's failure to attain sufficient altitude to avoid the trees during initial climb. Contributing to the accident were the pilot's failure to ensure the security of the entrance door before takeoff and the unintentional opening of the door.NTSB CHI08CA233Accident · Minor injuriesData collectionFinal reportErcoupe 415-C · Cedarburg, WIThe pilot not maintaining altitude/clearance from the tree during takeoff. Contributing to the accident were the windshear and the tree.NTSB CHI08CA203Accident · No injuriesData collectionFinal reportEnstrom F28F · Amberg, WIThe unsuitable terrain encountered by the pilot during a forced landing following a loss of engine power due to a cylinder head separation. Contributing to the accident was the tree.NTSB CHI08CA145Accident · No injuriesData collectionFinal reportCessna 150 · New Berlin, WIThe loss of engine power due to the pilot's failure to use the carburetor heat during the flight. Contributing factors included the carburetor icing conditions and the trees.NTSB CHI08CA127Accident · Minor injuriesData collectionFinal reportCessna 140 · Burlington, WIA loss of engine power for undetermined reasons. Contributing to the accident was the low altitude at the time of the loss of engine power.NTSB CHI08CA114Accident · Minor injuriesData collectionFinal reportBardouche Quad City Ultralight · Pulaski, WIThe loss of engine power during cruise due to the separation of the spark plug because of the loose threads. Contributing to the accident was trees.