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 FTW92DRA03Accident · No injuriesFinal reportSchweizer G-164B · Bay City, TXThe pilot's inability to initiate a climb due to exceeding the takeoff capability of the airplane. A factor was the high grass on the airstrip.NTSB SEA92LA115Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mccall, IDThe pilot's poorly planned approach which resulted in a long landing and overrun of the runway.NTSB CHI92LA181Accident · No injuriesLimited investigationFinal reportNorth American NA-265-50 · Cedar Rapids, IAThe pilot-in-command's selection of the wrong runway for landing. A factor was the tailwind.NTSB FTW92DRD03Accident · No injuriesFinal reportAir Tractor AT-502 · Kaplan, LAThe pilot's failure to lower flaps to the takeoff position.NTSB CHI92LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Rockford, ILThe flight instructor's premature liftoff. Related factors are the instructor's lack of total experience in the accident make and model airplane, and the unsuitable terrain encountered during the roll-out.NTSB CHI92LA172Accident · No injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILThe pilot's improper approach to landing. Related factors are the thunderstorm and the excessive airspeed.NTSB FTW92LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Truth Or Cons, NMThe pilot's inability to stop due to worn brakes and low brake fluid.NTSB LAX92LA240Accident · Minor injuriesLimited investigationFinal reportCessna 185E · Lone Pine, CAThe pilot did not abort the takeoff in time to avoid the on ground collision with the fence and creek bank.NTSB BFO92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · Danbury, CTThe national transportation safety board determines the probable cause of the accident was the pilot misjudged distance and altitude which resulted in an overrun of the runway.NTSB LAX92LA221Accident · No injuriesLimited investigationFinal reportCessna 182E · Lone Pine, CAThe pilot's encounter with a sudden and strong quartering tailwind after landing on a short dirt runway, and the failure of the pilot to select the other airport runway, which was longer and more aligned with the wind, for the approach and landing.NTSB BFO92LA066Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Caldwell, NJThe pilot's improper IFR operation. Contributing was the pilot's lack of recent instrument flight time.NTSB DEN92FA052Accident · Serious injuriesField investigationFinal reportCessna 182 · Frederick, COThe pilot and operator attempting to operate the aircraft over maximum gross weight.NTSB ATL92LA093Accident · 1 fatalLimited investigationFinal reportSchreder RS-15 · Benton, TNThe pilot's misjudged approach to the open field, which resulted in the forced landing on the obstacle lined road.NTSB BFO92LA053Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Amelia, VAThe pilot's misjudgement of distance and altitude that resulted in an landing overrun and collision with an embankment. Contributing was failure to initiate a go around and inadequate supervision.NTSB NYC92LA084Accident · No injuriesLimited investigationFinal reportCessna 172N · New Madison, OHThe pilot's failure to attain a proper touchdown point. Contributing to the accident was the pilot inadequately planned his approach and his failure to perform a go-around.NTSB CHI92LA132Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-8F-55 · Ypsilanti, MIThe pilot-in-command's misjudging of the touchdown point. Factors include (aircraft performance) hydroplaning condition, and the pilot-in-command's poor evaluation of weather conditions.NTSB ANC92LA062Accident · No injuriesLimited investigationFinal reportCessna 172M · Haines, AKThe pilot's delayed decision to abort the takeoff. Factors to the accident were: inadequate airspeed an soft/sandy terrain.NTSB ATL92IA080Incident · No injuriesIncident investigationFinal reportFokker F.28 MK4000 · Charlotte, NCThe pilot-in-command's decision to reject the takeoff at a speed in excess of V1, resulting in an inadequate distance to stop the aircraft.NTSB MIA92LA103Accident · 1 fatalLimited investigationFinal reportDouglas AD4-DW · Titusville, FLThe pilot in commands approach at higher than normal airspeed and his landing the aircraft at higher than normal airspeed at a point one half to three quarters down the runway resulting in the aircraft overrunning the runway and nosing over.NTSB CHI92LA121Accident · No injuriesLimited investigationFinal reportCessna 172M · Osage Beach, MOThe pilot-in-command's failure to use all th eavailable runway and his misjudgment of the proper touchdown point during landing.NTSB ANC92LA043Accident · Minor injuriesLimited investigationFinal reportDouglas DC-6B · Selawik, AKThe pilot's inadequate pre flight planning and disregarding the aircraft performance data. Contributing factors were the extreme outside air temperatures, the icy runway, and the tailwind.NTSB LAX92LA123Accident · No injuriesLimited investigationFinal reportBeech C-23 · Fullerton, CAWas the pilot's poorly planned approach. Contributing to this accident was the prevailing haze/smoke, the pilot's failure to attain a proper glidepath, proper touch down point and excessive final approach airspeed.NTSB SEA92LA050Accident · No injuriesLimited investigationFinal reportCessna 182D · Monroe, UTAn aborted takeoff was not performed. The wet, soft runway was a factor.NTSB LAX92LA099Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Pacoima, CAThe pilot's improper preflight and delay in aborting the takeoff. Contributing to this accident was the unlocked nose baggage door.NTSB SEA92LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Chehalis, WAThe failure of the pilot to attain the proper touchdown point for landing. A factor relating to the accident was the poor braking conditions on the wet grass strip.NTSB ANC92IA029Incident · No injuriesIncident investigationFinal reportCessna 207 · Port Moller, AKThe icy and snow covered condition of the runway surface and the pilot's inadequate preflight planning and preparation by not surveying the surface of the entire runway.NTSB ATL92LA037Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Griffin, GAThe excessive speed used by the pilot to land on the short private airstrip. A factor was unfavorable wind.NTSB CHI92LA069Accident · No injuriesLimited investigationFinal reportCessna 182 · Lake Elmo, MNThe proper touchdown point was not attained and an aborted landing was delayed by the pilot. A factor related to the accident was the icy runway conditions.NTSB LAX92LA069Accident · No injuriesLimited investigationFinal reportGates Learjet Lear 25B · Carlsbad, CAThe pilot not attaining the proper touchdown point because of excessive altitude and airspeed, and the pilot's failure to perform a go-around. A factor in this accident was the rough and uneven terrain which was encountered after the aircraft departed the…NTSB FTW92LA042Accident · Minor injuriesLimited investigationFinal reportGrumman AA1B · Spur, TXThe pilot's selection of unsuitable terrain for takeoff.NTSB ATL92LA016Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA5A · Burnsville, NCThe pilot's inadequate preflight planning and the selection of takeoff runway with an upslope for takeoff. Factors were the pilot's lack of experience with the geographical area and the high density altitude.NTSB BFO92LA001Accident · No injuriesLimited investigationFinal reportCessna 150H · Saluda, VAThe pilot's decision to abort the takeoff with inadequate runway to stop. A factor in the accident was the failure of the exhaust muffler baffle.NTSB NYC92LA002Accident · Minor injuriesLimited investigationFinal reportFairchild SA-227AC · Augusta, METhe copilot's failure to attain a proper touchdown point. Factors were the captain's failure to follow company procedure and both pilot's limited experience.NTSB SEA91LA259Accident · No injuriesLimited investigationFinal reportGrumman AA-1 · Granite Falls, WAThe pilot's decision to not perform a go-around and a misjudged distance.NTSB LAX91LA404Accident · No injuriesLimited investigationFinal reportCessna 172 · Cottonwood, AZThe pilot-in-command's delay in raising the flaps and the subsequent inadvertent stall/mush.NTSB NYC91LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hackettstown, NJThe failure of the pilot to achieve the proper touchdown spot and excessive airspeed which resulted in an overrun. Factors related to the accident was the failure of the pilot to make a go-around after he failed to achieve his proper touchdown spot, and his…NTSB BFO91LA084Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Clifton Forge, VAThe pilot's misjudgement of altitude, distance and speed which resulted in landing overshoot.NTSB NYC91LA233Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Easton, PAAn overrun after the pilot-in-command landed long on a short, wet runway. A factor related to the accident was the failure of the pilot to make a go-around.NTSB LAX91LA380Accident · Minor injuriesLimited investigationFinal reportCessna C-340A · Brawley, CAThe pilot's selection of the wrong landing runway and his failure to attain the proper touchdown location. Factors which contributed to the accident were related to the pilot's inadequate observations of the weather and the tailwind condition which existed.NTSB CHI91LA281Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Newark, ILThe pilot's poor inflight planning/decision making. A related factor was: the wet, slippery condition of the grass runway.NTSB SEA91LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Mead, WAImproper preflight planning by the pilot, and the pilot's delay in aborting the takeoff. Factors related to the accident were: the high temperature and unfavorable wind condiiton.NTSB SEA91LA213Accident · No injuriesLimited investigationFinal reportCessna 177 · Nampa, IDThe pilot's delay in initiating a go-around (aborted landing) and his improper raising of the flaps. Factors related to the accident were: the high density altitude, tailwind, and the pilot's selection of the wrong runway.NTSB NYC91LA210Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sandusky, OHThe pilot initiated an emergency landing when the engine RPM went to zero due to a broken tachometer cable. He did not attain the proper touchdown point and overran the end of the runway.NTSB DEN91LA136Accident · No injuriesLimited investigationFinal reportCessna 421B · Pagosa Springs, COInadequate preflight of the aircraft by the pilot in command. A factor was: failure of the pilot in command to properly latch the cargo door.NTSB ATL91LA156Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Camden, TNThe student pilot's delayed decision to abort the takeoff, resulting in his inability to stop the airplane in the remaining runway. Factors were the pilot's lack of total flying experience, and the high outside air temperature at the time of the accident.NTSB ATL91LA151Accident · No injuriesLimited investigationFinal reportCessna 182L · Macon, NCThe pilot's failure to accurately judge the distance required to stop the airplane. A factor in the accident was the wet, grass runway surface at the time of the accident.NTSB LAX91LA338Accident · No injuriesLimited investigationFinal reportCessna 421C · Auburn, CAThe pilot's failure to attain the proper touchdown point while landing.NTSB DEN91LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Watkins, COThe pilot selected the wrong runway and landed with a tailwind.NTSB CHI91DTG06Accident · No injuriesFinal reportAyres S2R · Drayton, NDThat the pilot did not perform any preflight planning, and did not use the aircraft performance data.NTSB ANC91LA099Accident · No injuriesLimited investigationFinal reportCessna 402-C · Kiana, AKThe pilot failed to attain the proper touchdown point and overran the usable portion of the runway which was under construction.