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 ANC93LA110Accident · No injuriesLimited investigationFinal reportCessna 180J · Delta Junction, AKThe pilot in command's delay in aborting the takeoff. The trees were a factor in the accident.NTSB SEA93LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Provo, UTThe wild animals on the runway. A factor relating to the accident was the dark night light conditions.NTSB LAX93LA262Accident · No injuriesLimited investigationFinal reportCessna 182F · Fallon, NVthe pilot's failure to detect and avoid a guy wire from a power pole during the landing roll on a private farm airstrip.NTSB CHI93LA214Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Galesburg, ILThe departing pilot's (N251NW) inadequate visual lookout while operating in VFR conditions at an uncontrolled airport. Factors related to the accident were: the departing pilot's diverted attention, and the arriving pilot's (N2632U) inadequate visual lookout.NTSB ANC93LA095Accident · No injuriesLimited investigationFinal reportBell B-3 · Annette Bay, AKThe failure of the tail rotor drive shaft coupling and the inadequate inspection of the tail rotor drive system by company maintenance personnel after the first tail rotor strike.NTSB LAX93LA251Accident · No injuriesLimited investigationFinal reportAlon A2 · Goodyear, AZthe pilot's failure to maintain adequate obstruction clearance while taxiing. A factor in the accident was the pilot's attention being diverted by the movement of two trucks.NTSB ANC93IA087Incident · No injuriesIncident investigationFinal reportPZL Warzawa-Okecie PZL-104 Wilga 80 · Haines, AKThe parking brake failure due to a broken bracket; intentionally leaving the airplane unattended with the engine running by the pilot-in-command; and the improper planning and decision of the pilot-in-command by not using wheel chocks.NTSB CHI93LA198Accident · Serious injuriesLimited investigationFinal reportBeech 200 · Wonder Lake, ILThe failure of the pilot of the Beech 200, N210PH, to maintain sufficient runway alignment to prevent the airplane from departing the runway.NTSB FTW93LA179Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAThe pilot's failure to have the airplane properly attended during start when people were available. A factor was the inadequate tie down rope.NTSB CHI93LA188Accident · No injuriesLimited investigationFinal reportBeech C23 · Kansas City, MOThe pilot-in-command was operating the airplane at an excessive taxi speed, and did not maintain visual separation with the tied down airplane. Factors contributing to the accident were a light rain and fog condition, and a foggy interior window.NTSB SEA93LA127Accident · No injuriesLimited investigationFinal reportCessna 210L · Lynden, WADirectional control not being maintained. Factors include a high touchdown speed, light rain, and a wet landing surface.NTSB FTW93LA175Accident · No injuriesLimited investigationFinal reportGrumman G-164B · St. Martinville, LAThe pilot's and tractor driver's inadequate visual lookoutNTSB ATL93LA101Accident · No injuriesLimited investigationFinal reportCessna 150H · Lafayette, ALThe pilot's failure to maintain adequate clearance from the mile marker sign during the takeoff roll. A factor was the sign adjacent to the highwayNTSB FTW93LA157Accident · Minor injuriesLimited investigationFinal reportAero Commander 680 · Marietta, OKThe pilot's inadequate visual lookout for obstructions on the runway and the airport operator's failure to ensure that animals could not enter the runway environmentNTSB BFO93LA069Accident · No injuriesLimited investigationFinal reportBeech B100 · Clarksburg, WVThe pilot's failure to maintain adequate clearance from the hangar. Contributing to the accident was the dark night.NTSB ANC93LA059Accident · No injuriesLimited investigationFinal reportCessna 172 · Kasigluk, AKThe pilot's poor judgement in attempting a takeoff from a narrow, wet, soft gravel runway with a crosswind. The runway conditions and the crosswind were factors in the accident.NTSB FTW93LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Palacios, TXThe pilot's selection of unsuitable terrain for landing. A factor was the hidden culvert.NTSB FTW93LA133Accident · No injuriesLimited investigationFinal reportCessna T303 · Mena, ARThe pilot's failure to maintain directional controlNTSB MIA93LA100Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Orlando, FLVisual lookout not maintained by the pilot-in-command while taxiing the airplane. Contributing to the accident was the failure of the driver of the vehicle to advise the ground controller that he had stopped the vehicle on the taxiway.NTSB FTW93LA127Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Danville, ARPilot's improper crosswind correction, his loss of directional control, and improper supervision by the instructor pilot. A factor was the crosswindNTSB NYC93LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Pawtucket, RIThe failure of both pilots to see and avoid, resulting in a ground collision between their two airplanes.NTSB MIA93LA091Accident · No injuriesLimited investigationFinal reportBeech V35B · Key Largo, FLThe pilot-in-command's complacency and decision to leave the aircraft controls unattended with the engine operating and without setting the parking brake.NTSB CHI93LA107Accident · No injuriesLimited investigationFinal reportBeech B90 · Chicago, ILThe pilot's misjudging distance from the parked vehicle.NTSB BFO93LA039Accident · No injuriesLimited investigationFinal reportCessna 335 · Owensboro, KYFailure of airport personnel to report the runway condition by NOTAM when airport snow removal personnel left snow piled on the edges of the runway. Factors related to the accident were: dark night, fog, and the snowbank.NTSB MIA93LA079Accident · No injuriesLimited investigationFinal reportAeronca KCA · Bunnell, FLImproper procedures by the other pilot for his failure to perform 's' turns while taxiing.NTSB SEA93LA067Accident · No injuriesLimited investigationFinal reportBeech C-99 · Seattle, WAThe improper starting procedure by the pilot of the Aeronca. A factor contributing to the accident was inadequate communications by the pilot of the Aeronca.NTSB MIA93LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Punta Gorda, FLThe pilot-in-command's failure to maintain a visual lookout while taxiing into the parking area, resulting in an on-ground collision with a light pole.NTSB BFO93LA029Accident · No injuriesLimited investigationFinal reportAgusta A109AII · Lincoln Park, NJThe pilot's inadequate visual lookout, which resulted in his misjudgment of clearance.NTSB MIA93LA053Accident · No injuriesLimited investigationFinal reportCessna 150M · Gainesville, FLPoor in-flight planning decision by the student pilot. Contributing to the accident was his apprehension and lack of total experience in the type of operation.NTSB SEA93IA050Incident · No injuriesIncident investigationFinal reportBeech 1900C · Riverton, WYThe pilot's disorientation. Factors include snow, fog, snow covered terrain, and a drainage ditch.NTSB ANC93LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Juneau, AKImproper airport ramp operations, specifically, the vehicle driver's operation of a loaded forklift near taxiing aircraft and standing aircraft.NTSB NYC93LA040Accident · 1 fatalLimited investigationFinal reportBoeing 737-300LR · Flushing, NYA lack of adequate clearance between the walker and tug which resulted in the walker being struck by the tug when he fell for unknown reason(s). A factor related to the accident was the lack of a policy to stay clear of the tug, towbar, and nosewheel of the…NTSB NYC93LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Alberta, VAThe pilot attempted to take off on rough uneven terrain and could not attain rotation speed, which resulted in the airplane striking a tree during the ground run. A factor in this accident was inadequate pre flight planning.NTSB LAX93LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Novato, CAFailed to maintain directional control and an inadequate visual lookout. Contributing to this accident were the inoperative runway lights.NTSB ATL93LA032Accident · No injuriesLimited investigationFinal reportVan Arsdell/Brent,M. Rutan Long EZ · Charleston, SCThe pilot's inadequate pre-flight planning and his failure to note the raised arresting device near the runway threshold.NTSB BFO93LA011Accident · No injuriesLimited investigationFinal reportCessna 150A · West Milford, NJThe pilot misjudged his altitude and distance and overshot the runway during landing. Contributing to the accident was the pilot's unfamiliarity with this airport.NTSB DEN93LA011Accident · No injuriesLimited investigationFinal reportBeech 1900C · Denver, COThe ramp agent misjudging the clearance between the airplane and gpu. A factor was: unavailability of proper ground assistance.NTSB ANC93LA009Accident · No injuriesLimited investigationFinal reportCessna 206 · Slate Creek, AKThe icy condition of the runway and the discontinued snow removal.NTSB FTW93LA020Accident · No injuriesLimited investigationFinal reportBritish Aerospace 3100 · Dfw Airport, TXThe pilot's failure to maintain visual lookout and clearance. The congested ramp was a factor.NTSB FTW93LA019Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-32 · Houston, TXThe vehicle operator's failure to maintain an adequate visual lookout.NTSB NYC93LA024Accident · No injuriesLimited investigationFinal reportCessna 150L · Linden, NJThe automobile driver's failure to see and avoid aircraft traffic while crossing an active runway.NTSB NYC93LA033Accident · No injuriesLimited investigationFinal reportCessna 172N II · Waverly, OHAn unavoidable collision with a deer.NTSB DEN93LA004Accident · No injuriesLimited investigationFinal reportCessna 172N · Addison, TXThe attempt by both pilots to pass each other without adequate clearance between their airplanes.NTSB FTW93LA003Accident · 1 fatalLimited investigationFinal reportCessna Ector 305A · Houston, TXThe pilot of the other aircraft's inadvertent ground loop. Factors were the left quartering tailwind and this pilot's inability to see the other airplane during the landing roll.NTSB ANC93LA004Accident · No injuriesLimited investigationFinal reportCessna 206U · Lime Village, AKPilot in command's poor preflight planning. A factor in the accident was the hazards on or near the gravel bar strip takeoff area.NTSB SEA93LA005Accident · No injuriesLimited investigationFinal reportSchweizer SSG 2-33A · Heber City, UTThe proper alignment was not maintained by the pilot. A factor relating to the accident was the sign located beside the runway.NTSB SEA92LA212Accident · No injuriesLimited investigationFinal reportBeech E35 · Anacortes, WAThe pilot in command's failure to maintain directional control. A factor contributing to the accident was: the pilot in command's not extending the flaps for landing.NTSB FTW92LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-200R · Fort Worth, TXThe pilot's failure to maintain proper clearance with the hole. Factors were the lack of markings and the poor maintenance of the taxiway and runway.NTSB ANC92FA148Accident · No injuriesField investigationFinal reportPiper PA-18 · Anchorage, AKMisjudgment by the pilot to insure adequate distance from objects in the takeoff area, which resulted in damage to the main landing gear on takeoff, and the uncontrolled ground loop by the pilot during a landing with the damaged landing gear. Factors related…NTSB SEA92LA193Accident · No injuriesLimited investigationFinal reportCessna 172N · Snohomish, WAInadequate visual lookout by the other pilot.