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 SEA85LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ephrata, WAThe pilot was returning from his third aerial tow. After releasing the tow rope while on the ramp, the plt was making clearing turns to avoid parked acft. The tow plane's parked unoccupied acft. The acft then pivoted into the mid portion of the right wing…NTSB CHI84LA191Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Columbus, OHThe acft right main gear failed during takeoff roll when it passed over an arresting cable. It was reported that the tailwheel was damaged on a previous landing at rickenbacker afb when it passed over an arresting cable and had since been replaced.…NTSB LAX84LA284Accident · No injuriesLimited investigationFinal reportTaylor Smith Mini DSA-1 · Hayward, CAThis acft landed in trail behind a lead acft (N53BT) and bounced on landing. During his recovery procedures he overtook and collided with the lead acft.NTSB ATL84LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Boaz, ALThe acft collided with a traffic sign while taxiing for takeoff on a highway. The plt said he was a'path finder' for a fly-in and had the cooperation of the police. The owner of the acft said the plt was not authorized to use the acft for this flt.NTSB LAX84LA276Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26D · Vacaville, CAThe student, glider plt stated that he encountered a loss of lift while on the downwind side of a hill. Subsequently, he selected a field for an off-arpt landing. On final apch, the plt noticed a fence in the middle of the field & was unable to avoid it. He…NTSB CHI84LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bluffton, INThe plt was attempting a takeoff on a country road. He stated that during the takeoff he noticed the acft was not set-up for a short field takeoff so he decided to abort. During the takeoff abort the acft struck a tree alongside the road and the the acft…NTSB FTW84LA203Accident · Serious injuriesLimited investigationFinal reportCessna 185F · Belle Chasse, LAWhen the plt attempted to start the eng, it 'hung up in the middle of the compression stroke.' He stated that after confirming that the magnetos were off, he attempted to 'free the propeller by hand.' The eng started as soon as the propeller was moved. The…NTSB MIA84LA141Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Vero Beach, FLA truck ran into an acft waitng to takeoff. The acft was on the runup pad and the vehicle driver was distracted by an acft taking off. The control tower was not in service.NTSB MIA84LA135Accident · No injuriesLimited investigationFinal reportCessna 172P · Deland, FLAs a student plt in a Cessna 172P, N92ER, was taxiing to takeoff on a supervised solo flt, another student in a Cessna 172P, N78ER, was taxiing from landing. While passing, in opposite directions on a taxiway, the wing tips of the acft collided & both acft…NTSB DEN84LA126Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Ogden, UTThe plt got out of the acft to check the starter solenoid by turning the propeller. He left the mags on and the brakes off. When the prop was turned the acft started and collided with a parked acft.NTSB MKC84LA118Accident · No injuriesLimited investigationFinal reportCessna 402 · Gardner, KSWhile landing on rwy 26 the left gear struck an open upheaval of dirt & asphalt, collasping the left main gear. A go-around was executed, & the plt landed on runway 35 with the right main gear and nose gear retracted.NTSB ATL84LA136Accident · Serious injuriesLimited investigationFinal reportCessna 172 E · Grayson, KYAccording to the plt, he encountered wx while on a x-country flt, got low on fuel while trying to get to an alternate arpt & made a precautionary landing in an open field. Later, he started to takeoff from a highway beside the field. During the takeoff roll,…NTSB LAX84LA232Accident · No injuriesLimited investigationFinal reportCessna 152 · Goleta, CABoth acft had been cleared to the right side of taxiway 'a' after landing due to a convoy of emergency vehicles on a training mission. When cleared to continue to taxi after the convoy passed, N7655S taxied into N4717L from behind.NTSB ATL84LA128Accident · Minor injuriesLimited investigationFinal reportCessna 337E · Tifton, GAThe acft reportedly was not tied down. The plt was hand propping the aft engine while the forward engine was running. In an attempt to board the acft the pilot was run over by the right main gear. The acft continued to travel until it collided with trees.NTSB NYC84LA121Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Chatham, MAAfter landing, as the plt was taxiing to the parking area, the acft hit a rwy identifier sign. The left horizontal stabilizer, elevator & rudder were damaged. The plt said the sign was painted black & was not clearly visible. Also, the sign was not of a…NTSB MIA84LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Borinquen, PRThe plt reported that when he initially attempted to start the eng, the battery was weak. He decided to manually remove excess oil/lubricant from the eng by hand propping the acft. The plt stated that he set the parking brake & turned off the master sw & fuel…NTSB MKC84IA108Incident · Minor injuriesIncident investigationFinal reportBoeing 727-224 · Kansas City, MOWhile taxiing to rwy 01 for takeoff, the plt noticed a snow removal vehicle operating in reverse, approaching his acft. He tried to maneuver to the rt to avoid a collision but the snow removal vehicle struck the leading edge of the lt wing. The driver of the…NTSB MIA84LA120Accident · No injuriesLimited investigationFinal reportSchweizer SGU-22 · Williston, FLThe acft collided with the wind tetrahedron during landing. The plt stated he landed on the grass parrllel to rwy 22 and a combination of landing long and ground effect caused him to hit the telrahedron.NTSB LAX84LA214Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Willcox, AZAn unknown person attempted to steal the acft. The acft was taxied out from its tie-down spot & accelerated down the mile-long dirt rwy. It failed to become airborne, impacted 5 fences, a power pole & came to rest inverted. The injury index is presumed.NTSB FTW84LA164Accident · Minor injuriesLimited investigationFinal reportEagle Balloons Eagle C-7 · Houston, TXThe plt stated that the wx at the accident site was scattered clouds between 150-650 ft AGL with a definite ceiling at 650 ft (broken). Visibility was 1 mi with rapidly forming fog layer. The plt descended with the intention of landing as soon as possible. He…NTSB MIA84LA100Accident · No injuriesLimited investigationFinal reportCessna 172 M · Ormond Beach, FLThe plt stated that the alternator was inop, so the acft had no electrical power. He decided to hand prop the eng to start it for a banner towing operation. He set the parking brake & started pulling the propeller thru by hand while the cockpit was…NTSB ATL84FA118Accident · No injuriesField investigationFinal reportPiper PA 31-350 · Atlanta, GAThe aircrews of a Piper PA-31, N62849, & a Piper PA-30, N7047Y, proceeded to taxi at dawn from a cargo ramp to rwy 26. Their taxi route was down a parallel taxiway. The PA-31 plt stopped at a glide slope hold line which was located near the end of the…NTSB ATL84FKG05Accident · 1 fatalFinal reportPiper PA-34-220T · Madison, GAThe acft collided with a car while landing on an airstrip at night. The car had been parked on the strip & an occupant in the car was fatally injured. An illicit substance was found aboard the acft & it was confiscated by law enforcement officials. Rain & fog…NTSB NYC84LA100Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Haven, CTWhile taxiing in from landing and maneuvering for parking the acft contacted a light pole. The CFI was reportedly at theacft controls at the time of the collision. The right wing was damaged in the collision.NTSB MKC84LA095Accident · No injuriesLimited investigationFinal reportCessna 182Q · Pleasanton, KSThe plt stated that he taxied through mud and snow enroute to the rwy. He said when he applied rt rudder and brake the acft failed to respond. The left wing hit a pole.NTSB NYC84IA091Incident · No injuriesIncident investigationFinal reportLockheed 382G · Groton, CTAfter landing on rwy 33, and during taxi to the ramp, the lt wing tip of the acft struck a parked DC-3.NTSB LAX84IA188Incident · No injuriesIncident investigationFinal reportCessna 152 · Riverside, CAN6496M executed a takeoff on taxiway 'a' & collided with Cessna N7831F holding short of rwy 09 at taxiway 'h'.NTSB LAX84LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hayward, CACompleting a night instrument private pilot biennial flight reivew, the acft was issued landing clearance for rwy 28L. On short final the pvt plt began to align the acft to land on rwy 28R which was closed for maintenance & not illuminated. The instructor plt…NTSB ATL84FA102Accident · No injuriesField investigationFinal reportCessna 182RG II · Chantilly, VAPlt stated he saw baggage tug at a stop, apparently holding, btw taxiways T-1 and T-2. Tug driver reported he stopped at the stop sign, looked left, looked right and observing no acft. He accelerated his vehicle and saw N1734R directly in front of him. He…NTSB MKC84LA100Accident · No injuriesLimited investigationFinal reportBeech F90 · Jonesboro, ARWhile en route to Jonesboro, the plt was informed the rwy and taxiway lights were inop. When he asked fss if the arpt was closed the reply was, 'negative, land at your own risk.' The plt lined up with what he thought was rwy 05 but in actuality it was a…NTSB SEA84FA048Accident · 1 fatalField investigationFinal reportSikorsky S-61L · Medford, ORThe plt deviated from the painted taxi line to avoid a parked fuel truck and collided with a hangar door. The main rotor hit the door and flying debris damaged 2 hangers,3 acft and 2 cars.NTSB SEA84LA041Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Klamath Falls, ORThe plt attempted a takeoff on a slushy soft rwy. The takeoff was aborted at the rwy midpoint due to lack of acceleration. During the abort the acft collided with a fence and nosed over. The plt thought the rwy conditions and carburetor ice.NTSB ANC84LA032Accident · No injuriesLimited investigationFinal reportCessna 207A · Deering, AKWhile in the traffic pattern for a night landing, the plt noticed the village agent's truck positioned about 2/3 down the rwy facing north. The plt assumed the truck was indicating the landing direction. During the landing roll, the plt noticed the truck on…NTSB LAX84LA145Accident · No injuriesLimited investigationFinal reportPiper J-3 CUB · Lompoc, CADuring taxi from landing N42077 taxied into N6592B which had pulled to the right side of the taxiway and stopped to avoid the on-coming acft. The plt of N42077 stated to an FAA inspector that he 'used poor judgement in taxiing.'NTSB CHI84LA091Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Chicago, ILThe acft was being taxied from landing. At a service road intersection a baggage tug collided with the right wing. The acft lights were reportedly on at the time of the accident. The driver of the tug said he was not looking for a small acft on the taxiway,…NTSB MKC84LA055Accident · No injuriesLimited investigationFinal reportMooney M20C · Pittsburg, MOThe acft ran off of the snow covered rwy into trees after an attempted downwind takeoff. The plt had packed the 8 inch snow by driving his car on the rwy. During the aborted takeoff the plt was unable to stop the acft before tree contact.NTSB DCA84AA013Accident · Serious injuriesFinal reportMcDonnell Douglas DC-10-30CF · Anchorage, AKA Piper PA-31, N35206, (south central air flt 59) was cleared to taxi to rwy 6L. The wx at that time was foggy with about 1/8 mi vsiibility, but the RVR was improving & the arpt was expected soon to be acceptable for takeoffs. The PA-31 crew taxied & waited…NTSB DCA84AA012Accident · 1 fatalFinal reportDouglas DC-9-31 · Sioux Falls, SDDuring landing the crew acquired visual reference with the ground & apch lights about 200 ft AGL, followed by visual sighting of the rwy. Since the ATIS reported blowing snow, the crew expected to see, & was not surprised to see, snow blowing across the rwy…NTSB ATL84IA065Incident · No injuriesIncident investigationFinal reportSabreliner NA-265-80 · Cherry Point, NCThe pilot's inadequate preflight planning/preparation. Factors contributing to the accident were fog, rain, and lightning.NTSB MKC84FA036Accident · No injuriesField investigationFinal reportBeech A36 · Kansas City, MOThe BE-A36 was holding short of rwy 18. The C-310 was taxiing to also hold short & collided with the BE-A36. The position & strobe lights on the BE-A36 were illuminated. The plt of the C-310 indicated that he did not see the BE-A36 because of what he…NTSB LAX84LA100Accident · No injuriesLimited investigationFinal reportCessna A 188 A · Cantua Creek, CAThe acft collided with a pick-up truck during a landing on a private airstrip. The truck driver became distracted while driving alongside the dirt rwy and reported that he did not see the arriving acft.NTSB FTW84LA087Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMThe plt reported that during flt, unfavorable winds were encountered. An apch was made to a golf course, but the plt aborted dur to high winds. A short time later, an apch was made to a park area. According to the plt, the wind switched as the Balloon touched…NTSB ATL84FA057Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Atlanta, GAAfter gompleting a preflt, the plt entered the acft & attempted to start the eng with the starter & on board battery. He stated that the eng turned slowly & would not start. After several attempts to make a normal start, the plt exited the acft, chocked the…NTSB CHI84IA052Incident · No injuriesIncident investigationFinal reportCessna 421B · Columbus, OHDuring approach to Columbus, the B-727 was vectored to a final for rwy 28L & the C-421 cleared for a visual to rwy 31 with instructions to 'land short of two eight left...' After contacting the tower the plt of the C-421 was twice clearedto land on rwy 31…NTSB MKC84LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Russellville, ARAfter landing, the plt taxied to the tie-down area. While turning into a tiedown postion, the right main gear hit a tire, surrounding a tie-down stake, & the acft nosed over.NTSB LAX84LA074Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Redding, CAThe plt reported that when he tried to start the acft, the starter would not 'turn the eng.' Thinking that the oil had congealed, he exited the acft & 'pulled the prop.' At that time, the eng started & the plane began to move. The plt jumped on the right wing…NTSB LAX84LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Half Moon Bay, CAThe plt was taxiing to park when the right wing tip of his acft contacted the left wing tip of a Cessna 172RG, N6221R, that was parked beside the taxiway. According to the plt, the wing tip of the parked acft extended aprx 5 ft over the taxiway.NTSB MIA84LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Bunnell, FLThe plt of the C-172 stated that as he entered the landing pattern he observed another company C-172 making landings & took an appropriate interval behind the observed traffic. The plt of the C-152 stated he made his approach behind an acft he observed in the…NTSB FTW84LA046Accident · No injuriesLimited investigationFinal reportMooney M20C · Mcgregor, TXIn order to take off on rwy 35, acft must utilize rwy 4/22 enroute from the arpt ramp. As the Mooney taxied onto rwy 4/22 it was struck by the pitts rolling out on rwy 22. While on base leg, the plt of the pitts saw the Mooney taxiing toward rwy 4/22 &…NTSB ATL84LA047Accident · No injuriesLimited investigationFinal reportPiper PA28-181 · Bessemer, ALThe acft collided with a station wagon while taxiing for takeoff during a purchaser demonstration flt. The prospective buyers were a husband and wife and the wife was occupying the left front seat with the CFI in the right seat. The CFI stated, that while…