NTSB investigations, 1990
141 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 290 |
|---|---|
| 1983 | 222 |
| 1984 | 210 |
| 1985 | 187 |
| 1986 | 159 |
| 1987 | 123 |
| 1988 | 135 |
| 1989 | 122 |
| 1990 | 141 |
| 1991 | 146 |
| 1992 | 143 |
| 1993 | 163 |
| 1994 | 124 |
| 1995 | 139 |
| 1996 | 110 |
| 1997 | 111 |
| 1998 | 105 |
| 1999 | 116 |
| 2000 | 109 |
| 2001 | 130 |
| 2002 | 105 |
| 2003 | 87 |
| 2004 | 72 |
| 2005 | 80 |
| 2006 | 79 |
| 2007 | 77 |
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\" = 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 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" = 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 NYC91DGT01Accident · 1 fatalFinal reportKolb Twin Star · Carlisle, PAThe pilot's failure to maintain adequate altitude above the ground.NTSB ANC91FA018Accident · 1 fatalField investigationFinal reportCessna 208 · False Pass, AKThe pilot's improper decision to continue flight into an area of mountainous terrain and adverse weather conditions. The terrain and weather were factors.NTSB SEA91FA120Accident · 1 fatalField investigationFinal reportCessna 182H · Thompson, UTThe pilot's misjudged descent. Contributing to the accident was the dark night conditions.NTSB ANC91FA017Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Evanston, WYThe pilot's premature descent. Contributing to the accident was the pilot's fatigue and poor weather.NTSB LAX91LA057Accident · No injuriesLimited investigationFinal reportCessna 172L · Mcdermitt, NVIntentional buzzing conducted by the pilot. His poor judgement was a factor in the accident.NTSB NYC91LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Easton, PAThe flight instructor allowed the airplane to get too low on final approach during the demonstration of a power off landing.NTSB LAX91FA059Accident · 1 fatalField investigationFinal reportCessna 182C · Globe, AZThe pilot's failure to conduct a weather evaluation prior to flight and his attempt to conduct his flight under visual flight rules into instrument meteorological conditions. Low ceilings along his flight route and self induced pressure to reach his…NTSB SEA91FA027Accident · 5 fatalField investigationFinal reportAero Commander 690A · Ryderwood, WAThe pilot's improper inflight planning and failure to maintain proper altitude in mountainous terrain at night.NTSB SEA91FA026Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Salt Lake City, UTThe pilot's intentional buzzing of uninhabited island in the great Salt lake and his misjudging the timing of a pull-up maneuver to clear rising terrain of a ridgeline.NTSB NYC91FA035Accident · 1 fatalField investigationFinal reportCessna 414A · Atlantic City, NJFailure of the pilot to follow the published ILS procedure and his continued descent below the decision height. Darkness and the adverse weather conditions were related factors.NTSB FTW91FA017Accident · 1 fatalField investigationFinal reportBeech B55 · England, ARThe pilot's misjudgement of altitude, which resulted in his failure to arrest descent from a dive. The pilot's impaired judgment from consumption of ethanol (alcohol) was a factor.NTSB SEA91FA021Accident · 3 fatalField investigationFinal reportBeech 95-55 · Hayden Lake, IDThe pilot's improper IFR procedure in failing to intercept the proper glideslope path.NTSB LAX91FA036Accident · 2 fatalField investigationFinal reportBeech 95-A55 · Woodland, CAThe pilot's misjudgement of his altitude to assure terrain clearance during a night visual approach. Contributing factors were the dark night, unlit terrain, the pilot's lack of recent night time, the pilot's lack of familiarity with the airport, and an…NTSB LAX91FA040Accident · 2 fatalField investigationFinal reportBeech S-35 · Kingman, AZProper altitude not maintained. Contributing to the accident was: the lack of supplemental oxygen on board the aircraft, pilot fatigue, improper use of the auto pilot, and pilot complacency.NTSB DEN91FA020Accident · Serious injuriesField investigationFinal reportCessna T210L · Clovis, NMAn inadvertent descent into the ground while conducting a non-precision instrument approach, as a result of the pilot failing to stop his descent at mda. A factor is low visibility due to fog.NTSB LAX91LA032Accident · 1 fatalLimited investigationFinal reportCessna 172RG · San Clemente, CAThe pilots selection of improper cruise altitude while operating under a low overcast on a dark night. A factor in the accident was fatigue and lack of sleep.NTSB SEA91LA016Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Brigham City, UTThe pilot did not maintain a proper climb rate.NTSB ATL91FA015Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Rock Hill, SCThe pilot misjudged the aircraft's altitude/clearance above the runway during a low pass and allowed the propeller to contact the runway; he then failed to maintain airspeed after a pull-up and allowed the aircraft to stall.NTSB LAX91LA030Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Portal, AZFailure of the pilot to maintain proper altitude.NTSB CHI91DEE01Accident · 1 fatalFinal reportPitts Special S1-S · Dekalb, ILThe pilot's attempt to perform aerobatic maneuvers at low altitude.NTSB LAX91FA022Accident · 3 fatalField investigationFinal reportPiper PA-22-108 · Oceanside, CAThe pilot initiating an instrument flight without operating air/ground communications equipment, and his failure to maintain adequate terrain clearance after apparently deciding to return to the airport. Factors contributing to the accident were inoperative…NTSB FTW91FA010Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Kingsland, TXThe pilot's failure to avoid flying into the mountain.NTSB DEN91FA013Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Belen, NMThe pilot misjudged the aircraft's altitude (ground clearance) above the desert terrain.NTSB CHI91LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Hannibal, MOThe pilot's improper recovery from a bounced landing. Factors were: excessive airspeed and the pilot's lack of total experience.NTSB NYC91LA014Accident · Minor injuriesLimited investigationFinal reportStinson SR8C · Lakeville, MAThe pilot misjudged his altitude above the lake water and allowed the airplane to descend while making a left turn. Factor's related to the accident were: calm winds causing the lake water to be glassy.NTSB ANC91LA006Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Madison Creek, AKThe pilot's premature lift off at an inadequate airspeed. Contributing to the accident was the unplowed snow on the runway.NTSB NYC91LA011Accident · No injuriesLimited investigationFinal reportRobinson R22 · Woonsocket, RIPilot's failure to maintain sufficient altitude above the terrain to avoid getting the right skid caught in the grass, resulting in a loss of control.NTSB LAX91LA009Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Agua Dulce, CAA failure of the pilot to perform preflight planning.NTSB LAX91LA003Accident · 1 fatalLimited investigationFinal reportCessna 210 · Riverside, CAImpairment of the pilot from use of drugs (cocaine), and his failure to maintain clearance (or altitude) from the mountain. Factors related to the accident were: darkness and the pilot's psychological condtion (depression).NTSB NYC91FA001Accident · 3 fatalField investigationFinal reportCessna 172P · Gorham, NHImproper planning/decision by the pilot, and his failure to maintain proper altitude while flying over mountainous terrain. Factors related to the accident were: darkness, mountainous terrain, and pilot fatigue.NTSB ANC90LA188Accident · No injuriesLimited investigationFinal reportCessna 180 · Swift River, AKThe pilot-in-command's failure to understand the performance data of the airplane, and his failure to identify unsuitable terrain.NTSB ATL90FA183Accident · 2 fatalField investigationFinal reportGrumman AA5B · Gallatin, TNThe pilot's failure to maintain the proper altitude which resulted in the inadvertent descent into the ground, and his diverted attention to another airplane. Factors in the accident were fog, dark night, fatigue from lack of sleep, and a lack of recent night…NTSB SEA90LA199Accident · 2 fatalLimited investigationFinal reportCessna 172N · Neilton, WAThe failure of the crew to maintain adequate clearance from the terrain. Factors to the accident were mountainous and box canyon terrain.NTSB NYC90FA231Accident · 2 fatalField investigationFinal reportCessna 182Q · Nantucket, MAThe pilot's improper IFR operation in attempting an ILS approach in an airplane not equipped with an ILS glide slope receiver. The weather conditions were factors in the accident.NTSB SEA90LA172Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Brothers, ORThe pilot's improper flight planning and decisions that led to him flying into rising terraain while engaged in low level flight activities.NTSB FTW90FA186Accident · 2 fatalField investigationFinal reportMooney M20A · San Ysidro, NMFailure of the pilot to maintain adequate terrain clearance during a night VFR flight. Darkness and mountainous terrain were related factors.NTSB NYC90FA227Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Eliot, METhe pilot's failure to abort the takeoff. Factors were the over weight condition, upsloping runway, premature rotation, and the pilot's lack of experience in type aircraft and general aviation operations.NTSB CHI90LA271Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNThe pilot in command attempting to force the airplane onto the runway.NTSB BFO90FA077Accident · 1 fatalField investigationFinal reportChristen Industries A-1 · Middle River, MDThe pilot delayed his recovery from an intentional spin manuever until there was insufficient altitude to recover.NTSB DEN90FA192Accident · 1 fatalField investigationFinal reportCessna 182P · Marble, COFailure of the private pilot (student pilot) to maintain sufficient altitude and airspeed above mountainous terrain, and inadequate supervision by the instructor pilot (CFI) and her delay in taking remedial action. Factors related to the accident were: the…NTSB BFO90FA076Accident · 1 fatalField investigationFinal reportPiper PA-601P · Wiley Ford, WVThe pilot's improper IFR procedure by not maintaining sufficient altitude, while circling to land. Factors related to the accident were: the low ceiling and visibility conditions in fog.NTSB FTW90DRA09Accident · No injuriesFinal reportGrumman G-164A · Altair, TXThe pilot's use of improper terrain for takeoff.NTSB CHI90DEM09Accident · 1 fatalFinal reportComben Bowers Flybaby IA · Cheboygan, MIUndetermined.NTSB LAX90LA321Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Novato, CAThe pilot's improper execution of the autorotation. Contributing to this accident was the excessive sink rate and misjudging of the altitude.NTSB FTW90FA178Accident · 1 fatalField investigationFinal reportBell B206LI · Port O'Connor, TXThe pilot's failure to maintain proper altitude. Factors were the pilot's decision to fly into the known adverse weather and the weather/light conditions.NTSB DEN90FA184Accident · 2 fatalField investigationFinal reportMorane-Saulnier MS760 · Albuquerque, NMFailure of the pilot to maintain a climb after takeoff, due to spatial disorientation. Factors related to the accident were: darkness, pilot fatigue, and the pilot's lack of recent experience in night flying operation.NTSB LAX90LA315Accident · Serious injuriesLimited investigationFinal reportCessna U206F · Las Vegas, NVThe pilot's loss of visual references during a night approach and his failure to detect and correct a descent. A factor in the accident was the dark night lighting conditions.NTSB ANC90FA158Accident · 2 fatalField investigationFinal reportCessna 414 · Sitka, AKImproper planning/decision by the pilot, and his failure to follow IFR procedures and maintain clearance from mountainous terrain.NTSB SEA90FA167Accident · 2 fatalField investigationFinal reportCessna 150-L · Newman Lake, WAThe pilot's poor judgement in attempting to land at an unlighted airstrip at night and his failure to maintain clearance from terrain during a go around.NTSB CHI90MA244Accident · 5 fatalMajor investigationFinal reportBell 206B · Elkhorn, WIImproper planning/decision by the pilot, and his failure to attain adequate altitude before flying over rising terrain at night. Factors related to the accident were: darkness, fog, haze, rising terrain, and the lack of visual cues that were available to the…