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 FTW91LA118Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201T · Sonora, TXThe pilot's improper aircraft control during the takeoff ground run. Factors were the density altitude and the rough terrain.NTSB DEN91LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Keenesburg, COThe pilot's misjudging the approach, and disregard of wind conditions. Factors were: a tailwind condition and the pilot's anxiety.NTSB LAX91LA267Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · Auburn, CAThe pilot's use of an excessive airspeed for the final approach, and the failure of the pilot to initiate a go around when it became apparent that the aircraft would land long on the runway. A factor in the accident was the limited total experience of the…NTSB SEA91LA141Accident · No injuriesLimited investigationFinal reportCessna 172-M · Salem, ORThe pilot's poor in-flight decision and his failure to select a proper touchdown point. Factors include a wet runway, soft terrain and high vegetation.NTSB CHI91LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Manning, IAAirspeed was not attained and aborted takeoff was delayed by the pilot. Factors related to the accident were: over confidence in aircraft's ability to takeoff on the short, grass runway and a dirt embankment on the departure end of the strip.NTSB ATL91LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Knighdale, NCFailure of the pilot to attain the proper touch down point on the runway and/or perform a go-around.NTSB LAX91LA287Accident · No injuriesLimited investigationFinal reportCessna C-U206B · Novato, CAThe pilot improperly used the mixture control, failed to attain the airspeed and delayed in aborting the takeoff.NTSB NYC91LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Tuckhannock, PAThe failure of the pilot to achieve a proper touchdown point. A factor related to the accident was the pilot's failure to make a go-around.NTSB CHI91LA169Accident · No injuriesLimited investigationFinal reportCessna 172M · Cadillac, MIThe pilot-in-command's maintaining excessive airspeed through the landing touchdown which resulted in overrunning the runway.NTSB CHI91LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Chicago, ILThe pilot in command (student)'s improper judgement of the proper touchdown point. A factor contributing was the pilot in command's delaying an aborted landing.NTSB LAX91LA225Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Kernville, CA1)The failure of the pilot to accurately assess and compensate for the prevailing wind conditions; 2) his failure to maintain a correct approach speed for the aircraft; 3) his failure to attain a proper touchdown point; and 4) his failure to initiate a go…NTSB FTW91LA086Accident · No injuriesLimited investigationFinal reportGulfstream AA5B · La Grange, TXThe pilot's improper aircraft handling.NTSB MIA91LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Cedar Key, FLThe pilot's selection of the wrong runway for wind conditions.NTSB FTW91DPG07Accident · No injuriesFinal reportCessna A188B · Eudora, ARThe pilot's exceeding the airplane's takeoff performance capability for the climatic conditions.NTSB CHI91LA147Accident · No injuriesLimited investigationFinal reportBeech 58P · Wichita, KSA go around was not performed resulting in the proper touchdown not being attained by the pilot.NTSB BFO91LA045Accident · No injuriesLimited investigationFinal reportGrumman AA5B · College Park, MDThe pilot's failure to maintain aircraft control. Related factors were: hydroplaning conditions on the wet runway and the pilot's lack of recent experience.NTSB CHI91LA139Accident · No injuriesLimited investigationFinal reportCessna 172 · Detroit, MIThe proper touchdown point was not attained and the pilot failed to perform a go around. A factor related to the accident was the tailwind condition in which the pilot was attempting to land.NTSB NYC91LA119Accident · No injuriesLimited investigationFinal reportCessna 172M · Bloomvale, NYThe pilot's delay in aborting the takeoff.NTSB MIA91LA121Accident · No injuriesLimited investigationFinal reportBeech A36 · Punta Gorda, FLDelay of the pilot to abort the takeoff from the private grass airstrip resulting in the airplane overrunning the runway and colliding with a ditch.NTSB BFO91LA041Accident · No injuriesLimited investigationFinal reportCessna 172P · College Park, MDThe pilot misjudged altitude and distance which resulted in an overrun of the runway.NTSB NYC91LA091Accident · No injuriesLimited investigationFinal reportCessna 172M · Leroy, NYThe hard landing made by the pilot. Factors relating to the accident were the decision of the pilot to land on the runway despite the runway lighting system being partially inoperative, and the lack of experience of the pilot at night.NTSB NYC91LA088Accident · No injuriesLimited investigationFinal reportPiper PA28-400 · Fall River, MAAn improper flare and touchdown point which resulted in an overrun of the runway during the landing roll.NTSB NYC91FA086Accident · Minor injuriesField investigationFinal reportDouglas DC-8-62 · Jamaica, NYImproper preflight planning/preparation, in that the flight engineer miscalculated (misjudged) the aircraft's gross weight by 100,000 lbs and provided the captain with improper takeoff speeds; and improper supervision by the captain. Factors related to the…NTSB FTW91DPG02Accident · No injuriesFinal reportGrumman G-164A · Light, ARThe pilot's selection of the downwind runway for landing. A factor was the tailwind.NTSB SEA91FA057Accident · 3 fatalField investigationFinal reportCessna 182J · Glendale, ORThe pilot's failure to use all available runway for this landing, aggravated by his failure to initiate a go-around after misjudging the proper touchdown point and landing with a tailwind.NTSB CHI91LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Newark, ILThe pilot in command's poor preflight planning and improper weather evaluation.NTSB BFO91LA024Accident · No injuriesLimited investigationFinal reportMooney M20K · Fredericksburg, VAThe pilot's misjudgment of distance (runway remaining) after the aircraft touched down and/or his failure to go-around when there was still sufficient speed to do so.NTSB CHI91LA072Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Springbrook, WIThe pilot's attempt to takeoff with a strong gusty tailwind.NTSB SEA91FA039Accident · 1 fatalField investigationFinal reportCessna 140 · Port Orchard, WAThe pilot's failure to initiate an aborted takeoff at a time that left adequate runway remaining to bring the aircraft to a stop.NTSB ATL91LA032Accident · No injuriesLimited investigationFinal reportCessna 150J · Willard, NCPilot's selection of unsuitable terrain for landing his airplane and his failure to raise the flaps after landing. This resulted in his inability to decelerate during the landing roll. A factor in the accident was the rough, uneven runway condition.NTSB MIA91LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Fort White, FLThe downwind landing with excessive airspeed.NTSB NYC91LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Indian Head, MDThe flight instructors decision to land with insufficient runway remaining to stop the airplane which resulted in an overrun.NTSB NYC91LA017Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Bridgeport, CTThe pilot used excessive airspeed on the approach and landed long. The airplane went off the runway and struck a fence.NTSB SEA91LA007Accident · No injuriesLimited investigationFinal reportCessna 414A · Jackson, WYThe pilot's inadequate preflight preparation of the aircraft, his failure to remove snow and ice from the aircraft before takeoff, and his delay in attempting to abort the takeoff.NTSB CHI91LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNA poorly planned approach, and failure to take remedial action by the pilot.NTSB ATL91LA003Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Lexington, NCThe pilot's failure to establish an approach profile which would have allowed him to make a safe landing on the runway. The pilot misjudged his altitude and airspeed throughout the approach. A factor to the accident was the collision with the railroad berm.NTSB LAX91LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Kearny, AZThe pilot executing a left turn at an altitude insufficient to clear a corn field located in close proximity to the departure runway.NTSB MIA90LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Cedar Key, FLThe failure of the pilot to execute a go-around after landing long.NTSB NYC90DEI03Accident · No injuriesFinal reportPiper PA28-180 · Elkhorn Lake, OHThe pilot's improper decision to land on a short, wet grass strip. A contributing factor was the wet grass.NTSB ANC90LA184Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · King Salmon, AKThe pilot-in-command's failure to maintain airplane control during the takeoff roll, and failure of not attaining airspeed on takeoff.NTSB ANC90LA183Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's failure to adequately remove snow from the airplane and his delay in aborting the takeoff.NTSB LAX90LA334Accident · No injuriesLimited investigationFinal reportCessna 172M · Orovada, NVThe pilot's failure to initiate a go-around. His lack of recent experience in type of operation, (landings), and the inadvertent ground loop were factors in the accident.NTSB NYC90LA216Accident · No injuriesLimited investigationFinal reportCessna C337 · Manville, NJThe pilot's failure to secure his seat which slipped back during the take off run.NTSB NYC90LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Farmingdale, NJThe pilot's exceeding a proper touchdown point. A factor in the accident was the pilot's misreading wind information.NTSB CHI90LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Elwood, INThe pilot's failure to abort takeoff.NTSB DEN90LA190Accident · No injuriesLimited investigationFinal reportMooney M20B · Glenwood Spring, COWrong runway selection by the pilot, resulting in an overrun and a collision with a fence during landing roll. The prevailing tailwind, runway information and markings, and the pilot's failure to use the proper touchdown point are factors.NTSB FTW90LA159Accident · No injuriesLimited investigationFinal reportCessna 182N · Justin, TXThe unexpected impairment of the pilot. Factors related to the accident were: the pilot's selection of a short grass runway with a tailwind, the high air temperature, and the obstructions (fence & power line) at the end of the runway.NTSB NYC90LA196Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Stow, MAThe pilot's failure to properly plan the approach which resulted in the pilot misjudging the touch down point and landed long.NTSB CHI90LA234Accident · No injuriesLimited investigationFinal reportBeech P-35 Bonanza · Joliet, ILThe delay in initiating the aborted takeoff.NTSB ANC90LA144Accident · No injuriesLimited investigationFinal reportCessna 172 · Seward, AKThe pilot in command's selection of the wrong runway for wind conditions and his failure to abort landing in a timely manner resulting in overrun of the runway and on ground collision with terrain.