Skip to content

NTSB investigations: Lycoming 0-235 series

4,598 cases on aircraft whose registry engine model is Lycoming 0-235 series. 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 ('41505')) 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 ('41505'))
  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 ('41505'))
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 CHI74FEP41Accident · No injuriesClosedAmer Avco AA-1B · Waunakee, WIApr 15, 1974 · N9621L · Substantial damage NTSB CHI74FEK20Accident · No injuriesClosedBellanca 7ECA · Lancaster, OHApr 7, 1974 · N41693 · Substantial damage NTSB CHI74AC082Accident · 1 fatalClosedAmer Avco AA1-A · Rattlesnk Is, OHApr 4, 1974 · N9229L · Substantial damage NTSB MIA74DKT67Accident · No injuriesClosedAmer Avco AA-1B · Homestead, FLMar 28, 1974 · N6522L · Substantial damage NTSB ANC74FAA30Accident · Minor injuriesClosedPiper PA-11 · Golovin, AKMar 24, 1974 · N78828 · Substantial damage NTSB OAK74FVM21Accident · No injuriesClosedChampion 7ECA · San Jose, CAMar 23, 1974 · N9548S · Substantial damage NTSB CHI74DEE60Accident · No injuriesClosedAmer Avco AA1-B · Sugar Grove, ILMar 10, 1974 · N6543L · Substantial damage NTSB SEA74DYC33Accident · No injuriesClosedAmer Avco AA-1A · Lagrande, ORFeb 28, 1974 · N9343L · Substantial damage NTSB CHI74FEE55Accident · No injuriesClosedBellanca 7ECA · Naperville, ILFeb 26, 1974 · N8868 · Substantial damage NTSB CHI74DEM46Accident · No injuriesClosedAmer Avco AA1-1A · Laingsburg, MIFeb 18, 1974 · N6383L · Substantial damage NTSB LAX74FUA17Accident · No injuriesClosedTurner Scout · Huntgtn Bch, CAFeb 15, 1974 · N7266 · Substantial damage NTSB MIA74DLG23Accident · Minor injuriesClosedChampion 7ECA · Plantersville, SCFeb 13, 1974 · N2986G · Substantial damage NTSB FTW74DRG59Accident · No injuriesClosedGrumman AA1-B · San Antonio, TXFeb 10, 1974 · N9995L · Substantial damage NTSB SEA74DYE37Accident · No injuriesClosedPiper PA-12 · Blakely Isle, WAFeb 8, 1974 · N4043H · Substantial damage NTSB NYC74FGM16Accident · Serious injuriesClosedPiper J3C-65 · Waynesburg, PAFeb 3, 1974 · N88361 · Substantial damage NTSB MIA74FKG50Accident · Minor injuriesClosedAmer Avco AA-1B · Harris Neck, GAJan 27, 1974 · N9609L · Substantial damage NTSB CHI74DEM37Accident · No injuriesClosedBellanca 7ECA · Holland, MIJan 26, 1974 · N36381 · Substantial damage NTSB NYC74FHD24Accident · No injuriesClosedAmer Avco AA1-B · Bristol, PAJan 19, 1974 · N9605L · Substantial damage NTSB FTW74DRJ23Accident · No injuriesClosedPiper PA-12 · Jonesville, LAJan 13, 1974 · N4252M · Substantial damage NTSB ANC74DAG84Accident · No injuriesClosedPiper PA-12 · Farewell, AKJan 1, 1974 · N2537M · Substantial damage NTSB IAD74FIG18Accident · Minor injuriesClosedPiper PA-22 · Edgewater, MDDec 15, 1973 · N5663Z · Substantial damage NTSB SEA74DYC24Accident · No injuriesClosedPiper PA-22 · Mosier, ORNov 17, 1973 · N5912Z · Substantial damage NTSB ANC74DAG79Accident · No injuriesClosedPiper PA-18 · Talkeetna, AKNov 17, 1973 · N215T · Substantial damage NTSB ANC74DAA21Accident · No injuriesClosedPiper PA-16 · North Pole, AKNov 16, 1973 · N5776H · Substantial damage NTSB CHI74FEA20Accident · No injuriesClosedPiper PA-22 · Monroe City, INNov 12, 1973 · N4919Z · Substantial damage NTSB ANC74DAG77Accident · No injuriesClosedPiper PA-12 · Beluga, AKNov 10, 1973 · N2368M · Substantial damage NTSB MIA74AM032Accident · No injuriesClosedAmer Avco AA1-A · Venice, FLOct 15, 1973 · N9374L · Substantial damage NTSB MIA74DLD41Accident · No injuriesClosedCessna 140A · Tampa, FLOct 13, 1973 · N3796V · Substantial damage NTSB FTW74DPD25Accident · No injuriesClosedAmer Avco AA-1A · Crowley, TXOct 10, 1973 · N9440L · Substantial damage NTSB MKC74FTG06Accident · Minor injuriesClosedAmer Avco AA-1B · Fargo, NDSep 25, 1973 · N9939L · Substantial damage NTSB MIA74DKG37Accident · No injuriesClosedBellanca 7ECA · Statesboro, GASep 20, 1973 · N5195T · Substantial damage NTSB IAD74FIA05Accident · No injuriesClosedPiper PA-12 · Front Royal, VASep 16, 1973 · N2547M · Substantial damage NTSB FTW74FRD09Accident · No injuriesClosedAmer Avco AA1-B · Slidell, LASep 9, 1973 · N9917L · Substantial damage NTSB ANC74DAG43Accident · No injuriesClosedPiper PA-12 · Skwentna, AKSep 9, 1973 · N3241M · Substantial damage NTSB ANC74DAG36Accident · No injuriesClosedPiper PA-12 · Alexander Lk, AKSep 6, 1973 · N2899M · Substantial damage NTSB FTW74FRJ11Accident · Minor injuriesClosedAmer Avco AA-1 · Converse, LASep 1, 1973 · N5928L · Substantial damage NTSB CHI74DET07Accident · Minor injuriesClosedLuscombe 8F · Crown Point, INAug 31, 1973 · N1883B · Substantial damage NTSB CHI74DEM18Accident · No injuriesClosedPiper PA-16 · Lake City, MIAug 31, 1973 · N5868H · Substantial damage NTSB NYC74FNA12Accident · Minor injuriesClosedAmer Avco AA1-B · Tewksbury, MAAug 30, 1973 · N6273L · Substantial damage NTSB NYC74DHD11Accident · Minor injuriesClosedAmer Avco AA1-B · Bristol, PAAug 19, 1973 · N9627L · Destroyed NTSB DEN74DTC10Accident · Minor injuriesClosedPiper PA-18 · Rocky Point, WYAug 16, 1973 · N7101K · Substantial damage NTSB ANC74FAA05Accident · No injuriesClosedPiper PA-22 · Iowa Ridge, AKAug 16, 1973 · N5032Z · Substantial damage NTSB FTW74DPJ07Accident · No injuriesClosedChampion 7GCBC · Seminole, OKAug 14, 1973 · N5242X · Substantial damage NTSB CHI74DEM08Accident · No injuriesClosedPiper PA-18 · Fibre, MIAug 4, 1973 · N7534K · Substantial damage NTSB NYC74DGM02Accident · No injuriesClosedPiper PA-16 · Beaver Falls, PAJul 30, 1973 · N5680H · Substantial damage NTSB MIA74FLA04Accident · No injuriesClosedChampion 7ECA · Jacksonville, FLJul 29, 1973 · N5162X · Substantial damage NTSB SEA74FYI06Accident · No injuriesClosedCessna 140 · Klamath Fals, ORJul 28, 1973 · N72166 · Substantial damage NTSB NYC74DNC13Accident · Minor injuriesClosedAmer Avco AA-1A · Alton, MEJul 25, 1973 · N6379L · Substantial damage NTSB ANC74DAG12Accident · No injuriesClosedPiper PA-22 · Dillingham, AKJul 23, 1973 · N5789Z · Substantial damage NTSB IAD74DKM05Accident · No injuriesClosedPiper PA-12 · Indian Trail, NCJul 22, 1973 · N3289M · Substantial damage