NTSB investigations: Lycoming 0-320 series, 1983
12 cases on aircraft whose registry engine model is Lycoming 0-320 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 | 20 |
|---|---|
| 1983 | 12 |
| 1984 | 16 |
| 1985 | 15 |
| 1986 | 13 |
| 1987 | 21 |
| 1988 | 8 |
| 1989 | 13 |
| 1990 | 5 |
| 1991 | 12 |
| 1992 | 12 |
| 1993 | 15 |
| 1994 | 19 |
| 1995 | 12 |
| 1996 | 22 |
| 1997 | 15 |
| 1998 | 16 |
| 1999 | 20 |
| 2000 | 16 |
| 2001 | 12 |
| 2002 | 22 |
| 2003 | 12 |
| 2004 | 16 |
| 2005 | 13 |
| 2006 | 16 |
| 2007 | 11 |
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 ('41508')
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 ('41508')
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 FTW84LA043Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Capitan, NMThe plt reported that the acft bounced on landing, resulting in the collapse of the main gear & damage to the prop & left wing. An exam revealed that the u-bolt which attaches the left main gear strut to the fuselage had failed due to tensile overload.…NTSB CHI83LA435Accident · No injuriesLimited investigationFinal reportCessna 172 · Plymouth, MIThe plt reported that during an apch to land on rwy 18, he encountered heavy turbulence & elected to go around. He reported the wind was from 180 deg at 15, gusting 25 KTS. On the 2nd apch, turbulence was encountered again. The acft was fast & began to float…NTSB CHI83LA427Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbondale, ILThe instructor plt (CFI) was providing a dual check-out for a private plt in the Cessna 172. After flying in the local area, they returned to the arpt to practice touch-and-go landings on rwy 18. The winds were reported from 190 deg at 20, gusting 25 KTS. On…NTSB DEN83LA198Accident · No injuriesLimited investigationFinal reportBeech 23 · Rocky Ford, COThe acft landed hard & bounced. The impact wrinkled the right wing at the fuel cell position.NTSB NYC83LA217Accident · No injuriesLimited investigationFinal reportCessna 172M · Somerville, NJAccording to the pilot, as the flight neared the runway it was flared for touchdown. However, the aircraft bounced and the pilot immediately applied full power, pushed the nose forward and raised the electric flap lever. The aircraft did not seem to climb and…NTSB MKC83LA175Accident · No injuriesLimited investigationFinal reportCessna 172P · Kansas City, MOOn landing the aircraft touched down hard, bounced and the right main landing gear broke off. A go around was executed and the flight proceeded to Kansas City where an emergency landing was made. During landing the aircraft swerved off the runway to the right.NTSB LAX83LA356Accident · No injuriesLimited investigationFinal reportCessna 172M · Santa Monica, CAThe plt reported that during the flare the acft began to 'porpoise.' Reportedly, it bounced during the landing, but the plt did not add power to go around or to reland the acft. The acft bounced several times. The nose gear, eng mounts & firewall were bent,…NTSB DCA83IA027Incident · No injuriesIncident investigationFinal reportGrumman AA-5 · Clinton, MDThe student pilot ballooned during the flare, then landed hared on runway. The nosegear failed and the acft slid down the runway.NTSB NYC83LA117Accident · No injuriesLimited investigationFinal reportCessna 172P · Collegeville, PAThe acft made a hard landing after which it swerved off the runway and collided with trees. The pilot was on a solo instructional flight and was landing on runway 27. As the acft touched down hard it bounced and left the confines of therunway. The acft…NTSB LAX83FA226Accident · No injuriesField investigationFinal reportRobinson R22 · Torrance, CAThe helicopter was on an FAA certification test flt with a part-time company employee in the left seat as pilot- in-command (PIC). An FAA test plt was in the right seat. The purpose of the flt was to establish new data for the helicopter's height-velocity…NTSB CHI83LA167Accident · No injuriesLimited investigationFinal reportCessna 172M · Holland, MIThe acft landed nose wheel first in a gusty crosswind. The active runway was 5 and the wind was 150 degrees at 15 KTS gusting to 21 KTS. The pilot stated that before she could round out a wind gust caused the acft to drop and make contacton the nose gear. The…NTSB CHI83LA158Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Fraser, MIThe pilot stated he lost directional control of the aircraft after touchdown during a crosswind landing. The aircraft departed the right side of the runway into a muddy area and nosed over.