NTSB investigations, 1990
37 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\") = 1990
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") = 1990 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 LAX91LA047Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Poway, CAThe pilot's failure to obtain a proper touchdown point. Contributing factors which related to the basket's tipping over were the pilot's misjudging the wind direction and the wind's relative high speed.NTSB DEN91LA009Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Watkins, COThe pilot's inadvertent retraction of the landing gear. A factor was the pilot's lack of familiarity with the airplane.NTSB ATL91LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Valdosta, GAThe student pilot's failure to maintain directional control during a takeoff attempt. Factors to the accident were the student's overall lack of flight experience, and the reported wind gust.NTSB MIA91LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rolling Fork, MSThe failure of the pilot to maintain wingtip clearance with tall grass at the edge of the runway during the ground roll.NTSB MIA90LA185Accident · No injuriesLimited investigationFinal reportCessna A188B · Vicksburg, MSFailure of the pilot to avoid a mud hole on the runway during the ground roll to takeoff.NTSB ANC90LA165Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Blair Lakes, AKThe pilot's failure to maintain adequate lookout during the post-landing taxi. Contributing to the accident were the rough terrain, the pilot's lack of total experience, and his lack of familiarity with the geographic area.NTSB ANC90LA162Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Alagnak River, AKThe pilot-in-command's inadequate preflight planning/preparation, his selection of unsuitable terrain, and his delay in aborting the takeoff.NTSB MIA90LA174Accident · No injuriesLimited investigationFinal reportPitts S1-S · Palm City, FLFailure of the pilot in command to initiate a go around in a timely manner, and the airplane landing gear dug into the soft sod and nosed over.NTSB ANC90LA157Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kashvik Bay, AKThe pilot-in-command's improper preflight preparation and planning. Contributing to the accident was unsuitable terrain.NTSB CHI90LA219Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Columbus, NEStanding water on the approach end of the runway.NTSB ANC90LA137Accident · No injuriesLimited investigationFinal reportCessna T-207A · King Salmon, AKThe pilot's delay in aborting the takeoff.NTSB SEA90FA149Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Leavenworth, WAThe pilot's misjudgement in preflight planning when departing toward rising terrain. Contributing factors in this accident were his decision to attempt a climb-out with full flaps extended, and the minimal performance data available to him upon which he could…NTSB CHI90DCD01Accident · No injuriesFinal reportFinn A. Arnold Glassaire/SH-2 · Shenandoah, IAThe failure of the pilot to maintain directional control of the airplane during the takeoff ground run. A factor in the accident is the pilot's lack of total experience in the type of aircraft involved in the accident.NTSB NYC90LA172Accident · Serious injuriesLimited investigationFinal reportCessna C-152A · Yellowsprings, OHLoss of control when the pilot stalled the airplane after prematurely becoming airborne. Contributing to the accident was a rough field and a hidden obstruction.NTSB DEN90LA157Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Clarkston, UTJammed ailerons resultant from the collision with crops.NTSB DEN90LA150Accident · No injuriesLimited investigationFinal reportCessna T 188C · Wray, COThe failure of the pilot to maintain proper alignment proper alignment during landing.NTSB NYC90LA138Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lancaster, PAThe pilot's selection of an unsuitable landing site. Contributing to the accident was the pilots decision to land in a field with insufficient space available.NTSB SEA90LA109Accident · No injuriesLimited investigationFinal reportMaule M-5 · Riverside, ORThe pilot's selection of unsuitable terrain for a landing site and his inadequate compensation for the wind condition. Factors related to the accident were: the tailwind and the ditch.NTSB SEA90LA103Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tekoa, WAFailure of the pilot to maintain clearance between the airplane and tall grass adjacent to the gravel strip.NTSB FTW90LA117Accident · No injuriesLimited investigationFinal reportBoeing E75 · Watonga, OKPic's failure to use all of the available runway. A factor was the high density altitude.NTSB BFO90LA051Accident · No injuriesLimited investigationFinal reportCessna 172P · Chesterfield, VAThe student pilot's improper compensation for wind conditions and failure to maintain runway alignment.NTSB ATL90IA123Incident · No injuriesIncident investigationFinal reportBeech BE-18 · Anderson, SCThe pilot's failure to ensure adequate clearance while taxiing to the ramp. A factor in the incident was a dark, unlighted ramp area.NTSB NYC90LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · West Milford, NJImproper planning/decision by the flight instructor (CFI). Related to the accident was the cfi's lack of experience as an instructor.NTSB LAX90LA161Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Santa Rosa, CAThe pilot's improper recovery from a bounced landing.NTSB BFO90LA040Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Have De Grace, MDThe pilot failed to maintain directional control, and used excessive braking trying to regain control.NTSB MKC90LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Lockwood, MOTouchdown point not attained and go-around not performed by the pilot in command. Contributing factors were a wet, grass runway.NTSB LAX90FA148Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-10-10F · Los Angeles, CAPilot failed to adhere to established landing procedures, maintain a stabilized approach, and allowed the airspeed to go below the predicted v.NTSB MKC90LA076Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Newport, ARFailure of the pilot to maintain proper runway alignment, which resulted in an encounter with soft/wet (muddy) terrain and a subsequent nose over of the aircraft.NTSB LAX90LA122Accident · No injuriesLimited investigationFinal reportBoeing 737-300 · Santa Ana, CAThe pilot's improper rotation during takeoff.NTSB LAX90LA077Accident · No injuriesLimited investigationFinal reportCessna 182Q · Watsonville, CAThe pilot's inadequate visual lookout.NTSB CHI90LA088Accident · No injuriesLimited investigationFinal reportMitsubishi MU-300 · Gary, INFailure of snow removal personnel to recognize the potential hazard of the snow ridge on the runway and communicate this information to the control tower. Factors related to the accident were: the runway/terrain/light conditions, and failure of airport…NTSB LAX90LA100Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Fresno, CAThe pilot's improper handling of the airplane during taxi.NTSB MKC90LA055Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbia, MOExcessive taxi speed and inadequate visual outlook by the pilot. Factors related to the accident were: dark night and the ditch.NTSB LAX90LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Big Bear, CAThe pilot's failure to maintain adequate clearance between the aircraft wing tip and the snow bank. A factor in the accident was the snow berms alongside the runway.NTSB DEN90LA046Accident · No injuriesLimited investigationFinal reportBoeing 757-222 · New York, NYOverrotation of the aircraft during takeoff. Factors related to the accident were: the first officer's improper use of the flight manual, which resulted in his improper calculations of the rotation speed, and inadequate supervision concerning verification of…NTSB ANC90LA026Accident · No injuriesLimited investigationFinal reportCessna 207A · Nondalton, AKImproper planning/decision by the pilot. Factors related to the accident were: inadequate positioning of the temporary runway markers, snow covered runway/terrain conditions, partial whiteout condition, and the snow berms at the edges of the runway.NTSB NYC90DFJ01Accident · No injuriesFinal reportSteele Acrosport II · Penn Yan, NYFailure of the pilot to maintain directional control during the takeoff ground run. His lack of experience & the snowbank were related factors.