NTSB investigations: Lycoming IO-320 series
15 cases on aircraft whose registry engine model is Lycoming IO-320 series, where the first occurrence was “In flight collision with object”. 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
| 1985 | 1 |
|---|---|
| 1986 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 2 |
| 1996 | 2 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 2 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41509')
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\" = 220))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41509')
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" = 220))
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 ATL04FA027Accident · 1 fatalField investigationFinal reportPiper PA-30 · Spartanburg, SCThe pilot's failure to follow IFR procedures and descent below the glide path, which resulted in an inflight collision with trees during an instrument approach. A factor was the pilot's impairment due to the sedating effects of medication.NTSB CHI03LA212Accident · No injuriesLimited investigationFinal reportCessna 172P · Pinckneyville, ILThe planned approach not maintained by the pilot and the delayed remedial action by the certified flight instructor. A contributing factor to the accident was the approach light.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 IAD01LA106Accident · Serious injuriesLimited investigationFinal reportDigimas Starduster Too · Watertown, CTthe student pilot's inattention while maneuvering at low altitude, which resulted in collision with trees. A factor in the accident was the student pilot's intentional low-altitude maneuvering.NTSB CHI01LA221Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bowman, NDAltitude/clearance not obtained by the pilot during the initial climb. Factors relating to the accident were attaining the proper climb rate not being possible, the microburst, the dark night, and the tree.NTSB ANC96LA155Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Skwentna, AKthe pilot's improper planning/decision. Related factors were: the terrain condition, unfavorable (lee-side) wind, and trees.NTSB LAX96FA290Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Mound House, NVthe flight instructor's improper in-flight planning/decision by allowing the student pilot to get too low during a simulated emergency landing before initiating a go-around.NTSB LAX94FA047Accident · 1 fatalField investigationFinal reportPiper PA-30 · Brea, CAThe pilot's choice of an inadequate cruise altitude over rolling hill terrain which resulted in an in-flight collision with helium balloons and an in-flight loss of control for undetermined reasons. A factor in the accident was the pilot's inadequate visual…NTSB NYC93LA132Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Mitchellville, MDThe failure of the pilot to maintain a proper glide path during the final approach, which resulted in the airplane striking a moving vehicle.NTSB CHI91LA209Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Hill City, SDPoor preflight planning by the pilot and over confidence in the aircrafts ability. Factors related to the accident were a high density altitude and a proper climb rate not attained.NTSB MIA90IA072Incident · No injuriesIncident investigationFinal reportPiper PA-30 · Tallahassee, FLProper glidepath not maintained.NTSB FTW90LA047Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Stephenville, TXImproper planning/decision by the pilot.NTSB CHI89LA053Accident · No injuriesLimited investigationFinal reportAeronca 7KCAB · Pine Creek, WIThe pilot's selection of unsuitable terrain which resulted in the failure to achieve a proper climb rate which resulted in the collision with trees. Contributing to the accident was the uphill, snow covered terrain.NTSB MIA86LA141Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · New Smyrna Bch, FLDuring a pickup of an aerial advertising banner the acft struck the pickup bridle with the left main landing gear. He stated that he was unable to climb. The acft then stalled and crashed along the arpt boundary in a swamp.NTSB ATL85LA257Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Portland, TNThe plt made a visual aprch to the wrong airport & attempted to go-around. During the go-around the acft coll ided with trees on the departure end of the rwy.