NTSB investigations: Lycoming 0-435A/0-435C, CA
13 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
| 1964 | 1 |
|---|---|
| 1968 | 2 |
| 1969 | 1 |
| 1970 | 2 |
| 1977 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1990 | 1 |
| 2002 | 1 |
| 2006 | 1 |
| 2009 | 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\" = 'CA' 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" = 'CA' 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 WPR09LA290Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · Columbia, CAThe failure of the left main landing gear drag link as a result of overstress fracture. Contributing to the accident was maintenance personnel's failure to detect a small crack in the left main landing gear drag link during the most recent annual inspection.NTSB LAX06FA233Accident · 1 fatalField investigationFinal reportBellanca 14-19 · Arcata, CAThe pilot's failure to follow the prescribed instrument approach procedure and to maintain the proper glide slope and altitude/clearance from obstacles while on an instrument landing system approach, resulting in a collision with trees. Contributing to the…NTSB LAX03LA032Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · Napa, CAthe pilot's inadequate management of the fuel system, which led to fuel starvation and a water ditching.NTSB LAX90LA272Accident · Minor injuriesLimited investigationFinal reportStinson L-5B · Victorville, CAThe oil gauge line 'b' nut backed off, and the pilot failed to maintain airspeed.NTSB LAX81DVG37Accident · Minor injuriesClosedStinson L-5 · Calavares, CANTSB OAK79DVA26Accident · No injuriesClosedRyan ST3KR · Fresno, CANTSB OAK78FVD03Accident · No injuriesClosedStinson L-5 · San Rafael, CANTSB OAK71FVG37Accident · No injuriesClosedStinson L-5B · Auburn, CANTSB LAX71AL025Accident · 1 fatalClosedBellanca 14-133 · San Fernando, CANTSB LAX70F0084Accident · Minor injuriesClosedStinson L-5 · Daggett, CANTSB OAK69D0181Accident · No injuriesClosedStinson 108-2 · Atwater, CANTSB OAK68F0348Accident · No injuriesClosedBellanca 14-19 · Sacramento, CANTSB UNK64X3950Accident · Serious injuriesClosedBellanca 1419 · Willits, CA