NTSB investigations, 1996
38 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 68 |
|---|---|
| 1983 | 54 |
| 1984 | 45 |
| 1985 | 57 |
| 1986 | 34 |
| 1987 | 46 |
| 1988 | 30 |
| 1989 | 40 |
| 1990 | 37 |
| 1991 | 31 |
| 1992 | 27 |
| 1993 | 34 |
| 1994 | 35 |
| 1995 | 45 |
| 1996 | 38 |
| 1997 | 33 |
| 1998 | 46 |
| 1999 | 40 |
| 2000 | 33 |
| 2001 | 35 |
| 2002 | 44 |
| 2003 | 33 |
| 2004 | 44 |
| 2005 | 47 |
| 2006 | 33 |
| 2007 | 39 |
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\") = 1996
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\" = 320)
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") = 1996 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" = 320) 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 LAX97LA077Accident · No injuriesLimited investigationFinal reportCessna 140 · Emigrant Gap, CAthe pilot's misjudgment of altitude/clearance while attempting a precautionary landing on a closed, snow covered runway.NTSB LAX97LA045Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Calexico, CAthe pilot's premature lift-off from the runway and his failure to attain adequate airspeed.NTSB SEA97LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bruneau, IDthe pilot's failure to perform adequate preflight planning to ensure that the aircraft could complete a takeoff in the distance available. Factors relating to the accident included: a short takeoff area, and a dirt bank at the end of the road from which the…NTSB NYC97LA012Accident · No injuriesLimited investigationFinal reportSocata TB 9 Tampico · Laurens, NYthe student pilot's selection of an unsuitable area for a precautionary landing. Factors relating to the accident were: the student becoming lost, the subsequent low fuel condition, and the embankment in the emergency landing area.NTSB CHI97LA022Accident · Serious injuriesLimited investigationFinal reportGalaxy AX8 · Columbia, MOthe pilot's selection of unsuitable terrain for landing. Factors relating to the accident were: the ditch, which was encountered during the landing; and high vegetation, which covered the ditch making it not visible to the pilot.NTSB CHI97LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Minneapolis, KSthe pilot's selection of unsuitable terrain on which to land the airplane. A factor relating with the accident was: the large rock, which the airplane contacted.NTSB SEA97TA012Accident · Minor injuriesFinal reportGarlick UH-1H · Detroit, ORthe pilot's misjudgement of rotor clearance from the terrain. The proximity of the berm was a related factor.NTSB ANC96LA164Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Aniak, AKThe pilot's failure to remove all snow and ice from the airplane prior to takeoff.NTSB ANC96LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kotzebue, AKThe pilot's selection of an unsuitable landing area. A factor in the accident was the soft terrain.NTSB LAX96LA337Accident · No injuriesLimited investigationFinal reportCessna 152 · San Carlos, AZthe pilot's decision to attempt a takeoff with the runway lights inoperative, and his failure to maintain runway alignment during an aborted takeoff, after failure of the landing light. Factors relating to the accident were: darkness, inoperative runway…NTSB ANC96LA166Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chitina, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident is the rough and uneven landing site.NTSB ANC96LA153Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKthe pilot's selection of unsuitable terrain for taxiing.NTSB MIA96TA221Accident · No injuriesFinal reportBell OH-58A · Wetumpka, ALThe student pilot improper use of flight controls (cyclic a nd collective) on a takeoff to a hover, resulting in the helicopter rolling to the right, and the main rotor blade colliding with the ground.NTSB ANC96LA136Accident · No injuriesLimited investigationFinal reportMaule M-4 · Skwentna, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident was the rough and uneven terrain.NTSB LAX96LA316Accident · No injuriesLimited investigationFinal reportCessna 172F · Ocotillo, CAthe pilot's failure to maintain proper runway alignment. The sun glare and proximity of rocks were related factors.NTSB ANC96LA169Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Northway, AKThe pilot's premature lift-off. A factor associated with the accident was the rough and uneven airstrip.NTSB CHI96LA337Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Wausau, WIthe pilot's selection of an unsuitable landing area, and his misjudgment of distance and speed, while attempting to minimize the effect of crossing an uneven area on the runway. The uneven runway condition was a related factor.NTSB ANC96LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dillingham, AKThe pilot's selection of unsuitable terrain for landing. Soft terrain was a factor in the accidentNTSB SEA96LA189Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ephrata, WAfailure of the pilot to maintain proper alignment with the landing area (driveway) during the landing. Factors relating to the accident were: the selection of an unsuitable area for landing, the reported turbulence during landing, and an encounter with a rock…NTSB MIA96LA206Accident · No injuriesLimited investigationFinal reportGrumman 164A · Marks, MSthe pilot's failure to remain clear of the known high point on runway.NTSB IAD96LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Midland, OHThe pilot's failure to attain adequate alignment with the runway and to maintain adequate terrain clearance during landing.NTSB ANC96LA107Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's inadequate preflight planning for departure and his selection of unsuitable terrain. Factors in the accident were soft, snow covered terrain and the pilot's delay in aborting the takeoff.NTSB CHI96LA303Accident · No injuriesLimited investigationFinal reportCessna A188B · Watford City, NDthe pilot's failure to maintain directional control while landing on a road.NTSB ANC96TA092Accident · No injuriesFinal reportHughes 369D · Ketchikan, AKThe pilot's failure to maintain control of the helicopter. The pilot's selection of unsuitable terrain for landing was a factor in the accident.NTSB CHI96LA190Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Oskaloosa, KSfailure of the pilot to maintain proper alignment with the roadway during the takeoff roll. A factor relating to the accident was: the selection of an unsuitable area for takeoff.NTSB CHI96LA161Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Maryville, MOthe pilot's selection of an unsuitable area to taxi off the narrow runway in order to turn around. The proximity of the ditch was a related factor.NTSB SEA96LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Harper, ORthe pilot's selection of unsuitable terrain (landing area) for a precautionary landing. A factor relating to the accident was: the pilot became ill during the flight.NTSB ANC96LA061Accident · No injuriesLimited investigationFinal reportCessna 180 · Hope, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was soft terrain.NTSB ANC96LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Palmer, AKthe pilot's selection of an unsuitable area for landing.NTSB ANC96LA036Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Chugiak, AKthe pilot's selection of an unsuitable area for landing.NTSB ANC96LA035Accident · No injuriesLimited investigationFinal reportCessna 206 · Willow, AKthe pilot's selection of unsuitable terrain for landing. Snow covered terrain that concealed uneven terrain was a factor in the accident.NTSB SEA96LA053Accident · No injuriesLimited investigationFinal reportCessna R172K · Garden Valley, IDThe pilot's selection of an unsuitable landing area. The snow covered runway was a related factor.NTSB SEA96LA064Accident · No injuriesLimited investigationFinal reportCessna 180A · Hillsboro, ORthe failure of the pilot to identify the unsuitable taxi area, and the failure of airport maintenance personnel to properly identify a construction area.NTSB LAX96LA320Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Paradise, CAThe pilot's attempted flight into known adverse weather conditions.NTSB FTW96LA087Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Port Mansfield, TXDeer running onto the runway as the student pilot was landing. A factor relating to the accident was: the soft terrain that was encountered as the pilot was maneuvering to avoid a collision.NTSB FTW96LA084Accident · No injuriesLimited investigationFinal reportLearjet 60 · Aspen, COThe pilot's improper in-flight decision to continue with the landing when the runway had not been positively identified. Factors were the snow-covered runway and landing area, sun glare, and the inadequate snow removal by airport personnel.NTSB SEA96LA038Accident · No injuriesLimited investigationFinal reportBeech B100 · Miles City, MTFailure of airport personnel to properly remove snow from the runway or issue an appropriate notam concerning the runway condition. Factors relating to the accident were: the low light condition at dawn, and the snowbank or berm that was left on the runway.NTSB CHI96LA071Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Zionsville, INthe pilot's failure to properly align the airplane for a safe landing on the runway. Related factors were: the pilot's inadequate preflight planning/preparation, snow, the snow-covered runway, and snowbanks on the sides of the runway.