Skip to content

NTSB investigations, OK

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

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."eventStateOrRegion" = 'OK' AND c."eventCountry" = 'USA' AND 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.\"eventStateOrRegion\" = 'OK' AND c.\"eventCountry\" = 'USA'
    AND 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."eventStateOrRegion" = 'OK' AND c."eventCountry" = 'USA'
  AND 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 DFW07LA056Accident · No injuriesLimited investigationFinal reportCessna 172S · Tulsa, OKThe pilot's failure to maintain clearance from a hangar and parked airplane during the unauthorized use of an airplane.Dec 27, 2006 · N159RA · Destroyed NTSB FTW04LA114Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Seminole, OKThe pilot's inadequate pre-flight planning. A contributing factor was the pilot's use of unsuitable terrain for takeoff.Apr 25, 2004 · N6228A · Destroyed NTSB FTW01LA126Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Tulsa, OKthe dual student pilot's failure to maintain clearance from the hangar while taxing.May 21, 2001 · N6003Y · Substantial damage NTSB FTW00LA158Accident · No injuriesLimited investigationFinal reportCessna 182RG · Sand Springs, OKThe pilot's failure to maintain directional control during the takeoff. A factor was the fence struck by the aircraft.May 28, 2000 · N736BA · Substantial damage NTSB FTW99LA266Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Lone Grove, OKThe pilot's selection of an unsuitable takeoff area. Factors were the fences struck during the takeoff, the tall grass, rising terrain, and a tailwind.Sep 25, 1999 · N5818C · Substantial damage 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.Jan 28, 1998 · N340CK · Substantial damage NTSB FTW97LA057Accident · No injuriesLimited investigationFinal reportGilbert Rutan Vari EZE · Oklahoma City, OKThe pilot's failure to follow proper starting procedures and set the throttle to idle before hand propping.Nov 10, 1996 · N18VE · Substantial damage NTSB FTW93LA157Accident · Minor injuriesLimited investigationFinal reportAero Commander 680 · Marietta, OKThe pilot's inadequate visual lookout for obstructions on the runway and the airport operator's failure to ensure that animals could not enter the runway environmentMay 17, 1993 · N6244D · Substantial damage NTSB FTW92LA182Accident · No injuriesLimited investigationFinal reportSchleicher KA6E · Haskell, OKThe pilot's failure to maintain directional control and the wing runners failure to keep the right wing up.Jul 18, 1992 · N1342 · Substantial damage NTSB DEN92FA060Accident · 1 fatalField investigationFinal reportBeech V35B · Tulsa, OKAircraft climb performance exceeded. Factors were: aircraft gross weight exceeded, grass runway selected, takeoff flaps not used, and premature rotation.Jun 17, 1992 · N4567S · Destroyed 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.Jan 23, 1991 · N82162 · Substantial damage NTSB FTW90LA158Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Broken Arrow, OKThe pilot in command's failure to maintain directional control during the takeoff.Aug 20, 1990 · N73571 · Substantial damage NTSB FTW89LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Muskogee, OKAcft's left wing struck a truck that was parked adjacent to the taxiway. After initial impact, the acft veered left and the nose also struck the truck. The plt stated that he was concentrating on a ramp sweeper that was moving down the taxiway in front of the…Oct 26, 1988 · N4715B · Substantial damage NTSB FTW87LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Farris, OKThe plt rprtd that drg a x-country flt, he got lost & the acft ran low on fuel. At dusk, he elected to make a precautionary landing in a open field. Drg the landing, the acft struck a tree & was damaged.Jun 30, 1987 · N49131 · Substantial damage NTSB FTW87LA113Accident · Minor injuriesLimited investigationFinal reportBoeing 707-323C · Oklahoma City, OKAfter engine start ground personnel experienced difficulty disconnecting the airstart unit hose. The ground signalman left the view of the crew to assist the other men in an effort to disconnect the unit from the aircraft. The pilot assuming that all was…May 1, 1987 · N8404 · Substantial damage NTSB FTW86LA120Accident · No injuriesLimited investigationFinal reportBeech E18S · Oklahoma City, OKA swearingen SA-226TC, N516SS, was lndd at ngt on rwy 17L. After lndg, the flt crew exited onto taxiway-E3 (TWY-E3), where they were instructed by tower to hold. A Beech E18S, N2001C, was then lndd on the same rwy (rwy 17L) & its plt also exited onto TWY-E3.…Jun 24, 1986 · N2001C · 2 aircraft · Minor damage NTSB FTW84LA373Accident · No injuriesLimited investigationFinal reportCessna 172M · Bethany, OKAccording to the plt of N9646H, while he was taxiing under the direction of ground control the acft was struck from behind by N1PN. The plt of N1PN stated that he was cleared to taxi and did not see any other acft as he entered the taxiway. Seated in the rear…Aug 30, 1984 · N9646H · 2 aircraft · Substantial damage NTSB FTW84LA307Accident · No injuriesLimited investigationFinal reportCessna 152 · Eufaula, OKWhile taxing from landing the plt was watching the clearance on the left side of the acft and the right wing contacted an unmarked utility pole.Jul 14, 1984 · N6180Q · Substantial damage NTSB FTW82DA307Accident · No injuriesFinal reportCessna 182M · Calumet, OKWhen the pilot landed on a 2000 ft private strip, the left wing of the aircraft struck a tree that was located beside the landing area. After impact the aircraft traveled approximately 100 ft before coming to rest. Both wings, propeller, cabin section and…Aug 2, 1982 · N70802 · Destroyed