NTSB investigations: Lycoming O&VO-360 series, CA
18 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “In flight encounter with weather”. 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 per year
| 1983 | 1 |
|---|---|
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 2002 | 2 |
| 2003 | 2 |
| 2005 | 2 |
Where
Open the mapLatest cases
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\" = 'CA' 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 ('41514')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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" = 'CA' 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 ('41514')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 LAX06LA068Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Hopland, CAThe non-instrument rated pilot's failure to maintain clearance with terrain, which resulted in a controlled flight into terrain. Contributing factors were the dark night conditions and the low clouds.NTSB LAX05FA099Accident · 2 fatalField investigationFinal reportBeech 95 · Calistoga, CAThe pilot's inadequate preflight and in-flight planning/decision, which resulted in continued VFR flight into instrument meteorological conditions at an altitude insufficient to ensure adequate terrain clearance and impact with rising terrain.NTSB LAX04GA051Accident · 2 fatalFinal reportPiper PA-28-180 · Big Bear City, CAThe pilots inadequate preflight planning and intentional flight into known adverse weather conditions. Contributing to this accident was the fact that it was a dark night with no moon illumination.NTSB LAX03LA271Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Watsonville, CAthe non-instrument rated pilot's intentional continuance of VFR flight into instrument meteorological conditions and failure to maintain clearance with terrain.NTSB LAX02FA131Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Three Rivers, CAthe pilot's attempt to continue visual flight in instrument meteorological conditions in mountainous terrain. Contributing factors were low ceiling and mountainous terrain.NTSB LAX02LA066Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Groveland, CAthe pilot's improper preflight planning and improper weather evaluation.NTSB LAX94LA079Accident · 1 fatalLimited investigationFinal reportAero Commander 100 · Chico, CAIssuance of an improper (special VFR) clearance by the tower controller, while the visibility was less than one mile, continued VFR flight by the pilot into instrument meteorological conditions (IMC), and the pilot's failure to maintain control of the…NTSB LAX91FA181Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Carpenteria, CA1) Inadequate weather evaluation by the pilot, 2) poor inflight decision to try and continue VMC flight, and 3) the pilot's lack of total experience.NTSB LAX89FA211Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Dinsmore, CAThe pilot's intentional VFR flight into instrument meteorological conditions, and his failure to maintain adequate terrain clearance. Contributing factors to the accident were: the pilot's failure to obtain weather information, his overconfidence in his…NTSB LAX89FA078Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · San Bernardino, CAThe pilot's decision to continue VFR flight after encountering instrument meteorological conditions while attempting to transit through a mountain pass. Contributing factors was: the pilot's self-induced pressure knowing that a co-worker was probably waiting…NTSB LAX86FA079Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · El Cajon, CADrg arrival at an arpt near his home, the plt contacted apch control (ctl) & asked the ctlr for assistance in landing & said that the wx looked a little foggy. The ctlr informed the plt of the acft's position in relation to the arpt. As the acft was dscndg…NTSB LAX86FA038Accident · 3 fatalField investigationFinal reportGrumman American AA-5B · Gold Run, CAThe accident location and the departure airport is located in a mountainous area. The acft departed truckee-tahoe arpt (trk) to the northeast in marginal VFR conditions at sunset. The acft continued on a northeasterly heading for 18 miles and then turned to a…NTSB LAX85FA322Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Phelen, CAAfter receiving a preflight weather briefing 1 hour and 20 minutes before takeoff, that cautioned of lowering ceilings and thunderstorms along his proposed flt route, the plt took off under VFR. A flt plan was not filed. As the acft climbed to its cruise alt…NTSB LAX85FA068Accident · 1 fatalField investigationFinal reportHart-Thorp T-18 Tiger · Tulare, CAAcft departed arpt & about 5 mins later was seen 'descending vertically' out of 'dark rain cloud' at about 1,000 ft AGL. During attempted recovery at about 300 ft AGL, acft broke up & crashed in a field. Plt did not obtain wx briefing prior to flt and did not…NTSB LAX84LA364Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Lee Vining, CAThe plt reported that after entering tioga pass, he made a left turn to follow the center of the pass & the acft began to sink. He applied full power & went to the best angle of climb speed, but was unable to stop the sink. The acft then hit an electrical…NTSB LAX84FA280Accident · 1 fatalField investigationFinal reportGrumman American AA-5B · Placerville, CAThe plt lived near the arpt & had been commuting to sacramento, CA for about 3 weeks. Rwy 27 was the prominant rwy & the arpt was surrounded by hills. Shortly after taking off, the acft crashed about 2 mi west of the arpt while in a right wing low attitude on…NTSB LAX84LA187Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Lucerne, CAUpon reaching his destination, the plt was unable to see the arpt because of the presence of a solid lower layer of clouds. While looking for a break in the cloud layer for a VFR descent, the plt 'inadvertently flew into IFR conditions,' & impacted trees.…NTSB LAX84FA065Accident · 2 fatalField investigationFinal reportMooney M20A · Mammoth Lakes, CAThe acft crashed into a mountain side at some time prior to 0900 on 11/12/83 when the ELT signal was 1st reported, via satellite. Before the flt, the student plt was last seen in bakersfield, CA at about 0100 that morning. A rescue mission was delayed due to…