NTSB investigations, WI
16 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1986 | 1 |
|---|---|
| 1989 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2002 | 1 |
| 2004 | 2 |
| 2005 | 2 |
| 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\" = 320)
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" = 320) 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 CHI07CA055Accident · No injuriesData collectionFinal reportCessna 150M · Bristol, WIThe pilot's selection of unsuitable terrain to taxi on for takeoff. A factor was the soft terrain condition.NTSB CHI07CA049Accident · No injuriesData collectionFinal reportBeech 99 · Mosinee, WIThe pilot encountering the unsuitable terrain during the landing. Factors were the dark night and the snowbank.NTSB CHI06CA259Accident · No injuriesData collectionFinal reportLuscombe 8E · Dodgeville, WIThe pilot encountering unsuitable terrain during the precautionary landing. A factor was the ditch the pilot encountered.NTSB CHI06CA052Accident · No injuriesData collectionFinal reportCessna 152 · Pelican Lake, WIThe pilot selecting an unsuitable landing area. Factors were the snow and ice covered lake.NTSB CHI06CA056Accident · Minor injuriesData collectionFinal reportChampion 7EC · Platteville, WIThe student pilot not maintaining directional control during the landing. A factor was the snow bank the pilot encountered.NTSB CHI04CA219Accident · No injuriesData collectionFinal reportLake LA4-200 · Oshkosh, WIThe unsuitable rough water conditions encountered during the attempted water takeoff.NTSB CHI04LA075Accident · No injuriesLimited investigationFinal reportCessna 120 · Merrill, WIThe pilot's selection of unsuitable terrain to conduct a landing. Factors were the reported flat light conditions and the uneven terrain.NTSB CHI02TA149Accident · No injuriesFinal reportCessna A185F · Necedah, WIDirectional control of the airplane not maintained by the pilot. The gusting winds was a contributing factor.NTSB CHI00LA213Accident · No injuriesLimited investigationFinal reportCessna 120 · Shawano, WIInadequate preflight planning and the pilot's delay in aborting the takeoff. A factor was the road embankment.NTSB CHI99LA294Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Johnson Creek, WIthe pilot's failure to maintain directional control of the airplane.NTSB CHI99FA263Accident · No injuriesField investigationFinal reportUnderwood Brokaw Bullet · Oshkosh, WIthe pilot failed to maintain directional control of the airplane.NTSB CHI98LA357Accident · No injuriesLimited investigationFinal reportCessna 182K · Baldwin, WIThe pilot's inadequate preflight planning and preparation, and his failure to stop on the wet, grassy runway. A related factor was the wet grass.NTSB CHI96LA337Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Wausau, WIthe pilot's selection of an unsuitable landing area, and his misjudgment of distance and speed, while attempting to minimize the effect of crossing an uneven area on the runway. The uneven runway condition was a related factor.NTSB CHI91LA141Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Evansville, WIThe pilot's selection of unsuitable terrain for landing, not maintaining directional control and attempting a go-around without sufficient airspeed. A factor was the rutted runway surface.NTSB CHI89LA091Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Ojibwa, WIImproper planning/decision by the pilot and his delay in aborting the takeoff. Contributing factors were: the wet/upward sloping condition of the airstrip, unfavorable wind, high obstructions (tall trees/obstacles at the end of the runway), and high…NTSB CHI86LA167Accident · Minor injuriesLimited investigationFinal reportCessna A152 · Middleton, WIThe student pilot stated that he was practicing soft field takeoffs on a grass strip. He aborted his first attempt to make an intersection takeoff. On his second try, he thought he could get airborne, but did not. The aircraft struck an embankment near the…