NTSB investigations, 1990
64 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 106 |
|---|---|
| 1983 | 103 |
| 1984 | 95 |
| 1985 | 80 |
| 1986 | 69 |
| 1987 | 79 |
| 1988 | 70 |
| 1989 | 67 |
| 1990 | 64 |
| 1991 | 67 |
| 1992 | 65 |
| 1993 | 55 |
| 1994 | 64 |
| 1995 | 57 |
| 1996 | 51 |
| 1997 | 51 |
| 1998 | 77 |
| 1999 | 66 |
| 2000 | 57 |
| 2001 | 60 |
| 2002 | 63 |
| 2003 | 52 |
| 2004 | 46 |
| 2005 | 50 |
| 2006 | 52 |
| 2007 | 29 |
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\" = 310)
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" = 310) 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 LAX91LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Tucson, AZBoth pilots used poor visual lookout procedures.NTSB NYC91LA052Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Concord, NHThe improper starting procedure used by the pilot.NTSB ANC91LA016Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Fairbanks, AKThe pilot-in-command's failure to properly perform the aircraft preflight resulting in a collision with a tow bar during initial taxi.NTSB NYC91LA043Accident · Minor injuriesLimited investigationFinal reportCessna 210L · New Haven, CTThe failure of the vehicle driver to adequately monitor the radio/traffic pattern. Factors related to the accident were: darkness, the aircraft's loss of electrical power after activating the runway lights and entering the pattern, and the lack of visual…NTSB DCA91MA010Accident · 8 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-9-14 · Romulus, MILack of proper crew coordn, including virtual reversal of roles by the DC-9 plts, which led to their failure to stop taxiing & alert gnd ctlr of their positional uncertainty in a timely manner bfr & after intruding onto the active rwy. Contribuing to cause of…NTSB ATL91LA023Accident · No injuriesLimited investigationFinal reportCessna 172N · Chamblee, GAPilot's failure to maintain adequate wingtip clearance during taxi.NTSB CHI91FA032Accident · Minor injuriesField investigationFinal reportGates Learjet 25B · Chicago, ILThe driver's inadequate visual lookout. A factor in the accident was the company's configuring the truck with mirrors which obstruct forward visibility.NTSB LAX91LA046Accident · No injuriesLimited investigationFinal reportCessna T303A · Santa Ana, CAThe pilot's misjudging the distance between the airplane and hangar.NTSB BFO91LA010Accident · No injuriesLimited investigationFinal reportAeronca L3B · Farmville, VAThe failure of the pilot to properly secure the aircraft while starting the engine by hand proping.NTSB CHI91LA019Accident · No injuriesLimited investigationFinal reportCessna 150 · La Crosse, WIInadequate visual outlook by the PIC.NTSB NYC91LA021Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-31 · Columbus, OHFailure by pilots of the other aircraft to see and alter taxi path to avoid the standing aircraft.NTSB ATL91LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Centerville, TNThe propable cause of the accident was the runway incursion by the deer during the pilot's takeoff roll.NTSB SEA91LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Princeton, ORThe pilot's failure to maintain clearance from obstacles at the side of the runway.NTSB LAX91LA018Accident · No injuriesLimited investigationFinal reportCessna 150H · San Carlos, CAThe pilot's failure to maintain clearance between his aircraft and a hanger while taxiing. The failure of airport maintenance personnel to maintain taxiway markings was a factor in the accident.NTSB BFO91LA005Accident · No injuriesLimited investigationFinal reportCessna C152 · Bridgeport, WVThe pilot's inability to avoid a collision with deer which had moved onto the runway during their takeoff roll. The dark night contributed to the accident by limiting the pilots' visual outlook.NTSB LAX91LA014Accident · No injuriesLimited investigationFinal reportCessna 150E · S. Lake Tahoe, CAThe pilot's failure to ensure adequate clearance was available when he attempted to taxi pass a parked vehicle.NTSB LAX91LA010Accident · No injuriesLimited investigationFinal reportCessna 172 · San Carlos, CAThe pilot's visual lookout was inadequate.NTSB LAX91LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Watsonville, CAThe failure of the pilots of both aircraft to see and avoid the other.NTSB LAX91LA004Accident · 1 fatalLimited investigationFinal reportMooney M20K · Rio Linda, CAThe airplane's ground collision with an unauthorized person who was located on the active runway. A contributing factor was related to the nighttime (light) condition which limited the pilot's ability to see the person prior to the impact.NTSB CHI90LA274Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob 109A · Waukesha, WIThe pilot's failure to maintain adequate clearance and visual lookout for the moving tractor.NTSB SEA90LA194Accident · Minor injuriesLimited investigationFinal reportRoger A Hansen KR-2M · Shaniko, ORPilot's failure to maintain clearance from a road sign during landing ground roll. A factor in the accident was the failure of the engine exhaust system which resulted in high engine oil temperature.NTSB BFO90LA078Accident · Minor injuriesLimited investigationFinal reportde Havilland DH-82A · Bealeton, VAThe pilot's failure to maintain a vigilent watch for other aircraft operating on the uncontrolled airport. The uneven terrain on the airport restricted visibility and contributed to the accident. Another contributing factor was the improper signals given by…NTSB ANC90LA186Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot's inadequate removal of snow and ice prior to takeoff.NTSB DEN90LA186Accident · Minor injuriesLimited investigationFinal reportBeech D17S · Englewood, COImproper planning/decision by the pilot and inadequate visual lookout by the vehicle driver, which resulted in their failure to assure clearance between the vehicle and aircraft. Factors related to the accident were: sunglare and the pilot's restricted view…NTSB NYC90LA214Accident · No injuriesLimited investigationFinal reportCessna 120 · Southbridge, MAThe pilot improper starting procedures.NTSB LAX90LA308Accident · No injuriesLimited investigationFinal reportCessna 182P · Fernley, NVThe pilot's final approach airspeed was excessive.NTSB NYC90LA202Accident · No injuriesLimited investigationFinal reportWaco DSO · Keene, NHAborted takeoff with insufficient room available to stop. The pilot's delayed decision to abort the takeoff was a factor.NTSB LAX90DVG18Accident · No injuriesFinal reportGlaser-Dirks D6-100G · Vacaville, CAThe unauthorized entry onto the runway by a vehicle operator.NTSB SEA90LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · North Plains, ORThe pilot's failue to maintain adequate clearance from an object near the runway.NTSB NYC90LA204Accident · No injuriesLimited investigationFinal reportPiper 28R · Farmingdale, NJThe failure of the pilot of N8564F to insure the runway was clear prior to crossing.NTSB FTW90LA158Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Broken Arrow, OKThe pilot in command's failure to maintain directional control during the takeoff.NTSB ANC90LA148Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Cold Foot, AKThe pilot-in-command's failure to maintain flying speed.NTSB LAX90LA282Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Liano, CAThe pilot's inflight decision was improper. Contributing to this accident was the pilot's self-induced pressure.NTSB MIA90LA161Accident · Minor injuriesLimited investigationFinal reportBeech 36 · Ellenton, FLThe improper takeoff procedure by the pilot.NTSB SEA90LA132Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Bellingham, WACollision with a submerged object.NTSB NYC90LA154Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Washington, PAThe pilot's failure to maintain clearance from objects while taxiing, and his visual lookout was inadequate.NTSB NYC90LA148Accident · No injuriesLimited investigationFinal reportCessna 150 · Montour Falls, NYThe pilot in command's decision to attempt takeoff at night from an inimproved field which resulted in collision with a vehicle.NTSB LAX90LA243Accident · Minor injuriesLimited investigationFinal reportBeech 95-C55 · Fullerton, CAThe pilot's failure to detect an incorrect rudder trim adjustment, his failure to follow the prescribed pre-takeoff instructions that call for the trim to be adjusted. The collision with the fence and the incorrect rudder trim adjustment were factors in the…NTSB LAX90LA255Accident · No injuriesLimited investigationFinal reportPiper PA28-236 · S. Lake Tahoe, CAThe pilot's failure to maintain clearance between the aircraft and an obstruction along his ground taxi route. Obstructions along the route and a fence constructed near the ramp are factors in the accident.NTSB ANC90LA107Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Eielson Afb, AKThe cfi's failure to take timely action when the dual student did not attain a proper touch down point.NTSB FTW90LA121Accident · No injuriesLimited investigationFinal reportCessna 140 · Fabens, TXInadequate visual lookout by the pilots of both aircraft, which resulted in a failure of each pilot to see-and-avoid the other aircraft. A factor related to the accident was: failure of the ryan ST-3KR pilot to make traffic advizories while entering the…NTSB LAX90LA254Accident · No injuriesLimited investigationFinal reportCessna T207A · Grand Canyon, AZThe pilot's misjudgement of clearance from a parked aircraft while taxiing.NTSB NYC90LA132Accident · No injuriesLimited investigationFinal reportBoeing 747-230 · Jamaica, NYThe Boeing 747 captain misjudged clearance between his aircraft and the fokker f.28. A factor related to the accident was: self-induced pressure of the Boeing 747 captain.NTSB BFO90LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chester, MDThe pilot's misidentification of a road for the runway. Factors were sunglare and the pilot's unfamiliarity with the airport, and inadequate visual lookout.NTSB SEA90LA119Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Hawthorne, NVThe pilot's selection of unsuitable terrain for landing.NTSB DEN90LA134Accident · No injuriesLimited investigationFinal reportCessna A185F · Erie, COFailure of the pilot receiving instruction to choose suitable terrain for the landing. Contributing to the accident was the cfi's inadequate supervision.NTSB SEA90LA089Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ketchikan, AKThe pilot did not adequately compensate for the cross wind conditions while taxiing and failed to maintain clearance between the airplane and a tree on the shoreline. The crosswind was a factor related to the accident.NTSB CHI90LA129Accident · No injuriesLimited investigationFinal reportCecil, Richard C. Starduster II · Indianapolis, INThe other pilot's inadequate visual lookout during ground taxi operations.NTSB DEN90LA110Accident · No injuriesLimited investigationFinal reportCessna 205 · Bluff, UTFailure of the pilot to properly select and survey his landing site.NTSB ANC90LA089Accident · No injuriesLimited investigationFinal reportCessna C-150M · Chakachamna, AKPilot-in-command's failure to properly survey the landing area and ensure the appropriate width for his airplane.