NTSB investigations: Lycoming 0-320 series, 1998
16 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
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 year(c.\"eventDate\") = 1998
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") = 1998
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 CHI99LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Evansville, INThe pilot's improper flare and improper recovery from a bounced landing.NTSB LAX99LA042Accident · No injuriesLimited investigationFinal reportMartin Stoddard Hamilton II · Georgetown, CAThe pilot's improper flare. Also causal was the flight instructor's inadequate supervision.NTSB MIA99LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Venice, FLThe pilot's improper flare and improper recovery from a bounced landing.NTSB FTW98LA417Accident · No injuriesLimited investigationFinal reportCessna 172N · Gallup, NMThe pilot's inadequate landing flare. Factors were his misjudgement of altitude and his excessive airspeed.NTSB LAX98LA294Accident · No injuriesLimited investigationFinal reportCessna 172L · Bakersfield, CAThe pilot's misjudged landing flare that led to an improper bounced landing recovery and subsequent uncontrolled porpoise.NTSB CHI98LA340Accident · No injuriesLimited investigationFinal reportCessna 172N · Traverse City, MIthe inadvertent stall/mush. Factors contributing to this accident were the pilot's improper compensation for the wind conditions, and his excessively high flare.NTSB ATL98LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Paris, TNThe pilot's improper landing flare that resulted in an overload failure of the left main landing gear.NTSB NYC98LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Nantucket, MAThe student pilot's failure to perform a go-around. A factor in the accident was the tailwind.NTSB FTW98LA314Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COThe pilot's improper landing flare which resulted in a hard landing.NTSB ATL98LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Homestead, FLThe pilot's improper flare that resulted in a hard landing and porpoise, and his improper recovery from the bounced landing.NTSB FTW98LA282Accident · No injuriesLimited investigationFinal reportBeech B19 · Frisco, TXThe student pilot's improper landing flare which resulted in a hard larding. Factors were the inadequate supervision of the flight by the flight instructor and the high winds.NTSB LAX98LA160Accident · No injuriesLimited investigationFinal reportRobinson R22B · San Jose, CAThe student pilot's failure to maintain adequate rotor rpm, and the flight instructor's inadequate supervision of the flight.NTSB FTW98LA240Accident · No injuriesLimited investigationFinal reportCessna 172P · La Porte, TXThe pilot's premature landing flare and improper recovery procedures from a bounced landing. A factor was the gusty winds.NTSB IAD98LA045Accident · No injuriesLimited investigationFinal reportCessna 172N · Stevensville, MDthe pilot's improper flare, improper recover from a bounced landing, and failure to maintain directional control.NTSB LAX98LA201Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Barbara, CAThe pilot's misjudging the landing flare and subsequent hard landing.NTSB MIA98LA095Accident · No injuriesLimited investigationFinal reportCessna 172P · Destin, FLthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.