NTSB investigations, KY
19 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 3 |
| 1984 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2005 | 2 |
Where
Open the mapLatest cases
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.\"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\" = 230)
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" = 230) 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 NYC06LA010Accident · 1 fatalLimited investigationFinal reportCessna 150F · Pineville, KYThe pilot's continued VFR flight into IMC conditions, which resulted in controlled flight into terrain. Factors in the accident were the low cloud ceiling and fog.NTSB NYC06FA004Accident · 3 fatalField investigationFinal reportBeech A36 · Pikeville, KYThe pilot's failure to follow the published instrument approach which resulted in controlled flight into terrain. A factor was the low ceiling.NTSB CHI04LA030Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Louisville, KYThe pilot's improper in-flight decision to allow the passenger to manipulate the aircraft flight controls, his failure to maintain altitude/clearance from the river, and his inadequate remedial action. A related factor was the low altitude.NTSB IAD03FA032Accident · 3 fatalField investigationFinal reportCessna 421 · Ferguson, KYThe pilot's failure to follow the instrument approach procedure, which resulted in an early descent into trees and terrain. Factors included the low ceiling and the night lighting conditions.NTSB NYC02LA186Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Jamestown, KYThe pilot's failure to maintain the proper descent rate, which resulted in low rotor rpm and a collision with water.NTSB NYC01FA089Accident · 1 fatalField investigationFinal reportCessna 182Q · Dixon, KYThe pilot's failure to maintain adequate clearance while maneuvering, which resulted in an in-flight collision with trees.NTSB NYC00FA068Accident · 1 fatalField investigationFinal reportCessna 195 · Willard, KYThe pilot's continued VFR flight into IMC conditions. Factors were the pilot's inadequate preflight planning and snow showers.NTSB BFO94LA162Accident · No injuriesLimited investigationFinal reportChampion 7FC · Sacramento, KYThe pilot's failure to maintain adequate obstacle clearance.NTSB BFO93LA085Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Paintsville, KYFailure of the pilot to maintain adequate altitude or clearance from the terrain. Factors related to the accident were the unfavorable wind condition and the proximity of the hill to the runway.NTSB ATL88FA138Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Bowling Green, KYPilot called fss on wrong freq. Another pilot answered & pilot req fss freq. He then called fss, rpted eng quit. Witness heard 'eng starting' momentarily overhead, watched acft pitch over, dive to gnd & impact with no attempt to flare for lnding. Pitch trim…NTSB ATL87LA092Accident · No injuriesLimited investigationFinal reportMooney M20 · Frankfort, KYDuring the final phase of the approach procedure, the pilot failed to extend the landing gear. The aircraft touched down, skidded along the runway surface until it finally came to rest. The pilot reported that the fuel strainer failed and a fire started and…NTSB ATL85FA055Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Burlington, KYAcft ferried VFR by owner. Radios repaired before departure, glide slope receiver found inop. At fuel stop wx was forecast IFR for destination. An IFR instructor was then hired for the remaining flt. Owner showed work order to CFI who incorrectly concluded…NTSB ATL84LA016Accident · No injuriesLimited investigationFinal reportBeech 58 · Middlesboro, KYDuring arrival, the acft was landed with the landing gear retracted. An exam of the acft revealed no evidence of a preimpact malfunction or failure of the landing gear system.NTSB ATL83LA369Accident · No injuriesLimited investigationFinal reportBeech D45(T-34) · Louisville, KYAbout 5 mi out, tower approved a straight-in for rwy 1. After the plt extended the landing gear, the tower then suggested rwy 6. The plt retracted the gear & began to set up for rwy 6. However, since another acft was beginning to set up for rwy 19, the plt…NTSB ATL83FA127Accident · 1 fatalField investigationFinal reportDouglas B-26C · Hubbards Fork, KYThe plt & acft had been fighting forest fires earlier in the day. A late developing fire necessitated another dispatch. The acft arrived on scene & checked in with the lead acft circling overhead coordinating the fire fighting efforts. The tanker made 2 runs…NTSB ATL82FLQ09Accident · Serious injuriesFinal reportCessna 150 · Prestonburg, KYImmediately after takeoff from rwy 13 the CFI saw another acft on final to rwy 31 & entered a steep left climbing turn up a small valley east of the arpt. The CFI was unable to out-climb the rising terrain. The CFI stated he took this evasive action to avoid…NTSB ATL82FLQ06Accident · 1 fatalFinal reportBellanca 8KCAB · Mayfield, KYThe aircraft crashed while the pilot was performing an aerobatic routine at an airshow. After about 7 minutes in an 8 minute act, the pilot performed an 8-point roll at about 200 ft AGL, then pulled up into a hammerhead stall. After a hammerhead turn to the…NTSB ATL82DA120Accident · No injuriesFinal reportCessna 150 · Paducah, KYWhile performing a practice emergency landing the pilot stated that he applied full power when the aircraft had descended to about 10 feet above a plowed field. After power was applied the flaps were raised from full down to 20 degrees. The second pilot…NTSB ATL82FA055Accident · 8 fatalField investigationFinal reportPiper PA-31T2 · Springfield, KYThe flt was cleared to maintain 3,000 ft MSL until over the arpt, then cruise. The plt had previously stated that he could see the lights on the ground & that he was 15 mi from the arpt. At 2013 the plt stated "we oughta be able to cancel here." The acft…