NTSB investigations, 2013, MN
8 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 4 |
| 2010 | 4 |
| 2011 | 4 |
| 2012 | 7 |
| 2013 | 8 |
| 2014 | 5 |
| 2015 | 4 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 4 |
| 2019 | 3 |
| 2020 | 5 |
| 2021 | 3 |
| 2022 | 6 |
| 2023 | 11 |
| 2024 | 4 |
| 2025 | 7 |
| 2026 | 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 year(c.\"eventDate\") = 2013
AND c.\"eventStateOrRegion\" = 'MN' 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\" = '230' 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 year(c."eventDate") = 2013 AND c."eventStateOrRegion" = 'MN' 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" = '230' 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 CEN13CA559Accident · No injuriesData collectionFinal reportCessna 182Q · Goodhue, MNThe pilot's failure to maintain directional control of the airplane during landing.NTSB CEN13CA526Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Edgerton, MNThe pilot's delay in aborting the landing which resulted in the airplane contacting the terrain off the departure end of the runway.NTSB CEN13CA508Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Faribault, MNThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CEN13CA412Accident · No injuriesData collectionFinal reportUniversal Stinson 108-1 · Hector, MNThe pilot’s inadvertent application of the brakes and failure to main directional control of the airplane during the takeoff roll, which resulted in the airplane nosing over.NTSB CEN13LA374Accident · No injuriesLimited investigationFinal reportAviat A-1B · Ely, MNThe pilot’s failure to maintain control of the amphibious airplane during the water landing.NTSB CEN13CA284Accident · No injuriesData collectionFinal reportStinson 108-1 · Cambridge, MNThe pilot’s loss of directional control while landing with a gusting crosswind.NTSB CEN13CA247Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Owatonna, MNThe pilot’s loss of directional control during an aborted landing.NTSB CEN13CA230Accident · No injuriesData collectionFinal reportWing Harold Kitfox II · Blaine, MNThe pilot's improper touchdown and subsequent failure to maintain control of the airplane during the landing roll. Contributing to the accident was the pilot’s lack of experience in tailwheel-equipped airplanes.