NTSB investigations: Lycoming IO-320 series
16 cases on aircraft whose registry engine model is Lycoming IO-320 series, where the first occurrence was “Hard landing”. 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 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2000 | 2 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 3 |
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\" = 200))
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" = 200))
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 CHI08CA036Accident · No injuriesData collectionFinal reportPiper PA-30 · Lonoke, ARThe pilot's misjudgment of the landing flare resulting in a hard landing.NTSB NYC07CA216Accident · No injuriesData collectionFinal reportPiper PA28-161 · William-Sodus, NYThe pilot's improper flare at touchdown, which resulted in a hard landing.NTSB DFW07LA075Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lubbock, TXThe pilot's improper landing flare. A contributing factor was the prevailing tailwind.NTSB NYC06CA221Accident · No injuriesData collectionFinal reportCessna 172P · Baltimore, MDThe pilot's improper flare, which resulted in a hard landing.NTSB MIA05CA061Accident · No injuriesData collectionFinal reportCessna 172 · Brooksville, FLThe pilot's improper landing flare which resulted in substantial damage during the subsequent hard landing.NTSB IAD04CA006Accident · No injuriesData collectionFinal reportPiper PA-30 · Louisville, KYThe pilot's improper flare, which resulted a hard landing. A factor was the glare from the setting sun.NTSB CHI00LA232Accident · No injuriesLimited investigationFinal reportCessna 152 · Indianapolis, INthe non-pilot rated passenger's improper flare and not relinquishing the controls, and the pilot's inadequate remedial action and the pilot's poor decision to practice instruction with an unqualified pilot prior to becoming a Certified Flight Instructor.NTSB MIA00LA136Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Immokalee, FLthe pilot misjudged the flare resulting in a hard landing short of the intended landing site, subsequently impacting the ground, and nosing over.NTSB NYC96LA069Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · South Wales, NYthe pilot's improper flare and failure to maintain directional control during landing.NTSB ANC95LA155Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Big Lake, AKThe pilot's failure to maintain a proper rate of descent during the approach to land, and his misjudgment of altitude to flare for landing on glassy water. The glassy water condition was a related factor.NTSB BFO88LA072Accident · No injuriesLimited investigationFinal reportPiper PA-30-160R · Chantilly, VAThe instr & stu plt were doing a practice landing on rwy 27 at the front royal airport when the acft landed hard and bounced about 20 ft high. A go around was made, however, the landing gear would not retract. After two flyovers of the arpt it was confirmed…NTSB LAX86LA246Accident · No injuriesLimited investigationFinal reportBellanca Kcab · Taft, CAThe citabrea bounced on landing and ground looped on the runway. The pilot indicated that on touchdown the aircraft bounced. Throttle was advanced and on the second touchdown the aircraft veered left. The left wing rose placing the aircraft on the right main…NTSB CHI84LA400Accident · Minor injuriesLimited investigationFinal reportSteen Skybolt · Valparaiso, INThe acft dragged a wing and flipped over after the plt made a hard landing and lost control. The plt attempted a go-around in an uncontrolled situation. The acft was destroyed.NTSB MIA83LA171Accident · No injuriesLimited investigationFinal reportCessna 172P · Clearwater, FLThe plt reported that during the landing, the acft bounced twice, then on the 3rd touchdown, the nose gear collapsed. An investigation revealed the acft was loaded beyond its max limited by an estimated 246 lbs.NTSB MKC83LA009Accident · No injuriesLimited investigationFinal reportSmith Miniplane · Bates City, MOThe pilot stated he landed on a sod strip which has a slight uphill incline. He stated the touchdown was hard and the main gear splayed out. The struts then dug into the sod and the aircraft nosed over.NTSB MIA82DA070Accident · No injuriesFinal reportPiper PA-30 · Crescent City, FLThe pilot landed on an upward sloping runway in very calm wind conditions. He stated that he failed to properly monitor the airspeed on final approach, and when he chopped the power, it resulted in a hard landing.