NTSB investigations, WI
22 cases where the defining event was Hard landing.
Cases per year
| 2009 | 4 |
|---|---|
| 2010 | 1 |
| 2012 | 2 |
| 2015 | 2 |
| 2016 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 3 |
| 2025 | 2 |
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\" = '092')
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" = '092') 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 CEN26LA047Accident · No injuriesClass 4 · LimitedFinal reportEngineering & Research 415 · Sheboygan Falls, WIThe flight instructor’s failure to arrest the airplane’s descent rate during a takeoff simulated engine failure which resulted in a hard landing.NTSB CEN25LA404Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR20 · Watertown, WIThe flight instructor’s failure to maintain control of the airplane following the student pilot’s bounced landing. Contributing to the accident was the flight instructor’s delayed remedial action which resulted in diminished airplane performance during the…NTSB CEN24LA322Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Chetek, WIThe pilot’s improper landing flare and hard landing.NTSB WPR24LA256Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Oshkosh, WIThe pilot’s failure to maintain control during an approach to land, which resulted in a hard landing.NTSB CEN24LA282Accident · No injuriesClass 3 · LimitedFinal reportJust Highlander · Oshkosh, WIThe reported uncommanded retraction of the flaps while on short final for unknown reasons, which resulted in a hard landing.NTSB CEN23LA430Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · West Bend, WIThe pilot’s inadequate landing flare that resulted in a hard landing and impact with the runway.NTSB CEN23LA323Accident · No injuriesClass 4 · LimitedFinal reportVans RV-10 · Oshkosh, WIThe pilot’s improper landing flare which resulted in a hard landing.NTSB CEN23LA229Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Salem, WIThe pilot’s improper landing flare, which resulted in a hard landing and the left main landing gear collapse.NTSB CEN22LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna T310R · Oshkosh, WIThe pilot’s loss of control while landing.NTSB CEN20CA257Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Reedsburg, WIThe student pilot's improper landing flare, which resulted a hard, bounced landing.NTSB CEN19CA227Accident · No injuriesData collectionFinal reportVans RV-8 · Oshkosh, WIThe pilot’s failure to maintain adequate spacing from the lead airplane while landing following revised landing instructions, which necessitated that the pilot conduct an improper landing flare and resulted in a hard landing.NTSB CEN16CA258Accident · No injuriesData collectionFinal reportBoyd Kenneth C Rans S-19 · Ephraim, WIThe pilot's decision to continue the landing from an unstabilized approach which resulted in a loss of control and subsequent hard landing.NTSB CEN16LA206Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Clintonville, WIThe pilot’s failure to maintain the proper glidepath during the night visual approach, which resulted in impact with a runway threshold light, and his improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot's…NTSB GAA15CA287Accident · No injuriesData collectionFinal reportPiper PA 24 · West Bend, WIThe pilot's failure to maintain his descent rate during the landing, which resulted in a hard landing and runway excursion.NTSB GAA15CA180Accident · No injuriesData collectionFinal reportPietenpol AIR Camper · Burlington, WIThe student pilot's failure to maintain pitch control during the landing touchdown, resulting in a hard landing.NTSB CEN12LA573Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Belgium, WIThe pilot’s failure to maintain control of the helicopter while landing in gusting wind conditions, which resulted in a hard landing.NTSB CEN12LA591Accident · Serious injuriesLimited investigationFinal reportArbc Inc DBA Lindstrand 180A · Prairie du Sac, WIThe pilot's loss of control of the balloon during a landing in higher-than-expected wind conditions, which resulted in a hard landing.NTSB CEN10CA344Accident · Serious injuriesData collectionFinal reportAir Creation GTE · Neenah, WIThe pilot's improper landing flare that resulted in a hard landing.NTSB CEN09CA478Accident · Minor injuriesData collectionFinal reportP&M Quik GT450 · Oshkosh, WIThe pilot's improper flare and improper recovery from a bounced landing.NTSB CEN09LA424Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Racine, WIThe pilot's improper landing flare that resulted in a hard landing and subsequent separation of the airplane's sponson.NTSB CEN09CA397Accident · No injuriesData collectionFinal reportWeatherhead Peter L Stol CH 701 · Hayward, WIThe pilot's improper flare resulting in a hard landing during gusty wind conditions. Contributing to the accident was the pilot's lack of experience with the accident airplane.NTSB CEN09CA358Accident · Serious injuriesData collectionFinal reportAerostar International RX-9 · Marathon City, WIA hard landing as a result of unexpected high winds and gusts.