NTSB investigations: Lycoming 0-235 series, 1983, AL
4 cases on aircraft whose registry engine model is Lycoming 0-235 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 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1968 | 1 |
| 1970 | 2 |
| 1972 | 1 |
| 1975 | 2 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 3 |
| 1979 | 1 |
| 1980 | 2 |
| 1981 | 3 |
| 1982 | 1 |
| 1983 | 4 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2008 | 3 |
| 2015 | 2 |
| 2018 | 1 |
| 2022 | 1 |
| 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\") = 1983
AND c.\"eventStateOrRegion\" = 'AL' 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 ('41505'))
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") = 1983
AND c."eventStateOrRegion" = 'AL' 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 ('41505'))
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 ATL84LA008Accident · No injuriesLimited investigationFinal reportCessna 152II · Hamilton, ALThe acft made a hard landing during a x-country flt. The acft was seen to make a slow approach and stall prior to touchdown. The acft landed hard and bounced after which the nose gear was damaged. The student plt had not landed at this arpt before.NTSB ATL83LA375Accident · No injuriesLimited investigationFinal reportBeech 77 · Montgomery, ALThe student plt flew to Montgomery, AL, intending to make a touch-and-go landing, and then return to birmingham, AL. After arriving, he made an apch to rwy 09 with a wind from 360 deg at 10 gusting 14 KTS. While on the landing roll, the acft began to veer to…NTSB ATL83LA349Accident · Serious injuriesLimited investigationFinal reportJohnston Long E-Z · Pell City, ALThe acft crashed while attempting a downwind takeoff in high winds and heavy rain. The pilot said he was trying to take off before the heavy rain so he picked a rwy pointing into clear weather but with a tailwind. The tailwind increased during the takeoff…NTSB ATL83LA152Accident · No injuriesLimited investigationFinal reportCessna 152 · Verbena, ALThe acft collided with a wire cable during a simulated emergency landing to an open field off the arpt. The pilot said he was flying locally and saw a field that looked large enough to land in so he reduced power to idle and was making a simulated emergency…