NTSB investigations: Lycoming 0-435A/0-435C, AK
14 cases on aircraft whose registry engine model is Lycoming 0-435A/0-435C. 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 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1993 | 1 |
| 1999 | 1 |
| 2017 | 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\" = 'AK' 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 ('41517'))
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" = 'AK' 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 ('41517'))
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 GAA17CA264Accident · No injuriesData collectionFinal reportStinson 108 · Pedro Bay, AKThe pilot’s failure to maintain directional control during the takeoff roll.NTSB ANC99LA137Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Chugiak, AKA partial failure of the brake system. A factor associated with the accident was a leaking brake system.NTSB ANC93LA140Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Near Skwentna, AKThe pilot in command's inadequate preflight planning and preparation. A factor in the accident was the pilot's lack of familiarity with the particular aircraft's performance.NTSB ANC85LA087Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Chugiak, AKWhile landing with a gusty x-wind, the acft bounced, the left wing dragged the ground & the acft went off the rwy. The plt stated that due to the x-wind & his foot slipping off of the rudder pedal, he was unable to maintain directional control.NTSB ANC84LA069Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Soldotna, AKThe acft was established in normal cruise when the engine quit. The pilot attempted restarts with negative results. The acft made a forced landing and collided with trees. Post accident examination revealed water in the fuel tanks & lines.NTSB ANC7LFAG50Accident · No injuriesClosedCessna 170 · Palmer, AKNTSB ANC74DAG91Accident · No injuriesClosedStinson 108-3 · Nicholi, AKNTSB ANC73FAG38Accident · No injuriesClosedBellanca 14-13 · Mcgrath, AKNTSB ANC72DAG79Accident · No injuriesClosedStinson 108-2 · Kodiak, AKNTSB ANC72DAG19Accident · No injuriesClosedStinson 108-3 · Anchorage, AKNTSB ANC71DAG24Accident · No injuriesClosedStinson 108-2 · Kenai, AKNTSB ANC69F0065Accident · Minor injuriesClosedNavion B · Agle River, AKNTSB ANC68D0087Accident · No injuriesClosedStinson 108-2 · Pilot Point, AKNTSB ANC66D0062Accident · No injuriesClosedStinson 108-2 · Bethel, AK