NTSB investigations: Lycoming IO-320 series, KS
12 cases on aircraft whose registry engine model is Lycoming IO-320 series. 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
| 1964 | 1 |
|---|---|
| 1966 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1974 | 1 |
| 1977 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 2002 | 1 |
| 2007 | 1 |
| 2017 | 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\" = 'KS' 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 ('41509'))
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" = 'KS' 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 ('41509'))
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 GAA19CA041Accident · No injuriesData collectionFinal reportVans RV 6 · Paola, KSThe pilot's failure to maintain directional control, which resulted in a runway excursion during the aborted landing and subsequent impact with vegetation and a nose-over.NTSB CEN17FA297Accident · 2 fatalField investigationFinal reportPiper PA30 · Topeka, KSThe failure of the pilot and flight instructor to maintain aircraft control while maneuvering in the traffic pattern.NTSB DEN07LA160Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lawrence, KSTotal failure of the landing gear retraction/extension assembly. Contributing factors in this accident were worn parts in the landing gear retraction/extension assembly, and mechanical binding of the extension assembly.NTSB CHI02LA219Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Abilene, KSThe pilot failed to achieve clearance over the trees and wires. Factors associated with the accident were the pilot failed to use all available runway, a downwind takeoff was performed, the tailwind, trees, and wires.NTSB MKC88LA016Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Leavenworth, KSWhile practicing landings and takeoffs, the PIC inadvertently put the gear switch in the retract cycle while rolling out. The gear began its retraction cycle with the acft still on the rwy, damaging the retraction system. The plt elected to tkof, but once…NTSB MKC85LA138Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Manhattan, KSThe plt said he put the landing gear selector switch to the down position and thought that he observed a green, down andlocked indicator light; however, the acft landed with the gear retracted. Examination of the acft after the accident revealed that the…NTSB MKC77FCQ43Accident · No injuriesClosedPiper PA-30 · Wichita, KSNTSB MKC75FCQ12Accident · Minor injuriesClosedBellanca 7KCAB · Liberal, KSNTSB MKC70AK039Accident · Minor injuriesClosedPiper PA-30 · Wichita, KSNTSB MKC70A0010Accident · No injuriesClosedPiper PA-30 · Topeka, KSNTSB MKC66D0579Accident · No injuriesClosedPiper PA-30 · Lawrence, KSNTSB UNK64X0176Accident · No injuriesClosedPiper PA30 · Lacrosse, KS