NTSB investigations, 1997
52 cases where the first occurrence was “Overrun”.
Cases per year
| 1982 | 131 |
|---|---|
| 1983 | 132 |
| 1984 | 124 |
| 1985 | 86 |
| 1986 | 59 |
| 1987 | 77 |
| 1988 | 65 |
| 1989 | 62 |
| 1990 | 66 |
| 1991 | 51 |
| 1992 | 69 |
| 1993 | 70 |
| 1994 | 62 |
| 1995 | 75 |
| 1996 | 60 |
| 1997 | 52 |
| 1998 | 46 |
| 1999 | 50 |
| 2000 | 42 |
| 2001 | 36 |
| 2002 | 46 |
| 2003 | 53 |
| 2004 | 48 |
| 2005 | 47 |
| 2006 | 41 |
| 2007 | 31 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1997
AND 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 year(c."eventDate") = 1997 AND 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 NYC98LA058Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-355 · New York, NYthe pilot's misjudgment of distance and speed on final approach with a tailwind, and his failure to perform a go-around in a timely manner. A factor in the accident was the strong tailwind.NTSB NYC98LA057Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Elkins, WVThe flight instructor's failure to identify an unsafe runway condition and his delay in aborting the takeoff. Contributing was the aircraft's maximum takeoff weight exceeded, and a snow-covered runway.NTSB NYC98LA036Accident · No injuriesLimited investigationFinal reportCessna 310R · Hartford, CTThe pilot's improper in-flight decision to land on the departure end of the runway and not perform a go-around.NTSB ATL98LA011Accident · Minor injuriesLimited investigationFinal reportBeech 60 · Athens, GAthe pilot's improper in-flight planning/decision by attempting to land in weather that was below minimums, and his failure to attain a suitable touchdown point on the runway. Weather below landing minimums was a related factor.NTSB NYC98LA027Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pittstown, NJthe pilot's misjudgment of distance and speed during the approach, and her failure to perform a go-around.NTSB SEA98LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Vashon, WAA misjudged soft field takeoff. Factors include wet grass.NTSB CHI98LA019Accident · No injuriesLimited investigationFinal reportPiper J3L-65 · Reeseville, WIfailure of the normal braking system, due to a low level of brake fluid. Factors relating to the accident were: inadequate inspection of the aircraft by other maintenance personnel, the pilot's failure to check the brakes after brake maintenance/inspection,…NTSB NYC98LA010Accident · No injuriesLimited investigationFinal reportSukhoi SU-29 · Williamstown, NJThe pilot misjudged his altitude and airspeed.NTSB NYC98LA007Accident · No injuriesLimited investigationFinal reportCessna 120 · Prince George, VAThe pilot's failure to attain takeoff climb, and his delay in aborting the takeoff. A contributing factor was soft terrain.NTSB IAD98LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Dover, DEThe pilot's misjudgment of distance and speed which resulted in an overrun of the runway.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.