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 CHI91LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mccook, NEA poorly planned approach and inadequate visual lookout by the pilot.NTSB SEA91LA093Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Elma, WAThe pilot used inadequate starting procedures. Factors to the accident were: the pilot did not use proper assistance and the passenger's inadvertent control interference.NTSB LAX91LA171Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Casa Grande, AZThat the pilot failed to maintain proper alignment during the landing roll on the narrow airstrip.NTSB LAX91LA165Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hemet, CAThe failure of the PIC to select a proper touch down point. Contributing to the accident was the lack of recent familiarity with the geographic layout of the landing area.NTSB CHI91LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Morgan, MNA guy wire was struck on takeoff because of inadequate clearance. Factors related to the accident were poor planning/decision by the pilot and over confidence in personal ability.NTSB LAX91LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAThe failure of the CFI aboard N25378 to adequately supervise the flight and the dual student pilot's improper use of the normal brakes.NTSB LAX91LA091Accident · No injuriesLimited investigationFinal reportCessna 340 · Columbia, CAAn unavoidable collision with animals (deer) on landing roll. Contributing to the accident was the airport environment that cannot preclude deer from gaining access to the airport.NTSB DCA91MA018Accident · 34 fatalClass 1 · MajorFinal reportBoeing 737-300 · Los Angeles, CAThe failure of the Los Angeles air traffic facility management to implement procedures that provided redundancy comparable to the requirements contained in the national operational position standards and the failure of the FAA air traffic service to provide…NTSB LAX91LA084Accident · No injuriesLimited investigationFinal reportMaule M5-180C · Owayhee, NVThe failure of the pilot to maintain directional control. A factor was sun glare.NTSB FTW91LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Enid, OKThe mechanical failure of the ignition switch. A factor was the pilot's failure to apply the parking brake or use airplane wheel chocks.NTSB CHI91IA073Incident · No injuriesIncident investigationFinal reportBritish Aerospace 146-200 · Chicago, ILCompany procedures and directives not being followed by ground personnel. A factor associated with the accident is complacency by company/operator management.NTSB MIA91LA067Accident · No injuriesLimited investigationFinal reportCessna 172N · New Smyrna Bch, FLFailure of the CFI to maintain clearance between the right wing tip and a telephone pole.NTSB LAX91LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Tucson, AZBoth pilots used poor visual lookout procedures.NTSB NYC91LA052Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Concord, NHThe improper starting procedure used by the pilot.NTSB ANC91LA016Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Fairbanks, AKThe pilot-in-command's failure to properly perform the aircraft preflight resulting in a collision with a tow bar during initial taxi.NTSB NYC91LA043Accident · Minor injuriesLimited investigationFinal reportCessna 210L · New Haven, CTThe failure of the vehicle driver to adequately monitor the radio/traffic pattern. Factors related to the accident were: darkness, the aircraft's loss of electrical power after activating the runway lights and entering the pattern, and the lack of visual…NTSB DCA91MA010Accident · 8 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-9-14 · Romulus, MILack of proper crew coordn, including virtual reversal of roles by the DC-9 plts, which led to their failure to stop taxiing & alert gnd ctlr of their positional uncertainty in a timely manner bfr & after intruding onto the active rwy. Contribuing to cause of…NTSB ATL91LA023Accident · No injuriesLimited investigationFinal reportCessna 172N · Chamblee, GAPilot's failure to maintain adequate wingtip clearance during taxi.NTSB CHI91FA032Accident · Minor injuriesField investigationFinal reportGates Learjet 25B · Chicago, ILThe driver's inadequate visual lookout. A factor in the accident was the company's configuring the truck with mirrors which obstruct forward visibility.NTSB LAX91LA046Accident · No injuriesLimited investigationFinal reportCessna T303A · Santa Ana, CAThe pilot's misjudging the distance between the airplane and hangar.NTSB BFO91LA010Accident · No injuriesLimited investigationFinal reportAeronca L3B · Farmville, VAThe failure of the pilot to properly secure the aircraft while starting the engine by hand proping.NTSB CHI91LA019Accident · No injuriesLimited investigationFinal reportCessna 150 · La Crosse, WIInadequate visual outlook by the PIC.NTSB NYC91LA021Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-31 · Columbus, OHFailure by pilots of the other aircraft to see and alter taxi path to avoid the standing aircraft.NTSB ATL91LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Centerville, TNThe propable cause of the accident was the runway incursion by the deer during the pilot's takeoff roll.NTSB SEA91LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Princeton, ORThe pilot's failure to maintain clearance from obstacles at the side of the runway.NTSB LAX91LA018Accident · No injuriesLimited investigationFinal reportCessna 150H · San Carlos, CAThe pilot's failure to maintain clearance between his aircraft and a hanger while taxiing. The failure of airport maintenance personnel to maintain taxiway markings was a factor in the accident.NTSB BFO91LA005Accident · No injuriesLimited investigationFinal reportCessna C152 · Bridgeport, WVThe pilot's inability to avoid a collision with deer which had moved onto the runway during their takeoff roll. The dark night contributed to the accident by limiting the pilots' visual outlook.NTSB LAX91LA014Accident · No injuriesLimited investigationFinal reportCessna 150E · S. Lake Tahoe, CAThe pilot's failure to ensure adequate clearance was available when he attempted to taxi pass a parked vehicle.NTSB LAX91LA010Accident · No injuriesLimited investigationFinal reportCessna 172 · San Carlos, CAThe pilot's visual lookout was inadequate.NTSB LAX91LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Watsonville, CAThe failure of the pilots of both aircraft to see and avoid the other.NTSB LAX91LA004Accident · 1 fatalLimited investigationFinal reportMooney M20K · Rio Linda, CAThe airplane's ground collision with an unauthorized person who was located on the active runway. A contributing factor was related to the nighttime (light) condition which limited the pilot's ability to see the person prior to the impact.NTSB CHI90LA274Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob 109A · Waukesha, WIThe pilot's failure to maintain adequate clearance and visual lookout for the moving tractor.NTSB SEA90LA194Accident · Minor injuriesLimited investigationFinal reportRoger A Hansen KR-2M · Shaniko, ORPilot's failure to maintain clearance from a road sign during landing ground roll. A factor in the accident was the failure of the engine exhaust system which resulted in high engine oil temperature.NTSB BFO90LA078Accident · Minor injuriesLimited investigationFinal reportde Havilland DH-82A · Bealeton, VAThe pilot's failure to maintain a vigilent watch for other aircraft operating on the uncontrolled airport. The uneven terrain on the airport restricted visibility and contributed to the accident. Another contributing factor was the improper signals given by…NTSB ANC90LA186Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot's inadequate removal of snow and ice prior to takeoff.NTSB DEN90LA186Accident · Minor injuriesLimited investigationFinal reportBeech D17S · Englewood, COImproper planning/decision by the pilot and inadequate visual lookout by the vehicle driver, which resulted in their failure to assure clearance between the vehicle and aircraft. Factors related to the accident were: sunglare and the pilot's restricted view…NTSB NYC90LA214Accident · No injuriesLimited investigationFinal reportCessna 120 · Southbridge, MAThe pilot improper starting procedures.NTSB LAX90LA308Accident · No injuriesLimited investigationFinal reportCessna 182P · Fernley, NVThe pilot's final approach airspeed was excessive.NTSB NYC90LA202Accident · No injuriesLimited investigationFinal reportWaco DSO · Keene, NHAborted takeoff with insufficient room available to stop. The pilot's delayed decision to abort the takeoff was a factor.NTSB LAX90DVG18Accident · No injuriesFinal reportGlaser-Dirks D6-100G · Vacaville, CAThe unauthorized entry onto the runway by a vehicle operator.NTSB SEA90LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · North Plains, ORThe pilot's failue to maintain adequate clearance from an object near the runway.NTSB NYC90LA204Accident · No injuriesLimited investigationFinal reportPiper 28R · Farmingdale, NJThe failure of the pilot of N8564F to insure the runway was clear prior to crossing.NTSB FTW90LA158Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Broken Arrow, OKThe pilot in command's failure to maintain directional control during the takeoff.NTSB ANC90LA148Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Cold Foot, AKThe pilot-in-command's failure to maintain flying speed.NTSB LAX90LA282Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Liano, CAThe pilot's inflight decision was improper. Contributing to this accident was the pilot's self-induced pressure.NTSB MIA90LA161Accident · Minor injuriesLimited investigationFinal reportBeech 36 · Ellenton, FLThe improper takeoff procedure by the pilot.NTSB SEA90LA132Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Bellingham, WACollision with a submerged object.NTSB NYC90LA154Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Washington, PAThe pilot's failure to maintain clearance from objects while taxiing, and his visual lookout was inadequate.NTSB NYC90LA148Accident · No injuriesLimited investigationFinal reportCessna 150 · Montour Falls, NYThe pilot in command's decision to attempt takeoff at night from an inimproved field which resulted in collision with a vehicle.NTSB LAX90LA243Accident · Minor injuriesLimited investigationFinal reportBeech 95-C55 · Fullerton, CAThe pilot's failure to detect an incorrect rudder trim adjustment, his failure to follow the prescribed pre-takeoff instructions that call for the trim to be adjusted. The collision with the fence and the incorrect rudder trim adjustment were factors in the…