NTSB investigations, 2004
46 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\") = 2004
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") = 2004 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 NYC05LA038Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Providence, RIThe vehicle driver's failure to maintain directional control, which resulted in a collision with the airplane during push-back. A factor was the icy ramp area.NTSB NYC05LA025Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Philadelphia, PAThe failure of the ground controller to coordinate the runway crossing of a maintenance tug, with the local controller, which resulted in a ground collision with an MU-2 airplane during it's takeoff roll.NTSB IAD05CA019Accident · No injuriesData collectionFinal reportEmbraer EMB-135BJ · Cleveland, OHThe pilot in command's improper decision to continue taxi without a ground marshaller, and her misjudged clearance from a parked airplane, which resulted in a ground collision during taxi. Factors which contributed to the accident were fatigue, night…NTSB MIA05CA032Accident · Serious injuriesData collectionFinal reportCessna 172B · Zephyrhills, FLThe pilot's failure to set the parking brake and his improper starting procedure which resulted in an unattended aircraft running away after hand starting the engine and the airplane colliding with parked airplanes, incurring substantial damage.NTSB LAX05LA038Accident · No injuriesLimited investigationFinal reportBeech 99 · Phoenix, AZthe pilot's inadequate visual lookout and failure to maintain clearance from obstacles while taxing in a nonmovement area at night.NTSB IAD05CA014Accident · No injuriesData collectionFinal reportCessna 172S · Mansfield, MAThe pilot's improper decision to taxi on a closed taxiway, and his misjudgment of obstacle clearance.NTSB CHI05CA031Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Sikeston, MOThe pilot not maintaining his visual lookout and not maintaining clearance from the pole during his taxi to park from a landing. A factor was the pole he impacted.NTSB LAX05CA024Accident · No injuriesData collectionFinal reportChampion 7GCAA · Petaluma, CAthe pilot's failure to follow the published prestart, start, and shutdown procedures.NTSB NYC05LA013Accident · Minor injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Philadelphia, PAThe flightcrew's misjudged clearance from a parked airport vehicle while taxiing. A factor was the vehicle operator's improper decision to park within a taxiway safety area.NTSB MIA05CA014Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Valkaria, FLThe inadvertent collision with a deer during takeoff which resulted in damage to the right brake system and the airplane being unable to stop prior to the end of the runway.NTSB SEA05LA009Accident · Minor injuriesLimited investigationFinal reportCessna A185F · White Bird, IDThe pilot's failure to attain the proper airspeed for takeoff and his improper soft-field takeoff procedure. Factors contributing to the accident included the pilot's improper preflight planning, the fence, and the closed exhaust stack.NTSB NYC05CA007Accident · No injuriesData collectionFinal reportBeech A23 · New Market, VAA collision with a deer during the takeoff roll. A factor in the accident was the night.NTSB CHI05CA007Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Port Austin, MIThe pilot's excessive airspeed during landing resulting in the airplane exiting the end of the wet turf runway. Factors were the wind gusts, the wet grass, the reported airplane braking not being possible on the wet grass, and the impacted fence.NTSB ANC04CA114Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · Willow, AKThe pilot's selection of an unsuitable landing area, which resulted in an on-ground collision with trees during the landing roll. A factor associated with the accident were trees.NTSB CHI04CA281Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Jackson, MICollision with a deer when it crossed the airplane's path during landing rollout. Factors were low lighting (night) conditions and the pilot's inability to maintain directional control due to the collision.NTSB SEA04LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Seattle, WAThe failure of the pilot to maintain clearance with the parked airplane while taxiing. A factor contributing to the accident was the pilot's inadequate preflight planning.NTSB NYC04LA213Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Somerville, NJThe pilot's failure to maintain aircraft control while landing. A factor was the pilot's impairment due to the influence of non-prescribed pain medication.NTSB LAX04CA317Accident · No injuriesData collectionFinal reportPiper PA-32R-301 · Monterey, CAthe pilot's failure to maintain proper alignment with the taxiway and adequate obstacle clearance. A factor was the bright morning sunglare.NTSB ATL04CA184Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Mount Pleasant, SCGround collision with an animal (deer) during an attempted takeoff.NTSB ANC04LA100Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Cordova, AKThe pilot's failure to maintain an adequate visual lookout during taxi, which resulted in a collision with a runway marker sign. A factor contributing to the accident was sunglare in the pilot's eyes.NTSB IAD04LA043Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T1-A2 · Elkton, KYThe pilot's misidentification of the runway, which resulted in the airplane striking an obscured runway marker. Factors were the tailwheel airplane's reduced forward and lateral visibility during landing rollout and inadequate maintenance of the airport…NTSB LAX04LA299Accident · No injuriesLimited investigationFinal reportCessna 182G · Big Bear City, CAthe pilot's mistaken selection of an airport road as the landing runway. Factors in the accident were the nonstandard markings on the temporary landing surface and the glare from the setting sun.NTSB SEA04CA170Accident · No injuriesData collectionFinal reportCessna 180J · Pittsburg, ORThe pilot's failure to maintain clearance from an object (pole) during an aborted landing. The pilot's delayed decision to abort the landing and a pole were factors.NTSB LAX04CA296Accident · No injuriesData collectionFinal reportPilatus PC-12/45 · Show Low, AZthe collision with an elk during the landing roll. The dark night lighting conditions was a factor.NTSB FTW04CA193Accident · Serious injuriesData collectionFinal reportHead Balloons AX8-88 · Baton Rouge, LAThe pilot's selection of an unsuitable area for landing. A contributing factor was the high vegetation.NTSB DEN04CA111Accident · Minor injuriesData collectionFinal reportBell 206 L-1 · Escalante, UTthe pilot's failure to maintain aircraft control. Factors contributing to the accident were the high winds, the gusts, and the refueling truck.NTSB SEA04LA129Accident · No injuriesLimited investigationFinal reportLogston Starduster SA100DL · Arlington, WAThe pilot's failure to maintain clearance during taxi from another aircraft standing on the runway resulting in a collision. The aircraft standing on the runway was a factor.NTSB CHI04LA204Accident · No injuriesLimited investigationFinal reportAerostar S53H · Sioux Falls, SDThe pilot's selection of an unsuitable landing area for the balloon and his failure to maintain clearance with the transmission line. A contributing factor was the presence of the transmission line.NTSB ATL04TA142Accident · No injuriesFinal reportBell UH-1H · Childs, FLThe vehicle driver's inadequate visual lookout and his failure to maintain clearance. A factor was the lack of company standards and operation procedures.NTSB ATL04LA167Accident · No injuriesLimited investigationFinal reportCessna 172M · Winston Salem, NCThe pilot's failure to maintain clearance from the fence post, while taxing which resulted in a collision.NTSB NYC04IA152Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-114 · Manchester, NHThe Airbus captain's misjudged clearance, which resulted the left wing of the Airbus contacting the rudder of the stationary Canadair.NTSB SEA04LA112Accident · Serious injuriesLimited investigationFinal reportCosmos Phase II · Bandera, WAThe pilot's failure to maintain clearance from an airport sign during the landing roll. Inadequate compensation for the wind gust and the sign were factors.NTSB FTW04CA141Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Tarzan, TXThe pilot's failure to maintain proper airspeed suitable for flight. Contributing factors were the high density altitude and tail wind condition.NTSB LAX04CA208Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe backhoe driver's failure to maintain visual lookout while maneuvering near a taxiway, which resulted in its collision with a taxiing airplane.NTSB ATL04LA110Accident · No injuriesLimited investigationFinal reportCessna 150K · Monticello, GAThe pilot's failure to maintain clearance from trees during taxi from landing.NTSB LAX04CA196Accident · No injuriesData collectionFinal reportCessna 172N · Lincoln, CAthe pilot's failure to maintain obstacle clearance.NTSB FTW04LA114Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Seminole, OKThe pilot's inadequate pre-flight planning. A contributing factor was the pilot's use of unsuitable terrain for takeoff.NTSB FTW04LA118Accident · No injuriesLimited investigationFinal reportCessna 182U · Boerne, TXThe pilot's inattentive planned approach to land on a runway with obstructions.NTSB NYC04LA099Accident · No injuriesLimited investigationFinal reportBeech 1900D · Windsor Locks, CTThe fuel truck driver's failure to maintain clearance with a taxiing airplane, resulting in the collision between the fuel truck and the airplane. A factor in the accident was the night condition.NTSB FTW04LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Mamou, LAThe pilot's delay in aborting the landing. A contributing factor included the entrance of a crawfish boat onto the airstrip.NTSB CHI04CA092Accident · No injuriesData collectionFinal reportCessna 150J · Gardner, KSThe pilot's inadequate visual lookout and failure to maintain clearance from the post. A factor was the post.NTSB DEN04IA050Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-232 · Denver, COthe failure of the other flight crew to maintain clearance from the airplane and the ground crews failure to follow proper pushback procedures.NTSB CHI04LA077Accident · No injuriesLimited investigationFinal reportSaab-Scania Saab 340B · Romulus, MIThe visual lookout not maintained and the procedures not followed by the Push Tug Operator during the pushback. Factors were the parked airplane, the dark night, and the inadequate surveillance of the pushback by airline management.NTSB CHI04LA062Accident · No injuriesLimited investigationFinal reportCessna 172M · Jeffersonville, INThe pilot selecting a closed runway for landing and the collapse of the nose landing gear. Factors were the pilot's failure to obtain NOTAM information and the snowbank across the closed runway.NTSB LAX04CA099Accident · No injuriesData collectionFinal reportCessna 152 · San Diego, CAthe pilot's misjudgment of clearance from the vehicle while taxiing. A factor in the accident was the pilot's diverted attention.NTSB LAX04CA088Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Groveland, CAthe pilot's inadequate visual lookout, and his failure to maintain obstacle clearance. Factors to the accident were the parked vehicle, and the pilot's diverted attention.