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 LAX90LA287Accident · No injuriesLimited investigationFinal reportCessna 172P · Coalinga, CAThe failure of the student pilot to accurately interpret the wind sock, and his inadvertent attempt to perform a downwind landing.NTSB ATL90LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNThe pilot's failure to properly judge the stopping distance of the airplane and his subsequent failure to perform a go around. Factors in the accident were the tailwind condition at the airport.NTSB NYC90LA185Accident · No injuriesLimited investigationFinal reportCessna 140 · Middlesex, NYThe student pilot's failure to execute a go-around. Factors which contributed to the accident was his misjudgement of speed and distance which resulted in overshooting the landing.NTSB NYC90LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tunkhannock, PAThe pilot did not obtain the proper touchdown point which resulted in an overrun. The factors were altitude, wet runway, and go around not performed.NTSB CHI90LA211Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mooresville, INThe pilot in commands failure to land with enough runway remaining resulting in a runway overun and on ground collision with a wall.NTSB CHI90LA204Accident · No injuriesLimited investigationFinal reportWhittman W-8 · Toledo, IAWrong runway selected and aborted takeoff delayed by the pilot in command.NTSB CHI90LA202Accident · No injuriesLimited investigationFinal reportCessna C-152 · Troy, MIThe solo student's failure to maintain lineup with runway centerline during landing flare and touchdown. Factors in the accident were the pilot's lack of total experience and the crosswind conditions.NTSB ATL90LA149Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Concord, NCThe pilot's inadequate preflight planning and preparation, in that he did not fully consider the effects of high obstructions and a poor runway surface condition.NTSB CHI90FA196Accident · No injuriesField investigationFinal reportCessna 172 · Canton, MIThe pilot's inadequate takeoff procedure, premature liftoff and delayed reaction to abort the takeoff.NTSB CHI90LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Twining, MIThe pilot's inability to maintain adequate control of the aircraft as it decellerated on the runway after touchdown.NTSB FTW90LA144Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Terrell, TXWrong runway selected by second pilot. Factors were: tailwind and inadequate supervision by pilot-cfi.NTSB FTW90DRD13Accident · 1 fatalFinal reportde Havilland DH-82A · Youngsville, LAThe pilot's failure to touch down at the proper point on the landing surface. A contributing factor was the late initiation of the aborted landing.NTSB CHI90LA189Accident · No injuriesLimited investigationFinal reportMitsubishi MU-300 · Milwaukee, WIThe pilot's delayed determination of traction or braking action until too little runway remained to go around or to employ alternate means of activiating the brakes. Contributing to the accident was the overservicing of the main gear struts.NTSB LAX90LA258Accident · No injuriesLimited investigationFinal reportCessna 340-A · Truckee, CAThe pilots loss of brake performance due to hydroplaning.NTSB CHI90LA172Accident · No injuriesLimited investigationFinal reportLearjet LR-24D · Benton Harbor, MIPilot-in-command's misjudged approach to landing, which resulted in the aircraft running off the departure end of the runway into a ravine. The late, dark night, IFR conditions contributed to the accident.NTSB ATL90LA147Accident · No injuriesLimited investigationFinal reportBeech 23 · Stone Mountain, GAThe pilot's improperly planned approach, in that the airplane was high and fast, which resulted in the runway overrun.NTSB SEA90LA134Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Yamhill, ORThe pilot's failure to retract the flaps during go-around.NTSB LAX90LA251Accident · No injuriesLimited investigationFinal reportBeech A36 · Los Banos, CAThe pilot's use of excessive airspeed during landing and his not attaining a proper touchdown point on the runway.NTSB CHI90LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Drummand Island, MIPilot-in-command's failure to plan his approach and landing to use all available runway. Contributing factors are inadequate preflight preparation, lack of familiarity with the destination airport, and inadequate runway markings.NTSB LAX90LA237Accident · No injuriesLimited investigationFinal reportCessna 172M · El Cajon, CAThe pilot-in-command's failure to abort the landing after touchdown past the touchdown zone.NTSB CHI90FA161Accident · 1 fatalField investigationFinal reportCessna 152 · Hagerstown, INThe pilot's failure to use all available runway and failure to abort the takeoff.NTSB DEN90LA126Accident · No injuriesLimited investigationFinal reportCessna 172 · Boulder, COThe pilot's failure to touch down at the proper point, his misjudgment of the distance required for takeoff following the touch and go, and his delayed decision to abort the takeoff.NTSB LAX90LA215Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Marble Canyon, AZInadequate compensation for wind conditions by the pilot and his delay in attempting a go-around. Factors related to the accident were: the surrounding terrain, unfavorable weather conditions, the pilot's failure to attain the proper touchdown point, and…NTSB NYC90LA121Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Clayton Lake, METhe pilot's delayed decision to perform a go around.NTSB ATL90LA122Accident · No injuriesLimited investigationFinal reportCessna 177 · Hazard, KYFailure of the pilot-in-command to execute a go-around, when an updraft caused the aircraft to be high on final.NTSB BFO90LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lusby, MDThe pilot misjudged the distance needed to touchdown and stop his aircraft before running off the end of the runway. The pilot failed to use all of the available runway during the landing sequence.NTSB MIA90LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, MSThe student pilot landed long and delayed applying power during the ground roll of the touch-and-go landing.NTSB LAX90LA193Accident · Minor injuriesLimited investigationFinal reportCessna 310G · Sedona, AZThe pilot selected the wrong runway, and proper touch down point was not attained.NTSB MKC90LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Starbuck, MNCompensation for wind conditions were misjudged and aircraft control was not maintained by the pilot in command.NTSB BFO90LA044Accident · No injuriesLimited investigationFinal reportCessna 172A · Pocomoke, MDThe pilot's misjudgement of distance and speed during the approach to land, and his failure to attain the proper touchdowwn point during the landing. The ditch was a related factor.NTSB CHI90LA121Accident · No injuriesLimited investigationFinal reportBeech 58P · Auburn, INThe pilot misjudged distance and speed during the approach and landing, which resulted in an overrun of the landing area. Factors related to the accident were: darkness and the ditch.NTSB NYC90LA094Accident · No injuriesLimited investigationFinal reportCessna C-172 · Matawan, NJPilot factor in that the pilot landed long and was unable to stop the a/c on the remaining r/w.NTSB DEN90LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bountiful, UTThe flight instructor's inadequate supervision of the dual student. Factors in the accident were the premature lift-off by dual student, the rough terrain and the fence.NTSB LAX90LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · Banning, CAFailure of the student pilot to ascertain the wind direction resulting in a downwind landing.NTSB BFO90LA034Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Lovingston, VAPilot failure to climb out of ground effect because of inadequate airspeed. Factor was unfavorable wind at takeoff.NTSB SEA90LA056Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Yamhill, ORThe pilot's failure to use the proper touchdown point for landing. The tailwind was a factor related to the accident.NTSB CHI90LA098Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Greenfield, INThe pilots selection of the wrong runway relative to the wind and his failure to go-around in a timely manner.NTSB MKC90LA068Accident · No injuriesLimited investigationFinal reportMaule M4 · Creston, IASelection of the wrong runway by the pilot, and his failure to go-around while he had sufficient speed and runway to do so. Factors related to the accident were: the gusty tailwind and wet runway condition.NTSB LAX90LA118Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Redding, CAThe pilot's decision not to use full flaps which resulted in a long landing on a wet runway.NTSB MKC90LA063Accident · No injuriesLimited investigationFinal reportCessna 310G · O'Neill, NEFailure of the pilot to select the proper runway or go around. Factors related to the accident were: inadequate wind indicator, tailwind, failure of the pilot to attain the proper touchdown point, and the ditch.NTSB ANC90LA035Accident · No injuriesLimited investigationFinal reportCessna 207 · Takotna, AKImproper planning/decision by the pilot. Factors related to the accident were: the pilot's failure to attain the proper touchdown point for landing, his excessive airspeed, his failure to go around while he still had sufficient airspeed, the snow covered…NTSB ATL90LA052Accident · Serious injuriesLimited investigationFinal reportAero Commander 680E · Knoxville, TNThe pilot's excessive airspeed and delay in initiating a go-around during the landing. Factors related to the accident were: the wet runway condition, the pilot's failure to attain the proper touchdown point for the landing, and his lack of flying experience…NTSB FTW90LA052Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Mineola, TXThe pilot's misjudgement of the proper touchdown point on the runway surface. Related factors were: darkness and partial failure of the lighting system.NTSB SEA90LA034Accident · No injuriesLimited investigationFinal reportCessna 177B · Friday Harbor, WAFailure of the pilot to attain the proper touchdown point or go-around. Factors related to the accident concerned the runway condition.NTSB CHI90LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Newark, ILImproper planning/decision by the pilot. The wet condition of the grass runway was a related factor.NTSB CHI90LA057Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Lizton, INSelection of unsuitable terrain by the pilot and his failure to abort the takeoff. Factors related to the accident were: interpersonal relations of the pilot, terrain condition and fence on or near the airstrip, the pilot's lack of experience in the type of…NTSB CHI90IA044Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-31 · Chicago, ILInadequate snow removal by airport personnel.NTSB LAX90LA047Accident · No injuriesLimited investigationFinal reportCessna 182E · Avalon, CAFailure of the pilot to attain the proper touchdown point for landing, and his failure to go around when he had too much speed and insufficient distance to stop on the runway. A factor related to the accident was: the uneven terrain beyond the departure end…NTSB NYC90LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Simsbury, CTThe pilot's misjudgement of airspeed and distance during landing resulting in an overshoot and swerve off the runway. The dusk light conditions, snow, and frozen terrain were contributing factors to the accident.NTSB ANC90LA015Accident · No injuriesLimited investigationFinal reportCessna 170B · Chugiak, AKThe student pilot's improper planning/decision and his delay in initiating a go-around. Contributing factors were: the student's overconfidence in his personal abilities, his selection of the wrong runway, the resultant tailwind, and icy runway conditions.