NTSB investigations: Lycoming 0-320 series, KY
9 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2001 | 2 |
| 2006 | 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 ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 NYC06CA149Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Louisville, KYThe pilot's failure to maintain directional control during landing. A factor in the accident was the wet grassy runway.NTSB IAD01LA063Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Louisville, KYThe flight instructor's failure to maintain directional control after landing.NTSB NYC01LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Elizabethtown, KYThe pilot's failure to maintain directional control during the takeoff roll.NTSB IAD98LA076Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Somerset, KYthe pilot's failure to follow procedures to hand-prop the airplane.NTSB NYC94LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Falls Of Rough, KYThe pilot's inadequate tiedown and starting procedure which resulted in a runaway aircraft, which subsequently collided with a building.NTSB BFO93LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Falmouth, KYThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent swerve, and his delayed remedial action.NTSB BFO90LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Maryville, KYThe failure of a hydraulic brake line which resulted in a loss of fluid, and an inoperative brake system during landing roll.NTSB ATL83LA221Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Jackson, KYThe pilot reported that when he exited the helicopter for the purpose of retrieveing a map from below the plt's seat, the acft began to lift and move laterally. The acft then tipped over trapping his leg and hip beneath it. He stated that he had not fully…NTSB ATL83LA055Accident · No injuriesLimited investigationFinal reportPitts Special 51C · London, KYThe aircraft ground looped during landing. Investigation revealed there was slight crosswind and the tail wheel steering spring failed.