NTSB investigations, IN
38 cases where the sequence of events included Runway excursion.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 4 |
| 2010 | 4 |
| 2011 | 5 |
| 2012 | 4 |
| 2013 | 3 |
| 2016 | 2 |
| 2017 | 4 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 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\" = 'IN' 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" = 'IN' 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 CEN27LA010Accident · No injuriesClass 4 · LimitedInvestigation openMooney M20F · Anderson, INNTSB CEN25LA254Accident · No injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Russellville, INThe pilot’s failure to establish and maintain the airstrip centerline during takeoff, which resulted in the airplane’s right wingtips contacting the corn that bordered the airstrip.NTSB CEN24LA309Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Salem, INThe pilot’s excessive airspeed during a landing, which resulted in a runway overrun and collision with terrain.NTSB CEN24LA032Accident · Minor injuriesClass 4 · LimitedFinal reportTom Hodgson 29 · Kokomo, INThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN23LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 150D · New Haven, INThe pilot’s loss of directional control while landing, which resulted in a runway excursion, impact with corn stalks, and subsequent nose over.NTSB CEN23LA429Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Muncie, INA loss of directional control during the landing roll due to the left wheel seizing from insufficient grease in the left wheel bearing.NTSB CEN22LA095Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Washington, INThe pilot’s failure to maintain directional control while landing in gusty crosswind conditions which resulted in a runway excursion.NTSB CEN21LA279Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Portland, INThe airplane’s collision with a deer on the runway during landing.NTSB CEN20CA112Accident · No injuriesData collectionFinal reportCessna 172 · Madison, INThe flight instructor's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and nose-over.NTSB GAA19CA330Accident · No injuriesData collectionFinal reportDiamond DA20 · Terre Haute, INThe student pilot's failure to maintain the runway heading and to relinquish the flight controls to the flight instructor when told to do so while landing in gusting, crosswind conditions, which resulted in a runway excursion and impact with runway lighting.NTSB CEN19LA090Accident · No injuriesClass 2 · LimitedFinal reportBeech 400 · Richmond, INThe flight crew's decision to continue an unstable approach under conditions that exceeded the airplane's landing performance capabilities, which resulted in a runway overrun and impact with terrain.NTSB CEN18LA062Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 525A · Michigan City, INThe flight crew's improper decision to land on a snow-covered runway that had insufficient runway distance for the airplane to land with the contamination, which resulted in a runway overrun and impact with obstacles.NTSB GAA17CA336Accident · No injuriesData collectionFinal reportPiper PA 28 · Auburn, INThe pilot’s decision to continue to attempt to take off despite the airplane’s inability to attain a positive climb rate, which resulted in little runway remaining, and his subsequent decision to turn off the runway, which resulted in a collision with a barn.NTSB GAA17CA153Accident · No injuriesData collectionFinal reportStinson 108 · Valparaiso, INThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN17LA082Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Hobart, INThe pilot's failure to abort the landing when he recognized the airplane was traveling too fast, which resulted in impact with trees off the end of the runway.NTSB CEN17LA029Accident · No injuriesLimited investigationFinal reportBeech 100 · Jeffersonville, INThe pilot’s inadequate preflight planning, his decision to take off knowing the airplane was over its gross takeoff weight, and his failure to abort the takeoff after he realized that the airplane was not accelerating as expected, which resulted in a runway…NTSB GAA17CA021Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Huntingburg, INThe pilot’s delayed crosswind correction during the landing roll with a gusting left crosswind, which resulted in the airplane weathervaning and nosing over.NTSB CEN13CA515Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA-1B · Valparaiso, INThe pilot's improper recovery from a bounced landing.NTSB CEN13IA177Incident · No injuriesIncident investigationFinal reportTTX Air Lancair · Indianapolis, INThe pilots' failure to verify landing gear extension before landing.NTSB CEN13CA144Accident · No injuriesData collectionFinal reportMooney M20J · Warsaw, INThe pilot's improper recovery from a bounced landing and failure to maintain control of the airplane during a go-around maneuver. Contributing to the accident were the pilot’s complacency flying the airplane and his lack of training on bounced landing…NTSB CEN12LA649Accident · No injuriesLimited investigationFinal reportBeechcraft A23-24 · Tell City, INThe pilot’s improper touchdown point during landing and the resultant runway excursion during the aborted landing.NTSB CEN12LA494Accident · No injuriesLimited investigationFinal reportLee Oscar D III RV7 · Columbus, INThe failure of the right main landing gear attach bolt for undetermined reasons because the bolt was not received for examination.NTSB CEN12CA355Accident · Minor injuriesData collectionFinal reportRyan Navion · Rockville, INThe pilot’s failure to attain the proper touchdown point during landing, which resulted in a runway overrun.NTSB CEN12LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Indianapolis, INThe student pilot did not maintain directional control while practicing a soft-field takeoff.NTSB CEN12CA062Accident · Minor injuriesData collectionFinal reportBeech 58 · Connersville, INThe pilot's failure to maintain directional control of the airplane during landing.NTSB CEN12CA038Accident · No injuriesData collectionFinal reportPipistrel Sinus 912 · Indianapolis, INThe pilot's failure to maintain directional control of the motor-glider while landing in gusty wind conditions.NTSB CEN11LA614Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Valparaiso, INThe pilot’s loss of directional control during landing. Contributing to the accident was the wear in the tailwheel assembly.NTSB CEN11LA265Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 10 · Sellersburg, INThe pilot's failure to maintain control of the airplane during landing in strong and gusty wind conditions.NTSB CEN11LA219Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Delphi, INThe pilot's loss of directional control, resulting in a runway excursion, and the subsequent separation of the left main landing gear for undetermined reasons.NTSB CEN10CA518Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Anderson, INThe pilot’s failure to abort the takeoff due to degraded airplane performance.NTSB CEN10CA301Accident · No injuriesData collectionFinal reportCessna 421B · Anderson, INThe pilot’s failure to establish proper rotation and liftoff speed during the takeoff roll.NTSB CEN10CA147Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Martinsville, INThe pilot's inadequate preflight planning and his exceedance of the airplane's takeoff capability.NTSB CEN10CA118Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Connersville, INThe pilot's failure to maintain directional control while landing on an ice- and slush-covered runway.NTSB CEN10CA062Accident · No injuriesData collectionFinal reportCessna 172S · Mt. Comfort, INThe pilot's failure to maintain directional control of the airplane while touching down during the landing.NTSB CEN09CA504Accident · Minor injuriesData collectionFinal reportVanderhoof Steve AIR Comman · Mentone, INThe pilot's failure to maintain aircraft control during the landing and subsequent impact with a parked aircraft.NTSB CEN09CA420Accident · No injuriesData collectionFinal reportAviat Husky · Greenfield, INThe pilot failed to maintain directional control of the airplane during the takeoff roll.NTSB CEN09CA200Accident · No injuriesData collectionFinal reportCessna 152 · Fort Wayne, INThe student pilot's improper flare and recovery from a bounced landing.NTSB CHI08CA107Accident · No injuriesData collectionFinal reportCessna 182T · Zionsville, INThe pilot's failure to maintain directional control during the crosswind landing. Contributing to the accident were the gusting crosswind and the runway light.