NTSB investigations: Lycoming 0-320 series, 1989
11 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Overrun”. 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 | 15 |
|---|---|
| 1983 | 22 |
| 1984 | 19 |
| 1985 | 12 |
| 1986 | 5 |
| 1987 | 6 |
| 1988 | 10 |
| 1989 | 11 |
| 1990 | 14 |
| 1991 | 10 |
| 1992 | 15 |
| 1993 | 12 |
| 1994 | 9 |
| 1995 | 7 |
| 1996 | 3 |
| 1997 | 8 |
| 1998 | 4 |
| 1999 | 8 |
| 2000 | 8 |
| 2001 | 4 |
| 2002 | 9 |
| 2003 | 9 |
| 2004 | 7 |
| 2005 | 6 |
| 2006 | 5 |
| 2007 | 2 |
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\") = 1989
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\" = 340))
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") = 1989
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" = 340))
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 ANC89LA179Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kiana Creek, AKImproper planning/decision by the pilot, and the premature lift-off. Factors related to the accident were: the unfavorable wind condition and the pilot's self-induced pressure.NTSB NYC89LA214Accident · No injuriesLimited investigationFinal reportCessna 172N · Bayport, NYThe pilot's misjudging speed and distance resulting in his overshooting the landing and running off the end of the runway.NTSB SEA89LA161Accident · No injuriesLimited investigationFinal reportCessna 172P · Alderwood Manor, WAImproper planning/decision by the pilot. The tailwind and high obstructions were related factors.NTSB DEN89LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Alpine, WYPilot's decision to land at an unlighted airport at night. The aircraft landed long and overran the runway.NTSB CHI89LA121Accident · No injuriesLimited investigationFinal reportCessna C172M · Wadsworth, OHPilot's poor planning/decision making during the approach and landing phase of flight, which resulted in a long landing and runway overrun.NTSB MKC89LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bolivar, MOImproper planning/decision by the pilot and his delay in aborting the takeoff. Contributing factors were the tall grass, inadequate runway maintenance, and trees.NTSB CHI89LA081Accident · No injuriesLimited investigationFinal reportCessna 172D · Ottawa, ILStudent pilot's continuing an approach to landing beyond the point where she could bring the aircraft to a controlled stop on the remaining runway surface.NTSB NYC89LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dushore, PACollision with trees during a rejected takeoff from a private turf strip due to the pilots failure to take advantage of the existing wind.NTSB NYC89LA117Accident · No injuriesLimited investigationFinal reportCessna 172M · Palmyra, PAThe pilot misjudged the airspeed and distance during the landing.NTSB NYC89LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Matawan, NJThe pilot's inadequate action after encountering tailwind conditions during landing.NTSB FTW89LA058Accident · No injuriesLimited investigationFinal reportCessna 172 · Marietta, OKFailure of the pilot to select the proper runway, which resulted in a downwind landing and an overrun of the runway. The gusty tailwind, ditch, and railing (fence) were factors.