NTSB investigations, 1992
65 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\") = 1992
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") = 1992 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 ANC93LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Juneau, AKImproper airport ramp operations, specifically, the vehicle driver's operation of a loaded forklift near taxiing aircraft and standing aircraft.NTSB NYC93LA040Accident · 1 fatalLimited investigationFinal reportBoeing 737-300LR · Flushing, NYA lack of adequate clearance between the walker and tug which resulted in the walker being struck by the tug when he fell for unknown reason(s). A factor related to the accident was the lack of a policy to stay clear of the tug, towbar, and nosewheel of the…NTSB NYC93LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Alberta, VAThe pilot attempted to take off on rough uneven terrain and could not attain rotation speed, which resulted in the airplane striking a tree during the ground run. A factor in this accident was inadequate pre flight planning.NTSB LAX93LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Novato, CAFailed to maintain directional control and an inadequate visual lookout. Contributing to this accident were the inoperative runway lights.NTSB ATL93LA032Accident · No injuriesLimited investigationFinal reportVan Arsdell/Brent,M. Rutan Long EZ · Charleston, SCThe pilot's inadequate pre-flight planning and his failure to note the raised arresting device near the runway threshold.NTSB BFO93LA011Accident · No injuriesLimited investigationFinal reportCessna 150A · West Milford, NJThe pilot misjudged his altitude and distance and overshot the runway during landing. Contributing to the accident was the pilot's unfamiliarity with this airport.NTSB DEN93LA011Accident · No injuriesLimited investigationFinal reportBeech 1900C · Denver, COThe ramp agent misjudging the clearance between the airplane and gpu. A factor was: unavailability of proper ground assistance.NTSB ANC93LA009Accident · No injuriesLimited investigationFinal reportCessna 206 · Slate Creek, AKThe icy condition of the runway and the discontinued snow removal.NTSB FTW93LA020Accident · No injuriesLimited investigationFinal reportBritish Aerospace 3100 · Dfw Airport, TXThe pilot's failure to maintain visual lookout and clearance. The congested ramp was a factor.NTSB FTW93LA019Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-32 · Houston, TXThe vehicle operator's failure to maintain an adequate visual lookout.NTSB NYC93LA024Accident · No injuriesLimited investigationFinal reportCessna 150L · Linden, NJThe automobile driver's failure to see and avoid aircraft traffic while crossing an active runway.NTSB NYC93LA033Accident · No injuriesLimited investigationFinal reportCessna 172N II · Waverly, OHAn unavoidable collision with a deer.NTSB DEN93LA004Accident · No injuriesLimited investigationFinal reportCessna 172N · Addison, TXThe attempt by both pilots to pass each other without adequate clearance between their airplanes.NTSB FTW93LA003Accident · 1 fatalLimited investigationFinal reportCessna Ector 305A · Houston, TXThe pilot of the other aircraft's inadvertent ground loop. Factors were the left quartering tailwind and this pilot's inability to see the other airplane during the landing roll.NTSB ANC93LA004Accident · No injuriesLimited investigationFinal reportCessna 206U · Lime Village, AKPilot in command's poor preflight planning. A factor in the accident was the hazards on or near the gravel bar strip takeoff area.NTSB SEA93LA005Accident · No injuriesLimited investigationFinal reportSchweizer SSG 2-33A · Heber City, UTThe proper alignment was not maintained by the pilot. A factor relating to the accident was the sign located beside the runway.NTSB SEA92LA212Accident · No injuriesLimited investigationFinal reportBeech E35 · Anacortes, WAThe pilot in command's failure to maintain directional control. A factor contributing to the accident was: the pilot in command's not extending the flaps for landing.NTSB FTW92LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-200R · Fort Worth, TXThe pilot's failure to maintain proper clearance with the hole. Factors were the lack of markings and the poor maintenance of the taxiway and runway.NTSB ANC92FA148Accident · No injuriesField investigationFinal reportPiper PA-18 · Anchorage, AKMisjudgment by the pilot to insure adequate distance from objects in the takeoff area, which resulted in damage to the main landing gear on takeoff, and the uncontrolled ground loop by the pilot during a landing with the damaged landing gear. Factors related…NTSB SEA92LA193Accident · No injuriesLimited investigationFinal reportCessna 172N · Snohomish, WAInadequate visual lookout by the other pilot.NTSB MIA92LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Oak Hill, FLFailure of the pilot-in-command to level off during the simulated forced landing.NTSB NYC92LA182Accident · No injuriesLimited investigationFinal reportCessna 172H · New Cumberland, WVThe pilot's improper takeoff procedures and his lack of understanding of airplane performance which resulted in an aborted takeoff with insufficient runway to stop and the subsequent collision with a fence. Factors related to the accident were; the pilot's…NTSB CHI92LA248Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, ILA premature liftoff and failure to maintain directional control during a takeoff ground run by the pilot in command. A delay in taking remedial action by the designated pilot examiner is an additional cause.NTSB ANC92LA149Accident · No injuriesLimited investigationFinal reportCessna 182P · Montague Island, AKThe pilot in command did not properly align the airplane with the airstrip landing zone. A factor which contributed to the accident were the trees.NTSB NYC92LA157Accident · No injuriesLimited investigationFinal reportBoeing 747-238 · Newark, NJThe airport authority's failure to assure adequate obstacle clearance for aircraft manuevering around the ramp area.NTSB FTW92DPG11Accident · No injuriesFinal reportGrumman G-164B · Fouke, ARThe pilot's selection of unsuitable terrain for takeoff. Factors were the trees and the soft field.NTSB BFO92LA114Accident · No injuriesLimited investigationFinal reportCessna A188B · Richmond, VAThe pilot's failure to maintain clearance during takeoff.NTSB MIA92LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCFailure of the pilot-in-command to maintain adequate wingtip clearance with bushes off the side of the taxiway while taxiing to takeoff.NTSB LAX92IA307Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Los Angeles, CAA failure of ground personnel to ensure proper clearance between a taxiing airplane and an adjacent parked airplane. Contributing to the accident was a failure of ground personnel to properly position a parked airplane to ensure that it did not encroach into…NTSB FTW92LA182Accident · No injuriesLimited investigationFinal reportSchleicher KA6E · Haskell, OKThe pilot's failure to maintain directional control and the wing runners failure to keep the right wing up.NTSB MIA92LA145Accident · 1 fatalLimited investigationFinal reportRaven S-60A · Dover, FLThe pilot in commands choice of landing area near electrical lines and his failure to exit the balloon and seek safety when it was determined the deflating bag was going to make contact with power lines resulting in his receiving electrocution injuries.NTSB LAX92LA286Accident · No injuriesLimited investigationFinal reportCessna 172G · Tonopah, NVThe failure of the pilot to adequately identify and compensate for the existing tailwind conditions, and, his failure to initiate a go around when he became aware of being high with a fast ground speed.NTSB ANC92IA097Incident · No injuriesIncident investigationFinal reportCessna 150 · Anchorage, AKThe driver of the other vehicle not following procedures and directives and colliding with the airplane.NTSB NYC92LA132Accident · No injuriesLimited investigationFinal reportPiper J-3 · Ocean City, MDThe pilot's inadequate visual look out for objects while taxing.NTSB LAX92LA261Accident · No injuriesLimited investigationFinal reportCessna 140 · Newhall, CAThe pilot's poor judgment and his overconfidence in his ability to fly his airplane.NTSB ANC92LA098Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kantishna, AKThe pilot in command's excessive taxi speed. Factors relating to the accident were the crosswind and dusk light conditions.NTSB DEN92LA063Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Brighton, COThe pilot's inadequate visual lookout.NTSB DEN92FA060Accident · 1 fatalField investigationFinal reportBeech V35B · Tulsa, OKAircraft climb performance exceeded. Factors were: aircraft gross weight exceeded, grass runway selected, takeoff flaps not used, and premature rotation.NTSB FTW92DPG02Accident · Minor injuriesFinal reportGrumman G-164-B · Mcdougal, ARThe pilots failure to properly plan his take off. A factor was his lack of familiarity with the chemical dispensing equipment.NTSB NYC92LA110Accident · No injuriesLimited investigationFinal reportJames J. Dean Pitts Special S1C · Newburyport, MAThe pilot misjudging his clearance to brush and small trees during landing rollout.NTSB CHI92LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Indian River, MIAn on ground collision with a deer during a landing ground roll.NTSB ANC92LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKInadequate visual look out by the pilot of both aircraft. Contributing to the accident were the pilot's diverted attention, the other moving aircraft/object (c 172), and the excessive taxi speed of the c 172.NTSB FTW92LA153Accident · No injuriesLimited investigationFinal reportPokorney Smith Mini DSA-1 · Groom, TXThe pilot's selection of the unsuitable landing area. Factors were the weather condition and the road sign.NTSB CHI92LA164Accident · Serious injuriesLimited investigationFinal reportGrumman AA5B · Charlotte, MIThe pedestrian's failure to maintain visual outlook and separation from the taxiing aircraft.NTSB ATL92LA117Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Williamson, GAThe failure of the pilot of N46RB (the sonerai) to maintain proper runway alignment during the takeoff roll, and his inadequate visual lookout. A factor was the lack of runway edge markings at this airport.NTSB FTW92LA148Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Oil Trough, ARThe pilot's selection of unsuitable terrain for takeoff.NTSB ATL92LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bainbridge, GAThe pilot's misjudged distance of runway remaining, resulting in a delayed decision to abort the takeoff, and subsequent collision with trees. Factors were the high obstructions (trees) at the departure end of the runway.NTSB NYC92LA098Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · New Milford, CTInadequate visual lookout by the pilot which resulted in the glider striking a vehicle parked next to the runway.NTSB LAX92LA248Accident · No injuriesLimited investigationFinal reportCessna 172L · Safford, AZThe airplane colliding with animals which ran on to the runway during the pilot's takeoff roll. A factor in this accident was the pilot not being able to take remedial action and avoid the animals.NTSB CHI92LA151Accident · No injuriesLimited investigationFinal reportCessna 172M · Climax Springs, MODelay in aborting the landing by the pilot in command.