NTSB investigations, 2008, KY

8 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
NTSB investigations, 2008, KY per year, 2008–2026: 45 cases
20088
20092
20103
20113
20124
20133
20141
20157
20161
20172
20181
20191
20201
20211
20232
20241
20252
20262

Latest 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 year(c.\"eventDate\") = 2008
    AND c.\"eventStateOrRegion\" = 'KY' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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.

NTSB ERA09LA114Accident · No injuriesLimited investigationFinal reportJohnson Barron T Lancair 360 · Owensboro, KYThe loss of engine power due to fuel starvation. Contributing to the accident was the failure of the fuel selector valve cotter pin and the inoperative main (center) fuel tank gauge.Dec 29, 2008 · N360AS · Substantial damageNTSB ERA09FA093Accident · 1 fatalField investigationFinal reportBeech 36 · Louisville, KYThe pilot’s continued operation of the aircraft with known deficiencies. Contributing to this accident was the improper sealing of the engine case during overhaul.Dec 18, 2008 · N7472N · Substantial damageNTSB MIA08LA204Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Falmouth, KYA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Sep 28, 2008 · N4477U · Substantial damageNTSB NYC08LA317Accident · Serious injuriesLimited investigationFinal reportSorrell Skybolt · Williamstown, KYA loss of engine power due to oil starvation as a result of improper servicing (removal of preserving fluid) of the engine after it had been returned from storage.Sep 21, 2008 · N3EG · Substantial damageNTSB MIA08LA180Accident · No injuriesLimited investigationFinal reportCessna 182A · Elizabethtown, KYA loss of engine power due to fuel exhaustion. Contributing to the accident was pressure from the company for the pilot to fly the second load of skydivers without refueling.Aug 30, 2008 · N5927B · Substantial damageNTSB NYC08LA251Accident · No injuriesLimited investigationFinal reportHolmes Arthur Orman Kitfox IV · Burkesville, KYThe total loss of engine power due to the installation of an engine oil filter that did not meet the engine manufacture's specifications.Jul 17, 2008 · N70694 · Substantial damageNTSB NYC08CA288Accident · Minor injuriesData collectionFinal reportGrumman American AA-5A · Carrollton, KYThe pilot's improper fuel tank selection, which resulted in fuel starvation and subsequent loss of engine power.Jun 25, 2008 · N26316 · Substantial damageNTSB NYC08LA137Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Middlesboro, KYThe mechanic's improper maintenance installation of the No. 1 cylinder rocker arms which led to oil starvation and a loss of engine power.Mar 13, 2008 · N6651F · Substantial damage