Skip to content

NTSB investigations, KY

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19842026

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" = 'KY' 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\" = 'KY' 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" = 'KY' 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 NYC05LA043Accident · No injuriesLimited investigationFinal reportBoeing 737-247 · Covington, KYThe catering truck driver's failure to maintain clearance of the parked airplane by his inadvertent depressing the accelerator. A factor in this accident was the catering truck driver's diverted attention.Jan 17, 2005 · N373DL · Substantial damage NTSB IAD04LA043Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T1-A2 · Elkton, KYThe pilot's misidentification of the runway, which resulted in the airplane striking an obscured runway marker. Factors were the tailwheel airplane's reduced forward and lateral visibility during landing rollout and inadequate maintenance of the airport…Aug 22, 2004 · N1XG · Substantial damage NTSB NYC02LA047Accident · Minor injuriesLimited investigationFinal reportSwearingen SA-227-AT · Covington, KYthe tug driver's inadequate visual lookout which resulted in his failure to see the airplane in time to prevent the collision.Jan 8, 2002 · N556UP · Substantial damage NTSB NYC99LA023Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYThe tug driver's failure to maintain a proper visual lookout.Oct 11, 1998 · N997DL · Substantial damage NTSB IAD98LA036Accident · Minor injuriesLimited investigationFinal reportCanadair CL600-2B19 · Covington, KYThe driver's operation of a ground vehicle at night with an inoperative windshield wiper and an obscured windscreen against company regulations which resulted in a collision with a parked aircraft.Mar 10, 1998 · N937CA · Substantial damage NTSB IAD97LA109Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Louisville, KYInadequate compensation for wind conditions by the pilot.Aug 12, 1997 · N2827X · Substantial damage NTSB NYC97LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Manchester, KYThe pilot's delay in aborting the takeoff. A factor in the accident was the high, wet grassy runway.Jun 19, 1997 · N2111G · Substantial damage NTSB 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.Mar 25, 1995 · N34010 · Substantial damage NTSB BFO93LA039Accident · No injuriesLimited investigationFinal reportCessna 335 · Owensboro, KYFailure of airport personnel to report the runway condition by NOTAM when airport snow removal personnel left snow piled on the edges of the runway. Factors related to the accident were: dark night, fog, and the snowbank.Mar 3, 1993 · N26CP · Substantial damage NTSB BFO92LA067Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Vine Grove, KYThe pilot's failure to maintain directional control. Contributing factors were wind gusts and the pilot's inadequate compensation for wind.May 17, 1992 · N93426 · Substantial damage NTSB NYC92LA083Accident · Minor injuriesLimited investigationFinal reportFairchild SA-227AC · Lexington, KYAttempted suicide by the vehicle driver.Apr 18, 1992 · N27465 · Substantial damage NTSB BFO92IA046Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Louisville, KYInadequate obstacle clearance, which resulted in on ground collision with a blast fence. Contributing was inadequate instruction from ground personnel.Mar 19, 1992 · N681UP · Minor damage NTSB BFO92LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Glasgow, KYDeer on the runway. Other related factor ws a dark night.Jan 2, 1992 · N40799 · Substantial damage NTSB ATL89IA063Incident · No injuriesIncident investigationFinal reportLake LA-4-200 · Silver Grove, KYDuring a takeoff run from the Ohio river, the right sponson collided with a submerged log. The a/c sustained minor damage.Dec 29, 1988 · N85020 · Minor damage NTSB ATL87LA185Accident · No injuriesLimited investigationFinal reportBeech 200C · Madisonville, KYThe acft struck a 2-FT hi avgas pump while the plt was taxiing around another acft that was parked. The nose gear collapsed & a small fire resulted. The plt & pax evacuated the acft. Line psnl were unable to extinguish the fire with hand-held extinguishers.…Jun 24, 1987 · N617MS · Destroyed NTSB ATL87IA027Incident · No injuriesIncident investigationFinal reportBritish Aerospace BA-31 · Louisville, KYWhile taxiing for takeoff, a jetstream 31 operating as a commuter carrier to dayton, Ohio, collided with the fourth baggage cart of a four car train. The visibility on the ramp was reduced due to rain and fog. The baggage cart driver stated that he was…Nov 26, 1986 · N823JS · Minor damage NTSB ATL84LA299Accident · No injuriesLimited investigationFinal reportCessna 182H · Murray, KYThe pilot stated that during taxi from landing, the left wing tip of the aircraft struck the corner of the main hangar building. Daylight hours, clear weather and dry ramp area conditions existed at the time.Sep 20, 1984 · N1936X · Substantial damage NTSB ATL84LA136Accident · Serious injuriesLimited investigationFinal reportCessna 172 E · Grayson, KYAccording to the plt, he encountered wx while on a x-country flt, got low on fuel while trying to get to an alternate arpt & made a precautionary landing in an open field. Later, he started to takeoff from a highway beside the field. During the takeoff roll,…Mar 31, 1984 · N3065U · Substantial damage