NTSB investigations: Lycoming 0-320 series, 1996
22 cases on aircraft whose registry engine model is Lycoming 0-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 | 20 |
|---|---|
| 1983 | 12 |
| 1984 | 16 |
| 1985 | 15 |
| 1986 | 13 |
| 1987 | 21 |
| 1988 | 8 |
| 1989 | 13 |
| 1990 | 5 |
| 1991 | 12 |
| 1992 | 12 |
| 1993 | 15 |
| 1994 | 19 |
| 1995 | 12 |
| 1996 | 22 |
| 1997 | 15 |
| 1998 | 16 |
| 1999 | 20 |
| 2000 | 16 |
| 2001 | 12 |
| 2002 | 22 |
| 2003 | 12 |
| 2004 | 16 |
| 2005 | 13 |
| 2006 | 16 |
| 2007 | 11 |
Where
Latest 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 year(c.\"eventDate\") = 1996
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\" = 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 year(c."eventDate") = 1996
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" = 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 LAX97LA053Accident · No injuriesLimited investigationFinal reportCessna 172P · Van Nuys, CAimproper flare by the pilot during the landing, and his improper recovery from a bounced landing, which resulted in a hard landing, dragged wing tip, and a collapsed main gear.NTSB MIA97LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot's improper flare and improper recovery from a ballooned/bounced landing. The gusty wind was a related factor.NTSB CHI97LA026Accident · No injuriesLimited investigationFinal reportCessna 172P · Waukegan, ILthe pilot's improper recovery from a bounced landing. A factor was the pilot's misjudging the flare.NTSB CHI96LA326Accident · No injuriesLimited investigationFinal reportCessna 172 · Chicago, ILthe pilot's improper flare and improper recovery from a bounced landing. A factor relating to the accident was: the pilot's lack of experience (or lack of training) in recovery from bounced landings.NTSB NYC96LA180Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, MEthe student pilot's improper flare, which resulted in at hard landing.NTSB LAX96LA324Accident · No injuriesLimited investigationFinal reportCessna 172N · Auburn, CAthe pilot's misjudged landing flare and improper bounced landing recovery. A contributing factor was his lack of recent flying experience.NTSB CHI96LA283Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rensselaer, INthe student pilot's improper flare and improper recovery from a bounced landing.NTSB IAD96LA119Accident · No injuriesLimited investigationFinal reportCessna 172M · Tremont City, OHthe student pilot's misjudged flare which resulted in a hard landing.NTSB NYC96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeport, CTthe student pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB LAX96LA250Accident · No injuriesLimited investigationFinal reportCessna 172 · Camarillo, CAthe student pilot misjudged the landing flare resulting in a hard landing. A factor in the accident was high airspeed.NTSB LAX96LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Avalon, CAthe pilot's failure to initiate a landing flare, which resulted in a bounced landing and porpoise, and his loss of directional control during an attempt to initiate a go-around with insufficient airspeed, which resulted in an inadvertent stall/mush and…NTSB LAX96LA246Accident · No injuriesLimited investigationFinal reportCessna 172M · Sedona, AZthe pilot's improper recovery from a bounced landing. The variable/gusty/quartering tail wind was a related factor.NTSB FTW96LA245Accident · No injuriesLimited investigationFinal reportBeech 23 · Weiner, ARan improper flare by the pilot, which resulted in a hard landing.NTSB LAX96LA237Accident · No injuriesLimited investigationFinal reportCessna 172N · Ramona, CAthe pilot's misjudged and delayed landing flare, and inadequate recovery technique from a bounced landing (porpoise). Sun glare was a factor in the accident.NTSB IAD96LA084Accident · No injuriesLimited investigationFinal reportCessna 172M · Findlay, OHthe student pilot's misjudged flare during landing.NTSB ANC96LA057Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe pilot's inadequate compensation for the wind conditions. A factor in the accident was the gusty wind conditions.NTSB FTW96LA191Accident · No injuriesLimited investigationFinal reportCessna 172P · Denton, TXthe student pilot's delayed landing flare and his improper bounced landing recovery technique.NTSB SEA96LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Cheyenne, WYthe pilot's improper flare during the landing and improper recovery from the subsequent bounced landing. A factor relating to the accident was: the pilot's failure to maintain the proper approach path during the approach for landing.NTSB SEA96LA077Accident · No injuriesLimited investigationFinal reportCessna 172P · Friday Harbor, WAthe pilot's misjudgment of the aircraft's altitude above the runway and failure to flare for landing. Darkness (bright night) was a related factor.NTSB MIA96LA105Accident · No injuriesLimited investigationFinal reportCessna 172N · New Smyrna Bch, FLThe student pilot's improper flare and improper recovery from a bounced landing, which resulted in an inadvertent porpoise, and subsequent overload failure of the nose gear.NTSB CHI96LA097Accident · No injuriesLimited investigationFinal reportCessna 172P · West Chicago, ILthe student pilot's misjudging the flare. A factor was the gusts.NTSB FTW96LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Norman, OKthe student pilot's improper level-off during landing.