NTSB investigations: Lycoming VO-435 series, GA
7 cases on aircraft whose registry engine model is Lycoming VO-435 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
| 1977 | 2 |
|---|---|
| 1980 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 1995 | 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.\"eventStateOrRegion\" = 'GA' 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 ('41525'))
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" = 'GA' 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 ('41525'))
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 ATL03LA007Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Highfalls, GAThe pilots inadequate fuel management, and subsequent loss of engine power due to fuel exhaustion, and a in-flight collision with trees during an autorotation. A factor was the pilot's failure to insure that the required equipment (fuel gauge) was installed…NTSB ATL95LA145Accident · No injuriesLimited investigationFinal reportBell 47G2 · Montrose, GAThe pilot's inadequate preflight planning and visual lookout.NTSB ATL89FA193Accident · 1 fatalField investigationFinal reportTexas Helicopter OH-13/M74 · Norman Park, GAImproper planning/decision by the pilot, which resulted in his physical impairment from exposure to lannate, and his failure to maintain altitude/clearance above the ground. A factor related to the accident was: failure of the pilot to use a respirator while…NTSB MIA85LA207Accident · No injuriesLimited investigationFinal reportQuinn EL Tomcat MK-5A · Blakley, GAWhile en route to reposition the helicopter to another farm, the eng lost power. The plt reported that during an autorotation, the main rotor lost some RPM as he stretched his glide to avoid a fence. As the helicopter touched down on uneven terrain, the main…NTSB ATL80FLA06Accident · No injuriesClosedTom Cat MK-5A · Quitman, GANTSB MIA77FKG51Accident · Minor injuriesClosedEL Tomcat MK5A · Colquitt, GANTSB MIA77FKG27Accident · Serious injuriesClosedEL Tomcat MK5A · Ray City, GA