NTSB investigations: Hughes 269B, KY
9 cases on aircraft the registry lists as Hughes 269B. 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
| 1966 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1974 | 2 |
| 1985 | 1 |
| 1997 | 1 |
| 2003 | 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.aircraft_model_code IN ('4470502'))
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.aircraft_model_code IN ('4470502'))
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 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 NYC97LA138Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Paducah, KYThe failure of maintenance personnel to identify and correct the worn holes on the lower fuselage fairing and the failure of the flight instructor to maintain main rotor RPM during the autorotative landing. A contributing factor was the flight instructor's…NTSB ATL85LA287Accident · No injuriesLimited investigationFinal reportHughes 269A · Winchester, KYThe accident occurred as the student pilot was attempting to takeoff for hover training. As the pilot was applying collective torque, the student said, he lost control and crashed. There were no system malfunctions or failures reported.NTSB IAD75FLQ02Accident · No injuriesClosedHughes 269B · Dreyfus, KYNTSB IAD74FLQ21Accident · Minor injuriesClosedHughes 269B · Louisville, KYNTSB CHI72FLQ22Accident · No injuriesClosedHughes 269B · Louisville, KYNTSB CHI70D0172Accident · No injuriesClosedHughes 269B · Paint Lick, KYNTSB CHI69F0074Accident · Minor injuriesClosedHughes 269B · Louisville, KYNTSB CHI67A0057Accident · 1 fatalClosedHughes 269B · Lexington, KY