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 LAX92LA007Accident · No injuriesLimited investigationFinal reportCessna 421C · Santa Monica, CAThe failure of the pilot of the other aircraft to maintain an adequate visual lookout while taxiing his aircraft.NTSB FTW92LA005Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-8-63F · Dfw Airport, TXThe pilot's misjudgment of the wing tip clearance. A factor was the failure of the maintenance personnel to follow procedures and directives pertaining to taxiway and ramp clearance.NTSB SEA91LA257Accident · No injuriesLimited investigationFinal reportCessna 172E · Burns, ORThe pilot's delay in computing aircraft fuel consumption and his failure to land at an alternate airport along the route of flight. Factors relating to the accident were the tree by the landing area and the improper maintenance adjustment of the right magneto.NTSB ATL91LA181Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lagrange, GAThe J-5 pilot's failure to maintain adequate visual lookout.NTSB ANC91LA153Accident · Minor injuriesLimited investigationFinal reportDe Havilland DHC-2 MKI · Holitna River, AKThe airplane's float hit a submerged log during landing on the River, which resulted in the pilot losing control of the airplane and crashing into the water.NTSB CHI91LA301Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-82 · Chicago, ILThe flight crew's failure to maintain adequate clearance from obstacles during ground operations. A related factor is the failure of the drivers of the escort vehicle and the semi trailer to follow established procedures and directives.NTSB DEN91LA131Accident · No injuriesLimited investigationFinal reportPiper PA-31T-620 · Santa Fe, NMInadvertent deactivation of aircraft brakes by unqualified person.NTSB ANC91LA155Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Eagle, AKThe damage sustained when striking a rock during the previous takeoff roll which resulted in the main landing gear's collapse during landing.NTSB NYC91LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Johnstown, PAA collision with a deer while landing. A factor related to the accident was night conditions which restricted the pilot's view of the deer until it was within the illumination of the landing light.NTSB MIA91FA208Accident · Serious injuriesField investigationFinal reportPiper PA28-151 · Miami, FLThe failure of the airport agent to exercise caution while driving in reduced visibility due to rain resulting in the collision between the agent's truck and the aircraft she was searching for which had stopped on the taxiway to await assistance. Contributing…NTSB DEN91LA118Accident · No injuriesLimited investigationFinal reportLet L-13 · Aspen, COThe pilot turning off the runway with excessive speed.NTSB SEA91LA215Accident · No injuriesLimited investigationFinal reportCessna 172N · Everett, WAThe student pilot's failure to maintain directional control. A factor related to the accident was: the taxiway marker's lack of frangibility due to its construction.NTSB DEN91LA115Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Parker, COPhysical impairment of the pilot in command for unknown reasons.NTSB CHI91LA263Accident · No injuriesLimited investigationFinal reportBeech 36 · Davenport, IAThe inadequate visual lookout and poor inflight planning and decision making by the pilot of N97867. Factors in the accident are inoperative exterior lights and radio communication not possible.NTSB SEA91LA166Accident · No injuriesLimited investigationFinal reportWaco UBF · Lincoln City, ORImproper planning/decision by the pilot, and his delay in aborting the takeoff. The tailwind & proximity of trees/brush were related factors.NTSB LAX91LA352Accident · No injuriesLimited investigationFinal reportCessna 210 · Chino Valley, AZThe failure of the pilot to maintain directional control. A factor in the accident was the slippery condition of the road surface being used as a runway.NTSB LAX91LA350Accident · No injuriesLimited investigationFinal reportCessna 402C · Grand Canyon, AZThe failure of the airport operator to develop animal control procedures for the airport property.NTSB ATL91LA152Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Manning, SCThe pilot's failure to maintain directional control during the takeoff roll, and his failure to abort the takeoff in a timely manner once the airplane had departed the runway surface. A factor in the accident was the pilot's failure to utilize the entire…NTSB SEA91LA200Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Murtaugh, IDThe improper preflight planning/decision by the pilot, resulting in his attempt to takeoff with the aircraft loaded over maximum certificated gross takeoff weight.NTSB NYC91LA198Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Atlantic City, NJThe failure of the pilot of N6877M to insure the runway was clear prior to pulling onto the runway.NTSB SEA91LA199Accident · No injuriesLimited investigationFinal reportCessna C-152 · W. Yellowstone, MTThe failure by the pilot to calculate aircraft fuel comsumption and the pilot's poor inflight planning. Factors relating to the accident were the inadequate preflight planning by the pilot, his lack of qualification and experience, and his disorientation…NTSB SEA91LA196Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Roy, MTThe failure of the pilot to maintain clearance from obstacles during takeoff.NTSB FTW91LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Heber Springs, ARThe pilot's touchdown at an improper point on the airstrip. A factor was the wet downsloping grass airstrip.NTSB FTW91LA137Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-80 · Dfw Airport, TXThe captain of the other aircraft misjudged clearance between his aircraft and the standing commuter airplane. A factor was the failure by the second pilot of the other airplane to identify a hazardous condition.NTSB SEA91LA179Accident · No injuriesLimited investigationFinal reportCessna 188B · Palouse, WAThe pilot's failure to maintain proper runway alignment.NTSB SEA91LA178Accident · No injuriesLimited investigationFinal reportGrumman G-164-B · Pullman, WAThe pilot's failure to maintain runway alignment. Factors include high vegetation growing close to the runway.NTSB SEA91LA176Accident · No injuriesLimited investigationFinal reportMooney M-20K · Mccall, IDAn on ground collision with an animal during the landing roll. A factor to the accident was: a dark night condition.NTSB NYC91LA186Accident · No injuriesLimited investigationFinal reportCessna 172N · Columbus, OHThe failure of the pilot to maintain an adequate visual lookout which resulted in a ground collision with a parked aircraft. Factors related to the accident was the failure of the pilot to taxi on the taxiway centerline and night conditions.NTSB NYC91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Old Bridge, NJThe failure of both pilots to maintain proper visual lookout. Factor related to the accident was inadequate radio communications by the pilots.NTSB SEA91IA159Incident · No injuriesIncident investigationFinal reportGalaxy GLX-7 · Provo, UTThe pilot's diverted attention. Facotrs include on ground contact with a fence.NTSB SEA91LA152Accident · No injuriesLimited investigationFinal reportCessna 172N · Waldron, WAVisual lookout was not maintained, and diverted attention.NTSB ANC91LA084Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Blair Lakes, AKWas the pilot-in-command's failure to assure sufficient obstruction clearance for his airplane during the takeoff roll. Contributing to the accident was the high vegetation.NTSB BFO91LA059Accident · No injuriesLimited investigationFinal reportCessna 150G · Stuart, VAThe pilot's failure to observe a hidden object while landing in an open field.NTSB BFO91LA056Accident · No injuriesLimited investigationFinal reportCessna 206 · Frederick, MDThe pilot of the other aircraft failed to maintain adequate clearance with a parked aircraft.NTSB CHI91DCJ03Accident · No injuriesFinal reportGrumman G-164-A · Edgar, NEThe pilot's inadequate aircraft preflight inspection.NTSB FTW91LA101Accident · Serious injuriesLimited investigationFinal reportRepublic RC-3 · Kingsland, TXThe pilot's failure to follow procedures. A factor was the pilot's lack of expereince in seaplanes.NTSB CHI91LA194Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Mundelein, ILThe pilot in command's not maintaining visual contact with the previously identified airplane.NTSB LAX91LA258Accident · No injuriesLimited investigationFinal reportBeech F33A · Mobile, AZThe failure of the pilot of the other aircraft to exit the runway onto the taxiway at a speed sufficient to stop prior to colliding with the stopped aircraft.NTSB ANC91LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Naknek, AKThe pilot's failure to maintain directional control during the attempted takeoff. Contributing to the accident was the rough takeoff area and the trees along the side of the takeoff area.NTSB MIA91LA153Accident · No injuriesLimited investigationFinal reportCessna 210N · Fernandina Bch, FLFailure of the pilot to obtain proper assistance while taxiing the airplane near a parked airplane.NTSB BFO91LA051Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar STP1 · Quinton, VAThe pilot's failure to maintain adequate clearance from a moving aircraft.NTSB ANC91LA063Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Sterling, AKThe pilot's improper remedial action.NTSB NYC91LA138Accident · No injuriesLimited investigationFinal reportCessna 172N · Canadensis, PAThe pilot's improper planning/decision. A factor related to the accident was the downhill slope of the runway.NTSB DEN91LA074Accident · No injuriesLimited investigationFinal reportPitts S-2B · Albuquerque, NMFailure of the pilot of the other airplane to maintain visual lookout.NTSB SEA91LA104Accident · No injuriesLimited investigationFinal reportHughes 269B · Grand Ronde, ORThe pilot inadvertently interfered with the controls.NTSB ATL91LA092Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Statesboro, GAFailure of both pilots to perform a visual lookout sufficiently adequate to avoid a collision at an uncontrolled airport. Factors related to the accident were: failure of the pilot of N95170 to communicate on the common traffic advisory frequency (CTAF) and…NTSB ATL91FA090Accident · Serious injuriesField investigationFinal reportMcdonnell Douglas MD-88 · Atlanta, GAThe van driver's inadequate visual lookout and poor division of attention.NTSB MIA91LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Vero Beach, FLFailure of the PA-28 pilot to maintain proper brake pressure, while diverting his attention to his notepad.NTSB LAX91LA185Accident · No injuriesLimited investigationFinal reportCessna 182B · Arvin, CA1) The pilot inadequately compensated for wind conditions; 2) the pilot's improper inflight decision; and 3) the pilot not attaining the proper landing touchdown point.NTSB CHI91IA144Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Chicago, ILThe failure of the ground crew to properly align the airplane in the gate alley during the push back from the gate.