NTSB investigations: Lycoming 0-320 series, 1987, GA
8 cases on aircraft whose registry engine model is Lycoming 0-320 series. 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
| 1964 | 7 |
|---|---|
| 1965 | 11 |
| 1966 | 8 |
| 1967 | 5 |
| 1968 | 6 |
| 1969 | 9 |
| 1970 | 4 |
| 1971 | 15 |
| 1972 | 5 |
| 1973 | 4 |
| 1974 | 7 |
| 1975 | 3 |
| 1976 | 4 |
| 1977 | 3 |
| 1978 | 10 |
| 1979 | 5 |
| 1980 | 8 |
| 1981 | 9 |
| 1982 | 7 |
| 1983 | 4 |
| 1984 | 5 |
| 1985 | 7 |
| 1986 | 4 |
| 1987 | 8 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 6 |
| 1998 | 6 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 5 |
| 2002 | 6 |
| 2003 | 6 |
| 2004 | 4 |
| 2005 | 7 |
| 2006 | 5 |
| 2007 | 4 |
| 2008 | 7 |
| 2009 | 2 |
| 2010 | 5 |
| 2011 | 6 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 5 |
| 2023 | 4 |
| 2024 | 2 |
| 2026 | 3 |
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\") = 1987
AND c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
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'))
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") = 1987
AND c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA'
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'))
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 ATL88LA041Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Thomson, GAThe airplane struck high-tension power lines while maneuvering at about 100 ft AGL. The collision occurred about 2/10 of a mile from the residence of the plt's girlfriend. One of the wires fell to the ground, damaging an auto and setting a field on fire. The…NTSB ATL88LA033Accident · No injuriesLimited investigationFinal reportCessna 172K · Cumming, GAThe student plt rptd that the airplane contacted the rwy and bounced twice during the ldg flare. Once he got the airplane on the rwy, he realized that the airspeed was 'too high' for the rwy remaining and attempted to ground loop the airplane to stop it. The…NTSB ATL88LA021Accident · No injuriesLimited investigationFinal reportCessna 172P · Swainsboro, GAThe acft was being returned to its home base following a 100 hour inspection. The plt reported that the eng quit as he was descending prior to traffic pattern entry. An off airport landing was attempted. The landing gear was extensivelydamaged and the…NTSB ATL88LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Thomson, GADuring the ldg roll on rwy 28, a crosswind gust caused the airplane to become airborne again. The plt added full pwr and attempted to abort the ldg. The airplane subsequently drifted to the downwind side of the runway and impacted rising terrain. The plt…NTSB ATL87LA238Accident · No injuriesLimited investigationFinal reportCessna 172M · Marietta, GAThe student plt was returning to his home airport after receiving a notice of disapproval for his pvt plt practical test. While on final apch to land, he noted a quartering x-wind & elected to use the crab method for controlling drift. Just before touchdown,…NTSB ATL87LA227Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hopeful, GAThe plt was lndg on a unidirectional ag strip with a tail wind & a thunderstorm (tstm) nearby. He rprtd that drg the roll-out, a gust of wind from the tstm picked up the tail of the acft & flipped the plane over on its top. He estimated the wind was from the…NTSB ATL87FA212Accident · Serious injuriesField investigationFinal reportPiper PA-28 · Elberton, GAThe plt noted a progressive loss of pwr that began drg the climb to cruise. He diverted back toward the dep arpt & atmtdto restore pwr by activating the boost pump, moving the mixture to full rich, switching fuel tanks & applying carb heat. However, the eng…NTSB ATL87LA060Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Stockbridge, GADuring an attempted landing, the pilot lost directional control and veered off the right side of runway 29 and collided with a tree. The pilot reported that a gust of wind from the left resulted in the left wing rising about 7 feet. The pilot applied power…