Skip to content

NTSB investigations

1,695 cases where the first occurrence was “On ground/water collision with object”.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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 SEA94LA141Accident · No injuriesLimited investigationFinal reportRockwell AC-690 · Casper, WYAnimals (deer) on the runway during the landing roll. Factors include a dark night.Jun 7, 1994 · N265JH · Substantial damage NTSB CHI94LA188Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · New Paris, INthe pilot's inadequate visual lookout. Factors associated with the accident are a fence post, and the pilot's lack of familiarity with the geographic area (landing environment).Jun 3, 1994 · N9046Y · Substantial damage NTSB NYC94LA093Accident · No injuriesLimited investigationFinal reportCessna 172M · Groton, CTthe pilot's inadequate visual lookout during taxi, which resulted in the airplane's wing tip striking ground support equipment.May 24, 1994 · N6891H · Substantial damage NTSB FTW94LA171Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Pottsboro, TXThe pilot's failure to determine, prior to landing at the airport, that the runway length would be inadequate for a safe takeoff, and his subsequent failure to follow the manufacturer's recommended short-field takeoff procedures. Factors in the accident were:…May 22, 1994 · N9687W · Substantial damage NTSB CHI94LA168Accident · No injuriesLimited investigationFinal reportCessna 182B · Glencoe, MNcollision with a fence post during landing roll after an inadvertent landing at the wrong field.May 22, 1994 · N7261E · Destroyed NTSB MIA94LA138Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Belleair, FLImproper maintenance inspection of the crankcase breather tube resulting in failure to detect blockage of the tube.May 13, 1994 · N114WW · Substantial damage NTSB ANC94LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Allakaket, AKThe pilot-in-command's failure to maintain proper runway alignment after landing.May 7, 1994 · N8908N · Substantial damage NTSB LAX94LA209Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Phoenix, AZthe pilot's failure to ensure that the magneto switch was in the off position prior to rotating the propeller by hand.May 1, 1994 · N1454S · Substantial damage NTSB CHI94LA136Accident · No injuriesLimited investigationFinal reportCessna 150A · Angola, INthe on ground collision of the airplane with a deer. A factor was the dark night.Apr 20, 1994 · N7044X · Substantial damage NTSB ATL94LA083Accident · No injuriesLimited investigationFinal reportCessna 172K · Spartanburg, SCThe inadequate visual lookout by the pilot of Cessna 172K, N711GT.Apr 17, 1994 · N711GT · 2 aircraft · Substantial damage NTSB BFO94LA064Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Poughkeepsie, NYThe student pilot's failure to maintain control of the airplane immediately after engine start, and his delay in reducing power and applying the brakes.Apr 12, 1994 · N5962U · Substantial damage NTSB LAX94LA195Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ramona, CAThe pilot of the other aircraft failed to maintain an adequate visual lookout.Apr 10, 1994 · N6319M · 2 aircraft · Substantial damage NTSB LAX94LA179Accident · No injuriesLimited investigationFinal reportCessna 177RG · Sedona, AZthe pilot's inadequate compensation of the existing wind conditions, and failure to maintain directional control of the aircraft.Apr 5, 1994 · N35060 · Substantial damage NTSB SEA94LA095Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Spangle, WAThe pilot not maintaining clearance from the fence. A factor in the accident was the dusk light conditions.Apr 3, 1994 · N6746B · Substantial damage NTSB CHI94LA124Accident · No injuriesLimited investigationFinal reportCessna 177RG · Charlotte, MIthe deer which ran onto the runway. Factors related to the accident were the night conditions and the runway lights which were contacted.Mar 31, 1994 · N7581V · Substantial damage NTSB NYC94LA059Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Norwood, MAThe inadequate supervision by the instructor pilot during the landing, resulting in the improper runway alignment by the student pilot, and the subsequent collision with a snowbank. A factor related to the accident was the incomplete runway snow removal.Mar 16, 1994 · N7303R · Substantial damage NTSB CHI94LA107Accident · Minor injuriesLimited investigationFinal reportBeech 18S · Kansas City, MOthe failure of the driver of the ground vehicle to exercise proper visual lookout.Mar 15, 1994 · N90CA · Substantial damage NTSB SEA94LA078Accident · No injuriesLimited investigationFinal reportSchweizer 2-33A · Heber City, UTThe flight instructor's delayed/inadequate remedial action. Factors include the student pilot's failure to maintain directional control, and unfavorable/variable, gusty winds during the takeoff roll.Mar 8, 1994 · N5790S · Substantial damage NTSB NYC94LA055Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · South Bethlehem, NYThe failure of the pilot to maintain proper alignment with the runway and the inadequate snow removal.Mar 5, 1994 · N7139P · Substantial damage NTSB ANC94LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Chugiak, AKThe failure of the student pilot to maintain directional control of the aircraft. Factors contributing to the accident were the frozen main landing gear brake shoe, the uncontrolled airport operations by airport personnel and extreme low temperature…Mar 5, 1994 · N6469B · Substantial damage NTSB NYC94LA050Accident · Serious injuriesLimited investigationFinal reportBell 47G-5 · Plymouth, MAThe pilot's failure to maintain adequate clearance of the fuel truck from the aircraft, which resulted in the main rotor striking the fuel hose and truck during refueling operation. A factor was the pilot's failure to follow company policy pertaining to the…Mar 1, 1994 · N7043J · Substantial damage NTSB LAX94LA140Accident · No injuriesLimited investigationFinal reportCessna 150 · Chandler, AZThe pilot's intentional swerve to avoid a large bird that flew toward the airplane during the landing roll.Feb 27, 1994 · N10669 · Substantial damage NTSB MIA94LA068Accident · No injuriesLimited investigationFinal reportCessna 172RG · Orlando, FLThe failure of the student pilot to follow instuctions given by ground control and the failure of both pilots to maintain proper obstruction clearance between aircraft.Feb 6, 1994 · N9346D · 2 aircraft · Substantial damage NTSB MIA94LA065Accident · No injuriesLimited investigationFinal reportOconnell LAZER-200 · St. Petersburg, FLThe failure of the pilot of the conventional gear airplane to maintain a visual lookout for other aircraft.Feb 3, 1994 · N199J · 2 aircraft · Substantial damage NTSB ATL94LA045Accident · No injuriesLimited investigationFinal reportCessna 310R · Memphis, TNThe failure of the pilot of N2069C to follow the ATC directive to give way to N3844C, and the inadequate visual lookout by the pilot of N2069C. A factor was the dark night lighting condition at the time of the accident.Jan 28, 1994 · N3844C · 2 aircraft · Substantial damage NTSB ANC94IA020Incident · No injuriesIncident investigationFinal reportSwearingen SA227 · King Salmon, AKThe pilot-in-command did not maintain control of the airplane and did not perform the appropriate procedures for an aborted takeoff. A factor in the incident was the asymmetry in power between the plane's two engines for undetermined reasons.Nov 30, 1993 · N630PA · Minor damage NTSB LAX94LA050Accident · No injuriesLimited investigationFinal reportCessna 172RG · Santa Ana, CAwere the CFI's inadequate supervision of the flight and his delay in taking remedial action. The dual student's excessive taxi speed and the worn right brake lining were factors in this accident.Nov 18, 1993 · N9620B · 2 aircraft · Substantial damage NTSB MIA94LA023Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Orlando, FLThe failure of the pilot-in-command of the other aircraft to maintain a visual lookout and clearance between aircraft.Nov 15, 1993 · N91WW · 2 aircraft · Substantial damage NTSB LAX94LA039Accident · No injuriesLimited investigationFinal reportBoeing PT-13D · Half Moon Bay, CAImproper planning/decision by the pilot of the second stearman, and his selection of the wrong runway on which to land. A factor related to the accident was: failure of the stearman pilots to obtain pertinent NOTAM information.Nov 6, 1993 · N14FR · 2 aircraft · Substantial damage NTSB NYC94LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt. Gilead, OHthe pilot's improper inflight decision to conduct a night landing at an airport without runway lights, and the subsequent misalignment with the runway and collision with an object.Oct 2, 1993 · N736RZ · Substantial damage NTSB FTW93GA269Accident · No injuriesFinal reportBell 206B · Wht Sands Mr, NMThe pilot's failure to land an adequate distance away from the unsecured parachute.Sep 29, 1993 · N39049 · Substantial damage NTSB SEA93LA216Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Clinton, MTTotal failure of the tow equipment.Sep 26, 1993 · N52AS · Substantial damage NTSB BFO93LA184Accident · No injuriesLimited investigationFinal reportCessna 172 · Emporia, VAThe pilot's selection of unsuitable terrain for a takeoff. A factor related to the accident was the pilot's delay in initiating an aborted takeoff.Sep 25, 1993 · N9841L · Substantial damage NTSB SEA93LA209Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA 315B · Avery, IDThe pilot's improper use of the cyclic control.Sep 24, 1993 · N351RM · Substantial damage NTSB FTW93LA265Accident · No injuriesLimited investigationFinal reportPitts S1-T · Sherman, TXFailure to maintain visual lookout by the pilots in command of both aircraft.Sep 23, 1993 · N7FD · 2 aircraft · Substantial damage NTSB LAX93LA362Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Twentynine Palm, CAThe pilot's attemted takeoff from a taxiway due to alcoholic impairment. The night light condition was a factor.Sep 21, 1993 · N93321 · Substantial damage NTSB BFO93LA172Accident · No injuriesLimited investigationFinal reportCessna 172L · Gr Barrington, MAThe pilot's inadequate compensation for the crosswind which resulted in his loss of directional control during the landing roll and subsequent collision with the parked airplanes. A related factor was the pilot's lack of experience.Sep 12, 1993 · N7064Q · Substantial damage NTSB BFO93LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28 · New Carlisle, OHThe pilot's delay in aborting the takeoff, and his failure to maintain directional control during the aborted takeoff.Sep 2, 1993 · N56975 · Substantial damage NTSB LAX93LA337Accident · No injuriesLimited investigationFinal reportCessna 208B · Los Angeles, CAThe inattention of the driver of a service truck to yield to aircraft and subsequent collision with the airplane as it crossed the service roadway.Aug 28, 1993 · N781FE · Substantial damage NTSB SEA93LA182Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Ilwaco, WAThe pilot's inadequate pre-flight planning, and his attempt to take off with the aircraft over gross weight.Aug 22, 1993 · N8267P · Substantial damage NTSB LAX93LA331Accident · Serious injuriesLimited investigationFinal reportUltimate 10-80 · Chandler, AZThe noncertificated pilot's failure to follow the prescribed VFR procedures and poor visual lookout. The other aircraft pilot's restricted visual lookout was a factor in this accident.Aug 21, 1993 · N51677 · 2 aircraft · Minor damage NTSB ANC93LA155Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Jay Creek, AKThe pilot's selection of unsuitable terrain on which to land.Aug 21, 1993 · N6066D · Substantial damage NTSB NYC93LA153Accident · No injuriesLimited investigationFinal reportCessna 172RG · Philadelphia, PAFailure of the cessa pilot to remain clear of the parked Beech C90.Aug 13, 1993 · N6419V · 2 aircraft · Substantial damage NTSB FTW93LA238Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pioneer, LAThe failure by both pilots to maintain visual lookout. Factors were the inadequate radio communications by both pilots, and the departing pilot's failure to follow procedures and directives.Aug 12, 1993 · N8227K · 2 aircraft · Substantial damage NTSB NYC93LA149Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Portsmouth, OHThe pilot's inadequate start procedure which resulted in the airplane taxiing unmanned and its subsequent collision with a building. A factor is the pilot's failure to obtain assistance.Aug 9, 1993 · N1844E · Substantial damage NTSB LAX93FA316Accident · Serious injuriesField investigationFinal reportBell 206L1 · Tusayan, AZFailure of the pilot of N444CR to maintain adequate main rotor clearance from N38903, and the operator's failure to provide adequate or recommended safe helipad dimensions. A factor in the accident was the lack of visual reference to the rotating blades of…Aug 8, 1993 · N444CR · 2 aircraft · Destroyed NTSB CHI93LA294Accident · No injuriesLimited investigationFinal reportNorth American F-51 · Fond Du Lac, WIthe pilot-in-command of the F-51's diverted attention and failure to maintain a visual outlook.Jul 28, 1993 · N6327T · 2 aircraft · Minor damage NTSB FTW93LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · League City, TXVisual lookout not maintained by the driver of the vehicle. A factor was the driver of the vehicle becoming inadvertently lost.Jul 27, 1993 · N3079M · Substantial damage NTSB NYC93FA137Accident · No injuriesField investigationFinal reportBoeing 747-368 · Jamaica, NYMissjudged clearance by the captain of the B-747, hz-ais, as he attempted to maneuver around the ATR-42, N242AT. A factor related to the accident was the diverted attention of the captain of the B-747.Jul 25, 1993 · HZAIS · 2 aircraft · Minor damage NTSB LAX93LA284Accident · No injuriesLimited investigationFinal reportCessna 172N · Alturus, CAThe pilot's delay in aborting the takeoff. The pilot's premature rotation and his failure to follow the procedures in the airplane flight manual regarding use of the mixture control, the high density altitude condition and the pilot's lack of total flight…Jul 9, 1993 · N75901 · Substantial damage