NTSB investigations: Lycoming 0-235 series, 1982, LA
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 |
|---|---|
| 1966 | 3 |
| 1968 | 1 |
| 1971 | 1 |
| 1973 | 3 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 4 |
| 1979 | 2 |
| 1980 | 6 |
| 1981 | 3 |
| 1982 | 4 |
| 1983 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2008 | 1 |
| 2016 | 1 |
| 2020 | 1 |
| 2021 | 1 |
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\") = 1982
AND c.\"eventStateOrRegion\" = 'LA' 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") = 1982
AND c."eventStateOrRegion" = 'LA' 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 FTW82DA392Accident · No injuriesFinal reportCessna 152 · Parks, LAThe pilot stated that the aircraft ran out of fuel. The fuel gauges were still registering 1/4 full on both tanks when the engine quit. In addition the pilot stated, "if I had dipped the tanks on preflight I would have known exactly how much fuel was in the…NTSB FTW82DA234Accident · No injuriesFinal reportBeech 77 · Jackson, LAWhile in the vicinity of Jackson, LA, the instructor pilot (ip) had the student make a simulated forced landing. The landing was to be to a full stop on the Jackson airport. According to the initial modification, the student allowed the aircraft to drift left…NTSB FTW82DA124Accident · No injuriesFinal reportCessna 152 · Lafayette, LAEn route to Lafayette, LA on a cross country the engine quit. A forced landing in a soft plowed field caused the landing gear to separate and the aircraft to nose over.NTSB FTW82DA102Accident · No injuriesFinal reportCessna 152 · New Orleans, LAThe student pilot was doing touch and go landings on runway 36. The wind was 290 degrees at 10 KTS. During a landing roll the student lost control and departed the left side of the runway. The aircraft sank into the mud and nosed over.