NTSB investigations: Lycoming 0-435A/0-435C, TX

6 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19672026

NTSB investigations: Lycoming 0-435A/0-435C, TX per year, 1967–2026: 6 cases
1967	1
1968	1
1980	1
1992	1
1997	1
2024	1

Where

Open the map

Latest cases

Query with SQL

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" = 'TX' 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

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\" = 'TX' 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" = 'TX' 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

Run 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 CEN25LA030Accident · No injuriesClass 4 · LimitedFinal reportStinson L-5 · Pleasanton, TXThe pilot’s failure to maintain control of the airplane during the landing.Oct 26, 2024 · N9HU · Substantial damage NTSB FTW97LA148Accident · No injuriesLimited investigationFinal reportStinson L5 · Lancaster, TXFailure of the pilot of the Stinson L5, N57789, to see and avoid the RV-6, N139TX.Mar 18, 1997 · N57789 · 2 aircraft · Substantial damage NTSB FTW93LA003Accident · 1 fatalLimited investigationFinal reportCessna Ector 305A · Houston, TXThe pilot of the other aircraft's inadvertent ground loop. Factors were the left quartering tailwind and this pilot's inability to see the other airplane during the landing roll.Oct 3, 1992 · N910E · 2 aircraft · Destroyed NTSB FTW80FRG73Accident · Minor injuriesClosedStinson 108-3 · Junction, TXSep 20, 1980 · N6948M · Substantial damage NTSB FTW68F0547Accident · Minor injuriesClosedBellanca 14-13 · Austin, TXApr 4, 1968 · N61X · Substantial damage NTSB FTW67F0625Accident · No injuriesClosedStinson 108-2 · Wright City, TXMay 26, 1967 · N9601K · Substantial damage