NTSB investigations: Lycoming 0-235 series, SC
4 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “On ground/water collision with object”. 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
| 1983 | 1 |
|---|---|
| 1988 | 1 |
| 1995 | 1 |
| 1998 | 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 c.\"eventStateOrRegion\" = 'SC' 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310))
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" = 'SC' 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310))
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 MIA98LA077Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Georgetown, SCthe pilot's decision to attempt a takeoff from an unsuitable area of roadway, following a forced landing after the engine had lost power, due to fuel exhaustion; and his failure to maintain clearance from obstructions, while attempting the takeoff. The…NTSB ATL95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · N. Myrtle Beach, SCThe improper starting procedure used by the pilot in that he failed to use wheel chocks to preclude aircraft movement. Additionally, the throttle was not placed in the idle position.NTSB ATL88IA144Incident · No injuriesIncident investigationFinal reportCessna 152 · York, SCThe acft was to be ferried back to the home arpt after an eng overhaul. The plt rprtd it was located on rough/sod & required full power to taxi from the parking area. After the acft began moving, he attempted to make a rgt turn onto the taxiway. However, he…NTSB ATL83LA296Accident · No injuriesLimited investigationFinal reportCessna T210N · N. Myrtle Beach, SCCessna T-210N, N6190C was struck by Piper J-3C, N42183, while taxiing at grand strand arpt. N6190C was not in motion at the time of collision and had taxied into the grass and turned off the acft eng in anticipation of the collision. The plt of N42183 stated…