NTSB investigations, AR
14 cases where the defining event was Runway excursion.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2021 | 1 |
| 2022 | 3 |
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\" = 'AR' 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\" = '300')
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" = 'AR' 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" = '300') 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 CEN23LA056Accident · Minor injuriesClass 3 · LimitedFinal reportLearjet 45 · Batesville, ARThe crew’s failure to execute a go-around during the unstable approach and long landing, which resulted in a runway excursion.NTSB CEN22LA364Accident · No injuriesClass 4 · LimitedFinal reportBeechcraft 35 · Star City, ARThe pilot’s delayed decision to abort the takeoff, which resulted in a runway excursion and impact with a ditch.NTSB CEN22LA235Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Nashville, ARThe pilot was not able to stop the airplane on a wet runway due to hydroplaning.NTSB CEN22LA024Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150L · Forrest City, ARThe pilot’s loss of control during landing. Contributing to the pilot’s injuries was his ejection from the airplane resulting from him not wearing his available seat restraints.NTSB GAA16CA367Accident · No injuriesData collectionFinal reportCessna 182 · Searcy, ARThe pilot landed long and failed to stop before the end of the runway, which resulted in a runway overrun and impact with trees. Contributing to the accident was the pilot's failure to maintain a stabilized approach.NTSB GAA15CA114Accident · No injuriesData collectionFinal reportPiper PA 16 · Tollville, ARThe pilot's failure to maintain directional control during the landing flare, which resulted in the airplane impacting a rice field and nosing over.NTSB CEN13CA549Accident · No injuriesData collectionFinal reportJabiru USA Sport J230-SP · Conway, ARThe pilot's failure to attain the proper landing approach speed and touchdown point, which resulted in a runway excursion after touchdown and collision with a blast fence.NTSB CEN13LA237Accident · 1 fatalLimited investigationFinal reportAlon A2 · Greenbrier, ARThe pilot's improper recovery from a bounced landing and porpoise. Contributing to the accident were the pilot's limited recent flying experience and proficiency and the challenging runway environment.NTSB CEN12CA447Accident · No injuriesData collectionFinal reportCessna 177B · Lakeview, ARThe pilot's delay in aborting the takeoff, which resulted in a runway excursion.NTSB CEN11CA668Accident · No injuriesData collectionFinal reportCessna R172K · Jonesboro, ARThe pilot's failure to maintain directional control of the airplane while taxiing.NTSB CEN10CA377Accident · No injuriesData collectionFinal reportAero Commander 100 · Jacksonville, ARThe pilot's failure to maintain an appropriate approach speed and his delayed decision not to initiate a go-around. Contributing to the accident was the pilot's lack of experience in the airplane type.NTSB CEN10CA436Accident · Minor injuriesData collectionFinal reportCessna 310C · Ashdown, ARThe pilot’s loss of directional control during the takeoff roll and his lack of experience in the airplane.NTSB CEN10CA265Accident · No injuriesData collectionFinal reportAyres S2R-R1340 · Roe, ARThe pilot's decision to take off with a tailwind, resulting in a runway overrun.NTSB CEN09CA102Accident · Serious injuriesData collectionFinal reportBeech 95-B55 · Batesville, ARThe pilot's improper decision to land with a tailwind which resulted in the overrun landing. Factors contributing to the accident include the culvert and the tailwind.