Fatal NTSB investigations: Lycoming 0-435
5 cases on aircraft whose registry engine model is Lycoming 0-435. 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
| 1982 | 2 |
|---|---|
| 1986 | 1 |
| 1993 | 1 |
| 2001 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41516'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41516'))
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 LAX01FA160Accident · 1 fatalField investigationFinal reportBellanca 14-19 · Casa Grande, AZA fuel leak on the cabin and engine sides of the firewall with a probable origin at the firewall pass-through fitting for the fuel pressure gage line. The fire likely began on the engine side of the firewall near the bottom with the explosive ignition of the…NTSB SEA93GA052Accident · 1 fatalFinal reportHiller UH-12E · Chinook, MTInattentive FBO personnel.NTSB ANC86FA116Accident · 2 fatalField investigationFinal reportStinson 108-2 · Willow, AKAbout 5 to 10 min prior to the acdnt, svrl witnesses in the vicinity of the Willow arpt saw the acft headed southbound. They rprtd the eng was running rough, but they saw no smoke or fire. Aprx 3 mi further south, other witnesses saw the acft make a 180 deg…NTSB LAX83LUQ02Accident · 2 fatalFinal reportStinson 108 · Santa Barbara, CAThe aircraft collided with a power line as the pilot was flying at low altitude near a highway at dusk. After hitting the power line, the plane fell to the ground and burned. Witnesses reported there was a low cloud cover and light rain. One witness stated…NTSB DEN82FTC09Accident · 1 fatalFinal reportBell 47G-3B-L · Kaycee, WYThe pilot was having cooling fan problems, some blades had broken. He landed in a canyon stayed overnight to cool engine and planned to fly to top of the canyon to get repairs. After takeoff, the helicopter had climbed almost level with the top of the canyon…