NTSB investigations: Lycoming O&VO-360 series, 1982
8 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
| 1982 | 8 |
|---|---|
| 1983 | 8 |
| 1984 | 7 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 4 |
| 1988 | 4 |
| 1989 | 6 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 2 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 3 |
| 2001 | 3 |
| 2002 | 6 |
| 2003 | 5 |
| 2004 | 2 |
| 2005 | 4 |
| 2006 | 2 |
| 2007 | 2 |
Where
Latest 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 year(c.\"eventDate\") = 1982
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 year(c."eventDate") = 1982
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 NYC83FA041Accident · 1 fatalField investigationFinal reportCessna 177B · Starrucca, PADuring a weather briefing before takeoff, the student pilot was advised of icing conditions, turbulence, snowshowers and snow squalls along ridges north of the wilkes-barre/scranton, PA area. The weather briefer indicated that VFR flight was not recommended.…NTSB MKC83LA031Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Near Vichy, MOWhile enroute from cape girardeau, MO to rolla, MO, the pilot encountered an area of low ceilings and fog. While he was trying to remain VFR at low altitude, the aircraft struck trees on top of a hill. The pilot climbed abruptly, but the plane stalled,…NTSB CHI83LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Marshall, MNDuring a preflight weather briefing, the pilot was warned that VFR flight was not recommended. Also, a fixed base operator warned him of the weather (there were patches of ground fog). After takeoff, fog was encountered at about 200 to 500 ft AGL. During a…NTSB FTW82FQA27Accident · 2 fatalFinal reportCessna 177B · Guadalupita, NMPilot on cross-country impacted the side of a 11,055 foot mountain at the 10,800 foot level. The mountains were obscured at the time.NTSB NYC82FA148Accident · 1 fatalField investigationFinal reportGulfstream American AA-5B · Newburg, PAThe pilot on a personal cross-country flew into trees on a slope of blue mountain, PA at the 2284 foot level. The weather in the area was foggy and the mountain tops were obscured in clouds. There is no record of a weather briefing or communication by the…NTSB ATL82DA162Accident · Serious injuriesFinal reportPiper PA-28-181 · Savannah, GAThe pilot obtained a weather briefing and filed a VFR flight plan before takeoff. He was advised that the weather was 6000 ft scattered, 6 miles visibility, possible storms gathering at palatka, FL. After takeoff, he was unable to contact the flight service…NTSB SEA82DYE06Accident · 1 fatalFinal reportBeech 23 · Greenwater, WAAt about 1620 local time on 4/24/82, the aircraft departed burley, id and proceeded on a VFR flight plan to tacoma, WA. The mountains east of seattle were obscured by an overcast ceiling beginning at 3500 ft. during a descent from 10,500 ft into the seattle…NTSB DEN82FTA09Accident · 1 fatalFinal reportCessna 177B · Wolf Pt., MTThe pilot reported that he encountered a snow squall while cruising at 5000 ft MSL on a VFR flight plan at night. He stated that he descended to 4000 ft MSL to try to get under the squall and continue. He was unable to remember what happened after descending…