NTSB investigations: Lycoming 0-235 series, DE
10 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
| 1965 | 1 |
|---|---|
| 1970 | 1 |
| 1975 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1989 | 3 |
| 1994 | 2 |
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 c.\"eventStateOrRegion\" = 'DE' 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 c."eventStateOrRegion" = 'DE' 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 BFO94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, DEInadequate clearance from obstacles, which resulted in birds strike. A factor was night conditions.NTSB BFO94LA033Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Georgetown, DEThe failure of ground personnel to maintain clearance from the engine propeller.NTSB BFO89LA073Accident · No injuriesLimited investigationFinal reportCessna 152 · Selbyville, DEExcessive wear of the number four exhaust lobe on the camshaft and poor condition (wear) of the number four exhaust tappet. The soybean crop in the emergency landing area was considered to be a factor.NTSB BFO89LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Dover Afb, DEThe pilot's improper flare, improper recovery from a bounced landing, and his delay in initiating a go-around, which resulted in an uncontrolled porpoise, loss of directional control, and an uncontrolled ground swerve. His lack of experience, a crosswind, and…NTSB BFO89FA020Accident · 1 fatalField investigationFinal reportCessna 152 · Townsend, DELoss of aircraft control for unknown reasons.NTSB NYC80DHD19Accident · No injuriesClosedPiper PA-12 · Rehoboth, DENTSB IAD78FHD22Accident · Minor injuriesClosedBellanca 7ECA · Selbyville, DENTSB IAD76DHD11Accident · Minor injuriesClosedAmerican AA1 · Delmar, DENTSB IAD70DHD33Accident · Minor injuriesClosedChampion 7ECA · Dover, DENTSB UNK65X1311Accident · No injuriesClosedPiper PA22 · Cheswold, DE