NTSB investigations, NE
16 cases where the first occurrence was “Overrun”.
Cases per year
| 1982 | 4 |
|---|---|
| 1984 | 2 |
| 1985 | 3 |
| 1990 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2004 | 1 |
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 c.\"eventStateOrRegion\" = 'NE' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'NE' AND c."eventCountry" = 'USA' 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 CHI04CA195Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Omaha, NEThe pilot's failure to attain a proper touchdown point on the runway during landing. Contributing factors were the pilot's failure to perform a go-around, the ditch and the roadway encountered during the overrun.NTSB CHI99LA093Accident · No injuriesLimited investigationFinal reportMitsubishi 300 · Columbus, NEthe pilot-in-command failed to attain the proper touchdown point during the landing. Factors associated with the accident were the rough, snow covered terrain encountered off the end of the runway, and the low ceiling at the time of the landing.NTSB CHI95LA129Accident · No injuriesLimited investigationFinal reportBeech B19 · Omaha, NEThe pilot misjudged distance and speed. A factor was turbulence.NTSB CHI94LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Weeping Water, NEthe pilot-in-command's misjudging compensation for wind conditions. Factors were tailwind, and wind information confusing.NTSB CHI93LA332Accident · No injuriesLimited investigationFinal reportCessna 172M · Lincoln, NEthe pilot's failure to attain the proper touchdown point.NTSB CHI93LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lincoln, NEThe pilot's failure to attain the proper touchdown point and failure to abort the landing. The wet, grass landing area was a factor.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 MKC86LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Weeping Water, NEThe pilot stated that he was going too fast when he touched down on the short runway and should have made a go around. The airplane went off the end of the runway, went down a slope and impacted a piloe of rocks.NTSB MKC85LA218Accident · No injuriesLimited investigationFinal reportCessna 210N · Mullen, NEThe takeoff was being made from a hay meadow that was soft due to recent rains. The property owner said the field was 1/4 mi long. The density alt was calculate to be 5600 ft. the plt said the acft did not attain takeoff speed & that it collided with a fence…NTSB MKC85LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Curtis, NEThe plt stated he misread the windsock and made a downwind landing resulted. The acft overran the end of the grass rwy and nosed over when the nose gear contacted a plowed fld. The arpt operator reported the winds were from 180 degs at 18 KTS when the landing…NTSB MKC84LA237Accident · No injuriesLimited investigationFinal reportPiper PA-23-250T · Hyannis, NEThe plt had made previous arrangements to have the passenger that was to be picked up use the headlights on his car to indicate the direction of landing. Upon arrival the plt saw the headlights on the south end of the rwy pointing north. The plt subsequently…NTSB MKC84LA191Accident · No injuriesLimited investigationFinal reportCessna 182N · Beaver City, NEThe acft was landed on an uncontrolled arpt toward the nnw, & after touchdown, it did not slow down adequetely. According to the plt, he elected to ground loop the acft rather than to continue off the end of the rwy. During the attempted ground loop, the acft…NTSB MKC83LA021Accident · No injuriesLimited investigationFinal reportCessna 150J · Wahoo, NEPlt thought he heard an unusual noise just after lift-off & aborted. The acft ran off the end of the rwy & overturned. The owner examined the acft & was unable to determine the source of the noise. The plt later stated he didn't know what the noise was, &…NTSB MKC82FCJ04Accident · 1 fatalFinal reportPiper PA-36 · North Platte, NEThe aircraft ran off the departure end of the runway during takeoff on a planned agricultural flight. After departing the runway, it continued for a distance through uncut wheat until it contacted a shallow washout and small bank, then flipped over. There…NTSB MKC82DA115Accident · No injuriesFinal reportBeech 58P · Fullerton, NEThe pilot pulled up to avoid a collision with a truck on final approach. He landed midfield on a 2350 foot wet grass runway and ran off the end of the runway into rough terrain.NTSB MKC82DA081Accident · No injuriesFinal reportCessna 182A · Minden, NEThe pilot stated that he carried extra power during the approach for aid in directional control in the 10 to 15 knot crosswind. Although the pilot applied full brakes at touchdown on the wet sod runway, the aircraft ran off the end into a ditch.