NTSB investigations: Continental O-470 series, 2000
9 cases on aircraft whose registry engine model is Continental O-470 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 | 8 |
|---|---|
| 1983 | 7 |
| 1984 | 8 |
| 1985 | 5 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 7 |
| 1989 | 8 |
| 1990 | 8 |
| 1991 | 10 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 5 |
| 1996 | 7 |
| 1997 | 6 |
| 1998 | 7 |
| 1999 | 5 |
| 2000 | 9 |
| 2001 | 6 |
| 2002 | 11 |
| 2003 | 5 |
| 2004 | 9 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 6 |
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\") = 2000
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026')
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") = 2000
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026')
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 NYC01LA049Accident · No injuriesLimited investigationFinal reportCessna 182J · College Park, MDThe pilot's inadequate flare, which resulted in a hard landing. A factor related to the accident was the downdraft wind conditions.NTSB NYC01LA041Accident · No injuriesLimited investigationFinal reportCessna 182Q · Blacksburg, VAThe pilot's improper flare while landing.NTSB LAX01LA037Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Tucson, AZThe pilot's misjudged landing flare and improper recovery from the bounced landing resulting in the overload failure of the nose gear and the airplane nosing over.NTSB MIA00LA254Accident · No injuriesLimited investigationFinal reportBeech D-45 · Jacksonville, FLthe pilot's improper landing flare which resulted the right wing dropping and impacting the runway.NTSB LAX00LA357Accident · No injuriesLimited investigationFinal reportCessna 182G · Fallon, NVA hard landing by a pilot of a previous flight. Additional causes of the accident were an undershoot that resulted in a hard landing, and the CFI's failure to adequately supervise the flight.NTSB DEN00LA138Accident · No injuriesLimited investigationFinal reportCessna 182P · Broomfield, COThe pilot's inaccurate recovery from a bounced landing. Factors were lack of total pilot experience and lack of pilot experience in aircraft make and model.NTSB SEA00TA138Accident · No injuriesFinal reportCessna 182R · John Day, ORThe pilot's improper flare on touchdown resulting in a hard landing. A factor was the pilot's entrance into an inadvertent porpoise condition.NTSB LAX00TA269Accident · No injuriesFinal reportCessna 182Q · So. Lake Tahoe, CAfailure of the pilot to maintain an adequate airspeed margin resulting in a stall and hard landing.NTSB CHI00LA077Accident · No injuriesLimited investigationFinal reportCessna 182J · Stanley, NDthe pilot's improperly performed flare.