NTSB investigations: Lycoming I0360 series, 1983
57 cases on aircraft whose registry engine model is Lycoming I0360 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 year(c.\"eventDate\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41515'))
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 year(c."eventDate") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41515'))
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 ATL83LA098Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Charleston, SCThe plt stated that the landing gear collapsed after acft had rolled aprx 1200 ft during the landing. An exam of the acft revealed that the gear retraction transmission was torn out of its fuselage bulkhead mount, the landing gear push-pull cable rod ends…NTSB FTW83FA101Accident · No injuriesField investigationFinal reportMooney M20E · Roanoke, TXPower loss occurred about 7 min after takeoff. The plt turned back toward the arpt but was unable to reach the arpt due to a 15-20 kt headwind. The acft landed hard collapsing the landing gear after the plt mushed the acft to clear wires. Examination & flow…NTSB MIA83LA059Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · New Smyrna Bch, FLThe newly purchased helicopter was being ferried to Maryland. During arrival to new Smyrna beach, FL, the 1st planned stop, the plt executed a landing approach to rwy 2. After coming to a hover, the helicopter lost rotor RPM during a pedal turn to a downwind…NTSB FTW83LA083Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bandera, TXThe pilot stated that after a normal landing, he taxied to the end of the runway in order to allow another aircraft to land. He than taxied about 70 ft off the runway into a grass turnaround/taxi area where the aircraft hit an 18 inch deep hole with the left…NTSB FTW83FA079Accident · 2 fatalField investigationFinal reportMooney M20E · Cushing, OKThe acft collided with a powerline during a low flt down a river. The acft impacted 3 high tension cables spanning the river. Witnesses said the acft was flying low and fast. The collision produced a sound 'like a gunshot' and the acft fell to the ground and…NTSB ANC83FAG02Accident · Serious injuriesFinal reportWillbird 2 · Chugiak, AKAs the aircraft lifted off, the nose pitched up alarmingly and application of full down elevator control had no apparent effect. The pilot was able to lower the nose by extending full flaps. However, he was unable to latch the manual flaps in the down…NTSB LAX83FUG11Accident · Minor injuriesFinal reportPiper PA-28R-200 · Upland, CAThe aircraft crashed 150 yards short of the runway during landing. The pilot said the manifold pressure kept falling as he progressed around the field in the traffic pattern. The engine went to idle on the base leg. The pilot had lowered the gear but not the…