NTSB investigations, KY
8 cases where the defining event was Miscellaneous/other.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2019 | 1 |
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '900')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '900') 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 ERA19TA213Accident · Minor injuriesClass 3Final reportContinental Copters Tomcat MK6C · Franklin, KYThe pilot’s failure to maintain main rotor rpm after takeoff, which resulted in a collision with terrain.NTSB ERA16LA274Accident · Minor injuriesLimited investigationFinal reportAlisport Silent 2 Targa · London, KYThe pilot's failure to properly secure the right side of the canopy before takeoff, and an in-flight collision with trees while maneuvering with an open canopy. Contributing to the pilot's failure to properly secure the canopy was the lack of a visual…NTSB ERA15LA304Accident · No injuriesLimited investigationFinal reportBoard James A Zenith 601 HD · Danville, KYThe pilot's improper adjustment of the propeller blade angle, which resulted in inadequate engine thrust, and his decision to continue the takeoff despite the excessively long takeoff roll.NTSB ERA15LA271Accident · No injuriesLimited investigationFinal reportYoung John E Searey · Corbin, KYThe pilot’s improper conduct of a precautionary landing, which resulted in abnormal water contact that damaged the hull.NTSB ERA13LA236Accident · No injuriesLimited investigationFinal reportBell 206B · Hartford, KYThe pilot’s failure to avoid a powerline that crossed a field that he was spraying. Contributing to the collision was the company’s failure to specifically mention that flight hazards be identified during a pre-work conference.NTSB ERA12CA323Accident · No injuriesData collectionFinal reportBeech A36 · Paducah, KYThe pilot’s failure to properly secure the airplane before turning the propeller by hand.NTSB ERA09CA276Accident · Serious injuriesData collectionFinal reportArbc Inc DBA Lindstrand 60X · Louisville, KYThe passenger's inadequate bracing during landing.NTSB MIA08CA065Accident · Serious injuriesData collectionFinal reportEmbraer EMB-145LR · Covington, KYThe flight attendant's inadvertent slip on the galley's contaminated floor and falling during climb to cruise.