NTSB investigations
1,681 cases where the first occurrence was “Overrun”.
Cases, newest first
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.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 340) 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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 340) 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 FTW99LA263Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Ozark, ARThe pilot's delay in aborting the takeoff, which resulted in a runway overrun. A factor was the wet grass runway.NTSB SEA99LA167Accident · No injuriesLimited investigationFinal reportCessna 182S · Kamiah, IDThe pilot's excessive airspeed on final approach, his inadequate remedial action, and his failure to attain the proper touchdown point during landing. Factors included a short, confined landing area and a tailwind.NTSB MIA99LA253Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Homestead, FLThe pilot's failure to obtain the proper touch down point on landing and excessive airspeed resulting in an overrun, and subsequent collision with a fence post and clippings.NTSB FTW99LA259Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Jeanerette, LAThe pilot's failure to attain the proper touchdown point resulting in the aircraft overrunning the runway on landing roll. A factor was the gusty crosswind condition.NTSB ANC99LA134Accident · No injuriesLimited investigationFinal reportCessna 180 · Dillingham, AKThe pilot's inadequate preflight planning. Factors associated with the accident were a short runway, and the pilot's failure to use available performance data.NTSB LAX99LA297Accident · No injuriesLimited investigationFinal reportCessna 205 · Gualala, CAThe pilot's failure to attain a proper touchdown point due to his misjudgment of the aircraft's speed, altitude, and distance to the runway. The pilot's failure to initiate a go-around is also causal.NTSB ATL99LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Baker, FLThe flight instructor misjudged his altitude and airspeed. A factor was trees.NTSB CHI99LA330Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Sparta, ILThe pilot's decision not to use all of the available. A factor to the accident was the ditch.NTSB LAX99LA281Accident · Minor injuriesLimited investigationFinal reportAyres S2R-G10 · Stanfield, AZThe pilot's delay in aborting the takeoff after noting sluggish acceleration during the takeoff roll, which resulted in a runway overrun.NTSB ANC99LA122Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3T · Port Alsworth, AKThe pilot's inadvertent retraction of the trailing edge flaps during the takeoff run.NTSB CHI99LA306Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Salem, MOThe pilot in command misjudging the touchdown point.NTSB MIA99FA219Accident · 1 fatalField investigationFinal reportBeech B-58 · Panacea, FLThe pilot's excessive speed and extended touchdown point during landing resulting in an inability to stop the airplane within the length of the wet, grass runway, and the subsequent on-ground collision with the airport fence and trees.NTSB FTW99LA221Accident · Minor injuriesLimited investigationFinal reportAir Tractor 502B · Guthrie, TXThe pilot's inadequate weather evaluation prior to takeoff. Factors associated with the accident were an inadequate wind direction indicator, a sudden windshift, and a tailwind.NTSB SEA99LA140Accident · No injuriesLimited investigationFinal reportCessna T210J · Sequim, WAThe pilot's failure to adequately compensate for the changing wind conditions. Factors include a berm located off the east end of the runway and a tailwind.NTSB NYC99LA189Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Greencastle, PAThe pilot's misjudgement of speed and distance during the approach and his failure to perform a go around.NTSB ANC99LA116Accident · No injuriesLimited investigationFinal reportCessna 206 · Talkeetna, AKA leak/partial failure of the left main gear brake system. Factors in the accident were a short runway/landing area, and the presence of rocks/boulders at the end of the airstrip.NTSB FTW99LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Heber Springs, ARThe pilot's excessive approach airspeed resulting in the airplane overrunning the runway, and his failure to maintain aircraft control during the landing roll.NTSB NYC99LA183Accident · No injuriesLimited investigationFinal reportCessna 172G · Dover, DEThe student pilot's failure to execute a go-around. Factors include excessive airspeed on the final approach, and the student pilot's attempt to land beyond a safe touchdown point.NTSB CHI99LA237Accident · No injuriesLimited investigationFinal reportCessna 172L · Montezuma, IAthe pilot inadvertently landed on the wrong runway and exceeded the proper touchdown point on the runway. Factors associated with the accident were the gusty tailwind, the fence, and the ditch.NTSB NYC99LA174Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Hamburg, NYThe pilot's improper recovery from a bounced landing. A related factor was the lack of experience in make and model.NTSB DEN99LA118Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Delta, UTThe pilot's delayed aborted takeoff. A factor was the high density altitude.NTSB CHI99LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Dongola, ILthe failure of the pilot to maintain a proper glidepath on the landing approach, and the failure of the pilot to select a proper touchdown point. Factors to the accident were the lack of runway lights, the dusk light condition, and the ditch.NTSB NYC99LA162Accident · No injuriesLimited investigationFinal reportCessna 182 · Forest, VAThe pilot's misjudgment of distance/speed, also causal was his failure to execute a go-around. Contributing factors were the night conditions and the tailwind.NTSB FTW99LA175Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cabot, ARThe flight instructor's failure to attain the proper touchdown point during the landing.NTSB NYC99LA137Accident · No injuriesLimited investigationFinal reportCessna 172 · Ravenna, OHThe pilot-in-command's failure to maintain aircraft control during landing.NTSB CHI99LA176Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Demotte, INThe pilot's misjudging distance/speed resulting in an overrun. A contributing factor was the wet condition of the turf runway.NTSB CHI99LA170Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Kalamazoo, MIthe excessive airspeed, the proper touchdown point not obtained and the aborted landing not performed by the pilot. The fence and automobile were contributing factors.NTSB CHI99LA150Accident · No injuriesLimited investigationFinal reportBeech A-36 · Buffalo Center, IAThe pilot not attaining a proper touchdown point and not performing a go around. Factors were the wet grass and the tailwin.NTSB NYC99FA110Accident · Serious injuriesField investigationFinal reportSaab-Scania 340B · Jamaica, NYThe pilot-in-command's failure to perform a missed approach as required by his company procedures. Factors were the pilot-in-command's improper in-flight decisions, the pilot-in-command's failure to comply with FAA regulations and company procedures,…NTSB NYC99LA101Accident · Serious injuriesLimited investigationFinal reportBeech BE-C23 · Annappolis, MDThe pilot's failure to perform a go-around and he landed long resulting in an overrun. A factor in the accident was the night light conditions.NTSB LAX99LA167Accident · No injuriesLimited investigationFinal reportMassey Super Stallion · Shafter, CAThe pilot's decision to attempt a landing with insufficient runway remaining to stop the airplane.NTSB NYC99LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Lumberton, NJThe pilot's misjudgment of altitude and distance which resulted in a runway overrun.NTSB NYC99FA091Accident · Serious injuriesField investigationFinal reportRaytheon Corporate Jets BE-400A · Beckley, WVThe pilot-in-command misjudged his altitude and airspeed which resulted in an overrun. Contributing to the accident were the pilot's lack of total flight experience in make and model, the pilot's reliance on the airplane's optional thrust reverser system and…NTSB FTW99LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Sheridan, ARThe pilot's excessive landing approach speed and his failure to attain the proper touchdown point which resulted in a runway overrun.NTSB ANC99LA045Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Chevak, AKThe pilot's inadequate in-flight planning/decision, and his failure to attain the proper touchdown point on the runway. Factors in the accident were a tail wind condition, and the presence of snow and ice on the runway surface.NTSB ATL99LA064Accident · No injuriesLimited investigationFinal reportCessna 172B · Mt. Airy, NCThe pilot's failure to maintain proper airspeed during landing and his failure to attain a proper touchdown point on the runway.NTSB CHI99LA118Accident · No injuriesLimited investigationFinal reportCessna 172M · New Hudson, MIThe pilot's misjudgment of speed and distance and his failure to execute a go-around. A related factor was the crosswind.NTSB NYC99LA066Accident · No injuriesLimited investigationFinal reportCessna 172N · Berlin, NJThe pilot in command's failure to obtain the proper touch down point on the runway, and failure to perform a go-around. A factor relating to the accident was a sudden wind shift.NTSB LAX99LA109Accident · No injuriesLimited investigationFinal reportCessna 172P · Death Valley, CAThe pilot's use of an excessive approach reference speed and his misjudged distance/speed relationship to the runway, which resulted in a landing overrun. The pilot's failure to execute a timely go-around was also causal.NTSB CHI99LA093Accident · No injuriesLimited investigationFinal reportMitsubishi 300 · Columbus, NEthe pilot-in-command failed to attain the proper touchdown point during the landing. Factors associated with the accident were the rough, snow covered terrain encountered off the end of the runway, and the low ceiling at the time of the landing.NTSB LAX99FA101Accident · No injuriesField investigationFinal reportGrumman G-1159 · Van Nuys, CAThe pilot performed inadequate in flight planning and decided to continue the approach and landing with excessive airspeed. The pilot failed to follow company directives, which required a go around under the encountered flight conditions. This led to a long…NTSB CHI99LA087Accident · No injuriesLimited investigationFinal reportSocata TB 9 Tampico · Cahokia, ILthe pilot's improper decision to initiate the takeoff with insufficient runway remaining. A factor associated with the accident was pilot's failure to obtain clarification from the controller regarding the clearance.NTSB LAX99LA082Accident · No injuriesLimited investigationFinal reportCessna 172L · Santa Paula, CAThe instructor pilot's misjudged altitude and speed, which resulted in a failure to attain the proper touchdown point causing an overrun and collision with a block wall. A factor was the wet runway, which may have hindered brake effectiveness.NTSB ATL99LA041Accident · No injuriesLimited investigationFinal reportCessna 172 · Centre, ALThe pilot's inadequate in-flight planning and his failure to attain the proper touchdown point on the runway. Factors were the tailwind weather condition, and the wet sod runway.NTSB CHI99LA018Accident · No injuriesLimited investigationFinal reportCessna 172 · Creve Coeur, MOthe pilot misjudged his altitude and airspeed during landing. A related factor was the dark night conditions.NTSB NYC99LA020Accident · No injuriesLimited investigationFinal reportPiper PA23-250 · West Chester, PAThe pilot's failure to obtain/maintain the proper airspeed during the landing, and failure to perform a go-around. A factor in the accident was the crosswind conditions.NTSB NYC99LA021Accident · No injuriesLimited investigationFinal reportCessna 172M · Cumberland, MDThe pilot's decision to land, instead of performing a go-around.NTSB LAX99LA011Accident · 3 fatalLimited investigationFinal reportPiper PA-28-181 · Shelter Cove, CAThe pilot's excessive airspeed, failure to attain the proper touchdown point, and the delayed decision to initiate a go-around.NTSB LAX99LA012Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Apple Valley, CAThe pilot's inadvertent use of the aircraft's brakes while using the rudder pedals to maintain directional alignment during the takeoff roll.NTSB NYC99LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-R200 · Caldwell, NJThe failure of both the normal and emergency brake systems.