NTSB investigations, 1998
46 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\") = 1998
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") = 1998 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 ANC99IA019Incident · No injuriesIncident investigationFinal reportCessna 207 · Kotzebue, AKThe pilot's selection of the wrong taxi route. A factor associated with this incident was the absence of taxiway lighting or marking.NTSB DEN99LA027Accident · No injuriesLimited investigationFinal reportBoeing 727-233 · Denver, COSnow removal not done by other person.NTSB CHI99LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hancock, MIthe pilot became disoriented while taxiing at an unfamiliar airport and his failure to reduce engine power when the airplane departed the paved surface. Factors associated with the accident were the dark night condition, the pilot did not follow the correct…NTSB DEN99LA017Accident · No injuriesLimited investigationFinal reportCessna 182A · Bedford, WYThe pilot's failure to identify a soft area on his newly constructed airstrip, which subsequently caused his airplane to nose over.NTSB MIA99LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Pocahontas, MSThe delay by the pilot-in-command (CFI) to abort the takeoff after the student landed slightly long and his delay to add power to perform a touch-and-go landing.NTSB DEN99LA001Accident · No injuriesLimited investigationFinal reportCessna 140A · Belen, NMThe pilot's failure to maintain aircraft control. Factors were his inadequate compensation for the gusty crosswind conditions, and the airplane manufacturer's failure to provide adequate performance data.NTSB ANC98LA166Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Tyonek, AKThe aircraft's left wheel encountering a hole as the pilot taxied from landing and his inadequate compensation for wind conditions. Contributing factors were the rough terrain and gusty wind condition.NTSB CHI98LA357Accident · No injuriesLimited investigationFinal reportCessna 182K · Baldwin, WIThe pilot's inadequate preflight planning and preparation, and his failure to stop on the wet, grassy runway. A related factor was the wet grass.NTSB ANC98LA153Accident · No injuriesLimited investigationFinal reportCessna 180 · Chalkitsik, AKThe pilot's failure to identify an unsafe/hazardous condition. A factor associated with the accident was soft terrain conditions.NTSB ANC98LA144Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Willow, AKThe pilot's selection of an unsuitable takeoff area from the lake. Factors were the obstruction (point of land) hidden in the glare from the rising sun.NTSB ANC98LA137Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chugiak, AKThe pilot's inadvertent ground loop of the airplane during the landing roll.NTSB SEA98FA170Accident · 1 fatalField investigationFinal reportCessna 172L · Anacortes, WATerrain clearance was not maintained. A low ceiling and the pilot's inadequate in-flight planning/decision were factors.NTSB CHI98LA345Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Grosse Ile, MIthe pilot in command (CFI)'s diverted attention and his failure to select landing gear extension.NTSB IAD98LA102Accident · No injuriesLimited investigationFinal reportCessna 185 · Westport, MAThe flight instructor's failure to maintain control of the airplane and his delayed decision to go-around. Factors related to the accident were the flight instructor's improper inflight decision to land downwind and his inadequate compensation for wind.NTSB ATL98LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Athens, GAThe student pilot's failure to maintain directional control during land roll out that resulted in the on ground collision.NTSB ANC98LA130Accident · No injuriesLimited investigationFinal reportAyres S2R-1820 · Palmer, AKThe pilot's failure to maintain adequate terrain clearance.NTSB ANC98LA127Accident · No injuriesLimited investigationFinal reportCessna 180 · Cordova, AKThe pilot's failure to maintain directional control during takeoff. Factors associated with the accident were soft airstrip conditions, and trees.NTSB ANC98LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Cordova, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was grass covered rocks.NTSB FTW98LA360Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Boulder, COThe pilot's intentional ground loop and his inadequate compensation for the wind condition. A contributng factor was crosswinds.NTSB CHI98LA316Accident · Minor injuriesLimited investigationFinal reportWakely DR-107 · Stanton, MNthe pilot's misjudging recovery from a bounced landing. Factors were the partial failure of the propeller and a crop field.NTSB ANC98LA119Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Copper Center, AKThe pilot's selection of an unsuitable off-airport landing site. A factor associated with the accident is rough and uneven terrain.NTSB LAX98IA261Incident · No injuriesIncident investigationFinal reportBoeing 727-2Q8 · Las Vegas, NVThe airport personnel's failure to properly mark the ditch hazard and the taxiway boundaries surrounding it, and, the captain's failure to maintain a situational awareness of his location with respect to the taxiway layout. The dark night lighting condition…NTSB LAX98LA242Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Pleasanton, CAThe flight instructor's delayed remedial action and the student pilot's failure to maintain rotor RPM. A factor was the downhill terrain.NTSB ANC98LA107Accident · Minor injuriesLimited investigationFinal reportCessna 206G · Yakutat, AKThe pilot's inadequate compensation for wind conditions, and a premature lift-off. A factor associated with the accident is a sudden windshift.NTSB ANC98LA097Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nenana, AKThe failure of the FAA Flight Service Station specialist to issue an active Notice to Airmen that noted a hazardous condition on the runway. Factors associated with the accident are the rough and uneven runway, and inadequate runway maintenance by airport…NTSB ANC98LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's failure to identify an unsafe/hazardous condition. A related factor was the ditch.NTSB LAX98LA231Accident · No injuriesLimited investigationFinal reportCessna 182RG · Cameron Park, CAThe pilot's decision to initiate a turn to exit the runway at an excessive rate of speed.NTSB ATL98LA097Accident · Minor injuriesLimited investigationFinal reportBenson B-8M · Placida, FLExcessive taxi speed. A related factor was the wind gusts.NTSB ANC98LA088Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Hope, AKThe pilot's selection of an unsuitable landing/takeoff area. Contributing factors were the stream crossing the airstrip and the embankment.NTSB CHI98LA222Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer 164B · Hatton, NDthe delayed abort by the pilot, the overweight condition of the airplane, and the pilot's inadequate preparation prior to takeoff. Factors contributing to this accident were the wet condition of the airstrip, the hopper dump valve not working, and the road…NTSB ANC98LA080Accident · No injuriesLimited investigationFinal reportCessna 185F · Chitina, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were uneven and soft terrain on the landing strip.NTSB CHI98LA199Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Gregory, SDthe pilot's not maintaining control of the airplane during landing.NTSB ANC98LA071Accident · No injuriesLimited investigationFinal reportCessna 172 · Angoon, AKThe pilot's failure to maintain directional control during the aborted takeoff. A factor associated with the accident was rough and uneven terrain.NTSB CHI98LA195Accident · No injuriesLimited investigationFinal reportCessna 172E · Demotte, INThe pilot's inadequate preflight planning that failed to ensure takeoff could be attained. Other related factors were the aborted takeoff, grass, and a dirt bank.NTSB ANC98LA066Accident · No injuriesLimited investigationFinal reportCessna 188B · Talkeetna, AKThe pilot's failure to identify an unsafe/hazardous taxiway condition. A factor associated with this accident was the presence of rough and uneven terrain conditions.NTSB MIA98LA175Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Clewiston, FLThe pilot's inadequate visual lookout while taxiing for takeoff.NTSB MIA98LA169Accident · No injuriesLimited investigationFinal reportMohr Skybolt · Lakeland, FLthe failure of the pilot to maintain directional control of the airplane, after landing, resulting in the airplane departing the left side of the runway and subsequent impact with the ground.NTSB FTW98LA222Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Watkins, COThe pilot's failure to maintain visual contact with the taxiway. Factors were the pilot's disabling the electrical system by turning off the master switch, a dark night, and excessive taxi speed.NTSB ANC98LA039Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Chugiak, AKThe pilot's selection of an unsuitable, slush-covered, runway for landing. A factor was the slush-covered runway.NTSB ANC98LA038Accident · No injuriesLimited investigationFinal reportGrumman G-21 · Dutch Harbor, AKThe pilot-in-command's failure to identify the swells prior to landing. A factor was the water swells.NTSB ANC98LA035Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were snow covered terrain, and a hidden obstruction.NTSB ANC98LA034Accident · No injuriesLimited investigationFinal reportCessna 185F · Coldfoot, AKThe pilot's selection of unsuitable terrain for takeoff. Soft, snow covered terrain was a factor in the accident.NTSB LAX98LA130Accident · Minor injuriesLimited investigationFinal reportCessna 150A · Apple Valley, CAThe pilot's selection of an unsuitable landing area.NTSB FTW98LA164Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Tuckerman, ARThe pilot's failure to maintain aircraft control. Factors were the wet and soft runway conditions.NTSB LAX98LA121Accident · No injuriesLimited investigationFinal reportCessna 421B · Show Low, AZThe pilot's failure to attain the proper alignment on the runway due to the obscuration by snow of the runway and on the airplane's windows.NTSB ANC98LA015Accident · No injuriesLimited investigationFinal reportCessna 180H · Chugiak, AKthe pilot's selection of an unsuitable area for landing. A factor relating to the accident was: the crusty, snow covered surface of the airstrip.