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 CHI99IA204Incident · No injuriesIncident investigationFinal reportBoeing 767-323 · Chicago, ILthe pilot's failure to maintain clearance from the parked aircraft while taxiing. A factor in the accident was the failure of ATC to issue a traffic advisory.NTSB CHI99LA201Accident · No injuriesLimited investigationFinal reportCessna 172G · Union, INThe pilot's failure to maintain clearance with the sign. Factors associated with the accident were the low ceilings and the sign which was contacted.NTSB SEA99LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Zillah, WAThe pilot's selection of unsuitable terrain for landing adjacent to the runway. Factors include sun glare encountered at the time of the landing attempt.NTSB SEA99LA087Accident · No injuriesLimited investigationFinal reportLet L-13 · Belgrade, MTThe pilot in command's failure to maintain clearance from a parked airplane during his attempt to avoid a person on the runway.NTSB MIA99FA168Accident · No injuriesField investigationFinal reportCessna 402C · Fort Lauderdale, FLThe pilot's decision takeoff with condensation on the cockpit windows which restricted visibility, his improper use of aileron control, improper compensation for winds during takeoff, and his failure to maintain directional control during takeoff, resulting…NTSB NYC99LA127Accident · No injuriesLimited investigationFinal reportBoeing 727 · Sterling, VAInadequate visual lookout by the tug operator. A factor in this accident was inadequate pushback procedures by the airline which failed to provide proper assistance (wing walkers) to the tug operator.NTSB NYC99LA118Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Gasburg, VAThe unforecast high winds that required the pilot in command to make a precautionary landing.NTSB SEA99LA068Accident · No injuriesLimited investigationFinal reportCessna 182N · Granite, ORClearance was not maintained. A sign and the selection of unsuitable terrain for landing were factors.NTSB LAX99LA195Accident · No injuriesLimited investigationFinal reportBeech A36 · Willows, CAThe failure of the pilot to maintain an adequate clearance with a parked trailer while taxiing the aircraft.NTSB ANC99LA063Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Anchorage, AKThe pilot misjudging the taxi clearance between the airplane's wingtip and the parked vehicle.NTSB LAX99LA178Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · Clarkdale, AZThe pilot's selection of unsuitable terrain during a high wind condition. Contributing factors were the high winds and the tree.NTSB FTW99LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sulphur Springs, TXThe delayed aborted takeoff by the pilot-in-command. Factors were the short runway, the tall grass, and the tree.NTSB DEN99LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Burlington, WYThe pilots' inadequate preflight planning for take off in that he failed to consider the takeoff surface not being a paved surface. A factor was loose material on the roadway used for take off.NTSB LAX99LA172Accident · No injuriesLimited investigationFinal reportBeech A36 · San Diego, CAThe pilot's failure to maintain a visual lookout while taxiing resulting in the aircraft's colliding with a runway sign. Contributing factors were dusk light conditions, the sign, and the pilot's diverting his attention to aircraft instrumentation during taxi.NTSB NYC99LA104Accident · No injuriesLimited investigationFinal reportCessna 172 · Columbus, OHThe pilot's failure to maintain obstacle clearance and his visual perception of the perimeter road as Taxiway Charlie. A factor in the accident was the absence of a sign identifying the perimeter road.NTSB DEN99LA068Accident · No injuriesLimited investigationFinal reportWeatherly 201-C · Two Buttes, COThe pilot's selection of an unsuitable landing area. Factors associated with the accident were an unknown object in the landing area, a failure of a main landing gear tire, and the pilot's inadvertent ground loop/swerve.NTSB SEA99LA055Accident · No injuriesLimited investigationFinal reportPiper J-3 · Vancouver, WAThe failure of the pilot of the other aircraft to maintain clearance from the pilot's stationary aircraft.NTSB MIA99LA145Accident · No injuriesLimited investigationFinal reportBeech E33 · Orlando, FLthe pilot's failure to maintain control of the airplane during takeoff, resulting in the airplane departing the runway, and subsequently impacting with an airport sign.NTSB LAX99LA145Accident · No injuriesLimited investigationFinal reportCessna 172H · North Las Vegas, NVThe pilot's failure to maintain directional control during takeoff roll resulting in a collision with taxiway sign. A factor was the sign.NTSB LAX99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Rubidoux, CAThe pilot's failure to maintain adequate clearance from parked airplanes while taxiing due to his diverted attention.NTSB SEA99LA042Accident · No injuriesLimited investigationFinal reportCessna 182R · Hailey, IDThe pilot's failure to maintain aircraft control after touchdown. Factors contributing to the accident were a snow bank along the runway edge and a crosswind.NTSB DEN99LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Provo, UTThe pilot exercising poor judgment by ignoring proper procedures/directives, his intentional selection of the wrong runway for takeoff, and his failure to maintain an adequate visual lookout. Factors were his ostentatious display, the other airplane moving on…NTSB NYC99LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Burnt Chimney, VAThe pilot's decision to land on a short runway with a strong tailwind, and his failure to obtain a proper touchdown point.NTSB CHI99LA086Accident · No injuriesLimited investigationFinal reportBeech 58 · Gaylord, MIthe pilot not obtaining proper runway centerline alignment during landing. Associated factors were the pilot's obscured view through the iced windshield, the runway lights not activating simultaneously with the approach lights, incomplete visual detection of…NTSB ANC99LA020Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Anchorage, AKThe failure of the driver of a vehicle to maintain an adequate visual lookout.NTSB SEA99LA029Accident · No injuriesLimited investigationFinal reportBeech 200 · Weiser, IDAirport snow removal was not properly performed. A snowbank was a factor.NTSB MIA99LA055Accident · No injuriesLimited investigationFinal reportCessna 150 · Pembroke Pines, FLThe pilot's decision to abort the takeoff with insufficient runway remaining.NTSB CHI99LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Evansville, INthe student pilot's inability to gain clearance between the airplane and the hanger. Factors contributing to this accident were the wet, grass landing surface, the student pilot's attempted turn to avoid the embankment drop off at the end of the runway, the…NTSB NYC99LA035Accident · No injuriesLimited investigationFinal reportBeech 36 · Mathews, VAThe pilot's decision to land with less than full-down flaps. Contributing factors were the wet landing surface and the tree.NTSB NYC99LA029Accident · Minor injuriesLimited investigationFinal reportBoeing 747-400 · Jamaica, NYThe first officer misjudged the clearance between the right wing and the crane. Factors included the subcontractor's unauthorized placement of the crane in the taxiway safety area and insufficient oversight of the subcontractor's operations.NTSB NYC99LA030Accident · No injuriesLimited investigationFinal reportKing Kitfox IV · Gasport, NYA collision with a deer while landing.NTSB ANC99FA012Accident · Minor injuriesField investigationFinal reportBoeing 747-400 · Anchorage, AKThe excessive taxi speed by the pilot of the other aircraft. A factor associated with the accident was the other pilot's inadequate maneuver to avoid the parked airplane.NTSB IAD99LA014Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Baltimore, MDAn inadvertent collision with a deer on the runway. A contributing factor was night conditions.NTSB LAX99LA018Accident · No injuriesLimited investigationFinal reportBeech C90 · Sedona, AZThe instructor's failure to maintain runway alignment during the takeoff roll.NTSB MIA99FA012Accident · Minor injuriesField investigationFinal reportAerospatiale ATR-42-300 · San Juan, PRThe pilot's failure to verify that the parking brake was applied prior to engine start, and the resultant inadvertent movement of the aircraft and collision with the ground power cart once No. 2 was started.NTSB LAX99LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe pilot's failure to maintain clearance between the airplane's wing and a parked fuel truck.NTSB MIA99LA009Accident · No injuriesLimited investigationFinal reportPiper PA-32RT · Vidalia, GAThe pilot's inadequate preflight planning by which he failed to obtain NOTAM information, and his failure to identify an hazardous/unsafe condition on the runway.NTSB NYC99LA023Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYThe tug driver's failure to maintain a proper visual lookout.NTSB DEN99LA011Accident · Minor injuriesLimited investigationFinal reportThunder and Colt AX8-90 S 2 · Albuquerque, NMThe pilot's improper planning for his landing site approach which resulted in the balloon landing in close proximity to electrical transmission lines.NTSB MIA99LA004Accident · No injuriesLimited investigationFinal reportMooney M20J · Orlando, FLThe failure of the pilot to maintain clearance while taxiing from landing resulting in the on-ground collision with the parked airplane. A factor in the accident was the intentional operation of the airplane by the pilot with known deficiencies in equipment…NTSB FTW98LA415Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Austin, TXThe collision with deer during the landing roll. Factors were the dark night light condition and the separation of the lower strut assembly from the right main landing gear, on the subsequent flight.NTSB ANC98LA158Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Mcgrath, AKThe failure of the pilot to maintain directional control during takeoff. Factors involved in the accident were a crosswind, and the trees adjacent to the takeoff area.NTSB LAX98LA303Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Santa Rosa, CAThe pilot's inadequate visual lookout during taxiing operations. A factor was the pilot's diverted attention while taxiing.NTSB LAX98LA315Accident · No injuriesLimited investigationFinal reportCessna 150L · Oroville, CAFailure of the pilot to maintain proper clearance and subsequently striking a hangar door while taxiing to parking.NTSB SEA98LA194Accident · No injuriesLimited investigationFinal reportCessna 182B · Big Creek, IDAn animal (cow elk) that had wandered onto the airport.NTSB NYC98LA189Accident · No injuriesLimited investigationFinal reportCessna 172M · Teterboro, NJThe pilot's failure to maintain control of the airplane. Factors in this accident were the night light conditions, and pilot's lack of recent night flight experience.NTSB ANC98LA151Accident · No injuriesLimited investigationFinal reportCessna 185F · Fairbanks, AKThe pilot's selection of unsuitable terrain for takeoff and his failure to maintain adequate obstacle clearance.NTSB ANC98LA149Accident · No injuriesLimited investigationFinal reportCessna 207 · Sleetmute, AKThe pilot's selection of unsuitable terrain for departure. A factor in the accident was a narrow runway.NTSB ANC98LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was sunglare as the pilot landed into the sun.NTSB MIA98TA243Accident · No injuriesFinal reportBell BHT-47-G3B1 · Buckhead Ridge, FLThe failure of the pilot to adequately compensate for a tailwind condition on liftoff from the helipad.