NTSB investigations, 2002
63 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\") = 2002
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") = 2002 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 MIA03CA037Accident · No injuriesData collectionFinal reportPiper PA-30 · Tallahassee, FLthe pilot's improper start procedure which resulted in an unintentional engine start, and unoccupied aircraft collision with hangar structure.NTSB SEA03LA010Accident · No injuriesLimited investigationFinal reportLearjet 36A · Astoria, ORCollision with an elk during the takeoff roll. Factors include dark night VFR conditions.NTSB ATL03LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Eastman, GAThe pilots failure to maintain a visual lookout resulting in the subsequent on ground collision with a hangar.NTSB MIA03CA063Accident · No injuriesData collectionFinal reportConsolidated Aeronautics LA-4-200 · Blountstown, FLThe failure of the certified flight instructor (CFI) to maintain clearance between the wingtip and a water marker bouy resulting in contact with the wingtip.NTSB ANC03LA017Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chenega Bay, AKThe pilot's selection of unsuitable terrain for landing and his failure to maintain obstacle clearance which resulted in the airplane colliding with a tree and a berm.NTSB ATL03LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fayette, ALThe pilot's poor inflight decision to land on a non illuminated runway, and the pilot's failure to maintain clearance during an attempted night landing that resulted in an on ground collision with a parked car. A factor was the light condition.NTSB CHI03FA014Accident · Minor injuriesField investigationFinal reportBombardier CL-600-2B19 · Chicago, ILThe driver of the bus not maintaining clearance from the taxiing airplane.NTSB ANC03CA006Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain proper alignment on the taxiway and clearance from the taxiway edge lights while taxiing from landing. A factor contributing to the accident was sun glare.NTSB CHI03LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Neenah, WIThe pilot failed to maintain clearance from the post. Factors included the post and the sun glare.NTSB NYC03LA007Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR-20 · Point Pleasant, WVAn inadvertent collision with wildlife. A factor in the accident was wildlife having access to the runway environment.NTSB FTW03LA010Accident · No injuriesLimited investigationFinal reportBeech K35 · Flippin, ARThe pilot's selection of an unsuitable landing area. A contributing factor was the pilot's disorientation.NTSB LAX03LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · San Luis Obispo, CAThe pilot's failure to maintain obstacle clearance due to her inadequate visual lookout.NTSB SEA03LA003Accident · No injuriesLimited investigationFinal reportMooney M20K · Rexburg, IDThe pilot's failure to perform a go-around once it became evident that his remedial action was not adequate to overcome the porpoise/pilot-induced oscillation that occurred during the landing flare. Factors include the pilot's inadvertent repeated…NTSB DEN03LA003Accident · No injuriesLimited investigationFinal reportCessna 172P · Broomfield, COthe pilot misjudging the clearance between the airplane and a fixed object during taxi. Contributing factors were the pilot's attention being diverted and sunglare.NTSB ATL02LA172Accident · No injuriesLimited investigationFinal reportCessna 172P · Lutz, FLThe pilot's failure to maintain visual lookout and clearance during taxi, which resulted in an on-ground collision with a building.NTSB CHI02CA279Accident · Serious injuriesData collectionFinal reportCessna 120 · Brookfield, WIThe inadequate visual outlook by the pilot during taxi.NTSB ANC02LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikolai, AKThe pilot's selection of unsuitable terrain while taxiing for takeoff, which precipitated an on ground collision with a tree stump. Factors contributing to the accident were soft terrain and the presence of tree stumps.NTSB ANC02LA115Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Tenakee Springs, AKThe pilot's misjudgment of the airplane's speed/distance from a dock resulting in the airplane drifting into a wooden piling during a taxi from landing. A factor in the accident was the presence of a tidal current.NTSB CHI02LA264Accident · No injuriesLimited investigationFinal reportCessna 182S · Fishers, INThe pilot failed to maintain clearance with the light pole while taxiing. A factor was the light pole.NTSB CHI02LA266Accident · No injuriesLimited investigationFinal reportSchweizer SGS-126E · Ionia, MIThe pilot's failure to maintain clearance from the runway end identifier light (REIL). A factor to the accident was the REIL.NTSB ANC02LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chickaloon, AKThe pilot's failure to maintain clearance from ground obstructions while taxiing. A factor contributing to the accident was excessive taxi speed.NTSB LAX02LA261Accident · Minor injuriesLimited investigationFinal reportAB Sportine Aviacija Genesis 2 · Orland, CAthe loss of thermal lift during flight.NTSB FTW02LA238Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Rosenburg, TXthe failure of the pedestrian to perform a visual lookout while walking on the runway which resulted in a on-ground collision with the airplane.NTSB NYC02LA172Accident · No injuriesLimited investigationFinal reportCessna 500 · Sandusky, OHA collision with a deer during a night takeoff.NTSB IAD02LA085Accident · No injuriesLimited investigationFinal reportCessna 172N · Williamsport, PAThe student pilot's failure to maintain adequate clearance from a building while taxiing.NTSB ATL02LA152Accident · No injuriesLimited investigationFinal reportCessna 150 · Lakeland, FLThe pilot's failure to maintain a visual lookout while taxiing to parking resulting in an on-ground collision with a pole. A related factor was the diverted attention to the lineman.NTSB SEA02LA143Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Quincy, WAThe pilot's failure to maintain the proper descent rate during the descent for landing. A proper glide path was not attained, inadequate remedial action, and a fence were factors.NTSB SEA02LA148Accident · No injuriesLimited investigationFinal reportCessna 180 · Cascade, IDThe pilot's failure to maintain directional control during the takeoff ground run. Wind gusts and a tree were a factor.NTSB NYC02LA146Accident · No injuriesLimited investigationFinal reportSaab-Scania 340A · Charleston, WVThe vehicle driver's failure to maintain clearance of the airplane.NTSB ANC02LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Dillingham, AKThe pilot's selection of an unsuitable area for taxiing, which resulted in running the airplane's float aground. Factors contributing to the accident were the hidden obstructions underwater, and the excessive taxi speed.NTSB FTW02LA199Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Houston, TXThe pilot's failure to maintain clearance with the parked vehicles. Factors contributing to the accident were the airport's failure to properly identify the construction area, their failure to publish a notice to airmen.NTSB CHI02LA173Accident · No injuriesLimited investigationFinal reportBeech BE90 · Roseau, MNAn inadvertent collision with a deer during the landing roll.NTSB CHI02LA175Accident · No injuriesLimited investigationFinal reportCessna 172N · Minneapolis, MNThe pilot did not maintain clearance from the vehicle while taxiing. A factor was the fuel truck.NTSB NYC02LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsburgh, PAThe student pilot's failure to maintain adequate clearance while maneuvering to avoid obstructions.NTSB CHI02LA162Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Beaumont, KSThe pilot's inadequate preflight planning and his failure to abort the takeoff when he realized the aircraft was not accelerating as expected. The wet and muddy turf runway was a contributing factor.NTSB FTW02LA166Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Nageezi, NMthe pilot's failure to select a suitable landing site, which resulted in a collision with a fence.NTSB SEA02LA080Accident · No injuriesLimited investigationFinal reportAeronca 7-EC · Flying M Ranch, ORThe pilot's failure to maintain directional control while applying the brakes during the landing roll. Factors include a tailwind and trees at the far end of the airstrip.NTSB CHI02LA128Accident · No injuriesLimited investigationFinal reportBoeing 757-33N · Chicago, ILThe ground personnel handled the aircraft improperly during pushback from the gate by failing to maintain clearance with the other parked aircraft. The light rain and the parked airplane that was contacted were factors.NTSB ANC02LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairbanks, AKThe pilots improper starting procedure. Factors associated with the accident are the continued operation of the airplane with a known mechanical deficiency, and failure to use wheel chocks and/or tie-down rope/straps to restrain the airplane during the engine…NTSB CHI02LA126Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Sandwich, ILThe driver of the automobile improperly drove his automobile on the active runway and did not maintain visual lookout for landing aircraft.NTSB NYC02LA096Accident · No injuriesLimited investigationFinal reportBeech 400 · Cleveland, OHIngestion of birds into both engines.NTSB LAX02LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Sacramento, CAFailure of the pilot to ensure the seat was set properly prior to engine start, and not using the parking brake when adjustment of seat was necessary, which resulted in the inadvertent deactivation of the brakes and subsequent collision with the fuel trucks.NTSB FTW02LA127Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Bogalusa, LAa deer that ran in front of the airplane during the takeoff phase. A contributing factor was the lack of an airport perimeter fence to prevent deer from entering the runway environment.NTSB MIA02LA087Accident · No injuriesLimited investigationFinal reportCessna 172H · Ehrhardt, SCthe pilot's failure to attain proper touchdown point while landing on a wet grass runway, resulting in the airplane departing the runway and impacting with trees.NTSB NYC02LA081Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Louisa, VAThe airplane's inadvertent collision with a deer while landing at night. A factor in the accident was the night condition.NTSB LAX02LA126Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Goodyear, AZThe student pilot's misjudgment of clearance and his failure to adhere to the flight school's policy/procedures for taxiing around obstructions.NTSB CHI02LA115Accident · No injuriesLimited investigationFinal reportCessna 551 · Lake in Hills, ILThe deer on the runway.NTSB FTW02LA094Accident · No injuriesLimited investigationFinal reportCessna 402C · Albuquerque, NMThe failure of the tug driver to stop at the stop sign resulting in a collision with a taxiing airplane. A contributing factor was the dark night light conditions.NTSB CHI02LA090Accident · No injuriesLimited investigationFinal reportCessna 182J · Springfield, ILThe pilot not maintaining clearance from a fence while taxiing. The fence was a factor.NTSB DCA02MA026Accident · No injuriesMajor investigationFinal reportCanadair CL-600-2B19 · Dulles Airport, VAthe airplane's collision with two wild turkeys.