NTSB investigations
1,695 cases where the first occurrence was “On ground/water collision with object”.
Cases, newest first
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 LAX85LA046Accident · No injuriesLimited investigationFinal reportMooney M20J · Tulelake, CAThe plt stated that he was conducting touch and go landings on a road when the left wing struck a 4X4 in wooden speed limit sign post.NTSB ANC85LA029Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Chandalar, AKThe plt reported that the acft hit a wooden sign post and ground looped during takeoff. The acft came to rest about 100 yards from the starting takeoff point.NTSB NYC85LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Waterford, CTN3772M (acft 'a') was on lndg roll on runway 15 when N19091 (acft 'b') initiated taxi across the runway. Acft 'a' swerved to avoid collision but inadequate clrnc was available. Right wing of acft 'a' collided with left wing of acft 'b'. Plt of acft 'b' stated…NTSB MIA85LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Gainesville, FLThe acft collided with a tractor during taxi. The plt stated that he saw the tractor and thought there was room to pass.NTSB DEN85LA023Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Denver, COAccording to the pilot, the acft was taxiing to park when a small truck was seen approaching from the right about 50 ft away. After realizing that the vehicle driver did not see the acft the pilot reduced power to idle and applied the brakes. The truck driver…NTSB LAX85IA037Incident · No injuriesIncident investigationFinal reportBoeing 747-131 · Los Angeles, CADuring darkness, a Boeing 747, N93106, was being taxied for departure when its left wing collided with the right wing of a Boeing 767 being towed in the same direction on a parallel taxiway. Both crews had obtained ground control clearances to perform their…NTSB LAX85LA033Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lower Lake, CAThe plt reported that he originally planned to start the acft eng in order to charge the battery. The eng started using the acft starter so the plt decided to fly. He set the parking brake & with the eng running at a 'fast idle', exited the acft, intending to…NTSB FTW85LA023Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Kilgore, TXAfter taxiing north to the end of the strip a 180 deg turn was made prior to takeoff to the south. Out of the turn the acft was lined up with the left wing tip close to the fence. The plt intended to correct his line-up during the roll. According to the plt,…NTSB SEA85LA010Accident · No injuriesLimited investigationFinal reportCessna C-207 · Juneau, AKThe right wing of N70076 contacted the spinning propeller of a PA-32-300 while taxiing from the ramp area to the active rwy. Plt stated he was checking the clearance on the left side of the acft and once viewing the PA-32-300 it was too late for the remedial…NTSB DEN85FA002Accident · 3 fatalField investigationFinal reportHamburger Flugzeugbau Hansa HFB-320 · Aberdeen, SDThe hansa jet HFB-320 acft crashed on takeoff from the Aberdeen airport after the flt crew selected the incorrect rwy for takeoff. The acft was observed running off the end of rwy 17, which is 3860 ft long, where it struck a fence, ditch, road & another ditch…NTSB FTW85LA004Accident · No injuriesLimited investigationFinal reportCessna A185E · Morgan City, LAPlt arrived at intended lndg site on remote pipeline canal where quarter boat was operating, overflew site and visually checked conditons. After 100-150 yds of landing roll, the right float struck a submerged object. Float filled with water and acft rolled…NTSB FTW84LA409Accident · No injuriesLimited investigationFinal reportCessna 172P · Lancaster, TXWitnesses reported that the acft was taxiing fast and failed to clear the row of parked acft. The left wing contacted the tail of a parked Cessna 177, which was destroyed by impact and propeller damage as the taxiing acft swung into it.NTSB ATL84LA299Accident · No injuriesLimited investigationFinal reportCessna 182H · Murray, KYThe pilot stated that during taxi from landing, the left wing tip of the aircraft struck the corner of the main hangar building. Daylight hours, clear weather and dry ramp area conditions existed at the time.NTSB SEA84LA230Accident · No injuriesLimited investigationFinal reportCessna R-182 · Mountain Home, IDThe pilot was landing on a road to visit friends when the acft collided with a gate during the roll. The pilot had originally intended to land at a nearby municipal arpt after flying over the friends house. Due to the close proximity of Mountain Home air…NTSB FTW84LA401Accident · No injuriesLimited investigationFinal reportPitts S-T1 · Rockwall, TXThe pilot reported that the rwy was clear when he turned on final. Once on final forward visibility is limited and the pilot did not see the cow until the acft collided with it. The airport manager was aware of the problem of cattle wondering onto the rwy but…NTSB ANC84LA183Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Anchorage, AKWhile taxiing for takeoff the aircraft's left wing struck a duck shack.NTSB FTW84LA394Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Spicewood, TXDespite the existence of an airstrip across the street from his home, the plt elected to takeoff & land on the street. During the landing, the acft hit several trees & a pump house. Local law enforcement officers reported that the plt was drunk and drinking…NTSB LAX84LA503Accident · No injuriesLimited investigationFinal reportCessna 172N · Hayward, CAWhile taxiing to rwy 28 on the taxiway the acft was overtaken by a vw bus which hit the acfts left wing.NTSB BFO84IA005Incident · No injuriesIncident investigationFinal reportBoeing 727-22 · Washington, DCMishap acft, new york air flight 306 (nya 306) followed a Boeing 727, united flight 827 (ual 827), to the run-up area and positioned in the #2 spot for takeoff, anticipating ual 827 would receive takeoff clearance first. Nya 306 was cleared first for takeoff…NTSB NYC84LA299Accident · No injuriesLimited investigationFinal reportBeech A23A · Mansfield, MAAfter a night landing, the plt went to the end of the rwy, then started a 180 deg turn to the right onto a parallel taxiway. He intended to head the opposite direction on the taxiway, which was not lighted. As he turned, the landing light (installed on the…NTSB MIA84LA243Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Miami, FLWhile taxiing for takeoff the acft veered to the left and collided with a parked acft. The plt stated a gust of wind caused the acft to veer. The acft operator reported the plt was helping the pax with a seatbelt when the accident occurred.NTSB ANC84LA151Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Bettles, AKThe acft collided with an overhanging tree branch during a river takeoff. The plt was trying to negotiate a bend in the river while on the 'step' for takeoff. The plt said he had very limited experience in the model acft and it got light on the floats and…NTSB LAX84LA465Accident · No injuriesLimited investigationFinal reportMooney M-20G · San Jose, CAThe rwy was closed during working hours due to a construction company working in the area. When the construction effort ended the rwy was opened for use. After tower clearance was issued the acft landed and contacted a barricade with the left wing. The pilot…NTSB FTW84LA373Accident · No injuriesLimited investigationFinal reportCessna 172M · Bethany, OKAccording to the plt of N9646H, while he was taxiing under the direction of ground control the acft was struck from behind by N1PN. The plt of N1PN stated that he was cleared to taxi and did not see any other acft as he entered the taxiway. Seated in the rear…NTSB FTW84LA369Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Austin, TXAfter lndg the plt exited the acft to assist deplaning of the pax. The engine was still running. The plt heard a surge of engine power followed by the acft rotating and colliding with a parked car. Examination of the acft disclosed that the collective balance…NTSB MIA84LA235Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe tailwheel equipped acft collided with a stopped Cessna while taxiing to takeoff. The Cessna was in the runup area. The Boeing A75 acft plt said he failed to see the parked acft.NTSB ATL84LA265Accident · No injuriesLimited investigationFinal reportCessna 150D · Parkersburg, WVThe pilot was unable to see the deer on the rwy during the landing roll because of the dark night conditions.NTSB LAX84IA448Incident · No injuriesIncident investigationFinal reportCessna 172 · Redding, CAPlt briefed pax on use of brakes so he could hand prop acft. Plt stated, the acft 'got away from the passenger' when the engine started. Acft contacted a parked acft and a hangar before stopping.NTSB DEN84LA257Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Cheyenne, WYFollowing an uneventful solo flight the student plt began to follow a parking vehicle to a parking spot. The spot that the parking vehicle driver selected necessitated that the acft execute a 180 deg turn just priop to stopping. During this turn the right…NTSB LAX84LA441Accident · No injuriesLimited investigationFinal reportBell P-63C-5-BE · Madera, CAThe plts of a Bell P-63 (king cobra), N62822 & a north American P-51 (mustang), N65206, were participating in an air- show when the acft collided during landing. An investigation revealed the P-63 plt had made a 360 overhead pattern before landing. At about…NTSB ATL84LA257Accident · No injuriesLimited investigationFinal reportCessna 177RG · Shelbyville, TNThe acft collided with a parked truck on a taxiway en route to takeoff. The plt said he observed the parked truck on thetaxiway. There was another taxiway available but the plt continued on the congested one with the acft wing overlapping the truck by about 7…NTSB MKC84LA239Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mount Vernon, MOThe acft rolled foward and collided with a metal hanger after the plt hand propped the acft to start it. The acft was tied at the tail and chocked with the plts oldest daughter on the foot brakes. In spite of these precautions the acft got away and hit the…NTSB CHI84LA325Accident · No injuriesLimited investigationFinal reportCessna 182-C · Akron, OHA Cessna 182 on takeoff on rwy 19 collided with a Piper PA34 landing on rwy 25. Each plts view of the other was obstructed by airport parking at one point during the mishap. The airport tower was closed. The pilot of the Cessna left the UNICOM frequency for…NTSB NYC84LA252Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mansfield, MAN49985 landed on rwy 32 and turned off rwy at midfield intersection. Acft came to full stop to retract flaps and turn off carb heat. Plt stated a check for other traffic who made at this time. Student plt began taxiing to ramp with landing light off, nav…NTSB DEN84LA233Accident · No injuriesLimited investigationFinal reportCessna A188B · Stratford, SDPlt stated that he was taking off on this flight with 120 gallons of chemical and full fuel tanks. He continued to state that the acft did not accelerate as it had earlier that day. The acft rolled aprx 3 quarters of the 1/2 mile long rwy before it became…NTSB CHI84LA307Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Huntley, ILThe plts of a Boeing A75, N55070, & a vultee BT-13, N176VR, where in formation as they apchd their destination. When the saw the arpt, they separated for separate landings & lost sight of each other. Before landing, both plts flew over the arpt & noted the…NTSB FTW84LA307Accident · No injuriesLimited investigationFinal reportCessna 152 · Eufaula, OKWhile taxing from landing the plt was watching the clearance on the left side of the acft and the right wing contacted an unmarked utility pole.NTSB SEA84LA169Accident · No injuriesLimited investigationFinal reportCessna 172NII · Hillsboro, ORWhile taxing on a ramp area the plts attention was diverted to adjusting the transponder code. The left wing of the acft contacted a moving fuel truck.NTSB CHI84LA273Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Hamilton, OHThe plt stated he landed long and fast and during an attempted go-around collided with a parked acft near the end of the grass strip.NTSB ANC84LA107Accident · No injuriesLimited investigationFinal reportMaule M-5 · Anchorage, AKThe plt reported that when he landed on campbell lake, the left float hit a submerged object. The acft then yawed to the left, banked to the right & went over on its top. Campbell lake was used as a private sea-plane base & was located within the city limits…NTSB MKC84LA187Accident · No injuriesLimited investigationFinal reportCessna 172N · Gainsville, MOThe pilot was taxiing the aircraft back to his hangar. Upon reaching the hangar he made a 180 degree turn to position the aircraft so he could push it backwards into the hangar. During the turn the left wing impacted a pole.NTSB FTW84LA275Accident · No injuriesLimited investigationFinal reportCessna A185F · New Iberia, LAWhile decelerating after landing one of the floats contacted a submerged object. Directional control was lost, acft veered to left and collided with a tree on the bank.NTSB ANC84FA092Accident · Minor injuriesField investigationFinal reportMaule M-5-235C · Anchorage, AKThe acft traveled forward into a parked acft after the plt hand propped it to start the engine. A pax who had 'a few hours', according to the plt, was inside the acft to hold the foot brake pedals. The plt said the battery was too low tostart the acft engine…NTSB SEA84LA134Accident · No injuriesLimited investigationFinal reportHughes 369D · Wrangell, AKThe helicopter was parked with the eng running when it was struck by another acft, a Beech C-45G. Prior to the collision, the helicopter was at a low RPM; therefore, the plt was unable to move the helicopter out of the way. The Beech acft was being taxied…NTSB CHI84LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Wauseon, OHWhile taxiing on the S0D for takeoff, the left wing hit a tree.NTSB DEN84LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, COAfter receiving clearance to rwy 16L, the plt began taxiing thru a congested area where the taxiway & an arpt road were routed thru a hangar/parking area. In that area, the roadway was adjacent to the taxiway & to the right of the plt as he was taxiing. The…NTSB CHI84LA221Accident · No injuriesLimited investigationFinal reportBeech 58 · Iron Mountain, MIThe plt reported that after he made a normal landing, he retracted the gear instead of the flaps. However, there were indicates that the gear was not fully extended during touchdown. The landing gear circuit breaker was found popped. The landing gear safety…NTSB LAX84LA331Accident · Minor injuriesLimited investigationFinal reportPitts S2A · Redlands, CAThe acft were to perform & the two plts agreed to a staggered takeoff with the 2nd plt counting to 5 prior to commencinghis takeoff. They positioned themselves abreast of each other on the rwy. The plt of N65P commenced her takeoff from the right side of the…NTSB NYC84LA205Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Teterboro, NJA Piper PA-34-200T, N33086 & a Piper Aerostar 600, N8208T, were involved in an on-ground collision at night. IFR flt plans had been filed for both acft & the plts of both acft had begun taxiing for takeoff. According to the PA-34 plt, he had been cleared to…NTSB ANC84LA076Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Nunavachak, AKThe plt of a Piper PA-32, N4143W, was taking off toward the west-northwest on a tidal beach at the same time that another plt was taxiing west onto the beach. The other plt was taxiing a high wing, Bellanca 7GCBC, N2677Z. The Bellanca was angling down onto…