NTSB investigations: Lycoming 0-235 series, OK
83 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.
Cases, newest first
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\" = 'OK' 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 ('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."eventStateOrRegion" = 'OK' 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 ('41505'))
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 FTW84LA199Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe student was on his 3rd solo flt, practicing touch-&-go landings. According to witnesses, the acft initially touched down short of the rwy, then bounced onto the prepared surface. The acft porpoised several times. The plt made no attempt to go around.NTSB FTW84LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKDuring landing the nose gear of the acft collapsed. The plt reported that the nose gear started to shimmy after landing and he pulled the stick back to raise the nose gear. When the gear contacted the rwy again it collapsed. Examination of the wreckage showed…NTSB FTW84LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe acft landed hard and bounced. The plt reacted by pushing the nose over and when the acft contacted the rwy the nose gear collapsed.NTSB FTW84FA084Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Pawnee, OKThe acft collided with a guy wire on a micro-wave tower during flt in IMC weather. The plt had not received a weather briefing prior to takeoff and after encountering low ceilings the plt attempted to fly along a highway at low alt. The right wing of the acft…NTSB FTW84LA073Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Walters, OKThe plt & safety plt had made two simulated instrument approaches at duncan,OK &a low VFR pass at Walters which was to terminate with a circling approach & landing. The acft stalled during the pull-up from the low pass.NTSB FTW83LA368Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe acft collided with a fence and a powerline during takeoff climb. The student pilot was visiting a small field with A1300 ft rwy of sod for practice. The C-152 uses 1340 ft to clear a 50 ft obstabcle for a standard day on a surfaced rwy this day was above…NTSB FTW83LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe acft collided with a ditch during a forced landing. This was an instructional flt and the CFI gave the student a simulated forced landing. During the attempted go-around the engine reportedly developed only 1800 RPM and a landing wasmade in a field by the…NTSB FTW83LA240Accident · No injuriesLimited investigationFinal reportCessna 152 · Woodward, OKAs the a/s increased drng tkof roll the acft started to skid to the rt. The student plt stated that with full l aileron and no rt rudder the acft continued to skid to the rt. He then atmptd to apply l rudder and abort the tkof by reducing pwr. The acft veered…NTSB FTW83FPM03Accident · Minor injuriesFinal reportCessna 152 · Tulsa, OKOn the day before the accident the plt flew the acft to excelsor springs, MO for refueling, returning to liberty. On 11/7/82 at 1545 the flt departedliberty on an IFR flt plan. Approximately 7 mi north of Tulsa intl arpt the plt elected to land at Tulsa for…NTSB FTW81DPM14Accident · No injuriesClosedCessna 152 · Whitefield, OKNTSB FTW81DPJ23Accident · No injuriesClosedCessna 152 · Ada, OKNTSB FTW81FPJ18Accident · Minor injuriesClosedCessna 152 · Bethany, OKNTSB FTW81FPJ08Accident · No injuriesClosedPiper PA-38 · Hennessey, OKNTSB FTW81FPJ03Accident · Serious injuriesClosedPiper PA-38 · Hammon, OKNTSB FTW81FPJ01Accident · Minor injuriesClosedPiper PA-38 · Stillwater, OKNTSB FTW80FPJ21Accident · No injuriesClosedCessna 152 · Grandfield, OKNTSB FTW80FA070Accident · 1 fatalClosedCessna 150 · Tulsa, OKNTSB FTW80FPJ05Accident · No injuriesClosedPiper PA-38 · Guymon, OKNTSB FTW79DPJ25Accident · No injuriesClosedCessna 152 · Lawton, OKNTSB FTW79DPJ02Accident · No injuriesClosedCessna 152 · Tonkawa, OKNTSB FTW78FPM13Accident · No injuriesClosedPiper PA-22 · Tulsa, OKNTSB FTW77FPJ08Accident · No injuriesClosedPiper PA-22 · Duncan, OKNTSB FTW76FPM18Accident · No injuriesClosedAmer Avco AA1-B · Cookson, OKNTSB FTW76FPM06Accident · No injuriesClosedBellanca 7ECA · Keifer, OKNTSB FTW75FRJ10Accident · No injuriesClosedPiper PA-16 · Fairview, OKNTSB FTW75DPJ05Accident · No injuriesClosedPiper PA-16 · Ardmore, OKNTSB FTW74DPJ07Accident · No injuriesClosedChampion 7GCBC · Seminole, OKNTSB FTW70D0244Accident · No injuriesClosedPiper PA-16 · Norman, OKNTSB MKC68A0018Accident · 4 fatalClosedPiper PA-16 · Blocker, OKNTSB FTW67D0382Accident · No injuriesClosedPiper PA-22 · Enid, OKNTSB FTW66D0591Accident · No injuriesClosedPiper PA-18 · Morris, OKNTSB UNK65X1432Accident · No injuriesClosedPiper PA22 · Ardmore, OKNTSB UNK64X1067Accident · Minor injuriesClosedPiper PA16 · Henryetta, OK