NTSB investigations, NE
14 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1991 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2006 | 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\" = 310)
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" = 310) 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 CHI06CA254Accident · No injuriesData collectionFinal reportAir Tractor AT-400A · Alliance, NEThe pilot's inadequate preflight inspection which led to the aircraft tow bar not being removed prior to flight.NTSB CHI02LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Falls City, NEThe deer striking the airplane during landing. A factor relating to this accident was the dark night.NTSB CHI99LA236Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Wahoo, NEThe pilot's improper starting technique which resulted in the inadvertent starting of the engine, with no one in the airplane.NTSB CHI98LA141Accident · No injuriesLimited investigationFinal reportCessna 172M · Superior, NEthe pilot's failure to maintain clearance with the sign. Factors associated with the accident were the sign which the airplane contacted and inadequate preflight planning/preparation.NTSB CHI91DCJ03Accident · No injuriesFinal reportGrumman G-164-A · Edgar, NEThe pilot's inadequate aircraft preflight inspection.NTSB CHI91LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mccook, NEA poorly planned approach and inadequate visual lookout by the pilot.NTSB MKC89LA203Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · North Omaha, NEThe pilot's selection of unsuitable terrain on which to make a simulated forced landing.NTSB MKC86LA173Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bertrand, NEThe pilot stated that he was on an unsupervised local solo flight when he decided to land at a private airstrip. As he had driven his automobile on this runway four days prior to the accident and had found the landing surface clear he assumed that the runway…NTSB MKC85LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bridgeport, NEN2920E was taking off on a 2,800 ft long, turf rwy. There was a lt crosswind of 12 KTS and the density alt was 5,000 ft. the plt said the acft encountered a dip in the rwy and swerved to the lt momentarily. He said he regained directional control but then…NTSB MKC83LA195Accident · No injuriesLimited investigationFinal reportCessna 150L · S. Sioux City, NEThe plt reported that during a touch-and-go landing on rwy 14 with a southerly wind at 8 KTS, he touched down about 1/4 of the way down the rwy with 20 deg of flaps. The temp was 93 deg & the density altitude was aprx 3800 ft. the plt did not raise the flaps…NTSB MKC83LA141Accident · No injuriesLimited investigationFinal reportPiper PA-36 · St. Paul, NEThe plt stated that when he was unable to get takeoff speed he dumped his load, then hit a fence & fence posts. The acftwas estimated to be within the CG & gross weight limits. Two inspections of the eng revealed no malfunctions.NTSB MKC83LA030Accident · No injuriesLimited investigationFinal reportCessna 152 · 1nm N. Or Mcgre, NEUpon discovering his intended point of landing was closed, the pilot chose to land the aircraft on a nearby road. During his final approach the pilot saw a power line and dove under it landing short. The aircraft collided with road signs during the landing…NTSB MKC82DA054Accident · No injuriesFinal reportCessna 340A · Lincoln, NEThe pilot tookoff from runway 17L at 1705 CST. After takeoff, he encountered a vibration. He decided to land and was cleared for runway 14. Reportedly, the vibration increased at 130 knots. The pilot reduced the power to decrease his speed and remain under…NTSB MKC82DA052Accident · No injuriesFinal reportCessna 182RG · Gurley, NEDuring takeoff from a wheatfield the left gear hit a rut and the pilot lost control. The takeoff was aborted and the aircraft traveled across a road and through a fence.