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 NYC98LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Edgartown, MAThe pilot's inadequate evaluation of the wind direction and his failure to initiate a go-around. Contributing factors were the tailwind, wet runway, and utility pole.NTSB SEA97LA220Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Stuart Island, WAThe pilot's improper decision to land on a wet grass runway with a ten knot tailwind. Factors were the wet runway surface and tailwind.NTSB FTW97IA365Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-83(MD-83) · New Orleans, LARunway overrun for undetermined reasons.NTSB FTW97LA360Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Heber City, UTThe pilot's improper use of spoilers during the landing sequence. Factors were the embankment and the fence.NTSB CHI97LA288Accident · No injuriesLimited investigationFinal reportBeech 35-C33A · Amana, IAthe pilot's improper planning/decision. The fence (location) was a related factor.NTSB ATL97LA130Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Murfreesboro, TNThe pilot's excessive airspeed, and improper touch down point during landing, that resulted in the runway end overun. Factors were the wet runway surface, and the embankment at the end of the runway.NTSB ANC97LA136Accident · No injuriesLimited investigationFinal reportCessna 185F · Kotzebue, AKThe pilot's selection of an unsuitable landing area. A factor was the short length of the off-airport site.NTSB CHI97LA265Accident · Minor injuriesLimited investigationFinal reportCessna P210 · Grayslake, ILexcessive airspeed and the pilot's failure to attain the proper touchdown point during landing. Factors associated with the accident were inadequate aircraft preflight and the ditch.NTSB SEA97LA175Accident · No injuriesLimited investigationFinal reportCessna T210H · Stehekin, WAThe pilot's misreading of the windsock and subsequent downwind landing. Factors in the accident were the sunglare and tailwind.NTSB ATL97LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Athens, TNthe pilot's failure to initiate a go-around. The pilot's misjudged approach was a factor.NTSB IAD97LA098Accident · No injuriesLimited investigationFinal reportCessna 182K · Ellington, CTThe pilot's misjudgment of speed and distance and his failure to execute a go around.NTSB IAD97LA099Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Wadsworth, OHThe pilot's failure to retard the engine throttle to idle during the landing roll. A related factor was the diverted attention.NTSB LAX97LA251Accident · No injuriesLimited investigationFinal reportCessna 150M · Chico, CAfailure of the student pilot to maintain adequate airspeed during a go-around. Trees at the departure end of the runway were a related factor.NTSB LAX97LA237Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Joshua Tree, CAfailure of the pilot to adequately judge the wind direction and to select the correct runway, which resulted in a downwind landing; and his failure to go around, while there was sufficient runway remaining. The tailwind, fence, and ditch were related factors.NTSB ANC97TA098Accident · Minor injuriesFinal reportCessna U206G · Platinum, AKThe pilot's misjudgment of the proper touchdown point. A factor associated with the accident was a tailwind.NTSB FTW97LA254Accident · No injuriesLimited investigationFinal reportNorth American NA-265-80 · Ardmore, OKThe failure of maintenance personnel to mask the gear locking pins prior to painting the airplane which resulted in the right main gear locking pin jamming in the unlocked position due to contamination with paint. A factor was the failure of maintenance…NTSB NYC97LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Frankfort, NYThe pilot's misjudgment of distance and speed on final approach, and his failure to attain the proper touchdown point during landing. A factor in the accident was the night light condition.NTSB CHI97LA189Accident · No injuriesLimited investigationFinal reportCessna 172P · Fowlerville, MIfailure of the pilot to either attain proper touchdown point for landing or go around while he had sufficient airspeed and runway remaining.NTSB ATL97LA089Accident · No injuriesLimited investigationFinal reportCessna 175A · Panama City Bch, FLfailure of the pilot to account for the reduced braking effectiveness on the wet/grass airstrip, which resulted in an overrun and encounter with a ditch. Factors relating to the accident were: failure of the pilot to obtain weather information before…NTSB FTW97LA231Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Waldenburg, ARthe pilot's improper planning/decision. The short runway and failure to use up to 10 degrees of flaps were related factors.NTSB FTW97LA211Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Oklahoma City, OKThe pilot's impairment of judgment and performance due to alcohol which led to an attempted takeoff in an airplane without an elevator installed.NTSB ANC97TA085Accident · No injuriesFinal reportCessna U206F · Chevak, AKThe pilot's misjudgment of the prevailing wind conditions during landing.NTSB ATL97LA076Accident · No injuriesLimited investigationFinal reportCessna 172M · Perry, GAthe pilot misjudged his distance/airspeed during the approach to land, and touched down long on the runway.NTSB FTW97LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeport, TXThe pilot's misjudgment of distance and altitude. A contributing factor was a tailwind.NTSB FTW97LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Rio Hondo, TXfailure of the pilot to use all of the available runway during landing, and his resultant failure to attain a proper touchdown point for a safe rollout. Factors relating to the accident were: the wet runway with hydroplaning conditions, the uneven terrain…NTSB NYC97LA094Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Red Hook, NYThe pilot's improper compensation for the wind conditions and his failure to initiate a go-around.NTSB CHI97LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Grayslake, ILthe pilot's misjudgment of the aircraft's speed and runway distance available. Factors were an off-field ditch and a tailwind condition.NTSB ANC97LA071Accident · No injuriesLimited investigationFinal reportCessna 185 · Cordova, AKThe pilot's decision not to perform a go-around. A factor in the accident was the presence of birds which led the pilot to extend and misjudge his touchdown point.NTSB LAX97LA199Accident · No injuriesLimited investigationFinal reportCessna 172N · El Monte, CAthe student pilot's misunderstanding of the controller's clearance during an aborted touch-and-go landing.NTSB IAD97LA072Accident · No injuriesLimited investigationFinal reportCessna 172H · Westminister, MDThe pilot misjudged landing distance on the runway and his failure to perform a go-around.NTSB LAX97LA169Accident · No injuriesLimited investigationFinal reportCameron N-77 · Temecula, CAThe pilot's misjudgment of his speed and altitude, which led to a landing overshoot.NTSB SEA97LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Ilwaco, WAThe student pilot's failure to land the aircraft at the proper touchdown point. Factors include inadequate preflight planning/preparation by the student pilot, inadequate supervision by the student pilot's flight instructor, rain, fog, strong crosswinds, a…NTSB NYC97LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Butler, PAthe pilot's misjudgment of distance and speed on final approach; his failure to attain the proper touchdown point; and his failure to perform a go-around, while there was still sufficient airspeed and runway remaining, which resulted in an overrun and…NTSB CHI97LA112Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Wautoma, WIthe pilot's improper use of the throttle. Factors were a crosswind and soft terrain.NTSB LAX97LA145Accident · No injuriesLimited investigationFinal reportBeech B-60 · Big Bear City, CAThe pilot's decision to land with a tail wind condition, and a failure to attain the proper touchdown point which resulted in an overrun.NTSB FTW97LA140Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Watson, ARThe pilot's failure to attain lift off speed and the ground loop/swerve encountered. Factors were the gravel and soft terrain at the end of the runway.NTSB MIA97LA088Accident · Minor injuriesLimited investigationFinal reportLearjet LR35 · Greenville, SCThe pilot-in-command's failure to achieve the proper touchdown point on a known wet runway, resulting in a subsequent overrun and on ground collision with a ditch.NTSB SEA97LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · College Place, WAThe certified flight instructor's improper in-flight decision to continue the landing attempt and not perform a go-around, her failure to attain the proper touchdown point, and her failure to apply proper remedial action. A contributing factor was the…NTSB ANC97LA030Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Dillingham, AKthe pilot's selection of unsuitable terrain for departure, and his inadequate evaluation of the wind conditions. Factors associated with the accident were: a snow/slush covered runway, and a quartering tailwind.NTSB IAD97IA045Incident · No injuriesIncident investigationFinal reportCessna 402C · Provincetown, MAthe pilot's inadequate inflight planning/decision, and his misjudgment of speed and distance. Related factors were: fog, tailwind, and soft terrain on the overrun area at the end of the runway.NTSB CHI97LA057Accident · No injuriesLimited investigationFinal reportBeech 300 · Bloomington, INthe pilot's excessive distance/speed during the landing which led to his failure to attain a proper touchdown point on the runway. The factors involved were: the pilot's inadequate in-flight planning/decision, his failure proceed to the destination airport,…NTSB CHI97LA049Accident · No injuriesLimited investigationFinal reportGates Learjet LR35 · Kansas City, MOthe flightcrew's excessive airspeed and failure to attain a proper touchdown point on the runway. Factors were: the fog, wet runway, tailwind and improper procedures by the flight crew.NTSB LAX97LA062Accident · No injuriesLimited investigationFinal reportCessna 182M · Fallbrook, CAthe pilot's selection of a runway with a tailwind component and his maintaining an excessive airspeed on final approach, which resulted in a late touchdown and a high ground speed.NTSB ATL97LA019Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Soperton, GAfailure of the pilot either to attain the proper touch down point for landing or to abort the landing while there was sufficient runway remaining. The terrain (ditch) at the end of the runway was a related factor.NTSB CHI97LA028Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301T · Lansing, ILthe pilot's improper planning/decision, and his failure to go around, while there was still sufficient runway remaining. The unfavorable wind condition was a related factor.NTSB IAD97IA020Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Cleveland, OHThe pilot's failure to follow checklist procedures and extend the spoilers.NTSB MIA97LA019Accident · No injuriesLimited investigationFinal reportBeech A36 · Walnut Cove, NCfailure of the pilot/owner (PIC) to either go around while there was sufficient runway remaining or apply adequate braking to stop the aircraft before overrunning the runway. Factors relating to the accident were: the pilot/owner's misjudgment of distance and…NTSB IAD97LA007Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Harlan, KYthe pilot's misjudged distance and speed, and his faiure to attain the proper touchdown point during the landing, which resulted in overrun of the runway and an encounter with terrain.NTSB ATL97LA001Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Morris, ALThe pilot selected the wrong runway relative to the wind, and misjudged the proper touchdowm point on the runway. The tailwind was a factor.NTSB FTW97LA012Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Idalou, TXthe pilot's improper planning/decision, which resulted in an overrun during takeoff and an encounter with cotton (crop) and rough/uneven terrain. Factors relating to the accident were: the excessive loading of the airplane for the existing conditions, the…