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 FTW95LA209Accident · No injuriesLimited investigationFinal reportPurdy HP-18 · Hempstead, TXThe pilot's poor in flight planning/decision. The lack of thermal lift was a factor.NTSB LAX95LA186Accident · Minor injuriesLimited investigationFinal reportGrumman 164A · Richvale, CAthe pilot's failure to maintain a glidepath adequate to avoid an obstacle, and his inadequate compensation for the wind.NTSB FTW95WA227Accident · No injuriesForeign investigationCessna 550 · Soto Cano, HondurasNTSB NYC95LA078Accident · Serious injuriesLimited investigationFinal reportBeech 1900C · Covington, KYa lack of procedures by the tug operator to prevent inadvertent movement of an unoccupied tug, which resulted in an airplane being struck by an unoccupied tug which moved on its own.NTSB FTW95LA140Accident · Serious injuriesLimited investigationFinal reportBeecher Polliwagen PW-1 · New Waverly, TXThe pilot's failure to abort the takeoff. Factors were his failure to obtain engine performance data, the resulting improper red line marking on the tachometer, and the improper adjustment of the propeller.NTSB FTW95LA137Accident · No injuriesLimited investigationFinal reportCessna 140 · Fentress, TXThe sudden movement of an animal into the path of the aircraft during takeoff roll. Factors were the inability of the pilot to establish a visual lookout down the runway due to the runway's 'crowned' midpoint.NTSB CHI95LA094Accident · No injuriesLimited investigationFinal reportBeech 1900 · Minneapolis, MNthe pilot-in-command's failure to maintain clearance from obstacles during taxi operations. Related factors are the dark night light conditions and the wrong taxi route.NTSB MIA95LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Miami, FLThe failure of the truck driver to follow airport operations procedures and signs.NTSB LAX95LA097Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · San Martin, CAthe failure of the pilot to attain takeoff speed and maintain directional control from a grass airstrip and his improper preflight of the runway for obstructions.NTSB ATL95LA038Accident · No injuriesLimited investigationFinal reportDouglas DC-9-32 · Memphis, TNThe ground personnel's improper handling of the aircraft while in tow, and the operator's failure to provide sufficient requirements for this situation.NTSB ANC95LA023Accident · No injuriesLimited investigationFinal reportCessna 208 · Craig, AKThe pilot's selection of an unsuitable landing area. Factors associated with the accident were the sun glare, the partially submerged log, and the shallow fog layer on the surface of the water (landing surface).NTSB LAX95LA066Accident · No injuriesLimited investigationFinal reportCessna 207 · Fort Huachuca, AZThe failure of the radar and tower controllers to ensure that the pilot was aware of the runway status. Factors related to the accident were the downwind no-flap landing and the sunglare.NTSB LAX95LA055Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Hemet, CAThe other aircraft pilot's inadequate bounced landing recovery and his failure to maintain directional control.NTSB LAX95LA045Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Oxnard, CAthe pilot's failure to ensure the aircraft was secured prior to attempting an engine start by handpropping.NTSB MIA95GA033Accident · No injuriesFinal reportSikorsky UH-60A · St. Petersburg, FLThe pilot-in-command's failure to maintain separation while ground taxiing between two hangers, resulting in the main rotor blades colliding with a hanger. Contributing to the accident was the lack of written procedures pertaining to ground marshalling of…NTSB FTW95IA053Incident · No injuriesIncident investigationFinal reportBoeing B-737-300 · Houston, TXThe failure of maintenance personnel to follow the taxi checklist resulting in the hydraulic pumps not being turned on.NTSB MIA95LA035Accident · No injuriesLimited investigationFinal reportCessna 172M · Crystal River, FLThe pilot in command's failure to maintain visual outlook during taxiing.NTSB MIA95LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Indiantown, FLAn evasive maneuver to avoid collision with animals.NTSB MIA95LA026Accident · Serious injuriesLimited investigationFinal reportBoeing 727-100 · Miami, FLThe failure of the truck driver to maintain visual lookout while operating his truck on an unlit ramp near an aircraft.NTSB CHI95LA017Accident · No injuriesLimited investigationFinal reportCessna 210L · Higginsville, MOA coyote (animal) that ran onto the runway as the airplane was landing.NTSB LAX95LA012Accident · No injuriesLimited investigationFinal reportPitts S-2B · Chandler, AZthe pilot's failure to maintain proper alignment with the runway during landing rollout. A contributing factor was sun glare.NTSB MIA95LA001Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenwood, MSThe student pilot's improper planning/decision concerning the selection/approach/execution of the emergency landing. Factors related to the accident were: the pilot's lack of experience, his becoming lost/disoriented, the light conditions at dusk, and the…NTSB ANC95LA002Accident · No injuriesLimited investigationFinal reportCessna 180 · Aniak, AKThe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor associated with the accident was the rough/uneven condition of the runway's surface.NTSB NYC94LA184Accident · Serious injuriesLimited investigationFinal reportCessna 180B · East Moriches, NYThe failure of the pedestrian to stay clear of the active runway. A factor was night conditions.NTSB CHI94LA344Accident · No injuriesLimited investigationFinal reportPrest Eagle II · Wellsville, KSthe pilot-in-command's inadequate visual lookout.NTSB LAX94LA365Accident · No injuriesLimited investigationFinal reportCessna 210L · Payson, AZAnimals on the runway.NTSB ANC94LA136Accident · No injuriesLimited investigationFinal reportCessna 140 · Willow, AKThe pilot's improper starting procedures. Factors in the accident were the unavailability of a parking brake and tiedowns to secure the airplane.NTSB CHI94LA322Accident · No injuriesLimited investigationFinal reportCessna 172N · Boone, IAthe failure of both pilots to adequately monitor radio communications during an exceptionally busy period. Factors related to the accident were the high vegetation and the failure of airport personnel to recognize and correct a hazardous situation.NTSB SEA94LA244Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Bozeman, MTThe student pilot's improper compensation for wind. The crosswind was a factor.NTSB CHI94LA324Accident · No injuriesLimited investigationFinal reportCessna 172 · Warrenton, MOthe pilot's failure to use the proper procedure for an aborted takeoff. Factors associated with the accident were the trees, the pilot's poor preflight/preparation, and the pilot's selection of unsuitable terrain for landing.NTSB LAX94LA357Accident · No injuriesLimited investigationFinal reportCanadair CL600 · Burbank, CAthe ground crew's failure to follow company procedures. The failure of the operator to provide headsets to communicate with the flightcrew and the poor lighting conditions were factors in this accident.NTSB LAX94LA347Accident · No injuriesLimited investigationFinal reportCessna 182P · Mesa, AZthe pilot's failure to properly secure the aircraft prior to a start attempt by handpropping.NTSB MIA94LA202Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12-D · Punta Gorda, FLThe failure of the pilot-in-command to tiedown the airplane prior to attempting an engine start by hand propping. Contributing to the accident was the pilot's complacency.NTSB BFO94LA150Accident · No injuriesLimited investigationFinal reportBeech 36 · Georgetown, DEThe issuance of a NOTAM with inadequate information. Factors related to the accident were: the pilot's failure to attain the proper touchdown point, and the lack of visual cues concerning the construction barrier.NTSB ANC94LA113Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Skwenta, AKThe failure of the pilot-in-command to maintain adequate clearance from an object (tree).NTSB CHI94FA262Accident · 1 fatalField investigationFinal reportGrumman HU-16 · St. Ignace, MIThe pilot's failure to follow good seaplane operating practices by taxiing with power at forward thrust, with a tailwind, at a speed that necessitated using reverse thrust to arrest the excessive speed, and the pilot's misjudgment of his distance from the…NTSB NYC94LA144Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-8-311 · Washington, DCThe vehicle operator's improper handling of the baggage tractor resulting in loss of control of a second baggage tractor being pushed and its subsequent collision with the airplane.NTSB SEA94FA199Accident · 2 fatalField investigationFinal reportPiper PA-12 · Salem, ORFailure of the pilot to see-and-avoid the occupied canoe. Factors related to the accident were: the pilot's improper planning/decision and excessive taxi speed.NTSB NYC94LA141Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-13 · Readington, NJThe failure of both pilots to maintain adequate visual lookout.NTSB LAX94LA302Accident · No injuriesLimited investigationFinal reportCessna 421C · Polacca, AZthe pilot's attempt to make a 180-degree turn in soft sand at a speed which imposed side loading on the nose gear. Factors were the pilot's decision to continue the approach beyond the planned touchdown point, the effect of the runway surface on braking…NTSB SEA94LA195Accident · No injuriesLimited investigationFinal reportPitts S-2B · Salt Lake City, UTThe inadequate visual lookout by the instructor and dual student. Factors include sunglare and the tug left on the taxiway.NTSB MIA94LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Naples, FLFailure of the pilot-in-command to maintain wingtip clearance while taxiing resulting in the on-ground collision with a light pole.NTSB SEA94LA186Accident · No injuriesLimited investigationFinal reportEiriavion PIK20D-78 · Rexberg, IDThe pilot's failure to maintain directional control during the aborted takeoff. Factors include a vehicle parked near the runway.NTSB SEA94LA181Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics PBY-5A · Lincoln City, ORThe pilot's failure to maintain clearance from a boat dock during the aborted takeoff. Factors include the pilot's poor inflight decision to land on a narrow lake under unfavorable wind conditions, and strong crosswinds during the attempted takeoff.NTSB ATL94LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Autaugaville, ALThe pilot's inadequate preflight planning, in that he did not properly evaluate the condition of the runway prior to takeoff, and his failure to abort the takeoff when adequate acceleration was not observed. Factors were the high vegetation (grass) on the…NTSB BFO94LA118Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS2-32 · Plymouth, MAThe pilot-in-command's improper in-flight planning and decision. A factor related to the accident is a downdraft.NTSB MIA94LA166Accident · No injuriesLimited investigationFinal reportBritish Aerospace BAE 3201 · Orlando, FLInadvertent deactivation of the parking brake by the pilot-in-command. Contributing to the accident was the worn condition of the parking brake assembly.NTSB SEA94LA146Accident · No injuriesLimited investigationFinal reportCessna 170A · Wolf Creek, MTPoor in flight planning. The mountainous terrain was a factor.NTSB BFO94FA092Accident · 2 fatalField investigationFinal reportCessna 172H · Millville, NJThe failure of the Cessna's pilot-in-command to perform an adequate visual lookout.NTSB SEA94LA148Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26D · North Plains, ORProper touch down point was not obtained. Factors to the accident were: canopy not secured, and inadequate preflight planning/preparation.