NTSB investigations: NONE, KY
9 cases on aircraft whose registry engine model is NONE. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1980 | 1 |
|---|---|
| 1983 | 1 |
| 1986 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2009 | 1 |
| 2022 | 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000'))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA22LA129Accident · No injuriesClass 4 · LimitedFinal reportLindstrand Balloons 60X · Louisville, KYThe pilot applicant’s delayed reaction to the balloon's increased rate of descent, which resulted in impact with a light pole.NTSB ERA09CA276Accident · Serious injuriesData collectionFinal reportArbc Inc DBA Lindstrand 60X · Louisville, KYThe passenger's inadequate bracing during landing.NTSB IAD05CA141Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 77A · Louisville, KYThe ground crewman's failure to release the basket of the balloon when it resumed flight during the landing phase. A factor in the accident was the wet grass at the landing site.NTSB NYC04LA078Accident · 1 fatalLimited investigationFinal reportRaven Industries Rally RX7 · Nicholasville, KYThe pilot's improper decision to continue the inadvertent flight in variable wind conditions, which resulted in an impact with power lines. Factors were the variable wind conditions and the unsuitable takeoff area.NTSB BFO94LA078Accident · Minor injuriesLimited investigationFinal reportCameron ET-90 · Louisville, KYThe pilot-in-command's failure to maintain clearance from wires during the landing approach. A factor related to the accident is a downdraft that exceeded the balloon's available climb capability.NTSB ATL90LA104Accident · No injuriesLimited investigationFinal reportBalloon Works 7B · Lexington, KYThe overload failure of several jumper cords. Factor(s) were inadvertent encounter with unfavorable wind (dust devil). Subsequently, the pilot was unable to control the rate of descent.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…NTSB ATL83LA325Accident · No injuriesLimited investigationFinal reportPiccard AX-6 · Louisvile, KYThe plt received a wx briefing at 0600 EDT & noted nothing significant that would be a hazard to flt. He proceeded to long run park, aprx 20 mi east of louisville, KY, to launch the ballon. There was a 654 foot tower in the vicinity, but the plt believed the…NTSB ATL80DLQ25Accident · Serious injuriesClosedSchweizer SGS233 · Frankfort, KY