NTSB investigations, WI
6 cases where the sequence of events included Ground collision.
Cases per year
| 2020 | 1 |
|---|---|
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '200' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '200' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN25LA293Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31T3 · Appleton, WIThe pilot’s failure to maintain control of the airplane on the ground, which resulted in a collision with a parked airplane.NTSB CEN24LA294Incident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Appleton, WIThe pilot’s failure to maintain adequate wingtip clearance while taxiing. Contributing to the accident was the ambiguous nonstandard parking at the time of the incident.NTSB CEN23LA209Accident · No injuriesClass 4 · LimitedFinal reportKolb Firestar SS · Lodi, WIThe pilot’s failure to maintain control during takeoff.NTSB CEN22LA346Accident · No injuriesClass 4 · LimitedFinal reportMeschler Gary R RV-4 · Oshkosh, WIThe failure of the pilot of N694V (RV-8) to maintain clearance from the preceding airplane, N79KM (RV-4), while taxiing for takeoff, which resulted in an on-ground collision.NTSB CEN21LA336Accident · No injuriesClass 3 · LimitedFinal reportDriver RV-7 · Oshkosh, WIThe RV-8 pilot’s failure to account for the position of the RV-7 behind him during the landing roll in a staggered landing formation, which resulted in a ground collision of the two airplanes. Contributing to the accident was the self-induced pressure created…NTSB CEN20LA436Accident · No injuriesClass 4 · LimitedFinal reportPiper J3 · Hartford, WIThe pilot’s loss of situation awareness which resulted in landing in a grass area and the subsequent collision with a runway marker.