NTSB investigations, WI
25 cases where NTSB found Landing flare.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 5 |
| 2010 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2023 | 3 |
| 2024 | 4 |
| 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062041'))
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", '01062041')) 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 CEN25LA279Accident · No injuriesClass 4 · LimitedFinal reportDyke Delta JD-2 · Oshkosh, WIThe pilot’s failure to maintain control of the airplane while landing with a tailwind.NTSB CEN25LA204Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Pembine, WIThe pilot’s improper flare during landing which resulted in a bounced landing.NTSB CEN24LA379Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Janesville, WIThe student pilot’s improper flare and the flight instructor’s delayed remedial action that resulted in a hard, bounced landing.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 CEN21LA398Accident · No injuriesClass 4 · LimitedFinal reportSegarra Lucas JR Zenith Stoll 701 · Grantsburg, WIThe pilot’s improper landing flare, which resulted in abnormal runway contact and the nose landing gear collapsing.NTSB WPR20CA208Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20E · Neenah, WIThe pilot's improper landing flare, which resulted in a bounced, hard landing and subsequent runway overrun.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 GAA17CA420Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2008 · Lone Rock, WIThe student pilot’s improper landing flare, which resulted in a bounced landing and subsequent loss of directional control and runway excursion during the aborted landing. Contributing to the improper landing flare was the student’s distraction by a deer…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 GAA15CA290Accident · No injuriesData collectionFinal reportCessna 172M · Shiocton, WIThe pilot's decision to continue to land at an unlighted airstrip, at night, after the landing light failed on approach, which resulted in a bounced landing, runway excursion, and collision with terrain.NTSB CEN10CA578Accident · No injuriesData collectionFinal reportCessna 172B · Oconomowoc, WIThe pilot's selection of unsuitable terrain for landing the float-equipped airplane on a turf runway.NTSB CEN10CA344Accident · Serious injuriesData collectionFinal reportAir Creation GTE · Neenah, WIThe pilot's improper landing flare that resulted in a hard landing.NTSB CEN10CA038Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Three Lakes, WIThe pilot's improper flare and touchdown during the water landing.NTSB CEN09CA478Accident · Minor injuriesData collectionFinal reportP&M Quik GT450 · Oshkosh, WIThe pilot's improper flare and improper recovery from a bounced landing.NTSB CEN09CA472Accident · No injuriesData collectionFinal reportFisher RV-7A · Brodhead, WIThe pilot's improper landing flare and 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 CHI08LA214Accident · Minor injuriesLimited investigationFinal reportBolenbaugh Phillip William Rans S-6ES · Oshkosh, WIThe pilot's improper landing flare, which resulted in a hard landing and subsequent collapse of the nose landing gear.NTSB CHI08CA192Accident · Minor injuriesData collectionFinal reportBell 47G-3B · Port Edwards, WIThe pilot failed to maintain control of the helicopter when he inadvertently flared the helicopter and the rotor rpm decayed as a result of sustaining bee stings during an aerial application flight. Contributing to the accidnet included the bees and the low…