NTSB investigations, 2007
31 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\") = 2007
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") = 2007 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 MIA08CA018Accident · No injuriesData collectionFinal reportCessna 172 · McKinnon, TNThe pilot's failure to perform a go around.NTSB CHI08CA042Accident · Minor injuriesData collectionFinal reportCessna 180 · Becker, MNThe pilot maintained excessive airspeed during the landing approach and failed to achieve a proper touchdown point. A factor associated with the accident was the fence that the airplane contacted.NTSB CHI08CA038Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Plato Center, ILThe excessive airspeed used by the pilot which resulted in an overrun, impact with a ditch and subsequent nose over. The ditch was a factor.NTSB LAX08CA037Accident · No injuriesData collectionFinal reportCessna 152 · Turlock, CAThe pilot's delayed decision to abort the landing, which resulted in a runway overrun.NTSB ANC08CA005Accident · No injuriesData collectionFinal reportTaylorcraft F-19 · Wasilla, AKThe flight instructor's delayed remedial action during the takeoff roll, which resulted in an overrun during an aborted takeoff, and a collision with trees.NTSB NYC07LA241Accident · Serious injuriesLimited investigationFinal reportEverson Sidewinder · Pensacola, FLThe pilot's failure to attain the proper touchdown point while landing.NTSB SEA07CA267Accident · No injuriesData collectionFinal reportCessna 340A · Schellville, CAThe pilot's misjudgment of speed and distance, which resulted in an overrun of the runway. Contribution factors are the pilot's inadvertent landing at the wrong airport with a shorter runway than his intended destination and limited braking effectiveness…NTSB NYC07LA229Accident · Minor injuriesLimited investigationFinal reportIsrael Aircraft Industries Astra SPX · Atlanta, GAThe pilot's failure to initiate a missed approach and his failure to obtain the proper touchdown point while landing in the rain. Contributing to the accident were the operator's lack of standard operating procedures and the inadequate maintenance of the…NTSB LAX07CA275Accident · Minor injuriesData collectionFinal reportCessna U206G · Fort Bragg, CAThe pilot's misjudged speed and distance, which resulted in a landing overrun of the runway.NTSB ANC07CA097Accident · No injuriesData collectionFinal reportCessna 185 · McGrath, AKThe pilot's selection of an unsuitable takeoff area which resulted in an overrun and collision with a gravel berm during an aborted takeoff. Factors contributing to the accident were his delay in aborting the takeoff, and the short takeoff area.NTSB NYC07CA223Accident · No injuriesData collectionFinal reportBeech BE-55 · Gainesville, GAThe pilot's failure to attain the proper touchdown point.NTSB SEA07CA257Accident · No injuriesData collectionFinal reportCessna 182Q · Dunsmuir, CAThe pilot's misjudgment of distance/speed and his failure to attain the proper touchdown point during landing, which resulted in a runway overrun during the landing roll.NTSB NYC07LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sevierville, TNThe pilot misjudged his speed and distance resulting in an overrun. Contributing to the accident was the wet turf runway and the lack of any information in the pilot operating handbook regarding landing distance on a wet turf runway.NTSB SEA07CA236Accident · No injuriesData collectionFinal reportCessna 182R · Redding, CAThe pilot's failure to achieve the proper touchdown point, which resulted in a runway overrun and collision with a fence.NTSB DFW07CA182Accident · No injuriesData collectionFinal reportCessna 182 · Montrose, PAThe pilot's failure to attain the proper touchdown point. A contributing factor was the prevailing tailwind.NTSB LAX07CA243Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Big Creek, IDThe pilot's misjudgment of distance and speed, which led to a long landing, and his delayed application of brakes that resulted in long landing and a runway overrun.NTSB CHI07CA231Accident · No injuriesData collectionFinal reportBeech A36 · Sturtevant, WIThe pilot's improper decision to land with a tailwind, which resulted in an overrun during landing rollout. Factors contributing to the accident include the dirt pile and the tailwind.NTSB DFW07LA179Accident · No injuriesLimited investigationFinal reportCessna 182 · Lexington, TXThe pilot's improper decision to takeoff from the unsuitable runway. Contributing to this accident was the soft terrain in the overrun area.NTSB MIA07CA115Accident · No injuriesData collectionFinal reportMooney M20R · Mitchellville, MDThe pilot's failure to attain the proper touchdown point for landing and his failure to initiate a go-around when he realized the airplane would touchdown past the intended point.NTSB NYC07CA150Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Machias, METhe pilot's inadequate in-flight planning.NTSB DEN07LA101Accident · No injuriesLimited investigationFinal reportBeech 1900D · Laramie, WYThe pilot's improper decision, his misjudgment of his speed and distance, and his failure to perform a go-around resulting in the airplane overrunning the runway and striking an electrical box. Factors contributing to the accident were the failure of the crew…NTSB SEA07LA152Accident · No injuriesLimited investigationFinal reportDassault-Breguet Mystere Falcon 900 · Santa Barbara, CAThe erroneous gross weight calculation and improper trim setting by the captain, which resulted in the airplane's failure to rotate at Vr as expected and the captain's decision to perform to a high speed aborted takeoff.NTSB CHI07CA134Accident · Minor injuriesData collectionFinal reportCessna 172I · Shelby, OHThe pilot's failure to properly achieve the correct touch down point which resulted in a runway over run and subsequent nose over into a ditch. Other factors were the pilot's improper decision to land with a tailwind and the ditch.NTSB CHI07LA135Accident · No injuriesLimited investigationFinal reportCessna 414A · Sturgeon Bay, WIWorn brakes which resulted in an overrun during landing. A fence was a factor.NTSB LAX07CA132Accident · No injuriesData collectionFinal reportCessna U206-C · Cottonwood, IDThe pilot's misjudgment of distance/speed, which resulted in a overshoot of the runway in tailwind conditions and subsequent nose over. Factors in the accident were the tail wind condition and the short runway.NTSB CHI07CA117Accident · Minor injuriesData collectionFinal reportNeal Anderson Comp Air 6 · Sturtevant, WIThe pilot's failure to obtain a proper touchdown point, which resulted in a runway over run and subsequent nose-over of the aircraft, and the pilot's improper weather evaluation to land with a quartering tailwind. Factors contributing to the accident were a…NTSB DCA07FA037Accident · No injuriesClass 1 · FieldFinal reportBombardier CL-600-2B19 · Traverse City, MIThe pilots' decision to land at Cherry Capital Airport (TVC), Traverse City, Michigan, without performing a landing distance assessment, which was required by company policy because of runway contamination initially reported by TVC ground operations personnel…NTSB DEN07LA078Accident · No injuriesLimited investigationFinal reportDassault Mystere Falcon 900C · Rifle, COThe pilot's improper decision to land with excessive airspeed during the approach and failure to obtain the proper touchdown point, which resulted in a runway overrun. Contributing factors were the pilot's failure execute a missed approach, to use available…NTSB DCA07MA072Accident · No injuriesClass 1 · MajorFinal reportEmbraer ERJ-170 · Cleveland, OHthe failure of the flight crew to execute a missed approach when visual cues for the runway were not distinct and identifiable. Contributing to the accident were (1) the crew's decision to descend to the ILS decision height instead of the localizer…NTSB NYC07FA058Accident · Serious injuriesField investigationFinal reportCessna 550 · Butler, PAThe copilot's failure to maintain the proper airspeed, and failure to obtain the proper touchdown point, and the pilot-in-command's inadequate supervision, which resulted in an overrun. Contributing to the accident was the PIC's failure to activate the speed…NTSB NYC07CA054Accident · No injuriesData collectionFinal reportCessna R182 · Hackettstown, NJThe pilot-in-command's delayed aborted takeoff, which resulted in a runway overrun and collision with terrain. A factor was the rocks off the end of the runway.