NTSB investigations
1,695 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 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 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 SEA08CA052Accident · No injuriesData collectionFinal reportCessna 172S · Fullerton, CAThe pilot's failure to maintain clearance while taxiing. Contributing to the accident was the pilot's diverted attention.NTSB MIA08CA040Accident · No injuriesData collectionFinal reportAgusta A109 · ST. Augustine, FLThe pilot's failure to maintain a visual lookout while taxiing.NTSB LAX08CA039Accident · No injuriesData collectionFinal reportCessna 310R · Phoenix, AZThe pilot's selection of a wrong taxi route, inadequate visual lookout, failure to maintain separation from ground obstacles, and excessive taxi speed.NTSB CHI08LA051Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Chicago, ILThe tug driver's failure to yield the right-of-way to the airplane prior to crossing the active taxiway as required by airport procedures, and his subsequent failure to maintain clearance with the airplane. A contributing factor was the presence of the tug on…NTSB SEA08CA039Accident · No injuriesData collectionFinal reportPiper PA-18A-135 · Yelm, WAThe pilot's failure to maintain directional control of the tailwheel-equipped airplane during landing roll. Contributing factors were the rough/uneven terrain and log.NTSB MIA08CA012Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Tuscaloosa, ALThe pilot's failure to maintain a visual look out while taxing resulting in an on-ground collision with a parked airplane.NTSB LAX08CA019Accident · Minor injuriesData collectionFinal reportPloof Progressive Aerodyne's Searey · Lake Berryessa, CAThe airplane's encounter with a submerged object during landing in water, which resulted in the airplane nosing over.NTSB DFW08LA012Accident · Serious injuriesLimited investigationFinal reportFormhals RV-8 · San Antonio, TXThe automobile driver's failure to yield right-a-way to the airplane before crossing an active runway.NTSB CHI08CA009Accident · No injuriesData collectionFinal reportCessna Turbo Centurion T210 · Festus, MOThe deer on the runway during the airplane landing rollout.NTSB NYC08LA004Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Hartford, CTThe pilot's failure to maintain adequate clearance from a parked airplane while taxiing. Contributing to the accident was the proximity of the parked airplanes to the taxiway and the failure of the marshaller to provide adequate guidance.NTSB ATL07LA130Accident · No injuriesLimited investigationFinal reportDassault Mystere Falcon 900 · Teterboro, NJThe steamroller driver's improper decision to operate the vehicle without a wing walker present.NTSB SEA07CA258Accident · Minor injuriesData collectionFinal reportBell 206-B2 · Rosamond, CAThe pilot's inadequate compensation for gusting variable winds encountered after landing. Factors include gusting, suddenly shifting winds, and a hangar near the spot where the helicopter had landed.NTSB CHI07CA278Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Hagerstown, INThe pilot's use of an unsuitable runway for takeoff and delayed aborted takeoff. Factors were the wet grass and the fence the airplane impacted and subsequently nosed over.NTSB LAX07CA250Accident · No injuriesData collectionFinal reportCessna 182H · Page, AZthe pilot's failure to maintain clearance with obstructions while taxiing behind parked airplanes.NTSB CHI07CA270Accident · No injuriesData collectionFinal reportMooney M20J · Chesterfield, MOThe pilot failed to maintain directional control while taxiing after landing. A factor was the runway sign.NTSB CHI07CA253Accident · No injuriesData collectionFinal reportCessna 180A · Duluth, MNThe pilot's failure to maintain directional control, which resulted in impact with terrain during an attempted aborted landing. A factor in the accident was the geese impacted during the landing roll.NTSB CHI07FA243Accident · 1 fatalField investigationFinal reportBeck P-51A · Oshkosh, WIThe P-51A pilot's inadequate visual lookout and his failure to maintain clearance from the P-51D. Contributing factors to the accident included the restricted forward visibility of the P-51A, the air race team representative's inadequate flight brief, the…NTSB CHI07CA200Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lake in the Hil, ILThe pilot's failure to achieve a proper touchdown point and delayed decision to abort the landing. Factors contributing to the accident include the chain link fence and the trees.NTSB CHI07FA184Accident · No injuriesField investigationFinal reportBoeing 777-222 · Chicago, ILThe 777-222's flight crew not maintaining clearance from the parked/standing MD 83 and the airport not coordinating the taxi chart instructions with air traffic control. Contributing to the accident was the MD 83's flight crew not following the taxi chart…NTSB SEA07CA184Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA20-C1 · La Pine, ORThe pilot's selection of an unsuitable landing site for a precautionary landing. Contributing factors were the pilot's failure to refuel the airplane, the low fuel level, and trees.NTSB DFW07LA120Accident · 1 fatalLimited investigationFinal reportCessna U206G · Leeville, LAThe failure of the operator of the powerboat to maintain separation from the departing floatplane.NTSB NYC07CA122Accident · Minor injuriesData collectionFinal reportHanson Gerald Hanson Bucker 131E · Memphis, TNThe pilot's inadequate visual lookout that resulted in a collision with a lighting structure in the grass while landing. A factor in the accident was the pilot's intentional landing in the runway safety area.NTSB MIA07CA097Accident · Minor injuriesData collectionFinal reportPiper J3-C-65 · Byron, GAThe pilots failure to maintain directional control of the airplane during takeoff.NTSB LAX07CA157Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Mariposa, CAThe pilot's failure to maintain clearance from a vehicle while taxiing.NTSB NYC07CA115Accident · No injuriesData collectionFinal reportAeronca 7AC · Lagrangeville, NYThe pilot's failure to identify a partially buried rock in the landing surface of an unimproved grass runway, which resulted in an inadvertent collision during the landing roll.NTSB SEA07LA111Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Van Horn, TXClearance was not maintained after landing by the instructor pilot, which resulted in an on ground collision with the helicopter standing near the refueling pumps. The aircraft standing in the refueling area was a factor.NTSB DEN07LA090Incident · No injuriesLimited investigationFinal reportBeech 200 · Angel Fire, NMThe pilot's inability to maintain clearance from the snow bank. Contributing factors were the pilot's failure to perform a go-around/missed approach procedure after observing snow removal equipment on the runway, the pilot's improper in-flight planning and…NTSB ERA10CA112Accident · No injuriesData collectionFinal reportBellanca 7ECA · Calhoun City, MSThe pilot's failure to maintain clearance from a fallen tree located off the right side of the runway during takeoff.NTSB CHI07CA082Accident · No injuriesData collectionFinal reportCessna 172N · Pinckneyville, ILPresence of a deer on the runway resulting in an inadvertent collision during the landing roll.NTSB DFW07LA056Accident · No injuriesLimited investigationFinal reportCessna 172S · Tulsa, OKThe pilot's failure to maintain clearance from a hangar and parked airplane during the unauthorized use of an airplane.NTSB MIA07IA031Incident · No injuriesIncident investigationFinal reportBoeing 747-436 · Miami, FLThe flightcrew's misinterpretation of available lighting, signage, and airfield marking cues during taxi.NTSB ANC07LA008Accident · No injuriesLimited investigationFinal reportBoeing 747-228F · Anchorage, AKThe failure of the deicing truck crew to maintain sufficient distance from the parked airplane during deicing, which resulted in a collision and substantial damage to the airplane.NTSB CHI07CA033Accident · No injuriesData collectionFinal reportCessna C-425 · Menominee, MIThe pilot failed to maintain control of the aircraft while parking the aircraft, and failed to maintain clearance from the building as the airplane taxied forward. A factor was the terminal.NTSB NYC07CA050Accident · No injuriesData collectionFinal reportCessna 152 · Block Island, RIThe pilot's failure to maintain adequate clearance while taxiing, which resulted in a collision with a construction vehicle. A factor in this accident was the location of the construction vehicle, which was parked on the ramp, adjacent to the parking area.NTSB NYC07LA032Accident · No injuriesLimited investigationFinal reportColumbia LC41-550FG · Somerville, NJThe tug driver's inadequate lookout for landing traffic before crossing the runway.NTSB CHI07LA021Accident · No injuriesLimited investigationFinal reportBoeing 717-200 · Milwaukee, WIThe failure of ground personnel to verify the clearance between the airplanes prior to signaling the crew tha the crew of the other airplane that they were cleared to taxi.NTSB CHI07FA020Accident · No injuriesField investigationFinal reportAirbus A-320-200 · Chicago, ILThe pilot-in-command of the other airplane failed to maintain clearance with the parked airplane during taxi for takeoff.NTSB NYC07LA017Accident · No injuriesLimited investigationFinal reportBoeing 747-400 · Newark, NJThe failure of the Boeing 747 crew to maintain an adequate visual lookout. Contributing to the accident were the night lighting conditions, the back lighting from the apron lights, and the crew's diverted attention in focusing on a Boeing 757 that they were…NTSB DEN07CA011Accident · Minor injuriesData collectionFinal reportAdams A55S · Albuquerque, NMthe pilot's improper in-flight planning/decision. A contributing factor was the unfavorable wind.NTSB CHI07LA005Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Lake Village, INInadequate visual lookout by the pilot. A factor associated with the accident was that neither airplane was equipped with communications equipment.NTSB SEA07LA004Accident · No injuriesLimited investigationFinal reportCessna 182M · Boise, IDThe pilot's failure to maintain adequate clearance while taxiing. A contributing factor was the temporary construction fence next to the taxiway.NTSB SEA06CA180Accident · No injuriesData collectionFinal reportBeech B36TC · Cedar City, UTInadvertent collision with a deer during takeoff. A contributing factor was night conditions.NTSB LAX06TA291Accident · No injuriesFinal reportCessna U206G · Wasco, CAThe pilot's improper decision in leaving the engine running while he left the airplane unattended.NTSB CHI06CA254Accident · No injuriesData collectionFinal reportAir Tractor AT-400A · Alliance, NEThe pilot's inadequate preflight inspection which led to the aircraft tow bar not being removed prior to flight.NTSB NYC06CA212Accident · No injuriesData collectionFinal reportPiper PA 38-112 · Chesapeake, VAThe presence of deer on the runway during the landing roll, which resulted in a collision. A factor in the accident was the dark night.NTSB DFW06LA197Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Ozona, TXThe pilot's selection of an unsuitable terrain for landing. A contributing factor was the lack of suitable terrain.NTSB CHI06FA206Accident · 1 fatalField investigationFinal reportGrumman TBM-3 · Oshkosh, WIThe Avenger pilot's visual lookout was inadequate and he failed to maintain clearance from the RV-6. Contributing factors were the Avenger's restricted visibility and the RV-6.NTSB CHI06CA204Accident · Minor injuriesData collectionFinal reportCessna 172N · Wadsworth, OHThe pilot used an improper aborted takeoff procedure in that she failed to reduce the engine power. Factors associated with the accident were the tailwind, the wrong runway selection, the pilot's lack of experience, the guard rail, and the embankment.NTSB ATL06LA111Accident · 1 fatalLimited investigationFinal reportCanadair F86 · Hickory, NCThe pilot's improper assembly of the airplanes brakes, exceeding the authorized gross weight of the airplane at takeoff, and the pilot's failure to abort the takeoff in sufficient time to avoid an on-ground collision with fixed objects. A factor in the…NTSB CHI06CA181Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Indianapolis, INThe failure of the tug driver to maintain clearance from the airplane taxiing on an active taxiway. A factor was the night conditions.