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 ANC89LA169Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKInadequate visual lookout by the pilot due to his diverted attention. The vehicles (tractor & truck) were considered to be related factors.NTSB CHI89LA187Accident · No injuriesLimited investigationFinal reportCessna 120 · Shelbyville, INThe pilot failed to maintain proper alignment during the landing roll.NTSB ANC89LA164Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Stony River, AKPilot's failure to ensure that his landing area was properly clear prior to landing.NTSB MIA89LA246Accident · No injuriesLimited investigationFinal reportCessna 150G · Marathon, FLThe pilot's misjudgement of clearance between his aircraft and the parked aircraft. Factors related to the accident were: sunglare and the location of the parked aircraft.NTSB MIA89LA245Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLInadequate visual lookout by the Waco pilot, which resulted in his misjudgement of clearance between his aircraft and the Cessna 172 and a subsequent collision.NTSB LAX89FA303Accident · No injuriesField investigationFinal reportFairchild SA227-AC · Los Angeles, CAThe fuel truck driver's improper operation of the vechicle on the airport. Factors were the driver's diverted attention and the inadequate supervision by company management.NTSB SEA89LA163Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Paradise Valley, NVThe pilot's inadequate preflight planning/preparation, and his failure to abort the takeoff. The high density altitude, soft runway, and fence were related factors.NTSB NYC89LA215Accident · No injuriesLimited investigationFinal reportBeech 1900C · Boston, MAThe failure of the ground personnel to safely guide the aircraft so that it would have cleared the jetway.NTSB ANC89LA159Accident · No injuriesLimited investigationFinal reportCessna 172H · Sparrevohn, AKThe bucket which was blown into the flight path by a crosswind.NTSB MKC89LA189Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee BT-13A · Kansas City, MOInadequate control tower service provided by tower personnel, and inadequate remedial action by the vehicle driver. The pilot's lack of visual lookout was considered to be a contributing factor.NTSB MIA89LA234Accident · No injuriesLimited investigationFinal reportCessna 172N · Jacksonville, FLInadequate visual lookout by the pilot. Factors related to the accident were: dark night, light pole with an inoperative light, and the lack of visual perception concerning the pilot's ability to see the pole at night.NTSB ATL89LA201Accident · No injuriesLimited investigationFinal reportBeech A-36 · Charleston, SCThe pilot's failure to maintain clearance from other parked aircraft while taxiing.NTSB DEN89LA193Accident · Serious injuriesLimited investigationFinal reportAerofab Lake LA-250 · Bullfrog, UTA submerged object in the landing area.NTSB MIA89LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Apalachicola, FLFailure of the pilot to maintain proper altitude. A factor related to the accident was: the pilot's lack of visual perception concerning altitude above the water.NTSB CHI89FA154Accident · Minor injuriesField investigationFinal reportRyan PT-22 · Oshkosh, WIThe experimental aircraft association's (eaa's) inadequate procedure for providing control and separation of aircraft, its inadequate surveillance of the operation, and inadequate coordination by ground personnel. Related factors were: the ground personnel's…NTSB SEA89LA146Accident · No injuriesLimited investigationFinal reportAbbott Gyroplane · Newport, WAThe pilot's selection of unsuitable terrain and the delay in aborting the takeoff.NTSB CHI89FA153Accident · No injuriesField investigationFinal reportCessna 182Q · Oshkosh, WIThe pilot of Cessna N95914 misjudging the distance necessary to avoid collisions with a the standing Piper N5937W.NTSB NYC89LA162Accident · No injuriesLimited investigationFinal reportBeech F33A · Waterville, METhe pilot's disregard of NOTAMS and the excessive landing speed which resulted in a long landing roll.NTSB MIA89FA194Accident · 1 fatalField investigationFinal reportAirbus Industrie A-300 · San Juan, PRFailure of the ramp guide (ground personnel) to follow normal safety procedures. His over confidence in his personal ability was considered to be a contributing factor.NTSB ATL89LA164Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Franklin, GAImproper planning/decision by the pilot by attempting to takeoff from an unsuitable field and his delay in aborting the takeoff. The terrain conditions and fence were contributing factors.NTSB LAX89LA210Accident · No injuriesLimited investigationFinal reportBeech E-90 · Tuba City, AZThat ground personnel did not properly clear the runway of animals prior to reporting to the pilot that it was clear to land.NTSB MKC89LA120Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Alexandria, MNThat proper starting procedures were not followed by the pilot in command and the aircraft was not tied down.NTSB LAX89LA208Accident · No injuriesLimited investigationFinal reportCessna 172N · Sacramento, CAThe pilot of the other aircraft displayed poor judgement when he elected to continue taxiing in the runup area when visual lookout could not be maintained.NTSB FTW89LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Addison, TXFailure of the pilot to maintain clearance from the telephone pole. Factors related to the accident were: darkness, the pilot's disorientation, lack of visual perception at night, the telephone (utility) pole, and the ditch.NTSB ANC89LA082Accident · No injuriesLimited investigationFinal reportCessna 180H · Togiak, AKImproper planning/decision by the pilot. Contributing factors were: light conditions at dusk, an unsafe/hazardous condition (drum that someone had left near the landing area).NTSB LAX89LA174Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Ramona, CAThe pilot of the other aircraft did not maintain an adequate visual lookout and collided with this Cessna that was parked in the runup area.NTSB MIA89LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · West Palm Beach, FLFailure of the pilot to insure adequate wingtip clearance while taxiing.NTSB LAX89LA147Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Salinas, CAThe pilot's failure to maintain proper taxiway alignment, when he diverted his attention, while taxiing. The location of the parked aircraft was a related factor.NTSB LAX89LA145Accident · No injuriesLimited investigationFinal reportLet L-13 · Hemet, CAInadequate crew coordination between the ground lineman and the blanik pilot, and failure of the blanik pilot to maintain clearance between his aircraft and the parked glider. A factor related to the accident was the proximity of the parked glider to the…NTSB NYC89FA111Accident · Minor injuriesField investigationFinal reportMitsubishi MU-2B-35 · Syracuse, NYFailure of the crew of brockway flight 993 to see-and-avoid the other aircraft due to the first officer's inadequate visual lookout & the captain's inadequate supervision. Factors related to the accident were: the weather condition, and the ground…NTSB NYC89FA106Accident · No injuriesField investigationFinal reportSikorsky S-76A · Manhattan, NYThe pilot of the other helicopter misjudged clearance between his and the other helicopter. Factors related to the accident were: inadequate layout (markings) of the heliport parking area, insufficient standard/requirement for numerical indication of maximum…NTSB FTW89LA072Accident · No injuriesLimited investigationFinal reportCessna A185F · Lake Arthur, LAThe failure of the pilot to see and avoid tree limbs that extended over the edge of the canal. Factors related to the accident were: the tree limbs and dirt bank near the edge of the selected landing area.NTSB NYC89IA101Incident · No injuriesIncident investigationFinal reportStinson 108-3 · Blairstown, NJThe pilot's misjudgement of the clearance between the airplanes.NTSB MIA89LA198Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Fort Myers, FLThe pilot's failure to see and avoid obstructions as he taxied from the ramp area. Contributing to the accident was the dark light conditions which degraded the pilot's visual perception.NTSB LAX89LA115Accident · No injuriesLimited investigationFinal reportRobinson R22 · Hayward, CAFailure of airport personnel to assure the taiway was free of objects after the taxiway was painted.NTSB SEA89LA061Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35J · Spokane, WAThe failure of the pilot to maintain directional control and runway alignment during the landing roll. Factors related to the accident were: light conditions at dawn, snow and ice on the runway, and the runway lights.NTSB LAX89LA117Accident · No injuriesLimited investigationFinal reportCessna 182C · Adalanto, CAThe pilot was inattentive, did not maintain proper alignment with the runway and did not maintain an adequate visual lookout during takeoff.NTSB DEN89FA070Accident · No injuriesField investigationFinal reportSwearingen SA-227-AC · Salt Lake City, UTThe failure of captain of N169SW to maintain a visual lookout while taxiing his aircraft allowing his aircraf to creep into the stationary aircraft in front of him.NTSB MIA89LA073Accident · No injuriesLimited investigationFinal reportBeech A36 · Daytona Beach, FLFailure of the driver of the automobile to maintain an adequate visual lookout and to yield the right of way to the aircraft.NTSB MIA89LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, FLThe Cessna 152 pilot misjudged clearance between his aircraft and the parked Piper PA-28.NTSB LAX89LA088Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Santa Ana, CAPoor preflight planning and preparation by selecting the wrong runway despite NOTAM and ATIS information indicating the runway was closed.NTSB LAX89FA086Accident · Minor injuriesField investigationFinal reportFairchild SA227AC · Los Angeles, CAThe failure of the fuel tanker driver to see and avoid the moving aircraft. Factors contributing to the accident were the driver's obstructed visibility through the right side of the vehicle's cab, and the dusk light conditions.NTSB ANC89IA032Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Anchorage, AKImproper placement of the 727 on the ramp and the failure of the 747 crew to maintain separation.NTSB ATL89IA063Incident · No injuriesIncident investigationFinal reportLake LA-4-200 · Silver Grove, KYDuring a takeoff run from the Ohio river, the right sponson collided with a submerged log. The a/c sustained minor damage.NTSB DEN89LA046Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Hammond, MTThe plt, who was a veterinarian, landed his acft in rough, cultivated farm fld at a ranch in order to conduct business. Upon completion of his business, the plt selected a smoother area in the same field for takeoff. The area was smoother but was shorter and…NTSB ANC89LA023Accident · No injuriesLimited investigationFinal reportCessna 207 · Napaskiak, AKDuring an aborted takeoff, the airplane collided with a bulldozer on the departure end of the snow covered runway. The pilot reported that he elected to abort the takeoff due to a low fuel flow indication. The director of operations stated that during an…NTSB ANC89LA021Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Homer, AKAfter landing, the plt was advised to taxi to the ramp via the south taxiway, since this was the only taxiway that had been snow plowed. Only about a 12 ft width of the 80 ft wide taxiway had been plowed. The cleared portion was on the outer edge of the…NTSB ATL89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Union City, TNPIC made two sdf approaches. On the first approach he had difficulty seeing the rwy lights. The acft was aligned left of rwy and a missed approach was made. On the second approach the PIC said he had difficulty picking up any rwy lights. He landed with the…NTSB MIA89LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Lajas, PRThe plt filled the fuel tanks, made three touch-&-go landings, then departed on a x-country flt. After aprx 1.5 hrs of flt, he elected to reverse course & land at an alternate arpt since he had inadequate fuel to reach his destn. Realizing the fuel supply was…NTSB MIA89LA025Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Tupelo, MSThe Cessna plt was taxiing his acft on a marked taxiway when he observed a Piper PA-31-350 (chieftain) entering the taxiway ahead of his acft. The Cessna plt applied the brakes & stated the acft was stopped for 3-4 seconds before the left wing of the Piper…