NTSB investigations: Lycoming O&VO-360 series, 1983
4 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “In flight collision with terrain/water”. 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 | 5 |
|---|---|
| 1983 | 4 |
| 1984 | 8 |
| 1985 | 5 |
| 1986 | 6 |
| 1987 | 4 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 5 |
| 1993 | 3 |
| 1994 | 8 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 4 |
| 2002 | 8 |
| 2003 | 4 |
| 2004 | 5 |
| 2005 | 7 |
| 2006 | 3 |
| 2007 | 1 |
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\") = 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 ('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\" = 230))
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 ('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" = 230))
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 MKC84LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Manhattan, KSThe plt stated that during her arrival at Manhattan, KS, the rwy had patches of snow & was surrounded by snow covered terrain. Just prior to landing, she became aware of a snowbank at the apch end of the rwy. She took evasive action, but the right main gear…NTSB CHI84FAMS1Accident · 1 fatalMissing aircraftFinal reportMooney M20C · Near Green Bay, WIAfter a taking off at 2029 CST, the plt climbed to 7000 ft & flew on a southerly heading toward the oshkosh VOR. At 2030, the plt indicated that he had a radio problem, but he remained in radio contact with ATC until a freq change at 2039, then no further…NTSB LAX83FUM06Accident · Serious injuriesFinal reportCessna 172RG · San Clemente, CAThe acft crashed on San Clemente island during a fish spotting flt on a dark night. These flts are usually flown at an alt of 1000-2000 ft AGL. A navy witness on the accident island said the ceiling was zero and the visibility about 200 yards at the accident…NTSB ANC83FA042Accident · 3 fatalField investigationFinal reportBellanca 8GCBC · Melozi Hot Spgs, AKAcft deptd a private airstrip with no flt plan and was later reported overdue. Acft wreckage was found on sept. 27, 1984. Debris was scattered near the bottom of a 1000 ft box canyon cliff. The main fuselage was found in a lake at the bottom of the canyon.…