NTSB investigations: Lycoming 0-320 series, 2007
11 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\") = 2007
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") = 2007
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 DEN08CA020Accident · No injuriesData collectionFinal reportCessna 172N · Grand Junction, COthe pilot's improper flare resulting in a hard landing.NTSB NYC07CA235Accident · No injuriesData collectionFinal reportCessna 172 · Meriden, CTThe student pilot's inadequate recovery from a bounced landing.NTSB MIA07CA143Accident · Minor injuriesData collectionFinal reportCessna 172N · Carrabelle, FLThe improper flare by the pilot-in-command resulting in a hard landing.NTSB CHI07CA294Accident · No injuriesData collectionFinal reportCessna 172M · Pontiac, MIThe pilot's misjudgment of the landing flare and her improper recovery from the bounced landing.NTSB ATL07CA132Accident · No injuriesData collectionFinal reportCessna C172N · Manassas, VAThe student pilot's failure to correct for a pilot-induced oscillation/porpoise, during flare/touchdown, which resulted in a hard landing.NTSB NYC07CA195Accident · No injuriesData collectionFinal reportCessna 172L · Winston-Salem, NCThe pilot's improper recovery from a bounced landing.NTSB ATL07CA118Accident · No injuriesData collectionFinal reportPiper PA28-140 · Front Royal, VAThe pilot's improper recovery from a bounced landing.NTSB CHI07CA245Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe student pilot's improper flare, which resulted in a hard landing. An additional cause was the pilot's inadequate recovery from a bounced landing. Factors in the accident include the pilot's failure to maintain directional control during the landing roll…NTSB SEA07CA211Accident · No injuriesData collectionFinal reportArtic S-1B2 · McCall, IDThe pilot's failure to maintain airspeed during the landing flare resulting in a hard landing and subsequent failure to maintain directional control during the landing roll. The soft terrain condition adjacent to the runway was a factor.NTSB CHI07CA132Accident · No injuriesData collectionFinal reportCessna 172P · Kenosha, WIThe pilot's improper recovery from a bounced landing, which resulted in a flat nose wheel tire and a buckled firewall. A factor was the porpoising that was encountered during the flare.NTSB LAX07CA138Accident · No injuriesData collectionFinal reportTolsma Tony G Avid Magnum · Jackpot, NVThe pilot's inadequate weather evaluation, inadequate compensation for the wind conditions, and decision to land with a gusty, quartering tailwind. Also causal was the pilot's misjudged landing flare and inadequate recovery from a bounced landing, resulting…