NTSB investigations, 1999
66 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\") = 1999
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") = 1999 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 SEA00LA035Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Jordan Valley, ORInadequate preflight planning/preparation. Unsuitable terrain was selected for landing and a road sign were factors.NTSB CHI00LA047Accident · No injuriesLimited investigationFinal reportDouglas DC-8-62 · Indianapolis, INthe flight crew misjudged the clearance between their right wing and the radome of the parked aircraft. A factor associated with the accident was the ground handling contractor failed to identify the unsafe/hazardous condition that existed on the congested…NTSB DEN00LA026Accident · No injuriesLimited investigationFinal reportCessna 421C · Gillette, WYThe collision with a deer on the runway during a night landing. A factor was the dark night.NTSB NYC00LA045Accident · Minor injuriesLimited investigationFinal reportCessna TR 182 · Clarksville, MDDeer that entered the runway environment while the pilot was executing a takeoff.NTSB CHI00IA037Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200A · Chicago, ILAn undetermined failure in the hydraulic system, which resulted in the airplane's entire braking system becoming temporarily inoperative. A factor associated with the incident was the airport terminal building that was contacted by the airplane.NTSB NYC00LA040Accident · No injuriesLimited investigationFinal reportBoeing 727-232 · Flushing, NYwas the use of a defective tow bar, due to the lack of an adequate inspection by contract personnel, the airlines lack of an adequate preventative maintenance program for the tow bars, and the lack of oversight by the airline on the contract personnel who…NTSB NYC00LA035Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Waynesville, OHThe flight instructor's delay in remedial action.NTSB CHI00LA024Accident · No injuriesLimited investigationFinal reportAmerican AA-1B · Gallatin, MOOn-ground collision with an animal during landing roll. The night conditions were a contributing factor.NTSB NYC00LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Rising Sun, MDThe PIC CFI's improper planning/decision to perform a downwind takeoff. A factor in this accident was the tail wind condition.NTSB LAX00LA015Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-320-231 · Phoenix, AZThe airline's failure to fully review the obstruction clearances and revise the pushback procedures in an area of the ramp where new construction had impinged on the available ramp space. Also causal was the failure of the tug driver and the wing walkers to…NTSB NYC00LA010Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Fredericksburg, PAWas the inadequate visual lookout by the pilot of the Stearman.NTSB NYC00LA009Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Burkittsville, MDThe vehicle drivers inadequate lookout.NTSB ANC00LA005Accident · No injuriesLimited investigationFinal reportCessna 172 · Bethel, AKThe failure of the driver of the forklift to maintain an adequate visual outlook.NTSB NYC00LA003Accident · No injuriesLimited investigationFinal reportPiper PA-60-700P · Greenville, METhe pilot's inadequate preflight planning and his inadequate visual lookout.NTSB FTW99LA266Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Lone Grove, OKThe pilot's selection of an unsuitable takeoff area. Factors were the fences struck during the takeoff, the tall grass, rising terrain, and a tailwind.NTSB CHI99IA351Incident · No injuriesIncident investigationFinal reportCessna 402B · Chicago, ILThe failure of the pilot in command to maintain clearance with ground obstructions.NTSB MIA99LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Covington, GAthe pilot's decision to take off from unsuitable terrain, which resulted in a collision with trees.NTSB SEA99LA170Accident · No injuriesLimited investigationFinal reportChampion 7BCM · Coolin, IDThe pilot's failure to adequately compensate for wind conditions. Factors include variable, gusty crosswinds, and trees along the sides of the runway.NTSB ANC99LA153Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot's failure to maintain a visual lookout for a parked airplane during taxi.NTSB SEA99LA164Accident · No injuriesLimited investigationFinal reportCessna 182Q · Crescent Lake, ORThe pilot's failure to maintain directional control during a bounced landing. Factors include a sudden wind shift, a crosswind gust, and tall trees growing along the side of the airstrip.NTSB NYC99LA225Accident · No injuriesLimited investigationFinal reportPiper PA-28-201RT · Toms River, NJThe pilot's failure to obtain proper clearance over an obstacle.NTSB LAX99LA306Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAThe pilot's failure to maintain an adequate visual lookout during taxi. Sun glare was a factor in the accident.NTSB LAX99LA302Accident · No injuriesLimited investigationFinal reportBoeing 737-322 · Los Angeles, CAThe lavatory service driver's failure to follow established company procedures and directives. A factor in the accident was the airline's use of a one person pushback procedure.NTSB SEA99LA160Accident · No injuriesLimited investigationFinal reportCessna 172M · Tahola, WAThe pilot's inadequate directional control and his failure to maintain clearance from trees along the side of the landing area. Factors include a landing area surrounded by tall trees.NTSB LAX99LA309Accident · No injuriesLimited investigationFinal reportCessna 172N · Carlsbad, CAThe pilot's failure to maintain an adequate clearance from obstacles during taxi in a confined space.NTSB LAX99LA298Accident · No injuriesLimited investigationFinal reportLithuanian Factory of LAK-12 · Prescott, AZThe pilot's failure to maintain an adequate clearance from ground obstructions during an off-airport landing. The pilot's inability to locate suitable thermal activity to remain aloft is a factor in the accident.NTSB ANC99LA132Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Ninilchik, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with this accident was the sunglare.NTSB DEN99LA161Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Heber City, UTThe pilot's failure to maintain aircraft control during takeoff roll. Factors were the gusting crosswind conditions, and the airport sign.NTSB CHI99LA312Accident · No injuriesLimited investigationFinal reportCessna 172M · Bloomington, ILthe pilot's inadequate visual lookout and not performing a maneuver to avoid obstructions. A factor was the road signs.NTSB MIA99LA235Accident · No injuriesLimited investigationFinal reportCessna 172P · Hampton, GAWas the failure of the pilot-in-command to maintain directional control after touchdown following a bounced landing, resulting in the on-ground collision with a taxiway sign and the separation of the right main landing gear.NTSB SEA99LA147Accident · No injuriesLimited investigationFinal reportCessna 180A · Belgrade, MTClearance from objects was not maintained during taxiing. Factors include the pilot's inadequate visual lookout.NTSB FTW99LA232Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Houston, TXThe failure of the pilot to maintain clearance with the person (the airport manager) walking on the taxiway and the inadequate visual lookout by the airport manager. A factor was the airport manager's diverted attention to the aircraft accident.NTSB CHI99LA302Accident · No injuriesLimited investigationFinal reportCessna 150K · Kenosha, WIThe pilot's attention being diverted into the cockpit and not maintaining visual separation with the fuel truck. A factor in the accident was the fuel truck.NTSB CHI99LA289Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe failure of the ramp service clerk to maintain clearance with the operating propeller. A factor related to the accident the inattentiveness on the part of the clerk.NTSB DEN99IA136Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COSee cause/factor narrative for DEN 99-I-A136A.NTSB DEN99LA133Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Montrose, COThe pilot's inadequate preflight planning and preparation and his failure to maintain clearance from the signpost. A factor was the signpost.NTSB LAX99LA322Accident · No injuriesLimited investigationFinal reportBoeing 757-2G7 · Phoenix, AZThe failure of the flight crew and the tug driver to verify that the aircraft was properly configured for pushback. Factors in the accident were the left wing walker's failure to notify the tug driver of his observations that the jet bridge was still in…NTSB CHI99LA259Accident · No injuriesLimited investigationFinal reportCessna 180 · Tower, MNfailure of the operator of the boat to maintain clearance with the floatplane.NTSB CHI99LA236Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Wahoo, NEThe pilot's improper starting technique which resulted in the inadvertent starting of the engine, with no one in the airplane.NTSB CHI99LA220Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Sylvania, WIthe misjudged planned approach and the evasive maneuver attempted by the pilot-in-command. A factor was the presence of trees.NTSB CHI99FA208Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-32 · Milwaukee, WIThe vehicle driver's inadvertent application of the accelerator pedal while backing towards the aircraft.NTSB CHI99IA204Incident · No injuriesIncident investigationFinal reportBoeing 767-323 · Chicago, ILthe pilot's failure to maintain clearance from the parked aircraft while taxiing. A factor in the accident was the failure of ATC to issue a traffic advisory.NTSB CHI99LA201Accident · No injuriesLimited investigationFinal reportCessna 172G · Union, INThe pilot's failure to maintain clearance with the sign. Factors associated with the accident were the low ceilings and the sign which was contacted.NTSB SEA99LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Zillah, WAThe pilot's selection of unsuitable terrain for landing adjacent to the runway. Factors include sun glare encountered at the time of the landing attempt.NTSB SEA99LA087Accident · No injuriesLimited investigationFinal reportLet L-13 · Belgrade, MTThe pilot in command's failure to maintain clearance from a parked airplane during his attempt to avoid a person on the runway.NTSB MIA99FA168Accident · No injuriesField investigationFinal reportCessna 402C · Fort Lauderdale, FLThe pilot's decision takeoff with condensation on the cockpit windows which restricted visibility, his improper use of aileron control, improper compensation for winds during takeoff, and his failure to maintain directional control during takeoff, resulting…NTSB NYC99LA127Accident · No injuriesLimited investigationFinal reportBoeing 727 · Sterling, VAInadequate visual lookout by the tug operator. A factor in this accident was inadequate pushback procedures by the airline which failed to provide proper assistance (wing walkers) to the tug operator.NTSB NYC99LA118Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Gasburg, VAThe unforecast high winds that required the pilot in command to make a precautionary landing.NTSB SEA99LA068Accident · No injuriesLimited investigationFinal reportCessna 182N · Granite, ORClearance was not maintained. A sign and the selection of unsuitable terrain for landing were factors.NTSB LAX99LA195Accident · No injuriesLimited investigationFinal reportBeech A36 · Willows, CAThe failure of the pilot to maintain an adequate clearance with a parked trailer while taxiing the aircraft.