NTSB investigations, NE
22 cases where the sequence of events included Runway excursion.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 1 |
| 2020 | 2 |
| 2022 | 2 |
| 2024 | 4 |
| 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\" = 'NE' 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\" = '300' 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" = 'NE' 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" = '300' 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 CEN25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Lincoln, NEA failure of the flight crew to ensure that the landing gear was properly extended before landing.NTSB CEN24LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Lincoln, NEThe student pilot’s failure to maintain directional control during landing.NTSB CEN24LA293Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Lincoln, NEThe pilot’s failure to maintain directional control during the landing roll with a crosswind.NTSB CEN24LA274Accident · No injuriesClass 4 · LimitedFinal reportCessna A188 · David City, NEThe pilot’s failure to maintain directional control during takeoff.NTSB CEN24LA187Accident · Serious injuriesClass 4 · LimitedFinal reportAviat A1 · Poole, NEThe non-certificated pilot’s failure to configure the airplane for takeoff, which resulted in a runway excursion.NTSB CEN22LA132Accident · No injuriesClass 3 · LimitedFinal reportMooney M20C · Crete, NEThe pilot’s failure to maintain control of the airplane during takeoff.NTSB CEN22LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Wahoo, NEThe pilot’s failure to maintain directional control during the landing.NTSB CEN21LA097Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Albion, NEThe pilot’s failure to maintain directional control during the landing with a tailwind.NTSB CEN20CA137Accident · No injuriesData collectionFinal reportPiper PA-28-235C · Omaha, NEThe student pilot’s improper landing flare, which resulted in a bounced landing, subsequent loss of directional control, and the airplane going down an embankment.NTSB GAA18CA167Accident · No injuriesData collectionFinal reportBeech C99 · Hastings, NEThe pilot's decision to land in a gusty crosswind that exceeded the airplane's maximum demonstrated crosswind and resulted in a runway excursion.NTSB GAA17CA508Accident · No injuriesData collectionFinal reportCessna 182 · North Platte, NEThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA482Accident · No injuriesData collectionFinal reportCessna 172 · Kearney, NEThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion.NTSB GAA17CA403Accident · No injuriesData collectionFinal reportLuscombe 8 · Grand Island, NEThe student pilot’s failure to maintain directional control during the takeoff roll and the flight instructor’s delayed remedial action.NTSB GAA16CA105Accident · No injuriesData collectionFinal reportEngineering & Research Ercoupe 415 · Chappell, NEThe pilot's inability to correct for a crosswind during the takeoff roll due to the interlinked flight control design, which resulted in a runway excursion, and a collision with terrain.NTSB GAA16CA063Accident · No injuriesData collectionFinal reportCessna 182D · Hamlet, NEThe student pilot's incorrect brake application which resulted in a runway excursion and a nose over.NTSB CEN14CA236Accident · No injuriesData collectionFinal reportMorris Thomas Lee Stolp Strdstr SA300 · Lincoln, NEThe pilot's loss of directional control while landing in gusty crosswinds in a tail wheel equipped airplane.NTSB CEN12CA148Accident · No injuriesData collectionFinal reportPiper PA-18 · Thedford, NEThe pilot did not maintain directional control during landing, which resulted in a runway excursion.NTSB CEN12CA029Accident · Minor injuriesData collectionFinal reportHunt Sparrowhawk · Blair, NEThe pilot/builder’s inadequate installation of a nosewheel steering component, which resulted in a shimmy and a loss of directional control during the takeoff roll.NTSB CEN10CA544Accident · No injuriesData collectionFinal reportPiper PA22 · Atkinson, NEThe pilot's failure to maintain directional control while landing with a crosswind.NTSB CEN09LA542Accident · No injuriesLimited investigationFinal reportCessna 182 · Weeping Water, NEThe pilots' improper execution of soft/short field take-off procedures.NTSB CEN09CA050Accident · No injuriesData collectionFinal reportAeronca 7CCM · Chadron, NEThe pilot's failure to maintain direction control of the airplane. Contributing to the accident was the pilot's lack of experience.NTSB DFW08CA189Accident · No injuriesData collectionFinal reportStinson 108-1 · Alliance, NEThe pilot's failure to maintain directional control on takeoff. Contributing to the accident was a lack of total experience.