NTSB investigations, WI
13 cases where the defining event was Sys/Comp malf/fail (non-power).
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2018 | 2 |
| 2024 | 1 |
| 2025 | 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '330')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '330') 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 CEN25LA287Accident · No injuriesClass 4 · LimitedFinal reportAerotek Pitts S-2A · New Holstein, WIThe pilot’s loss of direction control during landing due to an unapproved tailwheel assembly and tail spring that resulted in a tailwheel shimmy and a subsequent ground loop.NTSB CEN24LA337Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · East Troy, WIThe pilot/mechanic’s improper torquing of the fuel hose fitting while replacing the fuel pump, which allowed air to enter the fuel system and resulted in a loss of engine power during initial climb. Contributing to the accident was the pilot/mechanic’s…NTSB CEN18LA360Accident · No injuriesLimited investigationFinal reportStearman A75N1(PT17) · Kenosha, WIThe failed retaining bolt and cracked backing plate, which resulted in a shift of the brake lining to contact the brake drum and a subsequent wheel lock when the brakes were applied.NTSB CEN18LA115Accident · No injuriesLimited investigationFinal reportMesserschmitt-Bolkow-Blohm BK 117 B-2 · Sheboygan, WIThe restricted cyclic control movement for reasons that could not be determined because postaccident examination and testing of the cyclic control system did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal…NTSB CEN12CA567Accident · No injuriesData collectionFinal reportFantasy Air Allegro 2000 · Bear Creek, WIA malfunction of the right brake for reasons that could not be determined because of the perishable evidence, which resulted in the pilot’s inability to maintain directional control of the airplane during landing.NTSB CEN12IA498Incident · No injuriesIncident investigationFinal reportAmerican Champion 8KCAB · Oshkosh, WIThe failure of the pilot’s seat bottom frame due to the manufacturer’s improper production, installation, and inspection of that seat bottom, which resulted in a temporary loss of control during an air show performance.NTSB CEN11CA523Accident · No injuriesData collectionFinal reportCessna 195 · Oshkosh, WIThe failure of the left brake which resulted in a ground-loop.NTSB CEN11FA193Accident · No injuriesField investigationFinal reportGulfstream Aerospace GV-SP · Appleton, WIThe pilot flying's (PF) decision to land on a shorter-than-recommended runway with a known left hydraulic system failure rather than go around as suggested by the pilot-not-flying, his failure to immediately apply emergency brakes following the detection of…NTSB CEN09LA463Accident · No injuriesLimited investigationFinal reportPilgrim Samuel W JR RV-6 · Oshkosh, WIThe failure of the rudder pedal which resulted in the pilot's inability to maintain directional control of the aircraft.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 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 CHI08FA172Accident · No injuriesField investigationFinal reportEnstrom Helicopter 480B · Marinette, WIThe pilot inadvertently operating the helicopter at a gross weight greater than its maximum allowable operating weight, and flying the helicopter at an airspeed greater than the never-to-exceed speed for the helicopter’s gross weight condition, resulting in…NTSB CHI08CA076Accident · No injuriesData collectionFinal reportAmerican AA-1A · Grantsburg, WIThe seizure of the left brake due to a buildup of ice between the rotor and brake pad. Contributing to the accident was the snow and slush covered runway, and the snowbank.