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 CHI67F0359Accident · No injuriesClosedPiper PA-22 · Seymour, ILNov 20, 1966 · N4858Z · Substantial damage NTSB MKC67D0293Accident · No injuriesClosedPiper PA-22 · Spearfish, SDNov 16, 1966 · N4966Z · Substantial damage NTSB CHI67D0380Accident · No injuriesClosedPiper PA-22 · Toledo, OHNov 14, 1966 · N5721Z · Substantial damage NTSB CHI67D0407Accident · No injuriesClosedPiper PA-12 · Bowling Grn, OHNov 13, 1966 · N92571 · Substantial damage NTSB MIA67F0266Accident · Minor injuriesClosedPiper PA-12 · Whitsett, NCNov 5, 1966 · N4459M · Substantial damage NTSB NYC67F0317Accident · Minor injuriesClosedPiper PA-12 · Clarks Summit, PAOct 30, 1966 · N3414M · Destroyed NTSB MKC67D0289Accident · No injuriesClosedPiper PA-22 · Manson, IAOct 23, 1966 · N5333Z · Substantial damage NTSB ANC67A0036Accident · 1 fatalClosedPiper PA-16 · ZOct 8, 1966 · N6801K · Destroyed NTSB ANC67F0060Accident · No injuriesClosedPiper PA-18 · Juneau, AKOct 1, 1966 · N287T · Substantial damage NTSB MKC67F0228Accident · Minor injuriesClosedChampion 7ECA · Stanley, KSSep 23, 1966 · N8394V · Substantial damage NTSB SEA67D0160Accident · No injuriesClosedPiper PA-14 · Starbuck, WASep 19, 1966 · N5145H · Substantial damage NTSB FTW67D0252Accident · No injuriesClosedPiper PA-22 · Cloutierville, LASep 12, 1966 · N4964Z · Substantial damage NTSB NYC67D0257Accident · No injuriesClosedPiper PA-22 · Sandy Hook, NJSep 3, 1966 · N5683Z · Substantial damage NTSB NYC67D0209Accident · No injuriesClosedPiper PA-12 · Atlantic City, NJAug 24, 1966 · N7576H · Substantial damage NTSB MKC67F0124Accident · No injuriesClosedPiper PA-12 · Allison, IAAug 14, 1966 · N2674M · Substantial damage NTSB MIA67F0094Accident · Minor injuriesClosedCessna 150 · Bessemer, ALAug 6, 1966 · N3987V · 2 aircraft · Substantial damage NTSB NYC67D0127Accident · No injuriesClosedFryklund Aero S · Broadbrook, CTJul 30, 1966 · N10132 · Destroyed NTSB CHI67D0216Accident · No injuriesClosedPiper PA-22 · Midlothain, ILJul 30, 1966 · N5857Z · Substantial damage NTSB CHI67A0018Accident · 1 fatalClosedPiper PA-22 · Strongsville, OHJul 30, 1966 · N5722Z · 2 aircraft · Minor damage NTSB FTW6MF0154Accident · No injuriesClosedPiper PA-22 · Dallas, TXJul 26, 1966 · N4541Z · Substantial damage NTSB NYC67F0139Accident · No injuriesClosedPiper PA-12 · Annville, PAJul 24, 1966 · N87809 · Substantial damage NTSB MIA67F0009Accident · Minor injuriesClosedPiper PA12 · Gallatin, TNJul 17, 1966 · N98966 · Substantial damage NTSB NYC67F0114Accident · Minor injuriesClosedPiper J5C · Duanesburg, NYJul 12, 1966 · N9203H · Substantial damage NTSB NYC67D0080Accident · No injuriesClosedPiper J-3 · Erma, NJJul 11, 1966 · N46286 · Substantial damage NTSB NYC67D0216Accident · No injuriesClosedPiper PA-22 · Bellington, WVJul 10, 1966 · N5847Z · Destroyed NTSB NYC67D0160Accident · No injuriesClosedPiper PA-22 · Dubois, PAJul 7, 1966 · N5006Z · Substantial damage NTSB NYC67D0063Accident · No injuriesClosedPiper PA-22 · Bristol, MEJul 7, 1966 · N5528Z · Substantial damage NTSB FTW67A0002Accident · 1 fatalClosedPiper J3C · Memphis, TXJul 3, 1966 · N42743 · Destroyed NTSB CHI67D0209Accident · No injuriesClosedPiper PA-22 · Avon, OHJul 2, 1966 · N5571Z · Substantial damage NTSB CHI67D0179Accident · Minor injuriesClosedPiper PA-22 · Strongsville, OHJul 1, 1966 · N5626Z · Substantial damage NTSB NYC67F0043Accident · Minor injuriesClosedChampion 7ECA · Baden, PAJun 29, 1966 · N9562S · Substantial damage NTSB LAX67D0034Accident · No injuriesClosedPiper PA-22 · Hesperia, CAJun 29, 1966 · N5527Z · Substantial damage NTSB SEA67D0142Accident · No injuriesClosedChampion 7ECA · Lewistown, MTJun 28, 1966 · N8306V · Substantial damage NTSB OAK67F0040Accident · No injuriesClosedPiper PA-22 · Vacaville, CAJun 28, 1966 · N5134Z · 2 aircraft · Substantial damage NTSB NYC67F0036Accident · Serious injuriesClosedPiper PA-12 · Chesapeake, VAJun 21, 1966 · N4222M · Substantial damage NTSB CHI67F0148Accident · Serious injuriesClosedPiper PA-22 · Strongsville, OHJun 20, 1966 · N5435Z · 2 aircraft · Destroyed NTSB NYC67D0166Accident · No injuriesClosedPiper PA-16 · Newburyport, MAJun 15, 1966 · N5651H · Substantial damage NTSB MIA67F0006Accident · Minor injuriesClosedPiper PA12 · China Grove, NCJun 15, 1966 · N3656M · Substantial damage NTSB OAK67F0026Accident · Minor injuriesClosedPiper PA-22 · Sonoma, CAJun 11, 1966 · N5536Z · Substantial damage NTSB MIA67D0007Accident · No injuriesClosedPiper PA22 · Tullahoma, TNJun 11, 1966 · N4918Z · Substantial damage NTSB NYC67F0004Accident · No injuriesClosedPiper PA12 · Cato, NYJun 4, 1966 · N2793M · Substantial damage NTSB SEA66D0279Accident · No injuriesClosedPiper PA-22 · Boise, IDMay 30, 1966 · N5368Z · Substantial damage NTSB CHI67D0014Accident · No injuriesClosedPiper PA22 · Janesville, WIMay 30, 1966 · N5156Z · Substantial damage NTSB NYC67D0014Accident · No injuriesClosedPiper PA-22 · Spring Valley, NYMay 26, 1966 · N5624Z · Substantial damage NTSB NYC66F0670Accident · No injuriesClosedPiper PA-12 · Princeton, NJMay 26, 1966 · N3081M · Substantial damage NTSB CHI67F0046|CHI66F0046Accident · Minor injuriesClosedPiper J3 · Hinsdale, ILMay 26, 1966 · N35333 · 2 aircraft · Destroyed NTSB CHI67D0001Accident · No injuriesClosedPiper PA-16 · Chicago, ILMay 26, 1966 · N5631H · Substantial damage NTSB CHI66F0770Accident · No injuriesClosedPiper PA-22 · Logansport, INMay 22, 1966 · N5629Z · Substantial damage NTSB ANC67F0027Accident · No injuriesClosedPiper PA-18 · Soldotna, AKMay 21, 1966 · N7128K · Substantial damage NTSB FTW66F0674Accident · No injuriesClosedPiper J3C-65 · Crowville, LAMay 19, 1966 · N26783 · Substantial damage