NTSB investigations: Lycoming GO-435C&D series
4 cases on aircraft whose registry engine model is Lycoming GO-435C&D series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1988 | 1 |
|---|---|
| 1994 | 1 |
| 1997 | 1 |
| 2002 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41521')
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\" = 353))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41521')
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" = 353))
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 MIA02LA116Accident · No injuriesLimited investigationFinal reportNavion Nav4 · Raleigh, NCthe pilot's inadequate preflight planning, improper fuel consumption calculations, and selection of the auxiliary fuel tank for landing, which resulted in a loss of engine power due to fuel starvation, and forced landing in trees. A factor in this accident…NTSB LAX97FA330Accident · 2 fatalField investigationFinal reportRyan Navion B · Pacoima, CAthe dual student's improper positioning of the fuel selector and the CFI's inadequate supervision, which led to a takeoff with the auxiliary fuel tank selected and resulted in fuel starvation. A contributing factor was the position of the nomenclature on the…NTSB ANC94LA117Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Anchorage, AKThe binding in the mechanical fuel selector valve, and lack of suitable terrain for a forced landing.NTSB MIA89LA038Accident · No injuriesLimited investigationFinal reportRyan Navion B · Vero Beach, FLThe plt stated that drg flt, the eng lost power & he was unable to restart it. Drg a forced landing in a field, the acft struck three cows that were in a ravine & moved in front of the acft as it was apchg to land. A post acdnt exam of the acft revealed there…