NTSB investigations: Lycoming 0-235 series, 2001
7 cases on aircraft whose registry engine model is Lycoming 0-235 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 | 22 |
| 1984 | 25 |
| 1985 | 12 |
| 1986 | 4 |
| 1987 | 20 |
| 1988 | 14 |
| 1989 | 12 |
| 1990 | 6 |
| 1991 | 7 |
| 1992 | 5 |
| 1993 | 8 |
| 1994 | 5 |
| 1995 | 6 |
| 1996 | 10 |
| 1997 | 8 |
| 1998 | 6 |
| 1999 | 7 |
| 2000 | 7 |
| 2001 | 7 |
| 2002 | 7 |
| 2003 | 7 |
| 2004 | 5 |
| 2005 | 11 |
| 2006 | 7 |
| 2007 | 3 |
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\") = 2001
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505')
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") = 2001
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505')
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 MIA01LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe student pilot's improper recovery from a bounced landing resulting in a hard landing on the nose landing gear, collapse of the nose landing, the airplane sliding off the runway, and the airplane being destroyed by a postcrash fire.NTSB FTW01LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Lapace, LAthe student pilot flared the airplane high, which resulted in a hard landing.NTSB FTW01LA135Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Amarillo, TXthe pilot's inadequate compensation for the crosswind, which resulted in a hard landing. A contributing factor was the crosswind.NTSB IAD01LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe pilot's improper landing flare. A factor was the crosswind.NTSB LAX01LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAthe student pilot's misjudged landing flare and improper use of the elevator control.NTSB LAX01LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe pilot's premature flare, which resulted in an inadvertent stall and a bounced landing. A factor was the improper recovery from a bounced landing.NTSB LAX01LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Livermore, CAThe student pilot's inadequate compensation for a tailwind during final approach and her improper recovery from a bounced landing.