NTSB investigations, NE
32 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 4 |
| 1984 | 3 |
| 1985 | 2 |
| 1987 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1997 | 3 |
| 2000 | 1 |
| 2001 | 4 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 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\" = 230)
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" = 230) 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 CHI07CA166Accident · Serious injuriesData collectionFinal reportCessna A188B · Sargent, NEThe pilot's failure to maintain adequate visual lookout and clearance from the hillside. Factors contributing to the accident include the pilot's diverted attention, the hillside, and the glare from the setting sun.NTSB CHI06LA071Accident · 1 fatalLimited investigationFinal reportVillarubia RV-6 · Decatur, NEAn inflight collision with the terrain for undetermined reasons.NTSB CHI06FA057Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · La Vista, NEThe non-instrument rated pilot not maintaining aircraft control and not maintaining altitude/clearance from terrain during takeoff into instrument meteorological conditions. Contributing factors were the low ceilings, night conditions present, and the pilot's…NTSB CHI04LA100Accident · 1 fatalLimited investigationFinal reportChristen A-1 · Curtis, NEThe pilot's ostentatious display of a "hammerhead stall" during intial climb and his failure to maintain clearance from terrain. A factor was the post impact fire.NTSB CHI03LA124Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Benkelman, NEThe pilot's failure to maintain altitude clearance while maneuvering. Contributing factors were the wheat crop and the ground.NTSB CHI03LA121Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gordon, NEThe pilots failure to maintain adequate airspeed which resulted in a stall. Contributing factors to this accident were the rain, hail, and wind gusts.NTSB FTW02FA233Accident · 1 fatalField investigationFinal reportCessna 152 · Ithaca, NEThe pilot's intentional flight of the airplane into terrain in an act of suicide.NTSB CHI01LA122Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Kimball, NEThe pilot not maintaining clearance from the terrain. A factor was that the pilot misjudged the low altitude flight maneuver.NTSB CHI01LA121Accident · No injuriesLimited investigationFinal reportCessna 182L · Stromsburg, NEthe inadequate in-flight planning/decision and the flight to a destination alternate not performed by the pilot. Contributing factors were the crosswind and gusts.NTSB CHI01LA090Accident · No injuriesLimited investigationFinal reportBeech 95-55 · Scottsbluff, NEthe checklist not followed and the wheels-up landing performed by the pilot. The runway light was a contributing factor.NTSB CHI01FA080Accident · 1 fatalField investigationFinal reportBeech 58 · Ainsworth, NEthe pilot's improper in-flight decision to continue flight into known adverse weather. A factor was the icing conditions.NTSB CHI00LA255Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Omaha, NEthe landing gear not deployed, the checklist not followed, the lack of familiarity with the airplane, the landing gear warning system not understood, and the landing gear warning disregarded by the pilot.NTSB CHI98LA072Accident · 1 fatalLimited investigationFinal reportPiper PA-30/A · Hastings, NEThe pilot's improper IFR procedure, by which he failed to maintain minimum descent altitude. Fog, a low ceiling, and night condition were a contributing factor.NTSB CHI97LA259Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bradshaw, NEthe pilot not maintaining clearance from the terrain. Factors contributing to this accident were the pilot's diverted attention due to the problems with his global positioning flagger equipment and the other ag- airplane, and the crop.NTSB CHI97LA257Accident · No injuriesLimited investigationFinal reportCessna A188B · Elwood, NEthe pilot not maintaining clearance from the bushes. Factors contributing to this accident were the pilot's inadequate preparation prior to the takeoff attempt, his changing flap positions during the takeoff run which degraded the airplane's performance…NTSB CHI93FA165Accident · 3 fatalField investigationFinal reportCessna 182N · Genoa, NEThe private pilot's failure to maintain clearance from terrain while attempting aerobatic maneuvers. The pilot's disregard for procedures/directives, and attempted aerobatics, are factors.NTSB CHI92LA190Accident · No injuriesLimited investigationFinal reportPitts S2B · Aurora, NEThe pilot-in-command's restricted visual lookout from smoke entering the cockpit. Factors were smoke in the cockpit which resulted in the pilot becoming disoriented.NTSB CHI91DCJ07Accident · No injuriesFinal reportPiper PA-25-150 · Stapleton, NEThe pilot's disregard for aircraft performance data. Related factors are the pilot's poor weather evaluation, and delayed remedial action.NTSB MKC90FA019Accident · 2 fatalField investigationFinal reportCessna 320 · Nebraska City, NEThe pilot's decision to continue the flight into IFR conditions and the failure to maintain adequate alittude. Factors related to the accident were the pilot's over confidence in his ability and the lack of instrument flight experience.NTSB MKC89FA197Accident · Serious injuriesField investigationFinal reportCessna 172N · Hyannis, NEFailure of the pilot to maintain sufficient altitude. Darkness and adverse weather conditions were related factors.NTSB MKC87LA126Accident · No injuriesLimited investigationFinal reportCessna 150L · Antioch, NEThe rwy was 1900 feet long with 5500 ft density altitude. With pilot and passenger and 30 degrees of flaps and calm wind, airplane lifted off, cleared fence and road. Pilot said he lowered the nose and raised flaps to 20 degrees but may have retracted them…NTSB MKC86FCJ01Accident · Serious injuriesFinal reportCarothers Monoplane · Lincoln, NEThe plt was performing aerobatics while being photographed for a promotional video. On the last pass over the arpt the acft lost airspeed and began a side slip with the left wing down. At a very low alt AGL the acft appeared to stall and assume a higher sink…NTSB MKC85FA213Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hoskins, NEThis accident occurred on a telephone cable patrl flt. The acft would normally fly along the route of the buried cable at 200 to 300 ft AGL. When construction activity was sighted the plt would first record the sighting on a portable tape recorder and then…NTSB MKC84LA214Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Brule, NEAccording to the pilot, during the swath run the left wing dropped and the acft flew into the corn field. Density altitude was aprx 5,200 ft.NTSB MKC84LA144Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Louisville, NEAccording to the plt, the helicopter was involved in a ground search with a non-trained pax in the right seat. With the pax flying the acft in a hover the right skid contacted the muddy terrain causing the acft to roll over.NTSB MKC84LA143Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Silver Creek, NEThe plt stated he was making an end pass while spraying a pasture & collided with a hilltop on the opposite side of a draw. This occurred while the sun was obstructing his vision.NTSB MKC83LA202Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Wayne, NEThe acft collided with the ground during an aerial application maneuver. The pilots attention was diverted when he was looking for 3 wheel vehicles so he 'wouldn't spray them'. He did not realize that a hill was in his path and could not pull-up soon enough.NTSB MKC83LA170Accident · No injuriesLimited investigationFinal reportMonke Rotec Rally 3 · Nickerson, NEThe acft was a registered, home built, 2 place, ultralight vehicle. The passenger was the plt's friend who was building his own ultralight & wanted to ride along to get a general feeling of how to land this type of acft. The plt reported that the temp was 86…NTSB MKC83LA096Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Minatare, NEThe plt reported that he was making a low pass to look over a possible landing area, when he allowed the acft to inadvertently touch down on soft soil beside the strip. The acft bounced, then landed hard and the main gear collapsed.NTSB MKC83LA091Accident · No injuriesLimited investigationFinal reportCessna 150M · Axtell, NEThe plt reported that he began taking off on a 1310 ft rwy that was dry but spongy. The elevation was reported as 2210 ft, the wind was calm, and the temperature was 55 deg. The flaps were set at 10 deg. Reportedly, the acft lifted off, but settled back to…NTSB MKC82DA072Accident · No injuriesFinal reportPiper PA-18 · North Loup, NEThe pilot stated that the aircraft broke ground about 1000 feet down the runway but would not climb. The pilot attempted to jettison the load but did not have time. The aircraft was landed in rough terrain. Investigation revealed that the aircraft was below…NTSB MKC82DCJ01Accident · Serious injuriesFinal reportPiper PA-22-150 · Alliance, NEAfter landing and dropping off one passenger the pilot attempted to takeoff. The airport manager stated that due to the unusually warm weather the frost was out of the ground and the runway had many gopher mounds which were very soft. He further stated that…