NTSB investigations, 2001
60 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\") = 2001
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") = 2001 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 SEA02LA017Accident · No injuriesLimited investigationFinal reportCessna 172N · Snohomish, WAThe student pilot misjudged the distance from a fence during taxi. The flight instructors inadequate supervision and the fence were factors.NTSB FTW02LA065Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Paris, TXthe failure of the pilot of the other aircraft to maintain adequate visual lookout during taxi.NTSB MIA02LA024Accident · No injuriesLimited investigationFinal reportCessna 172M · Crystal River, FLthe pilot's failure to keep a proper visual lookout and ensure proper clearance during taxi operations, which resulted in a collision with vehicles.NTSB IAD02LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Coatesville, PACollision with a deer during the takeoff roll.NTSB NYC02LA023Accident · No injuriesLimited investigationFinal reportBeech 1900C · Bar Harbor, MEA deer, which had been crossing the runway as the airplane touched down. A factor was the dark night conditions.NTSB MIA02LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Marco Island, FLthe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane departing the runway, impacting with a windsock, and nosing over in soft terrain.NTSB DEN02LA006Accident · No injuriesLimited investigationFinal reportPilatus PC-12 · Casper, WYThe pilot's failure to maintain clearance from another parked airplane while taxiing. Contributing factors were the night light conditions, and the pilot's fatigue from a long day.NTSB LAX02LA014Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Mesa, AZThe pilot's inadequate compensation for an existing crosswind condition, and failure to maintain directional control on the landing rollout.NTSB ATL02LA007Accident · No injuriesLimited investigationFinal reportNorth American SNJ-6 · Kissimmee, FLSee narrative for ATL02LA007A.NTSB FTW02LA012Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Albuquerque, NMthe pilot's failure to maintain clearance with a power line during landing. A contributing factor was the high wind during the landing.NTSB FTW02LA013Accident · Serious injuriesLimited investigationFinal reportAerostar International S81A · Albuquerque, NMthe selection of an unsuitable landing area by the pilot. A contributing factor was the high wind during the landing.NTSB MIA01LA233Accident · No injuriesLimited investigationFinal reportBeech A45 · Eatonton, GAThe inadvertent sliding of the airplane on tall grass when the pilot aborted takeoff and the swerved the airplane to the left of the runway to avoid deer which had walked onto the runway, resulting in the airplanes left wing contacting a tree.NTSB ANC01LA143Accident · No injuriesLimited investigationFinal reportCessna U206 · Paxson, AKThe pilot's failure to maintain clearance from a sign while taxiing after landing in mixed rain and snow. Factors associated with the accident are reduced visibility conditions due to the snow and rain.NTSB SEA01LA171Accident · No injuriesLimited investigationFinal reportCessna 172M · Seattle, WAPilot's failure to maintain an adequate visual lookout during taxi. A fence was a factor.NTSB MIA01LA228Accident · No injuriesLimited investigationFinal reportCessna 172R · Orlando, FLthe pilot's failure to keep a proper visual lookout and ensure proper clearance during taxi operations, which resulted in a collision with another parked aircraft.NTSB IAD01LA104Accident · No injuriesLimited investigationFinal reportCessna 172P · Augusta, METhe pilot's failure to maintain the proper distance from a sign post during taxi.NTSB CHI01LA301Accident · No injuriesLimited investigationFinal reportCessna 150L · Madison, WIThe deer which struck the empennage of the airplane during the landing flare.NTSB CHI01FA270Accident · No injuriesField investigationFinal reportBoeing 717-200 · Mascoutah, ILThe malfunction of the nose gear extension system, which resulted from a previous ground collision with a wheel chock. A factor was the wheel chock.NTSB MIA01LA209Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Statesville, NCThe pilot's attempted takeoff with a tail wind and his failure to maintain directional control of the airplane during takeoff resulting in the airplane veering to the left and colliding with trees.NTSB MIA01LA200Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ocala, FLthe pilot's improper planning/decision and failure to properly judge takeoff distance, and his delayed decision to abort the takeoff, which resulted in the aircraft colliding with a fence at the end of the runway, and incurring substantial damage.NTSB CHI01LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Jeffersonville, INThe airplane was struck by deer during landing roll at night. A factor was the dark night.NTSB MIA01LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Orlando, FLthe pilot's improper visual lookout, which resulted in the aircraft colliding with a fence.NTSB ANC01LA090Accident · No injuriesLimited investigationFinal reportCessna 185 · Yakutat, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with the accident were trees.NTSB IAD01LA084Accident · No injuriesLimited investigationFinal reportCessna 152 · Gallipolis, OHcollision with a deer during take-off roll.NTSB NYC01LA183Accident · No injuriesLimited investigationFinal reportBeech BE-36 · Biddeford, METhe pilot's inadequate preflight inspection, which resulted in an attempted takeoff with a control column lock installed.NTSB LAX01LA257Accident · No injuriesLimited investigationFinal reportCessna 185F · Visalia, CAThe pilot failed to maintain clearance from crops which bordered the narrow runway.NTSB ANC01LA103Accident · No injuriesLimited investigationFinal reportCessna 207 · Pilot Point, AKThe pilot's selection of an unsuitable takeoff area, and failure to maintain clearance. A factor associated with the accident was a vehicle mounted gantry.NTSB SEA01LA134Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Oregon City, ORThe front seat (pilot-in-command's) inadequate visual lookout during step taxi resulting in the aircraft's collision with a partially submerged log. A contributing factor was the log and it's lack of any conspicuous marking.NTSB LAX01LA246Accident · No injuriesLimited investigationFinal reportMooney M20J · Las Vegas, NVThe pilot's inadaquate visual lookout and failure to maintain proper clearance from an object. A factor was the pilot's distraction by a conversation with ground control.NTSB NYC01LA165Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Plymouth, MAThe pilot's failure to ensure the magnetos were off prior to rotating the propeller, which resulted in an unintentional engine start and subsequent unmanned taxi.NTSB NYC01LA157Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrenton, VAThe airplane's encounter with a deer during a touch and go.NTSB LAX01LA226Accident · No injuriesLimited investigationFinal reportMooney M20C · Tucson, AZThe airplane's collision with a perimeter roadway vehicular traffic sign due to the pilot's diverted attention and inadequate visual lookout while taxiing from landing. A contributing factor was the lack of sign conspicuity.NTSB MIA01LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Tampa, FLThe pilot's failure to maintain a visual look out while taxing an airplane for parking resulting in an on ground collision with a fixed object (Hangar/Building.)NTSB CHI01LA188Accident · No injuriesLimited investigationFinal reportAyres S2R-G1 · Mohall, NDthe pilot not maintaining clearance between the airplane and the truck when he backed the airplane off of the loading pad. Factors relating to this accident was the pilot's inadequate visual lookout and the truck.NTSB CHI01LA174Accident · No injuriesLimited investigationFinal reportSmith Aerostar 600 · Wonewoc, WIThe deer on the runway as the airplane was landing.NTSB MIA01LA160Accident · No injuriesLimited investigationFinal reportCessna 182S · Corolla, NCThe pilots failure to maintain directional control during landing flare and touchdown resulting in the airplane touching down on the left side of the runway and the left wing contacting trees.NTSB FTW01LA141Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Marvell, ARthe improper decision of the driver of the vehicle(ATV) to enter an active airstrip.NTSB ANC01LA067Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Minto, AKThe pilot's selection of unsuitable terrain for takeoff, and an excessive descent rate resulting in a hard landing during an aborted takeoff. Factors in the accident were a collision of the airplane's float assembly with an unknown object, and the pilot's…NTSB CHI01LA145Accident · 1 fatalLimited investigationFinal reportBell Helicopter 407 · Schoolcraft, MIThe pilot rated passenger failed to maintain clearance with the rotor blades as he exited the helicopter.NTSB FTW01LA126Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Tulsa, OKthe dual student pilot's failure to maintain clearance from the hangar while taxing.NTSB ANC01LA064Accident · No injuriesLimited investigationFinal reportCessna 172P · Anchorage, AKThe pilot's selection of an unsuitable taxi area during taxi. A factor associated with the accident was a tree.NTSB LAX01LA172Accident · No injuriesLimited investigationFinal reportBell 206B · San Diego, CAthe failure of the ground personnel to maintain clearance between two aircraft on the ramp, while one airplane was taxiing and the other was standing with the engine running and rotor blades turning.NTSB LAX01LA175Accident · No injuriesLimited investigationFinal reportAviat A-1A · TontoNat.Forest, AZThe pilot's inadequate crosswind correction compensation during landing and his failure to maintain proper alignment with the usable runway. A contributing factor was the presence of bushes in proximity to the airstrip.NTSB SEA01LA091Accident · No injuriesLimited investigationFinal reportLet L-23 · Arlington, WAthe flight instructor's improper decision to partially retract the spoilers while the student was attempting to land. Factors include a tailwind, wet grass, and a taxiway sign off the end of the landing area.NTSB CHI01FA129Accident · Minor injuriesField investigationFinal reportDouglas DC-9-31 · Minneapolis, MNThe partial failure of the aircraft tug for undetermined reasons.NTSB MIA01LA135Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Greenville, SCThe failure of the pilot to obtain the assistance of a person to act as a safety pilot while hand propping the engine with the airplane tied down. A factor in the accident was the failure of the tie down rope.NTSB LAX01LA159Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Murrieta, CAThe failure of the pilot to maintain an adequate visual lookout during taxi to avoid striking a post. A factor in the accident was the inadequate marking of the obstruction by airport personnel.NTSB ANC01TA048Accident · No injuriesFinal reportde Havilland DHC-2 · Anchorage, AKA failure of the pilot to maintain adequate distance/clearance from a cement barricade while taxiing into a parking spot after landing. A factor was the presence of a barricade adjacent to the parking spot.NTSB CHI01LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Culver, INthe CFI delayed remedial action during the takeoff. Additional factors were the wrong runway was selected, the tailwind, and the trees.NTSB NYC01LA094Accident · No injuriesLimited investigationFinal reportBoeing 767-200ER · Boston, MAThe Boeing 767 captain's misjudgment of the distance between his airplane and the stationary Boeing 737, which resulted in a ground collision. A factor was sunglare.