NTSB investigations: Lycoming O&VO-360 series, 1983
5 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “Hard landing”. 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 | 10 |
|---|---|
| 1983 | 5 |
| 1984 | 9 |
| 1985 | 6 |
| 1986 | 5 |
| 1987 | 2 |
| 1988 | 5 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 5 |
| 1993 | 4 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 5 |
| 1997 | 1 |
| 1998 | 6 |
| 1999 | 5 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 7 |
| 2003 | 3 |
| 2004 | 8 |
| 2005 | 8 |
| 2006 | 6 |
| 2007 | 4 |
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\" = 200))
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" = 200))
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 CHI83LA293Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Kentland, INDuring arrival, the plt landed on rwy 27 with a left x-wind from the south. He stated that he had no indication of excessive x-winds or gusts until the acft was about to touch down. He stated that at that time, the plane encountered heavy gusts & a downdraft.…NTSB LAX83FVM08Accident · No injuriesFinal reportBeech C23 · Monterey, CAThe student pilot was on his first solo cross-country. The pilot stated that his approach was too high and too fast. The acft landed hard and bounced. As the acft hit a 2nd time the nose gear collapsed and became jammed between fuselage and runway. The…NTSB ANC83LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Kenai, AKThe pilot stated that on a short final approach he encountered a windshear. The pilot only had 5 hours in this type acftand had little experience landing at the location of the accident. This field has no facilities except a windsock. It isbordered by trees…NTSB CHI83LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Harrison, MIThe pilot stated that he executed a go-around on the first landing attempt because of a strong crosswind and high airspeed. On the second approach, he executed a go-around from the flare because of a 'strong updraft'. The pilot statedthat during the…NTSB NYC83LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Jamaica, NYThe aircraft made a hard landing after an ILS approach to runway 31L at jfk international airport. The acft broke out ofthe clouds at 600 feet. As descent continued 2 notches of flaps were applied and flare was begun at 20 feet AGL. About 10 ft. above the…