NTSB investigations: Lycoming 0-320 series, 1987, IL
6 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 | 11 |
|---|---|
| 1965 | 16 |
| 1966 | 21 |
| 1967 | 23 |
| 1968 | 15 |
| 1969 | 17 |
| 1970 | 16 |
| 1971 | 21 |
| 1972 | 16 |
| 1973 | 15 |
| 1974 | 15 |
| 1975 | 20 |
| 1976 | 14 |
| 1977 | 15 |
| 1978 | 22 |
| 1979 | 13 |
| 1980 | 12 |
| 1981 | 15 |
| 1982 | 8 |
| 1983 | 8 |
| 1984 | 3 |
| 1985 | 4 |
| 1986 | 7 |
| 1987 | 6 |
| 1988 | 4 |
| 1989 | 6 |
| 1990 | 6 |
| 1991 | 7 |
| 1992 | 7 |
| 1994 | 4 |
| 1996 | 4 |
| 1997 | 5 |
| 1998 | 6 |
| 1999 | 5 |
| 2000 | 2 |
| 2001 | 8 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 4 |
| 2005 | 5 |
| 2006 | 6 |
| 2007 | 4 |
| 2009 | 1 |
| 2011 | 4 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 5 |
| 2018 | 3 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 6 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 3 |
| 2026 | 1 |
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 year(c.\"eventDate\") = 1987
AND c.\"eventStateOrRegion\" = 'IL' 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" = 'IL' 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 CHI87LA208Accident · No injuriesLimited investigationFinal reportCessna 172PC · Jerseyville, ILThe pilot and one passenger were returning from a local flight. It had become dark during their flight and as the pilot was approaching to land on runway 36 the landing gear of the aircraft struck a drainage ditch approximately 2-3 feet short of the runway.…NTSB CHI87FA212Accident · No injuriesField investigationFinal reportCessna 177 · Genoa, ILThe plt made a straight-in apch to land at dusk on an unlighted sod rwy. He stated he lowered 10 deg of flaps aprx 2 mi fm the rwy. While on final apch, with the power set at aprx 1800 RPM, the acft began to settle. The plt said he applied full power, but it…NTSB CHI87LA199Accident · No injuriesLimited investigationFinal reportCessna 172P · Wheeling, ILAccording to the plt, the lndg was normal until after touchdown when the acft bgn to 'track' toward the rgt side of the rwy. The plt said he applied left rudder, but the acft contd off the rgt side, went into a drainage ditch with standing water & nosed over.NTSB CHI87DEE07Accident · No injuriesFinal reportCessna 172 · Lansing, ILThe pilot stated that due to an RPM fluctuation he had diverted to an alternate arpt. He attempted to land on rwy 27 when the wind was from 020 degrees 14 KTS gusting 30 knots. The flap operation was also erratic according to the plt. The acft ran off the…NTSB CHI87IA110Incident · 1 fatalIncident investigationFinal reportCessna 172L · Plainfield, ILThe pilot decided the weather was not good enough to fly, but he would run the engine and turn the tires. He was discovered in the plane by other pilots and later pronounced dead, from carbon monoxide asphyxiation. The muffler had a 12 inch crack which a…NTSB CHI87LA093Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Genoa, ILThe aircraft experienced a loss of power on takeoff, for undetermined reasons, and was forced to make an emergency landing. On impact the nose gear and main landing gear sheared off.