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 NYC98LA177Accident · No injuriesLimited investigationFinal reportDouglas DC-9-30 · Philadelphia, PAthe failure of the fuel truck driver to follow airport operating procedures, and yield the right-of-way to the airplane. Factors were the stopped airplane, which obscured the fuel truck from the approaching airplane and the approaching airplane from the fuel…NTSB MIA98LA234Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Leesburg, FLThe pilot's decision to leave the engine running with no one at the controls as he exited the aircraft to check for wheel chocks in place. This resulted in the aircraft moving uncontrolled and eventually colliding with a fence.NTSB CHI98LA330Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Sault Ste Marie, MIthe pilot's failure to maintain clearance between the airplane and the runway marker. A factor contributing to this accident was the runway marker.NTSB FTW98LA351Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-231 · Denver, COThe failure of the flight crew to comply with braking instructions after being instructed by ground personnel.NTSB LAX98LA259Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Willits, CAThe pilot's selection of an inadequate landing area and failure to maintain clearance from obstacles during the landing roll.NTSB NYC98LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201 · Hackettstown, NJThe pilot's failure to use the airplane's takeoff performance data, and his failure to obtain the proper climb airspeed.NTSB CHI98LA290Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Mentha, MIthe pilot's improper inflight decision to land the airplane on the gravel covered road with an uneven surface that had corn growing next to its edge. A factor in this accident was the pilot selecting an unsuitable landing area.NTSB SEA98IA153Incident · No injuriesIncident investigationFinal reportEmbraer EMB-135 · Moses Lake, WAAircraft control was not maintained.NTSB FTW98LA353Accident · No injuriesLimited investigationFinal reportde Havilland DH-8-202 · Telluride, COThe inadequate chocks and inadequate chocking procedures by the operator. Factors were the unavailability of the parking brake and sloping terrain.NTSB FTW98LA336Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Cody, WYThe pilot's failure to maintain visual lookout while taxiing the aircraft.NTSB SEA98LA151Accident · No injuriesLimited investigationFinal reportCurtiss-Wright 12W · Woodland, WAThe pilot in command misjudged clearance from high vegetation when he landed. Factors include inadequate mowing of high vegetation by airport personnel, providing insufficient clearance for the wingspan of landing airplanesNTSB CHI98IA275Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Saint Louis, MOthe failure of the flight crew to maintain clearance from the sweeper truck. A factor in the incident was the sweeper truck.NTSB ANC98LA111Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Tyonek, AKThe pilot's failure to maintain directional control while landing. A factor associated with the accident were willow trees near the airstrip.NTSB MIA98LA204Accident · No injuriesLimited investigationFinal reportCessna 182P · Concord, NCthe failure of the pilot to maintain directional control and his failure to maintain wingtip clearance with trees that border the right side of the runway.NTSB SEA98LA134Accident · Minor injuriesLimited investigationFinal reportNelson Cygnet SF-2A · Newberg, ORThe pilot-in-command's failure to maintain directional control. Factors contributing were the pilot-in-command's lack of experience in make of aircraft (i.e., use of toe brakes) and the fence post.NTSB IAD98LA100Accident · No injuriesLimited investigationFinal reportCessna 172L · Lincoln Park, NJInadequate visual lookout by the pilot, which resulted in his failure to see and avoid the fuel truck. Related factors were the truck and the pilot was unfamiliar with that area.NTSB SEA98LA117Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Big Creek, IDDirectional control was not maintained. A wet runway surface was a factor.NTSB SEA98LA118Accident · No injuriesLimited investigationFinal reportDassault Mystere Falcon 900 · Hamilton, MTPartial failure of the anti-skid brake system due to contamination.NTSB ANC98LA085Accident · No injuriesLimited investigationFinal reportLockheed L-382G · Huslia, AKThe pilot's failure to maintain proper alignment of the airplane during the landing roll.NTSB SEA98LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Manzanita, ORThe pilot's failure to maintain directional control during the aborted takeoff. Factors include a crosswind gust during the takeoff roll.NTSB FTW98FA273Accident · Minor injuriesField investigationFinal reportBoeing 737-322 · Denver, COInadequate visual lookout by ground personnel (tug operator). Factors include failure of the airline to provide proper assistance (wing walkers) to the tug operator, and inadequate pushback procedures by the airline; inattention of the catering truck driver,…NTSB SEA98LA094Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · North Plains, ORThe pilot's failure to maintain directional control and his failure to maintain clearance from a pole. Contributing factors were rain and an overcast which resulted in less than optimal conditions to detect the pole.NTSB LAX98LA190Accident · No injuriesLimited investigationFinal reportFones Z-MAX 1300 · Buckeye, AZthe failure of the pilot to maintain control of the aircraft during the landing approach, and his poor in-flight planning in making an off-airport landing at an unsuitable landing area.NTSB SEA98LA085Accident · 1 fatalLimited investigationFinal reportPiper PA-30 · Everett, WAThe pilot-in-command's exiting the aircraft with both engines running to remove a wheel chock. A factor was the inadequate preflight of the aircraft (not removing the chock) prior to engine start.NTSB FTW98LA255Accident · No injuriesLimited investigationFinal reportCessna 150L · Pearland, TXThe pilot's selection of the wrong runway/landing area. A factor was the lack of visual runway cues available to the pilot.NTSB LAX98LA163Accident · No injuriesLimited investigationFinal reportCessna 172A · Van Nuys, CAThe pilot's failure to maintain obstacle clearance due to his inadequate visual lookout and selection of the wrong taxi route. Contributing factors were the pilot's diverted attention while taxiing in the vicinity of a construction area.NTSB CHI98LA149Accident · No injuriesLimited investigationFinal reportCessna 172M · Elkhart, INthe pilot's disorientation that led him to believe he was on the active runway. A factor was the pilot's inattentiveness.NTSB SEA98LA071Accident · No injuriesLimited investigationFinal reportCessna 172M · Ocean Shores, WAThe pilot's failure to maintain clearance from a light standard (utility pole) just off the edge of the parking ramp. Factors include a light standard placed near the edge of the parking ramp.NTSB MIA98LA143Accident · Minor injuriesLimited investigationFinal reportOrlando Heli Air TR-2000 · Lakeland, FLThe pilot's failure to obtain the proper touch down point (landed left of runway) on landing.NTSB CHI98LA141Accident · No injuriesLimited investigationFinal reportCessna 172M · Superior, NEthe pilot's failure to maintain clearance with the sign. Factors associated with the accident were the sign which the airplane contacted and inadequate preflight planning/preparation.NTSB ATL98LA064Accident · No injuriesLimited investigationFinal reportDennis L. Long Pitts S-2A · Daytona Beach, FLThe pilot's failure to maintain directional control during an attempted takeoff. A factor was the reported crosswind condition.NTSB MIA98LA124Accident · No injuriesLimited investigationFinal reportDouglas DC-10-10F · Memphis, TNThe tug operator's (maintenance representative) inadequate visual lookout during pushback.NTSB IAD98LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Windsor Locks, CTThe student pilot's inattention during taxi, which resulted in the collision with a fuel truck.NTSB CHI98LA108Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Steele, MOthe pilot failed to maintain an adequate visual lookout. A factor was the pile of gravel in the taxiway.NTSB NYC98LA075Accident · Serious injuriesLimited investigationFinal reportFokker F-100 · Philadelphia, PAThe driver's failure to maintain clearance from the parked airplane. Related factors were night conditions and the driver's diverted attention.NTSB FTW98LA149Accident · No injuriesLimited investigationFinal reportFairchild SA227-AC · Tyler, TXThe failure of the golf cart's driver to shutdown the engine and set the parking brake before exiting, which resulted in an unmanned runaway cart.NTSB IAD98LA036Accident · Minor injuriesLimited investigationFinal reportCanadair CL600-2B19 · Covington, KYThe driver's operation of a ground vehicle at night with an inoperative windshield wiper and an obscured windscreen against company regulations which resulted in a collision with a parked aircraft.NTSB ANC98LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Naknek, AKThe pilot's failure to maintain an adequate visual lookout. Factors in the accident were flat lighting conditions, and inadequate airport facilities.NTSB MIA98LA086Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Lake Murray, SCA collision with an unknown submerged.NTSB MIA98LA077Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Georgetown, SCthe pilot's decision to attempt a takeoff from an unsuitable area of roadway, following a forced landing after the engine had lost power, due to fuel exhaustion; and his failure to maintain clearance from obstructions, while attempting the takeoff. The…NTSB NYC98LA064Accident · No injuriesLimited investigationFinal reportCessna 182 · East Moriches, NYthe pilot's improper planning/decision, and failure to attain rotation the airplane for lift-off, which led to an aborted takeoff and collision with a fence. The proximity of the fence was a related factor.NTSB FTW98LA114Accident · No injuriesLimited investigationFinal reportCessna 500 · Horseshoe Bay, TXthe entrance of deer onto the runway, which resulted in an unavoidable impact. Darknes was a related factor.NTSB LAX98LA082Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Chinle, AZthe airport personnel's failure to provide an adequate perimeter barrier to prevent animals from entering the runway area. A factor in the accident was the dark night lighting conditions which hindered the pilot's ability to detect animals on the runway…NTSB FTW98LA110Accident · No injuriesLimited investigationFinal reportAviat A-1 · Buena Vista, COThe pilot's failure to maintain directional control of the airplane. Factors were the crosswind changing to a tailwind, and the pilot's lack of experience in the type of aircraft.NTSB FTW98LA108Accident · No injuriesLimited investigationFinal reportCessna 340 · Wagoner, OKthe entrance of deer onto the runway, which resulted in an unavoidable impact. Darkness was a related factor.NTSB CHI98LA087Accident · No injuriesLimited investigationFinal reportPiper J3C · Mankato, MNthe pilot's inadequate compensation for the wind conditions and not maintaining proper alignment. Factors contributing to the accident were the snow covered terrain and the lack of depth perception it produced.NTSB IAD98LA023Accident · No injuriesLimited investigationFinal reportBeech 1900D · Saranac Lake, NYThe inadequate snow removal from the runway by airport personnel which left a snow bank extending onto the runway.NTSB MIA98LA059Accident · No injuriesLimited investigationFinal reportValentin Tiafun 17E · Pensacola, FLthe pilot's improper in-flight planning/decision and failure to see-and-avoid an obstruction during a precautionary landing on a paved road. Factors relating to the accident were: the resultant low fuel condition, and an obstruction in the precautionary…NTSB FTW98LA094Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Leadville, COThe failure of the pilot to maintain directional control of the airplane. Factors were a sudden windshift from a headwind to a quartering tailwind, and the snowbank.NTSB LAX98LA070Accident · No injuriesLimited investigationFinal reportBritish Aerospace Jetstream 3101 · Phoenix, AZThe pilot's exercising poor judgement to continue to taxi under a covered T-hanger during nighttime conditions without proper clearance between the hanger and the aircraft.