Skip to content

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

84 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, newest first

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."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.\"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."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 ANC72DAG19Accident · No injuriesClosedStinson 108-3 · Anchorage, AKAug 16, 1971 · N6175M · Substantial damage NTSB MKC72FCD08Accident · No injuriesClosedBell 47-G5 · New Market, IAJul 20, 1971 · N4705R · Destroyed NTSB OAK71FVG37Accident · No injuriesClosedStinson L-5B · Auburn, CANov 14, 1970 · N6709C · Substantial damage NTSB LAX71AL025Accident · 1 fatalClosedBellanca 14-133 · San Fernando, CANov 7, 1970 · N6513N · Destroyed NTSB ANC71DAG24Accident · No injuriesClosedStinson 108-2 · Kenai, AKSep 14, 1970 · N97978 · Substantial damage NTSB MKC70F0297Accident · No injuriesClosedDowner 14-19 · Sibley, MOOct 25, 1969 · N6557N · Substantial damage NTSB DEN70F0066Accident · No injuriesClosedStinson 108-3 · Silver City, NMAug 9, 1969 · N6539M · Substantial damage NTSB LAX70F0084Accident · Minor injuriesClosedStinson L-5 · Daggett, CAAug 7, 1969 · N51130 · Substantial damage NTSB MIA69F0416Accident · 1 fatalClosedStinson 108-2 · Russellville, ALFeb 21, 1969 · N97478 · Destroyed NTSB OAK69D0181Accident · No injuriesClosedStinson 108-2 · Atwater, CADec 5, 1968 · N9425K · Substantial damage NTSB NYC69D0012Accident · No injuriesClosedBellanca 14-13 · Collegeville, PAJun 16, 1968 · N74444 · Substantial damage NTSB NYC69D0195Accident · Minor injuriesClosedStinson L5G · Apalachin, NYJun 8, 1968 · N63373 · Substantial damage NTSB ANC69F0065Accident · Minor injuriesClosedNavion B · Agle River, AKMay 10, 1968 · N5408K · Substantial damage NTSB FTW68F0547Accident · Minor injuriesClosedBellanca 14-13 · Austin, TXApr 4, 1968 · N61X · Substantial damage NTSB OAK68F0348Accident · No injuriesClosedBellanca 14-19 · Sacramento, CAApr 3, 1968 · N6585N · Substantial damage NTSB FTW68D0497Accident · No injuriesClosedStinson 108-3 · Beaver, OKMar 18, 1968 · N6175M · Substantial damage NTSB ANC68D0087Accident · No injuriesClosedStinson 108-2 · Pilot Point, AKSep 21, 1967 · N9510K · Substantial damage NTSB MKC68F0192Accident · Minor injuriesClosedBellanca 14-19 · Vichy, MOAug 16, 1967 · N526A · Destroyed NTSB FTW67F0625Accident · No injuriesClosedStinson 108-2 · Wright City, TXMay 26, 1967 · N9601K · Substantial damage NTSB OAK67F0288Accident · No injuriesClosedStinson L-5 · Waianae, HIApr 30, 1967 · N5614V · Substantial damage NTSB MIA67D0114Accident · No injuriesClosedCessna 170B · Lakeport, FLJul 3, 1966 · N2784C · Substantial damage NTSB MKC66F0367AccidentClosedStinson L-5 · Desoto, KSJan 13, 1966 · N7605B · Substantial damage NTSB NYC66D0373Accident · No injuriesClosedStinson L-5E · Mechanicsville, VADec 15, 1965 · N3707C · Substantial damage NTSB DEN66D0057Accident · No injuriesClosedBellanca 14-19 · Ft Grant, AZJun 26, 1965 · N6575N · Substantial damage NTSB ANC66D0062Accident · No injuriesClosedStinson 108-2 · Bethel, AKJun 23, 1965 · N9688K · Substantial damage NTSB DEN65D0085Accident · No injuriesClosedBellanca 14-19 · Bowie, AZApr 17, 1965 · N6575N · Substantial damage NTSB UNK65X0203Accident · No injuriesClosedBellanca 1413 · Hartford City, INOct 9, 1964 · N86703 · Substantial damage NTSB UNK64X3950Accident · Serious injuriesClosedBellanca 1419 · Willits, CASep 12, 1964 · N508A · Substantial damage NTSB UNK64X3601Accident · No injuriesClosedStinson 108-2 · Sterling, ILAug 26, 1964 · N9666K · Substantial damage NTSB UNK64X2261Accident · No injuriesClosedStinson 108-3 · Silver City, NMJun 13, 1964 · N573C · Substantial damage NTSB UNK64X1866Accident · No injuriesClosedBellanca 1419 · Gardenville, PAMay 21, 1964 · N511A · Substantial damage NTSB UNK64X1849Accident · No injuriesClosedStinson L5 · Cheyenne, WYMay 19, 1964 · N68589 · Substantial damage NTSB UNK64X0484Accident · No injuriesClosedBellanca 1419 · Tatum, NMFeb 7, 1964 · N6590N · Substantial damage NTSB UNK64X0115Accident · No injuriesClosedBellanca 1419 · Holly Spring, MSJan 2, 1964 · N6577N · Substantial damage