NTSB investigations: Lycoming 0-320 series, 1999
20 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\") = 1999
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") = 1999
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 ATL00LA022Accident · No injuriesLimited investigationFinal reportCessna 172N · Melbourne, FLThe certified flight instructor's improper touchdown flare that resulted in a hard landing.NTSB LAX00LA031Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZThe pilot's misjudged landing flare and failure to maintain an adequate airspeed margin, which resulted in a stall/mush and hard landing.NTSB FTW00LA014Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Jonesboro, ARThe flight instructor's delay in taking remedial action to recover from a low rotor rpm situation. A factor was the student's failure to maintain adequate rotor rpm.NTSB FTW99LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Longview, TXThe pilot's improper touchdown technique, which resulted in the airplane porpoising.NTSB LAX99LA300Accident · Minor injuriesLimited investigationFinal reportRobinson R-22-BETA · Piute, NVthe failure of the pilot to maintain rotor rpm while practicing autorotations, resulting in a hard landing and roll over.NTSB ANC99LA148Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Sleetmute, AKThe pilot's selection of an unsuitable landing area. A factor in this accident was the rough and uneven gravel bar.NTSB MIA99LA239Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot misjudged the flare, resulting in the nose gear impacting the runway, and a bounced landing.NTSB LAX99LA286Accident · No injuriesLimited investigationFinal reportCessna 177 · Carson City, NVThe pilot's use of an excessive approach reference airspeed, his misjudged landing flare, and subsequent hard landing/porpoise. A contributing factor was the airplane's excessive approach airspeed.NTSB ANC99LA135Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Fairbanks, AKThe pilot's inadvertent stall during the landing flare.NTSB LAX99LA265Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Coalinga, CAThe flight instructor's failure to maintain a sufficient airspeed to compensate for the known wind shear condition, which resulted in a failure to maintain runway alignment and a hard landing. The flight instructor's inadequate supervision of the flight was…NTSB ATL99LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · Kissimmee, FLThe pilot's improper flare and recovery from a bounced landing.NTSB LAX99LA250Accident · No injuriesLimited investigationFinal reportCessna 172M · Fresno, CAThe pilot's misjudged landing flare and inadequate recovery procedures from the subsequent bounced landing.NTSB DEN99LA106Accident · No injuriesLimited investigationFinal reportCessna 172N · Platteville, COThe pilot misjudging the flare altitude, resulting in a hard landing, and his subsequent loss of aircraft control. A factor was overload forces collapsing the nose landing gear assembly.NTSB SEA99LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Easton, WAThe flight instructor's delayed remedial action. Factors include the student allowing the aircraft to climb too steeply at too low an airspeed, and the soft/rough terrain on which the aborted takeoff took place.NTSB ANC99LA069Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's failure to compensate for the wind conditions and maintain a proper rate of descent during the approach for landing, which resulted in a hard landing, and the subsequent collapse of the right main landing gear strut.NTSB CHI99LA148Accident · No injuriesLimited investigationFinal reportCessna 172 · Blair, NEThe pilot's misjudged landing flare.NTSB FTW99LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Cleburne, TXThe pilot's improper flare which resulted in a hard landing and his improper recovery procedures from a bounced landing.NTSB ANC99LA035Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Healy, AKThe pilot's inadequate recovery from a bounced landing. A factor associated with the accident was a snowbank.NTSB MIA99LA080Accident · No injuriesLimited investigationFinal reportCessna 172P · Cleveland, MSThe pilot's improper recovery from a bounced landing, resulting in a blown nose tire, loss of directional control, and subsequent collision with terrain.NTSB SEA99LA026Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe pilot's failure to maintain aircraft control.