NTSB investigations, 2003
52 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\") = 2003
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") = 2003 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 CHI04LA051Accident · No injuriesLimited investigationFinal reportCessna 177RG · Waterloo, IAThe impact with a deer during landing roll. A contributing factor was the night lighting conditions.NTSB FTW04LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Harrison, ARThe collapsing of the right main landing gear during the landing roll out as a result of impacting an animal on the runway during takeoff.NTSB ATL04LA053Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B19 · Miami, FLThe tug operator's loss of control and his failure to maintain clearance from the aircraft during pushback operations.NTSB LAX04CA065Accident · No injuriesData collectionFinal reportBeech 58P · San Diego, CAthe pilot's inadequate lookout, which resulted in his failure to maintain clearance from the vehicle while taxiing.NTSB CHI04LA037Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCBC · Menominee, MIThe Phillips screwdriver impacting the left tire on takeoff roll, and the deflated tire which did not allow directional control to be maintained during the subsequent landing.NTSB DEN04IA024Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COthe ground personnel’s failure to maintain aircraft clearance, resulting in the collision. Contributing factors include ground communications not coordinated by the ground personnel, the flight crew's inadequate visual outlook and the parked airplane.NTSB LAX04CA013Accident · No injuriesData collectionFinal reportCleveland Orson Starduster II SA-300 · Stockton, CAthe pilot's inadequate visual lookout resulted in his failure to maintain clearance from the parked airplane.NTSB MIA04CA002Accident · No injuriesData collectionFinal reportPiper PA-24-260B · Archer, FLThe pilot's failure to maintain directional control during the takeoff roll/run, which resulted in the airplane veering off the centerline of the runway and impacting an object, incurring damage.NTSB LAX04LA007Accident · No injuriesLimited investigationFinal reportBoeing 777-22B · San Francisco, CAthe failure of the taxiing Boeing 777's flight crew to maintain clearance from a Boeing 777 that was being pushed back from the gate. Contributing to the accident was the failure of the local ramp controller to caution either aircrew of a possible movement…NTSB NYC04CA003Accident · No injuriesData collectionFinal reportBoeing 737 · Boston, MAThe collision of a ground support vehicle with a parked aircraft, due to the faulty gearshift lever on the ground support vehicle.NTSB NYC03LA208Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135 · Flushing, NYThe inadequate visual lookout by the driver of a ground vehicle, and by ground support personnel, which resulted in a subsequent collision between the airplane and ground vehicle. A factor related to the accident was the failure of the pilot-in-command and…NTSB LAX03LA295Accident · No injuriesLimited investigationFinal reportde Havilland DH-8-202 · Phoenix, AZthe ground agent's inadequate visual lookout during push back, which resulted in his failure to maintain clearance between the airplanes.NTSB CHI03LA325Accident · No injuriesLimited investigationFinal reportBrice Lancair Legacy · Kimberling City, MOThe pilot's delayed aborted takeoff. Contributing to the accident was the pilot's inadequate preflight planning/preparation in his failure to remove the pitot cover.NTSB ANC03LA122Accident · No injuriesLimited investigationFinal reportCessna 180 · Cape Yakataga, AKThe pilot's selection of unsuitable terrain for departure, which resulted in a collision with a log during the takeoff roll. Factors contribuiting to the accident were the presence of hidden obstructions, and sunglare.NTSB ATL03CA135Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Murfreesboro, TNAn on-ground collision with an animal (deer) during an attempted takeoff. .NTSB CHI03LA276Accident · No injuriesLimited investigationFinal reportBeech 1900D · Muskegon, MIThe airplane colliding with a deer during the landing roll.NTSB NYC03LA178Accident · No injuriesLimited investigationFinal reportAerofab Lake 250 · Phippsburg, METhe airplane's collision with a submerged object during a water landing.NTSB CHI03LA258Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Litchfield, ILAn animal wandered onto the runway and collided with the airplane. A factor was the night light condition.NTSB ATL03LA124Accident · No injuriesLimited investigationFinal reportBoeing 717-200 · Atlanta, GAThe failure of the ground crew to follow powerback procedures and directives.NTSB CHI03FA234Accident · No injuriesField investigationFinal reportBeech M35 · Oshkosh, WIThe pilot's inadequate in-flight planning/decision and his failure to execute a go-around. Contributing factors were the pilot's failure to attain alignment with the runway centerline, the runway light and the airport sign.NTSB SEA03CA162Accident · No injuriesData collectionFinal reportCessna R172K · Idaho Falls, IDThe pilot's failure to see and avoid a parked aircraft while taxiing.NTSB NYC03LA145Accident · No injuriesLimited investigationFinal reportMooney M20J · De Lancey, NYThe pilot's delayed decision to perform an aborted takeoff, which did not allow for sufficient room to stop. A factor was the grass runway.NTSB CHI03LA193Accident · No injuriesLimited investigationFinal reportCessna 172H · Plymouth, INThe collision with a deer during landing.NTSB NYC03LA135Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135-KL · Boston, MAThe tug driver's failure to maintain directional control of the tug, which caused the tug to impact the airplane.NTSB CHI03LA167Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Atwood, ILThe pilot's selection of an unsuitable landing area and his improper decision to continue the approach without the airport and runway clearly in-sight. Factors contributing to the accident were the pilot's disorientation, the transmission wires, and the road…NTSB CHI03LA156Accident · No injuriesLimited investigationFinal reportDromader M-18 · Dumas, ARThe pilot's delay in aborting the takeoff and his intentional maneuver to avoid the obstruction at the end of the runway. Contributing factors were the road and ditch.NTSB DEN03LA096Accident · No injuriesLimited investigationFinal reportEmbraer EMB-120ER · Denver, COthe ground personnel's failure to maintain aircraft/ground vehicle clearance, resulting in the collision. Contributing factors include ground communications not coordinated by the ground personnel and the airport vehicle.NTSB CHI03LA146Accident · No injuriesLimited investigationFinal reportGlasflugel Libelle 201B · Hampshire, ILThe unsuitable terrain encountered by the pilot during the off airport landing. A factor was the rock.NTSB LAX03LA167Accident · No injuriesLimited investigationFinal reportBoeing 757-223 · Santa Ana, CAthe vehicle driver's failure to deploy the parking brake or use wheel chocks to secure the vehicle prior to leaving it unattended.NTSB CHI03LA122Accident · No injuriesLimited investigationFinal reportCessna 182S · Hatton, NDFailure by the flight instructor to maintain clearance to the tree. Contributing factors were the delayed remedial action by the flight instructor and the tree.NTSB SEA03LA073Accident · No injuriesLimited investigationFinal reportPilatus B4-PC11AF · Enumclaw, WAThe pilot's failure to maintain directional control. Contributing factors were the crosswind/tailwind conditions and the trees which the glider impacted.NTSB MIA03LA100Accident · No injuriesLimited investigationFinal reportCessna 172P · Lantana, FLthe pilot's use of excessive airspeed and the improper touchdown point during the landing roll, which resulted in the airplane departing the runway, and impacting with trees.NTSB LAX03LA144Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bullhead City, AZThe pilot's misjudgment of distance resulting in the inadequate clearance between the wing tip and the fuel truck.NTSB LAX03LA149Accident · No injuriesLimited investigationFinal reportCessna 340A · Boulder City, NVthe airport committee members failure to repair or mark the faulty telephone junction box cover as a hazard. A factor in the accident was the inadequate notification process of the airport and city personnel.NTSB IAD03LA047Accident · No injuriesLimited investigationFinal reportCessna 170B · Randolph, NYThe pilot's failure to attain/maintain proper runway alignment. A factor in the accident was the sun glare.NTSB DEN03LA075Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Salt Lake City, UTthe pilot improperly aligning the airplane on the runway for takeoff. Contributing factors were the reduced visibility due to rain, and the dark night.NTSB ANC03LA043Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Anchorage, AKThe failure of the captain to maintain adequate clearance between the airplane's wingtip and a parked vehicle. A factor contributing to the accident was the failure of ground personnel to utilize a wing walker as prescribed in company policy when aircraft are…NTSB MIA03LA089Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Lakeland, FLThe inadequate visual lookout of the pilot and the ground marshaller resulting in the ground marshaller being struck by the wing of the taxiing airplane and receiving serious injury.NTSB DEN03LA057Accident · No injuriesLimited investigationFinal reportCessna 170A · Santa Rosa, NMthe pilot's failure to maintain directional control while taxiing for takeoff. A contributing factor was the wind gust.NTSB LAX03FA116Accident · 1 fatalField investigationFinal reportCessna 182G · Santa Maria, CAthe pilot's failure to maintain proper runway alignment during the takeoff ground roll, which resulted in the left wing contacting the brush lining the runway edge. The combined effects of the brush and tree contact retarded the airplanes acceleration and…NTSB SEA03LA047Accident · No injuriesLimited investigationFinal reportCessna 172M · Idaho Falls, IDThe student pilot's failure to maintain proper runway alignment (centerline tracking) during a go around maneuver resulting in the aircraft impacting a runway light. Contributing factors were the gusty/crosswind conditions and the light fixture.NTSB DEN03IA054Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120ER · Cedar City, UTthe captain's failure to maintain directional control during takeoff. Factors contributing to the accident were the crew's diverted attention, the snow and slush-covered runway, the fog, and the runway marker.NTSB NYC03LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mineral, VAThe flight instructor's delayed remedial action.NTSB NYC03LA053Accident · No injuriesLimited investigationFinal reportCessna 180 · East Windsor, CTThe pilot's failure to maintain directional control. A related factor was the snow-covered runway conditions.NTSB LAX03LA088Accident · No injuriesLimited investigationFinal reportCessna 421C · San Francisco, CAThe vehicle driver's inadequate visual lookout and failure to follow established procedures. A contributing factor was the dark nighttime condition.NTSB LAX03LA099Accident · No injuriesLimited investigationFinal reportAerostar International S-71A · Scottsdale, AZthe pilot's inadequate in-flight decision to cross over four sets of power lines with the existence of a known low fuel state and lack of wind, and failure to maintain altitude/clearance from the power lines during the landing, which resulted in the envelope…NTSB CHI03IA070Incident · No injuriesIncident investigationFinal reportCanadair CRJ-600 · Bloomington, ILThe pilot's improper in-flight decision to land on a runway with a tailwind component that exceeded the airplane's tailwind limitation and his failure to perform a go-around which resulted in the proper touchdown point not being attained and the airplane…NTSB CHI03LA065Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Waskish, MNThe inadequate preflight planning/preparation by the pilot. Contributing factors were the snow covered takeoff area and the tailwind.NTSB NYC03LA038Accident · No injuriesLimited investigationFinal reportCessna 150F · Crestline, OHThe pilot's improper decision to takeoff from unsuitable terrain. A factor related to the accident was the plowed, snow covered field.NTSB NYC03FA039Accident · Serious injuriesField investigationFinal reportBoeing 757-251 · Flushing, NYMaintenance personnel failure to maintain aircraft control as a result of excessive throttle input.